dbVisualiser 6.5 crashes when selecting Sybase stored procedure

Hi there, I've just upgraded to version 6.5 (from 6.0.14) and am having problems viewing Sybase stored procedures on a particular server. I'm using the same JConnect drivers that I used previously but now when I select a stored procedure on the left hand pane I get the error - Incorrect syntax near '['. and the dump listed below. This works fine in version 6.0.14. Confusingly it also works fine in version 6.5 with a connection to a different Sybase server. Please advise. ----- Product Information ----- Product: DbVisualizer Personal 6.5 Build: #1339 (2008/10/23 11:47) Java VM: Java HotSpot(TM) Client VM Java Version: 1.6.0_07 Java Vendor: Sun Microsystems Inc. OS Name: Windows XP OS Arch: x86 OS Version: 5.1 ----- Connected Databases ----- Database Type: Sybase ASE Major Version: -1 Minor Version: 5 Profile: sybase-ase Connection Message: Adaptive Server Enterprise Adaptive Server Enterprise/12.5.0.3/EBF 11337 ESD#3/P/HP9000-879/HP-UX 11.0/rel12503/1933/64-bit/FBO/Fri Aug 1 07:59:26 2003 jConnect (TM) for JDBC (TM) jConnect (TM) for JDBC(TM)/6.05(Build 25828)/P/EBF13044/JDK14/Fri Sep 30 1:05:16 2005 ----- Debug Printouts ----- com.onseven.dbvis.G.B.L: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['. at com.onseven.dbvis.G.B.H.execute(Z:3362) at com.onseven.dbvis.G.B.V.run(Z:3245) at com.onseven.dbvis.S.A.A.?(Z:2122) at com.onseven.dbvis.S.A.A.?(Z:1382) at com.onseven.dbvis.S.A.A.?(Z:588) at com.onseven.dbvis.b.B.A.A.K.?(Z:2874) at com.onseven.dbvis.b.B.A.A.J.?(Z:1314) at com.onseven.dbvis.b.B.E.?(Z:3046) at com.onseven.dbvis.b.B.E.?(Z:3195) at com.onseven.dbvis.b.B.E.?(Z:759) at com.onseven.dbvis.b.B.E$1.ancestorAdded(Z:1320) at javax.swing.AncestorNotifier.fireAncestorAdded(Unknown Source) at javax.swing.AncestorNotifier.componentShown(Unknown Source) at java.awt.Component.processComponentEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at com.onseven.dbvis.J.A.g.dispatchEvent(Z:2143) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['. at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source) at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.Z.B.B.invoke(Z:573) at $Proxy2.execute(Unknown Source) at com.onseven.dbvis.G.B.H.execute(Z:2529) ... 26 more

Hi Nick, Can you please do a couple of things to help me find the problem. Enable debug (Tools -> Debug Window), select a procedure that cause this and post the debug output. Run this query and post the result: SELECT text FROM [].dbo.syscomments c , [].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id('.') with , and replaced by the corresponding names for your test case. Kind Regards, Hans

Hi there, thanks for the response. The debug output is shown below. The stored procedure text is attached. ------------------------- Product Information ------------------------ Product: DbVisualizer Personal 6.5 Build: #1339 (2008/10/23 11:47) Java VM: Java HotSpot(TM) Client VM Java Version: 1.6.0_07 Java Vendor: Sun Microsystems Inc. OS Name: Windows XP OS Arch: x86 OS Version: 5.1 ------------------------- Connected Databases ------------------------ Database Type: Sybase ASE Major Version: -1 Minor Version: 5 Profile: sybase-ase Connection Message: Adaptive Server Enterprise Adaptive Server Enterprise/12.5.0.3/EBF 11337 ESD#3/P/HP9000-879/HP-UX 11.0/rel12503/1933/64-bit/FBO/Fri Aug 1 07:59:26 2003 jConnect (TM) for JDBC (TM) jConnect (TM) for JDBC(TM)/6.05(Build 25828)/P/EBF13044/JDK14/Fri Sep 30 1:05:16 2005 --------------------------- Debug Printouts -------------------------- JdbcOdbcDriver class loaded registerDriver: driver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@5c77 5d] DriverManager.initialize: jdbc.drivers = null JDBC DriverManager initialized registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@a0b138] 09:06:57 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:06:57 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1d3030a] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybD river@a0b138 09:06:57 [DEBUG] Connecting: MIS Dev 09:06:57 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:06:57 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1f56157] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.Syb Driver@1d3030a 09:06:58 [DEBUG] RootConnection: SybConnection.setAutoCommit(true) 09:06:58 [DEBUG] Using facade: sybase-ase for MIS Dev 09:06:58 [DEBUG] RootConnection: SybConnection.createStatement() 09:06:58 [DEBUG] executing "set quoted_identifier off" 09:06:58 [DEBUG] RootConnection: SybStatement.execute("set quoted_identifier off") 09:06:58 [DEBUG] Loading profile /profiles/sybase-ase.xml 09:06:58 [DEBUG] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'" 09:06:58 [DEBUG] Using profile: sybase-ase 09:06:58 [DEBUG] elementName: 'GroupNode' label: 'Databases' type: 'Databases' on-empty-output: 'stop' 09:06:58 [DEBUG] elementName: 'GroupNode' label: 'DBA Views' type: 'DBA' on-empty-output: 'stop' 09:06:58 [DEBUG] Returning cloned generic Command for idref: getColumnNamesFor 09:07:17 [DEBUG] elementName: 'DataNode' label: '${getCatalogs.TABLE_CAT}' type: 'Catalog' on-empty-output: 'continue' 09:07:17 [DEBUG] Returning cloned generic Command for idref: getCatalogs 09:07:17 [DEBUG] CommandId: getCatalogs 09:07:17 [DEBUG] DbConnection: MIS Dev 09:07:17 [DEBUG] getting column 1 (java.lang.String) using getString() 09:07:17 [DEBUG] Total rows/columns: 22/1. Rows after filtering: 22 09:07:19 [DEBUG] elementName: 'GroupNode' label: 'Tables' type: 'Tables' on-empty-output: 'stop' 09:07:19 [DEBUG] elementName: 'GroupNode' label: 'System Tables' type: 'SystemTables' on-empty-output: 'stop' 09:07:19 [DEBUG] elementName: 'GroupNode' label: 'Views' type: 'Views' on-empty-output: 'stop' 09:07:19 [DEBUG] elementName: 'GroupNode' label: 'Users' type: 'Users' on-empty-output: 'stop' 09:07:19 [DEBUG] elementName: 'GroupNode' label: 'Groups' type: 'Groups' on-empty-output: 'stop' 09:07:19 [DEBUG] elementName: 'GroupNode' label: 'User Defined Data Types' type: 'Types' on-empty-output: 'stop' 09:07:19 [DEBUG] elementName: 'GroupNode' label: 'Triggers' type: 'Triggers' on-empty-output: 'stop' 09:07:19 [DEBUG] elementName: 'GroupNode' label: 'Stored Procedures' type: 'Procedures' on-empty-output: 'stop' 09:07:21 [DEBUG] elementName: 'DataNode' label: '${sybase-ase.getObjects.owner}.${sybase-ase.getObjects.name}' type: 'Procedure' on-empty-output: 'stop' 09:07:21 [DEBUG] Returning cloned generic Command for idref: sybase-ase.getObjects 09:07:21 [DEBUG] CommandId: sybase-ase.getObjects sql: select owner = user_name(uid), name, crdate "Creation Date" from ${database}.dbo.sysobjects where type = '${type}' order by name 09:07:21 [DEBUG] Executing... 09:07:21 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis' 09:07:21 [DEBUG] RootConnection: SybConnection.createStatement() 09:07:21 [DEBUG] SQL: select owner = user_name(uid), name, crdate "Creation Date" from mis.dbo.sysobjects where type = 'P' order by name 09:07:21 [DEBUG] RootConnection: SybConnection.nativeSQL("select owner = user_name(uid), name, crdate "Creation Date" from mis.dbo.sysobjects where type = 'P' order by name") 09:07:21 [DEBUG] RootConnection: SybStatement.setEscapeProcessing(false) 09:07:21 [DEBUG] RootConnection: SybStatement.execute("select owner = user_name(uid), name, crdate "Creation Date" from mis.dbo.sysobjects where type = 'P' order by name") 09:07:21 [DEBUG] getting column 1 (java.lang.String) using getString() 09:07:21 [DEBUG] getting column 2 (java.lang.String) using getString() 09:07:21 [DEBUG] getting column 3 (java.sql.Timestamp) using getTimestamp() 09:07:21 [DEBUG] Total rows/columns: 1545/3. Rows after filtering: 1545 09:07:24 [DEBUG] remove DataView type: Tables from: ObjectView 09:07:24 [DEBUG] remove DataView type: References from: ObjectView 09:07:24 [DEBUG] remove DataView type: Tables from: ObjectView 09:07:24 [DEBUG] adding DataView type: Tables to: Tables at index: 1 09:07:24 [DEBUG] remove DataView type: References from: ObjectView 09:07:24 [DEBUG] adding DataView type: References to: Tables at index: 3 09:07:24 [DEBUG] adding DataView type: Source to: Table at index: -1 09:07:24 [DEBUG] adding DataView type: Trigger to: Table at index: -1 09:07:24 [DEBUG] adding ObjectView type: SystemTables 09:07:24 [DEBUG] adding ObjectView type: SystemTable 09:07:24 [DEBUG] adding ObjectView type: Views 09:07:24 [DEBUG] adding ObjectView type: View 09:07:24 [DEBUG] adding ObjectView type: Users 09:07:24 [DEBUG] adding ObjectView type: User 09:07:24 [DEBUG] adding ObjectView type: Groups 09:07:24 [DEBUG] adding ObjectView type: Group 09:07:24 [DEBUG] adding ObjectView type: Triggers 09:07:24 [DEBUG] adding ObjectView type: Trigger 09:07:24 [DEBUG] adding ObjectView type: Types 09:07:24 [DEBUG] remove DataView type: Procedures from: ObjectView 09:07:24 [DEBUG] adding DataView type: Procedures to: Procedures at index: 1 09:07:24 [DEBUG] remove DataView type: Columns from: ObjectView 09:07:24 [DEBUG] adding DataView type: SourceEditor to: Procedure at index: -1 09:07:24 [DEBUG] adding DataView type: Interface to: Procedure at index: -1 09:07:24 [DEBUG] adding ObjectView type: ServerInfo 09:07:24 [DEBUG] adding ObjectView type: Logins 09:07:24 [DEBUG] adding ObjectView type: Login 09:07:24 [DEBUG] adding ObjectView type: Devices 09:07:24 [DEBUG] adding ObjectView type: Device 09:07:24 [DEBUG] adding ObjectView type: RemoteServers 09:07:24 [DEBUG] adding ObjectView type: ServerRoles 09:07:24 [DEBUG] adding ObjectView type: ServerRole 09:07:24 [DEBUG] adding ObjectView type: Processes 09:07:24 [DEBUG] adding ObjectView type: Transactions 09:07:24 [DEBUG] adding ObjectView type: Locks 09:07:25 [DEBUG] Returning cloned generic Command for idref: getProcedureColumns 09:07:25 [DEBUG] Executing... 09:07:25 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis' 09:07:25 [DEBUG] RootConnection: SybConnection.prepareStatement("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ") 09:07:25 [DEBUG] index=[1] name=[qn] value=[dbo.GenordsHK_nav_ext] type=[String] options=[nullable ] 09:07:25 [DEBUG] setting column 1 (String) using setString() 09:07:25 [DEBUG] RootConnection: SybPreparedStatement.setString(1, "dbo.GenordsHK_nav_ext") 09:07:25 [DEBUG] SQL: SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) 09:07:25 [DEBUG] RootConnection: SybConnection.nativeSQL("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ") 09:07:25 [DEBUG] RootConnection: SybPreparedStatement.execute() SQLState(42000) vendor code(102) com.onseven.dbvis.G.B.L: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['. at com.onseven.dbvis.G.B.H.execute(Z:3362) at com.onseven.dbvis.G.B.V.run(Z:3245) at com.onseven.dbvis.S.A.A.?(Z:2122) at com.onseven.dbvis.S.A.A.?(Z:1382) at com.onseven.dbvis.S.A.A.?(Z:588) at com.onseven.dbvis.b.B.A.A.K.?(Z:2874) at com.onseven.dbvis.b.B.A.A.J.?(Z:1314) at com.onseven.dbvis.b.B.E.?(Z:3046) at com.onseven.dbvis.b.B.E.?(Z:3195) at com.onseven.dbvis.b.B.E.?(Z:759) at com.onseven.dbvis.b.B.E$1.ancestorAdded(Z:1320) at javax.swing.AncestorNotifier.fireAncestorAdded(Unknown Source) at javax.swing.AncestorNotifier.componentShown(Unknown Source) at java.awt.Component.processComponentEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at com.onseven.dbvis.J.A.g.dispatchEvent(Z:2143) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['. at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source) at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.Z.B.B.invoke(Z:573) at $Proxy2.execute(Unknown Source) at com.onseven.dbvis.G.B.H.execute(Z:2529) ... 26 more

Hans, I've just realised that when I ran your suggested query I had removed the square brackets around the database name. If I run it with the [] then I get the following debug output. Sorry for the confusion. ------------------------- Product Information ------------------------ Product: DbVisualizer Personal 6.5 Build: #1339 (2008/10/23 11:47) Java VM: Java HotSpot(TM) Client VM Java Version: 1.6.0_07 Java Vendor: Sun Microsystems Inc. OS Name: Windows XP OS Arch: x86 OS Version: 5.1 ------------------------- Connected Databases ------------------------ Database Type: Sybase ASE Major Version: -1 Minor Version: 5 Profile: sybase-ase Connection Message: Adaptive Server Enterprise Adaptive Server Enterprise/12.5.0.3/EBF 11337 ESD#3/P/HP9000-879/HP-UX 11.0/rel12503/1933/64-bit/FBO/Fri Aug 1 07:59:26 2003 jConnect (TM) for JDBC (TM) jConnect (TM) for JDBC(TM)/6.05(Build 25828)/P/EBF13044/JDK14/Fri Sep 30 1:05:16 2005 --------------------------- Debug Printouts -------------------------- [cleared] ] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@4a25ab 15:28:20 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:28:20 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@10004ad] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1ef330a 15:28:20 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:28:20 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@33150a] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@10004ad 15:28:20 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:28:20 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1aa4de2] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@33150a 15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@12343d4] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1aa4de2 15:28:25 [DEBUG] Freeing connection: DefaultEditor-0 for MIS Dev 15:28:25 [DEBUG] Disconnecting: MIS Dev 15:28:25 [DEBUG] DefaultEditor-0: SybConnection.close() 15:28:25 [DEBUG] Disconnecting: MIS Dev 15:28:25 [DEBUG] RootConnection: SybConnection.close() 15:28:25 [DEBUG] Connection closed: MIS Dev 15:28:25 [DEBUG] Connection closed: MIS Dev 15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@199405a] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@12343d4 15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@173b4ce] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@199405a 15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@457189] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@173b4ce 15:28:25 [DEBUG] Connecting: MIS Dev 15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1965ff3] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@457189 15:28:25 [DEBUG] RootConnection: SybConnection.setAutoCommit(true) 15:28:25 [DEBUG] Using facade: sybase-ase for MIS Dev 15:28:25 [DEBUG] Loading profile /profiles/sybase-ase.xml 15:28:25 [DEBUG] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'" 15:28:25 [DEBUG] Using profile: sybase-ase 15:28:25 [DEBUG] Returning cloned generic Command for idref: getCatalogs 15:28:25 [DEBUG] CommandId: getCatalogs 15:28:25 [DEBUG] DbConnection: MIS Dev 15:28:25 [DEBUG] elementName: 'GroupNode' label: 'Databases' type: 'Databases' on-empty-output: 'stop' 15:28:25 [DEBUG] elementName: 'GroupNode' label: 'DBA Views' type: 'DBA' on-empty-output: 'stop' 15:28:25 [DEBUG] getting column 1 (java.lang.String) using getString() 15:28:25 [DEBUG] elementName: 'DataNode' label: '${getCatalogs.TABLE_CAT}' type: 'Catalog' on-empty-output: 'continue' 15:28:25 [DEBUG] Returning cloned generic Command for idref: getCatalogs 15:28:25 [DEBUG] CommandId: getCatalogs 15:28:25 [DEBUG] DbConnection: MIS Dev 15:28:25 [DEBUG] Total rows/columns: 22/1. Rows after filtering: 22 15:28:25 [DEBUG] getting column 1 (java.lang.String) using getString() 15:28:25 [DEBUG] Total rows/columns: 22/1. Rows after filtering: 22 15:28:25 [DEBUG] CommandId: getSchemaNames 15:28:25 [DEBUG] DbConnection: MIS Dev 15:28:25 [DEBUG] elementName: 'GroupNode' label: 'Tables' type: 'Tables' on-empty-output: 'stop' 15:28:25 [DEBUG] elementName: 'GroupNode' label: 'System Tables' type: 'SystemTables' on-empty-output: 'stop' 15:28:25 [DEBUG] elementName: 'GroupNode' label: 'Views' type: 'Views' on-empty-output: 'stop' 15:28:25 [DEBUG] elementName: 'GroupNode' label: 'Users' type: 'Users' on-empty-output: 'stop' 15:28:25 [DEBUG] elementName: 'GroupNode' label: 'Groups' type: 'Groups' on-empty-output: 'stop' 15:28:25 [DEBUG] elementName: 'GroupNode' label: 'User Defined Data Types' type: 'Types' on-empty-output: 'stop' 15:28:25 [DEBUG] elementName: 'GroupNode' label: 'Triggers' type: 'Triggers' on-empty-output: 'stop' 15:28:25 [DEBUG] elementName: 'GroupNode' label: 'Stored Procedures' type: 'Procedures' on-empty-output: 'stop' 15:28:25 [DEBUG] getting column 1 (java.lang.String) using getString() 15:28:25 [DEBUG] Total rows/columns: 73/1. Rows after filtering: 73 15:28:25 [DEBUG] elementName: 'DataNode' label: '${sybase-ase.getObjects.owner}.${sybase-ase.getObjects.name}' type: 'Procedure' on-empty-output: 'stop' 15:28:25 [DEBUG] Returning cloned generic Command for idref: sybase-ase.getObjects 15:28:25 [DEBUG] CommandId: sybase-ase.getObjects sql: select owner = user_name(uid), name, crdate "Creation Date" from ${database}.dbo.sysobjects where type = '${type}' order by name 15:28:25 [DEBUG] Executing... 15:28:25 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis' 15:28:25 [DEBUG] RootConnection: SybConnection.createStatement() 15:28:25 [DEBUG] SQL: select owner = user_name(uid), name, crdate "Creation Date" from mis.dbo.sysobjects where type = 'P' order by name 15:28:25 [DEBUG] RootConnection: SybConnection.nativeSQL("select owner = user_name(uid), name, crdate "Creation Date" from mis.dbo.sysobjects where type = 'P' order by name") 15:28:25 [DEBUG] RootConnection: SybStatement.setEscapeProcessing(false) 15:28:25 [DEBUG] RootConnection: SybStatement.execute("select owner = user_name(uid), name, crdate "Creation Date" from mis.dbo.sysobjects where type = 'P' order by name") 15:28:25 [DEBUG] getting column 1 (java.lang.String) using getString() 15:28:25 [DEBUG] getting column 2 (java.lang.String) using getString() 15:28:25 [DEBUG] getting column 3 (java.sql.Timestamp) using getTimestamp() 15:28:25 [DEBUG] Total rows/columns: 1545/3. Rows after filtering: 1545 15:28:26 [DEBUG] Returning cloned generic Command for idref: getColumnNamesFor 15:28:26 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:28:26 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@43dcca] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1965ff3 15:28:26 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:28:26 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@5e2f1d] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@43dcca 15:28:32 [DEBUG] Creating new connection: DefaultEditor-0 for MIS Dev 15:28:32 [DEBUG] Connecting: MIS Dev 15:28:32 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:28:32 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1a0efa] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@5e2f1d 15:28:32 [DEBUG] DefaultEditor-0: SybConnection.setAutoCommit(true) 15:28:32 [DEBUG] Using facade: sybase-ase for MIS Dev 15:28:32 [DEBUG] Executing... 15:28:32 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis' 15:28:32 [DEBUG] DbConnection='MIS Dev' Catalog='null' Schema='dbo' NewSchema='dbo' 15:28:32 [DEBUG] DefaultEditor-0: SybConnection.createStatement() 15:28:32 [DEBUG] SQL: SELECT text FROM [mis].dbo.syscomments c , [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id('mis.dbo.GenordsHK_nav_ext') 15:28:32 [DEBUG] DefaultEditor-0: SybConnection.nativeSQL("SELECT text FROM [mis].dbo.syscomments c , [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')") 15:28:32 [DEBUG] DefaultEditor-0: SybStatement.setEscapeProcessing(false) 15:28:32 [DEBUG] DefaultEditor-0: SybStatement.execute("SELECT text FROM [mis].dbo.syscomments c , [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')") SQLState(42000) vendor code(102) 15:28:48 [DEBUG] remove DataView type: Tables from: ObjectView 15:28:48 [DEBUG] remove DataView type: References from: ObjectView 15:28:48 [DEBUG] remove DataView type: Tables from: ObjectView 15:28:48 [DEBUG] adding DataView type: Tables to: Tables at index: 1 15:28:48 [DEBUG] remove DataView type: References from: ObjectView 15:28:48 [DEBUG] adding DataView type: References to: Tables at index: 3 15:28:48 [DEBUG] adding DataView type: Source to: Table at index: -1 15:28:48 [DEBUG] adding DataView type: Trigger to: Table at index: -1 15:28:48 [DEBUG] adding ObjectView type: SystemTables 15:28:48 [DEBUG] adding ObjectView type: SystemTable 15:28:48 [DEBUG] adding ObjectView type: Views 15:28:48 [DEBUG] adding ObjectView type: View 15:28:48 [DEBUG] adding ObjectView type: Users 15:28:48 [DEBUG] adding ObjectView type: User 15:28:48 [DEBUG] adding ObjectView type: Groups 15:28:48 [DEBUG] adding ObjectView type: Group 15:28:48 [DEBUG] adding ObjectView type: Triggers 15:28:48 [DEBUG] adding ObjectView type: Trigger 15:28:48 [DEBUG] adding ObjectView type: Types 15:28:48 [DEBUG] remove DataView type: Procedures from: ObjectView 15:28:48 [DEBUG] adding DataView type: Procedures to: Procedures at index: 1 15:28:48 [DEBUG] remove DataView type: Columns from: ObjectView 15:28:48 [DEBUG] adding DataView type: SourceEditor to: Procedure at index: -1 15:28:48 [DEBUG] adding DataView type: Interface to: Procedure at index: -1 15:28:48 [DEBUG] adding ObjectView type: ServerInfo 15:28:48 [DEBUG] adding ObjectView type: Logins 15:28:48 [DEBUG] adding ObjectView type: Login 15:28:48 [DEBUG] adding ObjectView type: Devices 15:28:48 [DEBUG] adding ObjectView type: Device 15:28:48 [DEBUG] adding ObjectView type: RemoteServers 15:28:48 [DEBUG] adding ObjectView type: ServerRoles 15:28:48 [DEBUG] adding ObjectView type: ServerRole 15:28:48 [DEBUG] adding ObjectView type: Processes 15:28:48 [DEBUG] adding ObjectView type: Transactions 15:28:48 [DEBUG] adding ObjectView type: Locks 15:28:48 [DEBUG] Returning cloned generic Command for idref: getProcedureColumns 15:28:48 [DEBUG] Executing... 15:28:48 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis' 15:28:48 [DEBUG] RootConnection: SybConnection.prepareStatement("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ") 15:28:48 [DEBUG] index=[1] name=[qn] value=[dbo.GenordsHK_nav_ext] type=[String] options=[nullable ] 15:28:48 [DEBUG] setting column 1 (String) using setString() 15:28:48 [DEBUG] RootConnection: SybPreparedStatement.setString(1, "dbo.GenordsHK_nav_ext") 15:28:48 [DEBUG] SQL: SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) 15:28:48 [DEBUG] RootConnection: SybConnection.nativeSQL("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ") 15:28:48 [DEBUG] RootConnection: SybPreparedStatement.execute() com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['. at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.Z.B.B.invoke(Z:573) at $Proxy1.execute(Unknown Source) at com.onseven.dbvis.G.B.H.execute(Z:741) at com.onseven.dbvis.G.B.K.execute(Z:1175) at com.onseven.dbvis.G.B.V.run(Z:3245) at com.onseven.dbvis.G.B.C.?(Z:636) at com.onseven.dbvis.G.B.C.?(Z:1586) at com.onseven.dbvis.G.B.C.execute(Z:606) at com.onseven.dbvis.G.B.I.construct(Z:1013) at se.pureit.swing.util.SwingWorker$2.run(Z:1192) at java.lang.Thread.run(Unknown Source) SQLState(42000) vendor code(102) com.onseven.dbvis.G.B.L: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['. at com.onseven.dbvis.G.B.H.execute(Z:3362) at com.onseven.dbvis.G.B.V.run(Z:3245) at com.onseven.dbvis.S.A.A.?(Z:2122) at com.onseven.dbvis.S.A.A.?(Z:1382) at com.onseven.dbvis.S.A.A.?(Z:588) at com.onseven.dbvis.b.B.A.A.K.?(Z:2874) at com.onseven.dbvis.b.B.A.A.J.?(Z:1314) at com.onseven.dbvis.b.B.E.?(Z:3046) at com.onseven.dbvis.b.B.E.?(Z:3195) at com.onseven.dbvis.b.B.E.?(Z:759) at com.onseven.dbvis.b.B.E$1.ancestorAdded(Z:1320) at javax.swing.AncestorNotifier.fireAncestorAdded(Unknown Source) at javax.swing.AncestorNotifier.componentShown(Unknown Source) at java.awt.Component.processComponentEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at com.onseven.dbvis.J.A.g.dispatchEvent(Z:2143) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['. at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source) at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.Z.B.B.invoke(Z:573) at $Proxy2.execute(Unknown Source) at com.onseven.dbvis.G.B.H.execute(Z:2529) ... 26 more 15:28:51 [DEBUG] Executing... 15:28:51 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis' 15:28:51 [DEBUG] RootConnection: SybConnection.prepareStatement("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ") 15:28:51 [DEBUG] index=[1] name=[qn] value=[dbo.GenordsHK_ex_rate_ext] type=[String] options=[nullable ] 15:28:51 [DEBUG] setting column 1 (String) using setString() 15:28:51 [DEBUG] RootConnection: SybPreparedStatement.setString(1, "dbo.GenordsHK_ex_rate_ext") 15:28:51 [DEBUG] SQL: SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) 15:28:51 [DEBUG] RootConnection: SybConnection.nativeSQL("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ") 15:28:51 [DEBUG] RootConnection: SybPreparedStatement.execute() com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['. at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source) at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.Z.B.B.invoke(Z:573) at $Proxy2.execute(Unknown Source) at com.onseven.dbvis.G.B.H.execute(Z:2529) at com.onseven.dbvis.G.B.V.run(Z:3245) at com.onseven.dbvis.S.A.A.?(Z:2122) at com.onseven.dbvis.S.A.A.?(Z:1382) at com.onseven.dbvis.S.A.A.?(Z:588) at com.onseven.dbvis.b.B.A.A.K.?(Z:2874) at com.onseven.dbvis.b.B.A.A.J.?(Z:1314) at com.onseven.dbvis.b.B.E.?(Z:3046) at com.onseven.dbvis.b.B.E.?(Z:3195) at com.onseven.dbvis.b.B.E.?(Z:759) at com.onseven.dbvis.b.B.E$1.ancestorAdded(Z:1320) at javax.swing.AncestorNotifier.fireAncestorAdded(Unknown Source) at javax.swing.AncestorNotifier.componentShown(Unknown Source) at java.awt.Component.processComponentEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at com.onseven.dbvis.J.A.g.dispatchEvent(Z:2143) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) SQLState(42000) vendor code(102) com.onseven.dbvis.G.B.L: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['. at com.onseven.dbvis.G.B.H.execute(Z:3362) at com.onseven.dbvis.G.B.V.run(Z:3245) at com.onseven.dbvis.S.A.A.?(Z:2122) at com.onseven.dbvis.S.A.A.?(Z:1382) at com.onseven.dbvis.S.A.A.?(Z:588) at com.onseven.dbvis.b.B.A.A.K.?(Z:2874) at com.onseven.dbvis.b.B.A.A.J.?(Z:1314) at com.onseven.dbvis.b.B.E.?(Z:3046) at com.onseven.dbvis.b.B.E.?(Z:3195) at com.onseven.dbvis.b.B.E.?(Z:2269) at com.onseven.dbvis.b.B.K.?(Z:1734) at com.onseven.dbvis.b.B.K.?(Z:3426) at com.onseven.dbvis.b.A.E.?(Z:1157) at com.onseven.dbvis.b.A.E.?(Z:1475) at com.onseven.dbvis.b.A.E$44.valueChanged(Z:3466) at javax.swing.tree.DefaultTreeSelectionModel.fireValueChanged(Unknown Source) at javax.swing.tree.DefaultTreeSelectionModel.notifyPathChange(Unknown Source) at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPaths(Unknown Source) at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPath(Unknown Source) at javax.swing.JTree.setSelectionPath(Unknown Source) at javax.swing.plaf.basic.BasicTreeUI.selectPathForEvent(Unknown Source) at javax.swing.plaf.basic.BasicTreeUI$Handler.handleSelection(Unknown Source) at javax.swing.plaf.basic.BasicTreeUI$Handler.mousePressed(Unknown Source) at java.awt.AWTEventMulticaster.mousePressed(Unknown Source) at java.awt.AWTEventMulticaster.mousePressed(Unknown Source) at java.awt.AWTEventMulticaster.mousePressed(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at com.onseven.dbvis.J.A.g.dispatchEvent(Z:2143) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['. at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source) at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.Z.B.B.invoke(Z:573) at $Proxy2.execute(Unknown Source) at com.onseven.dbvis.G.B.H.execute(Z:2529) ... 46 more 15:29:59 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:29:59 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['. at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source) at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.Z.B.B.invoke(Z:573) at $Proxy2.execute(Unknown Source) at com.onseven.dbvis.G.B.H.execute(Z:2529) at com.onseven.dbvis.G.B.V.run(Z:3245) at com.onseven.dbvis.S.A.A.?(Z:2122) at com.onseven.dbvis.S.A.A.?(Z:1382) at com.onseven.dbvis.S.A.A.?(Z:588) at com.onseven.dbvis.b.B.A.A.K.?(Z:2874) at com.onseven.dbvis.b.B.A.A.J.?(Z:1314) at com.onseven.dbvis.b.B.E.?(Z:3046) at com.onseven.dbvis.b.B.E.?(Z:3195) at com.onseven.dbvis.b.B.E.?(Z:2269) at com.onseven.dbvis.b.B.K.?(Z:1734) at com.onseven.dbvis.b.B.K.?(Z:3426) at com.onseven.dbvis.b.A.E.?(Z:1157) at com.onseven.dbvis.b.A.E.?(Z:1475) at com.onseven.dbvis.b.A.E$44.valueChanged(Z:3466) at javax.swing.tree.DefaultTreeSelectionModel.fireValueChanged(Unknown Source) at javax.swing.tree.DefaultTreeSelectionModel.notifyPathChange(Unknown Source) at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPaths(Unknown Source) at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPath(Unknown Source) at javax.swing.JTree.setSelectionPath(Unknown Source) at javax.swing.plaf.basic.BasicTreeUI.selectPathForEvent(Unknown Source) at javax.swing.plaf.basic.BasicTreeUI$Handler.handleSelection(Unknown Source) at javax.swing.plaf.basic.BasicTreeUI$Handler.mousePressed(Unknown Source) at java.awt.AWTEventMulticaster.mousePressed(Unknown Source) at java.awt.AWTEventMulticaster.mousePressed(Unknown Source) at java.awt.AWTEventMulticaster.mousePressed(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at com.onseven.dbvis.J.A.g.dispatchEvent(Z:2143) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1f12964] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1a0efa 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1a99c51] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1f12964 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@55a870] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1a99c51 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1a590d5] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@55a870 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@c7bef4] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1a590d5 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1c9afa1] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@c7bef4 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@298fa4] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1c9afa1 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@956567] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@298fa4 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@345ce0] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@956567 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1bda87e] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@345ce0 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@811740] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1bda87e 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@11d6b02] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@811740 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@5c5e36] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@11d6b02 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@2d3fed] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@5c5e36 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@c005a0] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@2d3fed 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@b154fd] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@c005a0 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@42edff] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@b154fd 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1730b1] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@42edff 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@7df41c] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1730b1 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@12586a0] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@7df41c 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@a9a747] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@12586a0 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@254fb0] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@a9a747 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@192c588] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@254fb0 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@e67c1e] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@192c588 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1debd03] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@e67c1e 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@4b2882] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1debd03 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@5093e2] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@4b2882 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1cfa64] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@5093e2 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@7ac9a7] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1cfa64 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@14d0cd5] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@7ac9a7 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@18581f3] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@14d0cd5 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@16a983] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@18581f3 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1d2f333] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@16a983 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@5c9e4e] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1d2f333 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@9d509e] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@5c9e4e 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@17b97d] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@9d509e 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@192c5cc] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@17b97d 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@f7d6ef] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@192c5cc 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@14019b9] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@f7d6ef 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@158cda2] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@14019b9 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@124672b] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@158cda2 15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1cebfd2] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@124672b 15:30:10 [DEBUG] Freeing connection: DefaultEditor-0 for MIS Dev 15:30:10 [DEBUG] Disconnecting: MIS Dev 15:30:10 [DEBUG] RootConnection: SybConnection.close() 15:30:10 [DEBUG] Connection closed: MIS Dev 15:30:10 [DEBUG] Disconnecting: MIS Dev 15:30:10 [DEBUG] DefaultEditor-0: SybConnection.close() 15:30:10 [DEBUG] Connection closed: MIS Dev 15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@198b354] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1cebfd2 15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@3cec5e] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@198b354 15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@b58296] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@3cec5e 15:30:10 [DEBUG] Connecting: MIS Dev 15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@b06ac3] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@b58296 15:30:10 [DEBUG] RootConnection: SybConnection.setAutoCommit(true) 15:30:10 [DEBUG] Using facade: sybase-ase for MIS Dev 15:30:10 [DEBUG] RootConnection: SybConnection.createStatement() 15:30:10 [DEBUG] executing "set quoted_identifier off" 15:30:10 [DEBUG] RootConnection: SybStatement.execute("set quoted_identifier off") 15:30:11 [DEBUG] Loading profile /profiles/sybase-ase.xml 15:30:11 [DEBUG] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'" 15:30:11 [DEBUG] Using profile: sybase-ase 15:30:11 [DEBUG] Returning cloned generic Command for idref: getCatalogs 15:30:11 [DEBUG] CommandId: getCatalogs 15:30:11 [DEBUG] DbConnection: MIS Dev 15:30:11 [DEBUG] elementName: 'GroupNode' label: 'Databases' type: 'Databases' on-empty-output: 'stop' 15:30:11 [DEBUG] elementName: 'GroupNode' label: 'DBA Views' type: 'DBA' on-empty-output: 'stop' 15:30:11 [DEBUG] elementName: 'DataNode' label: '${getCatalogs.TABLE_CAT}' type: 'Catalog' on-empty-output: 'continue' 15:30:11 [DEBUG] Returning cloned generic Command for idref: getCatalogs 15:30:11 [DEBUG] CommandId: getCatalogs 15:30:11 [DEBUG] DbConnection: MIS Dev 15:30:11 [DEBUG] getting column 1 (java.lang.String) using getString() 15:30:11 [DEBUG] getting column 1 (java.lang.String) using getString() 15:30:11 [DEBUG] Total rows/columns: 22/1. Rows after filtering: 22 15:30:11 [DEBUG] elementName: 'GroupNode' label: 'Tables' type: 'Tables' on-empty-output: 'stop' 15:30:11 [DEBUG] elementName: 'GroupNode' label: 'System Tables' type: 'SystemTables' on-empty-output: 'stop' 15:30:11 [DEBUG] elementName: 'GroupNode' label: 'Views' type: 'Views' on-empty-output: 'stop' 15:30:11 [DEBUG] elementName: 'GroupNode' label: 'Users' type: 'Users' on-empty-output: 'stop' 15:30:11 [DEBUG] elementName: 'GroupNode' label: 'Groups' type: 'Groups' on-empty-output: 'stop' 15:30:11 [DEBUG] elementName: 'GroupNode' label: 'User Defined Data Types' type: 'Types' on-empty-output: 'stop' 15:30:11 [DEBUG] elementName: 'GroupNode' label: 'Triggers' type: 'Triggers' on-empty-output: 'stop' 15:30:11 [DEBUG] elementName: 'GroupNode' label: 'Stored Procedures' type: 'Procedures' on-empty-output: 'stop' 15:30:11 [DEBUG] Total rows/columns: 22/1. Rows after filtering: 22 15:30:11 [DEBUG] CommandId: getSchemaNames 15:30:11 [DEBUG] DbConnection: MIS Dev 15:30:11 [DEBUG] getting column 1 (java.lang.String) using getString() 15:30:11 [DEBUG] elementName: 'DataNode' label: '${sybase-ase.getObjects.owner}.${sybase-ase.getObjects.name}' type: 'Procedure' on-empty-output: 'stop' 15:30:11 [DEBUG] Returning cloned generic Command for idref: sybase-ase.getObjects 15:30:11 [DEBUG] CommandId: sybase-ase.getObjects sql: select owner = user_name(uid), name, crdate "Creation Date" from ${database}.dbo.sysobjects where type = '${type}' order by name 15:30:11 [DEBUG] Executing... 15:30:11 [DEBUG] Total rows/columns: 73/1. Rows after filtering: 73 15:30:11 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis' 15:30:11 [DEBUG] RootConnection: SybConnection.createStatement() 15:30:11 [DEBUG] SQL: select owner = user_name(uid), name, crdate "Creation Date" from mis.dbo.sysobjects where type = 'P' order by name 15:30:11 [DEBUG] RootConnection: SybConnection.nativeSQL("select owner = user_name(uid), name, crdate "Creation Date" from mis.dbo.sysobjects where type = 'P' order by name") 15:30:11 [DEBUG] RootConnection: SybStatement.setEscapeProcessing(false) 15:30:11 [DEBUG] RootConnection: SybStatement.execute("select owner = user_name(uid), name, crdate "Creation Date" from mis.dbo.sysobjects where type = 'P' order by name") 15:30:11 [DEBUG] getting column 1 (java.lang.String) using getString() 15:30:11 [DEBUG] getting column 2 (java.lang.String) using getString() 15:30:11 [DEBUG] getting column 3 (java.sql.Timestamp) using getTimestamp() 15:30:11 [DEBUG] Total rows/columns: 1545/3. Rows after filtering: 1545 15:30:11 [DEBUG] Returning cloned generic Command for idref: getColumnNamesFor 15:30:11 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:11 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@fa702] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@b06ac3 15:30:11 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:11 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1ab37bd] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@fa702 15:30:21 [DEBUG] Creating new connection: DefaultEditor-0 for MIS Dev 15:30:21 [DEBUG] Connecting: MIS Dev 15:30:21 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 15:30:21 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@b565d2] DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1ab37bd 15:30:21 [DEBUG] DefaultEditor-0: SybConnection.setAutoCommit(true) 15:30:21 [DEBUG] Using facade: sybase-ase for MIS Dev 15:30:21 [DEBUG] DefaultEditor-0: SybConnection.createStatement() 15:30:21 [DEBUG] executing "set quoted_identifier off" 15:30:21 [DEBUG] DefaultEditor-0: SybStatement.execute("set quoted_identifier off") 15:30:21 [DEBUG] Executing... 15:30:21 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis' 15:30:21 [DEBUG] DbConnection='MIS Dev' Catalog='null' Schema='dbo' NewSchema='dbo' 15:30:21 [DEBUG] DefaultEditor-0: SybConnection.createStatement() 15:30:21 [DEBUG] SQL: SELECT text FROM [mis].dbo.syscomments c , [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id('mis.dbo.GenordsHK_nav_ext') 15:30:21 [DEBUG] DefaultEditor-0: SybConnection.nativeSQL("SELECT text FROM [mis].dbo.syscomments c , [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')") 15:30:21 [DEBUG] DefaultEditor-0: SybStatement.setEscapeProcessing(false) 15:30:21 [DEBUG] DefaultEditor-0: SybStatement.execute("SELECT text FROM [mis].dbo.syscomments c , [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')") SQLState(42000) vendor code(102) 15:30:33 [DEBUG] Executing... 15:30:33 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis' 15:30:33 [DEBUG] DbConnection='MIS Dev' Catalog='null' Schema='dbo' NewSchema='dbo' 15:30:33 [DEBUG] DefaultEditor-0: SybConnection.createStatement() 15:30:33 [DEBUG] SQL: SELECT text FROM mis.dbo.syscomments c , mis.dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id('mis.dbo.GenordsHK_nav_ext') 15:30:33 [DEBUG] DefaultEditor-0: SybConnection.nativeSQL("SELECT text FROM mis.dbo.syscomments c , mis.dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')") 15:30:33 [DEBUG] DefaultEditor-0: SybStatement.setEscapeProcessing(false) 15:30:33 [DEBUG] DefaultEditor-0: SybStatement.execute("SELECT text FROM mis.dbo.syscomments c , mis.dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')") 15:30:33 [DEBUG] getting column 1 (java.lang.String) using getString() 15:30:33 [DEBUG] Edit not allowed: More then one table is referenced in the FROM clause 15:30:55 [DEBUG] Executing... 15:30:55 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis' 15:30:55 [DEBUG] DbConnection='MIS Dev' Catalog='null' Schema='dbo' NewSchema='dbo' 15:30:55 [DEBUG] DefaultEditor-0: SybConnection.createStatement() 15:30:55 [DEBUG] SQL: SELECT text FROM mis.dbo.syscomments c , mis.dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id('mis.dbo.GenordsHK_nav_ext') 15:30:55 [DEBUG] DefaultEditor-0: SybConnection.nativeSQL("SELECT text FROM mis.dbo.syscomments c , mis.dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')") 15:30:55 [DEBUG] DefaultEditor-0: SybStatement.setEscapeProcessing(false) 15:30:55 [DEBUG] DefaultEditor-0: SybStatement.execute("SELECT text FROM mis.dbo.syscomments c , mis.dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')") 15:30:55 [DEBUG] getting column 1 (java.lang.String) using getString() 15:30:55 [DEBUG] Edit not allowed: More then one table is referenced in the FROM clause

