Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 12808 invoked from network); 6 Jul 2007 19:43:02 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 6 Jul 2007 19:43:02 -0000 Received: (qmail 39736 invoked by uid 500); 6 Jul 2007 19:43:01 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 39710 invoked by uid 500); 6 Jul 2007 19:43:01 -0000 Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: user@geronimo.apache.org List-Id: Delivered-To: mailing list user@geronimo.apache.org Received: (qmail 39697 invoked by uid 99); 6 Jul 2007 19:43:01 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Jul 2007 12:43:01 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [69.147.95.79] (HELO smtp116.plus.mail.sp1.yahoo.com) (69.147.95.79) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 06 Jul 2007 12:42:55 -0700 Received: (qmail 81808 invoked from network); 6 Jul 2007 19:42:33 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-YMail-OSG:In-Reply-To:References:Mime-Version:X-Priority:Content-Type:Message-Id:From:Subject:Date:To:X-Mailer; b=y2w8rKuqz+m2g3CjiK3E2dK+oqxz4uvQHx4kTjDu/1sdKVxibDkAK6IQlf/MxCrAWoDhqAHyAMMNipLXTTf6QWSkYNBtV8EBSuIpEXuGhBZvY7aVi7gtpvMMJM1II8GTPxLXQeSqDExKYiRxZEZNYIjK8PV1JGWpju9vVrPFD14= ; Received: from unknown (HELO ?192.168.254.137?) (david_jencks@71.222.111.251 with plain) by smtp116.plus.mail.sp1.yahoo.com with SMTP; 6 Jul 2007 19:42:33 -0000 X-YMail-OSG: QI5LyC4VM1mUqPJZs6cIXpTC80PJ9L3APfDQ4NNqJUFT0FfvhyjoV4mgEs4XRFCrX7Hekivm9CA1RvzTQ28Zg.BElLsGd4dTZkT1uH_s0DwS3ajnZMqvs4R_QNR7rxdL7K.vq0bsx8yHYtb4Fa8KRcH9_mUSJPfOSssKUU17N_ylXcf_Q0vPLw-- In-Reply-To: <00e101c7bfc6$817bc2f0$0300000a@animal> References: <964594.9811.qm@web27705.mail.ukl.yahoo.com> <00e101c7bfc6$817bc2f0$0300000a@animal> Mime-Version: 1.0 (Apple Message framework v752.3) X-Priority: 3 Content-Type: multipart/alternative; boundary=Apple-Mail-7--714678327 Message-Id: <01C779FD-FFE4-41F1-B314-E58614B3569E@yahoo.com> From: David Jencks Subject: Re: annoying embedded Derby exception Date: Fri, 6 Jul 2007 12:42:31 -0700 To: user@geronimo.apache.org X-Mailer: Apple Mail (2.752.3) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-7--714678327 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed On Jul 6, 2007, at 5:09 AM, Johnny Kewl wrote: > Hi Xh.... > I afraid I dont know anything about Geronimo, currently just > thinking about using it ;) > But I do know Derby.... > When I look at this.... which seems to be some kind of JNDI > datapool... > I cant see the dB driver anywhere.... in derby there are 2 > One for a shared network.... ie like a conventional server and the > other one is this. > org.apache.derby.jdbc.EmbeddedDriver for embedded dB's > > Then there also has to be a connection URI, something like this > jdbc:derby:dataweaver > > I'm surprized it actually connects to anything without that info... > ... anyway what do I know anyway ;) > Johnny, We're using one of the derby datasources which don't need a URI like that, instead the different properties are presented separately. It's wrapped in a J2CA connector implementation. Xh, What is supposed to create the database? Have you tried true ? thanks david jencks > > ----- Original Message ----- > From: Xh > To: User Geronimo > Sent: Friday, July 06, 2007 1:21 PM > Subject: annoying embedded Derby exception > > Hi All! > > I have very annoying embedded Derby exception that occurs once in a > while: > > SQL Exception: Failed to start database 'dataweaver', see the next > exception for details. > > Usually restart helps and every thing works fine, but this > situation is really annoying... > > I use Geronimo 1.1, and it's embedded Derby 10, the configuration > was simply created with Web wizard - http://127.0.0.1:8080/console/ > portal/services/services_jdbc > > I attach the generated below > > best regards > Lukasz > > > > > > console.dbpool > DataWeaverWARDerby > 1.0 > rar > > > > org.apache.derby > derby > 10.1.3-2 > jar > > > > > > > javax.sql.DataSource connectionfactory-interface> > > DataWeaverWARDerby > > > name="DatabaseName">dataweaver > > > > > 10 > 0 > > > > > > > > > > > > Yahoo! Mail is the world's favourite email. Don't settle for less, > sign up for your free account today. > --Apple-Mail-7--714678327 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=ISO-8859-1
On Jul 6, 2007, at = 5:09 AM, Johnny Kewl wrote:

