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: domain of Nathan.Voxland@sundog.net
 designates 65.164.223.134 as permitted sender)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Problem with default date values
Date: Thu, 9 Aug 2007 10:35:22 -0500
Message-ID: <1B92B5A688796F4C8296B03BD3AAE27FAF14D3@MAIL.sundog.net>
In-Reply-To: <46BB2FDA.7060701@amberpoint.com>
Thread-Topic: Problem with default date values
Thread-Index: AcfamF5E4/oYlCRbQV6zaT4YK0MisAAAl3mg
References: <1B92B5A688796F4C8296B03BD3AAE27FAF14AE@MAIL.sundog.net>
 <46BA3950.3070005@amberpoint.com>
 <1B92B5A688796F4C8296B03BD3AAE27FAF14C3@MAIL.sundog.net>
 <46BB2FDA.7060701@amberpoint.com>
From: "Nathan Voxland" <Nathan.Voxland@sundog.net>
To: "Derby Discussion" <derby-user@db.apache.org>

I tried the 10.3.1.4 release, and my test case if failing before I get
to the other error.  It's failing on this call:

tableRS =3D conn.getMetaData().getTables(getCatalogName(),
getSchemaName(), null, new String[]{"TABLE", "GLOBAL TEMPORARY", "LOCAL
TEMPORARY", "ALIAS", "SYNONYM"});

with this stack trace:
java.sql.SQLException: The parameter position '8' is out of range.  The
number of parameters for this prepared  statement is '7'.
	at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
	at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
	at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Un
known Source)
	at
org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown
Source)
	at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.setString(Unknown
Source)
	at
org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getTables(Unknown
Source)
	at
liquibase.database.AbstractDatabase.dropForeignKeys(AbstractDatabase.jav
a:714)
	... 25 more
Caused by: ERROR XCL13: The parameter position '8' is out of range.  The
number of parameters for this prepared  statement is '7'.
	at
org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
	at
org.apache.derby.impl.sql.GenericParameterValueSet.checkPosition(Unknown
Source)
	at
org.apache.derby.impl.sql.GenericParameterValueSet.getParameterForSet(Un
known Source)
	... 28 more

The same call worked before on 10.2.2.0

Nathan

-----Original Message-----
From: Bryan Pendleton [mailto:bpendleton@amberpoint.com]=20
Sent: Thursday, August 09, 2007 10:17 AM
To: Derby Discussion
Subject: Re: Problem with default date values

> Does setting the default value for the other columns kick in that bug?

No, I didn't think so. DERBY-2371 specifically involved a problem when
there were a non-zero number of non-null values in the table at the time
of the ALTER TABLE command.

Also, I tried your complete set of commands against the current trunk
and did not see the error.

Can you post the full stack trace (from derby.log) of the problem you're
seeing?

> I'll try the latest code to see if that helps.  Are there nightly
builds
> available, or do I have to build it myself?

For Derby 10.3, there is a release candidate available, and the
complete release should be available very soon. Get the candidate here:
http://wiki.apache.org/db-derby/DerbyTenThreeRelease

You have to build the trunk yourself, but it's not hard. Full
instructions
are available at the web site. If you encounter problems, people
on the derby-dev list will be glad to help you. Start here:
http://db.apache.org/derby/dev/derby_source.html

thanks,

bryan