On Wed, Feb 9, 2011 at 9:06 PM, Armand Pirvu (gmail)
<armand.pi...@gmail.com> 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("com.ingres.jdbc.IngresDriver","/home/ingres/ingresv1/ingres/lib/iijdbc.jar")
> conn <- dbConnect(drv, "jdbc:ingres://192.168.5.21:V17/rtestdb")
> mylargedata <- read.csv(file="a5.csv.v0",head=TRUE,sep=",")
>> dbWriteTable(conn, "table5",mylargedata)
> 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 quoted (m.1997.09.01)
>
>
> So I did another test. I used Squirel SQL client (JAVA based) and I ran this
>
> create table foo ("m.col1" integer)
>
>
> And it succeeded
>
> I checked in the database
>
> * help table foo \g
> Name: foo
> Column Information:
> Key
> Column Name Type Length Nulls Defaults Seq
> "m.col1" integer 4 yes null
>
>
>
> At this point I am not sure, whether the issue is in Ingres JDBC driver or in
> RJDBC ? Or maybe is it a specific value for identifier.quote ?
>
>
> Any help is appreciated
In both the RpgSQL and RH2 drivers (which each call RJDBC for the
respective databases) I had found that this worked:
JDBC(..., identifier.quote = "\"")
where above we have double quote, backslash, double quote, double quote.
--
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
