upgrade h2 server from 1.3.158 to latest 1.3.166

795 views
Skip to first unread message

austin17427

unread,
May 2, 2012, 2:02:57 AM5/2/12
to H2 Database, austi...@gmail.com
Hi,
First I want to thank you for your effort for h2, I think it's a great
software, I find it very useful for small projects and integration
tests. I'm trying to upgrade h2 server from 1.3.158 to latest 1.3.166.
Here is my properties and configuration;

h2.h2Server.startArgs=-tcp,-tcpAllowOthers,true,-tcpPort,8043
h2.h2WebServer.startArgs=-web,-webAllowOthers,true,-webPort,8082
jdbc.url=jdbc:h2:mem:testdb;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=1;LOCK_TIMEOUT=1000
jdbc.username=user
jdbc.password=pass

<bean id="h2Server" class="org.h2.tools.Server" factory-
method="createTcpServer" init-method="start" destroy-method="stop">
<constructor-arg value="${h2.h2Server.startArgs}" />
</bean>

<bean id="h2WebServer" class="org.h2.tools.Server" factory-
method="createWebServer" init-method="start" destroy-method="stop"
depends-on="h2Server">
<constructor-arg value="${h2.h2WebServer.startArgs}" />
</bean>

Everything works fine with version 1.3.158 but when I upgrade to
1.3.166, I get below exception.
Could you please advise what I am doing wrong here?
Thank you.


