Три дня колбасимся по указанной теме.
Не хочет видеть pool connection к Oracle 9 через JNDI (всякие common...jar и JNDI.jar имеются и подключены в проекте).
Вот такой кусочек исходного текста (можно сказать стандартный):
1.
2.
3.
4.
5.
...
Context init = new InitialContext();
Context ctx = (Context) init.lookup("java:comp/env");
DataSource dataSource = (DataSource) ctx.lookup("jdbc/LoginProvider");
...
А вот это в server.xml Tomcat от JBuilderX
<?xml version="1.0" encoding="UTF-8"?>
<Server debug="9" port="8081" shutdown="SHUTDOWN">
<GlobalNamingResources>
<Resource name="jdbc/LoginProvider" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/LoginProvider">
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>username</name>
<value>LOGINPROVIDER</value>
</parameter>
<parameter>
<name>password</name>
<value>LOGINPROVIDER</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:loginprovider@10.1.1.99:1521:ORATEST</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
</ResourceParams>
</GlobalNamingResources>
<Service name="Tomcat-Standalone">
<Connector acceptCount="10" className="org.apache.coyote.tomcat4.CoyoteConnector" connectionTimeout="60000" debug="0" maxProcessors="75" minProcessors="5" port="8080"/>
<Engine debug="9" defaultHost="localhost" name="Standalone">
<Host appBase="D:\Log_in\Tomcat\webapps" debug="9" name="localhost" unpackWARs="true"/>
</Engine>
</Service>
</Server>
А вот это в web.xml (Тут еще настройки для Struts, но они к к сути вопроса отношения не имеют )
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<display-name>LoginWM</display-name>
<servlet>
<servlet-name>action</servlet-name>
<servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
<init-param>
<param-name>config</param-name>
<param-value>/WEB-INF/struts-config.xml</param-value>
</init-param>
<init-param>
<param-name>debug</param-name>
<param-value>2</param-value>
</init-param>
<init-param>
<param-name>application</param-name>
<param-value>ApplicationResources</param-value>
</init-param>
<load-on-startup>2</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>action</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<taglib>
<taglib-uri>/WEB-INF/struts-bean.tld</taglib-uri>
<taglib-location>/WEB-INF/struts-bean.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/WEB-INF/struts-html.tld</taglib-uri>
<taglib-location>/WEB-INF/struts-html.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/WEB-INF/struts-logic.tld</taglib-uri>
<taglib-location>/WEB-INF/struts-logic.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/WEB-INF/struts-template.tld</taglib-uri>
<taglib-location>/WEB-INF/struts-template.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/WEB-INF/struts-tiles.tld</taglib-uri>
<taglib-location>/WEB-INF/struts-tiles.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/WEB-INF/struts-nested.tld</taglib-uri>
<taglib-location>/WEB-INF/struts-nested.tld</taglib-location>
</taglib>
<resource-ref>
<description>Resource reference to a factory for java.sql.Connection
instances in the server.xml file.
</description>
<res-ref-name>jdbc/LoginProvider</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
Может кто-нибудь из тех кто отлаживал приложения с JNDI в JBuilderX поделятся опытом?
Electronic Insect
