This week's book giveaway is in the Agile forum.
We're giving away four copies of The Software Craftsman and have Sandro Mancuso on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes JDBC-PostgreSQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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?
 
Have you tried LearnNowOnline? http://www.learnnowonline.com/
 
subject: JDBC-PostgreSQL