driver for jsp

[nehashri]

Hi,
I am using postgresql 8.1 an I am trying to connect to the postsql from
JSP and servlets but I cannot find the driver name for the postgresql so I
can use it in the jsp connection. i hv been sujjested to use jdbc but cannt find advantage of jdbc over odbc.

I would appreciate your help.

Thanks,
neha

[masijade]

Even when you use odbc, from Java, you are using jdbc (it is called the jdbc-odbc bridge for a reason). And the advantage of using a real driver over the odbc one, is that the odbc driver is severly limited (and, if I remember right, not even thread safe, which it would need to be to be reliably abd safely used in a servlet or JSP).

For a real Driver try here:

http://jdbc.postgresql.org/

And read it's documentation after downloading it.

[nehashri]

thnx so much for the quick response...but this will not effect if in linux plateform rt?????
thnx again

[masijade]

thnx so much for the quick response...but this will not effect if in linux plateform rt?????
thnx again

What do you mean by this (the bold part)? I have no idea what you are asking, especially when combined with your earlier wish to use odbc. You do realize that odbc would only work on Windows, right? Unless, maybe, you have some special Linux kernel module that I know nothing of.

The JDBC drivers are simple Java jarfiles. They depend on, unless otherwise explicitly stated, only the JRE or JDK. So, as long as you have a JRE or JDK (which will contain a JRE) installed, a downloaded JDBC driver will work, regardless of the OS platform.

[nehashri]

i had querry is my dission for optin jdbc correct. i hv been asked to justify my choice i wantted to knw adv of jdbc over odbc never wished to use odbc.......... n ya sorry i forgot to mention jdbc along with os Q. i ment abt the jdbc in linux. again thnx 4 ur help

[masijade]

Well, then, if you need to justify your decision to use a real JDBC Driver instead of the JDBC-ODBC Bridge, and you are using JSP/Servlet on Linux, you essentially don't need one. As mentioned, ODBC is, probably, not even available on your Linux system, and the JDBC-ODBC Bridge is not thread safe, and so not suited for Servlet/JSP in the first place.

[nehashri]

yap that was good thnx. tc

[jwenting]

if you need to justify your decision not to use the bridge driver, read the documentation that comes with the JDK. It contains an excellent reason.
There are of course many more, but that one alone should be sufficient for anyone.

[nehashri]

yap thnx jwenting that will b fyn