geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rbaumhof <ralf.baum...@web.de>
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
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.


Mime
View raw message