|
From: <sie...@he...> - 2012-10-04 19:32:20
|
<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div><br></div><div>This fragment of java code successfully connects from my windows 7 host to my oracle linux guest running the oracle database:</div><div><br></div><div>class Conn {<br> public static void main (String[] args) throws Exception<br> {<br> Class.forName ("oracle.jdbc.OracleDriver");<br> Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@//192.168.1.131:1521/orcl", "siegfried", "secret");<br> </div><div><br></div><div>Now I am trying to connect with squirrel 3.4.0 and I have downloaded ojdbc6.jar to c:/Program Files/squirrel-sql-3.4.0/lib. Is this necessary or does squirrel already come with this JDBC driver? What is that Extra Classpath tab for?</div><div><br></div><div>Here is the connection string I am trying to use that is giving me a stack trace. (Sorry, I forgot to save the stack trace! If necescary, I'll fire up the linux guest and database (that takes a while) and get that stack trace).</div><div><br></div><div>jdbc:oracle:thin:@192.168.1.131:1521/orcl </div><div><br></div><div>Is this the correct syntax? It works for java and squirrel is java so I don't understand why it does not work.</div><div><br></div><div>orcl is the name of my SID.</div><div><br></div><div>Also, does squirrel have a command line mode so it can be more of a substitute for sqlplus (oracle command line utility) and sqlcmd (MS SQL Server command line utility)?</div><div><br></div><div>Thanks</div><div>Siegfried</div></span></body></html>
|
