Confluence 5.10 service startup error, via tomcat8

[Joshi Shushruth]

I am trying to upgrade to the new confluence version 5.10.

I downloaded the Confluence 5.10.1 - Standalone (ZIP Archive) from Atlassian Downloads.

I have set up my JAVA_HOME env variable to point to: C:\Program Files\Java\jdk1.8.0_91 which is also 64-Bit. 

I was successfully able to install confluence using:

service.bat install Confluence5101,

I am getting an error when I try to start the service from the Services window.

An image of the error I get is shown below.error.png

And having a look at my common-daemons.log i get this error:

[2016-07-13 12:24:37] [info]  [ 2588] Commons Daemon procrun (1.0.15.0 32-bit) started
[2016-07-13 12:24:37] [info]  [ 2588] Running 'Confluence5101' Service...
[2016-07-13 12:24:37] [info]  [ 2280] Starting service...
[2016-07-13 12:24:37] [error] [ 2280] %1 is not a valid Win32 application.
[2016-07-13 12:24:37] [error] [ 2280] Failed creating java C:\Program Files\Java\jdk1.8.0_91\jre\bin\server\jvm.dll
[2016-07-13 12:24:37] [error] [ 2280] %1 is not a valid Win32 application.
[2016-07-13 12:24:37] [error] [ 2280] ServiceStart returned 1
[2016-07-13 12:24:37] [error] [ 2280] %1 is not a valid Win32 application.
[2016-07-13 12:24:37] [info]  [ 2588] Run service finished.
[2016-07-13 12:24:37] [info]  [ 2588] Commons Daemon procrun finished
[2016-07-13 12:30:17] [info]  [ 3012] Commons Daemon procrun (1.0.15.0 32-bit) started
[2016-07-13 12:30:17] [info]  [ 3012] Running 'Confluence5101' Service...
[2016-07-13 12:30:17] [info]  [ 4108] Starting service...
[2016-07-13 12:30:17] [error] [ 4108] %1 is not a valid Win32 application.
[2016-07-13 12:30:17] [error] [ 4108] Failed creating java C:\Program Files\Java\jdk1.8.0_91\jre\bin\server\jvm.dll
[2016-07-13 12:30:17] [error] [ 4108] %1 is not a valid Win32 application.
[2016-07-13 12:30:17] [error] [ 4108] ServiceStart returned 1
[2016-07-13 12:30:17] [error] [ 4108] %1 is not a valid Win32 application.
[2016-07-13 12:30:17] [info]  [ 3012] Run service finished.
[2016-07-13 12:30:17] [info]  [ 3012] Commons Daemon procrun finished

Any help would be great.

Cheers

Joshi

UPDATE: I changed the JVM path by executing the:

tomcat8w.exe // ES//Confluence5010

I changed the JVM path and used the 32-bit Version for jre using the path: 

C:\Program Files (x86)\Java\jre1.8.0_91\bin\client\jvm.dll

changedJVMpath.png

When i try to execute the service again I get a different kind of error:

serviceserror.png

changedJVMpath.png

serviceserror.png

error.png

[Bruno Vincent · Accepted solution]

Hi Joshi,

This is a know problem, please set you JVM path back to 64 bit and follow the steps detailed on this page: https://confluence.atlassian.com/confkb/problem-with-installing-confluence-standalone-zip-file-as-windows-service-with-64-bit-jdk-jre-632358039.html

[Joshi Shushruth]

Hi Bruno,

I have got the confluence service starting, but it gives me a 500 error. I had a look at the log file which gives me this:

Caused by: net.sf.hibernate.exception.GenericJDBCException: Cannot open connection
	at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80)
	at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
	at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
	at net.sf.hibernate.impl.BatcherImpl.convert(BatcherImpl.java:328)
	at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:295)
	at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3407)
	at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3367)
	at org.springframework.orm.hibernate.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:422)
	... 126 more
Caused by: java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null'
	at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2160)
	at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2032)
	at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1532)
	at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
	at bucket.core.persistence.hibernate.ConfluenceSharedConnectionProvider.getConnection(ConfluenceSharedConnectionProvider.java:34)
	at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:292)
	... 129 more
Caused by: java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getDriver(DriverManager.java:315)
	at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2144)
	... 134 more
2016-07-15 09:15:55,711 ERROR [Navlink Plugin Executor:thread-9] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Cannot create JDBC driver of class '' for connect URL 'null'

Im not sure what the problem here is. 

I am using MS SQL server as an external database, i have set up web.xml and server.xml as required.

Any suggestions on this?

[Bruno Vincent]

Hi Joshi,

Maybe you just forgot to copy the MS SQL Server driver (jtds-[version].jar) to Tomcat's lib directory?

(Step 2 on https://confluence.atlassian.com/display/CROWD/MS+SQL+Server)

[Joshi Shushruth]

Awesome, that seemed to fix it.