Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2010

[Date Index] [Thread Index] [Author Index]

Search the Archive

Connecting to Oracle via tnsnames.ora

  • To: mathgroup at smc.vnet.net
  • Subject: [mg112414] Connecting to Oracle via tnsnames.ora
  • From: Jan-Erik Brundell <jan-erik.brundell at bwin.org>
  • Date: Wed, 15 Sep 2010 04:36:19 -0400 (EDT)

I need to be able to connect to an Oracle database (11g) from Mathematica 7.0.1, I assume using JDBC is the way to go.

My method of connection to the Oracle database is via a tnsnames.ora file.

When searching for related information, I have found:


http://theblasfrompas.blogspot.com/2008/04/jdbc-thin-connection-using-tnsnamesora.html



 "As of the 10.2.x JDBC driver we now allow you to connect to your database using a tnsnames.ora entry from JDBC THIN. Previously this was not possible without fully qualifying the description alias. To do this in 10.2.x JDBC driver you can do it one of 2 ways.



Option 1:



Pass a system property as follows at the command line



-Doracle.net.tns_admin=D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN



Option 2:





    System.setProperty("oracle.net.tns_admin",

                        "D:\\oracle\\product\\10.2.0\\db_1\\NETWORK\\ADMIN");"



How can I do either of these from within Mathematica (or does anyone have any other option)?



Thanks in advance

/Jan-Erik Brundell



  • Prev by Date: Re: Include unconnected nodes in graph plot -- how?
  • Next by Date: Re: Extracting some elements, members of another list
  • Previous by thread: Re: Tabulating expressions dependent on two variables
  • Next by thread: Re: Why Row does not format 2 plots in one row when ImageSize->Full?