JDBC on postgres

[Joe Williams]

I'm not able to connect Postgres 8.0 & the same code with change in the driver & URL runs for SQL server.



javax.servlet.ServletException: Backend start-up failed: FATAL: database "TestPG" does not exist.
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:523)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

org.postgresql.util.PSQLException: Backend start-up failed: FATAL: database "TestPG" does not exist.
org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:443)
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:98)
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:117)
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
org.postgresql.Driver.connect(Driver.java:235)
java.sql.DriverManager.getConnection(DriverManager.java:512)
java.sql.DriverManager.getConnection(DriverManager.java:171)
coreservlets.DBConnection.CreateConnection(DBConnection.java:25)
coreservlets.UserRegistrationAction.execute(UserRegistrationAction.java:34)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


This is my code for the DB connection.

 package coreservlets;
 
import java.sql.*;
import javax.sql.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 

public class DBConnection 
{
 
DBConnection(){}
 
public static String CreateConnection(String uname, String pword) throws Exception
{
 
Connection connection =null;
String username,password,connectionstatus="failure";
String url = "jdbc :-P	 ostgresql:TestPG";
username=uname;
password=pword;
 

Class.forName("org.postgresql.Driver");
connection=DriverManager.getConnection(url,"postgres", "arun");
 
System.out.println("Im in action before connection");
 
try
{
 
    System.out.println("Im in action after connection");
PreparedStatement preparedstatement = connection.prepareStatement("insert into demotable (Name,Age) values (?,?)");
preparedstatement.setString(1, username);
preparedstatement.setString(2, password);
System.out.println("Before Update");
preparedstatement.executeUpdate();
preparedstatement.close();
System.out.println("After Close");
connectionstatus="success";
 }
 
catch(Exception e)
{
System.out.println("Exception in Myprogram: "+e);
}
 
finally
{
 
connection.close();
}
 
return connectionstatus;
 
}
 

 
}
 

[Ulf Dittmer]

Are you certain that the local server contains a database called "TestPG"?

[Joe Williams]

I gave the wrong DB,

Here is the code still giving another error



java.lang.ClassNotFoundException: org.postgresql.Driver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1340)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1189)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at coreservlets.DBConnection.CreateConnection(DBConnection.java:24)
at coreservlets.UserRegistrationAction.execute(UserRegistrationAction.java:34)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

package coreservlets;
 
import java.sql.*;
import javax.sql.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 

public class DBConnection 
{
 
DBConnection(){}
 
public static String CreateConnection(String uname, String pword) throws Exception
{
 
Connection connection =null;
String username,password,connectionstatus="failure";
String url = "jdbc :-P	 ostgresql://localhost:5432/TestDB";
username=uname;
password=pword;
 

Class.forName("org.postgresql.Driver");
connection=DriverManager.getConnection(url,"postgres", "arun");
 
System.out.println("Im in action before connection");
 
try
{
 
    System.out.println("Im in action after connection");
PreparedStatement preparedstatement = connection.prepareStatement("insert into 
 
demotable (Name,Age) values (?,?)");
preparedstatement.setString(1, username);
preparedstatement.setString(2, password);
System.out.println("Before Update");
preparedstatement.executeUpdate();
preparedstatement.close();
System.out.println("After Close");
connectionstatus="success";
 }
 
catch(Exception e)
{
String status;
System.out.println("Exception in Myprogram: "+e);
status="Failure"+e;
 
connectionstatus=status;
}
 
finally
{
 
connection.close();
}
 
return connectionstatus;
 
}
 

 
}
 

 

[Jeanne Boyarsky]

Joe,
Now it looks like the driver isn't in the classpath. Can you show the classpath you are using?

[Joe Williams]

Thanks for your reply

Here is the classpath in my system variable

 
 
set Classpath=.;C:\Program Files\Apache Software Foundation\Tomcat 
5.0\common\lib\servlet-api.jar;C:\Program Files\Apache Software 
Foundation\Tomcat 5.0\webapps\MiniHR\WEB-INF\lib\struts.jar;C:\Program 
Files\Apache Software Foundation\Tomcat 
5.0\webapps\TestPost\WEB-INF\lib\postgresql-8.0-313.jdbc3.jar; 

[added line breaks so page doesn't wrap right so much]
[ October 20, 2005: Message edited by: Jeanne Boyarsky ]