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 (asf.osuosl.org: domain of tomdzk@gmail.com designates
 64.233.182.194 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
        b=ErAdIEGET+yQtWBRAIUkVMOiqgzkQ9Lri9aFrTBrKhQGS+s30Yvc24HXY+rwT8d5SfHfL9wNX8Kn/AEcBaTHHE2LhwdCtyrKn2GEOkzrCF04Y7lIWEYtWfjOMUhiYquzrUgqm4N7SjE6L7cGRT+N7OksnnqRI6itpLuvYS7IIHY=
Message-ID: <224f32340511091336p4ffd94delc1f184e93f8ea2c5@mail.gmail.com>
Date: Wed, 9 Nov 2005 22:36:07 +0100
From: Thomas Dudziak <tomdzk@gmail.com>
To: derby-user@db.apache.org
Subject: "conglomerate does not exist" error
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi folks,

I get the "The conglomerate (1.056) requested does not exist." error
with Derby 10.1.1.0 and I don't understand why. Here's the setup:

* I've created a database (using embedded driver) via DdlUtils into my
webapp-to-be-deployed in directory WEB-INF/classes/derbydb. The
database correctly contains data as I checked with ij.

* I then configured my webapp (Struts + Spring) to use Derby via the
url "jdbc:derby:classpath:derbydb" in the assumption that the
WEB-INF/Classes folder is automatically in the classpath.

* The whole stuff is packaged into a WAR and deployed into Tomcat
5.5.12 (which btw. does not know anything about the database)

* The I start the webapp and try to login which in turn uses the
database for the first time. This is where it goes bang.

Database access is configured in Spring to use the
DriverManagerDataSource, and also there is only one user (me as I'm
currently developing the webapp) and only one using class in the
webapp, so there is no concurrent access AFAIK (no multiple VMs or
classloaders).

So could perhaps somebody give me a tip what I did wrong ?

regards,
Tom

PS: here's the stacktrace as far as Derby is concerned:

Caused by: SQL Exception: The conglomerate (1.056) requested does not exist=
.
=09at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source=
)
=09at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException=
(Unknown
Source)
=09at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Un=
known
Source)
=09at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown So=
urce)
=09at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown So=
urce)
=09at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Sour=
ce)
=09at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown So=
urce)
=09at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown So=
urce)
=09at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Sour=
ce)
=09at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown S=
ource)
=09at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown S=
ource)
=09at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
=09at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.=
java:39)
=09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces=
sorImpl.java:25)
=09at java.lang.reflect.Method.invoke(Method.java:585)
=09at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$T=
ransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.jav=
a:167)
=09at $Proxy1.prepareStatement(Unknown Source)