You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(7) |
Dec
(4) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(9) |
Feb
(4) |
Mar
(20) |
Apr
(10) |
May
(5) |
Jun
(2) |
Jul
(10) |
Aug
(4) |
Sep
(15) |
Oct
(5) |
Nov
(8) |
Dec
(2) |
| 2003 |
Jan
(11) |
Feb
(5) |
Mar
(10) |
Apr
(20) |
May
(24) |
Jun
(13) |
Jul
(6) |
Aug
(5) |
Sep
(10) |
Oct
(10) |
Nov
(9) |
Dec
(7) |
| 2004 |
Jan
(4) |
Feb
(10) |
Mar
(5) |
Apr
(18) |
May
(18) |
Jun
(14) |
Jul
(24) |
Aug
(14) |
Sep
(6) |
Oct
(18) |
Nov
(5) |
Dec
(3) |
| 2005 |
Jan
(5) |
Feb
(1) |
Mar
(5) |
Apr
(10) |
May
(10) |
Jun
(16) |
Jul
(46) |
Aug
(36) |
Sep
(16) |
Oct
(11) |
Nov
(12) |
Dec
(29) |
| 2006 |
Jan
(33) |
Feb
(45) |
Mar
(42) |
Apr
(23) |
May
(23) |
Jun
(21) |
Jul
(19) |
Aug
(23) |
Sep
(17) |
Oct
(50) |
Nov
(74) |
Dec
(44) |
| 2007 |
Jan
(35) |
Feb
(18) |
Mar
(46) |
Apr
(25) |
May
(26) |
Jun
(24) |
Jul
(33) |
Aug
(4) |
Sep
(41) |
Oct
(43) |
Nov
(23) |
Dec
(42) |
| 2008 |
Jan
(26) |
Feb
(20) |
Mar
(21) |
Apr
(18) |
May
(28) |
Jun
(32) |
Jul
(25) |
Aug
(28) |
Sep
(27) |
Oct
(34) |
Nov
(16) |
Dec
(42) |
| 2009 |
Jan
(21) |
Feb
(36) |
Mar
(40) |
Apr
(51) |
May
(27) |
Jun
(13) |
Jul
(38) |
Aug
(40) |
Sep
(5) |
Oct
(14) |
Nov
(4) |
Dec
(7) |
| 2010 |
Jan
(16) |
Feb
(10) |
Mar
(38) |
Apr
(83) |
May
(27) |
Jun
(41) |
Jul
(57) |
Aug
(24) |
Sep
(14) |
Oct
(22) |
Nov
(28) |
Dec
(42) |
| 2011 |
Jan
(52) |
Feb
(13) |
Mar
(41) |
Apr
(14) |
May
(24) |
Jun
(14) |
Jul
(16) |
Aug
(15) |
Sep
(19) |
Oct
(20) |
Nov
(35) |
Dec
(48) |
| 2012 |
Jan
(30) |
Feb
(9) |
Mar
(33) |
Apr
(15) |
May
(13) |
Jun
(13) |
Jul
(57) |
Aug
(20) |
Sep
(18) |
Oct
(29) |
Nov
(28) |
Dec
(9) |
| 2013 |
Jan
(19) |
Feb
(26) |
Mar
(44) |
Apr
(13) |
May
(38) |
Jun
(6) |
Jul
(24) |
Aug
(8) |
Sep
(7) |
Oct
(10) |
Nov
(12) |
Dec
(6) |
| 2014 |
Jan
(13) |
Feb
(6) |
Mar
(41) |
Apr
(5) |
May
(4) |
Jun
(3) |
Jul
(13) |
Aug
(9) |
Sep
(35) |
Oct
(36) |
Nov
(16) |
Dec
(4) |
| 2015 |
Jan
(6) |
Feb
(4) |
Mar
(7) |
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(2) |
Sep
(10) |
Oct
(4) |
Nov
(13) |
Dec
(3) |
| 2016 |
Jan
(6) |
Feb
(12) |
Mar
(6) |
Apr
(21) |
May
(9) |
Jun
(16) |
Jul
(13) |
Aug
(13) |
Sep
(11) |
Oct
(9) |
Nov
(20) |
Dec
(18) |
| 2017 |
Jan
(7) |
Feb
(19) |
Mar
(9) |
Apr
(12) |
May
(12) |
Jun
(35) |
Jul
(7) |
Aug
(3) |
Sep
|
Oct
(1) |
Nov
(4) |
Dec
|
| 2018 |
Jan
(4) |
Feb
(1) |
Mar
(3) |
Apr
(8) |
May
(9) |
Jun
(8) |
Jul
(6) |
Aug
(7) |
Sep
(8) |
Oct
(1) |
Nov
(6) |
Dec
|
| 2019 |
Jan
(6) |
Feb
(9) |
Mar
(3) |
Apr
(3) |
May
(4) |
Jun
|
Jul
|
Aug
(4) |
Sep
(3) |
Oct
(3) |
Nov
(3) |
Dec
(1) |
| 2020 |
Jan
(4) |
Feb
(4) |
Mar
(22) |
Apr
(1) |
May
(16) |
Jun
(12) |
Jul
(3) |
Aug
(10) |
Sep
(5) |
Oct
(1) |
Nov
(24) |
Dec
(1) |
| 2021 |
Jan
(2) |
Feb
(10) |
Mar
(9) |
Apr
(7) |
May
(8) |
Jun
(10) |
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2022 |
Jan
(3) |
Feb
(4) |
Mar
(5) |
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
(6) |
Sep
(1) |
Oct
(2) |
Nov
(2) |
Dec
|
| 2023 |
Jan
(2) |
Feb
(6) |
Mar
|
Apr
|
May
(13) |
Jun
|
Jul
|
Aug
(6) |
Sep
|
Oct
|
Nov
(1) |
Dec
(4) |
| 2024 |
Jan
(3) |
Feb
|
Mar
(5) |
Apr
(1) |
May
(5) |
Jun
(1) |
Jul
(1) |
Aug
|
Sep
|
Oct
(3) |
Nov
(3) |
Dec
|
| 2025 |
Jan
|
Feb
(5) |
Mar
(33) |
Apr
(8) |
May
(10) |
Jun
(7) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: <am...@ya...> - 2004-08-13 21:30:06
|
Hi Colin --- Colin Bell wrote: > What happens if you try running the SQL directly in the SQL > window? Do you get the same error? Yes. > Its peculiar that opening a connection to another server seems > to fix the problem on the first server. That points to a problem > with the driver. Does the problem only occur on the HP-UX server? > I.E. If you go first to the Windows server do you have the > same problem? I only have the problem with the HP-UX server. > Does it happen on every table? Or just some? If its just some is > there a common data type in the tables that have the problem that > isn't in the the tables that don't have the problem? There are > currently some problems with Oracle blob/clob columns in SQuirreL > so maybe your problem is related to those. All tables. Although there are many tables, they are all pretty straightforward, no blobs or clobs. > I've tested with Oracle 9.2.0.3.0 on a Solaris server with version > 9.2.0.3 of the thin driver and don't have a similar problem. Thanks for testing. I guess the next step is to compile myself and step through the code. -- Andrew ___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com |
|
From: <am...@ya...> - 2004-08-13 21:24:05
|
Hi Glenn --- gwg wrote: > Since the error seems to be generated by the Oracle driver this may not > help us, but what does the Squirrel log file say? It is not clear from > your message what OS you are running on so I can't tell you exactly > where the Squirrel log file is, but if you do a search on your system > for "squirrel" you should be able to find it. I'm on Windows 2000, sorry I should have included that. I found the logs, below I have included the log statements for a simple session connecting to the troublesome DB, trying to view data in one table and then shutting down. Looks like the problem is relating to obtaining stored procedures. The user I log in with probably doesn't have permission to read stored procedures from the schema in which the tables are. Still wouldn't expect a protocol violation. -- Andrew 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - ======================================================= 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - ======================================================= 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - ======================================================= 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - SQuirreL SQL Client Version 1.2beta6 started: Fri Aug 13 23:13:06 GMT+02:00 2004 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - Copyright (c) 2001-2003 Colin Bell and others 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.vendor: Sun Microsystems Inc. 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.version: 1.4.2_04 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.runtime.name: Java(TM) 2 Runtime Environment, Standard Edition 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.name: Windows 2000 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.version: 5.0 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.arch: x86 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - user.dir: C:\Program Files\SQuirreL SQL Client 1.2beta6 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - user.home: C:\Documents and Settings\inggsa 15 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.home: C:\j2sdk1.4.2_04\jre 15 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.class.path: C:\Program Files\SQuirreL SQL Client 1.2beta6\squirrel-sql.jar;C:\Program Files\SQuirreL SQL Client 1.2beta6\lib\commons-cli.jar;C:\Program Files\SQuirreL SQL Client 1.2beta6\lib\forms.jar;C:\Program Files\SQuirreL SQL Client 1.2beta6\lib\fw.jar;C:\Program Files\SQuirreL SQL Client 1.2beta6\lib\log4j.jar;C:\Program Files\SQuirreL SQL Client 1.2beta6\lib\nanoxml-2.1.jar; 1734 [main] INFO net.sourceforge.squirrel_sql.client.Application - Plugin oracle created in 0 ms, loaded in 0 ms, initialized in 0 ms, total 0 ms. 38297 [Thread-1] ERROR net.sourceforge.squirrel_sql.client.session.SchemaInfo - failed to load stroed procedures java.sql.SQLException: Protocol violation at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:591) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1199) at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:295) at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.readRow(ResultSetReader.java:118) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:700) at net.sourceforge.squirrel_sql.client.session.SchemaInfo.loadStoredProcedures(SchemaInfo.java:189) at net.sourceforge.squirrel_sql.client.session.SchemaInfo.load(SchemaInfo.java:169) at net.sourceforge.squirrel_sql.client.session.SchemaInfo.load(SchemaInfo.java:76) at net.sourceforge.squirrel_sql.client.session.Session.loadTableInfo(Session.java:690) at net.sourceforge.squirrel_sql.client.session.Session.access$000(Session.java:66) at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:192) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:534) 75375 [AWT-EventQueue-0] INFO net.sourceforge.squirrel_sql.client.Application - Application shutting down 04/08/13 11:14. 75390 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.client.session.SessionManager - SQL error closing session java.sql.SQLException: Io exception: invalid arguments in call at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334) at oracle.jdbc.driver.OracleStatement.freeLine(OracleStatement.java:6483) at oracle.jdbc.driver.OracleConnection.needLine(OracleConnection.java:2400) at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:689) at oracle.jdbc.driver.OraclePreparedStatement.privateClose(OraclePreparedStatement.java:489) at oracle.jdbc.driver.OraclePreparedStatement.close(OraclePreparedStatement.java:396) at oracle.jdbc.driver.OracleConnection.close_statements(OracleConnection.java:2369) at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1448) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.close(SQLConnection.java:104) at net.sourceforge.squirrel_sql.client.session.Session.closeSQLConnection(Session.java:486) at net.sourceforge.squirrel_sql.client.session.Session.close(Session.java:222) at net.sourceforge.squirrel_sql.client.session.SessionManager.closeSession(SessionManager.java:253) at net.sourceforge.squirrel_sql.client.session.SessionWindowManager.privateCloseSession(SessionWindowManager.java:363) at net.sourceforge.squirrel_sql.client.session.SessionWindowManager.sessionInternalFrameClosed(SessionWindowManager.java:404) at net.sourceforge.squirrel_sql.client.session.SessionWindowManager.access$700(SessionWindowManager.java:43) at net.sourceforge.squirrel_sql.client.session.SessionWindowManager$SessionInternalFrameListener.internalFrameClosed(SessionWindowManager.java:448) at javax.swing.JInternalFrame.fireInternalFrameEvent(JInternalFrame.java:1528) at javax.swing.JInternalFrame.dispose(JInternalFrame.java:1756) at net.sourceforge.squirrel_sql.client.session.SessionWindowManager.closeSession(SessionWindowManager.java:302) at net.sourceforge.squirrel_sql.client.session.SessionWindowManager.closeAllSessions(SessionWindowManager.java:282) at net.sourceforge.squirrel_sql.client.Application.shutdown(Application.java:209) at net.sourceforge.squirrel_sql.client.mainframe.MainFrame.dispose(MainFrame.java:130) at net.sourceforge.squirrel_sql.client.mainframe.action.ExitAction.actionPerformed(ExitAction.java:38) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:289) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113) at javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:943) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:231) at java.awt.Component.processMouseEvent(Component.java:5100) at java.awt.Component.processEvent(Component.java:4897) at java.awt.Container.processEvent(Container.java:1569) at java.awt.Component.dispatchEventImpl(Component.java:3615) at java.awt.Container.dispatchEventImpl(Container.java:1627) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at java.awt.Container.dispatchEventImpl(Container.java:1613) at java.awt.Window.dispatchEventImpl(Window.java:1606) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.EventQueue.dispatchEvent(EventQueue.java:456) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) at java.awt.EventDispatchThread.run(EventDispatchThread.java:100) 75656 [AWT-EventQueue-0] INFO net.sourceforge.squirrel_sql.client.Application - Application shutdown complete 04/08/13 11:14. ___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com |
|
From: Colin B. <Col...@as...> - 2004-08-12 22:52:34
|
Hi Andrew, What happens if you try running the SQL directly in the SQL window? Do you get the same error? Its peculiar that opening a connection to another server seems to fix the problem on the first server. That points to a problem with the driver. Does the problem only occur on the HP-UX server? I.E. If you go first to the Windows server do you have the same problem? Does it happen on every table? Or just some? If its just some is there a common data type in the tables that have the problem that isn't in the the tables that don't have the problem? There are currently some problems with Oracle blob/clob columns in SQuirreL so maybe your problem is related to those. I've tested with Oracle 9.2.0.3.0 on a Solaris server with version 9.2.0.3 of the thin driver and don't have a similar problem. Col > -----Original Message----- > From: Andrew Inggs [mailto:am...@ya...] > Sent: Thursday, 12 August 2004 12:52 AM > To: squ...@li... > Subject: [Squirrel-sql-users] Oracle: Protocol violation/Bigger type > length than Maximum error > > > Setup is: > > SQuirreL SQL 1.2beta6 > Oracle Plugin 0.13 > Oracle JDBC thin driver 9.2.0.3.0 > Oracle Database 9.2.0.4.0 (HP-UX) > J2SE 1.4.2_04 > > The first time a run Squirrel and connect to this database, > click on a schema > (CRMCC, not the same as the username I log in with), open the > list of tables, select > a table (AGENT), click on the Contents tab, I get the > following errors: > > java.sql.SQLException: Protocol violation > java.sql.SQLException: Bigger type length than Maximum > > If I click on the top-level database connection and then back > on the table name I > get: > > java.sql.SQLException: Refcursor value is invalid > > Close database connection, reconnect, go to the first table > again, click Contents > tab: > > java.sql.SQLException: Io exception: invalid arguments in call > java.sql.SQLException: Io exception: invalid arguments in call > > If I then open up a connection to a database that has a > similar schema but runs on a > Windows server (Oracle Database 9.2.0.1.0), close this > connection, then reopen the > connection to the database on HP-UX I get no errors. > > A trace leading up to the first exception is given at the end > of this message. The > trace was generated using OracleLog (ojdbc14_g.jar with > oracle.jdbc.Trace and > oracle.jdbc.LogFile Java system properties set). The full > trace is available if > anyone is interested (2.2 MB uncompressed). > > Any ideas? > > -- Andrew > > DRVR OPER BaseResultSet.clearWarnings() > > DRVR OPER OracleConnection.getMetaData() > > DRVR OPER OracleConnection.getIncludeSynonyms() returned false > > DRVR OPER OracleConnection.getRemarksReporting() > > DRVR OPER OracleConnection.getRemarksReporting() > > DRVR OPER OracleConnection.getIncludeSynonyms() returned false > > DRVR OPER OracleConnection.getIncludeSynonyms() returned false > > DRVR OPER OracleConnection.getRemarksReporting() > > DRVR OPER OracleConnection.getIncludeSynonyms() returned false > > DRVR SQLS SQL: "SELECT NULL AS table_cat, > t.owner AS table_schem, > t.table_name AS table_name, > t.column_name AS column_name, > DECODE (t.data_type, 'CHAR', 1, 'VARCHAR2', 12, 'NUMBER', 3, > 'LONG', -1, 'DATE', 93, 'RAW', -3, 'LONG RAW', > -4, 1111) > AS data_type, > t.data_type AS type_name, > DECODE (t.data_precision, null, t.data_length, > t.data_precision) > AS column_size, > 0 AS buffer_length, > t.data_scale AS decimal_digits, > 10 AS num_prec_radix, > DECODE (t.nullable, 'N', 0, 1) AS nullable, > NULL AS remarks, > t.data_default AS column_def, > 0 AS sql_data_type, > 0 AS sql_datetime_sub, > t.data_length AS char_octet_length, > t.column_id AS ordinal_position, > DECODE (t.nullable, 'N', 'NO', 'YES') AS is_nullable > FROM all_tab_columns t > WHERE t.owner LIKE ? ESCAPE '/' > AND t.table_name LIKE ? ESCAPE '/' > AND t.column_name LIKE ? ESCAPE '/' > > ORDER BY table_schem, table_name, ordinal_position > " > > DRVR OPER OracleConnection.getDefaultFixedString() returning false > > DRVR OPER ResultSetUtil.needIdentifier(typeCode=1): return: false > > DRVR SQLS Input SQL: "SELECT NULL AS table_cat, > t.owner AS table_schem, > t.table_name AS table_name, > t.column_name AS column_name, > DECODE (t.data_type, 'CHAR', 1, 'VARCHAR2', 12, 'NUMBER', 3, > 'LONG', -1, 'DATE', 93, 'RAW', -3, 'LONG RAW', > -4, 1111) > AS data_type, > t.data_type AS type_name, > DECODE (t.data_precision, null, t.data_length, > t.data_precision) > AS column_size, > 0 AS buffer_length, > t.data_scale AS decimal_digits, > 10 AS num_prec_radix, > DECODE (t.nullable, 'N', 0, 1) AS nullable, > NULL AS remarks, > t.data_default AS column_def, > 0 AS sql_data_type, > 0 AS sql_datetime_sub, > t.data_length AS char_octet_length, > t.column_id AS ordinal_position, > DECODE (t.nullable, 'N', 'NO', 'YES') AS is_nullable > FROM all_tab_columns t > WHERE t.owner LIKE ? ESCAPE '/' > AND t.table_name LIKE ? ESCAPE '/' > AND t.column_name LIKE ? ESCAPE '/' > > ORDER BY table_schem, table_name, ordinal_position > " > > DRVR OPER OracleConnection.getIncludeSynonyms() returned false > > DRVR OPER OraclePreparedStatement.setString(paramIndex=1, x=CRMCC) > > DRVR OPER OraclePreparedStatement.setString(paramIndex=2, x=AGENT) > > DRVR OPER OraclePreparedStatement.setString(paramIndex=3, x=%) > > DRVR OPER OraclePreparedStatement.executeQuery() > > DRVR OPER OraclePreparedStatement.executeUpdate() > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=4) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=4) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=4) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=4) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=4) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=4) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=4) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=4) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=4) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=3) > > DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE) > > DRVR OPER OracleResultSetImpl.getString(columnIndex=4) > > DRVR OPER BaseResultSet.clearWarnings() > > DRVR OPER OracleConnection.getAutoCommit() returned true > > DRVR OPER OracleResultSetImpl.getInt(columnIndex=11) > > DRVR WARN DBError.findMessage(errNum, obj): returned Bigger > type length than Maximum > > DRVR WARN DBError.throwSqlException(e): Unable to find ORA > number from exception > > DRVR WARN DBError.findMessage(errNum, obj): returned Io > exception: Bigger type > length than Maximum > > DRVR OPER BaseResultSet.clearWarnings() > > DRVR WARN DBError.findMessage(errNum, obj): returned Protocol > violation > > DRVR OPER OracleResultSetImpl.close() > > DRVR WARN DBError.findMessage(errNum, obj): returned Protocol > violation > > DRVR OPER OraclePreparedStatement.sendBatch() > > DRVR WARN DBError.findMessage(errNum, obj): returned Protocol > violation > > DRVR WARN DBError.findMessage(errNum, obj): returned Protocol > violation > > > > > > > > > ___________________________________________________________ALL > -NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Colin B. <Col...@as...> - 2004-08-12 22:20:46
|
Hi Nicolas, > -----Original Message----- > From: Nicolas Modrzyk [mailto:Nic...@in...] > Sent: Wednesday, 11 August 2004 8:16 PM > To: squ...@li... > Subject: [Squirrel-sql-users] Squirrel 1.2beta stable ? > > C-JDBC is currently packaged with the 1.1final version of squirrel, > because we had problem trying to make squirrel1.2beta talking and > retrieveing the proper information from the C-JDBC driver. Later versions of the 1.2beta (we are currently at beta6) should do a better job of connecting to different DBMSs than 1.1 did so if you're having problems I'd appreciate some details. Maybe theres something we can do to help. C-JDBC isn't something I've yet tested SQuirreL with. > Do you. users & developpers think we should try to integrate > the latest > squirrel in our next release ? Or should we wait until a > 1.2final comes > out there first. 1.2 final is still a ways off. To give you a quick roadmap, beta7 should be out in the next couple of weeks. After that beta8 with some UI enhancements (chiefly allowing multiple object trees and SQL entry areas for a session) should follow quickly, the code for this has already been written by Jason I just have to integrate it with the current code base. Once thats done I'm intending to freeze enhancing the code base and just test/bug fix. I'd say we're 3 months from a stable release beta7 will be the most _stable_ like of the betas so far but I'd still be a little nervous about bundling it, having said that I use it every day at work. I guess you need to decide how long you can wait for a stable version of 1.2. I'm hoping for it to come out in 3 months but my record of estimating release dates so far is abysmal. Col |
|
From: gwg <gw...@co...> - 2004-08-12 12:53:43
|
Hi Andrew, Since the error seems to be generated by the Oracle driver this may not help us, but what does the Squirrel log file say? It is not clear from your message what OS you are running on so I can't tell you exactly where the Squirrel log file is, but if you do a search on your system for "squirrel" you should be able to find it. Glenn Andrew Inggs wrote: > Setup is: > > SQuirreL SQL 1.2beta6 > Oracle Plugin 0.13 > Oracle JDBC thin driver 9.2.0.3.0 > Oracle Database 9.2.0.4.0 (HP-UX) > J2SE 1.4.2_04 > > The first time a run Squirrel and connect to this database, click on a schema > (CRMCC, not the same as the username I log in with), open the list of tables, select > a table (AGENT), click on the Contents tab, I get the following errors: > > java.sql.SQLException: Protocol violation > java.sql.SQLException: Bigger type length than Maximum > > If I click on the top-level database connection and then back on the table name I > get: > > java.sql.SQLException: Refcursor value is invalid > > Close database connection, reconnect, go to the first table again, click Contents > tab: > > java.sql.SQLException: Io exception: invalid arguments in call > java.sql.SQLException: Io exception: invalid arguments in call > > If I then open up a connection to a database that has a similar schema but runs on a > Windows server (Oracle Database 9.2.0.1.0), close this connection, then reopen the > connection to the database on HP-UX I get no errors. > > A trace leading up to the first exception is given at the end of this message. The > trace was generated using OracleLog (ojdbc14_g.jar with oracle.jdbc.Trace and > oracle.jdbc.LogFile Java system properties set). The full trace is available if > anyone is interested (2.2 MB uncompressed). > > Any ideas? > > -- Andrew |
|
From: <am...@ya...> - 2004-08-11 14:52:07
|
Setup is:
SQuirreL SQL 1.2beta6
Oracle Plugin 0.13
Oracle JDBC thin driver 9.2.0.3.0
Oracle Database 9.2.0.4.0 (HP-UX)
J2SE 1.4.2_04
The first time a run Squirrel and connect to this database, click on a schema
(CRMCC, not the same as the username I log in with), open the list of tables, select
a table (AGENT), click on the Contents tab, I get the following errors:
java.sql.SQLException: Protocol violation
java.sql.SQLException: Bigger type length than Maximum
If I click on the top-level database connection and then back on the table name I
get:
java.sql.SQLException: Refcursor value is invalid
Close database connection, reconnect, go to the first table again, click Contents
tab:
java.sql.SQLException: Io exception: invalid arguments in call
java.sql.SQLException: Io exception: invalid arguments in call
If I then open up a connection to a database that has a similar schema but runs on a
Windows server (Oracle Database 9.2.0.1.0), close this connection, then reopen the
connection to the database on HP-UX I get no errors.
A trace leading up to the first exception is given at the end of this message. The
trace was generated using OracleLog (ojdbc14_g.jar with oracle.jdbc.Trace and
oracle.jdbc.LogFile Java system properties set). The full trace is available if
anyone is interested (2.2 MB uncompressed).
Any ideas?
-- Andrew
DRVR OPER BaseResultSet.clearWarnings()
DRVR OPER OracleConnection.getMetaData()
DRVR OPER OracleConnection.getIncludeSynonyms() returned false
DRVR OPER OracleConnection.getRemarksReporting()
DRVR OPER OracleConnection.getRemarksReporting()
DRVR OPER OracleConnection.getIncludeSynonyms() returned false
DRVR OPER OracleConnection.getIncludeSynonyms() returned false
DRVR OPER OracleConnection.getRemarksReporting()
DRVR OPER OracleConnection.getIncludeSynonyms() returned false
DRVR SQLS SQL: "SELECT NULL AS table_cat,
t.owner AS table_schem,
t.table_name AS table_name,
t.column_name AS column_name,
DECODE (t.data_type, 'CHAR', 1, 'VARCHAR2', 12, 'NUMBER', 3,
'LONG', -1, 'DATE', 93, 'RAW', -3, 'LONG RAW', -4, 1111)
AS data_type,
t.data_type AS type_name,
DECODE (t.data_precision, null, t.data_length, t.data_precision)
AS column_size,
0 AS buffer_length,
t.data_scale AS decimal_digits,
10 AS num_prec_radix,
DECODE (t.nullable, 'N', 0, 1) AS nullable,
NULL AS remarks,
t.data_default AS column_def,
0 AS sql_data_type,
0 AS sql_datetime_sub,
t.data_length AS char_octet_length,
t.column_id AS ordinal_position,
DECODE (t.nullable, 'N', 'NO', 'YES') AS is_nullable
FROM all_tab_columns t
WHERE t.owner LIKE ? ESCAPE '/'
AND t.table_name LIKE ? ESCAPE '/'
AND t.column_name LIKE ? ESCAPE '/'
ORDER BY table_schem, table_name, ordinal_position
"
DRVR OPER OracleConnection.getDefaultFixedString() returning false
DRVR OPER ResultSetUtil.needIdentifier(typeCode=1): return: false
DRVR SQLS Input SQL: "SELECT NULL AS table_cat,
t.owner AS table_schem,
t.table_name AS table_name,
t.column_name AS column_name,
DECODE (t.data_type, 'CHAR', 1, 'VARCHAR2', 12, 'NUMBER', 3,
'LONG', -1, 'DATE', 93, 'RAW', -3, 'LONG RAW', -4, 1111)
AS data_type,
t.data_type AS type_name,
DECODE (t.data_precision, null, t.data_length, t.data_precision)
AS column_size,
0 AS buffer_length,
t.data_scale AS decimal_digits,
10 AS num_prec_radix,
DECODE (t.nullable, 'N', 0, 1) AS nullable,
NULL AS remarks,
t.data_default AS column_def,
0 AS sql_data_type,
0 AS sql_datetime_sub,
t.data_length AS char_octet_length,
t.column_id AS ordinal_position,
DECODE (t.nullable, 'N', 'NO', 'YES') AS is_nullable
FROM all_tab_columns t
WHERE t.owner LIKE ? ESCAPE '/'
AND t.table_name LIKE ? ESCAPE '/'
AND t.column_name LIKE ? ESCAPE '/'
ORDER BY table_schem, table_name, ordinal_position
"
DRVR OPER OracleConnection.getIncludeSynonyms() returned false
DRVR OPER OraclePreparedStatement.setString(paramIndex=1, x=CRMCC)
DRVR OPER OraclePreparedStatement.setString(paramIndex=2, x=AGENT)
DRVR OPER OraclePreparedStatement.setString(paramIndex=3, x=%)
DRVR OPER OraclePreparedStatement.executeQuery()
DRVR OPER OraclePreparedStatement.executeUpdate()
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER BaseResultSet.clearWarnings()
DRVR OPER OracleConnection.getAutoCommit() returned true
DRVR OPER OracleResultSetImpl.getInt(columnIndex=11)
DRVR WARN DBError.findMessage(errNum, obj): returned Bigger type length than Maximum
DRVR WARN DBError.throwSqlException(e): Unable to find ORA number from exception
DRVR WARN DBError.findMessage(errNum, obj): returned Io exception: Bigger type
length than Maximum
DRVR OPER BaseResultSet.clearWarnings()
DRVR WARN DBError.findMessage(errNum, obj): returned Protocol violation
DRVR OPER OracleResultSetImpl.close()
DRVR WARN DBError.findMessage(errNum, obj): returned Protocol violation
DRVR OPER OraclePreparedStatement.sendBatch()
DRVR WARN DBError.findMessage(errNum, obj): returned Protocol violation
DRVR WARN DBError.findMessage(errNum, obj): returned Protocol violation
___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com
|
|
From: Nicolas M. <Nic...@in...> - 2004-08-11 10:18:06
|
Hi, C-JDBC is currently packaged with the 1.1final version of squirrel, because we had problem trying to make squirrel1.2beta talking and retrieveing the proper information from the C-JDBC driver. Do you. users & developpers think we should try to integrate the latest squirrel in our next release ? Or should we wait until a 1.2final comes out there first. Thanks for any comments, Nicolas Modryzk, |
|
From: Victor O. <vo...@gm...> - 2004-08-08 00:30:25
|
Try using the 8.1.7 JDBC driver. Or pick latest ones from http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html Victor Stan Berka wrote: > Hi, > A new error that stops me from using Squirrel, pretty much (no changes > in Squirrel install nor driver/Java env.). When I log in, find a table > in the object tree, select and request to see its columns, this error > message shows up. It's not on all Servers but all servers used to work > w/o any problems. It's Oracle server 8.1.7.4 with Oracle thin JDBC > driver 8.1.6. I'm running Squirrel on Win2K under jdk1.4.1. > > Anyone has seen this error before with Squirrel SQL? > > Stan |
|
From: Victor O. <v....@gm...> - 2004-08-07 13:33:08
|
Try using the 8.1.7 JDBC driver. Or pick latest ones from http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html Victor Stan Berka wrote: > Hi, > A new error that stops me from using Squirrel, pretty much (no changes > in Squirrel install nor driver/Java env.). When I log in, find a table > in the object tree, select and request to see its columns, this error > message shows up. It's not on all Servers but all servers used to work > w/o any problems. It's Oracle server 8.1.7.4 with Oracle thin JDBC > driver 8.1.6. I'm running Squirrel on Win2K under jdk1.4.1. > > Anyone has seen this error before with Squirrel SQL? > > Stan |
|
From: Colin B. <co...@in...> - 2004-08-07 04:26:25
|
Hi Stan, Please don't start a new thread by replying to an old one, it stuffs up threading in most email clients. Theres no need to send messages to all the mailing lists, the users list is the appropriate place for this. On Fri, Aug 06, 2004 at 01:34:00PM -0700, Stan Berka wrote: > A new error that stops me from using Squirrel, pretty much (no changes > in Squirrel install nor driver/Java env.). When I log in, find a table > in the object tree, select and request to see its columns, this error > message shows up. It's not on all Servers but all servers used to work > w/o any problems. It's Oracle server 8.1.7.4 with Oracle thin JDBC > driver 8.1.6. I'm running Squirrel on Win2K under jdk1.4.1. Whats changed? Are you querying tables that you weren't before, possibly with different data types? Have you checked the Oracle site to see if they have any information? -- Colin Bell http://www.squirrelsql.org |
|
From: Stan B. <sb...@po...> - 2004-08-06 20:34:24
|
Hi, A new error that stops me from using Squirrel, pretty much (no changes in Squirrel install nor driver/Java env.). When I log in, find a table in the object tree, select and request to see its columns, this error message shows up. It's not on all Servers but all servers used to work w/o any problems. It's Oracle server 8.1.7.4 with Oracle thin JDBC driver 8.1.6. I'm running Squirrel on Win2K under jdk1.4.1. Anyone has seen this error before with Squirrel SQL? Stan Colin Bell wrote: >Version 0.32 of the Look and Feel plugin has been released. This fixes a >problem with SQuirreL sometimes locking up when started using the >Skin Look and Feel. > >Requires either 1.1final1 or 1.2beta6 or greater of SQuirreL. > >Downloads available at: > >http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=38421 >&release_id=258070 > > >------------------------------------------------------- >This SF.Net email is sponsored by OSTG. Have you noticed the changes on >Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, >one more big change to announce. We are now OSTG- Open Source Technology >Group. Come see the changes on the new OSTG site. www.ostg.com >_______________________________________________ >Squirrel-sql-develop mailing list >Squ...@li... >https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > > > |
|
From: Colin B. <Col...@as...> - 2004-08-06 02:59:03
|
Version 0.32 of the Look and Feel plugin has been released. This fixes a problem with SQuirreL sometimes locking up when started using the Skin Look and Feel. Requires either 1.1final1 or 1.2beta6 or greater of SQuirreL. Downloads available at: http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=38421 &release_id=258070 |
|
From: <co...@in...> - 2004-07-27 07:22:19
|
The SQuirreL SQL Client project now has its own domain: http://www.squirrelsql.org Col |
|
From: <co...@in...> - 2004-07-24 01:06:54
|
<snip> > With squirrel I can't change any row with an date. If I > use the format 01.01.2000 I get an squirrel error the > format should be yyyy-mm-dd hh:mm:ss.fffff. But using this > format I get an oracle exception. This is a known problem using SQuirreL with Oracle which we are looking at. Col |
|
From: <Bir...@t-...> - 2004-07-23 17:38:15
|
Hi, there is a standard JDBC escape syntax for dates that any database/JDBC driver should accept. For details see http://java.sun.com/j2se/1.3/docs/guide/jdbc/spec/jdbc-spec.frame11.html The SQL Entry Area Enhancements Plugin overs an 'Escape date' entry in the right mouse click menu of the SQL editor that will generate the escape syntax for you. See http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=64864&release_id=233971 Gerd Be...@gm... wrote: > Hello, > > I have a problem changing rows in tables which contains date fields. I use > the latest version ov squirrel with an orcle 9 database. > > I can change the date row direct on the oracle host using sqlplus. In this > case I use e.g. 01.01.2000 as date. > > With squirrel I can't change any row with an date. If I use the format > 01.01.2000 I get an squirrel error the format should be yyyy-mm-dd > hh:mm:ss.fffff. But using this format I get an oracle exception. > > Has somebody a solution for this? > > I think this was already reported as bug. > > txs, > |
|
From: <Be...@gm...> - 2004-07-23 12:56:05
|
Hello, I have a problem changing rows in tables which contains date fields. I use the latest version ov squirrel with an orcle 9 database. I can change the date row direct on the oracle host using sqlplus. In this case I use e.g. 01.01.2000 as date. With squirrel I can't change any row with an date. If I use the format 01.01.2000 I get an squirrel error the format should be yyyy-mm-dd hh:mm:ss.fffff. But using this format I get an oracle exception. Has somebody a solution for this? I think this was already reported as bug. txs, -- +++ GMX DSL-Tarife 3 Monate gratis* +++ Nur bis 25.7.2004 +++ Bis 24.000 MB oder 300 Freistunden inkl. http://www.gmx.net/de/go/dsl |
|
From: <co...@in...> - 2004-07-21 07:17:57
|
Hi Tim, I've just tried this on a Win XP box running OpenSSH within Cygwin and it worked for me with both 1.1final1 and 1.2beta6 of SQuirreL. I'm not sure that its a fair test as I'm running both the SSH client and server on the same PC but unfortunately its the closest I can get to your setup. I didn't need to set any extra driver properties. You could try 1.2beta6, it should give you some better error messages. Col |
|
From: Tim B. <tim...@ph...> - 2004-07-21 06:27:58
|
Hi Glenn- thanks for the reply :) I should have added that the machine is set up so that I can only make an ssh connection- the same is true if I want to make a vanilla MySQL client connection to the same machine. I've cc'd this to the list as well, hope that's ok? Thanks, Tim On 20/7/04 9:57 pm, "gwg" <gw...@co...> wrote: > Hi Tim, > > If MySQL is set up in the default manner, it should be listening on port > 3306. Unless your machine is set up in an unusual way, you should be > able to access the remote DB directly without using ssh. I don't have a > Squirrel instance available to check this right now, but something like: > > jdbc:mysql://the.mysql.server.node:3306/database_name > > may work for you. > > Glenn > > Tim Barrass wrote: >> Hi all, >> >> Is it possible to ssh tunnel a connection to a MySQL database using >> Squirrel? >> >> On a remote machine I can do the following >> >> >>> ssh -C -L 3307:the.mysql.server.node:3306 user@ the.mysql.server.node >>> mysql -h localhost -P 3307 -u user -p database_name >> >> >> - this connects fine. However, if I set up the ssh tunnel and try a Squirrel >> alias with the contact string >> >> jdbc:mysql://localhost:3307/database_name >> >> It tells me >> >> Unexpected Error occured attempting to open an SQL connection. Any advice >> very welcome... I'm using the 1.1final1 Squirrel on Mac OS X 10.3.4... >> >> Tim >> >> >> >> >> >> ------------------------------------------------------- >> This SF.Net email is sponsored by BEA Weblogic Workshop >> FREE Java Enterprise J2EE developer tools! >> Get your free copy of BEA WebLogic Workshop 8.1 today. >> http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> > > > --- > [This E-mail scanned for viruses by Declude Virus for the IOP] > |
|
From: <co...@in...> - 2004-07-20 22:25:53
|
I haven't tried this but as far as I know it should work. You may need to set some SSH related driver properties in the URL. http://dev.mysql.com/doc/connector/j/en/index.html#id2801034 Take a look in Table 2.1 under Security. The properties you may need are useSSL and requireSSL. In the SQuirreL 1.2 betas you can set these through the Driver properties dialog but in 1.1 you'll need to put them directly into the URL. Col > Hi all, > > Is it possible to ssh tunnel a connection to a MySQL > database using Squirrel? > > On a remote machine I can do the following > > > ssh -C -L 3307:the.mysql.server.node:3306 user@ > > the.mysql.server.node mysql -h localhost -P 3307 -u user > -p database_name > > - this connects fine. However, if I set up the ssh tunnel > and try a Squirrel alias with the contact string > > jdbc:mysql://localhost:3307/database_name > > It tells me > > Unexpected Error occured attempting to open an SQL > connection. Any advice very welcome... I'm using the > 1.1final1 Squirrel on Mac OS X 10.3.4... |
|
From: Tim B. <tim...@ph...> - 2004-07-20 15:57:44
|
Hi all, Is it possible to ssh tunnel a connection to a MySQL database using Squirrel? On a remote machine I can do the following > ssh -C -L 3307:the.mysql.server.node:3306 user@ the.mysql.server.node > mysql -h localhost -P 3307 -u user -p database_name - this connects fine. However, if I set up the ssh tunnel and try a Squirrel alias with the contact string jdbc:mysql://localhost:3307/database_name It tells me Unexpected Error occured attempting to open an SQL connection. Any advice very welcome... I'm using the 1.1final1 Squirrel on Mac OS X 10.3.4... Tim |
|
From: Colin B. <Col...@as...> - 2004-07-20 00:00:24
|
Hi Ethan, I've managed to "lockup" SQuirreL when working with clobs in oracle now. Most of the problem is fixed with the code currently in CVS but theres now a deadlock within the Oracle JDBC driver caused by the way we're handling clob columns and almost certainly blobs as well. I'm looking at this now and hope to have a fix soon. Col -----Original Message----- From: Knepp, Ethan [mailto:eK...@c-...] Sent: Friday, 2 July 2004 10:27 PM To: 'squ...@li...' Subject: RE: [Squirrel-sql-users] CLOB in result SQL causing lockup... I'm sorry I was wrong, SQuirrel Client doesn't lock up, but it acts like it can't refresh its display. I can choose menu items, pick from the history drop down, move the size of windows, and click in the results panel, but the results only show one or two rows at at time, and the CLOB column data doesn't show up. The table is fairly small (100-200 records), so the limit rows check box in the SQL panel didn't make a difference. I am also not performing any special SQL like 'order by'. I am actually doing one where for an individual row to be returned. If it helps when I view the table in the Content Tab, the CLOB column rows don't immediately show the data. At first, the column rows read '<CLOB>', then after I select an individual cell, the contents is displayed. Is this normal behavior? I will try an updated jdbc driver and see if that makes a difference. Thanks, Ethan -----Original Message----- From: co...@in... [mailto:co...@in...] Sent: Thursday, July 01, 2004 6:59 PM To: squ...@li... Subject: Re: [Squirrel-sql-users] CLOB in result SQL causing lockup... Hi Ethan, Works for me Oracle: Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production JDBC thin driver: 9.2.0.3.0 java: 1.4.2_03-b02 If its working in the Content Tab but not in the SQL tab then it may be something as simple as you having the "Contents - Limit Rows" checkbox selected with a small number of rows (e.g. 100) in the Object Tree tab in your session properties but not having the "Limit Rows" checkbox selected on the SQL tab, which could mean (depending on the size of your table) that you are bringing back a large amount of data which may take a long time. Are you using an ORDER BY clause or a WHERE clause that may be causing a full table scan and so slowing it down? Col > Does anyone know why a SQL statement that selects a table > that contains a CLOB column is causing my SQuirrel Client > to lockup? I can view the same table in Object Tree with > no problems. > > SQuirrel Version: 1.2beta6 > Java Version: 1.4.2_04 > Database: Oracle 9.2.0.4 > > CLOB column metadata: > COLUMN_NAME: ENTRY > TYPE_NAME: CLOB > COLUMN_SIZE: 4000 > DECIMAL_DIGITS: <null> > IS_NULLABLE: YES > COLUMN_DEF: <null> > REMARKS: <null> > DATA_TYPE: 1111 > BUFFER_LENGTH: 0 > NUM_PREC_RADIX: 10 > NULLABLE: 1 > SQL_DATA_TYPE: 0 > SQL_DATETIME_SUB: 0 > CHAR_OCTET_LENGTH: 4000 > ORDINAL_POSITION: 5 ------------------------------------------------------- This SF.Net email sponsored by Black Hat Briefings & Training. Attend Black Hat Briefings & Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Tim B. <tim...@ph...> - 2004-07-16 16:16:15
|
Neville- Thanks for the quick reply- and the solution works perfectly, thanks a bunch :) Have a good weekend! Tim On 16/7/04 3:09 pm, "Rowe, Neville" <Nev...@dr...> wrote: > Tim, > > Use <ctrl> q to quit rather than <apple> q - or from the menu use file->quit > rather than apple->quit. Squirrel SQL doesn't integrate with some of the > apple specific menu structure appropriately. > > I've got a small plug-in which (along with some changes in core) makes this > work properly so that this works properly. Unfortunately I've not been able > to give it to Colin successfully yet and will not be around for the next > week to send it directly to you. Once I'm back I should be able to send it > directly to you if you want. > > Neville > > -----Original Message----- > From: squ...@li... > [mailto:squ...@li...] On Behalf Of Tim > Barrass > Sent: 16 July 2004 14:56 > To: squ...@li... > Subject: [Squirrel-sql-users] Squirrel forgets it's settings...? > > > Hi all- > > I'm running Squirrel on OS X 10.3.4, but have a problem. I can point it to > the correct Oracle JDBC driver and connect to databases with no tourble. > However, when I quit Squirrel all the settings seem to be forgotten- every > time I start Squirrel I have to start from scratch. Any ideas? Might it be > failing because it doesn't have write permission in the apps dir..? > > Other than that- Squirrel is great :) > > Cheers, > Tim > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by BEA Weblogic Workshop > FREE Java Enterprise J2EE developer tools! > Get your free copy of BEA WebLogic Workshop 8.1 today. > http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click > _______________________________________________ > Squirrel-sql-users mailing list Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > ------------------------------------------------------------------------------ > -- > The information contained herein is confidential and is intended solely for > the > addressee. Access by any other party is unauthorised without the express > written permission of the sender. If you are not the intended recipient, > please > contact the sender either via the company switchboard on +44 (0)20 7623 8000, > or > via e-mail return. If you have received this e-mail in error or wish to read > our > e-mail disclaimer statement and monitoring policy, please refer to > http://www.drkw.com/disc/email/ or contact the sender. 3167 > ------------------------------------------------------------------------------ > -- > > --- > [This E-mail scanned for viruses by Declude Virus for the IOP] > |
|
From: Rowe, N. <Nev...@dr...> - 2004-07-16 15:53:43
|
Tim, Use <ctrl> q to quit rather than <apple> q - or from the menu use file->quit rather than apple->quit. Squirrel SQL doesn't integrate with some of the apple specific menu structure appropriately. I've got a small plug-in which (along with some changes in core) makes this work properly so that this works properly. Unfortunately I've not been able to give it to Colin successfully yet and will not be around for the next week to send it directly to you. Once I'm back I should be able to send it directly to you if you want. Neville -----Original Message----- From: squ...@li... [mailto:squ...@li...] On Behalf Of Tim Barrass Sent: 16 July 2004 14:56 To: squ...@li... Subject: [Squirrel-sql-users] Squirrel forgets it's settings...? Hi all- I'm running Squirrel on OS X 10.3.4, but have a problem. I can point it to the correct Oracle JDBC driver and connect to databases with no tourble. However, when I quit Squirrel all the settings seem to be forgotten- every time I start Squirrel I have to start from scratch. Any ideas? Might it be failing because it doesn't have write permission in the apps dir..? Other than that- Squirrel is great :) Cheers, Tim ------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users -------------------------------------------------------------------------------- The information contained herein is confidential and is intended solely for the addressee. Access by any other party is unauthorised without the express written permission of the sender. If you are not the intended recipient, please contact the sender either via the company switchboard on +44 (0)20 7623 8000, or via e-mail return. If you have received this e-mail in error or wish to read our e-mail disclaimer statement and monitoring policy, please refer to http://www.drkw.com/disc/email/ or contact the sender. 3167 -------------------------------------------------------------------------------- |
|
From: Tim B. <tim...@ph...> - 2004-07-16 13:55:49
|
Hi all- I'm running Squirrel on OS X 10.3.4, but have a problem. I can point it to the correct Oracle JDBC driver and connect to databases with no tourble. However, when I quit Squirrel all the settings seem to be forgotten- every time I start Squirrel I have to start from scratch. Any ideas? Might it be failing because it doesn't have write permission in the apps dir..? Other than that- Squirrel is great :) Cheers, Tim |
|
From: Colin B. <Col...@as...> - 2004-07-12 22:00:38
|
Apologies if you've already received this, there have been some problems with the mailing list. > -----Original Message----- > From: M.Neuber [mailto:aqu...@fr...] > Sent: Monday, 12 July 2004 2:44 AM > can anybody tell me how to set the SQLMODE > in a SAPdb/MaxDB with SQuirreL? You specify it in the URL. The SAPDB documentation shows you how: http://www.sapdb.org/7.4/jdbcSapdbcEng.html |
