Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 80423 invoked from network); 23 Jul 2008 16:32:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 23 Jul 2008 16:32:18 -0000 Received: (qmail 46927 invoked by uid 500); 23 Jul 2008 16:32:17 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 46650 invoked by uid 500); 23 Jul 2008 16:32:16 -0000 Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: user@geronimo.apache.org List-Id: Delivered-To: mailing list user@geronimo.apache.org Received: (qmail 46639 invoked by uid 99); 23 Jul 2008 16:32:16 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 Jul 2008 09:32:16 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [194.25.47.90] (HELO mail1.gmfoto.de) (194.25.47.90) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 Jul 2008 16:31:19 +0000 Received: by mail1.gmfoto.de (Postfix, from userid 1001) id 3B50726ECDC; Wed, 23 Jul 2008 18:27:48 +0200 (CEST) X-Spam-Checker-Version: SpamAssassin 3.2.1 (2007-05-02) on mail1.gmfoto.de X-Spam-Level: Received: from domino1.gmfoto.de (imap.gmfoto.de [192.168.2.2]) by mail1.gmfoto.de (Postfix) with ESMTP id 3D58926ECDB for ; Wed, 23 Jul 2008 18:27:46 +0200 (CEST) In-Reply-To: References: <001a01c8ec85$17c8cbe0$a20a0a0a@TOMMYT60p> X-Disclaimed: 53054 To: user@geronimo.apache.org MIME-Version: 1.0 Subject: Antwort: Re: Problems Connecting to Pervasive SQL Database X-KeepSent: 12A56CB1:0A5DEBCA-C125748F:00599A9F; type=4; name=$KeepSent X-Mailer: Lotus Notes Release 8.0.1 February 07, 2008 Message-ID: From: tpoth@gmfoto.de Date: Wed, 23 Jul 2008 18:30:10 +0200 X-MIMETrack: Serialize by Router on domino1/SERVER/GMFOTO/DE(Release 8.0.1|February 07, 2008) at 23.07.2008 18:31:10, Serialize complete at 23.07.2008 18:31:10 Content-Type: multipart/alternative; boundary="=_alternative 005AA713C125748F_=" X-Virus-Checked: Checked by ClamAV on apache.org X-Old-Spam-Status: No, score=-4.4 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00, HTML_MESSAGE autolearn=ham version=3.2.1 Dies ist eine mehrteilige Nachricht im MIME-Format. --=_alternative 005AA713C125748F_= Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Hi Lin, thanx for givin pervasive a chance to survive ;-) "Lin Sun" 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 - >=20 > - After you upload these files via admin console, what does these file > look like in the repository? They should be located somewhere under > geronimo=5Fhome/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=5Fhome/repository/com/pervasive/jdbc/v2/jpscs/1/jpscs-1.jar geronimo=5Fhome/repository/com/pervasive/jdbc/v2/pvjdbc2/1/pvjdbc2-1.jar geronimo=5Fhome/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. =20 > - 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 console.dbpool jdbc%2Frational 1.0 rar com.pervasive.jdbc.v2 jpscs 1 jar com.pervasive.jdbc.v2 pvjdbc2 1 jar com.pervasive.jdbc.v2 pvjdbc2x 1 jar =20 javax.sql.DataSource jdbc/rational com.pervasive.jdbc.v2.Driver jdbc:pervasive://srv-vm-w2k3-rat.gmfoto.de/RATIONAL<= /config-property-setting> 10 0 --- 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 =20 ---------------------------------------------------------------------------= ----------------------------------- GM-Foto GmbH, Taunusstra=DFe 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=E4ftsf=FChrer: Walter Adler und Harald Remsperger =D6ffnungszeiten: Montag - Freitag, 9:00 - 18:30 Uhr Internet: http://www.gmfoto.de , E-Mail: gmfoto@gmfoto.de ---------------------------------------------------------------------------= ----------------------------------- --=_alternative 005AA713C125748F_= Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable
Hi Lin,

