You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by tp...@gmfoto.de on 2008/07/23 10:06:48 UTC
Problems Connecting to Pervasive SQL Database
Hi All,
i'm currently in evaluating the geronimo Version 2.1.1 on Mac OS X with
Mac OS X 10.5.4 installed.
Java version is 1.5.0_13
I had to use a Pervasive SQL Database Server (v9.5 SP2), but at deployment
time it fails.
The Problem as follows:
I've added the three jar archives jpscs.jar, pvjdbcv2.jar and
pvjdbcv2x.jar to the repository.
Therefore i uploaded the three files seperate via Server Console -
Service/Repository
as group i give the package name com.pervasive.jdbc.v2
as artifact i give the Name of the jar (without .jar)
as version i took 1 (don't realy know the right Version of the jar's)
as type i inserted jar
Now i created a new database pool with the wizzard under Services/Database
Pools
Her i give the credentials for jdbc connection to our server
The connection test is ok
Test Result: Connected toPervasive.SQL 09.52.0043 000
If i know click the Deploy button the error occurs:
Error Deploying: Unable to deploy: jdbc/rational - see the log for details
In the console i see this ouput:
09:59:28,643 WARN [geronimo-commands:start-server] Deployer operation
failed: Can not load activation spec class
09:59:28,710 WARN [geronimo-commands:start-server]
org.apache.geronimo.common.DeploymentException: Can not load activation
spec class
09:59:28,710 WARN [geronimo-commands:start-server] at
org.apache.geronimo.connector.deployment.ConnectorModuleBuilder.setUpDynamicGBean(ConnectorModuleBuilder.java:625)
09:59:28,711 WARN [geronimo-commands:start-server] at
org.apache.geronimo.connector.deployment.ConnectorModuleBuilder.setUpDynamicGBeanWithProperties(ConnectorModuleBuilder.java:692)
09:59:28,711 WARN [geronimo-commands:start-server] at
org.apache.geronimo.connector.deployment.ConnectorModuleBuilder.getManagedConnectionFactoryInfoMap(ConnectorModuleBuilder.java:660)
09:59:28,711 WARN [geronimo-commands:start-server] at
org.apache.geronimo.connector.deployment.ConnectorModuleBuilder.initContext(ConnectorModuleBuilder.java:462)
09:59:28,711 WARN [geronimo-commands:start-server] at
org.apache.geronimo.j2ee.deployment.EARConfigBuilder.buildConfiguration(EARConfigBuilder.java:595)
09:59:28,727 WARN [geronimo-commands:start-server] at
org.apache.geronimo.deployment.Deployer.deploy(Deployer.java:254)
09:59:28,728 WARN [geronimo-commands:start-server] at
org.apache.geronimo.deployment.Deployer.deploy(Deployer.java:133)
09:59:28,728 WARN [geronimo-commands:start-server] at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
09:59:28,728 WARN [geronimo-commands:start-server] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
09:59:28,728 WARN [geronimo-commands:start-server] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
09:59:28,728 WARN [geronimo-commands:start-server] at
java.lang.reflect.Method.invoke(Method.java:585)
09:59:28,728 WARN [geronimo-commands:start-server] at
org.apache.geronimo.gbean.runtime.ReflectionMethodInvoker.invoke(ReflectionMethodInvoker.java:34)
09:59:28,728 WARN [geronimo-commands:start-server] at
org.apache.geronimo.gbean.runtime.GBeanOperation.invoke(GBeanOperation.java:124)
09:59:28,759 WARN [geronimo-commands:start-server] at
org.apache.geronimo.gbean.runtime.GBeanInstance.invoke(GBeanInstance.java:867)
09:59:28,759 WARN [geronimo-commands:start-server] at
org.apache.geronimo.kernel.basic.BasicKernel.invoke(BasicKernel.java:239)
09:59:28,759 WARN [geronimo-commands:start-server] at
org.apache.geronimo.deployment.plugin.local.AbstractDeployCommand.doDeploy(AbstractDeployCommand.java:116)
09:59:28,759 WARN [geronimo-commands:start-server] at
org.apache.geronimo.deployment.plugin.local.DistributeCommand.run(DistributeCommand.java:61)
09:59:28,759 WARN [geronimo-commands:start-server] at
java.lang.Thread.run(Thread.java:613)
09:59:28,759 WARN [geronimo-commands:start-server] Caused by:
java.lang.ClassNotFoundException: org.tranql.connector.jdbc.JDBCDriverMCF
in classloader console.dbpool/jdbc%2Frational/1.0/rar
09:59:28,759 WARN [geronimo-commands:start-server] at
org.apache.geronimo.kernel.config.MultiParentClassLoader.loadOptimizedClass(MultiParentClassLoader.java:428)
09:59:28,779 WARN [geronimo-commands:start-server] at
org.apache.geronimo.kernel.config.MultiParentClassLoader.loadClass(MultiParentClassLoader.java:278)
09:59:28,779 WARN [geronimo-commands:start-server] at
java.lang.ClassLoader.loadClass(ClassLoader.java:251)
09:59:28,779 WARN [geronimo-commands:start-server] at
org.apache.geronimo.connector.deployment.ConnectorModuleBuilder.setUpDynamicGBean(ConnectorModuleBuilder.java:622)
09:59:29,383 WARN [geronimo-commands:start-server] ... 17 more
Has anybody an idea, what's going wrong?
Thanks in advance...
Best regards
GM-Foto GmbH
Thomas Poth
IT-Manager
Tel.: 0049-69-238570-0
Fax: 0049-69-238570-30
Mail: poth@gmfoto.de
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: gmfoto@gmfoto.de
--------------------------------------------------------------------------------------------------------------
Re: Problems Connecting to Pervasive SQL Database
Posted by David Jencks <da...@yahoo.com>.
Can you show the geronimo plan generated in the admin console?
thanks
david jencks
On Jul 23, 2008, at 1:06 AM, tpoth@gmfoto.de wrote:
>
> Hi All,
>
> i'm currently in evaluating the geronimo Version 2.1.1 on Mac OS X
> with Mac OS X 10.5.4 installed.
> Java version is 1.5.0_13
>
> I had to use a Pervasive SQL Database Server (v9.5 SP2), but at
> deployment time it fails.
>
> The Problem as follows:
> I've added the three jar archives jpscs.jar, pvjdbcv2.jar and
> pvjdbcv2x.jar to the repository.
>
> Therefore i uploaded the three files seperate via Server Console -
> Service/Repository
> as group i give the package name com.pervasive.jdbc.v2
> as artifact i give the Name of the jar (without .jar)
> as version i took 1 (don't realy know the right Version of the jar's)
> as type i inserted jar
>
> Now i created a new database pool with the wizzard under Services/
> Database Pools
> Her i give the credentials for jdbc connection to our server
>
> The connection test is ok
> Test Result: Connected toPervasive.SQL 09.52.0043 000
>
> If i know click the Deploy button the error occurs:
> Error Deploying: Unable to deploy: jdbc/rational - see the log for
> details
>
> In the console i see this ouput:
> 09:59:28,643 WARN [geronimo-commands:start-server] Deployer
> operation failed: Can not load activation spec class
> 09:59:28,710 WARN [geronimo-commands:start-server]
> org.apache.geronimo.common.DeploymentException: Can not load
> activation spec class
> 09:59:28,710 WARN [geronimo-commands:start-server] at
> org
> .apache
> .geronimo
> .connector
> .deployment
> .ConnectorModuleBuilder
> .setUpDynamicGBean(ConnectorModuleBuilder.java:625)
> 09:59:28,711 WARN [geronimo-commands:start-server] at
> org
> .apache
> .geronimo
> .connector
> .deployment
> .ConnectorModuleBuilder
> .setUpDynamicGBeanWithProperties(ConnectorModuleBuilder.java:692)
> 09:59:28,711 WARN [geronimo-commands:start-server] at
> org
> .apache
> .geronimo
> .connector
> .deployment
> .ConnectorModuleBuilder
> .getManagedConnectionFactoryInfoMap(ConnectorModuleBuilder.java:660)
> 09:59:28,711 WARN [geronimo-commands:start-server] at
> org
> .apache
> .geronimo
> .connector
> .deployment
> .ConnectorModuleBuilder.initContext(ConnectorModuleBuilder.java:462)
> 09:59:28,711 WARN [geronimo-commands:start-server] at
> org
> .apache
> .geronimo
> .j2ee
> .deployment
> .EARConfigBuilder.buildConfiguration(EARConfigBuilder.java:595)
> 09:59:28,727 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.deployment.Deployer.deploy(Deployer.java:254)
> 09:59:28,728 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.deployment.Deployer.deploy(Deployer.java:133)
> 09:59:28,728 WARN [geronimo-commands:start-server] at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 09:59:28,728 WARN [geronimo-commands:start-server] at
> sun
> .reflect
> .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 09:59:28,728 WARN [geronimo-commands:start-server] at
> sun
> .reflect
> .DelegatingMethodAccessorImpl
> .invoke(DelegatingMethodAccessorImpl.java:25)
> 09:59:28,728 WARN [geronimo-commands:start-server] at
> java.lang.reflect.Method.invoke(Method.java:585)
> 09:59:28,728 WARN [geronimo-commands:start-server] at
> org
> .apache
> .geronimo
> .gbean
> .runtime.ReflectionMethodInvoker.invoke(ReflectionMethodInvoker.java:
> 34)
> 09:59:28,728 WARN [geronimo-commands:start-server] at
> org
> .apache
> .geronimo.gbean.runtime.GBeanOperation.invoke(GBeanOperation.java:124)
> 09:59:28,759 WARN [geronimo-commands:start-server] at
> org
> .apache
> .geronimo.gbean.runtime.GBeanInstance.invoke(GBeanInstance.java:867)
> 09:59:28,759 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.kernel.basic.BasicKernel.invoke(BasicKernel.java:
> 239)
> 09:59:28,759 WARN [geronimo-commands:start-server] at
> org
> .apache
> .geronimo
> .deployment
> .plugin
> .local.AbstractDeployCommand.doDeploy(AbstractDeployCommand.java:116)
> 09:59:28,759 WARN [geronimo-commands:start-server] at
> org
> .apache
> .geronimo
> .deployment
> .plugin.local.DistributeCommand.run(DistributeCommand.java:61)
> 09:59:28,759 WARN [geronimo-commands:start-server] at
> java.lang.Thread.run(Thread.java:613)
> 09:59:28,759 WARN [geronimo-commands:start-server] Caused by:
> java.lang.ClassNotFoundException:
> org.tranql.connector.jdbc.JDBCDriverMCF in classloader
> console.dbpool/jdbc%2Frational/1.0/rar
> 09:59:28,759 WARN [geronimo-commands:start-server] at
> org
> .apache
> .geronimo
> .kernel
> .config
> .MultiParentClassLoader
> .loadOptimizedClass(MultiParentClassLoader.java:428)
> 09:59:28,779 WARN [geronimo-commands:start-server] at
> org
> .apache
> .geronimo
> .kernel
> .config.MultiParentClassLoader.loadClass(MultiParentClassLoader.java:
> 278)
> 09:59:28,779 WARN [geronimo-commands:start-server] at
> java.lang.ClassLoader.loadClass(ClassLoader.java:251)
> 09:59:28,779 WARN [geronimo-commands:start-server] at
> org
> .apache
> .geronimo
> .connector
> .deployment
> .ConnectorModuleBuilder
> .setUpDynamicGBean(ConnectorModuleBuilder.java:622)
> 09:59:29,383 WARN [geronimo-commands:start-server] ... 17
> more
>
>
> Has anybody an idea, what's going wrong?
> Thanks in advance...
>
> Best regards
>
> GM-Foto GmbH
> Thomas Poth
>
> IT-Manager
> Tel.: 0049-69-238570-0
> Fax: 0049-69-238570-30
> Mail: poth@gmfoto.de
> 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: gmfoto@gmfoto.de
> --------------------------------------------------------------------------------------------------------------
Re: Re: Problems Connecting to Pervasive SQL Database
Posted by Lin Sun <li...@gmail.com>.
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, <tp...@gmfoto.de> wrote:
>
> Hi Lin,
>
> thanx for givin pervasive a chance to survive ;-)
>
> "Lin Sun" <li...@gmail.com> 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: poth@gmfoto.de
> 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: gmfoto@gmfoto.de
> --------------------------------------------------------------------------------------------------------------
Antwort: Re: Path to long while unzipping geronimo-tomcat6-javaee5-2.1.1-bin
Posted by tp...@gmfoto.de.
Hi Kevan,
Kevan Miller <ke...@gmail.com> schrieb am 31.07.2008 18:31:30:
> One request -- when starting a new discussion thread, please use
> "New Message" instead of "Reply" and then changing the Subject line.
> Some mail readers (e.g. mine ;-) will organize your "new thread" in
> the previous thread.
>
> Thanks!
I thought if i hit the reply Button an then change the subject, there is
no relation to the previuos message.
Thanks for the hint :-)
Best regards
GM-Foto GmbH
Thomas Poth
IT-Manager
Tel.: 0049-69-238570-0
Fax: 0049-69-238570-30
Mail: poth@gmfoto.de
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: gmfoto@gmfoto.de
--------------------------------------------------------------------------------------------------------------
Re: Path to long while unzipping geronimo-tomcat6-javaee5-2.1.1-bin
Posted by Kevan Miller <ke...@gmail.com>.
On Jul 31, 2008, at 12:13 PM, tpoth@gmfoto.de wrote:
>
> Hi List,
>
> i've now beeing downloading the current stable 2.1.1 Version in zip
> format with tomcat, and i tried to unzip it to the C:\Program Files
> \... Directory under Windows Vista.
> At the end of the unzip prozess i get an error path ist to long?
>
> Any suggestions?
Yes. Choose a shorter path (e.g. c:\) to unpack into. Windoze has a
limit on the number of characters in a path.
One request -- when starting a new discussion thread, please use "New
Message" instead of "Reply" and then changing the Subject line. Some
mail readers (e.g. mine ;-) will organize your "new thread" in the
previous thread.
Thanks!
--kevan
Path to long while unzipping geronimo-tomcat6-javaee5-2.1.1-bin
Posted by tp...@gmfoto.de.
Hi List,
i've now beeing downloading the current stable 2.1.1 Version in zip format
with tomcat, and i tried to unzip it to the C:\Program Files\... Directory
under Windows Vista.
At the end of the unzip prozess i get an error path ist to long?
Any suggestions?
Thx
GM-Foto GmbH
Thomas Poth
IT-Manager
Tel.: 0049-69-238570-0
Fax: 0049-69-238570-30
Mail: poth@gmfoto.de
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: gmfoto@gmfoto.de
--------------------------------------------------------------------------------------------------------------
Re: Re: Antwort: Re: Problems Connecting to Pervasive SQL Database
Posted by Lin Sun <li...@gmail.com>.
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 <li...@gmail.com> 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, <tp...@gmfoto.de> 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: poth@gmfoto.de
>> Web:
>> www.gmfoto.de
>>
>>
>>
>> David Jencks <da...@yahoo.com> 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, tpoth@gmfoto.de wrote:
>>>
>>> >
>>> > Hi Lin,
>>> >
>>> > thanx for givin pervasive a chance to survive ;-)
>>> >
>>> > "Lin Sun" <li...@gmail.com> 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: poth@gmfoto.de
>>> > 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: gmfoto@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: gmfoto@gmfoto.de
>> --------------------------------------------------------------------------------------------------------------
>
Re: Re: Antwort: Re: Problems Connecting to Pervasive SQL Database
Posted by Lin Sun <li...@gmail.com>.
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, <tp...@gmfoto.de> 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: poth@gmfoto.de
> Web:
> www.gmfoto.de
>
>
>
> David Jencks <da...@yahoo.com> 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, tpoth@gmfoto.de wrote:
>>
>> >
>> > Hi Lin,
>> >
>> > thanx for givin pervasive a chance to survive ;-)
>> >
>> > "Lin Sun" <li...@gmail.com> 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: poth@gmfoto.de
>> > 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: gmfoto@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: gmfoto@gmfoto.de
> --------------------------------------------------------------------------------------------------------------
Antwort: Re: Antwort: Re: Problems Connecting to Pervasive SQL Database
Posted by tp...@gmfoto.de.
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: poth@gmfoto.de
Web: www.gmfoto.de
David Jencks <da...@yahoo.com> 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, tpoth@gmfoto.de wrote:
>
> >
> > Hi Lin,
> >
> > thanx for givin pervasive a chance to survive ;-)
> >
> > "Lin Sun" <li...@gmail.com> 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: poth@gmfoto.de
> > 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: gmfoto@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: gmfoto@gmfoto.de
--------------------------------------------------------------------------------------------------------------
Re: Antwort: Re: Problems Connecting to Pervasive SQL Database
Posted by David Jencks <da...@yahoo.com>.
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, tpoth@gmfoto.de wrote:
>
> Hi Lin,
>
> thanx for givin pervasive a chance to survive ;-)
>
> "Lin Sun" <li...@gmail.com> 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: poth@gmfoto.de
> 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: gmfoto@gmfoto.de
> --------------------------------------------------------------------------------------------------------------
Antwort: Re: Problems Connecting to Pervasive SQL Database
Posted by tp...@gmfoto.de.
Hi Lin,
thanx for givin pervasive a chance to survive ;-)
"Lin Sun" <li...@gmail.com> 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: poth@gmfoto.de
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: gmfoto@gmfoto.de
--------------------------------------------------------------------------------------------------------------
Re: Problems Connecting to Pervasive SQL Database
Posted by Lin Sun <li...@gmail.com>.
Hi,
I don't remember seeing anyone configure G w/ pervasive SQL database
server but we'll try to help you.
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).
If the admin console doesn't you'll want to convert these jars to a
maven2 recognizable format yourself before upload these files via
admin console.
- When you create a db pool via admin console, make sure you pick the
jars you installed onto the repository as dependencies.
- If you still fail to deploy the pool, can you use the show plan
button before deploying the pool to show us the plan?
Thanks,
Lin
On Wed, Jul 23, 2008 at 4:06 AM, <tp...@gmfoto.de> wrote:
>
> Hi All,
>
> i'm currently in evaluating the geronimo Version 2.1.1 on Mac OS X with Mac
> OS X 10.5.4 installed.
> Java version is 1.5.0_13
>
> I had to use a Pervasive SQL Database Server (v9.5 SP2), but at deployment
> time it fails.
>
> The Problem as follows:
> I've added the three jar archives jpscs.jar, pvjdbcv2.jar and pvjdbcv2x.jar
> to the repository.
>
> Therefore i uploaded the three files seperate via Server Console -
> Service/Repository
> as group i give the package name com.pervasive.jdbc.v2
> as artifact i give the Name of the jar (without .jar)
> as version i took 1 (don't realy know the right Version of the jar's)
> as type i inserted jar
>
> Now i created a new database pool with the wizzard under Services/Database
> Pools
> Her i give the credentials for jdbc connection to our server
>
> The connection test is ok
> Test Result: Connected toPervasive.SQL 09.52.0043 000
>
> If i know click the Deploy button the error occurs:
> Error Deploying: Unable to deploy: jdbc/rational - see the log for details
>
> In the console i see this ouput:
> 09:59:28,643 WARN [geronimo-commands:start-server] Deployer operation
> failed: Can not load activation spec class
> 09:59:28,710 WARN [geronimo-commands:start-server]
> org.apache.geronimo.common.DeploymentException: Can not load activation spec
> class
> 09:59:28,710 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.connector.deployment.ConnectorModuleBuilder.setUpDynamicGBean(ConnectorModuleBuilder.java:625)
> 09:59:28,711 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.connector.deployment.ConnectorModuleBuilder.setUpDynamicGBeanWithProperties(ConnectorModuleBuilder.java:692)
> 09:59:28,711 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.connector.deployment.ConnectorModuleBuilder.getManagedConnectionFactoryInfoMap(ConnectorModuleBuilder.java:660)
> 09:59:28,711 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.connector.deployment.ConnectorModuleBuilder.initContext(ConnectorModuleBuilder.java:462)
> 09:59:28,711 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.j2ee.deployment.EARConfigBuilder.buildConfiguration(EARConfigBuilder.java:595)
> 09:59:28,727 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.deployment.Deployer.deploy(Deployer.java:254)
> 09:59:28,728 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.deployment.Deployer.deploy(Deployer.java:133)
> 09:59:28,728 WARN [geronimo-commands:start-server] at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 09:59:28,728 WARN [geronimo-commands:start-server] at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 09:59:28,728 WARN [geronimo-commands:start-server] at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 09:59:28,728 WARN [geronimo-commands:start-server] at
> java.lang.reflect.Method.invoke(Method.java:585)
> 09:59:28,728 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.gbean.runtime.ReflectionMethodInvoker.invoke(ReflectionMethodInvoker.java:34)
> 09:59:28,728 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.gbean.runtime.GBeanOperation.invoke(GBeanOperation.java:124)
> 09:59:28,759 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.gbean.runtime.GBeanInstance.invoke(GBeanInstance.java:867)
> 09:59:28,759 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.kernel.basic.BasicKernel.invoke(BasicKernel.java:239)
> 09:59:28,759 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.deployment.plugin.local.AbstractDeployCommand.doDeploy(AbstractDeployCommand.java:116)
> 09:59:28,759 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.deployment.plugin.local.DistributeCommand.run(DistributeCommand.java:61)
> 09:59:28,759 WARN [geronimo-commands:start-server] at
> java.lang.Thread.run(Thread.java:613)
> 09:59:28,759 WARN [geronimo-commands:start-server] Caused by:
> java.lang.ClassNotFoundException: org.tranql.connector.jdbc.JDBCDriverMCF in
> classloader console.dbpool/jdbc%2Frational/1.0/rar
> 09:59:28,759 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.kernel.config.MultiParentClassLoader.loadOptimizedClass(MultiParentClassLoader.java:428)
> 09:59:28,779 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.kernel.config.MultiParentClassLoader.loadClass(MultiParentClassLoader.java:278)
> 09:59:28,779 WARN [geronimo-commands:start-server] at
> java.lang.ClassLoader.loadClass(ClassLoader.java:251)
> 09:59:28,779 WARN [geronimo-commands:start-server] at
> org.apache.geronimo.connector.deployment.ConnectorModuleBuilder.setUpDynamicGBean(ConnectorModuleBuilder.java:622)
> 09:59:29,383 WARN [geronimo-commands:start-server] ... 17 more
>
>
> Has anybody an idea, what's going wrong?
> Thanks in advance...
>
> Best regards
>
> GM-Foto GmbH
> Thomas Poth
>
> IT-Manager
> Tel.: 0049-69-238570-0
> Fax: 0049-69-238570-30
> Mail: poth@gmfoto.de
> 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: gmfoto@gmfoto.de
> --------------------------------------------------------------------------------------------------------------