Problem to create data source with OCI type of driver

[Former Member]

Hi Experts

We are creating an XA datasource with OCI type of driver using an enterprise application with data-sources.xml, the xml is like this:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE data-sources SYSTEM "data-sources.dtd" >

<data-sources>

<data-source>

<data-source-name>OCI_DS_XA</data-source-name>

<driver-name>ORACLE_DRIVER</driver-name>

<init-connections>1</init-connections>

<max-connections>25</max-connections>

<max-time-to-wait-connection>120</max-time-to-wait-connection>

<expiration-control>

<connection-lifetime>60</connection-lifetime>

<run-cleanup-thread>300</run-cleanup-thread>

</expiration-control>

<sql-engine>Vendor_SQL</sql-engine>

<jdbc-2.0>

<xads-class-name>

oracle.jdbc.xa.client.OracleXADataSource

</xads-class-name>

<object-factory>

oracle.jdbc.pool.OracleDataSourceFactory

</object-factory>

<properties>

<property>

<property-name>serverName</property-name>

<property-value><SERVER_NAME></property-value>

</property>

<property>

<property-name>serverPort</property-name>

<property-value>1521</property-value>

</property>

<property>

<property-name>databaseName</property-name>

<property-value>ORCL</property-value>

</property>

<property>

<property-name>driverType</property-name>

<property-value>oci</property-value>

</property>

<property>

<property-name>user</property-name>

<property-value>username</property-value>

</property>

<property>

<property-name>password</property-name>

<property-value>password</property-value>

</property>

</properties>

</jdbc-2.0>

</data-source>

</data-sources>

We have installed oracle client in server M/C and configured all the environment variables. While we are deploying the application from CE developer studio IDE to the CE 7.1 AS, we are getting the following error:

Description:

1. Exception has been returned while the 'sap.com/DS_TEST_EAR' was starting. Warning/Exception :

[ERROR CODE DPL.DS.6193] Error while ; nested exception is:

com.sap.engine.services.deploy.exceptions.ServerDeploymentException: [ERROR CODE DPL.DS.5030] Clusterwide exception: server ID 7653550:com.sap.engine.services.dbpool.exceptions.BaseDeploymentException: Cannot create DataSource "OCI_DS_XA".

at com.sap.engine.services.dbpool.deploy.ContainerImpl.startDataSources(ContainerImpl.java:1467)

at com.sap.engine.services.dbpool.deploy.ContainerImpl.prepareStart(ContainerImpl.java:468)

at com.sap.engine.services.deploy.server.application.StartTransaction.prepareCommon(StartTransaction.java:219)

at com.sap.engine.services.deploy.server.application.StartTransaction.prepare(StartTransaction.java:179)

at com.sap.engine.services.deploy.server.application.ApplicationTransaction.makeAllPhasesOnOneServer(ApplicationTransaction.java:419)

at com.sap.engine.services.deploy.server.application.ParallelAdapter.makeAllPhasesImpl(ParallelAdapter.java:495)

at com.sap.engine.services.deploy.server.application.StartTransaction.makeAllPhasesImpl(StartTransaction.java:554)

at com.sap.engine.services.deploy.server.application.ParallelAdapter.runInTheSameThread(ParallelAdapter.java:248)

at com.sap.engine.services.deploy.server.application.ParallelAdapter.makeAllPhasesAndWait(ParallelAdapter.java:389)

at com.sap.engine.services.deploy.server.DeployServiceImpl.startApplicationAndWait(DeployServiceImpl.java:3387)

at com.sap.engine.services.deploy.server.DeployServiceImpl.startApplicationAndWait(DeployServiceImpl.java:3373)

at com.sap.engine.services.deploy.server.DeployServiceImpl.startApplicationAndWait(DeployServiceImpl.java:3276)

at com.sap.engine.services.deploy.server.DeployServiceImpl.startApplicationAndWait(DeployServiceImpl.java:3249)

at com.sap.engine.services.dc.lcm.impl.J2EELCMProcessor.doStart(J2EELCMProcessor.java:99)

at com.sap.engine.services.dc.lcm.impl.LifeCycleManagerImpl.start(LifeCycleManagerImpl.java:62)

