aspose file tools
The moose likes JBoss 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
Register / Login
JavaRanch » Java Forums » Products » JBoss
Reply 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.
 
I agree. Here's the link: jrebel
 
subject: java.sql.SQLException: ORA-01830: date format picture ends before converting entire i
 
Similar Threads
Date Conversion in SQL
Not able to convert string to date
How to insert date in below format
java.sql.SQLException: ORA-01830: date format picture ends before converting entire input string
Passing sysdate as parameter to Oracle procedure