We do not use postgres, instead we use MSSQL 2008. Recently we have switched to using a stand alone tomcat install. Previously we used jetty and had no problems, but we're also trying to switch from Jasper 5.0 to 5.6 so there could be some snags there as well.
I have created a default_master.properties file in the buildomatic folder by copying the sql example from the sample_conf folder and editing it to point to our sql jasperserver database. I have also changed the context.xml file in META-INF to point to the correct sql database, however whenever I try to import something from the command line I always get:
Cannot load driver class: org.postgressql.driver
I don't want to use postgress. I've searched for any config files that refer to that and it seems to point to sql. Is there a config file I am missing?
IIf you are using the commercial edition and are building from the war file and want MSSQL for the repository, then look carefully at chapter 6 of the 5.6 install guide for the version you are installing. There were some changes to our support for MSSQL drivers around this time. In fact, there were changes to the drivers from 5.5 to 5.6.0 and then from 5.6.0 to 5.6.1. In 5.6.0, you will have to make sure that you have a driver of your own and that you put it in the correct location. IN 5.6.1, you can use your standard MSSQL driver or you can use the new commercial TIBCO driver that is in the project. If you are using your existing driver, you need to use your old buildomatic file, although you may need to modify it slightly for your new tomcat.
I believe you should not edit context.xml directly - the changs are propagated from default_master.properties.