SupportSupport

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

Hans,

I've just realised that when I ran your suggested query I had removed the square brackets around the database name. If I run it with the [] then I get the following debug output. Sorry for the confusion.

---

Product Information

---

Product: DbVisualizer Personal 6.5
Build: #1339 (2008/10/23 11:47)
Java VM: Java HotSpot(TM) Client VM
Java Version: 1.6.0_07
Java Vendor: Sun Microsystems Inc.
OS Name: Windows XP
OS Arch: x86
OS Version: 5.1

---

Connected Databases

---

Database Type: Sybase ASE
Major Version: -1
Minor Version: 5
Profile: sybase-ase
Connection Message:
Adaptive Server Enterprise
Adaptive Server Enterprise/12.5.0.3/EBF 11337 ESD#3/P/HP9000-879/HP-UX 11.0/rel12503/1933/64-bit/FBO/Fri Aug 1 07:59:26 2003
jConnect (TM) for JDBC (TM)
jConnect (TM) for JDBC(TM)/6.05(Build 25828)/P/EBF13044/JDK14/Fri Sep 30 1:05:16 2005

---

Debug Printouts

---

[cleared]
]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@4a25ab
15:28:20 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:28:20 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@10004ad]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1ef330a
15:28:20 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:28:20 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@33150a]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@10004ad
15:28:20 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:28:20 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1aa4de2]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@33150a
15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@12343d4]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1aa4de2
15:28:25 [DEBUG] Freeing connection: DefaultEditor-0 for MIS Dev
15:28:25 [DEBUG] Disconnecting: MIS Dev
15:28:25 [DEBUG] DefaultEditor-0: SybConnection.close()
15:28:25 [DEBUG] Disconnecting: MIS Dev
15:28:25 [DEBUG] RootConnection: SybConnection.close()
15:28:25 [DEBUG] Connection closed: MIS Dev
15:28:25 [DEBUG] Connection closed: MIS Dev
15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@199405a]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@12343d4
15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@173b4ce]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@199405a
15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@457189]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@173b4ce
15:28:25 [DEBUG] Connecting: MIS Dev
15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:28:25 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1965ff3]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@457189
15:28:25 [DEBUG] RootConnection: SybConnection.setAutoCommit(true)
15:28:25 [DEBUG] Using facade: sybase-ase for MIS Dev
15:28:25 [DEBUG] Loading profile /profiles/sybase-ase.xml
15:28:25 [DEBUG] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'"
15:28:25 [DEBUG] Using profile: sybase-ase
15:28:25 [DEBUG] Returning cloned generic Command for idref: getCatalogs
15:28:25 [DEBUG] CommandId: getCatalogs
15:28:25 [DEBUG] DbConnection: MIS Dev
15:28:25 [DEBUG] elementName: 'GroupNode' label: 'Databases' type: 'Databases' on-empty-output: 'stop'
15:28:25 [DEBUG] elementName: 'GroupNode' label: 'DBA Views' type: 'DBA' on-empty-output: 'stop'
15:28:25 [DEBUG] getting column 1 (java.lang.String) using getString()
15:28:25 [DEBUG] elementName: 'DataNode' label: '${getCatalogs.TABLE_CAT}' type: 'Catalog' on-empty-output: 'continue'
15:28:25 [DEBUG] Returning cloned generic Command for idref: getCatalogs
15:28:25 [DEBUG] CommandId: getCatalogs
15:28:25 [DEBUG] DbConnection: MIS Dev
15:28:25 [DEBUG] Total rows/columns: 22/1. Rows after filtering: 22
15:28:25 [DEBUG] getting column 1 (java.lang.String) using getString()
15:28:25 [DEBUG] Total rows/columns: 22/1. Rows after filtering: 22
15:28:25 [DEBUG] CommandId: getSchemaNames
15:28:25 [DEBUG] DbConnection: MIS Dev
15:28:25 [DEBUG] elementName: 'GroupNode' label: 'Tables' type: 'Tables' on-empty-output: 'stop'
15:28:25 [DEBUG] elementName: 'GroupNode' label: 'System Tables' type: 'SystemTables' on-empty-output: 'stop'
15:28:25 [DEBUG] elementName: 'GroupNode' label: 'Views' type: 'Views' on-empty-output: 'stop'
15:28:25 [DEBUG] elementName: 'GroupNode' label: 'Users' type: 'Users' on-empty-output: 'stop'
15:28:25 [DEBUG] elementName: 'GroupNode' label: 'Groups' type: 'Groups' on-empty-output: 'stop'
15:28:25 [DEBUG] elementName: 'GroupNode' label: 'User Defined Data Types' type: 'Types' on-empty-output: 'stop'
15:28:25 [DEBUG] elementName: 'GroupNode' label: 'Triggers' type: 'Triggers' on-empty-output: 'stop'
15:28:25 [DEBUG] elementName: 'GroupNode' label: 'Stored Procedures' type: 'Procedures' on-empty-output: 'stop'
15:28:25 [DEBUG] getting column 1 (java.lang.String) using getString()
15:28:25 [DEBUG] Total rows/columns: 73/1. Rows after filtering: 73
15:28:25 [DEBUG] elementName: 'DataNode' label: '${sybase-ase.getObjects.owner}.${sybase-ase.getObjects.name}' type: 'Procedure' on-empty-output: 'stop'
15:28:25 [DEBUG] Returning cloned generic Command for idref: sybase-ase.getObjects
15:28:25 [DEBUG] CommandId: sybase-ase.getObjects sql: select owner = user_name(uid), name, crdate "Creation Date"
from ${database}.dbo.sysobjects where type = '${type}' order by name
15:28:25 [DEBUG] Executing...
15:28:25 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis'
15:28:25 [DEBUG] RootConnection: SybConnection.createStatement()
15:28:25 [DEBUG] SQL: select owner = user_name(uid), name, crdate "Creation Date"
from mis.dbo.sysobjects where type = 'P' order by name
15:28:25 [DEBUG] RootConnection: SybConnection.nativeSQL("select owner = user_name(uid), name, crdate "Creation Date"
from mis.dbo.sysobjects where type = 'P' order by name")
15:28:25 [DEBUG] RootConnection: SybStatement.setEscapeProcessing(false)
15:28:25 [DEBUG] RootConnection: SybStatement.execute("select owner = user_name(uid), name, crdate "Creation Date"
from mis.dbo.sysobjects where type = 'P' order by name")
15:28:25 [DEBUG] getting column 1 (java.lang.String) using getString()
15:28:25 [DEBUG] getting column 2 (java.lang.String) using getString()
15:28:25 [DEBUG] getting column 3 (java.sql.Timestamp) using getTimestamp()
15:28:25 [DEBUG] Total rows/columns: 1545/3. Rows after filtering: 1545
15:28:26 [DEBUG] Returning cloned generic Command for idref: getColumnNamesFor
15:28:26 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:28:26 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@43dcca]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1965ff3
15:28:26 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:28:26 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@5e2f1d]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@43dcca
15:28:32 [DEBUG] Creating new connection: DefaultEditor-0 for MIS Dev
15:28:32 [DEBUG] Connecting: MIS Dev
15:28:32 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:28:32 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1a0efa]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@5e2f1d
15:28:32 [DEBUG] DefaultEditor-0: SybConnection.setAutoCommit(true)
15:28:32 [DEBUG] Using facade: sybase-ase for MIS Dev
15:28:32 [DEBUG] Executing...
15:28:32 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis'
15:28:32 [DEBUG] DbConnection='MIS Dev' Catalog='null' Schema='dbo' NewSchema='dbo'
15:28:32 [DEBUG] DefaultEditor-0: SybConnection.createStatement()
15:28:32 [DEBUG] SQL: SELECT
text
FROM
[mis].dbo.syscomments c ,
[mis].dbo.sysobjects s
WHERE
s.id = c.id
AND s.type = 'P'
AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')
15:28:32 [DEBUG] DefaultEditor-0: SybConnection.nativeSQL("SELECT
text
FROM
[mis].dbo.syscomments c ,
[mis].dbo.sysobjects s
WHERE
s.id = c.id
AND s.type = 'P'
AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')")
15:28:32 [DEBUG] DefaultEditor-0: SybStatement.setEscapeProcessing(false)
15:28:32 [DEBUG] DefaultEditor-0: SybStatement.execute("SELECT
text
FROM
[mis].dbo.syscomments c ,
[mis].dbo.sysobjects s
WHERE
s.id = c.id
AND s.type = 'P'
AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')")
SQLState(42000) vendor code(102)
15:28:48 [DEBUG] remove DataView type: Tables from: ObjectView
15:28:48 [DEBUG] remove DataView type: References from: ObjectView
15:28:48 [DEBUG] remove DataView type: Tables from: ObjectView
15:28:48 [DEBUG] adding DataView type: Tables to: Tables at index: 1
15:28:48 [DEBUG] remove DataView type: References from: ObjectView
15:28:48 [DEBUG] adding DataView type: References to: Tables at index: 3
15:28:48 [DEBUG] adding DataView type: Source to: Table at index: -1
15:28:48 [DEBUG] adding DataView type: Trigger to: Table at index: -1
15:28:48 [DEBUG] adding ObjectView type: SystemTables
15:28:48 [DEBUG] adding ObjectView type: SystemTable
15:28:48 [DEBUG] adding ObjectView type: Views
15:28:48 [DEBUG] adding ObjectView type: View
15:28:48 [DEBUG] adding ObjectView type: Users
15:28:48 [DEBUG] adding ObjectView type: User
15:28:48 [DEBUG] adding ObjectView type: Groups
15:28:48 [DEBUG] adding ObjectView type: Group
15:28:48 [DEBUG] adding ObjectView type: Triggers
15:28:48 [DEBUG] adding ObjectView type: Trigger
15:28:48 [DEBUG] adding ObjectView type: Types
15:28:48 [DEBUG] remove DataView type: Procedures from: ObjectView
15:28:48 [DEBUG] adding DataView type: Procedures to: Procedures at index: 1
15:28:48 [DEBUG] remove DataView type: Columns from: ObjectView
15:28:48 [DEBUG] adding DataView type: SourceEditor to: Procedure at index: -1
15:28:48 [DEBUG] adding DataView type: Interface to: Procedure at index: -1
15:28:48 [DEBUG] adding ObjectView type: ServerInfo
15:28:48 [DEBUG] adding ObjectView type: Logins
15:28:48 [DEBUG] adding ObjectView type: Login
15:28:48 [DEBUG] adding ObjectView type: Devices
15:28:48 [DEBUG] adding ObjectView type: Device
15:28:48 [DEBUG] adding ObjectView type: RemoteServers
15:28:48 [DEBUG] adding ObjectView type: ServerRoles
15:28:48 [DEBUG] adding ObjectView type: ServerRole
15:28:48 [DEBUG] adding ObjectView type: Processes
15:28:48 [DEBUG] adding ObjectView type: Transactions
15:28:48 [DEBUG] adding ObjectView type: Locks
15:28:48 [DEBUG] Returning cloned generic Command for idref: getProcedureColumns
15:28:48 [DEBUG] Executing...
15:28:48 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis'
15:28:48 [DEBUG] RootConnection: SybConnection.prepareStatement("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ")
15:28:48 [DEBUG] index=[1] name=[qn] value=[dbo.GenordsHK_nav_ext] type=[String] options=[nullable ]
15:28:48 [DEBUG] setting column 1 (String) using setString()
15:28:48 [DEBUG] RootConnection: SybPreparedStatement.setString(1, "dbo.GenordsHK_nav_ext")
15:28:48 [DEBUG] SQL: SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?)
15:28:48 [DEBUG] RootConnection: SybConnection.nativeSQL("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ")
15:28:48 [DEBUG] RootConnection: SybPreparedStatement.execute()
com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['.

at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.onseven.dbvis.Z.B.B.invoke(Z:573)
at $Proxy1.execute(Unknown Source)
at com.onseven.dbvis.G.B.H.execute(Z:741)
at com.onseven.dbvis.G.B.K.execute(Z:1175)
at com.onseven.dbvis.G.B.V.run(Z:3245)
at com.onseven.dbvis.G.B.C.?(Z:636)
at com.onseven.dbvis.G.B.C.?(Z:1586)
at com.onseven.dbvis.G.B.C.execute(Z:606)
at com.onseven.dbvis.G.B.I.construct(Z:1013)
at se.pureit.swing.util.SwingWorker$2.run(Z:1192)
at java.lang.Thread.run(Unknown Source)
SQLState(42000) vendor code(102)
com.onseven.dbvis.G.B.L: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['.

at com.onseven.dbvis.G.B.H.execute(Z:3362)
at com.onseven.dbvis.G.B.V.run(Z:3245)
at com.onseven.dbvis.S.A.A.?(Z:2122)
at com.onseven.dbvis.S.A.A.?(Z:1382)
at com.onseven.dbvis.S.A.A.?(Z:588)
at com.onseven.dbvis.b.B.A.A.K.?(Z:2874)
at com.onseven.dbvis.b.B.A.A.J.?(Z:1314)
at com.onseven.dbvis.b.B.E.?(Z:3046)
at com.onseven.dbvis.b.B.E.?(Z:3195)
at com.onseven.dbvis.b.B.E.?(Z:759)
at com.onseven.dbvis.b.B.E$1.ancestorAdded(Z:1320)
at javax.swing.AncestorNotifier.fireAncestorAdded(Unknown Source)
at javax.swing.AncestorNotifier.componentShown(Unknown Source)
at java.awt.Component.processComponentEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at com.onseven.dbvis.J.A.g.dispatchEvent(Z:2143)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['.

at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.onseven.dbvis.Z.B.B.invoke(Z:573)
at $Proxy2.execute(Unknown Source)
at com.onseven.dbvis.G.B.H.execute(Z:2529)
... 26 more
15:28:51 [DEBUG] Executing...
15:28:51 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis'
15:28:51 [DEBUG] RootConnection: SybConnection.prepareStatement("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ")
15:28:51 [DEBUG] index=[1] name=[qn] value=[dbo.GenordsHK_ex_rate_ext] type=[String] options=[nullable ]
15:28:51 [DEBUG] setting column 1 (String) using setString()
15:28:51 [DEBUG] RootConnection: SybPreparedStatement.setString(1, "dbo.GenordsHK_ex_rate_ext")
15:28:51 [DEBUG] SQL: SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?)
15:28:51 [DEBUG] RootConnection: SybConnection.nativeSQL("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ")
15:28:51 [DEBUG] RootConnection: SybPreparedStatement.execute()
com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['.

at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.onseven.dbvis.Z.B.B.invoke(Z:573)
at $Proxy2.execute(Unknown Source)
at com.onseven.dbvis.G.B.H.execute(Z:2529)
at com.onseven.dbvis.G.B.V.run(Z:3245)
at com.onseven.dbvis.S.A.A.?(Z:2122)
at com.onseven.dbvis.S.A.A.?(Z:1382)
at com.onseven.dbvis.S.A.A.?(Z:588)
at com.onseven.dbvis.b.B.A.A.K.?(Z:2874)
at com.onseven.dbvis.b.B.A.A.J.?(Z:1314)
at com.onseven.dbvis.b.B.E.?(Z:3046)
at com.onseven.dbvis.b.B.E.?(Z:3195)
at com.onseven.dbvis.b.B.E.?(Z:759)
at com.onseven.dbvis.b.B.E$1.ancestorAdded(Z:1320)
at javax.swing.AncestorNotifier.fireAncestorAdded(Unknown Source)
at javax.swing.AncestorNotifier.componentShown(Unknown Source)
at java.awt.Component.processComponentEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at com.onseven.dbvis.J.A.g.dispatchEvent(Z:2143)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
SQLState(42000) vendor code(102)
com.onseven.dbvis.G.B.L: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['.

at com.onseven.dbvis.G.B.H.execute(Z:3362)
at com.onseven.dbvis.G.B.V.run(Z:3245)
at com.onseven.dbvis.S.A.A.?(Z:2122)
at com.onseven.dbvis.S.A.A.?(Z:1382)
at com.onseven.dbvis.S.A.A.?(Z:588)
at com.onseven.dbvis.b.B.A.A.K.?(Z:2874)
at com.onseven.dbvis.b.B.A.A.J.?(Z:1314)
at com.onseven.dbvis.b.B.E.?(Z:3046)
at com.onseven.dbvis.b.B.E.?(Z:3195)
at com.onseven.dbvis.b.B.E.?(Z:2269)
at com.onseven.dbvis.b.B.K.?(Z:1734)
at com.onseven.dbvis.b.B.K.?(Z:3426)
at com.onseven.dbvis.b.A.E.?(Z:1157)
at com.onseven.dbvis.b.A.E.?(Z:1475)
at com.onseven.dbvis.b.A.E$44.valueChanged(Z:3466)
at javax.swing.tree.DefaultTreeSelectionModel.fireValueChanged(Unknown Source)
at javax.swing.tree.DefaultTreeSelectionModel.notifyPathChange(Unknown Source)
at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPaths(Unknown Source)
at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPath(Unknown Source)
at javax.swing.JTree.setSelectionPath(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI.selectPathForEvent(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI$Handler.handleSelection(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI$Handler.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at com.onseven.dbvis.J.A.g.dispatchEvent(Z:2143)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['.

at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.onseven.dbvis.Z.B.B.invoke(Z:573)
at $Proxy2.execute(Unknown Source)
at com.onseven.dbvis.G.B.H.execute(Z:2529)
... 46 more
15:29:59 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:29:59 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['.

at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.onseven.dbvis.Z.B.B.invoke(Z:573)
at $Proxy2.execute(Unknown Source)
at com.onseven.dbvis.G.B.H.execute(Z:2529)
at com.onseven.dbvis.G.B.V.run(Z:3245)
at com.onseven.dbvis.S.A.A.?(Z:2122)
at com.onseven.dbvis.S.A.A.?(Z:1382)
at com.onseven.dbvis.S.A.A.?(Z:588)
at com.onseven.dbvis.b.B.A.A.K.?(Z:2874)
at com.onseven.dbvis.b.B.A.A.J.?(Z:1314)
at com.onseven.dbvis.b.B.E.?(Z:3046)
at com.onseven.dbvis.b.B.E.?(Z:3195)
at com.onseven.dbvis.b.B.E.?(Z:2269)
at com.onseven.dbvis.b.B.K.?(Z:1734)
at com.onseven.dbvis.b.B.K.?(Z:3426)
at com.onseven.dbvis.b.A.E.?(Z:1157)
at com.onseven.dbvis.b.A.E.?(Z:1475)
at com.onseven.dbvis.b.A.E$44.valueChanged(Z:3466)
at javax.swing.tree.DefaultTreeSelectionModel.fireValueChanged(Unknown Source)
at javax.swing.tree.DefaultTreeSelectionModel.notifyPathChange(Unknown Source)
at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPaths(Unknown Source)
at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPath(Unknown Source)
at javax.swing.JTree.setSelectionPath(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI.selectPathForEvent(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI$Handler.handleSelection(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI$Handler.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at com.onseven.dbvis.J.A.g.dispatchEvent(Z:2143)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1f12964]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1a0efa
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1a99c51]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1f12964
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@55a870]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1a99c51
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1a590d5]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@55a870
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@c7bef4]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1a590d5
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1c9afa1]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@c7bef4
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@298fa4]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1c9afa1
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@956567]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@298fa4
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@345ce0]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@956567
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1bda87e]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@345ce0
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@811740]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1bda87e
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@11d6b02]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@811740
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@5c5e36]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@11d6b02
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@2d3fed]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@5c5e36
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@c005a0]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@2d3fed
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@b154fd]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@c005a0
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@42edff]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@b154fd
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1730b1]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@42edff
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@7df41c]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1730b1
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@12586a0]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@7df41c
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@a9a747]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@12586a0
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@254fb0]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@a9a747
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@192c588]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@254fb0
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@e67c1e]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@192c588
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1debd03]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@e67c1e
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@4b2882]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1debd03
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@5093e2]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@4b2882
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1cfa64]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@5093e2
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@7ac9a7]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1cfa64
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@14d0cd5]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@7ac9a7
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@18581f3]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@14d0cd5
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@16a983]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@18581f3
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1d2f333]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@16a983
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@5c9e4e]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1d2f333
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@9d509e]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@5c9e4e
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@17b97d]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@9d509e
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@192c5cc]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@17b97d
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@f7d6ef]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@192c5cc
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@14019b9]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@f7d6ef
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@158cda2]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@14019b9
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:04 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@124672b]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@158cda2
15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1cebfd2]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@124672b
15:30:10 [DEBUG] Freeing connection: DefaultEditor-0 for MIS Dev
15:30:10 [DEBUG] Disconnecting: MIS Dev
15:30:10 [DEBUG] RootConnection: SybConnection.close()
15:30:10 [DEBUG] Connection closed: MIS Dev
15:30:10 [DEBUG] Disconnecting: MIS Dev
15:30:10 [DEBUG] DefaultEditor-0: SybConnection.close()
15:30:10 [DEBUG] Connection closed: MIS Dev
15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@198b354]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1cebfd2
15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@3cec5e]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@198b354
15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@b58296]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@3cec5e
15:30:10 [DEBUG] Connecting: MIS Dev
15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:10 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@b06ac3]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@b58296
15:30:10 [DEBUG] RootConnection: SybConnection.setAutoCommit(true)
15:30:10 [DEBUG] Using facade: sybase-ase for MIS Dev
15:30:10 [DEBUG] RootConnection: SybConnection.createStatement()
15:30:10 [DEBUG] executing "set quoted_identifier off"
15:30:10 [DEBUG] RootConnection: SybStatement.execute("set quoted_identifier off")
15:30:11 [DEBUG] Loading profile /profiles/sybase-ase.xml
15:30:11 [DEBUG] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'"
15:30:11 [DEBUG] Using profile: sybase-ase
15:30:11 [DEBUG] Returning cloned generic Command for idref: getCatalogs
15:30:11 [DEBUG] CommandId: getCatalogs
15:30:11 [DEBUG] DbConnection: MIS Dev
15:30:11 [DEBUG] elementName: 'GroupNode' label: 'Databases' type: 'Databases' on-empty-output: 'stop'
15:30:11 [DEBUG] elementName: 'GroupNode' label: 'DBA Views' type: 'DBA' on-empty-output: 'stop'
15:30:11 [DEBUG] elementName: 'DataNode' label: '${getCatalogs.TABLE_CAT}' type: 'Catalog' on-empty-output: 'continue'
15:30:11 [DEBUG] Returning cloned generic Command for idref: getCatalogs
15:30:11 [DEBUG] CommandId: getCatalogs
15:30:11 [DEBUG] DbConnection: MIS Dev
15:30:11 [DEBUG] getting column 1 (java.lang.String) using getString()
15:30:11 [DEBUG] getting column 1 (java.lang.String) using getString()
15:30:11 [DEBUG] Total rows/columns: 22/1. Rows after filtering: 22
15:30:11 [DEBUG] elementName: 'GroupNode' label: 'Tables' type: 'Tables' on-empty-output: 'stop'
15:30:11 [DEBUG] elementName: 'GroupNode' label: 'System Tables' type: 'SystemTables' on-empty-output: 'stop'
15:30:11 [DEBUG] elementName: 'GroupNode' label: 'Views' type: 'Views' on-empty-output: 'stop'
15:30:11 [DEBUG] elementName: 'GroupNode' label: 'Users' type: 'Users' on-empty-output: 'stop'
15:30:11 [DEBUG] elementName: 'GroupNode' label: 'Groups' type: 'Groups' on-empty-output: 'stop'
15:30:11 [DEBUG] elementName: 'GroupNode' label: 'User Defined Data Types' type: 'Types' on-empty-output: 'stop'
15:30:11 [DEBUG] elementName: 'GroupNode' label: 'Triggers' type: 'Triggers' on-empty-output: 'stop'
15:30:11 [DEBUG] elementName: 'GroupNode' label: 'Stored Procedures' type: 'Procedures' on-empty-output: 'stop'
15:30:11 [DEBUG] Total rows/columns: 22/1. Rows after filtering: 22
15:30:11 [DEBUG] CommandId: getSchemaNames
15:30:11 [DEBUG] DbConnection: MIS Dev
15:30:11 [DEBUG] getting column 1 (java.lang.String) using getString()
15:30:11 [DEBUG] elementName: 'DataNode' label: '${sybase-ase.getObjects.owner}.${sybase-ase.getObjects.name}' type: 'Procedure' on-empty-output: 'stop'
15:30:11 [DEBUG] Returning cloned generic Command for idref: sybase-ase.getObjects
15:30:11 [DEBUG] CommandId: sybase-ase.getObjects sql: select owner = user_name(uid), name, crdate "Creation Date"
from ${database}.dbo.sysobjects where type = '${type}' order by name
15:30:11 [DEBUG] Executing...
15:30:11 [DEBUG] Total rows/columns: 73/1. Rows after filtering: 73
15:30:11 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis'
15:30:11 [DEBUG] RootConnection: SybConnection.createStatement()
15:30:11 [DEBUG] SQL: select owner = user_name(uid), name, crdate "Creation Date"
from mis.dbo.sysobjects where type = 'P' order by name
15:30:11 [DEBUG] RootConnection: SybConnection.nativeSQL("select owner = user_name(uid), name, crdate "Creation Date"
from mis.dbo.sysobjects where type = 'P' order by name")
15:30:11 [DEBUG] RootConnection: SybStatement.setEscapeProcessing(false)
15:30:11 [DEBUG] RootConnection: SybStatement.execute("select owner = user_name(uid), name, crdate "Creation Date"
from mis.dbo.sysobjects where type = 'P' order by name")
15:30:11 [DEBUG] getting column 1 (java.lang.String) using getString()
15:30:11 [DEBUG] getting column 2 (java.lang.String) using getString()
15:30:11 [DEBUG] getting column 3 (java.sql.Timestamp) using getTimestamp()
15:30:11 [DEBUG] Total rows/columns: 1545/3. Rows after filtering: 1545
15:30:11 [DEBUG] Returning cloned generic Command for idref: getColumnNamesFor
15:30:11 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:11 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@fa702]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@b06ac3
15:30:11 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:11 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@1ab37bd]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@fa702
15:30:21 [DEBUG] Creating new connection: DefaultEditor-0 for MIS Dev
15:30:21 [DEBUG] Connecting: MIS Dev
15:30:21 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
15:30:21 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
registerDriver: driver[className=com.sybase.jdbc3.jdbc.SybDriver,com.sybase.jdbc3.jdbc.SybDrive r@b565d2]
DriverManager.deregisterDriver: com.sybase.jdbc3.jdbc.SybDriver@1ab37bd
15:30:21 [DEBUG] DefaultEditor-0: SybConnection.setAutoCommit(true)
15:30:21 [DEBUG] Using facade: sybase-ase for MIS Dev
15:30:21 [DEBUG] DefaultEditor-0: SybConnection.createStatement()
15:30:21 [DEBUG] executing "set quoted_identifier off"
15:30:21 [DEBUG] DefaultEditor-0: SybStatement.execute("set quoted_identifier off")
15:30:21 [DEBUG] Executing...
15:30:21 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis'
15:30:21 [DEBUG] DbConnection='MIS Dev' Catalog='null' Schema='dbo' NewSchema='dbo'
15:30:21 [DEBUG] DefaultEditor-0: SybConnection.createStatement()
15:30:21 [DEBUG] SQL: SELECT
text
FROM
[mis].dbo.syscomments c ,
[mis].dbo.sysobjects s
WHERE
s.id = c.id
AND s.type = 'P'
AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')
15:30:21 [DEBUG] DefaultEditor-0: SybConnection.nativeSQL("SELECT
text
FROM
[mis].dbo.syscomments c ,
[mis].dbo.sysobjects s
WHERE
s.id = c.id
AND s.type = 'P'
AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')")
15:30:21 [DEBUG] DefaultEditor-0: SybStatement.setEscapeProcessing(false)
15:30:21 [DEBUG] DefaultEditor-0: SybStatement.execute("SELECT
text
FROM
[mis].dbo.syscomments c ,
[mis].dbo.sysobjects s
WHERE
s.id = c.id
AND s.type = 'P'
AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')")
SQLState(42000) vendor code(102)
15:30:33 [DEBUG] Executing...
15:30:33 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis'
15:30:33 [DEBUG] DbConnection='MIS Dev' Catalog='null' Schema='dbo' NewSchema='dbo'
15:30:33 [DEBUG] DefaultEditor-0: SybConnection.createStatement()
15:30:33 [DEBUG] SQL: SELECT
text
FROM
mis.dbo.syscomments c ,
mis.dbo.sysobjects s
WHERE
s.id = c.id
AND s.type = 'P'
AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')
15:30:33 [DEBUG] DefaultEditor-0: SybConnection.nativeSQL("SELECT
text
FROM
mis.dbo.syscomments c ,
mis.dbo.sysobjects s
WHERE
s.id = c.id
AND s.type = 'P'
AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')")
15:30:33 [DEBUG] DefaultEditor-0: SybStatement.setEscapeProcessing(false)
15:30:33 [DEBUG] DefaultEditor-0: SybStatement.execute("SELECT
text
FROM
mis.dbo.syscomments c ,
mis.dbo.sysobjects s
WHERE
s.id = c.id
AND s.type = 'P'
AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')")
15:30:33 [DEBUG] getting column 1 (java.lang.String) using getString()
15:30:33 [DEBUG] Edit not allowed: More then one table is referenced in the FROM clause
15:30:55 [DEBUG] Executing...
15:30:55 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis'
15:30:55 [DEBUG] DbConnection='MIS Dev' Catalog='null' Schema='dbo' NewSchema='dbo'
15:30:55 [DEBUG] DefaultEditor-0: SybConnection.createStatement()
15:30:55 [DEBUG] SQL: SELECT
text
FROM
mis.dbo.syscomments c ,
mis.dbo.sysobjects s
WHERE
s.id = c.id
AND s.type = 'P'
AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')
15:30:55 [DEBUG] DefaultEditor-0: SybConnection.nativeSQL("SELECT
text
FROM
mis.dbo.syscomments c ,
mis.dbo.sysobjects s
WHERE
s.id = c.id
AND s.type = 'P'
AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')")
15:30:55 [DEBUG] DefaultEditor-0: SybStatement.setEscapeProcessing(false)
15:30:55 [DEBUG] DefaultEditor-0: SybStatement.execute("SELECT
text
FROM
mis.dbo.syscomments c ,
mis.dbo.sysobjects s
WHERE
s.id = c.id
AND s.type = 'P'
AND s.id = object_id('mis.dbo.GenordsHK_nav_ext')")
15:30:55 [DEBUG] getting column 1 (java.lang.String) using getString()
15:30:55 [DEBUG] Edit not allowed: More then one table is referenced in the FROM clause

Hi Hans,

I get the same problem even without the set quoted identifier connection hook.

Regards,

Nick

---

Product Information

---

Product: DbVisualizer Personal 6.5
Build: #1339 (2008/10/23 11:47)
Java VM: Java HotSpot(TM) Client VM
Java Version: 1.6.0_07
Java Vendor: Sun Microsystems Inc.
OS Name: Windows XP
OS Arch: x86
OS Version: 5.1

---

Connected Databases

---

Database Type: Sybase ASE
Major Version: -1
Minor Version: 5
Profile: sybase-ase
Connection Message:
Adaptive Server Enterprise
Adaptive Server Enterprise/12.5.0.3/EBF 11337 ESD#3/P/HP9000-879/HP-UX 11.0/rel12503/1933/64-bit/FBO/Fri Aug 1 07:59:26 2003
jConnect (TM) for JDBC (TM)
jConnect (TM) for JDBC(TM)/6.05(Build 25828)/P/EBF13044/JDK14/Fri Sep 30 1:05:16 2005

---

Debug Printouts

---

09:32:58 [DEBUG] Init Seconds: 15.232
09:33:15 [DEBUG] Loading profile /profiles/db2-zos.xml
09:33:15 [DEBUG] Loading profile /profiles/db2.xml
09:33:15 [DEBUG] Loading profile /profiles/derby.xml
09:33:15 [DEBUG] Loading profile /profiles/generic.xml
09:33:16 [DEBUG] Loading profile /profiles/informix.xml
09:33:16 [DEBUG] Loading profile /profiles/mimer.xml
09:33:16 [DEBUG] Loading profile /profiles/mysql.xml
09:33:16 [DEBUG] Loading profile /profiles/neoview.xml
09:33:17 [DEBUG] Loading profile /profiles/oracle.xml
09:33:17 [DEBUG] Loading profile /profiles/postgresql.xml
09:33:17 [DEBUG] Loading profile /profiles/postgresql8.xml
09:33:17 [DEBUG] Loading profile /profiles/sqlserver.xml
09:33:17 [DEBUG] Loading profile /profiles/sybase-ase.xml
09:33:18 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:18 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:23 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:23 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:23 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:23 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:40 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:43 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:43 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:43 [DEBUG] Connecting: MIS Dev
09:33:43 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:43 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:44 [DEBUG] RootConnection: SybConnection.setAutoCommit(true)
09:33:44 [DEBUG] Using facade: sybase-ase for MIS Dev
09:33:45 [DEBUG] Loading profile /profiles/sybase-ase.xml
09:33:45 [DEBUG] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'"
09:33:45 [DEBUG] Using profile: sybase-ase
09:33:45 [DEBUG] elementName: 'GroupNode' label: 'Databases' type: 'Databases' on-empty-output: 'stop'
09:33:45 [DEBUG] elementName: 'GroupNode' label: 'DBA Views' type: 'DBA' on-empty-output: 'stop'
09:33:45 [DEBUG] Returning cloned generic Command for idref: getColumnNamesFor
09:33:45 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:45 [DEBUG] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver
09:33:54 [DEBUG] elementName: 'DataNode' label: '${getCatalogs.TABLE_CAT}' type: 'Catalog' on-empty-output: 'continue'
09:33:54 [DEBUG] Returning cloned generic Command for idref: getCatalogs
09:33:54 [DEBUG] CommandId: getCatalogs
09:33:54 [DEBUG] DbConnection: MIS Dev
09:33:54 [DEBUG] Total rows/columns: 22/1. Rows after filtering: 22
09:33:56 [DEBUG] elementName: 'GroupNode' label: 'Tables' type: 'Tables' on-empty-output: 'stop'
09:33:56 [DEBUG] elementName: 'GroupNode' label: 'System Tables' type: 'SystemTables' on-empty-output: 'stop'
09:33:56 [DEBUG] elementName: 'GroupNode' label: 'Views' type: 'Views' on-empty-output: 'stop'
09:33:56 [DEBUG] elementName: 'GroupNode' label: 'Users' type: 'Users' on-empty-output: 'stop'
09:33:56 [DEBUG] elementName: 'GroupNode' label: 'Groups' type: 'Groups' on-empty-output: 'stop'
09:33:56 [DEBUG] elementName: 'GroupNode' label: 'User Defined Data Types' type: 'Types' on-empty-output: 'stop'
09:33:56 [DEBUG] elementName: 'GroupNode' label: 'Triggers' type: 'Triggers' on-empty-output: 'stop'
09:33:56 [DEBUG] elementName: 'GroupNode' label: 'Stored Procedures' type: 'Procedures' on-empty-output: 'stop'
09:33:59 [DEBUG] elementName: 'DataNode' label: '${sybase-ase.getObjects.owner}.${sybase-ase.getObjects.name}' type: 'Procedure' on-empty-output: 'stop'
09:33:59 [DEBUG] Returning cloned generic Command for idref: sybase-ase.getObjects
09:33:59 [DEBUG] CommandId: sybase-ase.getObjects sql: select owner = user_name(uid), name, crdate "Creation Date"
from ${database}.dbo.sysobjects where type = '${type}' order by name
09:33:59 [DEBUG] Executing...
09:33:59 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis'
09:33:59 [DEBUG] RootConnection: SybConnection.createStatement()
09:33:59 [DEBUG] SQL: select owner = user_name(uid), name, crdate "Creation Date"
from mis.dbo.sysobjects where type = 'P' order by name
09:33:59 [DEBUG] RootConnection: SybConnection.nativeSQL("select owner = user_name(uid), name, crdate "Creation Date"
from mis.dbo.sysobjects where type = 'P' order by name")
09:33:59 [DEBUG] RootConnection: SybStatement.setEscapeProcessing(false)
09:33:59 [DEBUG] RootConnection: SybStatement.execute("select owner = user_name(uid), name, crdate "Creation Date"
from mis.dbo.sysobjects where type = 'P' order by name")
09:33:59 [DEBUG] Total rows/columns: 1545/3. Rows after filtering: 1545
09:34:19 [DEBUG] remove DataView type: Tables from: ObjectView
09:34:19 [DEBUG] remove DataView type: References from: ObjectView
09:34:19 [DEBUG] remove DataView type: Tables from: ObjectView
09:34:19 [DEBUG] adding DataView type: Tables to: Tables at index: 1
09:34:19 [DEBUG] remove DataView type: References from: ObjectView
09:34:19 [DEBUG] adding DataView type: References to: Tables at index: 3
09:34:19 [DEBUG] adding DataView type: Source to: Table at index: -1
09:34:19 [DEBUG] adding DataView type: Trigger to: Table at index: -1
09:34:19 [DEBUG] adding ObjectView type: SystemTables
09:34:19 [DEBUG] adding ObjectView type: SystemTable
09:34:19 [DEBUG] adding ObjectView type: Views
09:34:19 [DEBUG] adding ObjectView type: View
09:34:19 [DEBUG] adding ObjectView type: Users
09:34:19 [DEBUG] adding ObjectView type: User
09:34:19 [DEBUG] adding ObjectView type: Groups
09:34:19 [DEBUG] adding ObjectView type: Group
09:34:19 [DEBUG] adding ObjectView type: Triggers
09:34:19 [DEBUG] adding ObjectView type: Trigger
09:34:19 [DEBUG] adding ObjectView type: Types
09:34:19 [DEBUG] remove DataView type: Procedures from: ObjectView
09:34:19 [DEBUG] adding DataView type: Procedures to: Procedures at index: 1
09:34:19 [DEBUG] remove DataView type: Columns from: ObjectView
09:34:19 [DEBUG] adding DataView type: SourceEditor to: Procedure at index: -1
09:34:19 [DEBUG] adding DataView type: Interface to: Procedure at index: -1
09:34:19 [DEBUG] adding ObjectView type: ServerInfo
09:34:19 [DEBUG] adding ObjectView type: Logins
09:34:19 [DEBUG] adding ObjectView type: Login
09:34:19 [DEBUG] adding ObjectView type: Devices
09:34:19 [DEBUG] adding ObjectView type: Device
09:34:19 [DEBUG] adding ObjectView type: RemoteServers
09:34:19 [DEBUG] adding ObjectView type: ServerRoles
09:34:19 [DEBUG] adding ObjectView type: ServerRole
09:34:19 [DEBUG] adding ObjectView type: Processes
09:34:19 [DEBUG] adding ObjectView type: Transactions
09:34:19 [DEBUG] adding ObjectView type: Locks
09:34:19 [DEBUG] Returning cloned generic Command for idref: getProcedureColumns
09:34:20 [DEBUG] Executing...
09:34:20 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis'
09:34:20 [DEBUG] RootConnection: SybConnection.prepareStatement("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ")
09:34:20 [DEBUG] index=[1] name=[qn] value=[dbo.GenordsLAEM_broker_off_ext] type=[String] options=[nullable ]
09:34:20 [DEBUG] RootConnection: SybPreparedStatement.setString(1, "dbo.GenordsLAEM_broker_off_ext")
09:34:20 [DEBUG] SQL: SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?)
09:34:20 [DEBUG] RootConnection: SybConnection.nativeSQL("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ")
09:34:20 [DEBUG] RootConnection: SybPreparedStatement.execute()
com.onseven.dbvis.G.B.L: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['.

at com.onseven.dbvis.G.B.H.execute(Z:3362)
at com.onseven.dbvis.G.B.V.run(Z:3245)
at com.onseven.dbvis.S.A.A.?(Z:2122)
at com.onseven.dbvis.S.A.A.?(Z:1382)
at com.onseven.dbvis.S.A.A.?(Z:588)
at com.onseven.dbvis.b.B.A.A.K.?(Z:2874)
at com.onseven.dbvis.b.B.A.A.J.?(Z:1314)
at com.onseven.dbvis.b.B.E.?(Z:3046)
at com.onseven.dbvis.b.B.E.?(Z:3195)
at com.onseven.dbvis.b.B.E.?(Z:759)
at com.onseven.dbvis.b.B.E$1.ancestorAdded(Z:1320)
at javax.swing.AncestorNotifier.fireAncestorAdded(Unknown Source)
at javax.swing.AncestorNotifier.componentShown(Unknown Source)
at java.awt.Component.processComponentEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at com.onseven.dbvis.J.A.g.dispatchEvent(Z:2143)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['.

at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.onseven.dbvis.Z.B.B.invoke(Z:573)
at $Proxy2.execute(Unknown Source)
at com.onseven.dbvis.G.B.H.execute(Z:2529)
... 26 more
09:35:41 [DEBUG] Executing...
09:35:41 [DEBUG] DbConnection='MIS Dev' Catalog='mis' Schema='null' NewCatalog='mis'
09:35:41 [DEBUG] RootConnection: SybConnection.prepareStatement("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ")
09:35:41 [DEBUG] index=[1] name=[qn] value=[dbo.GenordsHK_security_ext] type=[String] options=[nullable ]
09:35:41 [DEBUG] RootConnection: SybPreparedStatement.setString(1, "dbo.GenordsHK_security_ext")
09:35:41 [DEBUG] SQL: SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?)
09:35:41 [DEBUG] RootConnection: SybConnection.nativeSQL("SELECT text FROM [mis].dbo.syscomments c, [mis].dbo.sysobjects s WHERE s.id = c.id AND s.type = 'P' AND s.id = object_id(?) ")
09:35:41 [DEBUG] RootConnection: SybPreparedStatement.execute()
com.onseven.dbvis.G.B.L: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['.

at com.onseven.dbvis.G.B.H.execute(Z:3362)
at com.onseven.dbvis.G.B.V.run(Z:3245)
at com.onseven.dbvis.S.A.A.?(Z:2122)
at com.onseven.dbvis.S.A.A.?(Z:1382)
at com.onseven.dbvis.S.A.A.?(Z:588)
at com.onseven.dbvis.b.B.A.A.K.?(Z:2874)
at com.onseven.dbvis.b.B.A.A.J.?(Z:1314)
at com.onseven.dbvis.b.B.E.?(Z:3046)
at com.onseven.dbvis.b.B.E.?(Z:3195)
at com.onseven.dbvis.b.B.E.?(Z:2269)
at com.onseven.dbvis.b.B.K.?(Z:1734)
at com.onseven.dbvis.b.B.K.?(Z:3426)
at com.onseven.dbvis.b.A.E.?(Z:1157)
at com.onseven.dbvis.b.A.E.?(Z:1475)
at com.onseven.dbvis.b.A.E$44.valueChanged(Z:3466)
at javax.swing.tree.DefaultTreeSelectionModel.fireValueChanged(Unknown Source)
at javax.swing.tree.DefaultTreeSelectionModel.notifyPathChange(Unknown Source)
at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPaths(Unknown Source)
at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPath(Unknown Source)
at javax.swing.JTree.setSelectionPath(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI.selectPathForEvent(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI$Handler.handleSelection(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI$Handler.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at com.onseven.dbvis.J.A.g.dispatchEvent(Z:2143)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '['.

at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.onseven.dbvis.Z.B.B.invoke(Z:573)
at $Proxy2.execute(Unknown Source)
at com.onseven.dbvis.G.B.H.execute(Z:2529)
... 46 more

Hi Nick,

I believe I've found why square brackets works in some databases and not in others. Support for square brackets as identifier quotes was added in Sybase 12.5.1 to make it easier to migrate from MS SQL Server:

http://www.ispirer.com/doc/sqlways38/Output/SQLWays-1-173.html

The database you have a problem with is 12.5.0.

Best Regards,
Hans

Hi,

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

Best Regards

Roger