Re: [GENERAL] preoblem in jdbc postgresql and tomcat
Hi,
I see 2 jdbc version in your classpath pg73jdbc3.jar and
pg74.215.jdbc3.jar.
For Tomcat you just have to drop the jdbc Jar file in
/usr/local/jakarta-tomcat-4.1.31/common/lib
No classpath to change.. Nothing.
After create an entry in Server.xml or create a Context.xml to define your
datasource. See Tomcat Doc.
Works oki for me
/David
java unix wrote:
hi,
i have installed postgresql-7.4.1,and tomcat4.1.31and
j2sdk1.4.2_07
for tomcat i have included path
/usr/local/jakarta-tomcat-4.1.31
for j2sdk path set is /usr/local/j2sdk1.4.2_07
and CLASSPATH SET IS:
/usr/local/pgsql/pg73jdbc3.jar:/usr/local/pgsql/pg74.215.jdbc3.jar:/usr/local/pg
sql/postgresql-8.0-310.jdbc3.jar:/usr/local/j2sdk1.4.2_07/lib/tools.jar:/usr/loc
al/j2sdk1.4.2_07/jre/lib/rt.jar:/usr/local/jakarta-tomcat-4.1.31/common/lib/serv
let.jar:/usr/local/jakarta-tomcat-4.1.31/common/lib:/usr/local/pgsql:/usr/local/
j2sdk1.4.2_07/jre/lib:/usr/local/j2sdk1.4.2_07/lib
i have included all the paths
all the above path are set in /etc/profile/
and i set path for all three jar
files:/usr/local/pgsql/pg73jdbc3.jar:/usr/local/pgsql/pg74.215.jdbc3.jar:/usr/local/pg
sql/postgresql-8.0-310.jdbc3.jar
when i run this simple java program i get
error as follows:
[EMAIL PROTECTED] bin]# javac PostgreSQLTest.java//compile
PostgreSQLTest.java: In class `PostgreSQLTest':
PostgreSQLTest.java: In method
`PostgreSQLTest.main(java.lang.String[])':
PostgreSQLTest.java:7: Exception
`java.lang.ClassNotFoundException' must be caught, or
it must be declared in the `throws' clause of `main'.
Class.forName(postgresql.Driver).newInstance();
^
PostgreSQLTest.java:7: Exception
`java.lang.InstantiationException' must be caught, or
it must be declared in the `throws' clause of `main'.
Class.forName(postgresql.Driver).newInstance();
^
PostgreSQLTest.java:7: Exception
`java.lang.IllegalAccessException' must be caught, or
it must be declared in the `throws' clause of `main'.
Class.forName(postgresql.Driver).newInstance();
my PostgreSQLTest.java is as below
import java.sql.*;
class PostgreSQLTest {
public static void main (String[] args) {
try {
Driver driver = (Driver)
Class.forName(postgresql.Driver).newInstance();
DriverManager.registerDriver(driver);
String url = jdbc:postgresql:javatest;
Connection con =
DriverManager.getConnection(url, postgres, );
Statement stm = con.createStatement();
stm.setQueryTimeout(10);
ResultSet rs = stm.executeQuery(select col1
from test);
rs.next();
System.out.println(rs.getString(1));
} catch (SQLException e) {
System.out.println(Exception!);
System.out.println(e.toString());
}
}
}
This is one simple example
Now when i tried to perform operations with tomcat
simple sevlet works but with database operations i get
the following errors
file is:ShowBedrock.java
import javax.servlet.*;
import javax.servlet.http.*;
public class ShowBedrock extends HttpServlet
{
public String getServletInfo()
{
return Servlet connects to PostgreSQL database
and displays result of a SELECT;
}
private Connection dbcon; // Connection for scope
of ShowBedrock
// init sets up a database connection
public void init(ServletConfig config) throws
ServletException
{
String loginUser = postgres;
String loginPasswd = roopesh;
String loginUrl =
jdbc:postgresql://localhost/bedrock;
// Load the PostgreSQL driver
try
{
Class.forName(org.postgresql.Driver);
dbcon =
[GENERAL] preoblem in jdbc postgresql and tomcat
hi,
i have installed postgresql-7.4.1,and tomcat4.1.31and
j2sdk1.4.2_07
for tomcat i have included path
/usr/local/jakarta-tomcat-4.1.31
for j2sdk path set is /usr/local/j2sdk1.4.2_07
and CLASSPATH SET IS:
/usr/local/pgsql/pg73jdbc3.jar:/usr/local/pgsql/pg74.215.jdbc3.jar:/usr/local/pg
sql/postgresql-8.0-310.jdbc3.jar:/usr/local/j2sdk1.4.2_07/lib/tools.jar:/usr/loc
al/j2sdk1.4.2_07/jre/lib/rt.jar:/usr/local/jakarta-tomcat-4.1.31/common/lib/serv
let.jar:/usr/local/jakarta-tomcat-4.1.31/common/lib:/usr/local/pgsql:/usr/local/
j2sdk1.4.2_07/jre/lib:/usr/local/j2sdk1.4.2_07/lib
i have included all the paths
all the above path are set in /etc/profile/
and i set path for all three jar
files:/usr/local/pgsql/pg73jdbc3.jar:/usr/local/pgsql/pg74.215.jdbc3.jar:/usr/local/pg
sql/postgresql-8.0-310.jdbc3.jar
when i run this simple java program i get
error as follows:
[EMAIL PROTECTED] bin]# javac PostgreSQLTest.java//compile
PostgreSQLTest.java: In class `PostgreSQLTest':
PostgreSQLTest.java: In method
`PostgreSQLTest.main(java.lang.String[])':
PostgreSQLTest.java:7: Exception
`java.lang.ClassNotFoundException' must be caught, or
it must be declared in the `throws' clause of `main'.
Class.forName(postgresql.Driver).newInstance();
^
PostgreSQLTest.java:7: Exception
`java.lang.InstantiationException' must be caught, or
it must be declared in the `throws' clause of `main'.
Class.forName(postgresql.Driver).newInstance();
^
PostgreSQLTest.java:7: Exception
`java.lang.IllegalAccessException' must be caught, or
it must be declared in the `throws' clause of `main'.
Class.forName(postgresql.Driver).newInstance();
my PostgreSQLTest.java is as below
import java.sql.*;
class PostgreSQLTest {
public static void main (String[] args) {
try {
Driver driver = (Driver)
Class.forName(postgresql.Driver).newInstance();
DriverManager.registerDriver(driver);
String url = jdbc:postgresql:javatest;
Connection con =
DriverManager.getConnection(url, postgres, );
Statement stm = con.createStatement();
stm.setQueryTimeout(10);
ResultSet rs = stm.executeQuery(select col1
from test);
rs.next();
System.out.println(rs.getString(1));
} catch (SQLException e) {
System.out.println(Exception!);
System.out.println(e.toString());
}
}
}
This is one simple example
Now when i tried to perform operations with tomcat
simple sevlet works but with database operations i get
the following errors
file is:ShowBedrock.java
import javax.servlet.*;
import javax.servlet.http.*;
public class ShowBedrock extends HttpServlet
{
public String getServletInfo()
{
return Servlet connects to PostgreSQL database
and displays result of a SELECT;
}
private Connection dbcon; // Connection for scope
of ShowBedrock
// init sets up a database connection
public void init(ServletConfig config) throws
ServletException
{
String loginUser = postgres;
String loginPasswd = roopesh;
String loginUrl =
jdbc:postgresql://localhost/bedrock;
// Load the PostgreSQL driver
try
{
Class.forName(org.postgresql.Driver);
dbcon =
DriverManager.getConnection(loginUrl, loginUser,
loginPasswd);
}
catch (ClassNotFoundException ex)
{
System.err.println(ClassNotFoundException: +
ex.getMessage());
throw new ServletException(Class not
found Error);
}
catch (SQLException ex)
