Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: dbVisualiser 6.5 crashes when selecting Sybase stored procedure

This question is answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 10 - Pages: 1 - Last Post: Nov 27, 2008 2:18 PM Last Post By: sivaraman
Nick Gibbons

Posts: 5
Registered: 11/06/08
dbVisualiser 6.5 crashes when selecting Sybase stored procedure
Posted: Nov 6, 2008 5:52 PM
 
   thread.click_reply Reply


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
Hans Bergsten


Posts: 1,588
Registered: 10/11/06
Re: dbVisualiser 6.5 crashes when selecting Sybase stored procedure
Posted: Nov 7, 2008 12:19 AM    global.in_response_to.tooltip in response to: Nick Gibbons
 
   thread.click_reply Reply
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
[<database>].dbo.syscomments c ,
[<database>].dbo.sysobjects s
WHERE
s.id = c.id
AND s.type = 'P'
AND s.id = object_id('<schema>.<proc_name>')

with <database>, <schema> and <proc_name> replaced by the corresponding names for your test case.

Kind Regards,
Hans
Nick Gibbons

Posts: 5
Registered: 11/06/08
Re: dbVisualiser 6.5 crashes when selecting Sybase stored procedure
Posted: Nov 7, 2008 10:16 AM    global.in_response_to.tooltip in response to: Hans Bergsten
 
   thread.click_reply Reply
 global.attachment sp_text.txt (11.8 KB )
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

Nick Gibbons

Posts: 5
Registered: 11/06/08
Re: dbVisualiser 6.5 crashes when selecting Sybase stored procedure
Posted: Nov 7, 2008 4:34 PM    global.in_response_to.tooltip in response to: Nick Gibbons
 
   thread.click_reply Reply
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

Hans Bergsten


Posts: 1,588
Registered: 10/11/06
Re: dbVisualiser 6.5 crashes when selecting Sybase stored procedure
Posted: Nov 7, 2008 8:40 PM    global.in_response_to.tooltip in response to: Nick Gibbons
 
   thread.click_reply Reply
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
Nick Gibbons

Posts: 5
Registered: 11/06/08
Re: dbVisualiser 6.5 crashes when selecting Sybase stored procedure
Posted: Nov 10, 2008 10:38 AM    global.in_response_to.tooltip in response to: Hans Bergsten
 
   thread.click_reply Reply
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

Hans Bergsten


Posts: 1,588
Registered: 10/11/06
Re: dbVisualiser 6.5 crashes when selecting Sybase stored procedure
Posted: Nov 10, 2008 10:04 PM    global.in_response_to.tooltip in response to: Nick Gibbons
 
   thread.click_reply Reply
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.
Hans Bergsten


Posts: 1,588
Registered: 10/11/06
Re: dbVisualiser 6.5 crashes when selecting Sybase stored procedure
Posted: Nov 10, 2008 10:16 PM    global.in_response_to.tooltip in response to: Hans Bergsten
 
   thread.click_reply Reply
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
Nick Gibbons

Posts: 5
Registered: 11/06/08
Re: dbVisualiser 6.5 crashes when selecting Sybase stored procedure
Posted: Nov 11, 2008 10:46 AM    global.in_response_to.tooltip in response to: Hans Bergsten
 
   thread.click_reply Reply

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.

Roger Bjarevall


Posts: 5,173
Registered: 12/17/04
Re: dbVisualiser 6.5 crashes when selecting Sybase stored procedure
Posted: Nov 24, 2008 12:24 AM    global.in_response_to.tooltip in response to: Hans Bergsten
 
   thread.click_reply Reply
Hi,

Just to inform you that DbVisualizer 6.5.1 is now available with a fix for this issue.

Best Regards

Roger
sivaraman

Posts: 1
Registered: 11/27/08
Re: dbVisualiser 6.5 crashes when selecting Sybase stored procedure
Posted: Nov 27, 2008 2:18 PM    global.in_response_to.tooltip in response to: Roger Bjarevall
 
   thread.click_reply Reply
Hi Roger,

It helped me. thanks much


Point your RSS reader here for a feed of the latest messages in all forums