OraFAQ Forum: JDeveloper, Java & XML

Home » Developer & Programmer » JDeveloper, Java & XML » Extraction Error (Java, SQL)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Extraction Error [message #415430]

Mon, 27 July 2009 15:08

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

Report message to a moderator

Re: Extraction Error [message #415431 is a reply to message #415430]

Mon, 27 July 2009 15:18

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.

Report message to a moderator

Previous Topic:	Putting method into ADF
Next Topic:	Create new folder under web content

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 06:02:38 CST 2024