wood burning stoves 2.0*
The moose likes JBoss/WildFly and the fly likes java.sql.SQLException: ORA-01830: date format picture ends before converting entire i 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 » Products » JBoss/WildFly
Bookmark "java.sql.SQLException: ORA-01830: date format picture ends before converting entire i" Watch "java.sql.SQLException: ORA-01830: date format picture ends before converting entire i" New topic
Author

java.sql.SQLException: ORA-01830: date format picture ends before converting entire i

shradha sharma
Greenhorn

Joined: Jan 09, 2007
Posts: 5
My java program running in Jboss server gives the exception

java.sql.SQLException: ORA-01830: date format picture ends before converting entire input string

coz am passing the Oracle driver dates as string that doesnt match with what the driver expects.

am using oracle.jdbc.driver.OracleDriver

I beleive by making some changs in the configuration files of Jboss we can overcome the same.
What needs to be done....? any idea.....?
shradha sharma
Greenhorn

Joined: Jan 09, 2007
Posts: 5
is there any change required with the driver or is it because of data corruption.

Should not be an issue with data corruption as am inserting sysdate into the date columns of my test data.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: java.sql.SQLException: ORA-01830: date format picture ends before converting entire i
 
Similar Threads
java.sql.SQLException: ORA-01830: date format picture ends before converting entire input string
Date Conversion in SQL
Passing sysdate as parameter to Oracle procedure
How to insert date in below format
Not able to convert string to date