Thread: JDBC for DataSource and Connection Pooling

JDBC for DataSource and Connection Pooling

From
Dan
Date:
Hi,

I am trying to get Postgres 7.2.2 to work with JBOSS 3.0.4,  TOMCAT
4.0.6, and JDK 1.4 all running on Redhat 8.0. I downloaded the JDBC
driver for for 7.2 and noticed javax was not in there, so since there
will be no DataSource object I will not be able to use the JBOSS
connection factory. Can you tell me what JDBC driver I could use to get
this scenario functioning. Connection pooling is critical for me.  I did
notice that one of your drivers does support javax.  I am willing to
change whatever I have to, to get this to work, so tell me what will
play nice together and I will impliment it. I have successfully gotten
this to work with Oracle 9i but don't really have the funds to support
that architecture. Give me your words of wisdom and I will be greatly
appreciative.

Thanks,

DG


Re: JDBC for DataSource and Connection Pooling

From
Michael Ansley
Date:
Hi,

You need to either obtain an enterprise version of the binary, or compile from
CVS and ensure that you compile the enterprise version.  This will ensure
that you get a proper DataSource class.  Read the notes regarding compiling
the enterprise version.  If you are compiling this for a production
environment, amke sure that you get a production version from CVS.

Cheers...


MikeA


On Thursday 28 November 2002 17:30, Dan wrote:
> Hi,
>
> I am trying to get Postgres 7.2.2 to work with JBOSS 3.0.4,  TOMCAT
> 4.0.6, and JDK 1.4 all running on Redhat 8.0. I downloaded the JDBC
> driver for for 7.2 and noticed javax was not in there, so since there
> will be no DataSource object I will not be able to use the JBOSS
> connection factory. Can you tell me what JDBC driver I could use to get
> this scenario functioning. Connection pooling is critical for me.  I did
> notice that one of your drivers does support javax.  I am willing to
> change whatever I have to, to get this to work, so tell me what will
> play nice together and I will impliment it. I have successfully gotten
> this to work with Oracle 9i but don't really have the funds to support
> that architecture. Give me your words of wisdom and I will be greatly
> appreciative.
>
> Thanks,
>
> DG
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html