Hi Nick, From the logs it looks like you have a Connection Hook defined for this connection, executing this command when connecting: set quoted_identifier off That would explain the problem. Please remove that command from the Connection Hook and try again. Thanks, Hans

Hi Hans, I get the same problem even without the set quoted identifier connection hook. Regards, Nick ------------------------- Product Information ------------------------ Product: DbVisualizer Personal 6.5 Build: #1339 (2008/10/23 11:47) Java VM: Java HotSpot(TM) Client VM Java Version: 1.6.0_07 Java Vendor: Sun Microsystems Inc. OS Name: Windows XP OS Arch: x86 OS Version: 5.1 ------------------------- Connected Databases ------------------------ Database Type: Sybase ASE Major Version: -1 Minor Version: 5 Profile: sybase-ase Connection Message: Adaptive Server Enterprise Adaptive Server Enterprise/12.5.0.3/EBF 11337 ESD#3/P/HP9000-879/HP-UX 11.0/rel12503/1933/64-bit/FBO/Fri Aug 1 07:59:26 2003 jConnect (TM) for JDBC (TM) jConnect (TM) for JDBC(TM)/6.05(Build 25828)/P/EBF13044/JDK14/Fri Sep 30 1:05:16 2005 --------------------------- Debug Printouts -------------------------- 09:32:58 [DEBUG] Init Seconds: 15.232 09:33:15 [DEBUG] Loading profile /profiles/db2-zos.xml 09:33:15 [DEBUG] Loading profile /profiles/db2.xml 09:33:15 [DEBUG] Loading profile /profiles/derby.xml 09:33:15 [DEBUG] Loading profile /profiles/generic.xml 09:33:16 [DEBUG] Loading profile /profiles/informix.xml 09:33:16 [DEBUG] Loading profile /profiles/mimer.xml 09:33:16 [DEBUG] Loading profile /profiles/mysql.xml 09:33:16 [DEBUG] Loading profile /profiles/neoview.xml 09:33:17 [DEBUG] Loading profile /profiles/oracle.xml 09:33:17 [DEBUG] Loading profile /profiles/postgresql.xml 09:33:17 [DEBUG] Loading profile /profiles/postgresql8.xml 09:33:17 [DEBUG] Loading profile /profiles/sqlserver.xml 09:33:17 [DEBUG] Loading profile /profiles/sybase-ase.xml 09:33:18 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:18 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:23 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:23 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:23 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:23 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:43 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:43 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:43 [DEBUG] Connecting: MIS Dev 09:33:43 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:43 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:44 [DEBUG] RootConnection: SybConnection.setAutoCommit(true) 09:33:44 [DEBUG] Using facade: sybase-ase for MIS Dev 09:33:45 [DEBUG] Loading profile /profiles/sybase-ase.xml 09:33:45 [DEBUG] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'" 09:33:45 [DEBUG] Using profile: sybase-ase 09:33:45 [DEBUG] elementName: 'GroupNode' label: 'Databases' type: 'Databases' on-empty-output: 'stop' 09:33:45 [DEBUG] elementName: 'GroupNode' label: 'DBA Views' type: 'DBA' on-empty-output: 'stop' 09:33:45 [DEBUG] Returning cloned generic Command for idref: getColumnNamesFor 09:33:45 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:45 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 09:33:54 [DEBUG] elementName: 'DataNode' label: '${getCatalogs.TABLE_CAT}' type: 'Catalog' on-empty-output: 'continue' 09:33:54 [DEBUG] Returning cloned generic Command for idref: getCatalogs 09:33:54 [DEBUG] CommandId: getCatalogs 09:33:54 [DEBUG] DbConnection: MIS Dev 09:33:54 [DEBUG] Total rows/columns: 22/1. Rows after filtering: 22 09:33:56 [DEBUG] elementName: 'GroupNode' label: 'Tables' type: 'Tables' on-empty-output: 'stop' 09:33:56 [DEBUG] elementName: 'GroupNode' label: 'System Tables' type: 'SystemTables' on-empty-output: 'stop' 09:33:56 [DEBUG] elementName: 'GroupNode' label: 'Views' type: 'Views' on-empty-output: 'stop' 09:33:56 [DEBUG] elementName: 'GroupNode' label: 'Users' type: 'Users' on-empty-output: 'stop' 09:33:56 [DEBUG] elementName: 'GroupNode' label: 'Groups' type: 'Groups' on-empty-output: 'stop' 09:33:56 [DEBUG] elementName: 'GroupNode' label: 'User Defined Data Types' type: 'Types' on-empty-output: 'stop' 09:33:56 [DEBUG] elementName: 'GroupNode' label: 'Triggers' type: 'Triggers' on-empty-output: 'stop' 09:33:56 [DEBUG] elementName: 'GroupNode' label: 'Stored Procedures' type: 'Procedures' on-empty-output: 'stop' 09:33:59 [DEBUG] elementName: 'DataNode' label: '${sybase-ase.getObjects.owner}.${sybase-ase.getObjects.name}' type: 'Procedure' on-empty-output: 'stop' 09:33:59 [DEBUG] Returning cloned generic Command for idref: sybase-ase.getObjects 09:33:59 [DEBUG] CommandId: sybase-ase.getObjects sql: select owner = user_name(uid), name, crdate "Creation Date" from ${database}.dbo.sysobjects where type = '${type}' order by name 09:33:59 [DEBUG] Executing... 09:33:59 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis' 09:33:59 [DEBUG] RootConnection: SybConnection.createStatement() 09:33:59 [DEBUG] SQL: select owner = user_name(uid), name, crdate "Creation Date" from mis.dbo.sysobjects where type = 'P' order by name 09:33:59 [DEBUG] RootConnection: SybConnection.nativeSQL("select owner = user_name(uid), name, crdate "Creation Date" from mis.dbo.sysobjects where type = 'P' order by name") 09:33:59 [DEBUG] RootConnection: SybStatement.setEscapeProcessing(false) 09:33:59 [DEBUG] RootConnection: SybStatement.execute("select owner = user_name(uid), name, crdate "Creation Date" from mis.dbo.sysobjects where type = 'P' order by name") 09:33:59 [DEBUG] Total rows/columns: 1545/3. Rows after filtering: 1545 09:34:19 [DEBUG] remove DataView type: Tables from: ObjectView 09:34:19 [DEBUG] remove DataView type: References from: ObjectView 09:34:19 [DEBUG] remove DataView type: Tables from: ObjectView 09:34:19 [DEBUG] adding DataView type: Tables to: Tables at index: 1 09:34:19 [DEBUG] remove DataView type: References from: ObjectView 09:34:19 [DEBUG] adding DataView type: References to: Tables at index: 3 09:34:19 [DEBUG] adding DataView type: Source to: Table at index: -1 09:34:19 [DEBUG] adding DataView type: Trigger to: Table at index: -1 09:34:19 [DEBUG] adding ObjectView type: SystemTables 09:34:19 [DEBUG] adding ObjectView type: SystemTable 09:34:19 [DEBUG] adding ObjectView type: Views 09:34:19 [DEBUG] adding ObjectView type: View 09:34:19 [DEBUG] adding ObjectView type: Users 09:34:19 [DEBUG] adding ObjectView type: User 09:34:19 [DEBUG] adding ObjectView type: Groups 09:34:19 [DEBUG] adding ObjectView type: Group 09:34:19 [DEBUG] adding ObjectView type: Triggers 09:34:19 [DEBUG] adding ObjectView type: Trigger 09:34:19 [DEBUG] adding ObjectView type: Types 09:34:19 [DEBUG] remove DataView type: Procedures from: ObjectView 09:34:19 [DEBUG] adding DataView type: Procedures to: Procedures at index: 1 09:34:19 [DEBUG] remove DataView type: Columns from: ObjectView 09:34:19 [DEBUG] adding DataView type: SourceEditor to: Procedure at index: -1 09:34:19 [DEBUG] adding DataView type: Interface to: Procedure at index: -1 09:34:19 [DEBUG] adding ObjectView type: ServerInfo 09:34:19 [DEBUG] adding ObjectView type: Logins 09:34:19 [DEBUG] adding ObjectView type: Login 09:34:19 [DEBUG] adding ObjectView type: Devices 09:34:19 [DEBUG] adding ObjectView type: Device 09:34:19 [DEBUG] adding ObjectView type: RemoteServers 09:34:19 [DEBUG] adding ObjectView type: ServerRoles 09:34:19 [DEBUG] adding ObjectView type: ServerRole 09:34:19 [DEBUG] adding ObjectView type: Processes 09:34:19 [DEBUG] adding ObjectView type: Transactions 09:34:19 [DEBUG] adding ObjectView type: Locks 09:34:19 [DEBUG] Returning cloned generic Command for idref: getProcedureColumns 09:34:20 [DEBUG] Executing... 09:34:20 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis' 09:34:20 [DEBUG] RootConnection: SybConnection.prepareStatement("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ") 09:34:20 [DEBUG] index=[1] name=[qn] value=[dbo.GenordsLAEM_broker_off_ext] type=[String] options=[nullable ] 09:34:20 [DEBUG] RootConnection: SybPreparedStatement.setString(1, "dbo.GenordsLAEM_broker_off_ext") 09:34:20 [DEBUG] SQL: SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) 09:34:20 [DEBUG] RootConnection: SybConnection.nativeSQL("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ") 09:34:20 [DEBUG] RootConnection: SybPreparedStatement.execute() com.onseven.dbvis.G.B.L: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['. at com.onseven.dbvis.G.B.H.execute(Z:3362) at com.onseven.dbvis.G.B.V.run(Z:3245) at com.onseven.dbvis.S.A.A.?(Z:2122) at com.onseven.dbvis.S.A.A.?(Z:1382) at com.onseven.dbvis.S.A.A.?(Z:588) at com.onseven.dbvis.b.B.A.A.K.?(Z:2874) at com.onseven.dbvis.b.B.A.A.J.?(Z:1314) at com.onseven.dbvis.b.B.E.?(Z:3046) at com.onseven.dbvis.b.B.E.?(Z:3195) at com.onseven.dbvis.b.B.E.?(Z:759) at com.onseven.dbvis.b.B.E$1.ancestorAdded(Z:1320) at javax.swing.AncestorNotifier.fireAncestorAdded(Unknown Source) at javax.swing.AncestorNotifier.componentShown(Unknown Source) at java.awt.Component.processComponentEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at com.onseven.dbvis.J.A.g.dispatchEvent(Z:2143) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['. at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source) at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.Z.B.B.invoke(Z:573) at $Proxy2.execute(Unknown Source) at com.onseven.dbvis.G.B.H.execute(Z:2529) ... 26 more 09:35:41 [DEBUG] Executing... 09:35:41 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis' 09:35:41 [DEBUG] RootConnection: SybConnection.prepareStatement("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ") 09:35:41 [DEBUG] index=[1] name=[qn] value=[dbo.GenordsHK_security_ext] type=[String] options=[nullable ] 09:35:41 [DEBUG] RootConnection: SybPreparedStatement.setString(1, "dbo.GenordsHK_security_ext") 09:35:41 [DEBUG] SQL: SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) 09:35:41 [DEBUG] RootConnection: SybConnection.nativeSQL("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ") 09:35:41 [DEBUG] RootConnection: SybPreparedStatement.execute() com.onseven.dbvis.G.B.L: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['. at com.onseven.dbvis.G.B.H.execute(Z:3362) at com.onseven.dbvis.G.B.V.run(Z:3245) at com.onseven.dbvis.S.A.A.?(Z:2122) at com.onseven.dbvis.S.A.A.?(Z:1382) at com.onseven.dbvis.S.A.A.?(Z:588) at com.onseven.dbvis.b.B.A.A.K.?(Z:2874) at com.onseven.dbvis.b.B.A.A.J.?(Z:1314) at com.onseven.dbvis.b.B.E.?(Z:3046) at com.onseven.dbvis.b.B.E.?(Z:3195) at com.onseven.dbvis.b.B.E.?(Z:2269) at com.onseven.dbvis.b.B.K.?(Z:1734) at com.onseven.dbvis.b.B.K.?(Z:3426) at com.onseven.dbvis.b.A.E.?(Z:1157) at com.onseven.dbvis.b.A.E.?(Z:1475) at com.onseven.dbvis.b.A.E$44.valueChanged(Z:3466) at javax.swing.tree.DefaultTreeSelectionModel.fireValueChanged(Unknown Source) at javax.swing.tree.DefaultTreeSelectionModel.notifyPathChange(Unknown Source) at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPaths(Unknown Source) at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPath(Unknown Source) at javax.swing.JTree.setSelectionPath(Unknown Source) at javax.swing.plaf.basic.BasicTreeUI.selectPathForEvent(Unknown Source) at javax.swing.plaf.basic.BasicTreeUI$Handler.handleSelection(Unknown Source) at javax.swing.plaf.basic.BasicTreeUI$Handler.mousePressed(Unknown Source) at java.awt.AWTEventMulticaster.mousePressed(Unknown Source) at java.awt.AWTEventMulticaster.mousePressed(Unknown Source) at java.awt.AWTEventMulticaster.mousePressed(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at com.onseven.dbvis.J.A.g.dispatchEvent(Z:2143) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['. at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source) at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.Z.B.B.invoke(Z:573) at $Proxy2.execute(Unknown Source) at com.onseven.dbvis.G.B.H.execute(Z:2529) ... 46 more

