wood burning stoves*
The moose likes JDBC and the fly likes SQL error codes for 'PostgreSQL' found Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL error codes for Watch "SQL error codes for New topic

SQL error codes for 'PostgreSQL' found

Tien Nguyen Doan

Joined: Mar 29, 2009
Posts: 8
Hi all,
I have created a connection for Postgres as below:

But i got an errror:

I don't know why Database product name cached for DataSource [org.springframework.jdbc.datasource.DriverManagerDataSource@acb158]: name is 'PostgreSQL'. My expected result is "library"

Thank you,

Tien Nguyen
Kuba Zygmunt
Ranch Hand

Joined: Jul 17, 2007
Posts: 37

I think you might read your error message wrongly.

The actual error is : The column name borrowedby was not found in this ResultSet.
Tien Nguyen Doan

Joined: Mar 29, 2009
Posts: 8
@Kuba Zygmunt:
I have read error carefully. But I don't understand why I cannot connect to "library" db in order to retrieve all records (select * from book). Data source is cached.
I agree. Here's the link: http://aspose.com/file-tools
subject: SQL error codes for 'PostgreSQL' found
Similar Threads
Error in executing Spring Query
Unable to call Ms-Access DB from Spring application?
MySQL Problem !!!
wild cards in MySQL using jdbc
Spring framework test case for DAO: No suitable driver