<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>OK, progress! Thanks Robert!</div><div><br></div><div>I can now connect and I see a nice display of tabs.</div><div>When I try to expand "TABLE" I'm expecting a list of tables and I see no tables. What is wrong?</div><div><br></div><div>When I click on the SQL tab I enter the following SQL:</div><div>SELECT <a href="http://u.name">u.name</a> AS fall, <a href="http://c.name">c.name</a> AS county FROM upfall u INNER JOIN county c ON u.county_id = <a href="http://c.id">c.id</a> </div><div><br></div><div>I get </div><div>Error:Closed Connection</div><div>SQL State: 08003</div><div>ErrorCode: 17008</div><div><br></div><div>However, my java program executes this SQL query correctly with the connection string below.</div><div><br></div><div>What am I doing wrong?</div><div>Thanks</div><div>Siegfried</div><div><br></div><div><br></div><div><br></div>
<blockquote id="replyBlockquote" webmail="1" style="border-left: 2px solid blue; margin-left: 8px; padding-left: 8px; font-size:10pt; color:black; font-family:verdana;">
<div id="wmQuoteWrapper">
-------- Original Message --------<br>
Subject: Re: [Squirrel-sql-users] Connection string for Oracle Thin?<br>
From: Robert Manning <<a href="mailto:***@gmail.com">***@gmail.com</a>><br>
Date: Thu, October 04, 2012 4:52 pm<br>
To: <a href="mailto:squirrel-sql-***@lists.sourceforge.net">squirrel-sql-***@lists.sourceforge.net</a><br>
<br>
It should be :<br><br>jdbc:oracle:thin:@192.168.1.131:1521:orcl<br><br>(replace the forward slash '/' with a colon ':')<br><br>The drivers aren't shipped with SQuirreL. They can be located in SQUIRREL_HOME/lib folder - alternatively use the "Extra Classpath" tab to add drivers that are located elsewhere on the machine. SQuirreL has no command line mode - however, one plugin (dbcopy) does have a command-line interface.<br> <br>Rob<br><br><br><div class="gmail_quote">On Thu, Oct 4, 2012 at 3:32 PM, <span dir="ltr"><<a href="mailto:***@heintze.com" target="_blank">***@heintze.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <div><span style="font-size:10pt;font-family:Verdana"><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:@//<a href="http://192.168.1.131:1521/orcl" target="_blank">192.168.1.131:1521/orcl</a>", "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><a href="http://jdbc:oracle:thin:@192.168.1.131:1521/orcl" target="_blank">jdbc:oracle:thin:@192.168.1.131:1521/orcl</a> </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></div> <br>------------------------------------------------------------------------------<br> Don't let slow site performance ruin your business. Deploy New Relic APM<br> Deploy New Relic app performance management and know exactly<br> what is happening inside your Ruby, Python, PHP, Java, and .NET app<br> Try New Relic at no cost today and get our sweet Data Nerd shirt too!<br> <a href="http://p.sf.net/sfu/newrelic-dev2dev" target="_blank">http://p.sf.net/sfu/newrelic-dev2dev</a><br>_______________________________________________<br> Squirrel-sql-users mailing list<br> <a target="_blank" href="mailto:Squirrel-sql-***@lists.sourceforge.net">Squirrel-sql-***@lists.sourceforge.net</a><br> <a href="https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users</a><br> <br></blockquote></div><br> <hr>------------------------------------------------------------------------------<br>
Don't let slow site performance ruin your business. Deploy New Relic APM<br>
Deploy New Relic app performance management and know exactly<br>
what is happening inside your Ruby, Python, PHP, Java, and .NET app<br>
Try New Relic at no cost today and get our sweet Data Nerd shirt too!<br>
<a href="http://p.sf.net/sfu/newrelic-dev2dev">http://p.sf.net/sfu/newrelic-dev2dev</a><hr>_______________________________________________<br>
Squirrel-sql-users mailing list<br>
<a href="mailto:Squirrel-sql-***@lists.sourceforge.net">Squirrel-sql-***@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users">https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users</a><br>
</div>
</blockquote></span></body></html>