Porting to SQL-Server

Hi I'm trying to upgrade to v3.3.1 and at the same time port to SQL-Server, but I can't get Track to connect to SQL-Server.
Here's what I've done, so far:

Installed Track+ using the Windows Installer on a server where Track+ hasn't been installed before.
Installed SQL-Server on the same server.
Created a database named Track and a user named TrackUser
Run the three sql-scripts to create tables etc.
Alter Torque.properties (I've actually tried a lot of different settings) (see the latest attempt below).
(Track v3.3.0 is still running on the 'old' server).

I use SQL-Server Profiler to verify that Track+ doesn't even try to connect to SQL-Server

C:\Program Files\Apache Software Foundation\Tomcat 5.5\Webapps\track\Web-Inf\Torque.Properties:

torque.dsfactory.track.connection.user = TrackUser
torque.dsfactory.track.connection.password = MySecretPassword
torque.database.track.adapter=mssql
torque.dsfactory.track.connection.driver = net.sourceforge.jtds.jdbc.Driver
torque.dsfactory.track.connection.url = jdbc:jtds:sqlserver://127.0.0.1:1433/Track;user=TrackUser;password=MySecretPassword
torque.dsfactory.track.factory= org.apache.torque.dsfactory.SharedPoolDataSourceFactory
torque.dsfactory.track.pool.maxActive=30
torque.dsfactory.track.pool.testOnBorrow=true
torque.dsfactory.track.pool.validationQuery=SELECT PKEY FROM TSTATE

Any help will be very much appreciated.

1. If you have XP (SP2) and SQL Server 2000 please apply the Microsoft SQL Server 2000 Service Pack 4 from http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5
Apply this sp:
SQL2000-KB884525-SP4-x86-ENU.EXE

This sp is needed for jdbc connection.

2. Be sure that the user TrackUser has read/modify rights for all track tables.

If none of the above apply please let us know the error log (from the tomcat console or tomcat log file)

Sorry, I should have said: Im using SQL-Server 2005.
TrackUser is DBO, but as I wrote; it doesn't seem to even try to connect to the database. SQL-Server Profiler doesn't show any attempt to connect to the database.

These are the lines added to \Program Files\Apache Software Foundation\Tomcat 5.5\logs\stdout_20070131.log when I try to log on:

2007-02-05 12:30:36,976 [http-8080-Processor21] ERROR com.aurel.track.persist.TPersonPeer - Loading by loginname admin failed with org.firebirdsql.jdbc.FBSQLException: Resource Exception. I/O error for file CreateFile (open) "C:/Program Files/Track+/Database/track.gdb"
Error while trying to open file
null
Reason: I/O error for file CreateFile (open) "C:/Program Files/Track+/Database/track.gdb"
Error while trying to open file
null
[ERROR] BasePeer - Exception when loading message of the day: org.firebirdsql.jdbc.FBSQLException: Resource Exception. I/O error for file CreateFile (open) "C:/Program Files/Track+/Database/track.gdb"
Error while trying to open file
null
Reason: I/O error for file CreateFile (open) "C:/Program Files/Track+/Database/track.gdb"
Error while trying to open file
null
[ERROR] BasePeer - Exception when loading message of the day: org.firebirdsql.jdbc.FBSQLException: Resource Exception. I/O error for file CreateFile (open) "C:/Program Files/Track+/Database/track.gdb"
Error while trying to open file
null
Reason: I/O error for file CreateFile (open) "C:/Program Files/Track+/Database/track.gdb"
Error while trying to open file
null

It looks like it's still trying to connect to a Firebird-DB. Could it be, that I'm making changes to the wrong version of Torque.Properties?

If you do not plan to use Firebird as database you do not need to use the windows installer (which installs also the Firebird server and Tomcat server), use the war-file instead.
In this case you have to configure the database manually using the scripts, install a Tomcat (or other web container) and copy the war-file in the webapps directory of your Tomcat, then set the torque.properties from the war-file accordingly.

Regarding the errors from log yes, it seems that the application tries to connect to the Firebird server.
Have you commented out the entries which refer to the Firebird settings in your torque.properties?

Where did you edited the torque.properties: directly in the war-file or in the expanded directory (track-331)?

It is important to update your torque.properties in your war-file and delete the expanded war directory (track-331 directory) from webapps and then start Tomcat.
After restarting the track-331 directory will be created again.

PS
I would suggest to use the newest version 3.3.2 which removes some bugs found in 3.3.1 and gives you the possibility of Import and export from MS Project

I just saw that I wasn't logged on when i wrote the above comment. Sorry!

Hi again

I'm sorry, but I'm quite new at this, and I have no idea what a war-file is.
I have already run the Windows installer. Do I have to uninstall that installation, or can I just alter it?
Last I edited C:\Program Files\Apache Software Foundation\Tomcat 5.5\Webapps\track\Web-Inf\Torque.Properties. How do I set the torque.properties from the war-file? (Do I have to run some program to extract from the war-file?).
How do I upgrade from 3.3.1 to 3.3.2?

- Carsten Hynne

A war file is a zip file with special structure used for deploying java-based web applications.
The content of the war (C:\Program Files\Apache Software Foundation\Tomcat 5.5\Webapps\track.war) is exactly what you have in the C:\Program Files\Apache Software Foundation\Tomcat 5.5\Webapps\track directory:

In order to edit your torque.properties:

1. stop the tomcat
2. unpack the track.war file (like a zip) edit the torque.properties and then pack it back
3. delete the C:\Program Files\Apache Software Foundation\Tomcat 5.5\Webapps\track directory
4. restart the tomcat: the C:\Program Files\Apache Software Foundation\Tomcat 5.5\Webapps\track directory will be created again

I ask again: have you commented out the entries which refer to the Firebird settings in your torque.properties?

Regarding the installation, there are mainly two possibilities of installing track+:
1. Using the installer: the installer installs a Firebird server, a Tomcat server, creates the firebird database for the application, and you can use the application as it is. But in your case the Firebird server is not needed. (But it doesn’t hurt)
2. Manual installation (using the war file). You can download only the war file (from http://www.trackplus.com/products/download.html).
In this case:
-install a Tomcat manually (if not already installed)
-copy the war file in the webapps directory of the installed tomcat.
-create the database manually (using the scripts provided)
-edit your torque.properties in the war-file as described above

If you use other database as Firebird it’s suggested to use manual installation, using the downloaded war–file. (If you use the installer for other database servers you have to create your database manually anyway and set the torque.properties accordingly, and you will have a Firebird server installed which is not needed)

But, as an answer to your question, theoretically you do not have to uninstall the application installed with windows installer, it should work also in this way.

Upgrade from 3.3.1 to 3.3.2 is very easy:
Using installer: just install the 3.3.2 over your existing 3.3.1
Using war: overwrite the old war with the new one (and edit the torque.properties accordingly in the new war file).

Two more hints:

1. Please check that in your Torque.properties file all entries regarding Firebird are removed or commented out

2. Make sure you do not have an firewall problems. JDBC needs an open port to the database server.