thanx for givin pervasive a chance to survive ;-)

"Lin Sun" <linsun.unc@gmail.com> sch= rieb 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-Commer= ce 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=5Fhome/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=5Fhome/repository/com/pervasive/jdbc/v2/jps= cs/1/jpscs-1.jar
geronimo=5Fhome/repository/com/pervasive/jdbc/v2/pvj= dbc2/1/pvjdbc2-1.jar
geronimo=5Fhome/repository/com/pervasive/jdbc/v2/pvj= dbc2x/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=3D"1.0" encoding=3D"= UTF-8"?>
<connector xmlns=3D"htt= p://geronimo.apache.org/xml/ns/j2ee/connector-1.2">
    <dep:environment xmlns:dep=3D"= http://geronimo.apache.org/xml/ns/deployment-1.2">
        <dep:moduleId>
            <dep:gr= oupId>console.dbpool</dep:groupId>
            <dep:ar= tifactId>jdbc%2Frational</dep:artifactId>
            <dep:ve= rsion>1.0</dep:version>
            <dep:ty= pe>rar</dep:type>
        </dep:moduleId>
        <dep:dependencies>=
            <dep:de= pendency>
              &nb= sp; <dep:groupId>com.pervasive.jdbc.v2</dep:groupId>
              &nb= sp; <dep:artifactId>jpscs</dep:artifactId>
              &nb= sp; <dep:version>1</dep:version>
              &nb= sp; <dep:type>jar</dep:type>
            </dep:d= ependency>
            <dep:de= pendency>
              &nb= sp; <dep:groupId>com.pervasive.jdbc.v2</dep:groupId>
              &nb= sp; <dep:artifactId>pvjdbc2</dep:artifactId>
              &nb= sp; <dep:version>1</dep:version>
              &nb= sp; <dep:type>jar</dep:type>
            </dep:d= ependency>
            <dep:de= pendency>
              &nb= sp; <dep:groupId>com.pervasive.jdbc.v2</dep:groupId>
              &nb= sp; <dep:artifactId>pvjdbc2x</dep:artifactId>
              &nb= sp; <dep:version>1</dep:version>
              &nb= sp; <dep:type>jar</dep:type>
            </dep:d= ependency>
        </dep:dependencies>= ;
    </dep:environment>
    <resourceadapter>
        <outbound-resourceada= pter>
            <connec= tion-definition>
              &nb= sp; <connectionfactory-interface>javax.sql.DataSource</connectionfacto= ry-interface>
              &nb= sp; <connectiondefinition-instance>
              &nb= sp;     <name>jdbc/rational</name>
              &nb= sp;     <config-property-setting name=3D"Driver">com.= pervasive.jdbc.v2.Driver</config-property-setting>
              &nb= sp;     <config-property-setting name=3D"ConnectionURL"&= gt;jdbc:pervasive://srv-vm-w2k3-rat.gmfoto.de/RATIONAL</config-property-= setting>
              &nb= sp;     <connectionmanager>
              &nb= sp;         <local-transaction/>
              &nb= sp;         <single-pool>
              &nb= sp;             <max-size>10</max-size&g= t;
              &nb= sp;             <min-size>0</min-size>= ;
              &nb= sp;             <match-one/>
              &nb= sp;         </single-pool>
              &nb= sp;     </connectionmanager>
              &nb= sp; </connectiondefinition-instance>
            </conne= ction-definition>
        </outbound-resourcead= apter>
    </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=DFe 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=E4ftsf=FChrer: Walter Adler und Harald Remsperger

=D6ffnungszeiten: Montag - Freitag, 9:00 - 18:30 Uhr

Internet: http://www.gmfoto.de , E-Mail: gmfoto@gmfoto.de
---------------------------------------------------------------------------= ----------------------------------- --=_alternative 005AA713C125748F_=--