[R-sig-DB] RpgSQL/RJDBC(?) on R15.2(64) Win7 throws can't find .verify.JDBC.result

[Gabor Grothendieck]

I was wondering if you could use RPostgreSQL instead of RpgSQL?

RpgSQL was written to support cross platform PostgreSQL at a time that
RPostgreSQL did not have that capability but now that RPostgreSQL
works on all platforms (as far as I know) it does have the benefit of
not needing Java.  If there is a general feeling that RPostgreSQL is
sufficient I was thinking I could retire RpgSQL.

Let me know.

Regards.


On Wed, Jan 23, 2013 at 4:16 PM, Jim Porzak <jporzak using gmail.com> wrote:
> Thanks Gabor,
> Not a panic, since I'm doing this work in 2.14.2, but would be good to
> get cleaned up.
> Jim
>
>
> On Wed, Jan 23, 2013 at 12:22 PM, Gabor Grothendieck
> <ggrothendieck using gmail.com> wrote:
>> I tried the same fix that worked for RH2 but it seems its something
>> else as you found too.  I will have a look next week.
>>
>> On Wed, Jan 23, 2013 at 2:08 PM, Jim Porzak <jporzak using gmail.com> wrote:
>>> All, I see:
>>>
>>>> options(RpgSQL.user = "tableau", RpgSQL.password = "******",
>>> +         RpgSQL.host = "10.8.0.1", RpgSQL.port = 5432,
>>> +         RpgSQL.JAR = "C:/Drivers/JDBC")
>>>>
>>>> library(RpgSQL)                                  ## Version: 0.1-6
>>> Loading required package: RJDBC           ## Version: 0.2-1
>>> Loading required package: DBI                ## Version: 0.2-5
>>> Loading required package: rJava              ## Version: 0.9-3
>>>
>>>> con <- dbConnect(pgSQL(), dbname = "bidata_pg")
>>> Error in .local(drv, ...) : could not find function ".verify.JDBC.result"
>>>
>>> The above works just fine with R14.2 & prior versions of PpgSQL & RJDBC.
>>>
>>> I noticed H2 user had a similar error which they worked around by
>>> rolling back to RJDBC 0.2-0
>>> I tried hacking a roll-back using files from my 14.2 install but that
>>> didn't work.
>>> I did not see any window binaries for RJDBC 0.2-0
>>>
>>> Suggestions?
>>>
>>>
>>> Jim Porzak
>>> Minted.com
>>> San Francisco, CA
>>> www.linkedin.com/in/jimporzak
>>> use R! Group SF: www.meetup.com/R-Users/
>>
>>
>>
>> --
>> Statistics & Software Consulting
>> GKX Group, GKX Associates Inc.
>> tel: 1-877-GKX-GROUP
>> email: ggrothendieck at gmail.com



-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com