This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes SQL error 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 "SQL error" Watch "SQL error" New topic
Author

SQL error

Ravi Harishchandra
Greenhorn

Joined: Oct 29, 2012
Posts: 17
Hi... I'm trying to retrieve the records whose check out dates match with the system date(A hotel room reservation software). But I'm getting the following error java.sql.SQLException: ORA-01722: invalid number

The CODE:::
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  60

I've added code tags to your post (it does look much better this way) - you can do so yourself, but avoid using other formatting tools (such as colors) in code, it is not supported.

What is the data type of the CUST_TO column? Based on the exception, I'd say it is a NUMBER, so it doesn't even make sense to compare it to a date.

If you really want to put in a date, you should use PreparedStatement. Actually, Rob has already told you so, so please follow the good advice when given to you. This page says why using PreparedStatement is critical, and the JDBC tutorial can help you doing so.

Please read both of these pages (and the complete JDBC tutorial, if you haven't done so yet) before you try to write another database code - it will help you avoid many database-related problems. Of course, if something is unclear to you in the tutorial, feel free to ask questions here - we'll happily answer questions from people that read tutorials

chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1617
    
  13

Just one extra point to add to Martin's excellent advice:

You appear to be using your SYSTEM schema to hold these user tables. Do not do this. You should create a separate user schema for your application tables, and connect to the DB using that. The SYSTEM user has all kinds of extra privileges that you really do not want your application users to have access to. Also, until your run your application with the right user you cannot be sure you have set up access privileges etc properly.


No more Blub for me, thank you, Vicar.
 
jQuery in Action, 2nd edition
 
subject: SQL error
 
Similar Threads
Groovy vs. Ruby
1000 characters
groovy and javafx
best IDEs, editors for Groovy/Grails?