Hi, I looked at your plan and I assume you'll need a port number for ConnectionURL, like dbc:pervasive://srv-vm-w2k3-rat.gmfoto.de:1583/RATIONAL
fyi - I found this link related to pervasive SQL - http://wiki.pentaho.com/display/EAI/Pervasive+SQL HTH, Lin On Wed, Jul 23, 2008 at 12:30 PM, <[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] > --------------------------------------------------------------------------------------------------------------
