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
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.
 
jQuery in Action, 2nd edition
 
subject: java.sql.SQLException: ORA-01830: date format picture ends before converting entire i