File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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:
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