[R] name space conflict using RMySQL and ROracle

lutz.thieme@amd.com lutz.thieme at amd.com
Tue Feb 10 17:34:05 CET 2004


Hello everybody,

could anybody give me a hint how to to use RMySQL and ROracle libraries at the same
time without getting conflict with name spaces?
Because it needs to much time, unloading and reloading the libraries is no solution...

Example:
----------- snip -----------------
library(ROracle)
library(RMySQL)

mysql	<- MySQL()
con	<- dbConnect(mysql, user=MySQL.name, password=MySQL.pwd, dbname=MySQL.DB, host=MySQL.host)
MySQLres <- dbGetQuery(con, MySQL.query)
dbDisconnect(con)

ora			<- Oracle()
con			<- dbConnect(ora, user=Oracle.name, password=Oracle.pwd, dbname=Oracle.DB)
OraRes	<- dbGetQuery(con, Ora.query)
dbDisconnect(con)
----------- snap -----------------

platform sparc-sun-solaris2.8
arch     sparc               
os       solaris2.8          
system   sparc, solaris2.8   
status                       
major    1                   
minor    7.1                 
year     2003                
month    06                  
day      16                  
language R       


Thank you in advance!

	Kind regards,

	Lutz


	Lutz Thieme
	Product Engineering
	AMD Saxony Limited Liability Company & Co. KG
	M/S E22-PE, Wilschdorfer Landstr. 101
	D-01109 Dresden, Gemany
	phone:	+ 49-351-277 -  4269
	fax:		+ 49-351-277-9-4269




More information about the R-help mailing list