Fixx setup changes

From Ingres Community Wiki

Jump to: navigation, search

[edit]

Using Ingres as the data source

Assume that the home directory is /opt/fixx-1.4 then the following paths are relative to the home directory.

Put the JDBC Driver in fixx/WEB-INF/lib. A soft link or copy of the /opt/Ingres/IngresII/ingres/lib/iijdbc.jar.

cd /opt/fixx-1.4/fixx/WEB-INF/lib
ln -s /opt/Ingres/IngresII/ingres/lib/iijdbc.jar iijdbc.jar

Modify fixx/WEB-INF/classes/jdbc.properties to connect to the Ingres DB and change hibernate.dialect to org.hibernate.dialect.IngresDialect

cd /opt/fixx-1.4/fixx/WEB-INF/classes
cat <<! > jdbc.properties
jdbc.driverClassName=com.ingres.jdbc.IngresDriver
jdbc.url=jdbc:ingres://localhost:II7/fixxdb;CURSOR=READONLY;AUTO=MULTI
jdbc.username=tomcat
jdbc.password=tomcat
hibernate.dialect=org.hibernate.dialect.IngresDialect
!

Modify fixx/WEB-INF/classes/applicationContext-resources.xml and edit the dataSource XML specification to use the Ingres JDBC Driver and connection details for the DB.

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="com.ingres.jdbc.IngresDriver"/>
        <property name="url" value="jdbc:ingres://localhost:II7/fixxdb;CURSOR=READONLY;AUTO=MULTI"/>
        <property name="username" value="tomcat"/>
        <property name="password" value="tomcat"/>
        <property name="maxActive" value="100"/>
        <property name="maxIdle" value="30"/>
        <property name="maxWait" value="1000"/>
        <property name="defaultAutoCommit" value="false"/>
        <property name="removeAbandoned" value="true"/>
        <property name="removeAbandonedTimeout" value="60"/>
    </bean>

Finally, modify fixx/WEB-INF/classes/applicationContext-dao.xml and change the hibernate.dialect setting for sessionFactory bean to org.hibernate.dialect.IngresDialect.

    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="configLocation" value="classpath:hibernate.cfg.xml"/>
        <property name="hibernateProperties">
            <value>
                hibernate.dialect=org.hibernate.dialect.IngresDialect
                hibernate.query.substitutions=true 'Y', false 'N'
                hibernate.cache.use_second_level_cache=true
                hibernate.cache.provider_class=org.hibernate.cache.EhCacheProvider
                hibernate.jdbc.batch_size=0
            </value>
        </property>
    </bean>

Open port 9000 in the firewall

[edit]

Manual schema creation

At this point the remaining set-up should be using the Web interface by entering the URL address http://hostname:9000 in a browser
- We found that Fixx uses Apache DdlUtil which doesn't seem to support Ingres and the first attempt to set-up results in a Java NullPointerException.
The following steps are a manual database setup
1. Download and unzip the Fixx set-up scripts
2. Create a database for the metadata repository
```
createdb fixxdb
```
3. Load the schema using the fixxdb-schema-1.4.sql script
```
sql fixxdb < fixxdb-schema-1.4.sql
```
4. Load the initial data for general options and an administrator user
```
sql fixxdb < fixx-setup-data-1.4.sql
```
  Note: As the repository is being updated directly care is required to avoid value conflicts in key columns using a sequence; hence, the appearance of an alter sequence statement at the end of this script.
5. Start the fixx application. In the /opt/fixx-1.4/bin directory run the startup.sh script
```
./startup.sh
```
6. Start a Web browser and enter the URL http://hostname:9000
  - The application should start on the Dashboard page
7. Login as the administrator user and continue to configure the application