Just found it - GERONIMO-3469 We'll look into resolving this in the next G release. Thanks again.
Lin On Thu, Jul 31, 2008 at 10:02 AM, Lin Sun <[EMAIL PROTECTED]> wrote: > Hi, > > Thanks for the feedback. You are right, the prob is the artifact > name - <dep:artifactId>jdbc%2Frational</dep:artifactId> which has a / > in it. I thought this was a known prob for db pool created from > admin console, but I cannot find a JIRA about it. I'll keep looking. > > Lin > > On Thu, Jul 31, 2008 at 9:22 AM, <[EMAIL PROTECTED]> wrote: >> >> Hi David, >> Hi Lin, >> >> i tried another Poolname and it worked for me. >> >> The port must not be assigned in the connection url it works fine without. >> >> But if a took the Poolname jdbc/rational it fails. >> If i took the Poolname rational it's fine. >> >> I hope this is usefull. >> >> THX for your help on this case. >> >> Best regards >> >> GM-Foto GmbH >> Thomas Poth >> >> IT-Manager >> Tel.: 0049-69-238570-0 >> Fax: 0049-69-238570-30 >> Mail: [EMAIL PROTECTED] >> Web: >> www.gmfoto.de >> >> >> >> David Jencks <[EMAIL PROTECTED]> schrieb am 23.07.2008 19:11:01: >> >>> [Bild entfernt] >>> >>> Re: Antwort: Re: Problems Connecting to Pervasive SQL Database >>> >>> David Jencks >>> >>> an: >>> >>> user >>> >>> 23.07.2008 19:12 >>> >>> Bitte Antwort an user >>> >>> Your plan looks ok to me. The missing class is from the tranql >>> connector, not pervasive. It's supposed to be in a jar unpacked from >>> the tranql rar into your connector deployment. Could you look around >>> inside console/dbpool/jdbc%2Frational/1.0/rar and see what's there? >>> >>> Depending on how successful we are at cleaning up after deployment >>> failures you might need to save the plan and deploy using "deploy new" >>> without trying to start the connector. >>> >>> thanks >>> david jencks >>> >>> On Jul 23, 2008, at 9:30 AM, [EMAIL PROTECTED] wrote: >>> >>> > >>> > Hi Lin, >>> > >>> > thanx for givin pervasive a chance to survive ;-) >>> > >>> > "Lin Sun" <[EMAIL PROTECTED]> schrieb am 23.07.2008 17:45:09: >>> > >>> > > I don't remember seeing anyone configure G w/ pervasive SQL database >>> > > server... >>> > >>> > I'm not very lucky about it, but our ERP Software bases on this >>> > Database. >>> > And i had to get the data out of it for our E-Commerce Site. >>> > >>> > > The error looks like the connector failed to load the jdbc drivers. >>> > > Here are some things I can think of - >>> > > >>> > > - After you upload these files via admin console, what does these >>> > file >>> > > look like in the repository? They should be located somewhere under >>> > > geronimo_home/repository/com/pervasive/jdbc/ >>> > > I don't know if the admin console would convert these jars to a >>> > maven2 >>> > > recognizable format (such as name-version.jar, for example >>> > > sqljdbc-1.1.jar). >>> > >>> > It semms that this is OK >>> > >>> > The Files are organized as follows: >>> > geronimo_home/repository/com/pervasive/jdbc/v2/jpscs/1/jpscs-1.jar >>> > geronimo_home/repository/com/pervasive/jdbc/v2/pvjdbc2/1/pvjdbc2-1.jar >>> > geronimo_home/repository/com/pervasive/jdbc/v2/pvjdbc2x/1/ >>> > pvjdbcv2x-1.jar >>> > >>> > > - When you create a db pool via admin console, make sure you pick >>> > the >>> > > jars you installed onto the repository as dependencies. >>> > >>> > I'm sure to do so. >>> > >>> > > - If you still fail to deploy the pool, can you use the show plan >>> > > button before deploying the pool to show us the plan? >>> > > >>> > >>> > Here is the Deployment Plan: >>> > >>> > --- snip >>> > >>> > <?xml version="1.0" encoding="UTF-8"?> >>> > <connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/ >>> > connector-1.2"> >>> > <dep:environment xmlns:dep="http://geronimo.apache.org/xml/ns/ >>> deployment-1.2 >>> > "> >>> > <dep:moduleId> >>> > <dep:groupId>console.dbpool</dep:groupId> >>> > <dep:artifactId>jdbc%2Frational</dep:artifactId> >>> > <dep:version>1.0</dep:version> >>> > <dep:type>rar</dep:type> >>> > </dep:moduleId> >>> > <dep:dependencies> >>> > <dep:dependency> >>> > <dep:groupId>com.pervasive.jdbc.v2</dep:groupId> >>> > <dep:artifactId>jpscs</dep:artifactId> >>> > <dep:version>1</dep:version> >>> > <dep:type>jar</dep:type> >>> > </dep:dependency> >>> > <dep:dependency> >>> > <dep:groupId>com.pervasive.jdbc.v2</dep:groupId> >>> > <dep:artifactId>pvjdbc2</dep:artifactId> >>> > <dep:version>1</dep:version> >>> > <dep:type>jar</dep:type> >>> > </dep:dependency> >>> > <dep:dependency> >>> > <dep:groupId>com.pervasive.jdbc.v2</dep:groupId> >>> > <dep:artifactId>pvjdbc2x</dep:artifactId> >>> > <dep:version>1</dep:version> >>> > <dep:type>jar</dep:type> >>> > </dep:dependency> >>> > </dep:dependencies> >>> > </dep:environment> >>> > <resourceadapter> >>> > <outbound-resourceadapter> >>> > <connection-definition> >>> > <connectionfactory-interface>javax.sql.DataSource</ >>> > connectionfactory-interface> >>> > <connectiondefinition-instance> >>> > <name>jdbc/rational</name> >>> > <config-property-setting >>> > name="Driver">com.pervasive.jdbc.v2.Driver</config-property-setting> >>> > <config-property-setting >>> > name="ConnectionURL">jdbc:pervasive://srv-vm-w2k3-rat.gmfoto.de/ >>> > RATIONAL</config-property-setting> >>> > <connectionmanager> >>> > <local-transaction/> >>> > <single-pool> >>> > <max-size>10</max-size> >>> > <min-size>0</min-size> >>> > <match-one/> >>> > </single-pool> >>> > </connectionmanager> >>> > </connectiondefinition-instance> >>> > </connection-definition> >>> > </outbound-resourceadapter> >>> > </resourceadapter> >>> > </connector> >>> > >>> > --- snip >>> > >>> > >>> > Thx for your help >>> > >>> > >>> > GM-Foto GmbH >>> > Thomas Poth >>> > >>> > IT-Manager >>> > Tel.: 0049-69-238570-0 >>> > Fax: 0049-69-238570-30 >>> > Mail: [EMAIL PROTECTED] >>> > Web: www.gmfoto.de >>> > >>> > >>> > >>> > >>> >>> -------------------------------------------------------------------------------------------------------------- >>> > GM-Foto GmbH, Taunusstraße 47, D-60329 Frankfurt am Main >>> > Telefon: +49 69 238570-0, Telefax: +49 69 238570-30 >>> > Eingetragen beim Amtsgericht Frankfurt am Main: HRB 19494 >>> > Geschäftsführer: Walter Adler und Harald Remsperger >>> > >>> > Öffnungszeiten: Montag - Freitag, 9:00 - 18:30 Uhr >>> > >>> > Internet: http://www.gmfoto.de , E-Mail: [EMAIL PROTECTED] >>> > >>> >>> -------------------------------------------------------------------------------------------------------------- >>> >> >> >> -------------------------------------------------------------------------------------------------------------- >> GM-Foto GmbH, Taunusstraße 47, D-60329 Frankfurt am Main >> Telefon: +49 69 238570-0, Telefax: +49 69 238570-30 >> Eingetragen beim Amtsgericht Frankfurt am Main: HRB 19494 >> Geschäftsführer: Walter Adler und Harald Remsperger >> >> Öffnungszeiten: Montag - Freitag, 9:00 - 18:30 Uhr >> >> Internet: http://www.gmfoto.de , E-Mail: [EMAIL PROTECTED] >> -------------------------------------------------------------------------------------------------------------- >
