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: Antwort: Re: Problems Connecting to Pervasive SQL Database
Date Thu, 31 Jul 2008 14:02:06 GMT
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,  <tpoth@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 <david_jencks@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" <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
>> >
>>
>> --------------------------------------------------------------------------------------------------------------
>>
>
>
> --------------------------------------------------------------------------------------------------------------
> 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