intellij scala java.lang.classnotfoundexception oracle.jdbc.driver.oracledriver

Question

I've this message error when I run my scala code :

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Here my code :


object ScalaJdbcConnectSelect extends App {
  val url = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XXX)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=XXX)(PORT=1521))(FAILOVER=on)(LOAD_BALANCE=on))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XXX)))"
  val driver = "oracle.jdbc.driver.OracleDriver"
  val username = "XXX"
  val password = "XXX"
  var connection:Connection = _
  try {
    Class.forName(driver)
    connection = DriverManager.getConnection(url, username, password)
    val statement = connection.createStatement
    val rs = statement.executeQuery("SELECT * FROM TABLE WHERE ID = 1")
    while (rs.next) {
      val host = rs.getString("ID")
      val user = rs.getString("Field")
      println("ID = %s, Field = %s".format(host,user))
    }
  } catch {
    case e: Exception => e.printStackTrace
  }
  connection.close
}

I download ojdbc6.jar (database oracle version is 11) and in Project Structure > Project Settings > Modules I add my JAR (that appears in Libraries tab) but my error still happen.

I tried to change oracle.jdbc.driver.OracleDriver to oracle.jdbc.OracleDriver but it changes anythings.

I know my database connection's configuration is good because I can connect via DB Browser and test some sql request.

Did I miss something ? I'm new with Scala

How do you run your scala code? The error indicates the driver isn't on the runtime classpath. — Mark Rotteveel
– Mark Rotteveel, Commented Jan 22, 2020 at 9:15
With the terminal of intellij, I do "scalac ScalaJdbcConnectSelect" and then "scala ScalaJdbcConnectSelect". I already add ojdbc6.jar via ProjectSettings > Dependencies tab and I click on "+" to add my Jar. (I explain it in my post). How can I check what is on the runtime classpath ? — LynxWeb
– LynxWeb, Commented Jan 22, 2020 at 13:18
If you execute through the terminal, then you are responsible for declaring the classpath for scala (and for scalac for that matter), eg scala -classpath <list of jars> ScalaJdbcConnectSelect, see also Include jar file in Scala interpreter — Mark Rotteveel
– Mark Rotteveel, Commented Jan 22, 2020 at 13:53
Yes !! scala -classpath <list of jars> ScalaJdbcConnectSelect solved my problem !! — LynxWeb
– LynxWeb, Commented Jan 22, 2020 at 14:05

LynxWeb · Accepted Answer · 2020-01-22 14:07:50Z

0

I solved my problem !!

Thanks to @Mark Rotteveel for the solution :

If you execute through the terminal, then you are responsible for declaring the classpath for scala (and for scalac for that matter), eg scala -classpath ScalaJdbcConnectSelect

answered Jan 22, 2020 at 14:07

LynxWeb

791 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

2x_sham_y · Accepted Answer · 2020-01-21 19:37:40Z

-1

Clearly seems to be a classpath related issue. Usually i'll ask for clarifications with regards to your dependency manaagement but the forum doesn't permit

Try importing oracle.jdbc.driver.OracleDriver to your package

answered Jan 21, 2020 at 19:37

2x_sham_y

991 silver badge3 bronze badges

Collectives™ on Stack Overflow

intellij scala java.lang.classnotfoundexception oracle.jdbc.driver.oracledriver

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related