Hi Nick, Looks like I made a mistake. Sybase uses double-quotes for quoted identifiers according to their documentation, and that is what the "set quoted_identifier" command controls. In some configurations/versions, however, square brackets ("[ ]") can be used instead (probably due to its shared origin with MS SQL Server). I'm unable to find any mention of this now, but these delimiters work in my test server (15.0.2) and apparently in some of the servers you connect to. Most likely there's a configuration parameter somewhere. Anyway, the main issue here is that DbVisualizer uses hardcoded square bracket delimiters in an internal query and it doesn't work in all configurations. This will be fixed in the next release.

Hi Nick, I believe I've found why square brackets works in some databases and not in others. Support for square brackets as identifier quotes was added in Sybase 12.5.1 to make it easier to migrate from MS SQL Server: http://www.ispirer.com/doc/sqlways38/Output/SQLWays-1-173.html The database you have a problem with is 12.5.0. Best Regards, Hans

Hi Hans, I think that you have got to the root of the problem. The databases where I have a problem are Sybase Adaptive Server Enterprise/12.5.0.3/EBF 11337 whereas the ones where it's fine are Sybase Adaptive Server Enterprise/12.5.3/EBF 12335. So I guess that until we upgrade the older version I'm just going to have to live with the problem. It would be good if you could make the change in the next version of dbVisualiser to remove the use of hardcoded square brackets in internal queries as you suggested though. Many thanks for all your help.

Hi Roger, It helped me. thanks much