hi,

i am using Oracle 9i as my datasource and have declared it in my struts-config as 
follows:

    <data-source key="DB" type="oracle.jdbc.pool.OracleConnectionPoolDataSource">
       <set-property property="autoCommit" value="false"/>
    <set-property property="description" value="DB_Connection_Pool"/>
    <set-property property="driverClass" value="oracle.jdbc.driver.OracleDriver"/>
 
    <set-property property="maxCount" value="5"/>
    <set-property property="minCount" value="1"/>
    <set-property property="password" value="password"/>
    <set-property property="url" value="jdbc:oracle:thin:@ip-of-server:1521:ORACLE1"/>
    <set-property property="user" value="user"/>

    </data-source>


however, when i come to use this datasource in my struts actions, it gives me the 
following error:


Invalid Oracle URL specified: OracleDataSource.makeURL


im accessing the datasource in my actions like so (i use the same thing with an 
SQLServer datasource and it works fine):

DataSource dataSource = (DataSource)servlet.getServletContext().getAttribute("DB");


also, i have my oracle driver jar in the commons folder in tomcat - could this be the 
cause


Any help would be much appreciated!
claire


Reply via email to