Displaying 20 results from an estimated 100 matches similar to: "Rjdbc dbGetquery execution error"
2012 Mar 16
1
ggmap crash
Not sure if this is the right place to report this, but:
Am using ggmap to generate a map of a bounding box from 161
latitude/longitude pairs and the code crashes R (in ess). Data is at
http://analysis.d8u.us/~hdiwan/plotSource.csv and the code to read it
is below. I'm not sure if ess, emacs, ggmap, R, or my laptop is to
blame. Here's the code:
> rmc <-
2013 May 14
1
PuppetDB Cannot Find Postgresql Driver
Puppet 3.3.1 // CentOS release 6.4 (Final)
rpm -qa | grep puppet
puppetlabs-release-6-7.noarch
puppet-3.1.1-1.el6.noarch
puppetdb-1.3.0-1.el6.noarch
puppet-server-3.1.1-1.el6.noarch
puppetdb-terminus-1.3.0-1.el6.noarch
Installed from yum packages:
Running Transaction
Installing : puppetdb-1.3.0-1.el6.noarch
2015 Feb 06
3
how to draw paired mosaic plot?
Hi all:
If there are two numeric variable:x,y, and I can get paired scatter plot by function "pairs".But if x and y are character, and I want to get paired mosaic plot,which function should be used then?
Many thanks!
My best.
--
QQ: 1733768559
[[alternative HTML version deleted]]
2006 Jul 29
0
Mongrel-modproxy Issue
I am trying to setup typo using mongrel and apache2 on Ubuntu Linux
(Dapper). Following the tutorial at
http://www.ridaalbarazi.com/blog/2006/06/21/local-development-environment-part-3/...
1. I set up typo, mongrel-rails to start it -- verified by going to
http:/192.168.2.18:3000
2. I''ve also tried to set up mod_proxy but that doesn''t seem to be
working, my VirtualHost
2009 Dec 18
1
The RSQLite version of dbGetQuery drops colums
Hi all,
I just noticed (the hard way of course) that when a query returns 0
rows, the columns in the resulting data.frame get dropped as well. See
the following example code (where conn is an active connection to an
SQLite db):
> dbGetQuery(conn, "select 1 as hey, 2 as ho where 1")
hey ho
1 1 2
> dbGetQuery(conn, "select 1 as hey, 2 as ho where 0")
data frame
2008 Jan 26
0
RSQLite 0.6-7 -- changes to dbGetQuery semantics
RSQLite 0.6-7 has been uploaded to CRAN and should hit a mirror near
you in the next few days.
This version changes the behavior of the dbGetQuery method to make it
more consistent with dbSendQuery. Specifically:
1. dbGetQuery now closes a complete result set as dbSendQuery does.
2. If there is an incomplete result set open, dbGetQuery still opens a
new temporary connection, but now issues
2008 Jan 26
0
RSQLite 0.6-7 -- changes to dbGetQuery semantics
RSQLite 0.6-7 has been uploaded to CRAN and should hit a mirror near
you in the next few days.
This version changes the behavior of the dbGetQuery method to make it
more consistent with dbSendQuery. Specifically:
1. dbGetQuery now closes a complete result set as dbSendQuery does.
2. If there is an incomplete result set open, dbGetQuery still opens a
new temporary connection, but now issues
2012 Feb 15
1
Passing date as parameter while retrieving data from database using dbGetQuery
Hi All,
This might be simple question, I need to retrive data for modelling from the
databases. Eveytime date values changes so I countnot fix date value in the
code, it is required to pass as parameter.
When I pass the date as parameter, it throws error.
(ERROR: column "start_dt" does not exist Position: 285)
My script is as below, please guide me where am I going wrong?
All parameters
2012 Sep 23
0
VLANs with Open vSwitch in libvirt 0.10.1
Hello all, I'm trying to take advantage of libvirt's VLAN and OVS support in the 0.10.1 release and consistently getting an "error: internal error corrupted profileid string" when starting a guest.
I've defined a network using virsh; the configuration looks like this:
<network>
<name>ovs-network</name>
2011 Feb 17
1
RCurl HTTP Post ?
According to [1] and [2], using RCurl to post a form with basic
authentication is done using the postForm method. I'm trying to post
generated interpolation data from R onto an HTTP form. The call I'm using is
page <- postForm('http://our.server.com/dbInt/new', opts =
curlOptions=(userpwd="test:test", verbose=T), profileid = "-1",
value="1.801",
2012 Feb 09
0
Java heap space Error while reading table from postgres database using RJDBC
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
2010 Feb 05
0
RJDBC with MS Access
Has anybody used RJDBC to read tables from an MS Access mdb file? I know how
to do it with RODBC, and I have used RJDBC with SQL Server. I am, however
interested now in this particular combination. Is it possible?
--
View this message in context: http://n4.nabble.com/RJDBC-with-MS-Access-tp1470599p1470599.html
Sent from the R help mailing list archive at Nabble.com.
2014 Oct 20
0
dbHasCompleted() always returns TRUE for POSTGRES Database with RJDBC?
Hello Simon, Hello everyone,
I have a problem with retrieving database-queries chunkwise. In my query
(Postgresql-Database, Postgres-Version 9.1) dbHasCompleted seems to
always return TRUE.
dbGetQuery works for smaller tables, but not for the whole query, since
then a Heap-Overflow-Error will occur (and a Error:
"java.lang.OutOfMemoryError: GC overhead limit exceeded" when trying to
2007 Jun 14
0
connecting to db2 via RJDBC
Hello,
I seem to have issues with setting the driver:
My code:
library(RJDBC)
getStatic <- function()
{
# set driver
driverClass <-
JDBC("com.ibm.db2.jcc.DB2Driver","someClassPath.jar","'")
conn <- dbConnect(driverClass,"serverName")
etc etc
}
I get this error
> data <-getData()
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,
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,
2010 Oct 12
1
append rows to Sybase datatable using RJDBC
Hi,
Does anyone have experience using RJDBC library to write to Sybase
datatable? The jdbc driver I am using is jConnect 6.0. I can
successfully write into a new datatable, but have problem appending rows
to existing one. It either complains "Table *** already exists" or
simply overwrite the existing one. Here is the example.
I am trying to append 'data' to the existing
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/az05625/DBdrivers/ojdbc6.jar", identifier.quote="`")
it gives me
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
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/ingres/lib/iijdbc.jar")
conn <- dbConnect(drv,