Hi, I want to know if anyone have got a "well formed" sample configuration code for informix data pooled connection with tomcat & struts (I've got tomcat 4.0.3 and jakarta-struts-1.0.2) : cause, the sample code from jakarta struts (jsp + configuration) don't work : i've got "null" datasource from the jndi context, but i can lookup "java:comp/env" well.
Here's my code // create the datapoolconnexion Context init = new InitialContext(); Context ctx = (Context) init.lookup("java:comp/env"); try { Object value = ctx.lookup("jdbc/datasourcename"); } catch (NamingException e) { throw new Exception("JNDI lookup failed : ", e); } DataSource ds = (DataSource)ctx.lookup("jdbc/datasourcename"); conn = ds.getConnection(); ... // in the web.xml of my webapp : <resource-ref> <description> Resource reference to a factory for java.sql.Connection instances that may be used for talking to a particular database that is configured in the server.xml file. </description> <res-ref-name> jdbc/datasourcename </res-ref-name> <res-type> javax.sql.DataSource </res-type> <res-auth> Container </res-auth> </resource-ref> // in the server.xml of tomcat <Context path="/eventFile" docBase="eventFile" debug="10"> <Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_eventfile_log." suffix=".txt" timestamp="true"/> <Resource name="jdbc/datasourcename" auth="Container" type="com.informix.jdbcx.IfxConnectionPoolDataSource"/> <ResourceParams name="jdbc/datasourcename"> <parameter> <name>user</name> <value>xxxxx</value> </parameter> <parameter> <name>password</name><value>xxxxxx</value></parameter> <parameter> <name>driverClassName</name><value>com.informix.jdbc.IfxDriver</value></para meter> <parameter> <name>driverName</name><value>jdbc:informix-sqli://xxxxxxxxxxxxx</value></pa rameter> </ResourceParams> </Context> If someone could send me any expert mailing list for that (like struts, informix ?) Cheers, Franck E. =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com