aspose file tools*
The moose likes JDBC and the fly likes JDBC-PostgreSQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC-PostgreSQL" Watch "JDBC-PostgreSQL" New topic
Author

JDBC-PostgreSQL

sahidul karim
Greenhorn

Joined: Sep 19, 2006
Posts: 28
I am getting this error while ruuning an application. My database is in PostgreSQL 8.1 and "emp_info" is a table. I have postgresql-8.1-408.jdbc3.jar in WEB-INF/lib.What is the solution to remove this error?

org.postgresql.util.PSQLException: ERROR: relation "emp_info" does not e
xist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:1531)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1313)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:258)
Prabhu Venkatachalam
Ranch Hand

Joined: Nov 16, 2005
Posts: 502

Check in DB you are connecting to has emp_info table.

you will mention the DB(in bold) in JDBC URL:

jdbc:postgresql://host/database


Prabhu Venkatachalam<br />SCJP 1.4,SCWCD 1.4<br />prabhu.venkatachalam@gmail.com
sahidul karim
Greenhorn

Joined: Sep 19, 2006
Posts: 28
I have mention database name. database name is wisdb.
jdbc:postgresql://localhost:5432/wisdb
is it ok?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: JDBC-PostgreSQL