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 >>
Use context.xml, not server.xml. It might work.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.