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.

Thanks

Mamatha

---

From: Lily Wei [mailto:lilywei@yahoo.com]
Sent: Tuesday, September 21, 2010 1:49 AM
To: Derby Discussion
Cc: avinash.bhat@nsn.com
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 <kristian.waagan@oracle.com>
To: derby-user@db.apache.org
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
>