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
>
