Ingres settings

rcbeuker · **Joined:** Fri Mar 11, 2005 7:52 am **Posts:** 34

Hibernate version: 3.0

How do I set up Ingres for use with Hibernate? (where is the dialect?)

rcbeuker · **Joined:** Fri Mar 11, 2005 7:52 am **Posts:** 34

rcbeuker wrote:

Hibernate version: 3.0

How do I set up Ingres for use with Hibernate? (where is the dialect?)

Lots of internet sites are specifying Hibernates works with Ingres... But I cannot find any configuration. For example where is the dialect file for Ingres? (org.hibernate.dialect.IngresDialect). Is it working at this moment?

rcbeuker · **Joined:** Fri Mar 11, 2005 7:52 am **Posts:** 34

Quote:

All major relational database management systems are supported: Oracle, DB2, MySQL, PostgreSQL, Sybase, SAP DB, HypersonicSQL, Microsoft SQL Server, Informix, FrontBase, Ingres, Progress, Mckoi SQL, Pointbase and Interbase.

max · **Posted:** Tue Mar 15, 2005 8:15 am

eh ? The IngresDialect is bundled with hibernate - so what is your issue ?

rcbeuker · **Joined:** Fri Mar 11, 2005 7:52 am **Posts:** 34

max wrote:

eh ? The IngresDialect is bundled with hibernate - so what is your issue ?

excuse me, I took the

Code:

hibernate.properties

file as entry point for 'all' possible databases. In this file I could not find the settings for the Ingres database. Therefore the question...

Are there also some example settings for the Ingres database just as the settings for the other databases (dialect, driver_class, url, username and password)

max · **Posted:** Tue Mar 15, 2005 8:50 am

it should be pretty trivial.
use as with all other databases, the only thing that changes would the ingress jdbc url which is unique for your installation.

Look in the ingress jdbc driver doc for it.

rcbeuker · **Joined:** Fri Mar 11, 2005 7:52 am **Posts:** 34

max wrote:

it should be pretty trivial.
use as with all other databases, the only thing that changes would the ingress jdbc url which is unique for your installation.

Look in the ingress jdbc driver doc for it.

For the busy Hibernate/Ingres users:

Code:

hibernate.dialect org.hibernate.dialect.IngresDialect
hibernate.connection.driver_class ca.edbc.jdbc.EdbcDriver
hibernate.connection.url jdbc:edbc://localhost:II7/database
hibernate.connection.username user
hibernate.connection.password password