java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • On Thu, 2005-03-03 at 08:07 -0600, Dan Duensing wrote: In our nearing upgrade to uPortal2.4 we have greatly increased the number of bookmarks avaliable to the user. When testing this, I believe the length of BOOKMARK_XML is exceeding the max of the LONG datatype. We are getting the ORACLE SQL error below when it tries to INSERT to UPC_BOOKMARKS and no bookmarks are saved for the user in that table. Has anyone else encountered this and come up with a resolution? ERROR [uPortal thread pool worker #9] jasig.portal.[] Mar/02 17:11:28 - java.sql.SQLException: ORA-01704: string literal too long java.sql.SQLException: ORA-01704: string literal too long 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.parseExecuteFetch(TTC7Protocol.java:862) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1839) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1764) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2354) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:858) at org.jasig.portal.channels.CBookmarks.getDefaultBookmarks(CBookmarks.java:238) at org.jasig.portal.channels.CBookmarks.getBookmarkXML(CBookmarks.java:150) at org.jasig.portal.channels.CBookmarks.renderViewModeXML(CBookmarks.java:553) at org.jasig.portal.channels.CBookmarks.renderXML(CBookmarks.java:528) at org.jasig.portal.ChannelRenderer$Worker.run(ChannelRenderer.java:528) at org.jasig.portal.utils.threading.Worker.run(Worker.java:88) Has anyone else encountered this and come up with a resolution? Dan Duensing Internet Development KU Medical Center 913-588-7402
    via by Brad Johnson,
  • On Thu, 2005-03-03 at 08:07 -0600, Dan Duensing wrote: In our nearing upgrade to uPortal2.4 we have greatly increased the number of bookmarks avaliable to the user. When testing this, I believe the length of BOOKMARK_XML is exceeding the max of the LONG datatype. We are getting the ORACLE SQL error below when it tries to INSERT to UPC_BOOKMARKS and no bookmarks are saved for the user in that table. Has anyone else encountered this and come up with a resolution? ERROR [uPortal thread pool worker #9] jasig.portal.[] Mar/02 17:11:28 - java.sql.SQLException: ORA-01704: string literal too long java.sql.SQLException: ORA-01704: string literal too long 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.parseExecuteFetch(TTC7Protocol.java:862) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1839) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1764) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2354) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:858) at org.jasig.portal.channels.CBookmarks.getDefaultBookmarks(CBookmarks.java:238) at org.jasig.portal.channels.CBookmarks.getBookmarkXML(CBookmarks.java:150) at org.jasig.portal.channels.CBookmarks.renderViewModeXML(CBookmarks.java:553) at org.jasig.portal.channels.CBookmarks.renderXML(CBookmarks.java:528) at org.jasig.portal.ChannelRenderer$Worker.run(ChannelRenderer.java:528) at org.jasig.portal.utils.threading.Worker.run(Worker.java:88) Has anyone else encountered this and come up with a resolution? Dan Duensing Internet Development KU Medical Center 913-588-7402
    via by Brad Johnson,
  • Strings > 4000 to CLOB conversion using hibernate
    via by Unknown author,
    • java.sql.SQLException: ORA-20000: Oracle Ultra Search errorWKG-10602: Instance does not exist ORA-06512: at "WKSYS.WK_ERR", line 179 ORA-06512: at line 1at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:185) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:241) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)

    Users with the same issue

    rp
    1 times, last one,
    Unknown visitor1 times, last one,