Topic: Oracle access using TNS
Oracle access using TNS
Hi!
Is there possible to connect to an oracle database using TNS (Transparent Network Substrate)?
Is there possible to connect to an oracle database using TNS (Transparent Network Substrate)?
Hi uesker,
Don't know much about TNS (haven't tried this approach before), but from doing a quick google search on the subject it seems that you need to run datacleaner with a command line parameter to instruct the database driver on where some oracle files are located.
Check out this blog entry on the subject. http://java.sogeti.nl/JavaBlog/2008/02/03/oracle-thin-jdbc-to-tns-name/...
The easiest approach would be to get the platform independent distribution of datacleaner. It contains .cmd and .sh launch files that you can edit and add the command line parameter to.
Don't know much about TNS (haven't tried this approach before), but from doing a quick google search on the subject it seems that you need to run datacleaner with a command line parameter to instruct the database driver on where some oracle files are located.
Check out this blog entry on the subject. http://java.sogeti.nl/JavaBlog/2008/02/03/oracle-thin-jdbc-to-tns-name/...
The easiest approach would be to get the platform independent distribution of datacleaner. It contains .cmd and .sh launch files that you can edit and add the command line parameter to.
Hi Uesker
My experience is that if you are using the thin jdbc you need to specify hostname and port. If you dont know the hostname and port you can use tnsping to translate.
My experience is that if you are using the thin jdbc you need to specify hostname and port. If you dont know the hostname and port you can use tnsping to translate.
Another way would be also just to check the tnsnames.ora file to get all the required tokens for Oracle access and prepare then a set of required db-connections in advance.
Log in by clicking the login link at the top of the screen
Go back to forum.
