I found one posting about the url needing to be URL but did not help. here is my struts-config.xml portion: <data-sources> <data-source> <set-property property="description" value="Supporting Database" /> <set-property property="driverClass" value="oracle.jdbc.driver.OracleDriver" /> <set-property property="maxCount" value="10" /> <set-property property="minCount" value="2" /> <set-property property="URL" value="jdbc:oracle:thin:cmpcom_web_user/cnagxxxx@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=66.134.16.9)(PORT=8007)))(CONNECT_DATA=(SERVICE_NAME=DEV1.BOOSHLAKA.COM)))" /> </data-source> </data-sources> ActionServlet: MowerPartsActionServlet: --start here --
package com.cmp.servlet; import java.sql.Connection; import java.sql.SQLException; import javax.sql.DataSource; import javax.servlet.ServletException; import org.apache.struts.action.ActionServlet; import org.apache.struts.util.GenericDataSource; import com.cmp.db.IdentifyDatabase; /** * Make sure to identify the default database in use upon * starting/initializing this context. * * @version 27 February 2002 */ public class MowerPartsActionServlet extends ActionServlet{ public void init() throws ServletException{ super.init(); DataSource dataSource = this.findDataSource(null); try{ Connection conn = dataSource.getConnection(); IdentifyDatabase.setDB(conn); conn.close(); System.out.println("Database detected: " + IdentifyDatabase.getDB()); } catch (SQLException e){ this.log("Error getting DB connection.", e); } } } //finish here log portion here Dec 10, 2003 12:39:21 AM org.apache.struts.util.PropertyMessageResources <init> INFO: Initializing, config='ApplicationResources', returnNull=true Dec 10, 2003 12:39:21 AM org.apache.struts.action.ActionServlet initModuleDataSources SEVERE: Initializing application data source org.apache.struts.action.DATA_SOURCE java.sql.SQLException: open: java.lang.NullPointerException at org.apache.struts.legacy.GenericDataSource.open(GenericDataSource.java:735) at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:1085) at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472) at com.cmp.servlet.MowerPartsActionServlet.init(MowerPartsActionServlet.java:26) at javax.servlet.GenericServlet.init(GenericServlet.java:256) --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]