Announcement Announcement Module
No announcement yet.
mysql and subselect fetching Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql and subselect fetching

    Disclaimer: I know this problem is Hibernate specific but I didn't find any reponse on the forum (there is topic reported since May in there unanswered :

    Conf: Spring 1.2.2, HN 3.0.5, MySQL 4.1.12, mysql-jdbc-3.1.10
    When using subselect as a fetching strategy to a collection inside a hb mapping I get the following exception:

    org.hibernate.exception.GenericJDBCException: could not load collection by subselect:
    Caused by: java.sql.SQLException: Statement parameter 1 not set.
    at com.mysql.jdbc.ServerPreparedStatement.serverExecu te(
    at com.mysql.jdbc.ServerPreparedStatement.executeInte rnal(
    at com.mysql.jdbc.PreparedStatement.executeQuery(Prep
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement .executeQuery(
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(Ab
    at org.hibernate.loader.Loader.getResultSet(Loader.ja va:1272)
    at org.hibernate.loader.Loader.doQuery( 1)
    at org.hibernate.loader.Loader.doQueryAndInitializeNo nLazyCollections(
    at org.hibernate.loader.Loader.loadCollectionSubselec t(
    Has anyone here encounter this problem and found a solution (other then disabling subselect fetching)?