It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes connecting to postgresql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "connecting to postgresql" Watch "connecting to postgresql" New topic

connecting to postgresql

Simon Simbolon

Joined: Apr 15, 2010
Posts: 5
Please help.

Does anyone knows how to connect Java Apps to PostgreSQL using a class that implements javax.sql.DataSource?
I also needed the class to be able to accept jdbc url (eg. jdbc:postgresql://localhost/mydatabase) as input.
I'm currently working with a legacy system that kinda restrict connection with that condition.

I tried googling but can't seem to find class that support that condition.

Please help?
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33106

I don't follow. Does the class supplied with the postgresql driver not do that?

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Simon Simbolon

Joined: Apr 15, 2010
Posts: 5
Sorry for not being clear,

What I meant is that I needed a class in postgresql jdbc, I'm currently using postgresql-9.0-801.jdbc4.jar, that implement javax.sql.DataSource, so that I can get connection with code similar to this:

I've tried googling, but every class I found that implement javax.sql.DataSource, such as org.postgresql.ds.PGSimpleDataSource, can't take url as its input
So, any suggestion?

Thanks in advance
I agree. Here's the link:
subject: connecting to postgresql
It's not a secret anymore!