Hi,

We are using the Spring with Hibernate to develop the application.

The problem we got with the execution of hibernate query.

Problem occurs when the user enters ‘\’ in any text field and the same data is passed to hibernate.

This requires bringing down jboss and bringing it up.

The following stack trace shows the error ..


21:13:24,088 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 42601
21:13:24,089 ERROR [JDBCExceptionReporter] ERROR: unterminated quoted string at or near "'gmoore\' )"
21:13:24,089 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 42601
21:13:24,089 ERROR [JDBCExceptionReporter] ERROR: unterminated quoted string at or near "'gmoore\' )"
21:13:24,089 ERROR [JDBCExceptionReporter] Could not execute query
java.sql.SQLException: ERROR: unterminated quoted string at or near "'gmoore\' )"
at com.edb.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2057)
at com.edb.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1700)
at com.edb.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:416)
at com.edb.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:432)
at com.edb.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:364)
at com.edb.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:270)


Thanks & Regards.
Murthy