Details
-
Bug
-
Resolution: Obsolete
-
Medium
-
6.4.2
-
5
-
Severity 3 - Minor
-
2
-
Description
STEPS TO REPLICATE
- Install Confluence version 6.4.2 (using atlassian-confluence-6.4.2.tar.gz for this test)
- During the database setup, Driver Class Name is automatically set to use com.microsoft.sqlserver.jdbc.SQLServerDriver as per screenshot below:
- Enter the database URL and credential.
- Complete the installation.
EXPECTED BEHAVIOUR
User able to create a page after the installation.
ACTUAL BEHAVIOUR
Stack trace below appear in Confluence <HOME_directory>/logs/atlassian-synchrony.log:
2017-10-20 21:40:11,815 DEBUG [197:StdOutHandler [/Library/Java/JavaVirtualMachines/jdk1.8.0_102.jdk/Contents/Home/jre/bin/java]] Could not load driverClass net.sourceforge.jtds.jdbc.Driver 2017-10-20 21:40:11,815 DEBUG [197:StdOutHandler [/Library/Java/JavaVirtualMachines/jdk1.8.0_102.jdk/Contents/Home/jre/bin/java]] java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
User unable to create/edit page:
WORKAROUND
update the jtds url to a correctly formatted Microsoft SQL Server driver url as per their documentation (https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url) :
- Stop Confluence
- Navigate to Confluence <HOME_directory>/confluence.cfg.xml file and replace the line below:
<property name="hibernate.connection.url">jdbc:jtds:sqlserver://localhost:1433/confluence</property>
with:
<property name="hibernate.connection.url">jdbc:sqlserver://localhost:1433;databaseName=confluence</property>
- Start Confluence
Attachments
Issue Links
- is caused by
-
CONFSERVER-54000 During database setup, using a mismatched driver class and jdbc connection url does not fail the connection tests
- Closed