Timestem and jdbc Query Timeout

grdzeli_kaci · **Joined:** Tue Jan 17, 2006 6:16 am **Posts:** 31

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 :

Code:

<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:

Code:

19:13,342 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: S1000
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
19:13,346 ERROR [STDERR] javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
19:13,346 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:567)
19:13,346 ERROR [STDERR] at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:56)
19:13,347 ERROR [STDERR] at com.magti.businesslayer.ejb3Fasade.srvprov.MobileServiceFasadeBean.simChange(MobileServiceFasadeBean.java:1381)

can anybody help me ? :(

grdzeli_kaci · **Joined:** Tue Jan 17, 2006 6:16 am **Posts:** 31

this is a entity manager bug, when i change my session bean and did look up for connection and try execute sql command by the preparestatement it work, there for this is entity manager bug.

Code:

Query query = timeStenManager      .createNamedQuery("Subscriberserviceparameter.getSubsSrvParameters");
         query = query.setParameter("subsId", new Integer(100000250));
         query = query.setParameter("srvId", new Integer(1));
         query = query.setParameter("pvalue", "8999597280500048477F");
         List<Subscriberserviceparameter> list = query.getResultList();

there was an error but when i change this :

Code:

 @Resource(mappedName="java:/TimesTenXAClientDS") DataSource
myTestDB;   
............................................

 Connection con = myTestDB.getConnection();
                        PreparedStatement stmt = con.prepareStatement("selects
SERVICEID from RT.SUBSCRIBERSERVICEPARAMETERS  where SERVICEPARAMETERID
= 11111;");
             ResultSet result = stmt.executeQuery(); 
              System.out.println(" return data");
              while (result.next()) {
                        System.out.println("  ------
"+result.getInt(1));

the problem was fixed.

emmanuel · **Posted:** Fri Feb 02, 2007 5:05 pm

and how is configured your persistence provider?