geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lin Sun" <linsun....@gmail.com>
Subject Re: Re: Problems Connecting to Pervasive SQL Database
Date Wed, 23 Jul 2008 17:03:31 GMT
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,  <tpoth@gmfoto.de> wrote:
>
> Hi Lin,
>
> thanx for givin pervasive a chance to survive ;-)
>
> "Lin Sun" <linsun.unc@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
> --------------------------------------------------------------------------------------------------------------

Mime
View raw message