DataSources with Orion

Discussions

EJB programming & troubleshooting: DataSources with Orion

  1. DataSources with Orion (1 messages)

    I'm just trying to verify that the Orion environment is properly configured, so I'm starting with a very simple client to make a JDNI connection, lookup a datasource and perform a couple of JDBC statements. When this is stable I'll move on.

    My first question: I can get my InitialContext, lookup the DataSource, and retrieve a connection. But when I try to get a ResultSet, I get this error:
    OrionCMTConnection not closed, check your code!
    LogicalDriverManagerXAConnection not closed, check your code!
    (Use -Djdbc.connection.debug=true to find out where the leaked connection was created)
    ?Say What?
    I tried "-Djdbc.connection.debug=true" and nothing was printed out. Here is the data-source entry in data-sources.xml:
        <data-source
            class="oracle.jdbc.pool.OracleConnectionPoolDataSource"
            name="OracleMustang"
            location="jdbc/OracleDS"
            ejb-location="jdbc/MustangDS"
            xa-location="jdbc/xa/OracleXADS"
            username="mustang_user"
            password="cybermac"
            schema="database-schemas/oracle.xml"
            url="jdbc:oracle:thin:@emcintyre-ntw:1521:mustang"
            inactivity-timeout="600"
            min-connections="3"
            max-connections="10"
            connection-retry-interval="5"
            wait-timeout="30"
        >
            <description>
                This DataSource provides a connection to the Oracle database that
                the Mustang application uses. It provides a pooled data source.
            </description>
            <property name="serverName" value="emcintyre-ntw" />
            <property name="portNumber" value="1521" />
            <property name="databaseName" value="mustang" />
        </data-source>
    (BTW - Orion refuses to start if I leave the "xa-location" attribute out of the element. Is this normal? I can leave the other locations out, but not that one.)

    Second question is more fundamental (sorry for such a long post!): Should I even be using the Oracle pooled version of the DataSource, or will Orion pool the regular DataSource for me?

    Thanks,
    Eric
  2. DataSources with Orion[ Go to top ]

    Anyone there???

    Let me put it another way: How do I set up Orion to use an Oracle database?