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.