i'm having some trouble setting up a datasource on apache/tomcat that comes bundled with sun's solaris 9
i copied the jConnect5.5 jconn2.jar file to /usr/apache/tomcat/common/lib i pasted the new context (for connecting to the database) into the server.xml file in /var/apache/tomcat/conf the directory tree for the webapps looks like so: /var/apache/tomcat/webapps/sybase/jsp/sybase.jsp /var/apache/tomcat/webapps/sybase/WEB-INF/web.xml /var/apache/tomcat/webapps/sybase/WEB-INF/jsp/ i then stopped and then re-started apache when i call /var/apache/tomcat/webapps/sybase/jsp/sybase.jsp (it's a connection test file that Sybase provides) through http://hostname:port/sybase/jsp/sybase.jsp i get this error: Start of Test initCtx = new InitialContext() : successful [EMAIL PROTECTED] envCtx = initCtx.lookup(java:comp/env) : successful [EMAIL PROTECTED] Trying ds=(DataSource)envCtx.lookup(jdbc/a_sybase_datasource) Datasource lookup failed javax.naming.NamingException: Cannot create resource instance DataSource null Inside catch(Exception e) null java.lang.NullPointerException End of Test any ideas? context in server.xml ------------------------------ <!-- Sybase Example Context - dscp example --> <Context path="/sybase" docBase="sybase" debug="5" reloadable="true" crossContext="true"> <Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_Sybase.log." suffix=".txt" timestamp="true"/> <Resource name="jdbc/a_sybase_datasource" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/a_sybase_datasource"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>maxActive</name> <value>10</value> </parameter> <parameter> <name>maxIdle</name> <value>5</value> </parameter> <parameter> <name>maxWait</name> <value>10000</value> </parameter> <parameter> <name>driverClassName</name> <value>com.sybase.jdbc2.jdbc.SybDriver</value> </parameter> <parameter> <name>url</name> <value>jdbc:sybase:Tds:10.34.34.34:4300/mydb?JCONNECT_VERSION=6</value> </parameter> <parameter> <name>username</name> <value>myuser</value> </parameter> <parameter> <name>password</name> <value>mypasswd</value> </parameter> </ResourceParams> </Context> <!-- END Sybase Example Context - dscp example --> ------------------------------------- Thanks, Alan Czajkowski ------------------------------------- Database Administrator BMO Financial Group Decision Support Services 3300 Bloor Street West 14th Floor, West Tower Toronto, Ontario, M8X 2X2 Tel: 416.232.8736 -------------------------------------
