search for: jdbc

Displaying 20 results from an estimated 227 matches for "jdbc".

2011 Jun 26
1
RJDBC and multiple classpaths
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(&...
2007 Mar 05
1
RJDBC
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...
2013 Feb 14
4
Struggling with Jruby Rails + jdbc driver
...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...
2007 Aug 02
0
How to: Rails with JRuby/Actice Record-JDBC and JDBC-ODBC
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:...
2006 Sep 04
8
ActiveRecord-JDBC is coming along
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!)...
2011 Feb 10
1
rjdbc identifier.quote
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...
2009 May 05
3
Oracle-JRuby error
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)...
2010 Oct 30
12
Anyone successfully ran JRuby 1.5.3, Rails 3, Tomcat6
...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....
2007 Mar 05
0
RJDBC
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...
2010 Oct 28
2
ActiveRecord JDBC error Generated keys not requested
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...
2011 May 07
4
Activerecord::JDBCError: Invalid column number
...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...
2004 Oct 23
2
JDBC DB access in R
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
2006 Oct 09
1
accesing MySQL through JDBC
...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....
2010 Nov 24
1
RJDBC doesn't load Oracle driver?
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...
2007 Sep 27
2
rJava and RJDBC
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...
2008 Jun 02
1
RJDBC cant find driver class in JDBC jar file
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...
2013 Feb 01
0
rake db:migrate failing against oracle
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...
2018 May 30
0
CEBA-2018:1411 CentOS 7 postgresql-jdbc BugFix Update
...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 {...
2020 Aug 07
0
CESA-2020:3285 Important CentOS 7 postgresql-jdbc Security Update
...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 {...
2020 Aug 07
0
CESA-2020:3284 Important CentOS 6 postgresql-jdbc Security Update
...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...