-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Guillaume,

On 6/11/2009 5:48 AM, Guillaume M wrote:
> On my Vista version, I have the error "the name jdbc isn't bound to
> the context".

Sounds like your JNDI name is not correct.

>       <Resource       name="jdbc/authen"

This is correct.

>                               maxIdle="6000"
>                               maxWait="1000"
>                               maxActive="20000"

This is a LOT of connections. Are you sure you need 20000 database
connections? Are you sure MySQL will allow that many to connect?

>                               validationQuery="Select 1"

Try: "/* PING */ SELECT 1" -- you'll get better performance.

>                               removeAbandonnedTimeout="1000000"

1000 minutes? That's an awfully long time to consider a connection
abandoned. Do you have ridiculously-long-running queries? If not,
consider dropping this value to something more reasonable like 5 minutes.

>                       dataSourceName="jdbc/authen"

This is also correct.

>                       localDataSource="true"

Excellent: you have read the documentation!

>                       autoReconnect="true"

I don't believe this has any effect.

> GRAVE: Exception performing authentication
> javax.naming.NameNotFoundException: Le Nom jdbc n'est pas lié à ce Contexte
>       at org.apache.naming.NamingContext.lookup(NamingContext.java:770)
>       at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
>       at 
> org.apache.catalina.realm.DataSourceRealm.open(DataSourceRealm.java:403)
>       at 
> org.apache.catalina.realm.DataSourceRealm.authenticate(DataSourceRealm.java:284)

Okay, so the DataSourceRealm is failing to pick-up the DataSource.

> INFO: Starting Coyote AJP/1.3 on ajp-8009
> 11 juin 2009 08:16:13 org.apache.catalina.startup.Catalina start
> INFO: Server startup in 1125 ms
> </code>

Is there anything in catalina.out after these lines? How about after the
error (other than the exception itself)?

Where do you have your mysql-connector.jar file located? In order for
Tomcat to create this DataSource for you, you need to have it located in
$CATALINA_BASE/lib. It won't work if you have it in your webapp's
WEB-INF/lib directory.

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

iEYEARECAAYFAkoxLjcACgkQ9CaO5/Lv0PBqWQCfUuYk0KL4sUMFUcx5vRN5h1pE
B20AoMBmj1xJYzhMJoocAK87IdqMS0aL
=Ze9m
-----END PGP SIGNATURE-----

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

Reply via email to