XA connection problem

From: "GIROIRE, Nicolas (COFRAMI)" <nicolas(dot)giroire(at)airbus(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: XA connection problem
Date: 2005-05-20 09:43:29
Message-ID: 5C40CD1E4697424ABDE3AC57CF1B22C629CAA6@FR0-MAILMB20.res.airbus.corp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm working on carrying out application on Oracle database to PostgreSQL.

The server is weblogic.
For Oracle we use XA connection but there isn't in PostgreSQL so I try to use XA emulate Connection taht allows weblogic. But I don't succeed to use it correctly.
The connection seems correct, but at a time, the server uses the method getXAResource() and this method return null and an error is produced.

I've checked the case "Emulate XA connection" on my weblogic server connection.

When i create my connection I do,

Connection cx = getPostgresqlDataSource().getConnection();
return new ManagedConnectionImpl(this, pwdCred, null, cx, false, false);

and getPostgresqlDataSource is :
private javax.sql.DataSource getPostgresqlDataSource() throws ResourceException
{
try
{
InitialContext initialContext = new InitialContext();
return (javax.sql.DataSource)initialContext.lookup(ADOCProperties.getKeyValue(ADOCProperties.
FRAMEWORK_XA_DATASOURCE_DRIVER));
}
catch (Exception e)
{
logger.severe(e.getMessage());
return null;
}
}

Is somebody have an idea ?

COFRAMI
Nicolas Giroire
on behalf of AIRBUS France
for In Flight & Ground Information Services - Development
Phone : +33 (0)5 67 19 98 74
Mailto:nicolas(dot)giroire(at)airbus(dot)com

This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
Security Notice: all e-mail, sent to or from this address, may be
accessed by someone other than the recipient, for system management and
security reasons. This access is controlled under Regulation of
Investigatory Powers Act 2000, Lawful Business Practises.

Browse pgsql-general by date

  From Date Subject
Next Message Paul Newman 2005-05-20 10:58:04 guids / bytea and index use ?
Previous Message Zlatko Matic 2005-05-20 08:28:12 ODBC connection string-constants A,B,C ?