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
-----Original Message-----
From: Kristian Waagan [mailto:[email protected]]
Sent: Monday, October 04, 2010 3:48 PM
To: Derby Discussion
Cc: Mamatha Kodigehalli Venkatesh; [email protected]
Subject: Re: Problem inserting a record with derby 10.6.1.0
On 01.10.10 09:44, Mamatha Kodigehalli Venkatesh wrote:
>
> Hello all,
>
> I too upgraded derby from 10.5.3.0 to 10.6.1.0, I am getting below
> exception
>
> When I tried to insert a record into the table using a prepared statement.
>
> java.sql.SQLException: Java exception:
> 'org.apache.derby.iapi.sql.execute.Result
>
> SetFactory.getProjectRestrictResultSet(Lorg/apache/derby/iapi/sql/execute/NoPutR
>
> esultSet;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;Lorg/apache/derb
>
> y/iapi/services/loader/GeneratedMethod;ILorg/apache/derby/iapi/services/loader/G
>
> eneratedMethod;IZZDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;:
> java.la
>
> ng.NoSuchMethodError'.
>
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknow
>
> n Source)
>
> at
> org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
>
> at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
>
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException
>
> (Unknown Source)
>
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Un
>
> known Source)
>
> at
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown So
>
> urce)
>
> at
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown So
>
> urce)
>
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown So
>
> urce)
>
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Un
>
> known Source)
>
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unkno
>
> wn Source)
>
> However Iam able to insert a record into table through ij editor.
>
Hi Mamatha,
Looks like Derby is using some old generated code or something, and that
the referred method no longer exists. If that's the case, there is a bug
in the Derby upgrade logic.
Did you boot the database with "upgrade=true", or did you do a soft
upgrade [1]?
Also, I'm assuming that you ran with the released Derby jars and not a
custom build.
Regards,
--
Kristian
[1] http://wiki.apache.org/db-derby/UpgradingTen
> Thanks
>
> Mamatha
>
> ------------------------------------------------------------------------
>
> *From:* Lily Wei [mailto:[email protected]]
> *Sent:* Tuesday, September 21, 2010 1:49 AM
> *To:* Derby Discussion
> *Cc:* [email protected]
> *Subject:* Re: Problem!
>
> Hi Avinash:
> You can find the changes from 10.5.3.0 to 10.6.1.0 in here:
> http://wiki.apache.org/db-derby/DerbyTenSixOneRelease
>
> Does your application change behavior because of new features? As
> Kristian point out, the trace will give us more information in turn of
> which part of Derby the problem occurs along with what operation is
> performed to upgrade derby from 10.5.3.0 to 10.6.1.0.
>
>
> Hope this help,
> Lily
>
> ------------------------------------------------------------------------
>
> *From:* Kristian Waagan <[email protected]>
> *To:* [email protected]
> *Sent:* Fri, September 17, 2010 3:47:21 AM
> *Subject:* Re: Problem!
>
> On 17.09.10 12:11, Bhat, Avinash (NSN - IN/Bangalore) wrote:
> >
> > Hi,
> >
> > This is avinash bhat, I am facing a problem in derby upgrade.
> Currently I have 10.5.0.3 version installed in my system and when I
> tried upgrading it to 10.6.0.1 my software is not able to load it is
> throwing null pointer exception. But it is able to create databases
> for the first time and if database already exist it says Null pointer
> exception.
> >
> > Can I know what is the problem which I am facing? Or do I know what
> major difference that you people have made between 10.5.0.3 and 10.6.0.1?
> >
>
> Hi Avinash,
>
> I don't know why you get this error.
> Can you post the stack trace you get when hitting the problem?
> ( written to the console, or to derby.log )
> Also, are you doing a hard upgrade (specifying upgrade=true in the
> connection URL), or are you doing a soft upgrade (no special
> attributes in the connection URL)?
>
> The trace may tell us in which part of Derby the problem occurs.
>
>
> Regards,
> -- Kristian
>
> > With regards,
> > Avinash Bhat
> >
>
