Console dialog displays the following Info on editing the database pool
settings:
Pool Type:
TranQL XA Resource Adapter for Oracle
A resource adaptor that provides access to an Oracle database with XA
transaction support.
This is the plan:
<?xml version="1.0" encoding="UTF-8"?>
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2";>
<dep:environment
xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2";>
<dep:moduleId>
<dep:groupId>console.dbpool</dep:groupId>
<dep:artifactId>oracle.dsa</dep:artifactId>
<dep:version>1.0</dep:version>
<dep:type>rar</dep:type>
</dep:moduleId>
<dep:dependencies>
<dep:dependency>
<dep:groupId>oracle</dep:groupId>
<dep:artifactId>oracle</dep:artifactId>
<dep:version>jdbc14</dep:version>
<dep:type>jar</dep:type>
</dep:dependency>
</dep:dependencies>
</dep:environment>
<resourceadapter>
<outbound-resourceadapter>
<connection-definition>
<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
<connectiondefinition-instance>
<name>oracle.erbreg.withplan</name>
<config-property-setting
name="NetworkProtocol">tcp</config-property-setting>
<config-property-setting
name="PortNumber">1521</config-property-setting>
<config-property-setting name="TNSEntryName"/>
<config-property-setting name="MaxStatements"/>
<config-property-setting
name="DataSourceName">OracleXADatasourceWithTranql</config-property-setting>
<config-property-setting
name="DriverType">thin</config-property-setting>
<config-property-setting
name="Password">xxx</config-property-setting>
<config-property-setting
name="ServerName">localhost</config-property-setting>
<config-property-setting name="Description"/>
<config-property-setting name="LoginTimeout"/>
<config-property-setting name="DatabaseName"/>
<config-property-setting
name="ServiceName">XE</config-property-setting>
<config-property-setting
name="UserName">xxx</config-property-setting>
<connectionmanager>
<xa-transaction>
<transaction-caching/>
</xa-transaction>
<single-pool>
<max-size>10</max-size>
<min-size>0</min-size>
<match-one/>
</single-pool>
</connectionmanager>
</connectiondefinition-instance>
</connection-definition>
</outbound-resourceadapter>
</resourceadapter>
</connector>
Yes you'r right, i also want to use the datasource within login module. But
so far i did not try access by program. I only used the test mode when
configuring the security realm. This should work - it worked without
problems when configuring the postgresql database.
thanks for your help,
Ralf
djencks wrote:
>
> Could you please show the plan for the datasource (fine to remove
> username/pw, but knowing the dependencies could be useful) and which
> tranql wrapper you are using?
>
> Am I correct in thinking that you are using this datasource in an sql
> login module in your security realm?
>
> thanks
> david jencks
>
> On May 25, 2009, at 9:55 AM, rbaumhof wrote:
>
>>
>> Hallo, we have got the following problem.
>>
>> Our application is nearly ready developed with a PostgreSQL Database
>> server.
>> All works fine. Now the customer want's to migrate to Oracle database
>> server. We use EJB 5 standards with managed datasources. Now we have
>> problems to configure a XA datasource in geronimo. Access with
>> oracle local
>> or oracle thin seemed to work partly, but no commits have been made.
>> This
>> problem was earlier reported from other people in the forum (search
>> for
>> oracle XA). Does anybody know how to configure an oracle datasource
>> with
>> geronimo console dialog?
>>
>> Our settings are:
>> user / password: don't matter but ok
>> Service Name: xe
>> Port Number: 1521
>> Data Source name: (??)
>> Network Protocol: tcp (??)
>> Database Name: (??)
>> Driver Type: thin (??)
>> Servername: 127.0.0.1 (server run's on localhost)
>>
>> What could be good values for Data Source Name, Network Protocol,
>> Database
>> Name and Driver Type.
>>
>> The error i get on configuring an Security Realm is:
>> at java.lang.Thread.run(Thread.java:595)
>> Caused by: java.sql.SQLException: E/A-Exception: Connect identifier
>> is empty
>> at oracle.jdbc.driver.DatabaseError.throwSqlException(Databa
>> :111)
>> at oracle.jdbc.driver.DatabaseError.throwSqlException(Databa
>> :145)
>> at oracle.jdbc.driver.DatabaseError.throwSqlException(Databa
>> :254)
>> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java
>> at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConn
>> 413)
>> at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.jav
>> at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDr
>> n.java:34)
>>
>>
>> By the way:
>> Some years ago i wrote a little java query manager console. With this
>> program i can connect to the XE server and the program uses the
>> original
>> jdbc driver from oracle corporation. This driver i have also used for
>> connection from geronimo. In this little program i followed the
>> instructions
>> from oracle and wrote my jdbc url as "oracle:thin". That's the
>> reason why i
>> tried "thin" as driver type. So because this simple java program can
>> establish a connect this should be basically possible - even for
>> geronimo.
>>
>> much thanks in advance,
>> Ralf
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Configure-Oracle-XA-Datasource-with-Oracle-XE-%2810g-Express%29-in-console-dialog-tp23707396s134p23707396.html
>> Sent from the Apache Geronimo - Users mailing list archive at
>> Nabble.com.
>>
>
>
--
View this message in context:
http://www.nabble.com/Configure-Oracle-XA-Datasource-with-Oracle-XE-%2810g-Express%29-in-console-dialog-tp23707396s134p23718127.html
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.
