Home » Developer & Programmer » JDeveloper, Java & XML » Extraction Error (Java, SQL)
Extraction Error [message #415430] Mon, 27 July 2009 15:08 Go to next message
saramariemillr@aol.com
Messages: 1
Registered: July 2009
Junior Member
We got the following error when trying to do a data extraction from one application to another. See below:

java.sql.SQLException: ORA-01861: literal does not match format string

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:943)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2126)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:634)
at com.michelin.us.ttmsinterface.testrequest.mapping.TestRequestHome.queryBy(TestRequestHome.java:738)
at com.michelin.us.ttmsinterface.TtmsInterface.extractTest(TtmsInterface.java:238)
at com.michelin.us.ttmsinterface.TtmsInterface.extractAll(TtmsInterface.java:198)
at com.michelin.us.mtpxmlinterface.RealTimeExtract.<init>(RealTimeExtract.java:47)
at com.michelin.us.mtpxmlinterface.RealTimeExtract.main(RealTimeExtract.java:29)
end of Extract All
Re: Extraction Error [message #415431 is a reply to message #415430] Mon, 27 July 2009 15:18 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

01861, 00000, "literal does not match format string"
// *Cause:  Literals in the input must be the same length as literals in
//  the format string (with the exception of leading whitespace).  If the
//  "FX" modifier has been toggled on, the literal must match exactly,
//  with no extra whitespace.
// *Action: Correct the format string to match the literal.


You have the failing code & error message & can not determine what is wrong.

Think of the challenge we have to debug code we can not see.
Previous Topic: Putting method into ADF
Next Topic: Create new folder under web content
Goto Forum:
  


Current Time: Fri Mar 29 05:49:39 CDT 2024