All Forums Teradata Studio
rakeshsapbo 36 posts Joined 04/13
27 Jul 2014
Unable to establish connectivity to Oracle through Teradata Studio Express TD Studio Expv15

Hi Experts,
i have tried to establish a connection to connect to Oracle 11g db through TD Std Exp v15 ,unfortunately i am unable to establish the connection below are the steps i have followed
Reference teradata-studio-express-connectivity-to- oraclesqlserver
1) get working TNS entry for your Oracle instance ---?
2) download (ideally from OTN website) & install Oracle jdbc drivers (ojdbc6.jar) --> just put them to any folder you like --- done
3) run 'new connection profile' wizard --> choose Oracle as vendor and name your connection as used to ---done
4) install new jdbc driver --> choose "OtherOracle" --> provide JAR file location (from step #2) --> done
5) --> properties tab values to be like this:
  * Connection URL: jdbc:oracle:thin:@//
  * ​​Driver Class: oracle.jdbc.OracleDriver 
Note: /for OracleThinDriver  11 looks like this:/ Connection URL:
1) save it,edit credentials, for jdbc URL use notation like this: jdbc:oracle:thin@tns-entry-without-identificator
Step 5
i have captured the TNS entry from the below path from my local system
Tns entry from file

  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

      (SID = CLRExtProc)

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (SERVICE_NAME = orcl)

need some understanding on the below
what do we have to mention beside Connection URL
error message i got
java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
 at$ Source)
 at$ Source)
 at Method)
 at Source)
 at java.lang.ClassLoader.loadClass(Unknown Source)
 at Source)
 at java.lang.ClassLoader.loadClass(Unknown Source)
 at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCCo nnection.createConnection(
 at org.eclipse.datatools.connectivity.DriverConnectionBas e.internalCreateConnection( 105)
 at org.eclipse.datatools.connectivity.DriverConnectionBas
 at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCCo
 at racleConnectionFactory.createConnection(JDBCOracleConn
 at org.eclipse.datatools.connectivity.internal.Connection FactoryProvider.createConnection(ConnectionFactoryProv
 at org.eclipse.datatools.connectivity.internal.Connection Profile.createConnection(
 at org.eclipse.datatools.connectivity.ui.PingJob.createTe stConnection(
 at 54)
can you please guide me where exactly i need to correct???
Rakesh Reddy .G


Rakesh Reddy G
fgrimmer 553 posts Joined 04/09
27 Jul 2014

Rakesh, It looks like, from the exception, that it can't find the JDBC driver jar. Did you do steps 2 and 4 from above? 

You must sign in to leave a comment.