Обсуждение: query using JDBC with postgresql

Поиск
Список
Период
Сортировка

query using JDBC with postgresql

От
"sahaanaa subha"
Дата:
I have used JSP with oracle . so i prefer to use JSP with postgresql. I
have configured the JDBC driver for oracle .Is it ok if i use the same
for POSTGRESQL or should i use configure, download and install a
seperate JDBC drive for that?? If so which drive should i use??iam using
postgresql 8.1.4. The already configured jdbc is jdk 1.5. which JDBC
driver version should i use for this.how do i install, configure it and
use the driver. should i also include tomcat configuration with this?
how do i change the postgresql.conf file.
   We have netbeans IDE to work with java . oracle. can the same IDE be
used for postgresql.
   your answer will be really helpful
 
 Thanks and regards
 subha.N
 

I use Kify Mail - http://email.kify.com - Get your Kify Mail Account Today - Its Free, Fast, Easy, Secure & Spam-Free.

Re: query using JDBC with postgresql

От
John R Pierce
Дата:
sahaanaa subha wrote:
> I have used JSP with oracle . so i prefer to use JSP with postgresql. I
> have configured the JDBC driver for oracle .Is it ok if i use the same
> for POSTGRESQL or should i use configure, download and install a
> seperate JDBC drive for that?? If so which drive should i use??

you need to use the Postgres JDBC driver to talk to Postgres.
per http://jdbc.postgresql.org/download.html for Postgres 8.1, you
should use
http://jdbc.postgresql.org/download/postgresql-8.1-408.jdbc3.jar

>
>    We have netbeans IDE to work with java . oracle. can the same IDE be
> used for postgresql.

sure, the IDE shouldn't matter at all.

Re: query using JDBC with postgresql

От
Andrew Sullivan
Дата:
First, please don't post HTML mail to the list.

On Sun, Feb 18, 2007 at 09:21:09PM -0800, sahaanaa subha wrote:

> <BR>have configured the JDBC driver for oracle .Is it ok if i use
> the same <BR>for POSTGRESQL or should i use configure, download and
> install a <BR>seperate JDBC drive for that?? If so which drive

You need a driver for PostgreSQL.  The Oracle one will of course not
work.  Go to http://jdbc.postgresql.org to get yours.  They're
precompiled, so you shouldn't need to do anything.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
"The year's penultimate month" is not in truth a good way of saying
November.
        --H.W. Fowler