I am configuring SQL for confluence plugin but i am getting the below error.
Error rendering macro 'sql-query' : Unable to load database driver: net.sourceforge.jtds.jdbc.Driver. Make sure your configuration is correct
Step 1: Placed jtds-1.3.1.jar under lib directory.
Step 2: updated the context.xml under conf with the below.
Step 3: restarted Tomcat
Step 4: in the sql plugin configuration screen updated the information.
Add a profile named: InventoryDB
with profile value:
dbDriver=net.sourceforge.jtds.jdbc.Driver | dbUrl=jdbc:jtds:sqlserver://servername:1433/wiki;instance=UAT| dbUser=username|dbPassword=password| dbJar=lib/jtds-1.3.1.jar
Can Some one Please let me know if i am missing anything from my end ?
First, you only need one of these configurations. Either application defined data source (your first 3 steps) or the data source profile configuration. See Data Sources for more information.
In your case, the data source profile configuration will override the other configuration. I suspect you Confluence server is on Windows. Suggest setting the dbJar to the full path name to the jar file.
If you still have problems, please open a support issue.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
I am gathering information about resources available for Atlassian product knowledge transferring for a presentation in our local Atlassian User Group. I want to group them in four categories From ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs