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.

  • PostgresSQL support for JMS
    via by Jerome O'Neil,
  • hibernate-4 jboss-4 configuration
    via Stack Overflow by stam
    ,
  • JBoss Community / Mailing Lists
    via by Unknown author,
  • hibernate-4 jboss-4 configuration
    via by Unknown author,
  • Connecting to PostGres
    via oreports by mattheww99
    ,
  • 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)
    via by Andrew Marangakis,
    • java.sql.SQLException: ERROR: parser: parse error at or near "$$" at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94) at org.postgresql.Connection.ExecSQL(Connection.java:398) at org.postgresql.jdbc2.Statement.execute(Statement.java:130) at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54) at org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:99) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:83) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:631) at net.sf.hibernate.loader.Loader.doResultSet(Loader.java:166) at net.sf.hibernate.loader.Loader.doFind(Loader.java:111)
    No Bugmate found.