I am tring to deploy birt application on tomcat, its running fine when tomcat has only single application, but when I deploy my main application on the tomcat with Birt Application, I am giving the give error when accessing the report.
I have to use same driver for both application,
Please help me.
I am using the given property for creating the datasource
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="6">
<property name="odaDriverClass">oracle.jdbc.driver.OracleDriver</property>
<property name="odaURL">jdbc:oracle:oci:
@dbname</property>
<property name="odaUser">chain</property>
<encrypted-property name="odaPassword" encryptionID="base64">Y2Z1MTc=</encrypted-property>
</oda-data-source>
</data-sources>
Error:
SEVERE: Error happened while running the report.
java.lang.UnsatisfiedLinkError: Native Library C:\oracle\ora92\bin\ocijdbc9.dll already loaded in another classloader
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1716)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1676)
at java.lang.Runtime.loadLibrary0(Runtime.java:822)
at java.lang.System.loadLibrary(System.java:993)
at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:943)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:197)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:158)
at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:158)
at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:115)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:145)
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:134)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:121)
