Re: Need help to configure oracle database

Just a few questions:

1. What is the version of the Oracle server?
2. What is the name of the jdbc driver jar file that you are using?
3. What is the exact jdbc url you are using (please replace actual
hostname/ipaddress with <host>)
4. What version of Java are you using to run SQuirreL with?
5. What Operating System is the Oracle Server running on?  Is SQuirreL
running on the same machine? If not what is the OS of the machine that
SQuirreL is running on?

Rob

On 12/8/06, Sunitha Raghurajan <SRaghurajan@xxxxxxxxxxxxxxxxxx> wrote:
> Hi Robert,
>
> Thanks for your help. I believe that I was doing exactly what you are 
> mentioning in the mail. When I try to do a connection I am getting this error
>
> maapdev: Io exception: SO Exception was generated
>
> ****************************************
>
> java.sql.SQLException: Io exception: SO Exception was generated         at 
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)   
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161) 
>   at 
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:273)   
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:327)       at 
> oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:347)    
> at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:150)      at 
> oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
>       at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:563)       
> at 
> net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:127)
>         at 
> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnecti
 onCommand.java:97)    at 
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAli
 asCommand$SheetHandler.run(ConnectToAliasCommand.java:283)  at 
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)  at 
java.lang.Thread.run(Unknown Source) 
*****************************************************************************
>
> >>> "Robert Manning" <robert.m.manning@xxxxxxxxx> 12/07/06 07:25PM >>>
> On 12/7/06, Sunitha Raghurajan <SRaghurajan@xxxxxxxxxxxxxxxxxx> wrote:
> > How will I configure oracle database in sql squirrel. Do I need oracle 
> > pluggin?
>
> You don't need the Oracle plugin to connect to an Oracle server and do
> basic things like view table content and execute SQL statements.  The
> Oracle plugin gives source tabs for certain database objects
> (procedures, views, triggers etc.) and also provides nodes in the tree
> which without it you cannot access (such as triggers) except via SQL.
> That said, I would highly recommend installing the Oracle plugin if
> you connect to an Oracle database - it enhances SQuirreL's
> capabilities.
>
> You need to configure the Oracle JDBC driver in the driver definitions
> window, then setup an Alias using that driver, and finally connect.  A
> template JDBC URL is given when you configure a new alias and adding a
> driver definition is as simple as modifying the Oracle thin driver
> default definition to tell SQuirreL where the ojdbc14.jar driver jar
> is located.  Let us know if you run into any problems getting
> connected.
>
> Rob
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV