Hi Mamatha, Like Lily mentioned, it will be very helpful to have a setup script for the tables in questions to reproduce the problem. Would it possible for you to provide that?
Mamta On Tue, Oct 5, 2010 at 10:41 AM, Lily Wei <[email protected]> wrote: > 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 <[email protected]> > To: [email protected] > 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 <[email protected]> > To: Derby Discussion <[email protected]> > 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 > >
