About
I’m a father, a cycling junkie, and also a software developer. I’m mostly using this site as a location to store all of my development notes and tips. But from time to time, I’ll have an interesting bike or kid story that just hast to be told.
I’m a father, a cycling junkie, and also a software developer. I’m mostly using this site as a location to store all of my development notes and tips. But from time to time, I’ll have an interesting bike or kid story that just hast to be told.
softwarefreak said
Can you please elaborate on the work you have on the hsql stored procedure?
Appreciate it.
weiquan said
hi, doublaA:
sorry to bother you. really appreciate that you shared your development experience on hsql + hibernate. but I have the similar problem. Could you give me a hand?
=============================
hi, anyone use hibernate to call sp in hsqldb instead of using j2se
API executeQuery()?
when I using hibernate + hsqldb to call sp, I got the error
===========================
by: java.sql.SQLException: Unknown JDBC escape sequence: { ? = call
RT_BL_EMPLOYEE_LIFERATE(‘M’,'25′) }
at org.hsqldb.jdbc.jdbcConnection.onStartEscapeSequence(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.nativeSQL(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
at org.hsqldb.jdbc.jdbcCallableStatement.(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareCall(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:502)
at org.hibernate.jdbc.AbstractBatcher.prepareCallableQueryStatement(AbstractBatcher.java:156)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1543)
at org.hibernate.loader.Loader.doQuery(Loader.java:673)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2213)
… 53 more
===================================================
here is my sql-query configuration
——————————————————————————————–
{ ? = call RT_BL_EMPLOYEE_LIFERATE(‘M’,'25′) }
———————————————————-
here is my code to call sp
—————————————————
Query query = getSession(true).getNamedQuery(“selectBLEmployeesLifeRate_SP”);
———————————————————————————————————
any wrong ?
========================================