Ingres configuration parameters

[rcbeuker]

Does anyone know the configuration parameters for setting up the Ingres database?

[robisz]

Put jdbc driver to server/your_config/lib directory.
Put a -ds.xml file to server/your_config/deploy directory with
the following content (change the db url).

<?xml version="1.0" encoding="UTF-8"?>

<datasources>
 <local-tx-datasource>
 <jndi-name>IngresDS</jndi-name>
 <connection-url>jdbc:edbc://host:a01/hostname::db</connection-url>
 <driver-class>ca.edbc.jdbc.EdbcDriver</driver-class>
 <min-pool-size>5</min-pool-size>
 <max-pool-size>20</max-pool-size>
 <idle-timeout-minutes>0</idle-timeout-minutes>
 <track-statements>true</track-statements>
 </local-tx-datasource>
</datasources>

[rcbeuker]

I am still a little confused; with the EdbcDriver I am using the edbc.jar instead of the also existing iijdbc.jar? What is the difference between these two drivers?

Anyway it works this way. For the folks who asking me questions about the <connection-url>:

My host name is gea and I use the hard coded port number 21072 (the logical link II7 from Ingress is not working). The name from the test database is titan

<connection-url>jdbc:edbc://gea:21072/gea::titan</connection-url>

Thanx ;-)

[rcbeuker]

"rcbeuker" wrote:
I am still a little confused; with the EdbcDriver I am using the edbc.jar instead of the also existing iijdbc.jar? What is the difference between these two drivers?

Anyway it works this way. For the folks who asking me questions about the <connection-url>:

My host name is gea and I use the hard coded port number 21072 (the logical link II7 from Ingress is not working). The name from the test database is titan

<connection-url>jdbc:edbc://gea:21072/gea::titan</connection-url>

Thanx ;-)

The JDBC connection URL is working with for example Borland Database Pilot. But the databse connection with Jboss is still not working. As a test I tried an example from the book O'Reilly JBoss 3.0/4.0 Workbook. I posted this test and the resultst in the O'Reilly JBoss 3.0/4.0 Workbook forum: http://www.jboss.org/index.html?module=bb&op=viewtopic&t=55834

Does anybody have some information?