This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
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 Java 8 in Action this week in the Java 8 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: 235
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: 29287
    
140

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: column exist but ResultSet.getString(String) return invalid column name
 
Similar Threads
resultset return null
invalid column type exception on Oracle db
case insensitive search in Oracle
Max length of string returned by Resultset
Data Retrieval problem from db to jsp.