Re: [jtrac-users] Tomcat Can't Find My Jtrac Database Using JNDI

[Tom P. <to...@to...>]

I ended up figuring out what the problem was. The name of the data source was
ok, I needed to use the full path of the data source from the jtrac.properties
file.

So here's my data source declaration in /etc/tomcat6/context.xml:

...

    <Resource name="jdbc/JtracDB"
        auth="Container"
        type="javax.sql.DataSource"
        username="jtracdbo"
        password="somepass"
        driverClassName="com.mysql.jdbc.Driver"
        url="jdbc:mysql://localhost:3306/jtracdb"
        maxActive="100"
        maxIdle="30"
        maxWait="10000"  />

...

And here's my jtrac.properties file:

    database.driver=com.mysql.jdbc.Driver
    database.url=jdbc:mysql://localhost/jtracdb
    database.username=jtracdbo
    database.password=
    hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
    hibernate.show_sql=false
    database.datasource.jndiname=java:comp/env/jdbc/JtracDB

I hope this helps someone else who wants to deploy using a JNDI name for their
database.

Tom Purl