John C. Turnbull wrote:
I have just started to use Derby for configuration data for an
application and have found that whenever the app terminates unexpectedly
then Derby will not start the next time I start the application as it
complains that it’s already been opened. At the moment, I need
It seems to me that the compiler should not think it has enough
information at prepareStatement() time to assign the ? a type of
VARCHAR. That looks like a bug to me.
As a workaround, the following statement gives the compiler enough
information to correctly type the ? parameter. This allows
Hi Oystein,
Thanks for the reply. Comments inline.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, 2 April 2007 18:13
To: Derby Discussion
Subject: Re: [n00b] Recovering from program crashes
Normally the lock file used to lock the database for
On 4/2/07, Rick Hillegas [EMAIL PROTECTED] wrote:
It seems to me that the compiler should not think it has enough
information at prepareStatement() time to assign the ? a type of
VARCHAR. That looks like a bug to me.
As a workaround, the following statement gives the compiler enough
There is a file in the db directory db.lck that is created to prevent
dual booting. See
http://db.apache.org/derby/docs/10.2/devguide/cdevdvlp20458.html for
more info.
By removing that file you should be able to boot. However, make sure
that no other process is accessing the database.
After reading through the documentation it doesn't seem like passing an
array to a stored procedure is possible:
Java stored procedure:
package com.test.annotation;
public class UpdateData
{
public static void NewDataAdded(List newIds, long speciesId) throws
SQLException
{
Brown, Andrew W (Rosetta) wrote:
After reading through the documentation it doesn't seem like passing an
array to a stored procedure is possible:
Derby does not support the SQL ARRAY type. So it will not be possible
to pass arrays as stored procedures.
--
Øystein
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 3 April 2007 02:44
To: Derby Discussion
Subject: Re: [n00b] Recovering from program crashes
There is a file in the db directory db.lck that is created to prevent
dual booting. See