• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

postgres connection using jsp

 
keerthi malyala
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
can you please specify the login url you are using to connect.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64613
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please ask JDBC questions in the JSBC forum. I have moved this post there for you.
 
siva sankar
Ranch Hand
Posts: 68
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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);
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic