On 5/19/07, Rashmi Rubdi <[EMAIL PROTECTED]> wrote:
> This is what's configured as a global resource in server.xml:
> <Resource name="AdminCop"
>                     min="1"
>                     max="1"
>                     auth="Container"
>                     type="javax.sql.DataSource"
>                     factory="org.objectweb.jndi.DataSourceFactory"
>                    driverClassName="oracle.jdbc.driver.OracleDriver"
>                     username="xxx"
>                     password="xxx"
>                     url="jdbc:oracle:thin:@localhost:xxxx:XXX" />


In addition to the configuration checks I've mentioned in my previous
post, also check that you've configured the web.xml correctly.

Here's my configuration for reference, it works with Tomcat 6.0.10 and
Oracle 10g

-------------------------------------------------------------------
web.xml
-------------------------------------------------------------------
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/myoracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

-------------------------------------------------------------------
<Context> xml  or server.xml <Context tag
-------------------------------------------------------------------

<Context path="" docBase="......." reloadable="true" debug="true">

                <Resource name="jdbc/myoracle" auth="Container" 
type="javax.sql.DataSource"
                        maxActive="20" maxIdle="10"  maxWait="-1"
                        username="xxxxx" password="xxxxx" 
driverClassName="oracle.jdbc.OracleDriver"
                        url="jdbc:oracle:thin:@Venus:1521:XE"/>

</Context>

----------------------------------------------------------------------
Place ojdbc14_g.jar under
....\apache-tomcat-6.0.10\lib\  folder

-Regards
Rashmi

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to