Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
Message-ID: <4CA9A9DE.2070500@oracle.com>
Date: Mon, 04 Oct 2010 12:18:06 +0200
From: Kristian Waagan <kristian.waagan@oracle.com>
User-Agent: Mozilla/5.0 (X11; U; SunOS i86pc; en-US;
 rv:1.9.2.7) Gecko/20100830 Thunderbird/3.1.1
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
CC: Mamatha Kodigehalli Venkatesh <Mamatha.Venkatesh@ness.com>,
        avinash.bhat@nsn.com
Subject: Re: Problem inserting a record with derby 10.6.1.0
References: 
 <8130F649786FB040B748FED34D3F8D5C01F5CB80@SGSIEXC008.nsn-intra.net>
 <4C934739.3070109@oracle.com> <411849.99421.qm@web65704.mail.ac4.yahoo.com>
 <ECC00C33B2D4974EB8CDFB5294FA4E3805F869FE@INBLRNT11.ness.com>
In-Reply-To: <ECC00C33B2D4974EB8CDFB5294FA4E3805F869FE@INBLRNT11.ness.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

  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: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
> >
>