wood burning stoves*
The moose likes JDBC and the fly likes postgres connection using jsp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "postgres connection using jsp" Watch "postgres connection using jsp" New topic
Author

postgres connection using jsp

keerthi malyala
Greenhorn

Joined: Jul 14, 2006
Posts: 5
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

Joined: Dec 24, 2006
Posts: 35
can you please specify the login url you are using to connect.
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60774
    
  65

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


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
siva sankar
Ranch Hand

Joined: Jul 13, 2006
Posts: 68
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);
 
 
subject: postgres connection using jsp
 
Similar Threads
jdbc not bound
connection pooling problem
Coonection pooling problem.....
org.hsql.jdbcDriver
postgres connection using jsp