Tomcat apache fails to start on microsoft SQL server installation - Forum - Rollbase - Progress Community

Tomcat apache fails to start on microsoft SQL server installation

 Forum

Tomcat apache fails to start on microsoft SQL server installation

  • ANy help will be appreciated. The setup is

    Win2008 R2 64 Bit

    SQL2008



    java SE 6u31

    Apache 6



    Thanks.
  • Please make sure your jdbc driver is compatible with 64bit OS. You may also post question on SQL Server forum. This is clearly does not look like a problem with Rollbase software.
  • hi orbisrb,



    Maybe this could help you...



    - Since your using windows operating system, i would suggest to use windows service installer in your application.

    - Let's clean first your environment..

    - Delete or uninstall tomcat and its folders and sub-folders

    - drop/delete your existing RB_DBO database in MS-SQL server

    - download tomcat 32bit/64bit Windows Service Installer from tomcat website

    - install tomcat6 using windows service installer.

    - check if your tomcat is successfuly installed. type localhost:8080 to URL address field

    - stop your tomcat services, try to use the stop/start button in the task bar. You may find it in the bottom right of your screen

    - proceed to RB proper installation.

    - unzip Rollbase.zip to /Tomcat directory

    - unzip Webapps.zip to /Tomcat/webapps

    - unzip lib.zip to /Tomcat/lib

    - modify the shared.properties using your own preferred info

    - modify your database.xml based on the script that i previously post

    - copy sqljdbc4.jar to /tomcat/lib

    - create RB_DBO database
  • I will modify Rollbase code to deliver more detailed error message. But that will not fix the issue with your installation. Call to Class.forName() fails and JDBC driver cannot be loaded in your environment.
  • Thanks Walter!
  • Thanks for all your help.

    We have this working now.

    The driver name in the databases.xml file which came with the install was "com.microsoft.jdbc.sqlserver.SQLServerDriver" instead of "com.microsoft.sqlserver.jdbc.SQLServerDriver"

    Fixed the name and it's all working nicely.

    Once again, thanks!
  • Great news! And thanks for the update. We'll check with Walt and others whether this change was necessary for them as well and if so, update the default value in databases.xml (if not we'll include a warning or note about this).



    Valuable find.
  • Solved (by Orbis; thanks also to whaltz for stepping in) by changing driver name in the databases.xml file which comes with the install from "com.microsoft.jdbc.sqlserver.SQLServerDriver" to "com.microsoft.sqlserver.jdbc.SQLServerDriver"