3 Replies Latest reply on Nov 4, 2004 6:52 AM by Roland Beuker

    Ingres configuration parameters

    Roland Beuker Newbie

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

        • 1. Re: Ingres configuration parameters
          Robert Szalai Newbie

          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>


          • 2. Wat is the difference between edbc.jar and iijdbc.jar
            Roland Beuker Newbie

            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 ;-)

            • 3. Ingres still not working with JBoss...
              Roland Beuker Newbie

               

              "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?