访问H2 TCP服务器的Grails挂起 [英] Grails accessing H2 TCP server hangs
本文介绍了访问H2 TCP服务器的Grails挂起的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有一个Grails应用程序，在使用默认嵌入式H2数据库时可以正常工作。现在我需要在需要更多集成环境的情况下运行一些测试，所以我想在服务器模式下使用H2，并让其他应用程序访问同一个数据库。
我从命令行启动H2服务器，并为服务器URL获取 tcp：//192.168.56.1：9092 。我在Grails数据源中将它设置为 jdbc：h2：tcp：// localhost：9092 /〜/ devDb; IFEXISTS = TRUE 。
一旦启动Grails应用程序，它就会挂起。日志文件为空。
带有外部DB客户端的URL，并可以验证服务器是否正在工作。
使用命令 java -cp h2 * .jar org.h2.tools.Server 从命令行启动服务器时。当IP地址发生变化时，也尝试使用 java -jar h2 * .jar -tcp -tcpAllowOthers ，但效果相同：从SQL客户端连接成功，与Grails挂起。
IP地址192.168.56.1等于localhost ，仅用于分类。我在Grails中都尝试过，结果是一样的。
版本信息：
- ** Grails：2.3.6 **
- ** Groovy：2.2.2 **
- ** Java：1.6.0_45 **
- ** H2：1.4.180 **
更新
确定。它不会悬挂，超时时间很长。我离开了程序在后台运行，忘记了它（之前我杀了这个进程），离开了电脑。一旦我回来了几个小时，我就有一堆等待着我的Spring bean创建错误。我认为'牛肉'就是下面粘贴的内容。
原因：org.springframework.beans.factory.BeanCreationException：
创建名为'dialectDetector'的bean时出错：
调用init方法失败;嵌套异常是org.springframework.jdbc.support.MetaDataAccessException：
提取DatabaseMetaData时出错;嵌套的异常是org.h2.jdbc.JdbcSQLException：
连接中断：session closed[90067-173]
... 5 more
引起：org.springframework.jdbc。 support.MetaDataAccessException：
提取DatabaseMetaData时出错;嵌套异常是org.h2.jdbc.JdbcSQLException：
连接中断：session closed[90067-173]
... 5 more
引起：org.h2.jdbc。 JdbcSQLException：连接中断：session closed[90067-173]
at org.h2.message.DbException.getJdbcSQLException（DbException.java:331）
at org.h2.message.DbException.get （DbException.java:171）
at org.h2.message.DbException.get（DbException.java:148）
at org.h2.engine.SessionRemote.checkClosed（SessionRemote.java:512）
在org.h2.engine.SessionRemote.removeServer（SessionRemote.java:442）
在org.h2.command.CommandRemote.prepare（CommandRemote.java:78）
在org.h2。 command.CommandRemote。< init>（CommandRemote.java:45）
at org.h2.engine.SessionRemote.prepareCommand（SessionRemote.java:449）
at org.h2.jdbc.JdbcConnection.prepareCommand （JdbcConnection.java:1142）
at org.h2.jdbc.JdbcConnection.getTransactionIsolation（JdbcConnection.java:756）
... 5 m ore
更新2
以下是Thomas在他的评论中提出的跟踪记录。
07-18 16:39:32 jdbc：
/ ** / Connection conn9 = DriverManager.getConnection（jdbc：h2：tcp：// localhost：9092 /〜/ devDb; TRACE_LEVEL_FILE = 3，SA，）;
07-18 16:39:32 jdbc：
/**/conn9.setReadOnly(false）;
07-18 16:39:32 jdbc：
/ ** / conn9.getAutoCommit（）;
07-18 16:39:32 jdbc：
/ ** / conn9.getTransactionIsolation（）;
07-18 16:39:32 jdbc：SESSION_PREPARE_READ_PARAMS 0
07-18 16:39:32 jdbc：exception
org.h2.jdbc.JdbcSQLException：连接中断：意外状态$ {$ b $ at org.h2.message.DbException.getJdbcSQLException（DbException.java:331）
at org.h2.message.DbException.get（DbException.java:171）
在org.h2.message.DbException.get（DbException.java:148）
在org.h2.engine.SessionRemote.done（SessionRemote.java:594）
在org.h2。 command.CommandRemote.prepare（CommandRemote.java:65）
at org.h2.command.CommandRemote。< init>（CommandRemote.java:45）
at org.h2.engine.SessionRemote.prepareCommand （SessionRemote.java:449）
at org.h2.jdbc.JdbcConnection.prepareCommand（JdbcConnection.java:1142）
at org.h2.jdbc.JdbcConnection.getTransactionIsolation（JdbcConnection.java:756）
at sun.reflect.NativeMethodAccessorImpl.invoke0（Native Method）
at sun.reflect.NativeMethodAccessorImpl.invoke（Native MethodAccessorImpl.java:39）
at sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:25）
at java.lang.reflect.Method.invoke（Method.java:597）
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke（ProxyConnection.java:126）
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke（JdbcInterceptor.java:109）
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke（DisposableConnectionFacade.java:80）
at com.sun.proxy。$ Proxy32.getTransactionIsolation（Unknown Source）
at org.springframework.jdbc .datasource.LazyConnectionDataSourceProxy.checkDefaultConnectionProperties（LazyConnectionDataSourceProxy.java:191）
at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet（LazyConnectionDataSourceProxy.java:164）
at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy 。< init>（LazyConnectionDataSourceProxy.java:106）
at sun.reflect.NativeC onstructorAccessorImpl.newInstance0（Native Method）
at sun.reflect.NativeConstructorAccessorImpl.newInstance（NativeConstructorAccessorImpl.java:39）
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance（DelegatingConstructorAccessorImpl.java:27）
at java.lang.reflect.Constructor.newInstance（Constructor.java:513）
在org.springframework.beans.BeanUtils.instantiateClass（BeanUtils.java:148）
在org.springframework.beans.factory。 support.SimpleInstantiationStrategy.instantiate（SimpleInstantiationStrategy.java:121）
位于org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor（ConstructorResolver.java:280）
位于org.springframework.beans.factory。 （AbstractAutowireCapableBeanFactory.java:1075）
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance（AbstractAutowireCapableBeanFactory.java:979）
在org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:487）
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean（ReloadAwareAutowireCapableBeanFactory.java:127）
。在org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:458）
在org.springframework.beans.factory.support.AbstractBeanFactory $ 1.getObject（AbstractBeanFactory.java:296）
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java:223）
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean（AbstractBeanFactory.java:293）
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean（AbstractBeanFactory.java:194）
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.re solveReference（BeanDefinitionValueResolver.java:320）
处org.springframework.beans.factory.support.ConstructorResolver org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary（BeanDefinitionValueResolver.java:107）
。 resolveConstructorArguments（ConstructorResolver.java:637）
处org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor（ConstructorResolver.java:148）
。 autowireConstructor（AbstractAutowireCapableBeanFactory.java:1075）
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance（AbstractAutowireCapableBeanFactory.java:979）
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory。 doCreateBean（AbstractAutowireCapableBeanFactory.java:487）
在org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory。 doCreateBean（ReloadAwareAutowireCapableBeanFactory.java:127）
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:458）
at org.springframework.beans.factory.support.AbstractBeanFactory $ 1 .getObject（AbstractBeanFactory.java:296）
在org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java:223）
在org.springframework.beans.factory.support.AbstractBeanFactory .doGetBean（AbstractBeanFactory.java:293）
在org.springframework.beans.factory.support.AbstractBeanFactory.getBean（AbstractBeanFactory.java:194）
在org.springframework.beans.factory.support.BeanDefinitionValueResolver .resolveReference（BeanDefinitionValueResolver.java:320）
在org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary（BeanDefinitionValueResolver.java:107）
在org.springframework.bean在org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean s.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues（AbstractAutowireCapableBeanFactory.java:1417）
（AbstractAutowireCapableBeanFactory.java:1158）
。在org.springframework。 $ or $ {$ b $ or $'$ or $'$'$ or $ $ $ $' springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:458）
at org.springframework.beans.factory.support.AbstractBeanFactory $ 1.getObject（AbstractBeanFactory.java:296）
at org .springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java:223）
at org.springframework.beans .factory.support.AbstractBeanFactory.doGetBean（AbstractBeanFactory.java:293）
在org.springframework.beans.factory.support.AbstractBeanFactory.getBean（AbstractBeanFactory.java:194）
在org.springframework.beans .factory.support.BeanDefinitionValueResolver.resolveReference（BeanDefinitionValueResolver.java:320）
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary（BeanDefinitionValueResolver.java:107）
at org.springframework.beans .factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues（AbstractAutowireCapableBeanFactory.java:1417）
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean（AbstractAutowireCapableBeanFactory.java:1158）
at org.springframework.beans .factory.support.AbstractAutowireCapableBeanFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:519）
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapable BeanFactory.doCreateBean（ReloadAwareAutowireCapableBeanFactory.java:127）
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:458）
at org.springframework.beans.factory.support。 AbstractBeanFactory $ 1.getObject（AbstractBeanFactory.java:296）
在org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java:223）
在org.springframework.beans.factory.support .AbstractBeanFactory.doGetBean（AbstractBeanFactory.java:293）
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean（AbstractBeanFactory.java:198）
at org.codehaus.groovy.grails.orm 。org.springframework
org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory（TransactionManagerPostProcessor.java:52）
at org.springframework .beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods（AbstractAutowireCapableBeanFactory.java:1532）
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean（AbstractAutowireCapableBeanFactory.java:1500）
at org.springframework .beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:521）
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean（ReloadAwareAutowireCapableBeanFactory.java:127）
at org .springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:458）
在org.springframework.beans.factory.support.AbstractBeanFactory $ 1.getObject（AbstractBeanFactory.java:296）
。在org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java:223）
at org.springframework .beans.factory.support.AbstractBeanFactory.doGetBean（AbstractBeanFactory.java:293）
在org.springframework.beans.factory.support.AbstractBeanFactory.getBean（AbstractBeanFactory.java:198）
在org.springframework .context.support.AbstractApplicationContext.registerBeanPostProcessors（AbstractApplicationContext.java:720）
在org.springframework.context.support.AbstractApplicationContext.refresh（AbstractApplicationContext.java:464）
在org.codehaus.groovy.grails .commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext（DefaultRuntimeSpringConfiguration.java:156）
在org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure（GrailsRuntimeConfigurator.java:169）
在org.codehaus .groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure（GrailsRuntimeConfigurator.java:127）
在org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext（GrailsConfigUtils.java:122）
在 org.codehaus.groovy.grails.web.context.GrailsContextLoader.initWebApplicationContext（GrailsContextLoader.java:108）
在org.springframework.web.context.ContextLoaderListener.contextInitialized（ContextLoaderListener.java:112）
。在org.apache.catalina.core.StandardContext.listenerStart（StandardContext.java:4961）
在org.apache.catalina.core.StandardContext.startInternal（StandardContext.java:5455）
在org.apache。 catalina.util.LifecycleBase.start（LifecycleBase.java:150）
位于org.apache.catalina.core.ContainerBase $ StartChild.call（ContainerBase.java:1559）
位于org.apache.catalina。 core.ContainerBase $ StartChild.call（ContainerBase.java:1549）$ java.util.concurrent.FutureTask
$ Sync.innerRun（FutureTask.java:303）
at java.util.concurrent.FutureTask。运行（FutureTask.java:138）
在java.util.concurrent.ThreadPoolExecutor $ Worker.runTask（ThreadPoolExecutor.java:895）$ b $在java.util.concurrent.ThreadPoolExecutor $ Worker.run（ThreadPo olExecutor.java:918）
在java.lang.Thread.run（Thread.java:662）
07-18 16:39:32 jdbc：
/**/conn9.getTransactionIsolation （）;
07-18 16:39:32 jdbc：SESSION_PREPARE_READ_PARAMS 1
07-18 16:39:32 jdbc：exception
org.h2.jdbc.JdbcSQLException：连接中断：意外状态$ [
at org.h2.message.DbException.getJdbcSQLException（DbException.java:331）
at org.h2.message.DbException.get（DbException.java:171）
在org.h2.message.DbException.get（DbException.java:148）
在org.h2.engine.SessionRemote.done（SessionRemote.java:594）
在org.h2。 command.CommandRemote.prepare（CommandRemote.java:65）
at org.h2.command.CommandRemote。< init>（CommandRemote.java:45）
at org.h2.engine.SessionRemote.prepareCommand （SessionRemote.java:449）
at org.h2.jdbc.JdbcConnection.prepareCommand（JdbcConnection.java:1142）
at org.h2.jdbc.JdbcConnection.getTransactionIsolation（JdbcConnection.java:756）
at sun.reflect.NativeMethodAccessorImpl.invoke0（Native Method）
at sun.reflect.NativeMethodAccessorImpl.invoke（Native MethodAccessorImpl.java:39）
at sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:25）
at java.lang.reflect.Method.invoke（Method.java:597）
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke（ProxyConnection.java:126）
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke（JdbcInterceptor.java:109）
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke（DisposableConnectionFacade.java:80）
at com.sun.proxy。$ Proxy32.getTransactionIsolation（Unknown Source）
at org.springframework.jdbc .datasource.LazyConnectionDataSourceProxy.checkDefaultConnectionProperties（LazyConnectionDataSourceProxy.java:191）
at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet（LazyConnectionDataSourceProxy.java:164）
at org.springframework.beans.factory.support .AbstractAutowireCapableBeanFactory.invokeInitMethods（AbstractAutowireCapableBeanFactory.java:1571）
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:521）
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean（ReloadAwareAutowireCapableBeanFactory.java:127）
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:458）
。在org.springframework.beans.factory.support.AbstractBeanFactory $ 1.getObject（AbstractBeanFactory.java:296）
在org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java:223）
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean（AbstractBeanFactory.java:293）
at org.springframework.beans.factory.sup port.AbstractBeanFactory.getBean（AbstractBeanFactory.java:194）
处org.springframework.beans.factory org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference（BeanDefinitionValueResolver.java:320）
。 （org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments（ConstructorResolver.java:637）
org.springframework.beans.factory中的
。 support.ConstructorResolver.autowireConstructor（ConstructorResolver.java:148）
处org.springframework.beans.factory org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor（AbstractAutowireCapableBeanFactory.java:1075）
。支持.AbstractAutowireCapableBeanFactory.createBeanInstance（AbstractAutowireCapableBeanFactory.java:979）
在org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC reateBean（AbstractAutowireCapableBeanFactory.java:487）
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean（ReloadAwareAutowireCapableBeanFactory.java:127）
at org.springframework.beans.factory.support。 AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:458）在org.springframework.beans.factory.support.AbstractBeanFactory上
$ 1.getObject（AbstractBeanFactory.java：296）$ or $ $ $ $在org.springframework.beans.factory.support .DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java:223）
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean（AbstractBeanFactory.java:293）
at org.springframework.beans.factory.support .AbstractBeanFactory.getBean（AbstractBeanFactory.java:194）
在org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference（BeanDefinitionValueResolver.java:320）
在org.springframework.b （org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues（AbstractAutowireCapableBeanFactory.java:1417）
at org.springframework。
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues（AbstractAutowireCapableBeanFactory.java:1417）
at org.springframework。 $ or $ $ b $ org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:519）
at org.codehaus。 groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean（ReloadAwareAutowireCapableBeanFactory.java:127）
在org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:458）
。在组织。 springframework.beans.factory.support.AbstractBeanFactory $ 1.getObject（AbstractBeanFactory.java:296）
at org.springfra mework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java:223）
在org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean（AbstractBeanFactory.java:293）
。在组织。 springframework.beans.factory.support.AbstractBeanFactory.getBean（AbstractBeanFactory.java:194）
在org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference（BeanDefinitionValueResolver.java:320）
。在组织。在org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary（BeanDefinitionValueResolver.java:107）
（AbstractAutowireCapableBeanFactory.java:1417）
。在组织。 springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean（AbstractAutowireCapableBeanFactory.java:1158）
at org.springframework.beans.factory.support.AbstractAutowireCapableBea nFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:519）
处org.springframework.beans.factory org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean（ReloadAwareAutowireCapableBeanFactory.java:127）
。 support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:458）
在org.springframework.beans.factory.support.AbstractBeanFactory $ 1.getObject（AbstractBeanFactory.java:296）
在org.springframework.beans.factory .support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java:223）
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean（AbstractBeanFactory.java:293）
at org.springframework.beans.factory .support.AbstractBeanFactory.getBean（AbstractBeanFactory.java:198）$ or $ $ b $ org.codehau $ or $ $ b $ org.codehau
org.codehau $ s.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory（TransactionManagerPostProcessor.java:52）
在org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods（AbstractAutowireCapableBeanFactory.java:1532）
。在org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:521）
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean（ReloadAwareAutowireCapableBeanFactory.java:127）
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:458）
at org.springframework.beans.factory.support.AbstractBeanFactory $ 1.getObject（AbstractBeanFactory.java:296）
at org.spr ingframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java:223）
在org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean（AbstractBeanFactory.java:293）
。在组织。在org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors springframework.beans.factory.support.AbstractBeanFactory.getBean（AbstractBeanFactory.java:198）
（AbstractApplicationContext.java:720）
。在org.springframework。 context.support.AbstractApplicationContext.refresh（AbstractApplicationContext.java:464）
位于org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext（DefaultRuntimeSpringConfiguration.java:156）
位于org.codehaus。 groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure（GrailsRuntimeConfigurator.java:169）
在org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure（GrailsRuntimeConfigurator.jav a：127）
位于org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext（GrailsConfigUtils.java:122）
位于org.codehaus.groovy.grails.web.context.GrailsContextLoader。 initWebApplicationContext（GrailsContextLoader.java:108）
at org.springframework.web.context.ContextLoaderListener.contextInitialized（ContextLoaderListener.java:112）
at org.apache.catalina.core.StandardContext.listenerStart（StandardContext。
at org.apache.catalina.core.StandardContext.startInternal（StandardContext.java:5455）
at org.apache.catalina.util.LifecycleBase.start（LifecycleBase.java:150）
at org.apache.catalina.core.ContainerBase $ StartChild.call（ContainerBase.java:1559）
at org.apache.catalina.core.ContainerBase $ StartChild.call（ContainerBase.java:1549）
at java.util.concurrent.FutureTask $ Sync.innerRun（FutureTask.java:303）
at java.util.concurrent.FutureTask.run（FutureTask.java:138）
at java .uti l.concurrent.ThreadPoolExecutor $ Worker.runTask（ThreadPoolExecutor.java:895）$ b $在java.util.concurrent.ThreadPoolExecutor $ Worker.run（ThreadPoolExecutor.java:918）$ b $在java.lang.Thread。运行（Thread.java:662）
07-18 16:39:32 jdbc：
/ ** / conn9.getTransactionIsolation（）;
07-18 16:39:32 jdbc：SESSION_PREPARE_READ_PARAMS 2
解决方案 div>
意外状态16777216/16842752（0x1000000 / 0x1010000）：
它可能是H2的不兼容的客户端和服务器版本。即使认为客户端和服务器协商使用哪种传输协议版本，理论上这应该不成问题。所以这将是服务器或客户端实现中的一个错误。根据错误代码，客户端版本为1.3.173，服务器版本为1.4.180。你能确保你为客户端和服务器使用相同的版本吗？
I have a Grails app which works fine when using the default embedded H2 database. Now I'd need to run some tests where I need more integrated environment, so I thought of using H2 in server mode for this and making my other apps access the same DB.
I start the H2 server from command line and get tcp://192.168.56.1:9092 for the server URL. I've set it in Grails datasource as jdbc:h2:tcp://localhost:9092/~/devDb;IFEXISTS=TRUE.
Once I start the Grails app, it simply hangs. The log file is empty.
I've tried the URL with external DB client and can verify that the server is working.
When server is started from the command line with command java -cp h2*.jar org.h2.tools.Server. Also tried with java -jar h2*.jar -tcp -tcpAllowOthers when the IP address changes, but the effects are the same: Connection OK from SQL client, hangs with Grails.
The IP address 192.168.56.1 equals localhost, just for clasrification. I've tried with both in Grails, and the results are the same. Also, both work with external client.
Version information:
- **Grails: 2.3.6**
- **Groovy: 2.2.2**
- **Java: 1.6.0_45**
- **H2: 1.4.180**
UPDATE
OK. It doesn't 'just hang', the timeout simply is quite long. I left the program running in the background and forgot it (previously I had killed the process), left the computer. Once I got back hours later, I got a long stacktrace of Spring bean creation errors waiting for me. I think the 'beef' is what is pasted below.
Caused by: org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'dialectDetector':
Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException:
Error while extracting DatabaseMetaData; nested exception is org.h2.jdbc.JdbcSQLException:
Connection is broken: "session closed" [90067-173]
... 5 more
Caused by: org.springframework.jdbc.support.MetaDataAccessException:
Error while extracting DatabaseMetaData; nested exception is org.h2.jdbc.JdbcSQLException:
Connection is broken: "session closed" [90067-173]
... 5 more
Caused by: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-173]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
at org.h2.message.DbException.get(DbException.java:171)
at org.h2.message.DbException.get(DbException.java:148)
at org.h2.engine.SessionRemote.checkClosed(SessionRemote.java:512)
at org.h2.engine.SessionRemote.removeServer(SessionRemote.java:442)
at org.h2.command.CommandRemote.prepare(CommandRemote.java:78)
at org.h2.command.CommandRemote.<init>(CommandRemote.java:45)
at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:449)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1142)
at org.h2.jdbc.JdbcConnection.getTransactionIsolation(JdbcConnection.java:756)
... 5 more
UPDATE 2
Below are the trace logging suggested by Thomas in his comment.
07-18 16:39:32 jdbc:
/**/Connection conn9 = DriverManager.getConnection("jdbc:h2:tcp://localhost:9092/~/devDb;TRACE_LEVEL_FILE=3", "SA", "");
07-18 16:39:32 jdbc:
/**/conn9.setReadOnly(false);
07-18 16:39:32 jdbc:
/**/conn9.getAutoCommit();
07-18 16:39:32 jdbc:
/**/conn9.getTransactionIsolation();
07-18 16:39:32 jdbc: SESSION_PREPARE_READ_PARAMS 0
07-18 16:39:32 jdbc: exception
org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16777216" [90067-173]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
at org.h2.message.DbException.get(DbException.java:171)
at org.h2.message.DbException.get(DbException.java:148)
at org.h2.engine.SessionRemote.done(SessionRemote.java:594)
at org.h2.command.CommandRemote.prepare(CommandRemote.java:65)
at org.h2.command.CommandRemote.<init>(CommandRemote.java:45)
at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:449)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1142)
at org.h2.jdbc.JdbcConnection.getTransactionIsolation(JdbcConnection.java:756)
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.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126)
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80)
at com.sun.proxy.$Proxy32.getTransactionIsolation(Unknown Source)
at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.checkDefaultConnectionProperties(LazyConnectionDataSourceProxy.java:191)
at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet(LazyConnectionDataSourceProxy.java:164)
at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.<init>(LazyConnectionDataSourceProxy.java:106)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:148)
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:121)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1075)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:979)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:487)
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean(ReloadAwareAutowireCapableBeanFactory.java:127)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:320)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107)
at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:637)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1075)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:979)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:487)
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean(ReloadAwareAutowireCapableBeanFactory.java:127)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:320)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1417)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean(ReloadAwareAutowireCapableBeanFactory.java:127)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:320)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1417)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean(ReloadAwareAutowireCapableBeanFactory.java:127)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:198)
at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74)
at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1532)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1500)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean(ReloadAwareAutowireCapableBeanFactory.java:127)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:198)
at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:720)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156)
at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:169)
at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127)
at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:122)
at org.codehaus.groovy.grails.web.context.GrailsContextLoader.initWebApplicationContext(GrailsContextLoader.java:108)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4961)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5455)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
07-18 16:39:32 jdbc:
/**/conn9.getTransactionIsolation();
07-18 16:39:32 jdbc: SESSION_PREPARE_READ_PARAMS 1
07-18 16:39:32 jdbc: exception
org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16842752" [90067-173]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
at org.h2.message.DbException.get(DbException.java:171)
at org.h2.message.DbException.get(DbException.java:148)
at org.h2.engine.SessionRemote.done(SessionRemote.java:594)
at org.h2.command.CommandRemote.prepare(CommandRemote.java:65)
at org.h2.command.CommandRemote.<init>(CommandRemote.java:45)
at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:449)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1142)
at org.h2.jdbc.JdbcConnection.getTransactionIsolation(JdbcConnection.java:756)
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.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126)
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80)
at com.sun.proxy.$Proxy32.getTransactionIsolation(Unknown Source)
at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.checkDefaultConnectionProperties(LazyConnectionDataSourceProxy.java:191)
at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet(LazyConnectionDataSourceProxy.java:164)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1571)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1509)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean(ReloadAwareAutowireCapableBeanFactory.java:127)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:320)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107)
at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:637)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1075)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:979)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:487)
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean(ReloadAwareAutowireCapableBeanFactory.java:127)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:320)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1417)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean(ReloadAwareAutowireCapableBeanFactory.java:127)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:320)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1417)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean(ReloadAwareAutowireCapableBeanFactory.java:127)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:198)
at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74)
at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1532)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1500)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
at org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean(ReloadAwareAutowireCapableBeanFactory.java:127)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:198)
at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:720)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156)
at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:169)
at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127)
at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:122)
at org.codehaus.groovy.grails.web.context.GrailsContextLoader.initWebApplicationContext(GrailsContextLoader.java:108)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4961)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5455)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
07-18 16:39:32 jdbc:
/**/conn9.getTransactionIsolation();
07-18 16:39:32 jdbc: SESSION_PREPARE_READ_PARAMS 2
解决方案
"unexpected status 16777216 / 16842752" (0x1000000 / 0x1010000):
It could be incompatible client and server versions of H2. Even thought the client and the server negotiate which transport protocol version to use, so in theory this should not be a problem. So that would be a bug in the server or client implementation. According to the error code, the client is version 1.3.173, and the server is version 1.4.180 as you wrote. Could you ensure you use the same version for both client and server?
这篇关于访问H2 TCP服务器的Grails挂起的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
