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

<div style="font-family:Arial, sans-serif; font-size:10pt;">I have used JSP with oracle . so i prefer to use JSP with
postgresql.I <br />have configured the JDBC driver for oracle .Is it ok if i use the same <br />for POSTGRESQL or
shouldi use configure, download and install a <br />seperate JDBC drive for that?? If so which drive should i use??iam
using<br />postgresql 8.1.4. The already configured jdbc is jdk 1.5. which JDBC <br />driver version should i use for
this.howdo i install, configure it and <br />use the driver. should i also include tomcat configuration with this? <br
/>howdo i change the postgresql.conf file.<br />   We have netbeans IDE to work with java . oracle. can the same IDE be
<br/>used for postgresql.<br />   your answer will be really helpful<br /> <br /> Thanks and regards<br /> subha.N <br
/> <br/><hr />I use Kify Mail - http://email.kify.com - Get your Kify Mail Account Today - Its Free, Fast, Easy, Secure
&Spam-Free.</div> 

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.

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