OracleDriver fails 1.0 to 1.1 upgrade.

2003-12-11 Thread Mort Coleman
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=maxCountvalue=10 /
set-property property=minCountvalue=2 /
set-property property=URL
value=jdbc:oracle:thin:cmpcom_web_user/cnag@(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]



Re: OracleDriver fails 1.0 to 1.1 upgrade.

2003-12-11 Thread Antony Paul
try driverClassName.

Antony Paul.

- Original Message -
From: Mort Coleman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 11:40 AM
Subject: OracleDriver fails 1.0 to 1.1 upgrade.


 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=maxCountvalue=10 /
 set-property property=minCountvalue=2 /
 set-property property=URL

value=jdbc:oracle:thin:cmpcom_web_user/cnag@(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);
   }
}
 }

 file://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.j
ava: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]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]