0 Replies Latest reply on Jan 29, 2007 3:10 AM by paata lominadze

    Timestem and jdbc Query Timeout

    paata lominadze Master

      hi all,
      i have install timesten on one computer and configure there Query Timeout like This:

      SQLQueryTimeout = 80

      and i have JBoss Application Server on another computer and timesten client.
      i've timesten-xa-ds.xml configuration file configured like this :

      <set-tx-query-timeout>
      <query-timeout>50000</query-timeout>
      <set-tx-query-timeout>
      


      and when i tryed to execute sql command i get an error:

      14:19:13,342 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: S1000
      14:19:13,344 ERROR [JDBCExceptionReporter] [TimesTen][TimesTen 6.0.4 CLIENT]Query Timeout must be numeric, greater than or equal to 0, and less than the Network Timeout
      14:19:13,346 ERROR [STDERR] javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
      14:19:13,346 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:567)
      14:19:13,346 ERROR [STDERR] at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:56)
      14:19:13,347 ERROR [STDERR] at com.magti.businesslayer.ejb3Fasade.srvprov.MobileServiceFasadeBean.simChange(MobileServiceFasadeBean.java:1381)
      


      can anybody help me ? :(