Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-2945

Method org.postgresql.jdbc3.Jdbc3PreparedStatement.setQueryTimeout(int) is not yet implemented.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: EAP 5.0.0.CR4 (FCS and BETA2), EAP 5.0.0.CR5, EAP 5.0.0, 4.2.0.GA_CP08, 4.3.0.GA_CP07
    • Fix Version/s: TBD
    • Component/s: Hibernate
    • Labels:
      None
    • Environment:

      PostgreSQL 8.3.7

    • Affects:
      Release Notes
    • Release Notes Text:
      Hide
      <para>Setting the query timeout for a PreparedStatement is not supported by PostgreSQL 8.3.7. This limitation means that queries will fail if they use an annotation like the following:</para><para>
      <literal>@QueryHint(name = &quot;org.hibernate.timeout&quot;, value = &quot;100&quot;)</literal>.</para>
      Show
      <para>Setting the query timeout for a PreparedStatement is not supported by PostgreSQL 8.3.7. This limitation means that queries will fail if they use an annotation like the following:</para><para> <literal>@QueryHint(name = &quot;org.hibernate.timeout&quot;, value = &quot;100&quot;)</literal>.</para>
    • Release Notes Docs Status:
      Not Required

      Description

      the test of
      org.hibernate.test.annotations.query.QueryAndSQLTest.testCache
      org.hibernate.test.annotations.xml.ejb3.Ejb3XmlTest.testEjb3Xml
      fail on PostgreSQL 8.3.7 with these log messages below:
      org.hibernate.exception.GenericJDBCException: could not execute query
      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      at org.hibernate.loader.Loader.doList(Loader.java:2235)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
      at org.hibernate.loader.Loader.list(Loader.java:2124)
      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
      at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
      at org.hibernate.test.annotations.xml.ejb3.Ejb3XmlTest.testEjb3Xml(Ejb3XmlTest.java:30)
      at org.hibernate.test.annotations.TestCase.runTestMethod(TestCase.java:170)
      at org.hibernate.test.annotations.TestCase.runTest(TestCase.java:113)
      Caused by: org.postgresql.util.PSQLException: Method org.postgresql.jdbc3.Jdbc3PreparedStatement.setQueryTimeout(int) is not yet implemented.
      at org.postgresql.Driver.notImplemented(Driver.java:738)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.setQueryTimeout(AbstractJdbc2Statement.java:597)
      at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1605)
      at org.hibernate.loader.Loader.doQuery(Loader.java:696)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
      at org.hibernate.loader.Loader.doList(Loader.java:2232)

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                stliu Strong Liu
                Reporter:
                stliu Strong Liu
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: