search for: oracledriver

After installing RJDBC on RedHat Linux and using it successfully with mySQL JDBC driver i am trying to use it with Oracle database. I use the JDBC driver that works fine elsewhere (use it in DBVizualizer). However, when i try to load the driver, drv<-JDBC("oracle.jdbc.driver.OracleDriver", "/home/az05625/DBdrivers/ojdbc6.jar", identifier.quote="`") it gives me error message Error in .jfindClass(as.character(driverClass)[1]) : java.lang.UnsupportedClassVersionError: Bad version number in .class file One would think that this has to do with JRE older t...

...l drv <- JDBC("com.mysql.jdbc.Driver","C:\\Temporal\\mysql-connector-java-3.0.9-stable-bin.jar","'") conn <- dbConnect(drv, "jdbc:mysql://localhost:3306/bd", "user", "password") //Oracle drv <- JDBC("oracle.jdbc.driver.OracleDriver","C:\\Temporal\\classes12.jar","'") conn <- dbConnect(drv,"jdbc:oracle:thin:@192.168.1.70:1521:SDS22","user","password") R always returns for oracle "Error en .local(drv, ...) : Unable to connect JDBC to jdbc:oracle:thin:@192.168....

Hello All -- I am using jruby 1.6.7.2 with rails 3.2.11 to create a brown bag for several other developers. I cannot get the migration to work to save my life... In my database yaml file I have the following: --- development: adapter: jdbc driver: oracle.jdbc.driver.OracleDriver url: jdbc:oracle:thin:@localhost:1521:xe username: brownbag password: brownbag pool: 500 --- When I run: --- rake db:create --trace ** Invoke db:create (first_time) ** Invoke rails_env (first_time) ** Execute rails_env ** Invoke db:load_config (first_time) ** Execute db:load_config ** Exec...

...e so I need to be able to specify connection information somewhere in the ruby code. In application.rb i have tried the following after printing the public methods on config config.database_configuration = { :adapter => ''jdbc'', :driver => ''oracle.jdbc.driver.OracleDriver'', :url => ''jdbc:oracle:think@host:1521:dbname'', :username => ''username'', :password => ''password'' } I''m not sure if this is the right way (or place) to do this but any help you can give me would be greatly app...

...een experiencing issues with an R script hanging when connecting to an Oracle database. To help debug, I found a function here in the nabble forum and made a small test script: #!/usr/bin/Rscript --no-restore --no-save --no-init-file library("RJDBC") drv<-JDBC("oracle.jdbc.OracleDriver","/home/oracle/lib/ojdbc6.jar", "'") dbCheck = function(url, user='', pwd='') { j = .jcall("java/sql/DriverManager", "Ljava/sql/Connection;", "getConnection", url, user, pwd, check=FALSE) x = .jgetEx() .jche...

...rv <- JDBC("com.mysql.jdbc.Driver","C:\\Temporal\\mysql-connector-java-3.0.9-stable-bin.jar","'") conn <- dbConnect(drv, "jdbc:mysql://localhost:3306/bd", "user", "password") //Oracle drv <- JDBC("oracle.jdbc.driver.OracleDriver","C:\\Temporal\\classes12.jar","'") conn <- dbConnect(drv,"jdbc:oracle:thin:@192.168.1.70:1521:SDS22","user","password") R always returns for oracle "Error en .local(drv, ...) : Unable to connect JDBC to jdbc:oracle:thin:@192.1...