[Solved] GateIn 3.1 and Ingres 9.3

[namrata.hangal]

Hi,

Has anyone tried configuring GateIn Portal (Tomcat bundle) to work with Ingres?

[namrata.hangal]

Tried it myself. It works.

The steps are similar to the MySQL configuration described in Ranganathan Barathan's comment in the discussion http://community.jboss.org/wiki/ConfigureGateIntouseMySQL

1) Install ingres under the system user account "ingres" identified by password "ingres".

2) Create a database named "gatein_portal" in ingres. Provide access to system user "$ingres" because the owner is shown as "ingres", which is identified as database user and not system user by ingres!!

3) Change the configuration files

    configuration.properties

    jcr-configuration.xml

    idm-configuration.xml

    to include the ingres jdbc properties as follows:

    driver : com.ingres.jdbc.IngresDriver

    url      : jdbc:ingres://localhost:II7/gatein_portal

    username : ingres

    password : ingres

   Comment out other database related lines. Use the jdbc connector from the lib file in Ingres installation directory. iijdbc.jar

4) Restart GateIn-Tomcat

5) Point your browser to the url http://localhost:8080/portal

6) It works!

[rayfan]

Hi Namrata,

I've not tried GateIn, but I'm somewhat familiar with Ingres configuration.  I'm not sure that you need step 2, "$ingres" is an internal user.

1. I would create an unprivileged OS user for example, tomcat and it as an Ingres user using accessdb.
2. Create a database owned by tomcat; as the user ingres run the command createdb -utomcat gatein_portal
3. Adjust the JDBC URL by adding AUTO=MULTI and CURSOR=READONLY, jdbc:ingres://localhost:II7/gatein_portal;AUTO=MULTI;CURSOR=READONLY
4. Change the username and password with tomcat credentials.

For additional information on Ingres set-up and configuration there are many useful resources located on http://community.ingres.com/wiki/Category:Workshop.

[namrata.hangal]

Hi Ray,

Thanks for pointing out the tweaks for Ingres configuration.

Am totally new to Ingres also, so not much aware of the command line options!

Also, could you please tell me the relevance of AUTO=MULTI;CURSOR=READONLY ?

[rayfan]

Hi Namrata,

The AUTO setting is related to the handling of auto commit.  This link http://docs.ingres.com/ingres/10.0/connectivity-guide/1233-how-transactions-are-autocommitted describes the mechanism and the link http://docs.ingres.com/ingres/10.0/connectivity-guide/1347-autocommitmode-connection-propertyset-autocommit-processing-mode explains the settings.  It is related to when the auto commit is applied.

The CURSOR setting relates to the behaviour of a result set and is explained in part here http://docs.ingres.com/ingres/10.0/connectivity-guide/1235-cursors-and-result-set-characteristics.  In early implementations of the JDBC driver the default cursor mode was updateable and is now the default, I add it from habit.

You may like to try GateIn with Ingres 10.0 release where there have been several major enchancements and improvements.