db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Re: Upgrade issue from 10.5.3 - Problem inserting a record with derby 10.6.1.0
Date Tue, 05 Oct 2010 21:15:14 GMT
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 <lilywei@yahoo.com> 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 <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