From ddlutilslopezlauren@example.net Wed Jan 11 13:59:57 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 32860 invoked from network); 11 Jan 2006 13:59:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 11 Jan 2006 13:59:56 -0000 Received: (qmail 43042 invoked by uid 500); 11 Jan 2006 13:59:55 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 42987 invoked by uid 500); 11 Jan 2006 13:59:55 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 42976 invoked by uid 99); 11 Jan 2006 13:59:54 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jan 2006 05:59:54 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO hera.med.yale.edu) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jan 2006 05:59:54 -0800 Received: from [83.161.120.155] (moussaka.med.yale.edu [83.161.120.155]) by email.med.yale.edu (PMDF V6.2-X17 #31085) with ESMTPS id <lopezlauren@example.net> for lopezlauren@example.net; Wed, 11 Jan 2006 08:59:32 -0500 (EST) Date: Wed, 11 Jan 2006 08:57:40 -0500 From: Mark Shifman <lopezlauren@example.net> Subject: Problem reading model from live database To: lopezlauren@example.net Message-id: <lopezlauren@example.net> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi: I just started playing with ddlutils and I was trying to read a live database and write the structure to a file (hopefully as sql to avoid dbartisan). 1. the example from api-usage.html didn't work in my hands since platform.readModelFromDatabase(); was not defined in version from yesterday. 2. I tried (actually with a bunch of different readModelFromDatabase's) public static void writemodel (DataSource dataSource, String filename) throws Exception { Platform platform = PlatformFactory.createNewPlatformInstance(dataSource); Database db =platform.readModelFromDatabase(null,null,null,new String[] {}); new DatabaseIO().write( db ,filename); } and got org.apache.ddlutils.DynaSqlException: java.sql.SQLException: ORA-00911: invalid character The full stack trace is below. My database is Oracle 9. What am I doing wrong? I must be missing something quite basic. thanks in advance mas org.apache.ddlutils.DynaSqlException: java.sql.SQLException: ORA-00911: invalid lopezlauren@example.net(PlatformImplBase.java:1472) at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1454) at org.ycmi.ypedDLL.getDLL.writemodel(getDLL.java:39) at org.ycmi.ypedDLL.getDLL.main(getDLL.java:24) Caused by: java.sql.SQLException: ORA-00911: invalid lopezlauren@example.net(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2877) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:858) at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3671) at org.apache.ddlutils.platform.DatabaseMetaDataWrapper.getIndices(DatabaseMetaDataWrapper.java:190) at org.apache.ddlutils.platform.JdbcModelReader.readIndices(JdbcModelReader.java:840) at org.apache.ddlutils.platform.JdbcModelReader.readTable(JdbcModelReader.java:502) at org.apache.ddlutils.platform.JdbcModelReader.readTables(JdbcModelReader.java:460) at org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:423) at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1465) ... 3 more -- Mark Shifman MD. Ph.D. Yale Center for Medical Informatics Phone 646.665.3509 lopezlauren@example.net From ddlutilslopezlauren@example.net Wed Jan 11 16:27:26 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 69362 invoked from network); 11 Jan 2006 16:27:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 11 Jan 2006 16:27:26 -0000 Received: (qmail 44925 invoked by uid 500); 11 Jan 2006 16:27:26 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 44903 invoked by uid 500); 11 Jan 2006 16:27:25 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 44888 invoked by uid 99); 11 Jan 2006 16:27:25 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jan 2006 08:27:25 -0800 X-ASF-Spam-Status: No, hits=1.3 required=10.0 tests=RCVD_IN_BL_SPAMCOP_NET,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of lopezlauren@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO nproxy.gmail.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jan 2006 08:27:24 -0800 Received: by nproxy.gmail.com with SMTP id d4so43796nfe for <lopezlauren@example.net>; Wed, 11 Jan 2006 08:27:02 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=HRCf24yiF/KRyl98hCkkpKrO36g4jvB2AFDCILFRvVELG1YFSTBciNYLdvgJDfBUVHWl6iG5eZ50ZzZLHk16BNm9yn16q5JZd/zHpiOlbn9wuAjtWjMYjSr5a+wDF16Gi0JG0U0+UQpBmJetQLM8g3kPN9wTBBR6dkd+6bDFGzU= Received: by 83.161.120.155 with SMTP id l8mr57962nfj; Wed, 11 Jan 2006 08:27:02 -0800 (PST) Received: by 83.161.120.155 with HTTP; Wed, 11 Jan 2006 08:27:02 -0800 (PST) Message-ID: <lopezlauren@example.net> Date: Wed, 11 Jan 2006 17:27:02 +0100 From: Thomas Dudziak <lopezlauren@example.net> To: lopezlauren@example.net Subject: Re: Problem reading model from live database In-Reply-To: <lopezlauren@example.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <lopezlauren@example.net> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On 1/11/06, Mark Shifman <lopezlauren@example.net> wrote: > I just started playing with ddlutils and I was trying to read a live > database > and write the structure to a file (hopefully as sql to avoid dbartisan). > 1. the example from api-usage.html didn't work in my hands since > > platform.readModelFromDatabase(); was not defined in version from yesterd= ay. Yes, that's because the reading of models from the database is currently work in progress as we test it against the different databases. Currently tested and working are: HsqlDb, McKoi, Derby, PostgreSql, MySql 4 & 5. Testing is in progress for the bigger ones (those which are more difficult to setup): Oracle, Db2, MaxDb, Sql Server, Sybase > 2. I tried (actually with a bunch of different readModelFromDatabase's) > > public static void writemodel (DataSource dataSource, String file= name) throws Exception > { > Platform platform =3D PlatformFactory.createNewPlatformInstan= ce(dataSource); > Database db =3Dplatform.readModelFromDatabase(null,null,null,= new String[] {}); > new DatabaseIO().write( db ,filename); > } > and got org.apache.ddlutils.DynaSqlException: java.sql.SQLException: ORA-= 00911: invalid character > The full stack trace is below. > My database is Oracle 9. You should use the readModelFromDatabase(String) method where the single argument is the name of the resulting database model (has nothing to do with the live database). Oracle databases are not fully tested yet, I wanted to do that sometime this week (probably weekend). For playing around and getting familiar with DdlUtils, you could in the meantime use an embedded database (e.g. Derby). Tom From ddlutilslopezlauren@example.net Wed Jan 11 22:13:09 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 6510 invoked from network); 11 Jan 2006 22:13:09 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 11 Jan 2006 22:13:09 -0000 Received: (qmail 49109 invoked by uid 500); 11 Jan 2006 22:13:09 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 49086 invoked by uid 500); 11 Jan 2006 22:13:08 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 49075 invoked by uid 99); 11 Jan 2006 22:13:08 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jan 2006 14:13:08 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO roc.holo.8d.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jan 2006 14:13:07 -0800 Received: from base.8d.com ([83.161.120.155] helo=[83.161.120.155]) by roc.holo.8d.com with asmtp (TLS-1.0:DHE_RSA_AES_128_CBC_SHA:16) (Exim 4.34) id 1EwoCw-0003gG-L0 for lopezlauren@example.net; Wed, 11 Jan 2006 17:12:46 -0500 Message-ID: <lopezlauren@example.net> Date: Wed, 11 Jan 2006 17:13:09 -0500 From: Laurent Sacaut <lopezlauren@example.net> User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: lopezlauren@example.net Subject: NullPointerException when trying to use SqlBuilder.alterDatabase X-Enigmail-Version: 83.161.120.155 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Spam-Roc-Score: -4.8 X-Spam-Roc-Level: ---- X-Spam-Roc-Report: -4.8 points, 5.0 required autolearn=ham -4.9 BAYES_00 BODY: Bayesian spam probability is 0 to 1% [score: 0.0000] 0.1 AWL AWL: Auto-whitelist adjustment X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hello, I am getting familiarized with DdlUtils using a MySQL 4.1x database. I am trying to alter an existing database so that new tables are created and new columns are added to existing tables. I am using the changeDatabase(..) as shown in the API usage example. I keep getting an error at some point. I traced the code and found out that it happens when SqlBuilder.alterDatabase(Database currentModel, Database desiredModel, CreationParameters params, boolean doDrops, boolean modifyColumns) is called, more specifically when params is null (which it is in my case). I narrowed it down to the createTable(desiredModel, desiredTable, params.getParametersFor(desiredTable)) call in that function. It does not go in, I guess because of the null params but I could be wrong. It jumps out with the following message: java.lang.NullPointerException. there is no more details about the exception. Is there a way around this or some settings I missed? thx. Laurent From ddlutilslopezlauren@example.net Wed Jan 11 22:33:38 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 17327 invoked from network); 11 Jan 2006 22:33:38 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 11 Jan 2006 22:33:38 -0000 Received: (qmail 1062 invoked by uid 500); 11 Jan 2006 22:33:37 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 1049 invoked by uid 500); 11 Jan 2006 22:33:37 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 1037 invoked by uid 99); 11 Jan 2006 22:33:37 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jan 2006 14:33:37 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of lopezlauren@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO nproxy.gmail.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jan 2006 14:33:37 -0800 Received: by nproxy.gmail.com with SMTP id g2so74886nfe for <lopezlauren@example.net>; Wed, 11 Jan 2006 14:32:42 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=H9Q3+r04rQSJAVdJAuwg91ClhmnmGTtXTxZwJPDelfyqTSX1UG0XLIiu3OpsuQhtJpj/5RiGGH1USNLh/Ju3ZTU48ky8+Oy0hUzZJwjk+wzJ3veNPQzMxPigN4XaCK14R8nIf40tzlyZsXJ9fdSXuvjPLOV+hnNYYYddc4O7k3E= Received: by 83.161.120.155 with SMTP id o6mr84898nfi; Wed, 11 Jan 2006 14:32:41 -0800 (PST) Received: by 83.161.120.155 with HTTP; Wed, 11 Jan 2006 14:32:41 -0800 (PST) Message-ID: <lopezlauren@example.net> Date: Wed, 11 Jan 2006 23:32:41 +0100 From: Thomas Dudziak <lopezlauren@example.net> To: lopezlauren@example.net Subject: Re: NullPointerException when trying to use SqlBuilder.alterDatabase In-Reply-To: <lopezlauren@example.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <lopezlauren@example.net> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Please try the SVN trunk again, I've committed a fix. Tom From ddlutilslopezlauren@example.net Thu Jan 12 00:34:49 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 65859 invoked from network); 12 Jan 2006 00:34:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 12 Jan 2006 00:34:48 -0000 Received: (qmail 5410 invoked by uid 500); 12 Jan 2006 00:34:48 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 5371 invoked by uid 500); 12 Jan 2006 00:34:47 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 5317 invoked by uid 99); 12 Jan 2006 00:34:46 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jan 2006 16:34:46 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of lopezlauren@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO nproxy.gmail.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jan 2006 16:34:44 -0800 Received: by nproxy.gmail.com with SMTP id y38so210156nfb for <lopezlauren@example.net>; Wed, 11 Jan 2006 16:34:22 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=CS3KUML9NUcovBNJgxQILIWjCvfG5JyyDVMMAy8BNUtWVuy3iCKwCDAB3t06qV00lbU4XjLWvqGKSfPE3ASI2zL7a4yA/szQEjCA0HdhGEw5ou32DRGstlMFvBek83LKFO+Qvzw3Zvw3gmgzr+97cizmBwwNSgeQHWgU1NRkmLo= Received: by 83.161.120.155 with SMTP id l11mr83434nfj; Wed, 11 Jan 2006 14:25:06 -0800 (PST) Received: by 83.161.120.155 with HTTP; Wed, 11 Jan 2006 14:25:06 -0800 (PST) Message-ID: <lopezlauren@example.net> Date: Wed, 11 Jan 2006 23:25:06 +0100 From: Thomas Dudziak <lopezlauren@example.net> To: lopezlauren@example.net Subject: Re: NullPointerException when trying to use SqlBuilder.alterDatabase In-Reply-To: <lopezlauren@example.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <lopezlauren@example.net> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On 1/11/06, Laurent Sacaut <lopezlauren@example.net> wrote: > I am getting familiarized with DdlUtils using a MySQL 4.1x database. I > am trying to alter an existing database so that new tables are created > and new columns are added to existing tables. > I am using the changeDatabase(..) as shown in the API usage example. I > keep getting an error at some point. > > I traced the code and found out that it happens when > SqlBuilder.alterDatabase(Database currentModel, Database desiredModel, > CreationParameters params, boolean doDrops, boolean modifyColumns) is > called, more specifically when params is null (which it is in my case). > > I narrowed it down to the createTable(desiredModel, desiredTable, > params.getParametersFor(desiredTable)) call in that function. It does > not go in, I guess because of the null params but I could be wrong. It > jumps out with the following message: java.lang.NullPointerException. > there is no more details about the exception. I think you're right, this is a bug. I'll fix it ASAP. Tom From ddlutilslopezlauren@example.net Thu Jan 12 20:30:33 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 49674 invoked from network); 12 Jan 2006 20:30:33 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 12 Jan 2006 20:30:33 -0000 Received: (qmail 15848 invoked by uid 500); 12 Jan 2006 20:30:32 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 15833 invoked by uid 500); 12 Jan 2006 20:30:32 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 15820 invoked by uid 99); 12 Jan 2006 20:30:31 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jan 2006 12:30:31 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO roc.holo.8d.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jan 2006 12:30:30 -0800 Received: from base.8d.com ([83.161.120.155] helo=[83.161.120.155]) by roc.holo.8d.com with asmtp (TLS-1.0:DHE_RSA_AES_128_CBC_SHA:16) (Exim 4.34) id 1Ex95A-0007EX-CU for lopezlauren@example.net; Thu, 12 Jan 2006 15:30:08 -0500 Message-ID: <lopezlauren@example.net> Date: Thu, 12 Jan 2006 15:30:28 -0500 From: Laurent Sacaut <lopezlauren@example.net> User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: lopezlauren@example.net Subject: Re: NullPointerException when trying to use SqlBuilder.alterDatabase References: <lopezlauren@example.net> <lopezlauren@example.net> In-Reply-To: <lopezlauren@example.net> X-Enigmail-Version: 83.161.120.155 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Spam-Roc-Score: -4.8 X-Spam-Roc-Level: ---- X-Spam-Roc-Report: -4.8 points, 5.0 required autolearn=ham -4.9 BAYES_00 BODY: Bayesian spam probability is 0 to 1% [score: 0.0000] 0.1 AWL AWL: Auto-whitelist adjustment X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Resolved That worked well. Thank for the quick fix. You rock :) Laurent Thomas Dudziak wrote: >Please try the SVN trunk again, I've committed a fix. > >Tom > > > From ddlutilslopezlauren@example.net Fri Jan 13 14:10:24 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 75366 invoked from network); 13 Jan 2006 14:10:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 13 Jan 2006 14:10:18 -0000 Received: (qmail 85709 invoked by uid 500); 13 Jan 2006 14:09:51 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 85626 invoked by uid 500); 13 Jan 2006 14:09:51 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 85535 invoked by uid 99); 13 Jan 2006 14:09:50 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jan 2006 06:09:50 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of lopezlauren@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO mail.oles.biz) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jan 2006 06:09:47 -0800 Received: from localhost (localhost.localdomain [83.161.120.155]) by mail.oles.biz (Postfix) with ESMTP id D2472846F for <lopezlauren@example.net>; Fri, 13 Jan 2006 16:49:16 +0200 (EET) Received: from mail.oles.biz ([83.161.120.155]) by localhost (oles.biz [83.161.120.155]) (amavisd-new, port 10024) with ESMTP id 07456-10 for <lopezlauren@example.net>; Fri, 13 Jan 2006 16:49:14 +0200 (EET) Received: from [83.161.120.155] (j2.oles.biz [83.161.120.155]) by mail.oles.biz (Postfix) with ESMTP id BBB151026 for <lopezlauren@example.net>; Fri, 13 Jan 2006 16:49:14 +0200 (EET) Message-ID: <lopezlauren@example.net> Date: Fri, 13 Jan 2006 16:15:14 +0200 From: Georgi Naplatanov <lopezlauren@example.net> User-Agent: Debian Thunderbird 1.0.7 (X11/20051017) X-Accept-Language: en-us, en MIME-Version: 1.0 To: lopezlauren@example.net Subject: too many waiting objects Content-Type: multipart/mixed; boundary="------------050703040201040206040207" X-Virus-Scanned: Debian lopezlauren@example.net X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N --------------050703040201040206040207 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Hello, ddlutils is a great tool, i try to migrate hsqldb database to apache derby and i have synchronization problem with autogenerated keys from the old (source) db and new values from the new db (target db - derby). Lets say we hawe one row from the parent table parent table - old db pk autoincrement - id = 35 parent table- new db pk autoincrement - id = 2 In this case ddlutils can't insert rows to the tables wich has fk from parent tables because id value was changed from 35 to 2. For apache derby i use attached pach for lastInsertedId implementation Regards --------------050703040201040206040207 Content-Type: text/plain; name="derby.patch" Content-Transfer-Encoding: base64 Content-Disposition: inline; filename="derby.patch" ZGlmZiAtdXJOIGRkbHV0aWxzL3NyYy9qYXZhL29yZy9hcGFjaGUvZGRsdXRpbHMvcGxhdGZv cm0vZGVyYnkvRGVyYnlCdWlsZGVyLmphdmEgZGRsdXRpbHMtbW9kaWZpZWQvc3JjL2phdmEv b3JnL2FwYWNoZS9kZGx1dGlscy9wbGF0Zm9ybS9kZXJieS9EZXJieUJ1aWxkZXIuamF2YQot LS0gZGRsdXRpbHMvc3JjL2phdmEvb3JnL2FwYWNoZS9kZGx1dGlscy9wbGF0Zm9ybS9kZXJi eS9EZXJieUJ1aWxkZXIuamF2YQkyMDA2LTAxLTEzIDE1OjE3OjI3LjAwMDAwMDAwMCArMDIw MAorKysgZGRsdXRpbHMtbW9kaWZpZWQvc3JjL2phdmEvb3JnL2FwYWNoZS9kZGx1dGlscy9w bGF0Zm9ybS9kZXJieS9EZXJieUJ1aWxkZXIuamF2YQkyMDA2LTAxLTEzIDE1OjE5OjE5LjAw MDAwMDAwMCArMDIwMApAQCAtNjYsNCArNjYsMTQgQEAKICAgICB7DQogICAgICAgICBwcmlu dCgiR0VORVJBVEVEIEJZIERFRkFVTFQgQVMgSURFTlRJVFkiKTsNCiAgICAgfQ0KKw0KKyAg ICAvKioNCisgICAgICoge0Bpbmhlcml0RG9jfQ0KKyAgICAgKi8NCisgICAgcHVibGljIFN0 cmluZyBnZXRTZWxlY3RMYXN0SW5zZXJ0SWQoVGFibGUgdGFibGUpDQorICAgIHsNCisJLy8g c3VwcG9zZWQgb25lIGF1dG9pbmNyZW1lbnQgZmlsZWQgcGVyIHRhYmxlDQorICAgICAgICBy ZXR1cm4gICJzZWxlY3QgKHNjLmF1dG9pbmNyZW1lbnR2YWx1ZS0xKSBsYXN0aWQgZnJvbSBz eXMuc3lzdGFibGVzIHN0LCBzeXMuc3lzY29sdW1ucyBzYyB3aGVyZSBzdC50YWJsZW5hbWU9 ICciK3RhYmxlLmdldE5hbWUoKSsiJyBhbmQgc3QudGFibGVpZD1zYy5yZWZlcmVuY2VpZCBh bmQgc2MuYXV0b2luY3JlbWVudHZhbHVlIGlzIG5vdCBudWxsICIgOw0KKwkNCisgICAgfQ0K IH0NCmRpZmYgLXVyTiBkZGx1dGlscy9zcmMvamF2YS9vcmcvYXBhY2hlL2RkbHV0aWxzL3Bs YXRmb3JtL1BsYXRmb3JtSW1wbEJhc2UuamF2YSBkZGx1dGlscy1tb2RpZmllZC9zcmMvamF2 YS9vcmcvYXBhY2hlL2RkbHV0aWxzL3BsYXRmb3JtL1BsYXRmb3JtSW1wbEJhc2UuamF2YQot LS0gZGRsdXRpbHMvc3JjL2phdmEvb3JnL2FwYWNoZS9kZGx1dGlscy9wbGF0Zm9ybS9QbGF0 Zm9ybUltcGxCYXNlLmphdmEJMjAwNi0wMS0xMyAxNToxNzoyOS4wMDAwMDAwMDAgKzAyMDAK KysrIGRkbHV0aWxzLW1vZGlmaWVkL3NyYy9qYXZhL29yZy9hcGFjaGUvZGRsdXRpbHMvcGxh dGZvcm0vUGxhdGZvcm1JbXBsQmFzZS5qYXZhCTIwMDYtMDEtMTMgMTU6MzU6NDcuMDAwMDAw MDAwICswMjAwCkBAIC05ODEsOSArOTgxLDkgQEAKIA0KICAgICAgICAgICAgICAgICBsYXN0 SW5zZXJ0ZWRJZHMubmV4dCgpOw0KIA0KLSAgICAgICAgICAgICAgICBmb3IgKGludCBpZHgg PSAwOyBpZHggPCBhdXRvSW5jckNvbHVtbnMubGVuZ3RoOyBpZHgrKykNCisgICAgICAgICAg ICAgICAgZm9yIChpbnQgaWR4ID0gMTsgaWR4IDw9IGF1dG9JbmNyQ29sdW1ucy5sZW5ndGg7 IGlkeCsrKQ0KICAgICAgICAgICAgICAgICB7DQotICAgICAgICAgICAgICAgICAgICBPYmpl Y3QgdmFsdWUgPSBsYXN0SW5zZXJ0ZWRJZHMuZ2V0T2JqZWN0KGF1dG9JbmNyQ29sdW1uc1tp ZHhdLmdldE5hbWUoKSk7DQorICAgICAgICAgICAgICAgICAgICBPYmplY3QgdmFsdWUgPSBs YXN0SW5zZXJ0ZWRJZHMuZ2V0T2JqZWN0KGlkeCk7DQogICAgIA0KICAgICAgICAgICAgICAg ICAgICAgUHJvcGVydHlVdGlscy5zZXRQcm9wZXJ0eShkeW5hQmVhbiwgYXV0b0luY3JDb2x1 bW5zW2lkeF0uZ2V0TmFtZSgpLCB2YWx1ZSk7DQogICAgICAgICAgICAgICAgIH0NCg== --------------050703040201040206040207-- From ddlutilslopezlauren@example.net Fri Jan 20 14:04:50 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 70661 invoked from network); 20 Jan 2006 14:04:47 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 20 Jan 2006 14:04:47 -0000 Received: (qmail 73749 invoked by uid 500); 20 Jan 2006 14:04:09 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 73647 invoked by uid 500); 20 Jan 2006 14:04:09 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 73587 invoked by uid 99); 20 Jan 2006 14:04:08 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Jan 2006 06:04:08 -0800 X-ASF-Spam-Status: No, hits=1.3 required=10.0 tests=RCVD_IN_BL_SPAMCOP_NET,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of lopezlauren@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO uproxy.gmail.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Jan 2006 06:01:51 -0800 Received: by uproxy.gmail.com with SMTP id o2so325319uge for <lopezlauren@example.net>; Fri, 20 Jan 2006 06:01:30 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=j7s8IBWf4MdEx2uxIt7FhPVaG8DKUwXmi7lg/oVk6MA8n0x++kvx+eMQWyhL0Dfy87QWX8mT1BXltqCKcZzo6X8AEYVEzpqkcsQ6l+H2hPThqBKRWfoH8qFnz308i0zAGVfyS2DwzPWKBM+z99FguwRsn4eqmoGez4HqCIk+opk= Received: by 83.161.120.155 with SMTP id i6mr141854nfh; Fri, 20 Jan 2006 06:01:29 -0800 (PST) Received: by 83.161.120.155 with HTTP; Fri, 20 Jan 2006 06:01:29 -0800 (PST) Message-ID: <lopezlauren@example.net> Date: Fri, 20 Jan 2006 15:01:29 +0100 From: Philip Mark Donaghy <lopezlauren@example.net> To: lopezlauren@example.net Subject: Which driver to use for ms-sql MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I have opportunity to give ddlutils a try with ms-sql. I found two different drivers. http://jtds.sourceforge.net/ and The ms driver obtained by going through the ms channels. Anyone ever compared the drivers? What's you preference? -- Philip Donaghy donaghy.blogspot.com del.icio.us/donaghy/philip Skype: philipmarkdonaghy Office: 646.665.3509 Mobile: 646.665.3509 From ddlutilslopezlauren@example.net Fri Jan 20 14:17:01 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 82404 invoked from network); 20 Jan 2006 14:17:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 20 Jan 2006 14:17:01 -0000 Received: (qmail 10024 invoked by uid 500); 20 Jan 2006 14:17:00 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 9994 invoked by uid 500); 20 Jan 2006 14:17:00 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 9983 invoked by uid 99); 20 Jan 2006 14:17:00 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Jan 2006 06:17:00 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO mailin.phonecoop.coop) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Jan 2006 06:16:58 -0800 Received: from [83.161.120.155] (port=2059 helo=[83.161.120.155]) by mailin.phonecoop.coop with esmtp (Exim 4.50) id 1Ezx44-00027f-Ak for lopezlauren@example.net; Fri, 20 Jan 2006 14:16:33 +0000 Message-ID: <lopezlauren@example.net> Date: Fri, 20 Jan 2006 14:16:24 +0000 From: Dave Sunerton-Burl <lopezlauren@example.net> Reply-To: lopezlauren@example.net Organization: Lledr Solutions User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: lopezlauren@example.net Subject: Re: Which driver to use for ms-sql References: <lopezlauren@example.net> In-Reply-To: <lopezlauren@example.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus-Scanned: Clean X-Spam-Score: 0.0 (/) X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Philip Mark Donaghy wrote: > I have opportunity to give ddlutils a try with ms-sql. I found two > different drivers. > > http://jtds.sourceforge.net/ > > and > > The ms driver obtained by going through the ms channels. > > Anyone ever compared the drivers? What's you preference? I've always found the jtds driver gives much better performance. Plus it's open source, which is always a plus! -- Dave Sunerton-Burl Lledr Solutions Email : lopezlauren@example.net Phone : 646.665.3509 Web : www.lledr-solutions.com From ddlutilslopezlauren@example.net Fri Jan 20 14:19:09 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 83369 invoked from network); 20 Jan 2006 14:19:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 20 Jan 2006 14:19:07 -0000 Received: (qmail 13154 invoked by uid 500); 20 Jan 2006 14:19:04 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 13137 invoked by uid 500); 20 Jan 2006 14:19:04 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 13124 invoked by uid 99); 20 Jan 2006 14:19:04 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Jan 2006 06:19:04 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO mvdb.net) (83.161.120.155) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 20 Jan 2006 06:19:03 -0800 Received: (qmail 10778 invoked from network); 20 Jan 2006 14:18:41 -0000 Received: from unknown (HELO [83.161.120.155]) (83.161.120.155) by 83.161.120.155 with SMTP; Fri, 20 Jan 2006 14:18:41 +0000 Message-ID: <lopezlauren@example.net> Date: Fri, 20 Jan 2006 15:19:02 +0100 From: Martin van den Bemt <lopezlauren@example.net> User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: lopezlauren@example.net Subject: Re: Which driver to use for ms-sql References: <lopezlauren@example.net> In-Reply-To: <lopezlauren@example.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi Philip, Ignoring the fact that MS just released a completely new driver (see http://www.microsoft.com/downloads/details.aspx?FamilyID=e22bc83b-32ff-4474-a44a-22b6ae2c4e17&displaylang=en) Jtds is far superiour :) Afaik the new driver is a complete rewrite my MS itself (the old driver was not written my MS itself, if I understood that correctly). Just one warning : we dind't get around to test/fix ddlutils for usage with sqlserver 2000 and 2005 after the refactor. It's on my todo list though (with a bit of luck next weekend) Mvgr, Martin Philip Mark Donaghy wrote: > I have opportunity to give ddlutils a try with ms-sql. I found two > different drivers. > > http://jtds.sourceforge.net/ > > and > > The ms driver obtained by going through the ms channels. > > Anyone ever compared the drivers? What's you preference? > > -- > Philip Donaghy > donaghy.blogspot.com del.icio.us/donaghy/philip > Skype: philipmarkdonaghy > Office: 646.665.3509 > Mobile: 646.665.3509 > > From ddlutilslopezlauren@example.net Fri Jan 20 14:33:30 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 98246 invoked from network); 20 Jan 2006 14:33:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 20 Jan 2006 14:33:29 -0000 Received: (qmail 33080 invoked by uid 500); 20 Jan 2006 14:33:16 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 33049 invoked by uid 500); 20 Jan 2006 14:33:16 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 33026 invoked by uid 99); 20 Jan 2006 14:33:16 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Jan 2006 06:33:16 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of lopezlauren@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO uproxy.gmail.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Jan 2006 06:33:15 -0800 Received: by uproxy.gmail.com with SMTP id o2so336688uge for <lopezlauren@example.net>; Fri, 20 Jan 2006 06:32:54 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Aa84aUzejPC+CSXca7cCon5DS0V5+22NthuBbkx3+Tx6m6vSZmKKL8S9xLjbtsBJCBwONInQp8foes30YLG+NEMm0Liw9dScyq/MIAEe6ZWEL/0IfUujD3UA5QMIdESm1xHTsJzi3RVI0WkXQq9YQbtPLrHBJ+TG6tx+NdHowHs= Received: by 83.161.120.155 with SMTP id m5mr144257nfh; Fri, 20 Jan 2006 06:32:54 -0800 (PST) Received: by 83.161.120.155 with HTTP; Fri, 20 Jan 2006 06:32:53 -0800 (PST) Message-ID: <lopezlauren@example.net> Date: Fri, 20 Jan 2006 15:32:53 +0100 From: Philip Mark Donaghy <lopezlauren@example.net> To: lopezlauren@example.net Subject: Re: Which driver to use for ms-sql In-Reply-To: <lopezlauren@example.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <lopezlauren@example.net> <lopezlauren@example.net> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Everything went well with a test database using derby. I have a few comments and improvements to the docs. I just copied and pasted some stuff from the docs to get started. It would be nice if the sample schema in the docs had the xml header and the <database> tag. And the example ant targets define runtime.classpath yet refer to it as runtime_classpath. These are just details but users appreciate when this works the first time. On 1/20/06, Martin van den Bemt <lopezlauren@example.net> wrote: > Hi Philip, > > Ignoring the fact that MS just released a completely new driver (see > http://www.microsoft.com/downloads/details.aspx?FamilyID=3De22bc83b-32ff-= 4474-a44a-22b6ae2c4e17&displaylang=3Den) > Jtds is far superiour :) > Afaik the new driver is a complete rewrite my MS itself (the old driver w= as not written my MS > itself, if I understood that correctly). > > Just one warning : we dind't get around to test/fix ddlutils for usage wi= th sqlserver 2000 and 2005 > after the refactor. I'm going to try ms-sql next. Ok, I'll try it and if it doesn't work I'll edit the ddl by hand from the derby ddl. > > It's on my todo list though (with a bit of luck next weekend) > > Mvgr, > Martin > > Philip Mark Donaghy wrote: > > I have opportunity to give ddlutils a try with ms-sql. I found two > > different drivers. > > > > http://jtds.sourceforge.net/ > > > > and > > > > The ms driver obtained by going through the ms channels. > > > > Anyone ever compared the drivers? What's you preference? > > > > -- > > Philip Donaghy > > donaghy.blogspot.com del.icio.us/donaghy/philip > > Skype: philipmarkdonaghy > > Office: 646.665.3509 > > Mobile: 646.665.3509 > > > > > -- Philip Donaghy donaghy.blogspot.com del.icio.us/donaghy/philip Skype: philipmarkdonaghy Office: 646.665.3509 Mobile: 646.665.3509 From ddlutilslopezlauren@example.net Fri Jan 20 14:55:46 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 14199 invoked from network); 20 Jan 2006 14:55:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 20 Jan 2006 14:55:46 -0000 Received: (qmail 81404 invoked by uid 500); 20 Jan 2006 14:55:46 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 81392 invoked by uid 500); 20 Jan 2006 14:55:46 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 81376 invoked by uid 99); 20 Jan 2006 14:55:46 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Jan 2006 06:55:45 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO mvdb.net) (83.161.120.155) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 20 Jan 2006 06:55:45 -0800 Received: (qmail 6927 invoked from network); 20 Jan 2006 14:55:24 -0000 Received: from unknown (HELO [83.161.120.155]) (83.161.120.155) by 83.161.120.155 with SMTP; Fri, 20 Jan 2006 14:55:24 +0000 Message-ID: <lopezlauren@example.net> Date: Fri, 20 Jan 2006 15:55:45 +0100 From: Martin van den Bemt <lopezlauren@example.net> User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: lopezlauren@example.net Subject: Re: Which driver to use for ms-sql References: <lopezlauren@example.net> <lopezlauren@example.net> <lopezlauren@example.net> In-Reply-To: <lopezlauren@example.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Philip Mark Donaghy wrote: > Everything went well with a test database using derby. Derby should work indeed. I have a few > comments and improvements to the docs. I just copied and pasted some > stuff from the docs to get started. It would be nice if the sample > schema in the docs had the xml header and the <database> tag. > > And the example ant targets define runtime.classpath yet refer to it > as runtime_classpath. Both are fixed, though not deployed to the website.. > > These are just details but users appreciate when this works the first time. In all honesty I really haven't looked to closely at the docs yet, but it is goign to be adressed before the 1.0 release (and after all the coding and testing that still needs to done). Any patches to the documentation are welcome though! Mvgr, Martin From ddlutilslopezlauren@example.net Fri Jan 20 15:06:47 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 20224 invoked from network); 20 Jan 2006 15:06:45 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 20 Jan 2006 15:06:45 -0000 Received: (qmail 99673 invoked by uid 500); 20 Jan 2006 15:06:30 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 99202 invoked by uid 500); 20 Jan 2006 15:06:27 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 98984 invoked by uid 99); 20 Jan 2006 15:06:24 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Jan 2006 07:06:24 -0800 X-ASF-Spam-Status: No, hits=1.3 required=10.0 tests=RCVD_IN_BL_SPAMCOP_NET,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of lopezlauren@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO uproxy.gmail.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Jan 2006 07:05:24 -0800 Received: by uproxy.gmail.com with SMTP id o2so9736uge for <lopezlauren@example.net>; Fri, 20 Jan 2006 07:05:03 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=MnIKbUgcvWCCgqBAcuWKMzKcKZXqeTL+XmhXVCB4E2QpgV+Q9utCbarizRP5gyJKWglbaxe77eKKBrqxgjGXSRqJtLJdHSVBaj/ZF3D4EPptsrGAwtcR5JW5dHWgucnqHc+BFm2NfdXN98cPl8PyU+EatNquC+Q4M1rzM/kr7UM= Received: by 83.161.120.155 with SMTP id f12mr142251nfe; Fri, 20 Jan 2006 07:05:03 -0800 (PST) Received: by 83.161.120.155 with HTTP; Fri, 20 Jan 2006 07:05:03 -0800 (PST) Message-ID: <lopezlauren@example.net> Date: Fri, 20 Jan 2006 16:05:03 +0100 From: Philip Mark Donaghy <lopezlauren@example.net> To: lopezlauren@example.net Subject: How do I obtain the ddl to dreate the database. MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I am trying to obtain a file that has the create table statements. I use ddlToDatabase in the following way, <createDatabase/> <writeSchemaToDatabase/> <writeSchemaSqlToFile outputFile=3D"database.ddl"/> I expected the create table statements to be in database.ddl but it contains only the table alter statements. ALTER TABLE "book" ADD CONSTRAINT "book_FK_author_id_author" FOREIGN KEY ("author_id") REFERENCES "author" ("author_id"); ALTER TABLE "book" DROP CONSTRAINT "book_FK_author_id_author"; Am I missing something? -- Philip Donaghy donaghy.blogspot.com del.icio.us/donaghy/philip Skype: philipmarkdonaghy Office: 646.665.3509 Mobile: 646.665.3509 From ddlutilslopezlauren@example.net Fri Jan 20 15:27:31 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 32004 invoked from network); 20 Jan 2006 15:27:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 20 Jan 2006 15:27:31 -0000 Received: (qmail 34399 invoked by uid 500); 20 Jan 2006 15:27:19 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 33922 invoked by uid 500); 20 Jan 2006 15:27:12 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 33879 invoked by uid 99); 20 Jan 2006 15:27:11 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Jan 2006 07:27:11 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO mvdb.net) (83.161.120.155) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 20 Jan 2006 07:20:59 -0800 Received: (qmail 24101 invoked from network); 20 Jan 2006 15:20:38 -0000 Received: from unknown (HELO [83.161.120.155]) (83.161.120.155) by 83.161.120.155 with SMTP; Fri, 20 Jan 2006 15:20:38 +0000 Message-ID: <lopezlauren@example.net> Date: Fri, 20 Jan 2006 16:20:59 +0100 From: Martin van den Bemt <lopezlauren@example.net> User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: lopezlauren@example.net Subject: Re: How do I obtain the ddl to dreate the database. References: <lopezlauren@example.net> In-Reply-To: <lopezlauren@example.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Just from a quick look at the code (I never used the tasks before) : alterDatbase should be set to false to get the full ddl in the file. doDrops should be set to true or false depending on your needs. Afaik it will not do anything to your database. Mvgr, Martin Philip Mark Donaghy wrote: > I am trying to obtain a file that has the create table statements. > > I use ddlToDatabase in the following way, > > <createDatabase/> > <writeSchemaToDatabase/> > <writeSchemaSqlToFile outputFile="database.ddl"/> > > I expected the create table statements to be in database.ddl but it > contains only the table alter statements. > > ALTER TABLE "book" > ADD CONSTRAINT "book_FK_author_id_author" FOREIGN KEY > ("author_id") REFERENCES "author" ("author_id"); > > ALTER TABLE "book" > DROP CONSTRAINT "book_FK_author_id_author"; > > Am I missing something? > > -- > Philip Donaghy > donaghy.blogspot.com del.icio.us/donaghy/philip > Skype: philipmarkdonaghy > Office: 646.665.3509 > Mobile: 646.665.3509 > > From ddlutilslopezlauren@example.net Fri Jan 20 15:48:18 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 44522 invoked from network); 20 Jan 2006 15:48:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 20 Jan 2006 15:48:18 -0000 Received: (qmail 91455 invoked by uid 500); 20 Jan 2006 15:48:03 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 91412 invoked by uid 500); 20 Jan 2006 15:48:03 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 91380 invoked by uid 99); 20 Jan 2006 15:48:03 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Jan 2006 07:48:03 -0800 X-ASF-Spam-Status: No, hits=1.3 required=10.0 tests=RCVD_IN_BL_SPAMCOP_NET,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of lopezlauren@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO uproxy.gmail.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Jan 2006 07:48:02 -0800 Received: by uproxy.gmail.com with SMTP id o2so27241uge for <lopezlauren@example.net>; Fri, 20 Jan 2006 07:47:41 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=XT1PLdCT9OJ8qyCpWk9BVErcYLiINJS2e/l9KnlJUO1fmmwfjMeVrewaJ0sPaw/LuN/yo+E86r8KG8r3JsVpoKf9sLl9a45l77jXF5V3Wj0ke3W0bKHwZuZ3qQh2WZNMTEe3SE1FfoK0CbMLb9yHZWp7bIUdLXR2baQSK5vDPsY= Received: by 83.161.120.155 with SMTP id t11mr152947nfj; Fri, 20 Jan 2006 07:47:40 -0800 (PST) Received: by 83.161.120.155 with HTTP; Fri, 20 Jan 2006 07:47:40 -0800 (PST) Message-ID: <lopezlauren@example.net> Date: Fri, 20 Jan 2006 16:47:40 +0100 From: Philip Mark Donaghy <lopezlauren@example.net> To: lopezlauren@example.net Subject: Re: How do I obtain the ddl to dreate the database. In-Reply-To: <lopezlauren@example.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <lopezlauren@example.net> <lopezlauren@example.net> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Thanks, that works. On 1/20/06, Martin van den Bemt <lopezlauren@example.net> wrote: > Just from a quick look at the code (I never used the tasks before) : > alterDatbase should be set to false to get the full ddl in the file. doDr= ops should be set to true > or false depending on your needs. > Afaik it will not do anything to your database. > > Mvgr, > Martin > > Philip Mark Donaghy wrote: > > I am trying to obtain a file that has the create table statements. > > > > I use ddlToDatabase in the following way, > > > > <createDatabase/> > > <writeSchemaToDatabase/> > > <writeSchemaSqlToFile outputFile=3D"database.ddl"/> > > > > I expected the create table statements to be in database.ddl but it > > contains only the table alter statements. > > > > ALTER TABLE "book" > > ADD CONSTRAINT "book_FK_author_id_author" FOREIGN KEY > > ("author_id") REFERENCES "author" ("author_id"); > > > > ALTER TABLE "book" > > DROP CONSTRAINT "book_FK_author_id_author"; > > > > Am I missing something? > > > > -- > > Philip Donaghy > > donaghy.blogspot.com del.icio.us/donaghy/philip > > Skype: philipmarkdonaghy > > Office: 646.665.3509 > > Mobile: 646.665.3509 > > > > > -- Philip Donaghy donaghy.blogspot.com del.icio.us/donaghy/philip Skype: philipmarkdonaghy Office: 646.665.3509 Mobile: 646.665.3509 From ddlutilslopezlauren@example.net Sat Jan 21 14:15:47 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 50552 invoked from network); 21 Jan 2006 14:15:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 21 Jan 2006 14:15:46 -0000 Received: (qmail 54616 invoked by uid 500); 21 Jan 2006 14:15:46 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 54561 invoked by uid 500); 21 Jan 2006 14:15:46 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 54550 invoked by uid 99); 21 Jan 2006 14:15:46 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 21 Jan 2006 06:15:46 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy includes SPF lopezlauren@example.net) Received: from [83.161.120.155] (HELO smtp801.mail.ukl.yahoo.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with SMTP; Sat, 21 Jan 2006 06:15:45 -0800 Received: (qmail 7195 invoked from network); 21 Jan 2006 14:15:23 -0000 Received: from unknown (HELO ?83.161.120.155?) (lopezlauren@example.net@83.161.120.155 with plain) by smtp801.mail.ukl.yahoo.com with SMTP; 21 Jan 2006 14:15:23 -0000 Message-ID: <lopezlauren@example.net> Date: Sat, 21 Jan 2006 14:15:13 +0000 From: Tim Dudgeon <lopezlauren@example.net> User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: lopezlauren@example.net Subject: probem reading oracle database? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I'm seeting a NullPointerException when reading a model from a live Oracle database. The problem stems from reading the index information. The db is Oracle 9i and I'm reading it with platform.readModelFromDatabase("a_name", null, "MY_SCHEMA_NAME", null); Any ideas? Tim Exception in thread "main" lopezlauren@example.net(JdbcModelReader.java:893) at org.apache.ddlutils.platform.JdbcModelReader.readIndices(JdbcModelReader.java:846) at org.apache.ddlutils.platform.JdbcModelReader.readTable(JdbcModelReader.java:502) at org.apache.ddlutils.platform.JdbcModelReader.readTables(JdbcModelReader.java:460) at org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:423) at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1469) at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1458) From ddlutilslopezlauren@example.net Sat Jan 21 16:58:38 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 3092 invoked from network); 21 Jan 2006 16:58:38 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 21 Jan 2006 16:58:38 -0000 Received: (qmail 58155 invoked by uid 500); 21 Jan 2006 16:58:38 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 58139 invoked by uid 500); 21 Jan 2006 16:58:37 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 58121 invoked by uid 99); 21 Jan 2006 16:58:37 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 21 Jan 2006 08:58:37 -0800 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=BIZ_TLD,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of lopezlauren@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO uproxy.gmail.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 21 Jan 2006 08:58:36 -0800 Received: by uproxy.gmail.com with SMTP id j3so208390ugf for <lopezlauren@example.net>; Sat, 21 Jan 2006 08:58:15 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=YYCr/z79LiUE5BRsUqgHhlwORqUen5UtviFZH6WoENQcDtrlAXcY8oZ+oz3UWCu5Ibap55AJjiZpMOLc/m+0LwQT3eAKGDd+QWJeiQp2+VqbsT/u7JKLUqiyHgLQ3G7/zpH0QS89eIQwYRMBuP4BTVedRw1LGvXAMIPXTEiQD+M= Received: by 83.161.120.155 with SMTP id r19mr224691nfj; Sat, 21 Jan 2006 08:58:14 -0800 (PST) Received: by 83.161.120.155 with HTTP; Sat, 21 Jan 2006 08:58:13 -0800 (PST) Message-ID: <lopezlauren@example.net> Date: Sat, 21 Jan 2006 17:58:13 +0100 From: Thomas Dudziak <lopezlauren@example.net> To: lopezlauren@example.net Subject: Re: too many waiting objects In-Reply-To: <lopezlauren@example.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <lopezlauren@example.net> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On 1/13/06, Georgi Naplatanov <lopezlauren@example.net> wrote: > Hello, ddlutils is a great tool, > i try to migrate hsqldb database to apache derby and i have > synchronization problem with autogenerated keys from the old (source) db > and new values from the new db (target db - derby). > > Lets say we hawe one row from the parent table > > parent table - old db > pk autoincrement - id =3D 35 > > > parent table- new db > pk autoincrement - id =3D 2 > > In this case ddlutils can't insert rows to the tables wich has fk from > parent tables because id value was changed from 35 to 2. > > For apache derby i use attached pach for lastInsertedId implementation Could you add this as a bug to DdlUtils' JIRA ? Tom From ddlutilslopezlauren@example.net Sat Jan 21 23:42:42 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 53848 invoked from network); 21 Jan 2006 23:42:41 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 21 Jan 2006 23:42:41 -0000 Received: (qmail 90397 invoked by uid 500); 21 Jan 2006 23:42:41 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 90371 invoked by uid 500); 21 Jan 2006 23:42:41 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 90359 invoked by uid 99); 21 Jan 2006 23:42:40 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 21 Jan 2006 15:42:40 -0800 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=BIZ_TLD,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of lopezlauren@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO mail.oles.biz) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 21 Jan 2006 15:42:40 -0800 Received: from localhost (localhost.localdomain [83.161.120.155]) by mail.oles.biz (Postfix) with ESMTP id 027191FF77 for <lopezlauren@example.net>; Sun, 22 Jan 2006 02:23:18 +0200 (EET) Received: from mail.oles.biz ([83.161.120.155]) by localhost (oles.biz [83.161.120.155]) (amavisd-new, port 10024) with ESMTP id 14278-06 for <lopezlauren@example.net>; Sun, 22 Jan 2006 02:23:17 +0200 (EET) Received: from [83.161.120.155] (j2.oles.biz [83.161.120.155]) by mail.oles.biz (Postfix) with ESMTP id 7D9406F37 for <lopezlauren@example.net>; Sun, 22 Jan 2006 02:23:17 +0200 (EET) Message-ID: <lopezlauren@example.net> Date: Sun, 22 Jan 2006 01:49:11 +0200 From: Georgi Naplatanov <lopezlauren@example.net> User-Agent: Debian Thunderbird 1.0.7 (X11/20051017) X-Accept-Language: en-us, en MIME-Version: 1.0 To: lopezlauren@example.net Subject: Re: too many waiting objects References: <lopezlauren@example.net> <lopezlauren@example.net> In-Reply-To: <lopezlauren@example.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Debian lopezlauren@example.net X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Thomas Dudziak wrote: >On 1/13/06, Georgi Naplatanov <lopezlauren@example.net> wrote: > > > >>Hello, ddlutils is a great tool, >>i try to migrate hsqldb database to apache derby and i have >>synchronization problem with autogenerated keys from the old (source) db >>and new values from the new db (target db - derby). >> >>Lets say we hawe one row from the parent table >> >>parent table - old db >>pk autoincrement - id = 35 >> >> >>parent table- new db >>pk autoincrement - id = 2 >> >>In this case ddlutils can't insert rows to the tables wich has fk from >>parent tables because id value was changed from 35 to 2. >> >>For apache derby i use attached pach for lastInsertedId implementation >> >> > >Could you add this as a bug to DdlUtils' JIRA ? > >Tom > > Done https://issues.apache.org/jira/browse/DDLUTILS-64 From ddlutilslopezlauren@example.net Sun Jan 22 18:56:07 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 95094 invoked from network); 22 Jan 2006 18:56:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 22 Jan 2006 18:56:07 -0000 Received: (qmail 17347 invoked by uid 500); 22 Jan 2006 18:56:06 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 17329 invoked by uid 500); 22 Jan 2006 18:56:06 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 17318 invoked by uid 99); 22 Jan 2006 18:56:06 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 22 Jan 2006 10:56:06 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=DNS_FROM_RFC_BOGUSMX X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO pd3mo1so.prod.shaw.ca) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 22 Jan 2006 10:56:05 -0800 Received: from pd2mr8so.prod.shaw.ca (pd2mr8so-qfe3.prod.shaw.ca [83.161.120.155]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0ITI001LLCJHJ410@l-daemon> for lopezlauren@example.net; Sun, 22 Jan 2006 11:54:53 -0700 (MST) Received: from pn2ml3so.prod.shaw.ca ([83.161.120.155]) by pd2mr8so.prod.shaw.ca (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <lopezlauren@example.net> for lopezlauren@example.net; Sun, 22 Jan 2006 11:54:53 -0700 (MST) Received: from [83.161.120.155] ([83.161.120.155]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0ITI00HSZCJHWFJ0@l-daemon> for lopezlauren@example.net; Sun, 22 Jan 2006 11:54:53 -0700 (MST) Date: Sun, 22 Jan 2006 11:54:53 -0700 From: Guy Davis <lopezlauren@example.net> Subject: Re: probem reading oracle database? In-reply-to: <lopezlauren@example.net> To: lopezlauren@example.net Message-id: <lopezlauren@example.net> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7bit X-Accept-Language: en-us, en References: <lopezlauren@example.net> User-Agent: Mozilla Thunderbird 1.0.7-1.1.fc4 (X11/20050929) X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I had the same problem on Friday after trying out ddlutils for the first time. I'm hoping to pull the schema off our main Oracle 9i database and let me automatically load it onto developer workstations running Oracle 10g Express Edition via the Ant tasks. Any ideas on how to get around this issue would be most appreciated. Guy Tim Dudgeon wrote: > I'm seeting a NullPointerException when reading a model from a live > Oracle database. > The problem stems from reading the index information. > The db is Oracle 9i and I'm reading it with > platform.readModelFromDatabase("a_name", null, "MY_SCHEMA_NAME", null); From ddlutilslopezlauren@example.net Sun Jan 22 23:32:47 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 87226 invoked from network); 22 Jan 2006 23:32:47 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 22 Jan 2006 23:32:47 -0000 Received: (qmail 28726 invoked by uid 500); 22 Jan 2006 23:32:46 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 28702 invoked by uid 500); 22 Jan 2006 23:32:46 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 28691 invoked by uid 99); 22 Jan 2006 23:32:46 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 22 Jan 2006 15:32:46 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of lopezlauren@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO uproxy.gmail.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 22 Jan 2006 15:32:45 -0800 Received: by uproxy.gmail.com with SMTP id o2so667716uge for <lopezlauren@example.net>; Sun, 22 Jan 2006 15:32:24 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ZpIsmRvW/wiwvD9fattEwxY3BnJgZowgXb3J6MgNpsdk/P0du9hnuLPDQYe53uKUVW0KSY2PK4/5d7JLIQ2GCD59rgu03spv3eeYQBeORtjOPMGmfOyAyObFdRzFnfDDj/UMddkY52igpcWmaXMa+7MNkl05pAI1C9GxVX+eGcA= Received: by 83.161.120.155 with SMTP id i13mr2015461ugj; Sun, 22 Jan 2006 15:32:24 -0800 (PST) Received: by 83.161.120.155 with HTTP; Sun, 22 Jan 2006 15:32:24 -0800 (PST) Message-ID: <lopezlauren@example.net> Date: Mon, 23 Jan 2006 00:32:24 +0100 From: Thomas Dudziak <lopezlauren@example.net> To: lopezlauren@example.net Subject: Re: probem reading oracle database? In-Reply-To: <lopezlauren@example.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <lopezlauren@example.net> <lopezlauren@example.net> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On 1/22/06, Guy Davis <lopezlauren@example.net> wrote: > I had the same problem on Friday after trying out ddlutils for the first > time. I'm hoping to pull the schema off our main Oracle 9i database and > let me automatically load it onto developer workstations running Oracle > 10g Express Edition via the Ant tasks. Any ideas on how to get around > this issue would be most appreciated. FYI, I'm currently struggling to setup a Oracle 10 for testing. I've already adapted the dump task, and it would be nice if you could test it on your 9i like this: <taskdef name=3D"dumpMetadata" classname=3D"org.apache.ddlutils.task.DumpMetadataTask"> classpathref=3D"project.class.path"/> <dumpMetadata outputfile=3D"db-metadata.xml" catalogpattern=3D"" schemapattern=3D"SOMESCHEMA" tablepattern=3D"" procedurepattern=3D"" tabletypes=3D"TABLE" > <database driverclassname=3D"${datasource.driverClassName}" url=3D"${datasource.url}" username=3D"${datasource.username}" password=3D"${datasource.password}"/> </dumpMetadata> This should run through (though it might take a bit, esp. when reading the procedures which you can turn it off with the dumpProcedures task attribute) and the created XML file should contains all tables etc. that you were expecting. Tom From ddlutilslopezlauren@example.net Mon Jan 23 09:11:07 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 97016 invoked from network); 23 Jan 2006 09:11:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 23 Jan 2006 09:11:06 -0000 Received: (qmail 80572 invoked by uid 500); 23 Jan 2006 09:11:06 -0000 Delivered-To: lopezlauren@example.net Received: (qmail 80555 invoked by uid 500); 23 Jan 2006 09:11:05 -0000 Mailing-List: contact lopezlauren@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:lopezlauren@example.net> List-Unsubscribe: <mailto:lopezlauren@example.net> List-Post: <mailto:lopezlauren@example.net> List-Id: <ddlutils-user.db.apache.org> Reply-To: lopezlauren@example.net Delivered-To: mailing list lopezlauren@example.net Received: (qmail 80543 invoked by uid 99); 23 Jan 2006 09:11:05 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Jan 2006 01:11:05 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy includes SPF lopezlauren@example.net) Received: from [83.161.120.155] (HELO smtp811.mail.ukl.yahoo.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 23 Jan 2006 01:11:04 -0800 Received: (qmail 78038 invoked from network); 23 Jan 2006 09:10:41 -0000 Received: from unknown (HELO ?83.161.120.155?) (lopezlauren@example.net@83.161.120.155 with plain) by smtp811.mail.ukl.yahoo.com with SMTP; 23 Jan 2006 09:10:41 -0000 Message-ID: <lopezlauren@example.net> Date: Mon, 23 Jan 2006 09:10:34 +0000 From: Tim Dudgeon <lopezlauren@example.net> User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: lopezlauren@example.net Subject: Re: probem reading oracle database? References: <lopezlauren@example.net> <lopezlauren@example.net> <lopezlauren@example.net> In-Reply-To: <lopezlauren@example.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Tom, This is what I get when I try this: java.lang.AbstractMethodError: oracle.jdbc.driver.OracleDatabaseMetaData.locatorsUpdateCopy()lopezlauren@example.net(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.ddlutils.task.DumpMetadataTask.dumpProperty(DumpMetadataTask.java:294) at org.apache.ddlutils.task.DumpMetadataTask.dumpMetaData(DumpMetadataTask.java:269) at org.apache.ddlutils.task.DumpMetadataTask.execute(DumpMetadataTask.java:214) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275) at org.apache.tools.ant.Task.perform(Task.java:364) at org.apache.tools.ant.Target.execute(Target.java:341) at org.apache.tools.ant.helper.ProjectHelper2.parse(ProjectHelper2.java:142) at org.apache.tools.ant.ProjectHelper.configureProject(ProjectHelper.java:91) at org.apache.tools.ant.Main.runBuild(Main.java:653) at org.apache.tools.ant.Main.startAnt(Main.java:187) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67) oracle.jdbc.driver.OracleDatabaseMetaData.locatorsUpdateCopy()Z Looks like a driver version issue? Which driver version are you using? I'm using the ojdbc14.jar, but I think there are multiple versions of this? Tim Thomas Dudziak wrote: >On 1/22/06, Guy Davis <lopezlauren@example.net> wrote: > > >>I had the same problem on Friday after trying out ddlutils for the first >>time. I'm hoping to pull the schema off our main Oracle 9i database and >>let me automatically load it onto developer workstations running Oracle >>10g Express Edition via the Ant tasks. Any ideas on how to get around >>this issue would be most appreciated. >> >> > >FYI, I'm currently struggling to setup a Oracle 10 for testing. >I've already adapted the dump task, and it would be nice if you could >test it on your 9i like this: > > <taskdef name="dumpMetadata" > classname="org.apache.ddlutils.task.DumpMetadataTask"> > classpathref="project.class.path"/> > <dumpMetadata outputfile="db-metadata.xml" > catalogpattern="" > schemapattern="SOMESCHEMA" > tablepattern="" > procedurepattern="" > tabletypes="TABLE" > > <database driverclassname="${datasource.driverClassName}" > url="${datasource.url}" > username="${datasource.username}" > password="${datasource.password}"/> > </dumpMetadata> > >This should run through (though it might take a bit, esp. when reading >the procedures which you can turn it off with the dumpProcedures task >attribute) and the created XML file should contains all tables etc. >that you were expecting. > >Tom > > > From ddlutilslopezlauren@example.net Mon Jan 23 09:48:15 2006 Return-Path: <ddlutilslopezlauren@example.net> Delivered-To: lopezlauren@example.net Received: (qmail 23062 invoked from network); 23 Jan 2006 09:48:15 -0000 Received: from hermes.apache.org (HELO
{'source': 'Apache Software Foundation Public Mail Archives'}