Worklight 6.1，SQL Adapter（Oracle 11g)在Tomcat 7.0.42上出现JNDI错误

Question

我们正在worklight 6.1、Oracle11g和Tomcat7.0.42上部署worklight应用程序。

我们按照手动步骤在Tomcat上部署worklight应用程序，我们配置了以下文件：adapter.xml

<connectivity>
        <connectionPolicy xsi:type="sql:SQLConnectionPolicy">   
         <dataSourceJNDIName>${DataSource-jndi-Local}</dataSourceJNDIName>
    </connectionPolicy>

DataSource-jndi-Local = jdbc/WorklightAppDS

server.xml（Tomcat 7）

<Context path="/App_Name" docBase="App_Name">
        <Resource name="jdbc/WorklightAppDS"
            auth="Container"
            type="javax.sql.DataSource"
            driverClassName="oracle.jdbc.driver.OracleDriver"
            url="jdbc:oracle:thin:@domain:1521:ORCL"
            username="DBUSER"
            password="DBPASS"/>
        <Resource name="jdbc/WorklightDS"
            auth="Container"
            type="javax.sql.DataSource"
            driverClassName="oracle.jdbc.driver.OracleDriver"
            url="jdbc:oracle:thin:@domain:1521:ORCL"
            username="DBUSERWORKLIGHT"
            password="DBUSERWORKLIGHTPASS"/>    
        <Resource name="jdbc/WorklightReportsDS"
            auth="Container"
            type="javax.sql.DataSource"
            driverClassName="oracle.jdbc.driver.OracleDriver"
            url="jdbc:oracle:thin:@domain:1521:ORCL"
            username="DBUSERWORKLIGHTREPORTS"
            password="DBUSERWORKLIGHTREPORTSPASS"/>

         <Manager pathname="" />
    </Context> 

完成上述配置后，部署了Worklight应用程序，我们能够访问上下文“/app_name/console”上的Worklight控制台。我们在worklight控制台上部署了。wlapp和。wladapter，当我们通过应用程序调用worklight适配器时，它表示“运行时：Datasource JDBC/WorklightAppds在JNDI中找不到”。

我们尝试了另外两种方法来配置数据源：

        <Resource name="UserDatabase" auth="Container"
                  type="org.apache.catalina.UserDatabase"
                  description="User database that can be updated and saved"
                  factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
                  pathname="conf/tomcat-users.xml" />

        <Resource name="jdbc/WorklightAppDS"
            auth="Container"
            type="javax.sql.DataSource"
            driverClassName="oracle.jdbc.driver.OracleDriver"
            url="jdbc:oracle:thin:@domain:1521:ORCL"
            username="DBUSER"
            password="DBPASS"/> 
    </GlobalNamingResources>

        <Resource name="jdbc/WorklightAppDS"
            auth="Container"
            type="javax.sql.DataSource"
            driverClassName="oracle.jdbc.driver.OracleDriver"
            url="jdbc:oracle:thin:@domain:1521:ORCL"
            username="DBUSER"
            password="DBPASS"/>

        <!--
        <Manager pathname="" />
        -->
    </Context>

在这两种方法中，我们面临着相同的错误。即“运行时：在JNDI中找不到数据源JDBC/WorklightAppDS”

Answer 1

尝试在datasourceJndiname中使用java:comp/env/${DataSource-jndi-Local}。