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,
    • java.sql.SQLException: ORA-01403: no data found ORA-06512: at "APPS.POR_UTIL_PKG", line 385 ORA-06512: at line 1 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:2 89) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
    No Bugmate found.