Configuring JNDI for Database Custom Field

[DJX]

I cannot seem to get this plugin to work.

I have added the following resource in server.xml:

<Resource name="jdbc/myDB"

			 	 auth="Container" type="javax.sql.DataSource"

			 	 username="userName"

			 	 password="password"

			 	 driverClassName="net.sourceforge.jtds.jdbc.Driver"

			 	 url="jdbc:jtds:sqlserver://myserver:1433;database=MyDb;"

			  />

I have used this JNDI Name: java:comp/env/jdbc/myDB

and I get this error in the log:

2013-10-03 06:56:03,531 http-bio-8080-exec-2 ERROR user 416x85x1 vawvqi 10.255.32.85 /secure/QuickCreateIssue!default.jspa [commons.jira.kconfig.PluginConfiguration] Database JNDI >>java:comp/env/jdbc/myDB<<, error obtaining connection

2013-10-03 06:56:03,531 http-bio-8080-exec-2 ERROR user 416x85x1 vawvqi 10.255.32.85 /secure/QuickCreateIssue!default.jspa [databasecf.querydb.impl.QueryDatabaseImpl] Not connected. Possible database misconfiguration ?

2013-10-03 06:56:03,531 http-bio-8080-exec-2 ERROR user 416x85x1 vawvqi 10.255.32.85 /secure/QuickCreateIssue!default.jspa [databasecf.querydb.impl.QueryDatabaseImpl] Could not execute SQL query >>

[Radu Dumitriu · Accepted solution]

Use context.xml, not server.xml. It might work.

[DJX]

I have made the change to the DS name in the server.xml file as well as in the plugin configuration but I still get the same error. Is there a way I can test the connection string to confirm it is working properly?

[Radu Dumitriu]

Could you pls try the exact string "jdbc/myDB" ? I cannot find it right now, but JNDI had some problems with namespaces (e.g. "jdbc") on some tomcats, so what I recommend is to use a simple string "myDB" in both places. We anyway add the prefix "java:comp/env" and search for it if it is not found from the very first time ;)

Of course, this assumes that the config is right.

For reference: http://confluence.kepler-rominfo.com/display/DBCF/Data+Source+Configuration