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] --------------------------------------------------------------------------------------------------------------
