could not read a hi value

doubleallergic · **Posted:** Mon Sep 04, 2006 9:04 pm

Hibernate version: 2.0

Hi all,

I have two instances of Jboss (local testing & remote prod), both of which connect to the same remote Oracle datasource using the same connect string, username and password. The oracle user i am using has privleges to query, insert, delete and modify data in that schema.

The hibernate dialect in both Jboss instances is also the same (net.sf.hibernate.dialect.OracleDialect)

On each jboss instance i have deployed the exact same application (as an .ear).

Running the app from my local jboss everything is fine - i can insert/delete/modify database records etc.

However, when I deploy the same app on my remote jboss I can modify and delete records ok but can't insert new entries into the database, fails with the following error:

2006-09-05 10:20:18,657 ERROR [net.sf.hibernate.id.TableGenerator] could not read a hi value
java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:880)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2516)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2850)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:537)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)
at net.sf.hibernate.id.TableGenerator.generate(TableGenerator.java:93)
at net.sf.hibernate.id.TableHiLoGenerator.generate(TableHiLoGenerator.java:59)
at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:765)
at net.sf.hibernate.impl.SessionImpl.doCopy(SessionImpl.java:4013)
at net.sf.hibernate.impl.SessionImpl.saveOrUpdateCopy(SessionImpl.java:3980)
at com.bsl.antares.database.util.ROMISHelper.saveOrUpdate(ROMISHelper.java:493)
at com.bsl.antares.product_portal.configuration.ConfigurationManagerBean.saveProductView(ConfigurationManagerBean.java:791)
at sun.reflect.GeneratedMethodAccessor13069.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)
at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)
at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:158)
at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:62)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
at org.jboss.ejb.Container.invoke(Container.java:873)
at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:155)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104)
at org.jboss.invocation.InvokerInterceptor.invokeMarshalled(InvokerInterceptor.java:201)
at org.jboss.invocation.MarshallingInvokerInterceptor.invoke(MarshallingInvokerInterceptor.java:35)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:97)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
at $Proxy80.saveProductView(Unknown Source)
at com.bsl.antares.product_portal.configuration.ConfigurationManagerDelegate.saveProductView(ConfigurationManagerDelegate.java:663)
at com.bsl.antares.product_portal.web.actions.ProductViewConfigurationAction.saveProductView(ProductViewConfigurationAction.java:1867)
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 com.bsl.antares.web.actions.AntaresDispatchAction.execute(AntaresDispatchAction.java:134)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.bsl.antares.product_portal.util.UserChangeFilter.doFilter(UserChangeFilter.java:128)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
2006-09-05 10:20:18,700 WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
2006-09-05 10:20:18,701 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] ORA-00942: table or view does not exist

2006-09-05 10:20:18,702 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] Could not save object
java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:880)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2516)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2850)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:537)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)
at net.sf.hibernate.id.TableGenerator.generate(TableGenerator.java:93)
at net.sf.hibernate.id.TableHiLoGenerator.generate(TableHiLoGenerator.java:59)
at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:765)
at net.sf.hibernate.impl.SessionImpl.doCopy(SessionImpl.java:4013)
at net.sf.hibernate.impl.SessionImpl.saveOrUpdateCopy(SessionImpl.java:3980)
at com.bsl.antares.database.util.ROMISHelper.saveOrUpdate(ROMISHelper.java:493)
at com.bsl.antares.product_portal.configuration.ConfigurationManagerBean.saveProductView(ConfigurationManagerBean.java:791)
at sun.reflect.GeneratedMethodAccessor13069.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)
at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)
at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:158)
at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:62)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
at org.jboss.ejb.Container.invoke(Container.java:873)
at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:155)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104)
at org.jboss.invocation.InvokerInterceptor.invokeMarshalled(InvokerInterceptor.java:201)
at org.jboss.invocation.MarshallingInvokerInterceptor.invoke(MarshallingInvokerInterceptor.java:35)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:97)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
at $Proxy80.saveProductView(Unknown Source)
at com.bsl.antares.product_portal.configuration.ConfigurationManagerDelegate.saveProductView(ConfigurationManagerDelegate.java:663)
at com.bsl.antares.product_portal.web.actions.ProductViewConfigurationAction.saveProductView(ProductViewConfigurationAction.java:1867)
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 com.bsl.antares.web.actions.AntaresDispatchAction.execute(AntaresDispatchAction.java:134)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.bsl.antares.product_portal.util.UserChangeFilter.doFilter(UserChangeFilter.java:128)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)

