From derby-user-return-4423-apmail-db-derby-user-archive=db.apache.org@db.apache.org Wed Jun 14 21:29:44 2006 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 90237 invoked from network); 14 Jun 2006 21:29:44 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 14 Jun 2006 21:29:44 -0000 Received: (qmail 80724 invoked by uid 500); 14 Jun 2006 21:29:42 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 80679 invoked by uid 500); 14 Jun 2006 21:29:42 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 80668 invoked by uid 99); 14 Jun 2006 21:29:42 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Jun 2006 14:29:42 -0700 X-ASF-Spam-Status: No, hits=1.9 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [32.97.110.151] (HELO e33.co.us.ibm.com) (32.97.110.151) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Jun 2006 14:29:41 -0700 Received: from westrelay02.boulder.ibm.com (westrelay02.boulder.ibm.com [9.17.195.11]) by e33.co.us.ibm.com (8.12.11.20060308/8.12.11) with ESMTP id k5ELTKQr017159 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Wed, 14 Jun 2006 17:29:20 -0400 Received: from d03av01.boulder.ibm.com (d03av01.boulder.ibm.com [9.17.195.167]) by westrelay02.boulder.ibm.com (8.13.6/NCO/VER7.0) with ESMTP id k5ELT648283654 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Wed, 14 Jun 2006 15:29:06 -0600 Received: from d03av01.boulder.ibm.com (loopback [127.0.0.1]) by d03av01.boulder.ibm.com (8.12.11.20060308/8.13.3) with ESMTP id k5ELTKck006637 for ; Wed, 14 Jun 2006 15:29:20 -0600 Received: from [127.0.0.1] (MARSDEN-IBM-LT1.usca.ibm.com [9.72.134.81]) by d03av01.boulder.ibm.com (8.12.11.20060308/8.12.11) with ESMTP id k5ELTJDK006622 for ; Wed, 14 Jun 2006 15:29:19 -0600 Message-ID: <44907FAE.4050703@sbcglobal.net> Date: Wed, 14 Jun 2006 14:29:18 -0700 From: Kathey Marsden User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.13) Gecko/20060414 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Re: The tutorial on migrating DB to derby References: <42120.205.175.225.24.1150307715.squirrel@mail.eng.iastate.edu> <449050F0.70206@bristowhill.com> <44907096.4010402@sbcglobal.net> In-Reply-To: <44907096.4010402@sbcglobal.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 Kathey Marsden wrote: > Jean T. Anderson wrote: > >> kamna@eng.iastate.edu wrote: >> >> >>> Hi, >>> I was just going through the tutorial at >>> http://db.apache.org/derby/integrate/db_ddlutils.html >>> >>> >> > I am going through this tutorial too today. I got through the > tutorial fine but on migrating another db I see the exception below #:( > Perhaps DdlUtils is calling Clob.getSubString with an invalid length > value in this case? > > Jean suggested I post the DDL for the table. Changing the book sample database to have a clob column of the same size worked ok. Here is the DDL for the table. CREATE TABLE "APP"."CEG" ("CUUID" CHAR(36) NOT NULL, "CCUUID" CHAR(36) NOT NULL, "CSECTION" CHAR(6) NOT NULL, "CSTATUS" CHAR(8) NOT NULL, "CNAME" VARCHAR(255) NOT NULL, "CXMLDATA" CLOB(10485760) NOT NULL, "CLASTUPDATE" TIMESTAMP NOT NULL); > EXCEPTION: > SQL Exception: Zero or negative length argument '0' passed in a BLOB > or CLOB method. > > JDBCAPI CALL > http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Clob.html#getSubString(long,%20int) > > > FULL TRACE: > export-source-db: > [databaseToDdl] Written schema to C:\marsden\ddlutils-test\db-schema.xml > > BUILD FAILED > C:\marsden\ddlutils-test\build.xml:11: > org.apache.ddlutils.DynaSqlException: Exception while reading the row > from the resultset > at > org.apache.ddlutils.task.WriteDataToFileCommand.execute(WriteDataToFileCommand.java:88) > > at > org.apache.ddlutils.task.DatabaseTaskBase.executeCommands(DatabaseTaskBase.java:198) > > at > org.apache.ddlutils.task.DatabaseTaskBase.execute(DatabaseTaskBase.java:222) > > at > org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269) > at org.apache.tools.ant.Task.perform(Task.java:364) > at org.apache.tools.ant.Target.execute(Target.java:301) > at org.apache.tools.ant.Target.performTasks(Target.java:328) > at org.apache.tools.ant.Project.executeTarget(Project.java:1215) > at org.apache.tools.ant.Project.executeTargets(Project.java:1063) > at org.apache.tools.ant.Main.runBuild(Main.java:632) > at org.apache.tools.ant.Main.startAnt(Main.java:183) > at org.apache.tools.ant.launch.Launcher.run(Launcher.java:197) > at org.apache.tools.ant.launch.Launcher.main(Launcher.java:56) > Caused by: org.apache.ddlutils.DynaSqlException: Exception while > reading the row from the resultset > at > org.apache.ddlutils.platform.ModelBasedResultSetIterator.next(ModelBasedResultSetIterator.java:261) > > at org.apache.ddlutils.io.DataWriter.write(DataWriter.java:303) > at > org.apache.ddlutils.task.WriteDataToFileCommand.execute(WriteDataToFileCommand.java:82) > > ... 12 more > Caused by: SQL Exception: Zero or negative length argument '0' passed > in a BLOB or CLOB method. > at > org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:80) > at > org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87) > at > org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:166) > at > org.apache.derby.impl.jdbc.EmbedClob.getSubString(EmbedClob.java:206) > at > org.apache.ddlutils.platform.PlatformImplBase.extractColumnValue(PlatformImplBase.java:1961) > > at > org.apache.ddlutils.platform.PlatformImplBase.getObjectFromResultSet(PlatformImplBase.java:1885) > > at > org.apache.ddlutils.platform.ModelBasedResultSetIterator.next(ModelBasedResultSetIterator.java:251) > > ... 14 more > --- Nested Exception --- > org.apache.ddlutils.DynaSqlException: Exception while reading the row > from the resultset > at > org.apache.ddlutils.platform.ModelBasedResultSetIterator.next(ModelBasedResultSetIterator.java:261) > > at org.apache.ddlutils.io.DataWriter.write(DataWriter.java:303) > at > org.apache.ddlutils.task.WriteDataToFileCommand.execute(WriteDataToFileCommand.java:82) > > at > org.apache.ddlutils.task.DatabaseTaskBase.executeCommands(DatabaseTaskBase.java:198) > > at > org.apache.ddlutils.task.DatabaseTaskBase.execute(DatabaseTaskBase.java:222) > > at > org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269) > at org.apache.tools.ant.Task.perform(Task.java:364) > at org.apache.tools.ant.Target.execute(Target.java:301) > at org.apache.tools.ant.Target.performTasks(Target.java:328) > at org.apache.tools.ant.Project.executeTarget(Project.java:1215) > at org.apache.tools.ant.Project.executeTargets(Project.java:1063) > at org.apache.tools.ant.Main.runBuild(Main.java:632) > at org.apache.tools.ant.Main.startAnt(Main.java:183) > at org.apache.tools.ant.launch.Launcher.run(Launcher.java:197) > at org.apache.tools.ant.launch.Launcher.main(Launcher.java:56) > Caused by: SQL Exception: Zero or negative length argument '0' passed > in a BLOB or CLOB method. > at > org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:80) > at > org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87) > at > org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:166) > at > org.apache.derby.impl.jdbc.EmbedClob.getSubString(EmbedClob.java:206) > at > org.apache.ddlutils.platform.PlatformImplBase.extractColumnValue(PlatformImplBase.java:1961) > > at > org.apache.ddlutils.platform.PlatformImplBase.getObjectFromResultSet(PlatformImplBase.java:1885) > > at > org.apache.ddlutils.platform.ModelBasedResultSetIterator.next(ModelBasedResultSetIterator.java:251) > > ... 14 more > > Total time: 14 seconds > $ > > >