jQuery in Action, 2nd edition*
The moose likes JDBC and the fly likes column exist but ResultSet.getString(String) return invalid column name    Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "column exist but ResultSet.getString(String) return invalid column name    " Watch "column exist but ResultSet.getString(String) return invalid column name    " New topic
Author

column exist but ResultSet.getString(String) return invalid column name

Reda Mokrane
Ranch Hand

Joined: Jul 25, 2001
Posts: 237
With oracle 7 db the ResultSet.getString(String) works fine but after the upgrade to oracle 8 db it return invalid column name. ResultSet.getString(int) method works fine.
Is this a bug in the driver?



Thanks for any help
-Reda
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30123
    
150

Reda,
Can you post the DDL and failing Java statement? I suspect Oracle's validations got more strict in Oracle 8.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: column exist but ResultSet.getString(String) return invalid column name
 
Similar Threads
Max length of string returned by Resultset
resultset return null
invalid column type exception on Oracle db
case insensitive search in Oracle
Data Retrieval problem from db to jsp.