tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anjib Mulepati <anji...@hotmail.com>
Subject Re: JNDI configuration with 6.0.29
Date Wed, 07 Sep 2011 17:10:39 GMT
i change to
<Resource name="jdbc/dynic"
             auth="Container"
             type="javax.sql.DataSource"
             driverClassName="oracle.jdbc.driver.OracleDriver"
             url="jdbc:oracle:thin:@//localhost:4001/SAIDIT"
             user="sfed_schema"
             password="sfed_schema"
             maxActive="20"
             maxIdle="10"
             maxWait="-1" />

and still same problem.
On 9/7/2011 12:31 PM, Christopher Schultz wrote:
> -----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
>
>
>


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


Mime
View raw message