database acrutecture advice please

Thread view:

Aza - 05 Nov 2004 04:48 GMT

hey all i was just after some advice on what would be a good way of setting
up my database connections
i am currently working on a work flow application that connects to a
database on a server. The number of users conecting to the database is
small say about 10... i was wondering what would be a good way to set this
up... at the moment each instance of the application connects to the
databse server. thought another idea would be to create an application
that runs on the server to process these requests and uses connection
pooling to access the database

Reply to this Message

Christian Kalkhoff - 07 Nov 2004 12:12 GMT

Hi Aza,

> hey all i was just after some advice on what would be a good way of setting
> up my database connections

I guess you mean in a POJO environment, not in container?

> i am currently working on a work flow application that connects to a
> database on a server. The number of users conecting to the database is
> small say about 10...

Shouldnt matter. :)

> i was wondering what would be a good way to set this
> up... at the moment each instance of the application connects to the
> databse server. thought another idea would be to create an application
> that runs on the server to process these requests and uses connection
> pooling to access the database

Have a look at http://jakarta.apache.org/commons/dbcp/. This package
provides the bases apache database pooling stuff also used in tomcat
application server. I havent yet worked directly with it, but perhaps it
is a pointer into the right direction for your problem.

Christian

Reply to this Message

database acrutecture advice please

Free Magazines