2:40 p.m.
sridharts [https://community.jboss.org/people/sridharts] created the discussion
"JBoss AS 7.1.0 not working with OCI driver"
To view the discussion, visit: https://community.jboss.org/message/752703#752703
--------------------------------------------------------------
Hi,
I have Jboss AS 4.05 currently and am migrating to JBoss AS 7.1.0. I installed
Jboss7.1.0 and did the setup and everything works fine except the jdbc driver.
I have downloaded the instantclient from oracle website for oralce 11g (1.2.0.1.0) in
C:\ple\instantclient folder which has the ojdbc6.jar and ocijdbc11.dll and other dlls . My
oracle database is in a different machine and its the same version(11.2.0.1.0.)
I created a simple java program which does these things and it works fine and returns the
results without any error.
String driverClass = "oracle.jdbc.driver.OracleDriver";
String connectString = "jdbc:oracle:oci:@sridb:1521:intpl";
String userName = "myuser";
String password = "mypass";
String sql = "select count(id) from mytesttable";
Class.forName(driverClass);
cont = DriverManager.getConnection(connectString, userName, password);
Statement stmt = cont.createStatement(sql);
stmt.executeQuery();
But when i do the exact same thing from a jsp inside the Jboss 7.1.0 server it doesnt work
and gives a sql exception in DriverManager.getConnection() with no trace or detail
message.
All the detailed message the SQLException had was some 4 wierd square shaped characters
and those characters keeps changing too everytime i run it.
This same thing works fine with my Jboss 4.05 server with the oci driver. The other thing
i noticed was if i changed the driver to thin in my connectString
(jdbc:oracle:thin:@sridb:1521:intpl) it works fine.
*Has anyone encountered this similar issue. Any help in this is appreciated.*
In my jboss standalone.bat i set the classpath and path as
set CLASSPATH=%CLASSPATH%;C:\ple\instantclient\ojdbc6.jar
set PATH=C:\ple\instantclient;%PATH%
In modules folder i created com/myoracle/main folders and copied into it the
C:\ple\instantclient\ojdbc6.jar
also created a dlls folder under main and copied all the dlls from C:\ple\instantclient
This is how my module.xml looks like
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.0" name="com.myoracle">
<resources>
<resource-root path="dlls"/>
<resource-root path="ojdbc6.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
</dependencies>
</module>
In my test.war/WEB-INF this is my jboss-deployment-structure.xml
<jboss-deployment-structure>
<deployment>
<!-- Exclusions allow you to prevent the server from automatically adding some
dependencies -->
<exclusions>
</exclusions>
<dependencies>
<module name="com.myoracle" />
</dependencies>
</deployment>
</jboss-deployment-structure>
I also tried it with giving a datasource in standalone.xml l and accessing it in my jsp
with the datasource name. But get the same issue. It works only if i use thin but not
oci.
<subsystem xmlns="urn:jboss:domain:datasources:1.0">
<datasources>
<datasource jta="true" jndi-name="java:/OracleDS"
pool-name="OracleDS" enabled="true"
use-java-context="true">
<connection-url>jdbc:oracle:oci:@sdqa11:1521:intpl</connection-url>
<driver>plejdbc</driver>
<security>
<user-name>nielsen_claritas</user-name>
<password>f00sball</password>
</security>
</datasource>
<drivers>
<driver name="plejdbc"
module="com.nielsen.oraclejdbc">
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
</driver>
</drivers>
</datasources>
</subsystem>
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/752703#752703]
Start a new discussion in JBoss AS 7 Development at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]