Hi Mamatha: Are you using trigger in 10.5? Do you have the definition of those trigger? i.e. the SQL statement.
Thanks, Lily ________________________________ From: Lily Wei <lily...@yahoo.com> To: derby-user@db.apache.org Sent: Tue, October 5, 2010 10:16:54 AM Subject: Re: Upgrade issue from 10.5.3 - Problem inserting a record with derby 10.6.1.0 Hi Mamath: Before you do upgrade=true, were you doing a softupgrade? I just try upgrade from 10.5 to 10.6.2.1(the release candidate) with softupgrade. I did not see the Exception with my try. This is what I did: On 10.5 ====== ij version 10.5 ij> connect 'jdbc:derby:TestDerbyDB;user=admin;password=password;create=true'; ij> create table tidlrblt(BLT char(10), BLT_SIZE int, MIN_MAX_SIZE int); 0 rows inserted/updated/deleted ij> insert into tidlrblt values ('Test 1', 15, 20); 1 row inserted/updated/deleted ij> insert into tidlrblt values ('Test 2', 20, 25); 1 row inserted/updated/deleted ij> insert into tidlrblt values ('Test 3', 25, 30); 1 row inserted/updated/deleted ij> select * from tidlrblt; BLT |BLT_SIZE |MIN_MAX_SI& ---------------------------------- Test 1 |15 |20 Test 2 |20 |25 Test 3 |25 |30 3 rows selected up $ export CLASSPATH=".;c:/derby/10.6/tools/java/junit.jar;c:/derby/10.6/jars/san e/derbyrun.jar;c:/derby/10.6/jars/sane/derbyTesting.jar;c:/derby/10.6/tools/jar s/java/jakarta-oro-2.0.8.jar" l...@lily-pc /c/derby/10.5/testtmp $ ij ij version 10.6 ij> connect 'jdbc:derby:TestDerbyDB;user=admin;password=password'; ij> insert into tidlrblt values ('TUpdate 1.', 30, 35); 1 row inserted/updated/deleted ij> select * from tidlrblt; BLT |BLT_SIZE |MIN_MAX_SI& ---------------------------------- Test 1 |15 |20 Test 2 |20 |25 Test 3 |25 |30 TUpdate 1.|30 |35 4 rows selected Do you see you are doing anything different with you upgrade step before try the upgrade=true option? If I miss anything, please feel free to comment. Thanks, Lily From: Mamatha Kodigehalli Venkatesh <mamatha.venkat...@ness.com> To: Derby Discussion <derby-user@db.apache.org> Sent: Tue, October 5, 2010 5:50:11 AM Subject: Upgrade issue from 10.5.3 - Problem inserting a record with derby 10.6.1.0 Hello all, Currently I have my tables with data that was created using 10.5.3 version. Where I was able to perform all operations like select ,insert, update successfully. Now I upgraded to 10.6.1 and unable to perform insert into existing tables of the database that was created in 10.5.3 however am able to perform select & update operations. NOTE : There is no problem to insert data into the newly created table for existing database that was created in the 10.5.3 I also tried Connect jdbc:derby:C:\DATA\L10NEnvSetup\DERBY\TestDerbyDB;user=admin;password=password;upgrade=true'; But end up getting ij> INSERT INTO tidlrblt(BLT,BLT_SIZE,MIN_MAX_SIZE) VALUES('Mamatha Testing2', 1 5, 20); ERROR XJ001: Java exception: 'org.apache.derby.iapi.sql.execute.ResultSetFactory .getProjectRestrictResultSet(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;L org/apache/derby/iapi/services/loader/GeneratedMethod;Lorg/apache/derby/iapi/ser vices/loader/GeneratedMethod;ILorg/apache/derby/iapi/services/loader/GeneratedMe thod;IZZDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;: java.lang.NoSuchM ethodError'. ij> Thanks Mamatha