File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: ORA-01830: date format picture ends before converting entire i
 
Similar Threads
How to insert date in below format
Passing sysdate as parameter to Oracle procedure
Not able to convert string to date
Date Conversion in SQL
java.sql.SQLException: ORA-01830: date format picture ends before converting entire input string