search for: jdbc

Corect me if this is not the right place to post this. I have a mdbdriver.jar (to access an MSAccess file) under Linux. I bought the license from http://www.csv-jdbc.com/ guys. The driver work fine when tested with DBVisualizer or another JDBC thing. The problem is that driver needs 3 other more jar files to work. Under R I have tried this and does not work: > library(RJDBC) Loading required package: DBI Loading required package: rJava > .jaddClassPath(&...

I need help. I'm trying to connect with an Oracle DBMS and MySQL DBMS, I'm using RJDBC package. My code is the next: library('rJava') library('DBI') library('RJDBC') //Mysql drv <- JDBC("com.mysql.jdbc.Driver","C:\\Temporal\\mysql-connector-java-3.0.9-stable-bin.jar","'") conn <- dbConnect(drv, "jdbc:mysql://loc...

...ter couple hours, I pulled the whole thing as well. Remove all rubies from RVM and then re-installing them. I got to a point where the ruby, gem, bundle functions without problem. Now firing up my test project it can no longer connect to the derby database anymore. I tried manually adding the jdbc-derby in the gem file even thought I know "activerecord-jdbcderby-adapter" should have that as dependency. But it is still giving me class not found error. Suspecting I might have screwed my current project setting somehow, I created a brand new app and added the same derby active re...

hi to all, it is posible to use activerecord-jdbc with the jdbc-odbc bridge? i have problems to use ajax_scaffold. i get an error message, that the driver is unable to choose type for date from(list of datatypes) my database.yml look like development: adapter: jdbc driver: sun.jdbc.odbc.JdbcOdbcDriver url: jdbc:odbc:ac43demo username:...

The ActiveRecord-JDBC adapter is rapidly maturing these days. I got the full set of AWDwR2 migrations to run with it against MySQL last night, and Ola Bini has gotten migrations working well against Oracle and Firebird. We also have SQL Server support running most of our test cases (under non-Windows environments too!)...

