Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@geronimo.apache.org
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Received:X-Yahoo-SMTP:X-YMail-OSG:X-Yahoo-Newman-Property:Message-Id:From:To:In-Reply-To:Content-Type:Content-Transfer-Encoding:Mime-Version:Subject:Date:References:X-Mailer;
  b=hHfvMjQ/yQtJouNxT78imj4NwB7LdDLk5lepb0MbpVmenb4xVOq1JuvOz+VaaLXJITdjawQbCcn/hM5idv3UgTwt/i516QMVdC9Hv7Yx5wNUWTdfJvlnhGxklonQYZySF52WsVPALLwJVG8/MyG5DA8lXu202pbxj3ymsPNVKkA=
  ;
Message-Id: <BC719750-D697-4330-8A99-50EAAB0945F0@yahoo.com>
From: David Jencks <david_jencks@yahoo.com>
To: user@geronimo.apache.org
In-Reply-To: <23707396.post@talk.nabble.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v930.3)
Subject: Re: Configure Oracle XA Datasource with Oracle XE (10g Express) in
 console dialog
Date: Mon, 25 May 2009 10:17:49 -0400
References: <23707396.post@talk.nabble.com>

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.
>