Oracle data-source problem with struts 1.1

2003-10-30 Thread Richard Wheeldon
Hi,

I recently upgraded my struts setup to the 1.1 release version.
Now I find that the data source used by my application to
connect to the database no longer works:

  data-sources
data-source key=db.user
  set-property property=url
 
value=jdbc:oracle:thin:user/[EMAIL PROTECTED]:1521:milk/
  set-property property=autoCommit  value=false/
  set-property property=description value=Taco User
Account/
  !-- set-property property=driverClass   
value=oracle.jdbc.driver.OracleDriver/ --
set-property property=driverClass
value=oracle.jdbc.pool.OracleConnectionPoolDataSource /
  set-property property=maxCountvalue=5/
  set-property property=minCountvalue=2/
/data-source
  /data-sources

If left like this, the container (tomcat) fails to start with
the exception:

java.lang.NullPointerException
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:258)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at
org.apache.catalina.loader.WebappClassLoader.loadClass(Unknown Source)
at
org.apache.catalina.loader.WebappClassLoader.loadClass(Unknown Source)
at
org.apache.struts.util.RequestUtils.applicationClass(RequestUtils.java:163)
at
org.apache.struts.util.RequestUtils.applicationInstance(RequestUtils.java:187)
at
org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:813)
at
org.apache.struts.action.ActionServlet.init(ActionServlet.java:389)
at javax.servlet.GenericServlet.init(GenericServlet.java)
at org.apache.catalina.core.StandardWrapper.loadServlet(Unknown
Source)
at org.apache.catalina.core.StandardWrapper.load(Unknown Source)


I've tried adding type=oracle.jdbc.pool.OracleConnectionPoolDataSource
to the data source element. This causes the following exception:

java.sql.SQLException: Invalid Oracle URL specified:
OracleDataSource.makeURL
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)
at
oracle.jdbc.pool.OracleDataSource.makeURL(OracleDataSource.java:966)
at
oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:134)
at
oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:108)
at
taco.struts.GetCourseWorkAction.execute(GetCourseWorkAction.java:39)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:449)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:264)

I've tried giving the URL without the username/password and setting them
in properties. Nothing seems to work. Any suggestions would be very much
appreciated. As I said, all this worked before upgrading the struts
jars.

Richard


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



Re: Oracle data-source problem with struts 1.1

2003-10-30 Thread Yann Cébron
Hi,

I stumbled upon the same thing..

The property url is URL (all uppercase) with the OracleDataSource ;-)

HTH,
Yann

 I recently upgraded my struts setup to the 1.1 release version.
 Now I find that the data source used by my application to
 connect to the database no longer works:

   data-sources
 data-source key=db.user
   set-property property=url

 value=jdbc:oracle:thin:user/[EMAIL PROTECTED]:1521:milk/
   set-property property=autoCommit  value=false/
   set-property property=description value=Taco User
 Account/
   !-- set-property property=driverClass
 value=oracle.jdbc.driver.OracleDriver/ --
 set-property property=driverClass
 value=oracle.jdbc.pool.OracleConnectionPoolDataSource /
   set-property property=maxCountvalue=5/
   set-property property=minCountvalue=2/
 /data-source
   /data-sources

 If left like this, the container (tomcat) fails to start with
 the exception:

 java.lang.NullPointerException
 at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:258)
 at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
 at
 org.apache.catalina.loader.WebappClassLoader.loadClass(Unknown Source)
 at
 org.apache.catalina.loader.WebappClassLoader.loadClass(Unknown Source)
 at

org.apache.struts.util.RequestUtils.applicationClass(RequestUtils.java:163)
 at

org.apache.struts.util.RequestUtils.applicationInstance(RequestUtils.java:18
7)
 at

org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.j
ava:813)
 at
 org.apache.struts.action.ActionServlet.init(ActionServlet.java:389)
 at javax.servlet.GenericServlet.init(GenericServlet.java)
 at org.apache.catalina.core.StandardWrapper.loadServlet(Unknown
 Source)
 at org.apache.catalina.core.StandardWrapper.load(Unknown Source)


 I've tried adding type=oracle.jdbc.pool.OracleConnectionPoolDataSource
 to the data source element. This causes the following exception:

 java.sql.SQLException: Invalid Oracle URL specified:
 OracleDataSource.makeURL
 at
 oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
 at
 oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
 at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)
 at
 oracle.jdbc.pool.OracleDataSource.makeURL(OracleDataSource.java:966)
 at
 oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:134)
 at
 oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:108)
 at
 taco.struts.GetCourseWorkAction.execute(GetCourseWorkAction.java:39)
 at

org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:449)
 at

org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:264)

 I've tried giving the URL without the username/password and setting them
 in properties. Nothing seems to work. Any suggestions would be very much
 appreciated. As I said, all this worked before upgrading the struts
 jars.

 Richard




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