geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rbaumhof <>
Subject Re: Configure Oracle XA Datasource with Oracle XE (10g Express) in console dialog
Date Tue, 26 May 2009 07:37:58 GMT

Console dialog displays the following Info on editing the database pool

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="">
                    <config-property-setting name="TNSEntryName"/>
                    <config-property-setting name="MaxStatements"/>
                    <config-property-setting name="Description"/>
                    <config-property-setting name="LoginTimeout"/>
                    <config-property-setting name="DatabaseName"/>

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,

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: (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
>> 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(
>>        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConn
>> 413)
>>        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.jav
>>        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDr
>> 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:
>> Sent from the Apache Geronimo - Users mailing list archive at  

View this message in context:
Sent from the Apache Geronimo - Users mailing list archive at

View raw message