Hello,
I tried to configure connection to two oracle databases, one is version 8,
the other is 10i, but ojdbc6.jar will work with 10i but not with 8, and
ojdbc5.jar the other way round.
It's not really a problem with d2rq, but with jdbc. However, my data
integration test system won't work until I figure out how to deal with it.
I'd like to discuss with the group the options I got:
*1) JDBC-ODBC then ODBC-Oracle.*
It seems that the only Linux driver available for versions <10.2 is provided
by easysoft; it's proprietary and I couldn't get the 14-days-trial version
to work. FAIL
*2) Hack:*
http://stackoverflow.com/questions/3858334/either-possible-1-connection-to-oracle-8i-w-ojdbc5-or-ojdbc6-2-multiple-ojdb
The hack above consists on switching the .jar used to connect to the
database, depending on the oracle database version.
I know that, theoretically, one could write a mediator that accomplishes
this hack and use this "driver" instead of the jdbc:oracle:thin. But it's
far beyond my java skills.
*3) Oracle DBLink:*
http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_5005.htm
I can configure a oracle 10 database to connect to the oracle 8 database,
and then access the table as dblinkn...@table_name.
Question: Can I use this kind of naming on the d2rq mapping file? It seems
that it only accepts things like [DATABASE.]TABLE_NAME. In this case, I
could create one view for each table on the source database, but it's so
ugly.
*4) Dump to RDF.*
LUCKLY, this Oracle 8 is a legacy database, and no more information is
entered in it. So I could just dump the RDF and add it to d2rq-server,
altogether with the other databases. But I don't know how to do it either =)
Any help will be extremely appreciated.
Thanks!
Diogo F.C. Patrão
Manager of Medical Informatics
Biotechnology Laboratory
Hospital A.C. Camargo
http://www.accamargo.org.br/
------------------------------------------------------------------------------
The Next 800 Companies to Lead America's Growth: New Video Whitepaper
David G. Thomson, author of the best-selling book "Blueprint to a
Billion" shares his insights and actions to help propel your
business during the next growth cycle. Listen Now!
http://p.sf.net/sfu/SAP-dev2dev
_______________________________________________
d2rq-map-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
