|
From: Robert M. <rob...@gm...> - 2006-12-09 01:25:54
|
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 <SRa...@sa...> wrote: > Hi Robert, > > Thanks for your help. I believe that I was doing exactly what you are men= tioning 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 a= t oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124= ) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.jav= a:161) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseErro= r.java:273) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:= 327) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnecti= on.java:347) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.ja= va:150) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriv= erExtension.java:31) at oracle.jdbc.driver.OracleDriver.connect(Oracle= Driver.java:563) at net.sourceforge.squirrel_sql.fw.sql.SQLDriverMana= ger.getConnection(SQLDriverManager.java:127) at net.sourceforge.squi= rrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnecti= onCommand.java:97) at net.sourceforge.squirrel_sql.client.mainframe.acti= on.ConnectToAliasCommand$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" <rob...@gm...> 12/07/06 07:25PM >>> > On 12/7/06, Sunitha Raghurajan <SRa...@sa...> 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 y= our > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D= DEVDEV > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
