postgres connection using jsp

[keerthi malyala]

Hi all I am trying to connect to Postgres database using jsp at tomcat 5.5 server.can anyone help me out in this?I have added the jar file of postgres(postgresql-8.1-408.jdbc3.jar) in tomcat5.5\lib.But still iam gettting this errorIam getting this error when iam running this page.

my error is:

org.postgresql.util.PSQLException: Protocol error. Session setup failed.

my connection lines are:

Class.forName("org.postgresql.Driver");
dbcon = DriverManager.getConnection(loginUrl,loginUser,loginPasswd);

am i doing anything wrong? please Help me in this.

Thanking you,
Keerthi Malyala.

[Kamesh Rao]

can you please specify the login url you are using to connect.

[Bear Bibeault]

Please ask JDBC questions in the JSBC forum. I have moved this post there for you.

[siva sankar]

Hi,
You try once with this code...

Class.forName("org.postgresql.Driver");
Connection conn=DriverManager.getConnection("jdbc:postgresql://URL address/databasename","infinity","infinity");
Statement stmt=conn.createStatement();
ResultSet rs = stmt.executeQuery(qry);