java - Glassfish 4 - 集群设置 - DAS 上的数据库连接池

Question

我安装了 glassfish 4 (DAS)。一个远程 (SSH) 节点和一个集群，该节点上有一个实例。我还定义了一个连接池及其数据源。

我的测试应用程序非常简单 - 它是一个带有一个 servlet 的 Web 应用程序，我通过以下方式加载数据源:

@Resource(lookup = "jdbc/vadsacRootSource")
private Datasource datasource;

什么不起作用 - 集群实例(远程)上的数据源无法实例化，因为找不到底层池 - stacktrace 请参阅消息末尾。

什么有效:

• 本地DAS节点(默认节点)上的相同应用
• 加载在远程和本地保存为自定义 JNDI 资源的字符串
• glassfish 3.1 上的整个应用程序(还有数据源) - 远程和本地

因此，当前 glassfish 4 版本存在问题 - 数据源(或其池)未在某些远程 SSH 实例上实例化(或按 JNDI 找到？)。我测试了正式版本 4.0 和 nightly build 版本 4.1-bl3 - 同样的问题

你有什么想法吗？

GlassFish Server Open Source Edition 4.0 - Error report

HTTP Status 500 - Internal Server Error

---

type Exception report

messageInternal Server Error

descriptionThe server encountered an internal error that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Error instantiating servlet classcom.sedo.webtesty.HelloWorld

root cause

com.sun.enterprise.container.common.spi.util.InjectionException:Error creating managed object for class: classcom.sedo.webtesty.HelloWorld

root cause

com.sun.enterprise.container.common.spi.util.InjectionException:Exception attempting to inject Res-Ref-Env-Property:com.sedo.webtesty.HelloWorld/datasource@javax.sql.DataSource@ resolvedas: jndi: jdbc/vadsacRootSource@res principal: null@mail: null NoRuntime properties Database Vendor : null Create Tables at Deploy :false Delete Tables at Undeploy : false into classcom.sedo.webtesty.HelloWorld: Lookup failed for'java:comp/env/com.sedo.webtesty.HelloWorld/datasource' inSerialContext[myEnv={java.naming.factory.initial=com.sun.enterprise.naming.impl.SerialInitContextFactory,java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl,java.naming.factory.url.pkgs=com.sun.enterprise.naming}

root cause

javax.naming.NamingException: Lookup failed for'java:comp/env/com.sedo.webtesty.HelloWorld/datasource' inSerialContext[myEnv={java.naming.factory.initial=com.sun.enterprise.naming.impl.SerialInitContextFactory,java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl,java.naming.factory.url.pkgs=com.sun.enterprise.naming} [Rootexception is javax.naming.NamingException: Lookup failed for'jdbc/vadsacRootSource' inSerialContext[myEnv={java.naming.factory.initial=com.sun.enterprise.naming.impl.SerialInitContextFactory,java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl,java.naming.factory.url.pkgs=com.sun.enterprise.naming,com.sun.enterprise.naming.logicalName=java:comp/env/com.sedo.webtesty.HelloWorld/datasource}[Root exception is javax.naming.NamingException: Unable to lookupresource : jdbc/vadsacRootSource [Root exception iscom.sun.appserv.connectors.internal.api.ConnectorRuntimeException:Lookup failed for '__SYSTEM/pools/mysqlRootVadsacPool' inSerialContext[myEnv={java.naming.factory.initial=com.sun.enterprise.naming.impl.SerialInitContextFactory,java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl,java.naming.factory.url.pkgs=com.sun.enterprise.naming,com.sun.enterprise.naming.logicalName=java:comp/env/com.sedo.webtesty.HelloWorld/datasource}]]]

root cause

javax.naming.NamingException: Lookup failed for'jdbc/vadsacRootSource' inSerialContext[myEnv={java.naming.factory.initial=com.sun.enterprise.naming.impl.SerialInitContextFactory,java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl,java.naming.factory.url.pkgs=com.sun.enterprise.naming,com.sun.enterprise.naming.logicalName=java:comp/env/com.sedo.webtesty.HelloWorld/datasource}[Root exception is javax.naming.NamingException: Unable to lookupresource : jdbc/vadsacRootSource [Root exception iscom.sun.appserv.connectors.internal.api.ConnectorRuntimeException:Lookup failed for '__SYSTEM/pools/mysqlRootVadsacPool' inSerialContext[myEnv={java.naming.factory.initial=com.sun.enterprise.naming.impl.SerialInitContextFactory,java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl,java.naming.factory.url.pkgs=com.sun.enterprise.naming,com.sun.enterprise.naming.logicalName=java:comp/env/com.sedo.webtesty.HelloWorld/datasource}]]

root cause

javax.naming.NamingException: Unable to lookup resource: jdbc/vadsacRootSource [Root exception iscom.sun.appserv.connectors.internal.api.ConnectorRuntimeException:Lookup failed for '__SYSTEM/pools/mysqlRootVadsacPool' inSerialContext[myEnv={java.naming.factory.initial=com.sun.enterprise.naming.impl.SerialInitContextFactory,java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl,java.naming.factory.url.pkgs=com.sun.enterprise.naming,com.sun.enterprise.naming.logicalName=java:comp/env/com.sedo.webtesty.HelloWorld/datasource}]

root cause

com.sun.appserv.connectors.internal.api.ConnectorRuntimeException:Lookup failed for '__SYSTEM/pools/mysqlRootVadsacPool' inSerialContext[myEnv={java.naming.factory.initial=com.sun.enterprise.naming.impl.SerialInitContextFactory,java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl,java.naming.factory.url.pkgs=com.sun.enterprise.naming,com.sun.enterprise.naming.logicalName=java:comp/env/com.sedo.webtesty.HelloWorld/datasource}

root cause

javax.naming.NamingException: Lookup failed for'__SYSTEM/pools/mysqlRootVadsacPool' inSerialContext[myEnv={java.naming.factory.initial=com.sun.enterprise.naming.impl.SerialInitContextFactory,java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl,java.naming.factory.url.pkgs=com.sun.enterprise.naming,com.sun.enterprise.naming.logicalName=java:comp/env/com.sedo.webtesty.HelloWorld/datasource}[Root exception is javax.naming.NameNotFoundException:pools]

root cause

javax.naming.NameNotFoundException: pools

note The full stack traces of the exception and its root causes are available in the GlassFish Server Open Source Edition 4.0 logs.

---

GlassFish Server Open Source Edition 4.0

Answer 1

该问题已在当前 4.1 版本中得到解决 - 现在一切正常