ERROR 2012-05-02 00:52:24,084 [main]
org.springframework.test.context.TestContextManager: Caught exception
while allowing TestExecutionListener
[org.springframework.test.context.support.DependencyInjectionTestExecutionListener@5918cb3a]
to prepare test instance [com.xyz.SomeBean@6ac67a88]
java.lang.IllegalStateException: Failed to load ApplicationContext
at
org.springframework.test.context.TestContext.getApplicationContext(TestContext.java:
157)
at
org.springframework.test.context.support.DependencyInjectionTestExecutionListener.injectDependencies(DependencyInjectionTestExecutionListener.java:
109)
at
org.springframework.test.context.support.DependencyInjectionTestExecutionListener.prepareTestInstance(DependencyInjectionTestExecutionListener.java:
75)
at
org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:
321)
at
org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:
211)
at
org.springframework.test.context.junit4.SpringJUnit4ClassRunner
$1.runReflectiveCall(SpringJUnit4ClassRunner.java:288)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:
15)
at
org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:
290)
at
org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:
231)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:
47)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:
60)
at
org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:
50)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:
222)
at
org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:
61)
at
org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:
71)
at org.junit.runners.ParentRunner.run(ParentRunner.java:300)
at
org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:
174)
at org.junit.runners.Suite.runChild(Suite.java:128)
at org.junit.runners.Suite.runChild(Suite.java:24)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:
60)
at
org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:
50)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:
222)
at org.junit.runners.ParentRunner.run(ParentRunner.java:300)
at org.junit.runner.JUnitCore.run(JUnitCore.java:157)
at org.junit.runner.JUnitCore.run(JUnitCore.java:136)
at
org.apache.maven.surefire.junitcore.JUnitCoreWrapper.execute(JUnitCoreWrapper.java:
62)
at
org.apache.maven.surefire.junitcore.JUnitCoreProvider.invoke(JUnitCoreProvider.java:
139)
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:597)
at
org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:
189)
at org.apache.maven.surefire.booter.ProviderFactory
$ProviderProxy.invoke(ProviderFactory.java:165)
at
org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:
85)
at
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:
103)
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:
74)
Caused by: org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'messageDaoImpl': Injection of
persistence dependencies failed; nested exception is
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'entityManagerFactory' defined in class path
resource [applicationContext.xml]: Cannot resolve reference to bean
'dataSource' while setting bean property 'dataSource'; nested
exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'h2Server' defined in class path
resource [applicationContext.xml]: Instantiation of bean failed;
nested exception is
org.springframework.beans.factory.BeanDefinitionStoreException:
Factory method [public static org.h2.tools.Server
org.h2.tools.Server.createTcpServer(java.lang.String[]) throws
java.sql.SQLException] threw exception; nested exception is
org.h2.jdbc.JdbcSQLException: Feature not supported:
"true" [50100-166]
at
org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.postProcessPropertyValues(PersistenceAnnotationBeanPostProcessor.java:
342)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:
1106)
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:294)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:
225)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:
291)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
193)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:
585)
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:
913)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:
464)
at
org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:
103)
at
org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:
1)
at
org.springframework.test.context.support.DelegatingSmartContextLoader.loadContext(DelegatingSmartContextLoader.java:
228)
at
org.springframework.test.context.TestContext.loadApplicationContext(TestContext.java:
124)
at
org.springframework.test.context.TestContext.getApplicationContext(TestContext.java:
148)
... 39 more
Caused by: org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'entityManagerFactory' defined in class
path resource [applicationContext.xml]: Cannot resolve reference to
bean 'dataSource' while setting bean property 'dataSource'; nested
exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'h2Server' defined in class path
resource [applicationContext.xml]: Instantiation of bean failed;
nested exception is
org.springframework.beans.factory.BeanDefinitionStoreException:
Factory method [public static org.h2.tools.Server
org.h2.tools.Server.createTcpServer(java.lang.String[]) throws
java.sql.SQLException] threw exception; nested exception is
org.h2.jdbc.JdbcSQLException: Feature not supported:
"true" [50100-166]
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:
328)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:
106)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:
1360)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:
1118)
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:294)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:
225)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:
291)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
193)
at
org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findDefaultEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:
530)
at
org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:
496)
at
org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor
$PersistenceElement.resolveEntityManager(PersistenceAnnotationBeanPostProcessor.java:
657)
at
org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor
$PersistenceElement.getResourceToInject(PersistenceAnnotationBeanPostProcessor.java:
630)
at
org.springframework.beans.factory.annotation.InjectionMetadata
$InjectedElement.inject(InjectionMetadata.java:150)
at
org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:
87)
at
org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.postProcessPropertyValues(PersistenceAnnotationBeanPostProcessor.java:
339)
... 54 more
Caused by: org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'h2Server' defined in class path
resource [applicationContext.xml]: Instantiation of bean failed;
nested exception is
org.springframework.beans.factory.BeanDefinitionStoreException:
Factory method [public static org.h2.tools.Server
org.h2.tools.Server.createTcpServer(java.lang.String[]) throws
java.sql.SQLException] threw exception; nested exception is
org.h2.jdbc.JdbcSQLException: Feature not supported:
"true" [50100-166]
at
org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:
581)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:
1015)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:
911)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:
485)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:
456)
at
org.springframework.beans.factory.support.AbstractBeanFactory
$1.getObject(AbstractBeanFactory.java:294)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:
225)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:
291)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
193)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:
284)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
193)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:
284)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
193)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:
322)
... 70 more
Caused by:
org.springframework.beans.factory.BeanDefinitionStoreException:
Factory method [public static org.h2.tools.Server
org.h2.tools.Server.createTcpServer(java.lang.String[]) throws
java.sql.SQLException] threw exception; nested exception is
org.h2.jdbc.JdbcSQLException: Feature not supported:
"true" [50100-166]
at
org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:
169)
at
org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:
570)
... 83 more
Caused by: org.h2.jdbc.JdbcSQLException: Feature not supported:
"true" [50100-166]
at
org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.util.Tool.throwUnsupportedOption(Tool.java:66)
at org.h2.tools.Server.verifyArgs(Server.java:203)
at org.h2.tools.Server.<init>(Server.java:47)
at org.h2.tools.Server.createTcpServer(Server.java:427)
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:597)
at
org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:
149)
... 84 more



Thomas Mueller

unread,
May 2, 2012, 2:44:29 AM5/2/12
to h2-da...@googlegroups.com
Hi,

The problem is:

h2.h2Server.startArgs=-tcp,-tcpAllowOthers,true,-tcpPort,8043
h2.h2WebServer.startArgs=-web,-webAllowOthers,true,-webPort,8082

needs to be changed to:

h2.h2Server.startArgs=-tcp,-tcpAllowOthers,-tcpPort,8043
h2.h2WebServer.startArgs=-web,-webAllowOthers,-webPort,8082

The "true" is no longer needed since quite a long time, and no longer supported.

Regards,
Thomas
Reply all
Reply to author
Forward
0 new messages