This is strange, as the required tables definitely do exist (when the app is run locally it finds the tables and inserts the data) and the database user i connect as has sufficient priveledges.

I'm thinking that this is not a code/database access issue, as everything is fine when the app is run locally - more likely a configuration issue, as the local/remote jboss instances are configured differently.

I'm fairly new to hibernate & jboss, so I not entirely sure what kind of (mis)configuration might be causing this problem. Has anyone come across this/something similar before?

Any leads appreciated!

RM

Yuunli · **Posted:** Tue Sep 05, 2006 3:27 am

Maybe you should check the database URL, username and password specified in hibernate.cfg.xml, hibernate.properties or another Hibernate configuration file.

If the configuration is correct, enable SQL output (showsql=true), and check whether the Hibernate-generated SQL makes any sense.

Maybe a simple typo in one of your mapping files?

doubleallergic · **Posted:** Tue Sep 05, 2006 9:43 pm

Hi,

I have checked my hibernate config file (hibernate-prod.cfg.xml) and all seems in order, as do the mapping files. FYI this is what hibernate-prod.cfg.xml looks like:

Code:

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 2.0//EN"
 "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>

    <session-factory>

   <!-- JNDI Datasource Connection -->         
   <property name="connection.datasource">java:/AntaresDS</property>
      
   <!-- properties -->
      <property name="hibernate.statement_cache.size">10</property>
      <property name="show_sql">true</property> <!-- change to false for prod deploy -->
      <property name="use_outer_join">true</property>
      <property name="transaction.manager_lookup_class">net.sf.hibernate.transaction.JBossTransactionManagerLookup</property>
      <property name="transaction.factory_class">net.sf.hibernate.transaction.JTATransactionFactory</property>

   <!-- Add the system config mapping -->
      <mapping resource="com/bsl/antares/database/util/SystemConfigItem.hbm.xml"/>
      
    <!-- mapping files -->
      <mapping resource="com/bsl/antares/product_portal/model/DataPoint.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/DatabaseRelationship.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/Product.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/ProductView.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/ProductViewPoint.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/HistorianServer.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/HistorianGroup.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/DataPointGroup.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/DataPointGroupDetail.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/Report.hbm.xml"/>       
      <mapping resource="com/bsl/antares/product_portal/model/ScriptConfig.hbm.xml"/>     
      <mapping resource="com/bsl/antares/product_portal/model/ScriptParameters.hbm.xml"/> 
      <mapping resource="com/bsl/antares/product_portal/model/Wizard.hbm.xml"/>     
      <mapping resource="com/bsl/antares/product_portal/model/ScriptParameterValues.hbm.xml"/> 
      <mapping resource="com/bsl/antares/product_portal/model/PivotTable.hbm.xml"/>     
      <mapping resource="com/bsl/antares/product_portal/model/PivotTableColumn.hbm.xml"/> 
      <mapping resource="com/bsl/antares/product_portal/model/ProductViewSummaryResult.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/AggregateFunctionDefs.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/PivotGraphConfig.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/PivotGraph.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/PivotGraphDataPoint.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/ProductViewGraphConfig.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/ProductViewGraph.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/ReportGroup.hbm.xml"/>
      <mapping resource="com/bsl/antares/product_portal/model/ReportManagerQueries.hbm.xml"/>
    </session-factory>
</hibernate-configuration> 

I have also ensured that the jboss unified class loader is turned off (this has caused problems in the past, eg it tries to load multiple versions of the jdbc driver).

I still believe the problem is in the configuration of the remote jboss instance, as the exact same .ear (with same dialect, datasource, jdbc driver etc) deployed on my local machine is fine...

I will also try to setting show_sql to true and see what happens...

Other suggestions anyone?

Thanks
RM