|
From: Robert M. <rob...@gm...> - 2012-10-04 23:52:51
|
It should be :
jdbc:oracle:thin:@192.168.1.131:1521:orcl
(replace the forward slash '/' with a colon ':')
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.
Rob
On Thu, Oct 4, 2012 at 3:32 PM, <sie...@he...> wrote:
>
> This fragment of java code successfully connects from my windows 7 host to
> my oracle linux guest running the oracle database:
>
> class Conn {
> public static void main (String[] args) throws Exception
> {
> Class.forName ("oracle.jdbc.OracleDriver");
> Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@//
> 192.168.1.131:1521/orcl", "siegfried", "secret");
>
>
> 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?
>
> 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).
>
> jdbc:oracle:thin:@192.168.1.131:1521/orcl
>
> Is this the correct syntax? It works for java and squirrel is java so I
> don't understand why it does not work.
>
> orcl is the name of my SID.
>
> 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)?
>
> Thanks
> Siegfried
>
>
> ------------------------------------------------------------------------------
> Don't let slow site performance ruin your business. Deploy New Relic APM
> Deploy New Relic app performance management and know exactly
> what is happening inside your Ruby, Python, PHP, Java, and .NET app
> Try New Relic at no cost today and get our sweet Data Nerd shirt too!
> http://p.sf.net/sfu/newrelic-dev2dev
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
|
