Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

SQL error codes for 'PostgreSQL' found

 
Tien Nguyen Doan
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
@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.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!