Hi Robert,
Your first question:
Orion emulates the jdbc 2.0 functionality for you if you use
class="com.evermind.sql.ConnectionDataSource"
in data-sources.xml.
So you will get something like this :
<data-source
name="postgresql" {link to the database-schemas\postgresql.xml}
class="com.evermind.sql.ConnectionDataSource" {Orion jdbc2.0
emulator}
location="jdbc/postgreDS"
pooled-location="jdbc/postgrePooledDS"
xa-location="jdbc/xa/postgreXADS"
ejb-location="jdbc/postgreEJBDS"
url="jdbc:postgre:yourDB"
connection-driver="" {location (class and package of postgre
driver}
username="your_username"
password="your_password"
/>
Your second question:
Don't use getPooledConnection but use getConnection() because Datasource
doesn't have a method
getPooledConnection()
Hope this helps.
Greetings Wim Veninga
email : [EMAIL PROTECTED]
-----Original Message-----
From: Robert Balahura <[EMAIL PROTECTED]>
To: Orion-Interest <[EMAIL PROTECTED]>
Date: Thursday, July 27, 2000 10:14 AM
Subject: POSTGRES AND ORION NEWBIE QUESTION
>Hello,
>
>I just want to make sure I'm on the right track. I am trying to use Orion
>and Postgres SQL database together.
>
>Postgres does not have the JDBC 2.0 driver available so I am wondering how
>to configure the data-source.xml so ORION will take care of creating a
>connection pool for me.
>
>Secondly, I am unsure as to how to which method to call to obtain a
>connection from the connection pool from my program. getConnection() or
>getPooledConnection()??
>
>Any help would be greatly appreciated..
>
>Thank-you,
>
>Rob
>
>