Atomikos Forum

I'm just wondering how to create the connection to the DB using Atomikos with the SYSDBA privileges ( Oracle ).

I need to execute some statements as SYSDBA but right now i'm getting exception:

ORA-28009: connection as SYS should be as SYSDBA or SYSOPER


using property "internal_logon" obviously will not work - there is not such property in OracleXADataSource.

dbConfig.getProperties().put( "internal_logon", "sysdba");
atomikosDataSource.setXaProperties( dbConfig.getProperties() )


Is there any possiblity?

Hi,

Try configuring the Oracle XADataSource separately, with SYSDBA parameters, and then inject it on the AtomikosDataSourceBean by calling setXaDataSource.

HTH