best way to handle db connection

[uthpalaw]

Hi, i'm going to create a client app using java, i need to know whether there is a better method (framework) to handle the database.

i'm using ejb when i'm working with j2ee app, but i don't know if there is a better ( efficient ) method for client applications to work with db. Please advice.

Thanks

[Tolls]

What do you mean by a client app?

[doWhile]

The advantage of creating a 3(+)-tier, EJB based server side application is that the client doesn't need to directly 'work with db'. When that logic is server side, clients don't get crudded up with code that makes it harder to maintain in the long run.

[uthpalaw]

Just a desktop application, not a web application, so i'm not going to run any application servers(tomcat, jboss). Therefore i won't be able to use ejb. I think im correct, am I ?

[doWhile]

Therefore i won't be able to use ejb. I think im correct, am I ?

You tell us. You mentioned you use(d) an ejb J2EE application, if this is already developed for the same data source then why re-invent the wheel in the client. But as Tolls alluded to, you haven't provided much information to give specifics.

[uthpalaw]

No, this is a totally different system.

[Tolls]

Design decisions cannot be made based on such a small amount of info.

Is the database going to be shared between instances of this app?
If not, then is the database going to be fairly small?
If it is shared then is it shared with any other apps?

You have to provide us with informationon which the base our advice.

[uthpalaw]

Yes, database is going to be shared between instances of this app.
No, it will not be shared with any other applications.

only this application will communicate with the db.

[Tolls]

So there is already a server involved.
The one with the db on it.

I would stick some server code in front of that that handles db interactions personally. Have your app interact with that.

[ora.adf]

you must add JDBC driver to your project to connect to db directly without any additional layer .

[uthpalaw]

sorry Tolls, i didn't get u.

What's the server involved with db ?

[Tolls]

sorry Tolls, i didn't get u.

What's the server involved with db ?

You said:

Yes, database is going to be shared between instances of this app.

That means multiple instances of your app will be talking to the same db.
That implies (since you haven't explained anything else about your app) that the db is central and that implies it's on a server.

You have to realise we do not know your system so are reduced to guesswork when you don't provide us with enough information.