at com.sap.engine.services.dc.cm.deploy.impl.LifeCycleManagerStartVisitor.visit(LifeCycleManagerStartVisitor.java:34)

at com.sap.engine.services.dc.cm.deploy.impl.DeploymentItemImpl.accept(DeploymentItemImpl.java:83)

at com.sap.engine.services.dc.cm.deploy.impl.DefaultDeployPostProcessor.postProcessLCMDeplItem(DefaultDeployPostProcessor.java:80)

at com.sap.engine.services.dc.cm.deploy.impl.DefaultDeployPostProcessor.postProcess(DefaultDeployPostProcessor.java:56)

at com.sap.engine.services.dc.cm.deploy.impl.DeployerImpl.doPostProcessing(DeployerImpl.java:741)

at com.sap.engine.services.dc.cm.deploy.impl.DeployerImpl.performDeploy(DeployerImpl.java:732)

at com.sap.engine.services.dc.cm.deploy.impl.DeployerImpl.doDeploy(DeployerImpl.java:576)

at com.sap.engine.services.dc.cm.deploy.impl.DeployerImpl.deploy(DeployerImpl.java:270)

at com.sap.engine.services.dc.cm.deploy.impl.DeployerImpl.deploy(DeployerImpl.java:192)

at com.sap.engine.services.dc.cm.deploy.impl.DeployerImplp4_Skel.dispatch(DeployerImplp4_Skel.java:875)

at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:351)

at com.sap.engine.services.rmi_p4.server.ServerDispatchImpl.run(ServerDispatchImpl.java:70)

at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:62)

at com.sap.engine.services.rmi_p4.P4Message.execute(P4Message.java:37)

at com.sap.engine.services.cross.fca.FCAConnectorImpl.executeRequest(FCAConnectorImpl.java:872)

at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:53)

at com.sap.engine.services.cross.fca.MessageReader.run(MessageReader.java:58)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:108)

at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:304)

Caused by: com.sap.engine.frame.core.database.DatabaseException: Exception of type java.sql.SQLException occurred: Closed Connection.

at com.sap.engine.core.database.impl.DataSourceAdministratorImpl.createDataSource(DataSourceAdministratorImpl.java:49)

at com.sap.engine.services.dbpool.deploy.ContainerImpl.startDataSources(ContainerImpl.java:1400)

... 33 more

Caused by: java.sql.SQLException: Closed Connection

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)

at oracle.jdbc.driver.GetCharSetError.processError(T2CConnection.java:3082)

at oracle.jdbc.driver.T2CConnection.getCharSetIds(T2CConnection.java:2811)

at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:300)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)

at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:136)

at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:79)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)

at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:194)

at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:121)

at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:333)

at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:84)

at com.sap.sql.connect.factory.XADSPooledConnectionFactory.getPooledConnection(XADSPooledConnectionFactory.java:27)

at com.sap.sql.connect.datasource.DBDataSourceImpl.createPooledConnection(DBDataSourceImpl.java:677)

at com.sap.sql.connect.datasource.DBDataSourcePoolImpl.initConnections(DBDataSourcePoolImpl.java:1099)

at com.sap.sql.connect.datasource.DBDataSourcePoolImpl.<init>(DBDataSourcePoolImpl.java:49)

at com.sap.sql.connect.datasource.DataSourceManager.createDataSource(DataSourceManager.java:507)

at com.sap.sql.connect.datasource.DataSourceManager.createDataSource(DataSourceManager.java:136)

at com.sap.sql.manager.OpenSQLManager.createDataSource(OpenSQLManager.java:141)

at com.sap.engine.core.database.impl.DataSourceAdministratorImpl.createDataSource(DataSourceAdministratorImpl.java:42)

... 34 more

But when we are creating the datasource with thin type of driver, it is working fine. We have already created a driver with name “ORACLE_DRIVER” in server using the ojdbc14.jar using Netweaver administrator consol.

Same this is happening when we are creating the OCI type of datasource by using Netweaver administrator consol by specifying all the parameter as above and also the initial connection pool size is more than zero.

Same thing is happening for normal (JDBC 1x) datasource creation with OCI type driver.

[former_member185954]

Hello,

I ran a search on SDN, related to your error code, i found the following:

Maybe its useful to you

Regards,

Siddhesh