Hi,
i am one of the guys trying to get a valid MysqlDataSource reference via
JNDI. But i am getting crazy without knowing where the problem is (perhaps
the reason is, i cant debug JNDI too good, cause i am no expert in it..)
i have the following:
server.xml
----------
<context ....>
<Resource name="jdbc/TestDB" auth="Cotainer" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/TestDB">
<parameter>
<name>factory</name>
<value>org.gjt.mm.mysql.jdbc2.optional.MysqlDataSourceFactory</value>
</parameter>
<parameter> <name>user</name><value>root</value> </parameter>
<parameter> <name>password</name><value></value> </parameter>
<parameter>
<name>driverClassName</name><value>org.gjt.mm.mysql.jdbc2.optional.MysqlDataSource</value></parameter>
<parameter> <name>driverName</name><value>jdbc:mysql://localhost/maxbahr</value>
</parameter>
</ResourceParams>
</context>
web.xml
-------
<web-app>
<resource-ref>
<description>DataSource MySQL</description>
<res-ref-name>jdbc/TestDB</res-ref-name>
<res-type> javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
i placed the mysql mm jar into commons/lib
When i run a servlet with the standard lookup code:
try {
javax.naming.Context jndictx = new InitialContext();
if (jndictx == null) throw new Exception("Boom - No Context");
DataSource ds =
(DataSource) jndictx.lookup("java:comp/env/jdbc/TestDB");
if (ds != null) {
[..]
i get no exception but i also dont get any reference returned from lookup.
I read tons of websites including the tomcat JNDI howto, without beeing able to
understand it
better (in fact it gets worse cause of thousands of combinations in the web for
server.xml and
web.xml)
When i leave out factory in the server.xml, i get a tyrex exception regarding loading
a factory...
I just thought that using a datasource is better than just calling the DriverManager,
but the
effort seems amazing... or i am too unclever... whatever...
thx for help.
---
greetings from
Marc Logemann
Homebase @ www.logemann.info
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
