Hi,

I am using jboss-fuse-karaf-6.3.0.redhat-187, and trying to add Oracle ojdbc jar in my project

I have added the ojdbc jar in my local .m2 repositary using following:

mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc14 -Dversion=9.0.2.0.0 -Dpackaging=jar -Dfile=/path/to/jar/ojdbc14-9.0.2.0.0.jar -DgeneratePom=true

and then in my POM file, I have added dependency:

<dependency>
  <groupId>com.oracle</groupId>
  <artifactId>ojdbc14</artifactId>
  <version>9.0.2.0.0</version>
</dependency>

every thing works fine, but when I deploy my project in jboss fuse and run it,

it gives an error that:

11:29:35,366 | INFO  | qtp1730278923-77 | DBFactory  | 295 - CamelServiceRoute - 1.0.0.SNAPSHOT | java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@//IP:Port/AAAAA

even I have placed ojdbc14.jar in Jboss-home/deploy folder. but still getting the same error.

Java Code:

  // imports
  import org.apache.log4j.Logger;
  import java.sql.*; 
  import oracle.jdbc.*;
  import java.sql.DriverManager;
  import java.sql.Connection;
  import java.sql.SQLException;
  import java.util.Date;
  
  // code
  Class.forName ("oracle.jdbc.OracleDriver");
  String dbURL = "jdbc:oracle:thin:@//10.1.111.201:1521/BSCSPRE";;
  String strUserID = "Selfcare";
  String strPassword = "self_care#2017";
  Connection dbConnection=DriverManager.getConnection(dbURL,strUserID,strPassword);
  System.out.println(new Date() +": Coonected.");
  CallableStatement callableStatement = null;

Any help, what am I missing here.