Dear all Backend is Ingres DBMS I use RJDBC with Ingres JDBC driver I have this csv file "","Strategy","par1","m.1997.09.01" "1","ALF",2,0.1244 which I try to load it RJDBC require (RJDBC) drv <- JDBC("com.ingres.jdbc.IngresDriver","/home/ingres/ingresv1/ingr...

I am trying to migrate from RoR/MYSql to JRoR/Oracle. I am using Active Record JDBC to talk to the database. The Migration process to create and populate the database tables has been painful. My latest issue is the method new_date is undefined in the JDBC adapter. I have the following gems installed: *** LOCAL GEMS *** actionmailer (2.2.2) actionpack (2.2.2) activerecord (2.2.2)...

...es did you have to overcome to get this to work? Also, is this a combination that you would recommend for a production site, or is it all too new and untested? The latest issue I''m stuck on right now is with the mysql-connector- java-5.0.4 which comes with jruby 1.5.3 which keeps returning JDBCError: Generated keys not requested. Any feedback on this would be appreciated. Thanks. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public....

I need help. I'm trying to connect with an Oracle DBMS and MySQL DBMS, I'm using RJDBC package. My code is the next: library('rJava') library('DBI') library('RJDBC') //Mysql drv <- JDBC("com.mysql.jdbc.Driver","C:\\Temporal\\mysql-connector-java-3.0.9-stable-bin.jar","'") conn <- dbConnect(drv, "jdbc:mysql://l...

I''m getting the following error while connecting to mysql using activerecord-jdbcmysql-adapter (1.0.2). Rails 3.0.1. ActiveRecord::JDBCError: Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate() or Connection.prepareStatement().: SET SQL_AUTO_IS_NULL=0 This occurs not matter what application I run it in to e.g. rake, ra...

...form via browsers. So I thought that could be the right beginner-project, because I have only read datasets without any editing or creating. The existing database is a very old one (Pervasive 8.7) and the db-design is poor, but that is all I have and I have to live with it. Fortunately there are JDBC-Drivers, so a connection via activerecord-jdbc-adapter will work... I thought. Within the services of Netbeans using those JDBC-Drivers I''m able to establish a connection to the database and the IDE shows me all available tables and there referring datasets. The content of database.yml i...

Hello, i see packages referencing using ODBC access to databases via R, are there any packages that use JDBC to submit SQL to a database and return into a data frame? -zubin

...t and completely new to R so, please, accept my apologies in advance if any question is too basic or out of place. Thanks. After reading some docs, googling around and searched the mail lists I've only found spare references to accessing databases. Among these references, few are related with JDBC and none of them include both MySQL and JDBC access. Our group is considering to move to R from SPSS, SAS, StatGraphics and other minor statistic packages. We need to support a diverse group of users playing with several Windows and Linux flavours, Mac OS X and some more exoteric s.o. solutions....

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/az05...

I am desperate for help. I am trying to get the RJDBC and rJava .5to work on both my windows xp and linux Redhat EL5 Server. On both I get a ava.lang.ClassNotFoundException when calling JDBC(). My example is require(RJDBC) classPath='C:\\libraries\\mysql-connector-java-5.1.3-rc\\mysql-connector-java-5.1.3-rc-bin.jar' driverClass=c("co...

I would like to set up a Windows XP environment with R and MySQL. This set-up was recommended by a friend who uses this set up, but I have been unable to get RJDBC to work. I have installed all of the software today (June 2 2008), first deleting and then replacing old versions of software. The error is as follows: Error in .jfindClass(as.character(driverClass)[1]) : class not found This error is produced after running the following code (): library(RJDBC...

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 (fir...

...Bugfix Advisory 2018:1411 Upstream details at : https://access.redhat.com/errata/RHBA-2018:1411 The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) x86_64: 36b6e7066fd5a7027bbf9d71d115f5717b0030f853ae2c523907947fe4c82f13 postgresql-jdbc-9.2.1002-6.el7_5.noarch.rpm 2a5db4473102f6606aeadc66ea4a2b5b8f54d73cf1ffbbb0b1c209d2978c57e3 postgresql-jdbc-javadoc-9.2.1002-6.el7_5.noarch.rpm Source: f9428372e63c5f526bbc64b79d666c7bc110c3742bf5da89cabc34372d33c13d postgresql-jdbc-9.2.1002-6.el7_5.src.rpm -- Johnny Hughes CentOS Project {...

...dvisory 2020:3285 Important Upstream details at : https://access.redhat.com/errata/RHSA-2020:3285 The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) x86_64: 4085f09e7be4410758ded16aeb5fca59795cf4c2ad37a1afa78cddf45bef6806 postgresql-jdbc-9.2.1002-8.el7_8.noarch.rpm 7ac006a9950b2c1cc710083732c5cc4a33e7c20c3699c50ad6f24318b5986edb postgresql-jdbc-javadoc-9.2.1002-8.el7_8.noarch.rpm Source: dec9a91e3d4f1c930e75b9ca02ce766fc30afc08ad522f6bb121cd0888e2e3fa postgresql-jdbc-9.2.1002-8.el7_8.src.rpm -- Johnny Hughes CentOS Project {...

...Advisory 2020:3284 Important Upstream details at : https://access.redhat.com/errata/RHSA-2020:3284 The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 7da24f52d632e4a7bfe00e2133a719c22e6927e21c74a8c4a584b001aeb35df8 postgresql-jdbc-8.4.704-4.el6_10.noarch.rpm x86_64: 7da24f52d632e4a7bfe00e2133a719c22e6927e21c74a8c4a584b001aeb35df8 postgresql-jdbc-8.4.704-4.el6_10.noarch.rpm Source: 72decf7b6b1f789fbe15f76d71c768e6d5c95ea45c37ceea449a6b578ee61a8c postgresql-jdbc-8.4.704-4.el6_10.src.rpm -- Johnny Hughes CentOS Project...