Home » Developer & Programmer » JDeveloper, Java & XML » Extraction Error (Java, SQL)
Extraction Error [message #415430] Mon, 27 July 2009 15:08 Go to next message
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
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
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 Sep 17 18:42:01 CDT 2021