1 Reply Latest reply on Jan 31, 2007 1:10 AM by paata lominadze

    jdbc Query Timeout ( Is This a Bug? )

    paata lominadze Master

      hi all,
      i have one problem whole week, and could not resolve.

      enviroment :
      1. AS - Jboss Application Server 4.0.4 GA or Jboss Application Server 4.04 GA (i tryed both of them)
      2.ThierdParty/Database - Oracle Timesten In Memory DataBase
      3.EJB 3.0.EJB3 RC7 (for JBoss 4.0.4) EJB 3.0.EJB3 RC9 Patch 1 (For JBoss 4.0.5)
      4.OS - Solaris, Suse Linux, Windows XP (I tryed on all of them)
      5.ThierdParty/DataBase Driver - classes14.jar (1.5.0_04 (Sun Microsystems Inc.))

      task : i need use named query search from session beans

      my project snipets:
      1. jboss Timesten Datasource Configuration :

       <datasources>
      <xa-datasource>
       <jndi-name>TimesTenXAClientDS</jndi-name>
       <xa-datasource-class>
       com.timesten.jdbc.xa.TimesTenXADataSource
       </xa-datasource-class>
       <xa-datasource-property name="Url">
       jdbc:timesten:client:Test34
       </xa-datasource-property>
       <user-name></user-name>
       <password></password>
       <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
       <!--pooling parameters-->
       <min-pool-size>5</min-pool-size>
       <max-pool-size>100</max-pool-size>
       <blocking-timeout-millis>5000</blocking-timeout-millis>
       <idle-timeout-minutes>15</idle-timeout-minutes>
       <prepared-statement-cache-size>32</prepared-statement-cache-size>
       <track-connection-by-tx/>
       <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
       <metadata>
       <type-mapping>TimesTen</type-mapping>
       </metadata>
       </xa-datasource>
      </datasources>
      


      2. Database Table :

      create table "RT"."SUBSCRIBERS" ("SUBSCRIBERID" INTEGER not null,
      "CHARGINGPROFILEID" INTEGER not null, "STATUSID" INTEGER not null,
      "TSTAMP" BINARY(8), constraint "RT"."SUBSCRIBERS" primary key
      ("SUBSCRIBERID"))
      

      3. Entity Bean :

      package com.magti.businesslayer.ejb3entity.oracle;
      import java.io.Serializable;
      import org.apache.commons.lang.builder.ToStringBuilder;
      import javax.persistence.*;
      
      @NamedQueries
      ({
       @NamedQuery(name="Subscriber.getSubscriber",query="select e from Subscriber e where e.subscriberid = :subsId")
      })
      
      @Entity()
      @Table(name="SUBSCRIBERS", schema="RT")
      public class Subscriber implements Serializable {
       //default serial version id, required for serializable classes.
       private static final long serialVersionUID = 1L;
       private Integer subscriberid;
       private int chargingprofileid;
       private int statusid;
       private byte [] tstamp;
      
       public Subscriber() {
       }
      
       @Id()
       @Column(name="SUBSCRIBERID", unique=true, nullable=false, precision=10)
       public Integer getSubscriberid() {
       return this.subscriberid;
       }
       public void setSubscriberid(Integer subscriberid) {
       this.subscriberid = subscriberid;
       }
      
       @Basic()
       @Column(name="CHARGINGPROFILEID", nullable=false, precision=10)
       public int getChargingprofileid() {
       return this.chargingprofileid;
       }
       public void setChargingprofileid(int chargingprofileid) {
       this.chargingprofileid = chargingprofileid;
       }
      
       @Basic()
       @Column(name="STATUSID", nullable=false, precision=10)
       public int getStatusid() {
       return this.statusid;
       }
       public void setStatusid(int statusid) {
       this.statusid = statusid;
       }
      
       public String toString() {
       return new ToStringBuilder(this)
       .append("subscriberid", getSubscriberid())
       .toString();
       }
       @Basic()
       @Column(name="TSTAMP", nullable=true)
       public byte[] getTstamp() {
       return tstamp;
       }
      
       public void setTstamp(byte[] tstamp) {
       this.tstamp = tstamp;
       }
      }
      


      4. Remote Interface :
      package com.magti.businesslayer.ejb3entity.businesslayer;
      import javax.ejb.Remote;
      @Remote
      public interface SubscriberOperations {
       public void insertSubscriber() throws Exception;
       public void updateSubscriber() throws Exception;
       public void getSubscriber() throws Exception;
      }
      


      4. Remote Interface Implementation (Session bean) :

      package com.magti.businesslayer.ejb3entity.businesslayer;
      
      import java.util.List;
      
      import javax.ejb.Remote;
      import javax.ejb.Stateful;
      import javax.ejb.TransactionAttribute;
      import javax.ejb.TransactionAttributeType;
      import javax.persistence.EntityManager;
      import javax.persistence.PersistenceContext;
      
      import com.magti.businesslayer.ejb3entity.businesslayer.SubscriberOperations;
      import com.magti.businesslayer.ejb3entity.oracle.Subscriber;
      
      @Remote(SubscriberOperations.class)
      @Stateful
      public class SubscriberOperationsBean implements SubscriberOperations {
      
       @PersistenceContext(unitName = "Blaaaaaaaaaaaaaaaaa")
       private EntityManager timeStenMan;
      
       @TransactionAttribute(TransactionAttributeType.REQUIRED)
       public void insertSubscriber() throws Exception {
       try {
       System.out.println("Start Persisting");
       Subscriber subscriber = new Subscriber();
       subscriber.setTstamp(null);
       subscriber.setChargingprofileid(123123123);
       subscriber.setStatusid(123123123);
       timeStenMan.persist(subscriber);
       System.out.println("End Of Persisting");
       } catch (Exception e) {
       e.printStackTrace();
       }
       }
      
       @TransactionAttribute(TransactionAttributeType.REQUIRED)
       public void updateSubscriber() throws Exception {
       try {
      
       System.out.println("Start Updateing");
       Subscriber subscriber = new Subscriber();
       subscriber.setSubscriberid(606244);
       subscriber.setTstamp(null);
       subscriber.setChargingprofileid(312312312);
       subscriber.setStatusid(312312312);
       timeStenMan.merge(subscriber);
       System.out.println("End Of Updateing");
      
       } catch (Exception e) {
       e.printStackTrace();
       }
      
       }
      
       @TransactionAttribute(TransactionAttributeType.REQUIRED)
       public void getSubscriber() throws Exception {
       try {
       System.out.println("Start Searching");
       List<Subscriber> subscribers = (List<Subscriber>) timeStenMan
       .createNamedQuery("Subscriber.getSubscriber").setParameter(
       "subsId", new Integer(606244)).getResultList();
       System.out.println("End Of Searching");
      
       System.out.println("List Size = " + subscribers.size());
       } catch (Exception e) {
       e.printStackTrace();
       }
       }
      }
      


      5. persistance.xml file :
      <?xml version="1.0" encoding="ISO-8859-1" ?>
      <persistence xmlns="http://java.sun.com/xml/ns/persistence"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
       version="1.0">
      
       <persistence-unit name="Blaaaaaaaaaaaaaaaaa">
       <jta-data-source>java:/TimesTenXAClientDS</jta-data-source>
       <class>com.magti.businesslayer.ejb3entity.oracle.Subscriber</class>
       <properties>
       <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/>
       <property name="hibernate.connection.driver_class" value="com.timesten.jdbc.xa.TimesTenXADataSource"/>
       <property name="hibernate.connection.url" value="jdbc:timesten:client:Test34"/>
       <property name="hibernate.connection.username" value=""/>
       <property name="hibernate.connection.password" value=""/>
       <property name="hibernate.default_schema" value="RT"/>
       <property name="hibernate.show_sql" value="true"/>
       <property name="hibernate.format_sql" value="true"/>
       </properties>
       </persistence-unit>
      </persistence>
      


      6. and at last my test client :
      package com.magti.businesslayer.ejb3entity.oracle;
      
      import java.util.Properties;
      
      import javax.naming.Context;
      import javax.naming.InitialContext;
      
      import com.magti.businesslayer.ejb3entity.businesslayer.SubscriberOperations;
      
      public class TestMain {
       public static void main(String[] args) {
       try {
       Properties jndiProps = new Properties();
       jndiProps.setProperty(Context.INITIAL_CONTEXT_FACTORY,
       "org.jnp.interfaces.NamingContextFactory");
       jndiProps.setProperty(Context.URL_PKG_PREFIXES,
       "org.jboss.naming:org.jnp.interface");
       jndiProps.setProperty(Context.PROVIDER_URL,
       "jnp://192.168.9.136:1099");
       InitialContext ctx = new InitialContext(jndiProps);
      
       SubscriberOperations ops = (SubscriberOperations) ctx
       .lookup("SubscriberOperationsBean/remote");
      
       // Test Searching
       ops.getSubscriber();
       // End Of Test Searching
      
       } catch (Exception e) {
       e.printStackTrace();
       }
       }
      }
      


      and i get an error like this :
      java.sql.SQLException: [TimesTen][TimesTen 6.0.4 CLIENT]Query Timeout must be numeric, greater than or equal to 0, and less than the Network Timeout
       at com.timesten.jdbc.JdbcOdbc.createSQLException(JdbcOdbc.java:7307)
       at com.timesten.jdbc.JdbcOdbc.standardError(JdbcOdbc.java:7440)
       at com.timesten.jdbc.JdbcOdbc.standardError(JdbcOdbc.java:7405)
       at com.timesten.jdbc.JdbcOdbc.SQLSetStmtOption(JdbcOdbc.java:6679)
       at com.timesten.jdbc.JdbcOdbcStatement.setStmtOption(JdbcOdbcStatement.java:1883)
       at com.timesten.jdbc.JdbcOdbcStatement.setQueryTimeout(JdbcOdbcStatement.java:720)
       at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.close(CachedPreparedStatement.java:339)
       at org.jboss.resource.adapter.jdbc.WrappedStatement.internalClose(WrappedStatement.java:588)
       at org.jboss.resource.adapter.jdbc.WrappedStatement.close(WrappedStatement.java:73)
       at org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.java:526)
       at org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:265)
       at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:281)
       at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:209)
       at org.hibernate.loader.Loader.doQuery(Loader.java:714)
       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
       at org.hibernate.loader.Loader.doList(Loader.java:2145)
       at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
       at org.hibernate.loader.Loader.list(Loader.java:2024)
       at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392)
       at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333)
       at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
       at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
       at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
       at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:53)
       at com.magti.businesslayer.ejb3Fasade.srvprov.MobileServiceFasadeBean.test(MobileServiceFasadeBean.java:1467)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
       at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
       at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
       at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
       at org.jboss.ejb3.entity.ExtendedPersistenceContextPropagationInterceptor.invoke(ExtendedPersistenceContextPropagationInterceptor.java:57)
       at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
       at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
       at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
       at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
       at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
       at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
       at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:197)
       at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
       at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
       at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
       at org.jboss.ejb3.stateful.StatefulInstanceInterceptor.invoke(StatefulInstanceInterceptor.java:81)
       at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
       at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78)
       at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
       at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
       at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
       at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
       at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
       at org.jboss.ejb3.stateful.StatefulContainer.dynamicInvoke(StatefulContainer.java:297)
       at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:106)
       at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
       at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:828)
       at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:681)
       at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:358)
       at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:412)
       at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:239)
      30 Jan 07 12:31:23, DEBUG org.apache.commons.logging.impl.Log4JLogger:debug:84 about to open ResultSet (open ResultSets: 0, globally: 0)
      30 Jan 07 12:31:23, WARN org.apache.commons.logging.impl.Log4JLogger:warn:104 SQL Error: 0, SQLState: S1000
      30 Jan 07 12:31:23, DEBUG org.apache.commons.logging.impl.Log4JLogger:debug:84 result row:
      30 Jan 07 12:31:23, ERROR org.apache.commons.logging.impl.Log4JLogger:error:114 [TimesTen][TimesTen 6.0.4 CLIENT]Query Timeout must be numeric, greater than or equal to 0, and less than the Network Timeout
      30 Jan 07 12:31:23, DEBUG org.apache.commons.logging.impl.Log4JLogger:debug:84 about to close ResultSet (open ResultSets: 1, globally: 1)
      30 Jan 07 12:31:23, DEBUG org.apache.commons.logging.impl.Log4JLogger:debug:84 about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
      30 Jan 07 12:31:23, DEBUG org.apache.commons.logging.impl.Log4JLogger:debug:84 aggressively releasing JDBC connection
      30 Jan 07 12:31:23, DEBUG org.apache.commons.logging.impl.Log4JLogger:debug:84 releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
      
      


      i thougt that it mey be bug in timesten but when i tryed the same task without jboss and ejb 3 into stand alone client it works ....

      is there any idea ? :(
      i am nto sure but i think this bug into hibrnate or jboss.
      if this is a bug can i report it in jira ?




        • 1. Re: jdbc Query Timeout ( Is This a Bug? )
          paata lominadze Master

          hi all, i found out one way.
          when i changed the session bean, add this:

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


          and then i tryed get information from timesten database it works :)
           try{
           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));
          
           }
          



          but it is not good idea, becouse i need entity transaction management,
          i think that bug is in the entity manager.