similar to: rjdbc identifier.quote

Hi all, I am in the process of adding Migration support to the Ingres ActiveRecord adapter and have run in to a problem. During the call to create_table the Ingres adapter some how causes ruby to blow the stack and coredump/segv. I have tracked down the problem down to "add_column_options!" in "lib/active_record/connection_adapters/abstract/schema_statements.rb".

Hi all, I am in the process of adding Migration support to the Ingres ActiveRecord adapter and have run in to a problem. During the call to create_table the Ingres adapter some how causes ruby to blow the stack and coredump/segv. I have tracked down the problem down to "add_column_options!" in "lib/active_record/connection_adapters/abstract/schema_statements.rb".

Hello List! I successfully installed, configured and joined Samba 3.0.0 on Solaris 9 to Windows 2000 Active Directory. I tried to set the option admin user in smb.conf to user (ingres). After doing so the user isn't able to connect or browse to the Samba server anymore. Without this option the user just connects fine and is able to browse the Samba server. The goal is to have the user

Hi all, I''m working on a database adapter for the Ingres database and I''m having a problem with the Rails tests. The first SQL statement from each of the four SQL files (ingres.sql, etc), is sent to the database with this line first: -- statement #0 and extra blank lines. So the database is getting "sql" that looks like this: " -- statement #0 DROP TABLE

Dear R Forum members, I am wondering of anyone has used R to pull data from an Ingres SQL database? My initial thoughts would be to use the RJDBC package and Ingres's JDBC driver. Before I get this thing together, has anyone used this combination and can verify that it works, or can forewarn me of any "gotchas" that may be lurking in the shadows? One uncomfortable feature with

Hi all, Which ports do I need to have open on an NFS client's firewall to allow it to connect to a remote NFS servers? When I disable iptables (using ConfigServerFirewall), it connects fine, but as soon as I enable it, NFS gives me this error: root at saturn:[~]$ mount master1.mydomain.co.za:/saturn /bck mount: mount to NFS server 'master1.mydomain.co.za' failed: RPC Error: Unable to

I have this: class htb 1:29 parent 1:1 prio 0 rate 3000bit ceil 100000bit burst 1599b cburst 1611b Sent 33233 bytes 772 pkts (dropped 0, overlimits 0) lended: 415 borrowed: 357 giants: 0 tokens: -3756376 ctokens: 128779 or this: class htb 1:21 parent 1:1 prio 0 rate 3000bit ceil 100000bit burst 1599b cburst 1611b Sent 57554 bytes 618 pkts (dropped 0, overlimits 0) lended: 193 borrowed: 425

I would like to differentiate incoming traffic streams to guarantee minimum bandwidth to some services. However, as per the Adv-Routing-HOWTO it appears that only outgoing traffic can be shaped. Is this correct or is there a way of shaping incoming traffic? The problem could possibly be overcome if there is a way of routing traffic through a virtual host. Any tips on how to go about that? --

Martin Morgan commented in email to me that a change to any slot of an object that has other, large slot(s) does substantial computation, presumably from copying the whole object. Is there anything to be done? There are in fact two possible changes, one automatic but only partial, the other requiring some action on the programmer's part. Herewith the first; I'll discuss the second

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

Hi, I'm working with R on Cassandra and need to install RJDBC on my Ubuntu virtual machine. The traditional commands (install.packages(RJDBC, dep=TRUE) and library(RJDBC)) don't work: they throw an error that they can't find the package. I tried installing it using the Rkward GUI, but can't write to any of the pre-set directories because of permissions issues. When I try running

Trying to install the above two packages via the "install.packages("package_name")" command and the "R CMD INSTALL file.tar.gz". I receive the following error either way "sh: ./configure: /bin/sh: bad interpreter: Permission denied". I have tried to chmod and chown permissions and also ran dos2unix in hopes that there is a CRLF in some of the tar.gz files,

Trying to install the above two packages via the "install.packages("package_name")" command and the "R CMD INSTALL file.tar.gz". I receive the following error either way "sh: ./configure: /bin/sh: bad interpreter: Permission denied". I have tried to chmod and chown permissions and also ran dos2unix in hopes that there is a CRLF in some of the tar.gz files,

Rjdbc consistently gives me an execution error with postgresql 9.0s JDBC4 driver. It's probably something trivial so am including my code below: library("RJDBC") param <- 249 param2 <- 188129 postgres <- JDBC("org.postgresql.Driver", ".m2/repository/postgresql/postgresql/9.0-801.jdbc4/postgresql-9.0-801.jdbc4.jar") con <- dbConnect(postgres,

Hi R-helpers, i am using the following dataset.This dataset is stored in a mysql database. W(x) pH(y) 10 1 15 1 20 4 5 7.5 3 13 9 5 11.5 13.5 3 16 2 1 9.6 1 I am using RJDBC package to read the data from the database into a dataFrame.The commands used are, jdbcDriver<-JDBC(driverClass="com.mysql.jdbc.Driver",

Trying to install the above two packages via the "install.packages("package_name")" command and the "R CMD INSTALL file.tar.gz". I receive the following error either way "sh: ./configure: /bin/sh: bad interpreter: Permission denied". I have tried to chmod and chown permissions and also ran dos2unix in hopes that there is a CRLF in some of the tar.gz files,

Hi List, I am reading table from postgres database into R session using RJDBC, table contains 150 columns and 200000 rows. Sample code is as below, which works fine with smaller tables. ######################################################################## db_driver <- mydir$db_driver db_jar_file <- mydir$db_jar_file db_server <- mydir$db_server db_server_lgn <- mydir$db_server_lgn

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,

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

I am running a simple SQL SELECT statement that involvs 50k + data points using R and the RJDBC interface. I am facing very slow response times in both the RGUI and the R console. When running this SQL statement directly in a SQL client I have processing times that are a lot lot faster (which means that the SQL statement itself is not the problem). Did any of you compare RJDBC vs RMySQL or is