You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Richard Wheeldon <ri...@rswheeldon.com> on 2003/10/30 10:08:17 UTC
Oracle data-source problem with struts 1.1
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/password@malted.cs.ucl.ac.uk: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="maxCount" value="5"/>
<set-property property="minCount" value="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: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
Re: Oracle data-source problem with struts 1.1
Posted by Yann C�bron <ya...@yahoo.de>.
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/password@malted.cs.ucl.ac.uk: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="maxCount" value="5"/>
> <set-property property="minCount" value="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: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org