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]

Reply via email to