手动安装后收到"Name [jdbc/WorklightDS] is not bound in this Context. Unable to find [jdbc]"错误

Question

我们正试图在Rhel Linux上的Tomcat 7上，在带有一个DB（worklight）的服务器上手动安装worklight 5.06 enterprise。我们运行了create-worklight-oracle.sql脚本，并按照http://pic.dhe.ibm.com/infocenter/wrklight/v5r0m6/index.jsp?topic=%2Fcom.ibm.worklight.help.doc%2Fadmin%2Fc_installation.html

但仍遇到一些问题。具体来说，我们的tomcat与工作灯DB:的配置文件似乎有问题

SEVERE: com.worklight.server.bundle.project.messages:logger.projectStartFailed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'txManager' defined in URL [jar:file:/usr/share/java/tomcat7/worklight-jee-library.jar!/conf/core.xml]: Cannot resolve reference to bean 'brokerSessionFactory' while setting bean property 'entityManagerFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'brokerSessionFactory' defined in URL [jar:file:/usr/share/java/tomcat7/worklight-jee-library.jar!/conf/spring-server-core.xml]: Cannot resolve reference to bean 'rssBrokerDS' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean
 with name 'rssBrokerDS' defined in URL [jar:file:/usr/share/java/tomcat7/worklight-jee-library.jar!/conf/spring-server-core.xml]: Cannot resolve reference to bean 'worklight-direct' while setting bean property 'targetDataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'worklight-direct' defined in URL [jar:file:/usr/share/java/tomcat7/worklight-jee-library.jar!/conf/spring-server-core.xml]: Invocation of init method failed; nested exception is javax.naming.NameNotFoundException: Name [jdbc/WorklightDS] is not bound in this Context. Unable to find [jdbc].
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)

可能是一些愚蠢的错误，我为数据库配置做了以下操作：在分解的worklight.war中将以下内容添加到我们的worklight.properties中：取消注释这些行：

wl.db.type=ORACLE
wl.db.url=jdbc:oracle:thin:@//DBSERVER:1521/SERVICE_NAME <-- changed from our internal names
wl.db.username=worklight
wl.db.password=worklight

在节中为tomcat在context.xml中添加了以下内容；

<Resource name="jdbc/WorklightDS"
auth="Container"
type="javax.sql.DataSource"
username="worklight"
password="worklight"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@//DBSERVER:1521/SERVICE_NAME"/>

将以下内容添加到文件末尾的web.xml中（在/web app>end标记之前）：

<resource-ref>
    <res-ref-name>jdbc/WorklightDS</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
</resource-ref>

可能的解决方案：问题是使用JNDI连接——单独使用jdbc连接可以很好地工作。

Answer 1

对于tomcat 7上的Worklight 506，这里有一个示例配置：

在tomcat 7 server.xml（在<host>部分）中设置JDBC数据源

<Context docBase="worklight" path="/worklight">
<Resource auth="Container"
    driverClassName="oracle.jdbc.driver.OracleDriver"
    maxActive="80"
    maxIdle="4"
    maxWait="5000"
    name="jdbc/WorkLightDS"
    password="worklight"
    type="javax.sql.DataSource"
    url="jdbc:oracle:thin:@//DBSERVER:1521/SERVICE_NAME"
    username="worklight"/>
</Context>

在worklight.properties中，设置在以下两行：

wl.db.type=ORACLE
wl.db.jndi.name=java:comp/env/jdbc/WorkLightDS