tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: JNDI configuration with 6.0.29
Date Wed, 07 Sep 2011 16:31:18 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Anjib,

On 9/7/2011 12:21 PM, Anjib Mulepati wrote:
> I did checked the XML file and it looks correct to me. Following is
> the content:
> 
> <?xml version="1.0" encoding="UTF-8"?> <Context
> antiJARLocking="true" docBase="C:\Users\amulepati\My 
> Projects\ClientDAOTest\build\web" path="/ClientDAOTest">

It probably has no bearing on this particular problem, but the "path"
attribute is illegal here.

> <Resource auth="Container" 
> driverClassName="oracle.jdbc.driver.OracleDriver" 
> factory="oracle.jdbc.pool.OracleDataSourceFactory"

Do you need to use Oracle's DataSourceFactory? If not, allow Tomcat to
use it's own DataSourceFactory.

> maxActive="20" maxIdle="10" maxWait="-1" name="jdbc/dynic"

I'm curious why the lookup fails with the message about "dynic" and
not, as Felix asks, "jdbc/dynic".

> password="sfed_schema" type="oracle.jdbc.pool.OracleDataSource" 
> url="jdbc:oracle:thin:@//localhost:4001/SAIDIT" 
> user="sfed_schema"/>

I have "username" as the attribute in my <Resource>, but this might be
the way you have to configure Oracle's factory. Here's what I've got
in my configuration:

   <Resource name="jdbc/db"
    description="db"
        auth="Container"
        type="javax.sql.DataSource"
        maxActive="1"
        maxIdle="1"
        maxWait="10000"
        url="jdbc:[url]"
        username="scott"
        password="tiger"
        driverClassName="com.mysql.jdbc.Driver"
        removeAbandoned="true"
        removeAbandonedTimeout="30"
        logAbandoned="true"
        testOnBorrow="true"
        validationQuery="/* ping */ SELECT 1"
    />

(That "validationQuery" is a short-cut for MySQL connection testing.
Feel free to use something like "SELECT 1 FROM DUAL" when using Oracle).

> Same config work for Tomcat 7 so I am wondering is there any thing
> I have to different/extra in Tomcat 6

The configuration should be identical to Tomcat 6.

Do you see any messages in your logs during webapp startup?

I wrote a JSP-based JNDI navigator a while back but I can't seem to
find it. Maybe I'll whip one up so you can look-around the JNDI tree
to see if your DataSource is just misplaced. I'm sure you can write
one yourself fairly easily, too.

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk5nnFYACgkQ9CaO5/Lv0PAFrwCfcrpNdl8EiBvtsSc2ju5Lp7LF
MzsAn35+pyrAivj6TtHBMWj6G6rL5+UN
=sBGp
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message