Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC-PostgreSQL

 
sahidul karim
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 502
Java jQuery Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
sahidul karim
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have mention database name. database name is wisdb.
jdbc:postgresql://localhost:5432/wisdb
is it ok?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic