[GENERAL] XA connection problem

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[GENERAL] XA connection problem

GIROIRE, Nicolas (COFRAMI)
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:[hidden email]



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.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match