db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lily Wei <lily...@yahoo.com>
Subject Re: Upgrade issue from 10.5.3 - Problem inserting a record with derby 10.6.1.0
Date Tue, 05 Oct 2010 17:41:37 GMT
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 <lilywei@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"
 
lily@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.Venkatesh@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



      
Mime
View raw message