2 Replies Latest reply on Dec 19, 2014 4:25 PM by dancbaez

    Help with Hibernate 4.0.1 and String index out of range: -1 JBoss AS 7.1

    dancbaez

      Hi there. I'm new here. I hope somebody can help me.

       

      I have some troubles to excecute the following statement ponting towards Oracle 11G database:

       

      Query query = this.em.createNativeQuery("select * from SS_AS_NORM_TIPO", NormTipoModel.class);

      return query.getResultList();

       

      And then it throws this: String index out of range: -1 select * from SS_AS_NORM_TIPO

      But when the application is pointing towards Oracle 10G database, the app return the list successfully.

       

      The app is running over Hibernate 4.0.1, Java 1.7 and JBoss AS 7.1.

       

      The persistence.xml configuration is:

      <properties>

      <property name="javax.persistence.transactionType" value="JTA"/>

      <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" />

      <property name="hibernate.jdbc.batch_size" value="20" />

      <property name="hibernate.show_sql" value="false" />

      <property name="hibernate.format_sql" value="false" />

      <property name="hibernate.use_sql_comments" value="false" />

      <property name="hibernate.transaction.jta.platform" value="org.hibernate.service.jta.platform.internal.JBossAppServerJtaPlatform" />

      <property name="hibernate.cache.region.factory_class" value="org.jboss.as.jpa.hibernate4.infinispan.InfinispanRegionFactory" />

      <property name="hibernate.cache.infinispan.cachemanager" value="java:jboss/infinispan/container/hibernate" />

      <property name="hibernate.cache.infinispan.statistics" value="false"/>

      <property name="hibernate.cache.infinispan.use_synchronization" value="false"/>

      <property name="hibernate.cache.use_second_level_cache" value="false" />

      <property name="hibernate.cache.use_query_cache" value="false" />

      <property name="hibernate.generate_statistics" value="false" />

      </properties>

       

       

      And the complete stack trace is the following:

       

      String index out of range: -1 select * from SS_AS_NORM_TIPO

      at cl.synapsis.dao.imm.novedades.reglas.NovedadesDao.getAllNormTipos(NovedadesDao.java:117)

      at cl.orenda.service.imm.novedades.service.ServicioRngNovedades.loadNormTipo(ServicioRngNovedades.java:37)

      at cl.orenda.service.imm.novedades.service.ServicioRngNovedades.initBean(ServicioRngNovedades.java:49)

      at cl.orenda.jcore.ObjetoNegocioAbstract.setInitEjbDao(ObjetoNegocioAbstract.java:39)

      at cl.orenda.aspect.TransactionInterceptor.execEjbTransaction(TransactionInterceptor.java:55)

      at cl.orenda.aspect.TransactionInterceptor.executeWithTx(TransactionInterceptor.java:38)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

      at java.lang.reflect.Method.invoke(Method.java:601)

      at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptorFactory$ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptorFactory.java:123)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)

      at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374)

      at org.jboss.as.ejb3.concurrency.ContainerManagedConcurrencyInterceptor.processInvocation(ContainerManagedConcurrencyInterceptor.java:104)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

      at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:53)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:202)

      at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:306)

      at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:190)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:32)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

      at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)

      at org.jboss.as.ejb3.remote.LocalEjbReceiver.processInvocation(LocalEjbReceiver.java:179)

      at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:179)

      at org.jboss.ejb.client.TransactionInterceptor.handleInvocation(TransactionInterceptor.java:43)

      at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:181)

      at org.jboss.ejb.client.ReceiverInterceptor.handleInvocation(ReceiverInterceptor.java:128)

      at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:181)

      at org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:136)

      at org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:121)

      at org.jboss.ejb.client.EJBInvocationHandler.invoke(EJBInvocationHandler.java:104)

      at com.sun.proxy.$Proxy44.getConfigLog(Unknown Source)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

      at java.lang.reflect.Method.invoke(Method.java:601)

      at cl.orenda.aspect.BusinessProxy.invoke(BusinessProxy.java:34)

      at com.sun.proxy.$Proxy44.getConfigLog(Unknown Source)

      at cl.orenda.service.imm.novedades.strategy.AbstractNovedadStrategy.initLog(AbstractNovedadStrategy.java:110)

      at cl.orenda.service.imm.novedades.strategy.AbstractNovedadStrategy.<init>(AbstractNovedadStrategy.java:94)

      at cl.orenda.service.imm.novedades.strategy.AbstractCuentaOSENovedadStratey.<init>(AbstractCuentaOSENovedadStratey.java:19)

      at cl.orenda.service.imm.novedades.strategy.CuentaOseSinTarifaStrategy.<init>(CuentaOseSinTarifaStrategy.java:28)

      at cl.orenda.service.imm.novedades.service.NovedadesStrategyFactory.getStrategy(NovedadesStrategyFactory.java:31)

      at cl.orenda.service.imm.novedades.service.ProcesoNovedades.<init>(ProcesoNovedades.java:29)

      at cl.synapsis.service.testing.RegNovTestBean.oseSinTarifa(RegNovTestBean.java:49)

      at cl.synapsis.service.testing.RegNovTestBean.go(RegNovTestBean.java:33)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

      at java.lang.reflect.Method.invoke(Method.java:601)

      at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptorFactory$ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptorFactory.java:130)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.as.ee.component.ManagedReferenceInterceptorFactory$ManagedReferenceInterceptor.processInvocation(ManagedReferenceInterceptorFactory.java:95)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:228)

      at org.jboss.as.ejb3.tx.CMTTxInterceptor.requiresNew(CMTTxInterceptor.java:333)

      at org.jboss.as.ejb3.tx.SingletonLifecycleCMTTxInterceptor.processInvocation(SingletonLifecycleCMTTxInterceptor.java:56)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)

      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

      at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:161)

      at org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:85)

      at org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:116)

      at org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:130)

      at org.jboss.as.ee.component.ComponentStartService.start(ComponentStartService.java:44)

      at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811)

      at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

      at java.lang.Thread.run(Thread.java:722)

      Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: -1

      at java.lang.String.substring(String.java:1911)

      at cl.orenda.aspect.QueryProxy.checkTimeTooLong(QueryProxy.java:72)

      at cl.orenda.aspect.QueryProxy.invoke(QueryProxy.java:59)

      at com.sun.proxy.$Proxy53.getResultList(Unknown Source)

      at cl.synapsis.dao.imm.novedades.reglas.NovedadesDao.getAllNormTipos(NovedadesDao.java:115)

      ... 97 more

       

       

      Thanks you all.

      Daniel