java.sql.SQLException: ERROR: parser: parse error at or near "s" at character 1409

Apereo Issues | Andrew Marangakis | 1 decade ago
  1. 0

    A single quote in a bookmarks title for the default user, i.e. demo, causes the following error for new user logins, causing no bookmark changes to be saved for these users. Removing the quote from the title fixes the problem. The database in use is postgresql: ERROR [Thread-30] root.[] May/14 10:15:18 - EXCEPTION: java.sql.SQLException: ERROR: parser: parse error at or near "s" at character 140 9 java.sql.SQLException: ERROR: parser: parse error at or near "s" at character 1409 at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:197) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:183) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:171) at org.jasig.portal.channels.bookmarks.CBookmarks.getDefaultBookmarks(CBookmarks.java:238) at org.jasig.portal.channels.bookmarks.CBookmarks.getBookmarkXML(CBookmarks.java:150) at org.jasig.portal.channels.bookmarks.CBookmarks.renderViewModeXML(CBookmarks.java:553) at org.jasig.portal.channels.bookmarks.CBookmarks.renderXML(CBookmarks.java:528) at org.jasig.portal.ChannelRenderer$Worker.run(ChannelRenderer.java:495) at org.jasig.portal.utils.threading.Worker.run(Worker.java:84)

    Apereo Issues | 1 decade ago | Andrew Marangakis
    java.sql.SQLException: ERROR: parser: parse error at or near "s" at character 1409
  2. 0

    A single quote in a bookmarks title for the default user, i.e. demo, causes the following error for new user logins, causing no bookmark changes to be saved for these users. Removing the quote from the title fixes the problem. The database in use is postgresql: ERROR [Thread-30] root.[] May/14 10:15:18 - EXCEPTION: java.sql.SQLException: ERROR: parser: parse error at or near "s" at character 140 9 java.sql.SQLException: ERROR: parser: parse error at or near "s" at character 1409 at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:197) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:183) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:171) at org.jasig.portal.channels.bookmarks.CBookmarks.getDefaultBookmarks(CBookmarks.java:238) at org.jasig.portal.channels.bookmarks.CBookmarks.getBookmarkXML(CBookmarks.java:150) at org.jasig.portal.channels.bookmarks.CBookmarks.renderViewModeXML(CBookmarks.java:553) at org.jasig.portal.channels.bookmarks.CBookmarks.renderXML(CBookmarks.java:528) at org.jasig.portal.ChannelRenderer$Worker.run(ChannelRenderer.java:495) at org.jasig.portal.utils.threading.Worker.run(Worker.java:84)

    Apereo Issues | 1 decade ago | Andrew Marangakis
    java.sql.SQLException: ERROR: parser: parse error at or near "s" at character 1409
  3. 0

    hibernate-4 jboss-4 configuration

    Stack Overflow | 2 years ago | stam
    java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF is no longer supported
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    hibernate-4 jboss-4 configuration

    dolinked.com | 1 year ago
    java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF is no longer supported
  6. 0

    java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460) - Grokbase

    grokbase.com | 1 year ago
    java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF is no longer supported

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ERROR: parser: parse error at or near "s" at character 1409

      at org.postgresql.core.QueryExecutor.execute()
    2. PostgreSQL JDBC Driver
      QueryExecutor.execute
      1. org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
      1 frame