java.sql.SQLException: ORA-01830: date format picture ends before converting ent

最新推荐文章于 2021-04-02 19:50:36 发布

mikyz

最新推荐文章于 2021-04-02 19:50:36 发布

阅读量1.9k

点赞数

本文链接：https://blog.csdn.net/mikyz/article/details/69397035

版权

本文介绍了一个关于Java应用程序中遇到的ORA-01830错误：dateformatpicture ends before converting entire input string的问题及解决方案。该问题是由于数据库日期格式与输入字符串不匹配导致，解决方案建议在查询时使用to_char()函数处理日期格式。

摘要由CSDN通过智能技术生成

java.sql.SQLException: ORA-01830: date format picture ends before converting ent
ire input string

        at oracle.jdbc.driver.DatabaseError.throwSqlException(Ljava.lang.String;
Ljava.lang.String;I)V(DatabaseError.java:125)
        at oracle.jdbc.driver.T4CTTIoer.processError(Z)V(T4CTTIoer.java:305)
        at oracle.jdbc.driver.T4CTTIoer.processError()V(T4CTTIoer.java:272)
        at oracle.jdbc.driver.T4C8Oall.receive()V(T4C8Oall.java:623)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(ZZZZ)V(T4CPreparedSta
tement.java:181)
        at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(Z)V(T4CPrepa
redStatement.java:543)
        at oracle.jdbc.driver.OracleStatement.execute_maybe_describe()V(OracleSt
atement.java:913)
        at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe()V(T4C
PreparedStatement.java:452)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout()V(OracleStat
ement.java:984)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal()I(OracleP
reparedStatement.java:2885)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery()Ljava.sql.Re
sultSet;(OraclePreparedStatement.java:2926)
        at weblogic.jdbc.wrapper.PreparedStatement.executeQuery()Ljava.sql.Resul
tSet;(PreparedStatement.java:124)
        at com.wss.user.session.UserManagerEJB.updateBuyerUserInfo(Lcom.wss.user
.general.UserDTListInfo;)Ljava.lang.String;(Unknown Source)
        at com.wss.user.session.UserManagerEJB_kyi0c6_EOImpl.updateBuyerUserInfo
(Lcom.wss.user.general.UserDTListInfo;)Ljava.lang.String;(UserManagerEJB_kyi0c6_
EOImpl.java:46)