Anthony,
Did you try options(java.parameters = "-Xmx8g
-Djava.oracle.jdbc.timezoneAsRegion=false")
instead of specifying the java property separately? -- H
On 2 May 2017 at 15:18, Nelson Anthony wrote:
> Hi all,
>
>
>
> I am trying to connect to Database using RJDBC but due to some DB & Server
Hi all,
I am trying to connect to Database using RJDBC but due to some DB & Server
timezone mismatch I am facing below error message.
Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect",
as.character(url)[1], :
java.sql.SQLException: ORA-00604: error occurred at recursive SQL le
Hi,
I have a script that starts with some code to open a connection to an Oracle
database, however the code is crashing R/RStudio as soon as it runs. The code
does run successfully on another machine.
The script opens by loading the required RJDBC package:
library("RJDBC", lib.loc="C:/Program
Hello,
I am using the RJDBC library to connect to a SQL database and pull out text
that includes Hebrew characters. If I do this on a Mac, the data frames I
construct display the characters properly. If I do it on a Windows PC, then
the characters are converted to strings like this:
I have tri
Hello,
You probably should reconfigure R using:
> R CMD javareconf
before installing the package you want.
And when you install a package, don't forget the quote.
HTH
Pascal
Le 02/08/2012 14:45, am a écrit :
Hi,
I'm working with R on Cassandra and need to install RJDBC on my Ubuntu
virtual
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
My ignorance! I managed to connect doing:
library(RJDBC)
cp <- c(
"/opt/DbVisualizer-7.1.1/jdbc/mdb/log4j.jar",
"/opt/DbVisualizer-7.1.1/jdbc/mdb/commons_lang.jar",
"/opt/DbVisualizer-7.1.1/jdbc/mdb/commons_logging.jar"
)
.jinit(classpath=cp)
drv <- JDBC("jstels.jdbc.mdb.MDBDriver",
"/opt/DbVisu
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
On Wed, Feb 16, 2011 at 12:36 PM, Hasan Diwan
wrote:
> 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
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
Hi Gabor
Thank you for your reply
I tried it
> dbWriteTable(conn, "table6",mylargedata,identifier.quote ="\"")
Error in .sql.qescape(names(value), TRUE, conn@identifier.quote) :
The JDBC connection doesn't support quoted identifiers, but table/column name
contains characters that must be qu
On Wed, Feb 9, 2011 at 11:05 PM, Armand Pirvu (gmail)
wrote:
> Hi Gabor
>
> Thank you for your reply
>
> I tried it
>
>> dbWriteTable(conn, "table6",mylargedata,identifier.quote ="\"")
> Error in .sql.qescape(names(value), TRUE, conn@identifier.quote) :
> The JDBC connection doesn't support quot
On Wed, Feb 9, 2011 at 9:06 PM, Armand Pirvu (gmail)
wrote:
> 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(
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 <- dbC
Hmm, for the sake of anyone who steps on the same mine. Basically, this class
error always say that you need to install latest java. It's not enough to
get new jre -- you need to get full latest jdk as well. After that you need
to do R reconfiguration, which is done by
R CMD javareconf
Then you ne
I asked my local java export and his reply was that the driver was compiled
with the later version of java that i need to install. I did install it in
parallel to existing java and changed JAVA_HOME variable to point to new
java directory. I also pre-pended PATH with path to java. Still, when i tr
I am having trouble loading Oracle JDBC driver into RJDBC.
Basically, i installed RJDBC and used it to connect to MySql. However, when
i try to load JDBC Oracle driver, it gives me an error message
> drv<-JDBC("oracle.jdbc.driver.OracleDriver", "/pathToDriver/ojdbc6.jar")
Error in .jfindClass(as
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",
"/hom
Unfortunately, I have a lot of errors with RMySQL -- but that is
another thread...
Ralf
On Thu, Jun 24, 2010 at 10:31 AM, James W. MacDonald
wrote:
> Hi Ralf,
>
> Ralf B wrote:
>>
>> Sorry for the lack of details. Since I run the same SQL first directly
>> on MySQL (using the MySQL Query Browser
Hi Ralf,
Ralf B wrote:
Sorry for the lack of details. Since I run the same SQL first directly
on MySQL (using the MySQL Query Browser) and then again using R
through the RJDBC interface, I assume that I won't simply have a badly
constructed SQL query. However, just to clear possible objection, h
Sorry for the lack of details. Since I run the same SQL first directly
on MySQL (using the MySQL Query Browser) and then again using R
through the RJDBC interface, I assume that I won't simply have a badly
constructed SQL query. However, just to clear possible objection, here
the SQL:
# Extracts
Hi Ralf,
Ralf B wrote:
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
l
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
Hi all,
I am suffering from a very slow RJDBC (7 rows of from a simple
select take like 10 minutes). Does anybody know if RMySQL is faster?
Or RODBC in that respect? What are alternatives and what can be done
to get a realistic performance out of MySQL when connected to R's JRI
?
Best,
Ralf
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-tp1470
Anybody knows what could be the problem?
I am trying to use the class4 (I also tried the class2) JDBC driver for
DB2 and I get the following error. This driver is for db2 9.5, so it
does not require a matching license .jar file, and I tried redownloading
the driver.
I am running R 2.6 on Windows X
Hi there,
I'm trying to connect in an Oracle database. I am able to do it with
Java, but when trying this code in R:
library(DBI)
library(RJDBC)
drv = JDBC("oracle.jdbc.driver.OracleDriver",
"C:\\Documents and
Settings\\rodri\\workspace\\AtlasQueryingTest\\lib\\ojdbc14.jar",
I can't comment on problems with RJDBC but I can say that if you want to
access MySQL from R, I have had very little difficulty doing it with
RODBC. The only difficulty I have experienced is in getting the MySQL 5.0
server started, which after hours of trying I avoided by using MySQL 5.1.
S
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 er
On Dec 14, 2007 8:28 AM, Marc Schwartz <[EMAIL PROTECTED]> wrote:
>
> Bearing in mind that OO.org's Write and Calc documents are just 'zipped'
> XML files, it would be possible to parse the data stored within such
> documents. I suspect Max Kuhn has spent much time on this for odfWeave.
>
I haven'
On Fri, 2007-12-14 at 07:31 +, Prof Brian Ripley wrote:
> On Fri, 14 Dec 2007, Metz, Thomas (IRRI) wrote:
>
> > Under Windows, I have used RODBC to connect to Excel spreadsheets as per
> > the example below:
> >
> > library(RODBC);
> > connect = odbcConnectExcel("testdata.xls");
> > query = "
On Fri, 14 Dec 2007, Metz, Thomas (IRRI) wrote:
> Under Windows, I have used RODBC to connect to Excel spreadsheets as per
> the example below:
>
> library(RODBC);
> connect = odbcConnectExcel("testdata.xls");
> query = "SELECT [data$.ethn], [data$.sex], [data$.age],
>[data$.height
Under Windows, I have used RODBC to connect to Excel spreadsheets as per
the example below:
library(RODBC);
connect = odbcConnectExcel("testdata.xls");
query = "SELECT [data$.ethn], [data$.sex], [data$.age],
[data$.height], [data$.weight],
[label$.label]
Help is sincerely requested.
After further investigation, I found that if I run .jmethods and have
the listing below. I know that this driver works because I have a java
program using that loads data scrapped from the web every night.
The call to JDBC in my previous email is trying to create t
I am having trouble getting RJDBC and rJava working. rjava does not
seem to be able to traverse my classpath that I define inside R.
My example is
library(RJDBC)
.jinit('C:\\Libraries\\mysql-connector-java-5.1.3-rc\\mysql-connector-java-5.1.3-rc-bin.jar')
drv <- JDBC("com.mysql.jdbc.Driver",
'C:\
Hi everyone,
I'm obviously missing something simple here...
Trying to connect to an external db with RJDBC. (I can connect OK with
ROLAP and with other java apps, eg dbVisualizer)
JDBC call seems to work ok:
> driverClass <- "net.sourceforge.jtds.jdbc.Driver"
> classPath <- "C:\\Dwns\\jtds\\jtd
36 matches
Mail list logo