Hi = Xh....
But I do know Derby....
When I look at this.... = which seems to be some kind of JNDI = datapool...
org.apache.derby.jdbc.EmbeddedDriver=A0=A0 for = embedded dB's
=A0
=A0
=A0

Johnny,

We're using one of the = derby datasources which don't need a URI like that, instead the = different properties are presented separately.=A0 It's wrapped in a J2CA = connector implementation.

Xh,

What is supposed to create = the database?=A0 Have you tried=A0

=A0 =A0 =A0=A0 =A0=A0 =A0=A0 = =A0=A0 =A0=A0 =A0<config-property-setting = name=3D"CreateDatabase">true</config-property-setting>
= ?

thanks
david = jencks

----- Original Message = -----
From:
Sent: Friday, July 06, 2007 1:21 PM
Subject: annoying embedded Derby = exception

Hi = All!
I have very annoying embedded Derby exception that = occurs once in a while:

SQL Exception: Failed to start database = 'dataweaver', see the next exception for details.

Usually restart helps and every thing works fine, but = this situation is really annoying...

I use Geronimo 1.1, and it's = embedded Derby 10, the configuration was simply created with Web wizard = -
I attach the generated <connector> = below
best regards

<?xml version=3D"1.0" = encoding=3D"UTF-8"?>
http://geron= imo.apache.org/xml/ns/j2ee/connector-1.1">
=A0=A0=A0 http://geronimo.= apache.org/xml/ns/deployment-1.1">
=A0=A0=A0=A0=A0=A0=A0 <dep:moduleId>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = <dep:groupId>console.dbpool</dep:groupId>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = <dep:artifactId>DataWeaverWARDerby</dep:artifactId>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = <dep:version>1.0</dep:version>
=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 <dep:type>rar</dep:type>
=A0=A0=A0=A0=A0=A0=A0 </dep:moduleId>
=A0=A0=A0=A0=A0=A0=A0 = <dep:dependencies>
=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 <dep:dependency>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = <dep:artifactId>derby</dep:artifactId>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = <dep:version>10.1.3-2</dep:version>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = <dep:type>jar</dep:type>
=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 </dep:dependency>
=A0=A0=A0=A0=A0=A0= =A0 </dep:dependencies>
=A0=A0=A0 = </dep:environment>
=A0=A0=A0 = <resourceadapter>
=A0=A0=A0=A0=A0=A0=A0 = <outbound-resourceadapter>
=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 <connection-definition>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = <connectionfactory-interface>javax.sql.DataSource</connectionfact= ory-interface>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 <connectiondefinition-instance>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= <name>DataWeaverWARDerby</name>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= <config-property-setting name=3D"Password"/>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= <config-property-setting name=3D"LoginTimeout"/>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= <config-property-setting = name=3D"DatabaseName">dataweaver</config-property-setting>=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= <config-property-setting name=3D"UserName"/>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= <connectionmanager>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = <max-size>10</max-size>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 <match-one/>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 </single-pool>
=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 </connection-definition>
=A0=A0=A0=A0=A0=A0=A0 = </outbound-resourceadapter>
=A0=A0=A0 = </resourceadapter>


Yahoo! Mail is the world's favourite = email. Don't settle for less,=A0sign up for = your free account today.


<= /HTML>= --Apple-Mail-7--714678327--