Atomikos Forum

I'm using spring with hibernate 3.6.7 and atomikos 3.7.0. As you can see on log below on SchemaUpdate.execute(SchemaUpdate.java:168) I get the following exception.

11-09-25 16:42:28,538 [main] Starting read of logfile G:\Prinz git copy\projects\prinz-server\.\tmlog0.log
11-09-25 16:42:28,538 [main] Done read of logfile
11-09-25 16:42:28,538 [main] Logfile closed: G:\Prinz git copy\projects\prinz-server\.\tmlog0.log
11-09-25 16:42:28,581 [main] atomikosDataSource: refreshed XAResource
11-09-25 16:42:28,618 [main] USING core version: 3.7.0
11-09-25 16:42:28,618 [main] USING com.atomikos.icatch.console_file_name = tm.out
11-09-25 16:42:28,618 [main] USING com.atomikos.icatch.console_file_count = 1
11-09-25 16:42:28,618 [main] USING com.atomikos.icatch.automatic_resource_registration = false
11-09-25 16:42:28,618 [main] USING com.atomikos.icatch.client_demarcation = false
11-09-25 16:42:28,618 [main] USING com.atomikos.icatch.threaded_2pc = false
11-09-25 16:42:28,619 [main] USING com.atomikos.icatch.serial_jta_transactions = true
11-09-25 16:42:28,619 [main] USING com.atomikos.icatch.log_base_dir = .\
11-09-25 16:42:28,619 [main] USING com.atomikos.icatch.console_log_level = INFO
11-09-25 16:42:28,619 [main] USING com.atomikos.icatch.max_actives = 50
11-09-25 16:42:28,619 [main] USING com.atomikos.icatch.checkpoint_interval = 500
11-09-25 16:42:28,619 [main] USING com.atomikos.icatch.enable_logging = true
11-09-25 16:42:28,619 [main] USING com.atomikos.icatch.output_dir = .\
11-09-25 16:42:28,619 [main] USING com.atomikos.icatch.log_base_name = tmlog
11-09-25 16:42:28,619 [main] USING com.atomikos.icatch.console_file_limit = -1
11-09-25 16:42:28,619 [main] USING com.atomikos.icatch.max_timeout = 300000
11-09-25 16:42:28,620 [main] USING com.atomikos.icatch.tm_unique_name = 169.254.5.29.tm
11-09-25 16:42:28,620 [main] USING java.naming.factory.initial = com.sun.jndi.rmi.registry.RegistryContextFactory
11-09-25 16:42:28,620 [main] USING java.naming.provider.url = rmi://localhost:1099
11-09-25 16:42:28,620 [main] USING com.atomikos.icatch.service = com.atomikos.icatch.standalone.UserTransactionServiceFactory
11-09-25 16:42:28,620 [main] USING com.atomikos.icatch.force_shutdown_on_vm_exit = true
11-09-25 16:42:28,620 [main] USING com.atomikos.icatch.default_jta_timeout = 10000
11-09-25 16:42:28,622 [main] suspend() called without a transaction context
11-09-25 16:42:28,707 [main] suspend() called without a transaction context
11-09-25 16:42:28,790 [main] AtomikosDataSoureBean 'atomikosDataSource': getConnection ( null )...
11-09-25 16:42:28,790 [main] AtomikosDataSoureBean 'atomikosDataSource': init...
11-09-25 16:42:28,791 [main] atomikos connection pool 'atomikosDataSource': error creating proxy of connection an AtomikosXAPooledConnection with a SessionHandleState with 0 context(s)
com.atomikos.datasource.pool.CreateConnectionException: an AtomikosXAPooledConnection with a SessionHandleState with 0 context(s): connection is erroneous
    at com.atomikos.jdbc.AtomikosXAPooledConnection.testUnderlyingConnection(AtomikosXAPooledConnection.java:114)
    at com.atomikos.datasource.pool.AbstractXPooledConnection.createConnectionProxy(AbstractXPooledConnection.java:68)
    at com.atomikos.datasource.pool.ConnectionPool.borrowConnection(ConnectionPool.java:161)
    at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:321)
    at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:373)
    at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:82)
    at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
    at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:168)
    at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:375)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1872)
    at org.springframework.orm.hibernate3.SessionFactoryBuilderSupport.newSessionFactory(SessionFactoryBuilderSupport.java:607)
    at org.springframework.orm.hibernate3.SessionFactoryBuilderSupport.doBuildSessionFactory(SessionFactoryBuilderSupport.java:467)
    at org.springframework.orm.hibernate3.SessionFactoryBeanDelegate.afterPropertiesSet(SessionFactoryBeanDelegate.java:110)
    at org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean.afterPropertiesSet(AnnotationSessionFactoryBean.java:121)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1479)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:844)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:786)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:703)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:476)
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:84)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:284)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1074)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:377)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:278)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
    at org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:549)
    at org.mortbay.jetty.servlet.Context.startContext(Context.java:136)
    at org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1282)
    at org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:518)
    at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
    at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
    at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130)
    at org.mortbay.jetty.Server.doStart(Server.java:224)
    at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
    at runjettyrun.Bootstrap.main(Bootstrap.java:82)
11-09-25 16:42:28,791 [main] atomikos connection proxy for Pooled connection wrapping physical connection org.postgresql.jdbc4.Jdbc4Connection@4fed44be: calling getAutoCommit...
11-09-25 16:42:28,792 [main] atomikos connection proxy for Pooled connection wrapping physical connection org.postgresql.jdbc4.Jdbc4Connection@4fed44be: calling getMetaData...
11-09-25 16:42:28,792 [main] atomikos connection proxy for Pooled connection wrapping physical connection org.postgresql.jdbc4.Jdbc4Connection@4fed44be: calling createStatement...
11-09-25 16:42:28,826 [main] atomikos connection proxy for Pooled connection wrapping physical connection org.postgresql.jdbc4.Jdbc4Connection@4fed44be: calling createStatement...
11-09-25 16:42:29,336 [main] atomikos connection proxy for Pooled connection wrapping physical connection org.postgresql.jdbc4.Jdbc4Connection@4fed44be: calling getWarnings...
11-09-25 16:42:29,336 [main] atomikos connection proxy for Pooled connection wrapping physical connection org.postgresql.jdbc4.Jdbc4Connection@4fed44be: calling clearWarnings...
11-09-25 16:42:29,336 [main] atomikos connection proxy for Pooled connection wrapping physical connection org.postgresql.jdbc4.Jdbc4Connection@4fed44be: close()...
11-09-25 16:42:29,372 [main] suspend() called without a transaction context
11-09-25 16:42:29,398 [main] suspend() called without a transaction context

Hi,

This is a warning, not an issue. Please make sure to set a testQuery to streamline the pooling mechanism.

HTH