Looking at the documentation for Bob Swift's SQL for Confluence addon (https://bobswift.atlassian.net/wiki/display/SQL/Data+Source+Profiles), I don't see any examples for SQL Server. There are application server based data source configurations (https://bobswift.atlassian.net/wiki/display/SQL/Data+source+configuration+-+application+server), but those require rebooting Confluence. I'd like to try the dynamic data source profile first.
Does anyone have an example for this? The format should be something like:
dbUrl=jdbc:jtds:sqlserver://localhost:1433| dbUser=username| dbPassword=password| dbDriver=??? | dbJar=???
Thanks!
This is what I have used.
dbDriver=net.sourceforge.jtds.jdbc.Driver|dbUrl=jdbc:jtds:sqlserver://{server}:1433/{database}|dbUser=user|dbPassword=password|dbJar=c:\Program Files\Atlassian\Confluence\confluence\WEB-INF\lib\jtds-1.2.2.jar
The configuration for data source profiles mirrors the information from the application server examples.
The app-server example doesn't explicitly reference a JAR: <Resource name="jdbc/myDS" auth="Container" type="javax.sql.DataSource" driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://mysqlserver:1433/mydatabase" username="username" password="password" maxActive="20" maxIdle="10" maxWait="-1" validationQuery="Select 1" /> But, I see that the app-server's "driverClassName" maps to the data source profile's "dbDriver".
@Davin Studer Thanks, I'll try that today!
It looks like you're new here. Sign in or register to get started.
