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.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
@Manon Soubies-Camy is an engineer who has been an avid Atlassian user since 2014. She helps companies of all sizes transform the way they work with the Atlassian stack, including Jira and Confl...
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