Start a new topic

Partial result set retrieval

[This topic is migrated from our old forums. The original author name has been removed]

Hi. Is there a way to save the partial result set returned? For example, I run a query which return 1 million rows (by accident). I see 10000 rows returned and decide to stop. Once I click stop, nothing will show up in the result set tab, althought 10,000 has returned. I would like to keep whatever has returned. I believe DBVis v4 did this way. I know I could set the rowcount and rerun the query but the query could take long. Thanks Richard

[This reply is migrated from our old forums.]

Re: Partial result set retrieval
Richard, This is now fixed in the 8.0.9 version. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Partial result set retrieval
thanks, Roger.
[This reply is migrated from our old forums.]

Re: Partial result set retrieval
Richard, Just to inform you that we have a fix that solves the problem. It will be included in the next maintenance version. Best Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Partial result set retrieval
Hi, Hans. I changed the database type to Generic, still got the same error. I tried Sybase ASA Jconnect, Sybase SQL Anywhere JConnect but with the same error. here is the debug info. ------------------------- Product Information ------------------------ Product: DbVisualizer Personal 8.0.5 Build: #1714 (2011/11/03 18:14) Java VM: Java HotSpot(TM) Client VM Java Version: 1.6.0_26 Java Vendor: Sun Microsystems Inc. OS Name: Windows XP OS Arch: x86 OS Version: 5.1 ------------------------- Connected Databases ------------------------ Database Type: Generic Major Version: 15 Minor Version: 2 Profile: generic Connection Message: Sybase IQ Sybase IQ/15.2.0.5615/101123/P/ESD 2/Sun_Sparc/OS 5.10/64bit/2010-11-23 11:07:14 jConnect (TM) for JDBC (TM) jConnect (TM) for JDBC(TM)/6.05(Build 25939)/P/EBF13489/JDK14/Mon May 8 11:51:20 2006 --------------------------- Debug Printouts -------------------------- 10:30:03 [DEBUG Thread-36 F.?] Creating new connection: DefaultEditor-0 for PROD_MBA_ASA_Jconnect 10:30:03 [DEBUG Thread-36 G.?] Connecting: PROD_MBA_ASA_Jconnect 10:30:03 [DEBUG Thread-36 L.?] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 10:30:03 [DEBUG Thread-36 L.?] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 10:30:03 [DEBUG pool-3-thread-6 D.?] DefaultEditor-0: SybDriver.acceptsURL("jdbc:sybase:Tds:pmba-appdb.bmogc.net:4480/prod_mba") 10:30:03 [DEBUG pool-3-thread-6 D.?] DefaultEditor-0: SybDriver.connect("jdbc:sybase:Tds:pmba-appdb.bmogc.net:4480/prod_mba", {user=****, password=********}) 10:30:03 [DEBUG pool-3-thread-6 C.?] DefaultEditor-0: SybConnection.setAutoCommit(true) 10:30:03 [DEBUG Thread-36 G.?] Using facade: generic for PROD_MBA_ASA_Jconnect 10:30:03 [DEBUG pool-3-thread-6 E.?] DefaultEditor-0: SybDatabaseMetaData.getDatabaseProductName() 10:30:03 [DEBUG pool-3-thread-6 E.?] DefaultEditor-0: SybDatabaseMetaData.getDatabaseProductVersion() 10:30:03 [DEBUG pool-3-thread-6 E.?] DefaultEditor-0: SybDatabaseMetaData.getDriverName() 10:30:03 [DEBUG pool-3-thread-6 E.?] DefaultEditor-0: SybDatabaseMetaData.getDriverVersion() 10:30:03 [DEBUG Thread-36 J.execute] Executing... 10:30:04 [DEBUG Thread-36 J.setCurrentCatalog] DbConnection='PROD_MBA_ASA_Jconnect' Catalog='prod_mba' Schema='null' NewCatalog='prod_mba' 10:30:04 [DEBUG Thread-36 J.setCurrentSchema] DbConnection='PROD_MBA_ASA_Jconnect' Catalog='null' Schema='null' NewSchema='null' 10:30:04 [DEBUG pool-3-thread-6 C.?] DefaultEditor-0: SybConnection.createStatement() 10:30:04 [DEBUG pool-3-thread-6 B.?] DefaultEditor-0: SybStatement.execute("select * from dbo.AccessWk") 10:30:13 [DEBUG AWT-EventQueue-1 J.stopExecution] Cancelling current statement... 10:30:13 [DEBUG pool-3-thread-6 B.?] DefaultEditor-0: SybStatement.cancel() 10:30:13 [DEBUG AWT-EventQueue-1 Y.stopExecution] Forced interrupt of executor runner 10:30:13 [DEBUG Thread-36 E.?] Error (java.sql.SQLException) getting value for: 25692/16 (java.lang.String: fut_card_typ): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 10:30:13 [DEBUG Thread-36 E.?] ... switching to getObject() 10:30:13 [DEBUG Thread-36 E.?] Error getting value for: 25692/16: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 10:30:13 [DEBUG Thread-36 E.?] Error (java.sql.SQLException) getting value for: 25692/17 (java.lang.String: prev_bl_cd): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 10:30:13 [DEBUG Thread-36 E.?] ... switching to getObject() 10:30:13 [DEBUG Thread-36 E.?] Error getting value for: 25692/17: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 10:30:13 [DEBUG Thread-36 E.?] Error (java.sql.SQLException) getting value for: 25692/18 (java.sql.Date: prev_bl_cd_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 10:30:13 [DEBUG Thread-36 E.?] ... switching to getObject() 10:30:13 [DEBUG Thread-36 E.?] Error getting value for: 25692/18: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 10:30:13 [DEBUG Thread-36 E.?] Error (java.sql.SQLException) getting value for: 25692/19 (java.sql.Date: bl_cd_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 10:30:13 [DEBUG Thread-36 E.?] ... switching to getObject() 10:30:13 [DEBUG Thread-36 E.?] Error getting value for: 25692/19: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 10:30:13 [DEBUG Thread-36 E.?] Error (java.sql.SQLException) getting value for: 25692/20 (java.lang.Integer: card_issued_nbr): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 10:30:13 [DEBUG Thread-36 E.?] ... switching to getObject() 10:30:13 [DEBUG Thread-36 E.?] Error getting value for: 25692/20: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 10:30:13 [DEBUG Thread-36 E.?] Error (java.sql.SQLException) getting value for: 25692/21 (java.lang.Integer: card_ret_nbr): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 10:30:13 [DEBUG Thread-36 E.?] ... switching to getObject() 10:30:13 [DEBUG Thread-36 E.?] Error getting value for: 25692/21: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 10:30:13 [DEBUG Thread-36 E.?] Error (java.sql.SQLException) getting value for: 25692/22 (java.sql.Date: last_issue_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 10:30:13 [DEBUG Thread-36 E.?] ... switching to getObject() 10:30:13 [DEBUG Thread-36 E.?] Error getting value for: 25692/22: java.sql.SQLException: JZ0R0: ResultSet has already been closed.
[This reply is migrated from our old forums.]

Re: Partial result set retrieval
Hi Richard, Your debug log shows that you are connected to two databases, both of them being Sybase IQ databases, But for one of them, you have set the Database Type to Sybase ASE and Sybase ASA (in another test). Sybase IQ is neither an ASE nor an ASA database, so you must use the Generic Database Type (as you do for the second database). The log indicates that when you test Stop, you are using the connection with the invalid Database Type setting, which may explain the behavior. Please try this: 1) Set the Database Type to Generic, 2) Use either the jConnect or the jTDS driver instead of the JDBC-ODBC Bridge. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

Re: Partial result set retrieval
Hans, I am sure I clicked stop after seeing more than 10,000 rows retrieved. Please see following debug info with jConnect driver, along with a couple of screenshots. I also changed the database type from ASE to ASA, but got the similar error(see the debugging info at the second half). The error message seems to have changed a bit. ------------------------- Product Information ------------------------ Product: DbVisualizer Personal 8.0.5 Build: #1714 (2011/11/03 18:14) Java VM: Java HotSpot(TM) Client VM Java Version: 1.6.0_26 Java Vendor: Sun Microsystems Inc. OS Name: Windows XP OS Arch: x86 OS Version: 5.1 ------------------------- Connected Databases ------------------------ Database Type: Sybase ASE Major Version: 15 Minor Version: 2 Profile: sybase-ase Connection Message: Sybase IQ Sybase IQ/15.2.0.5615/101123/P/ESD 2/Sun_Sparc/OS 5.10/64bit/2010-11-23 11:07:14 jConnect (TM) for JDBC (TM) jConnect (TM) for JDBC(TM)/6.05(Build 26312)/P/EBF15807/JDK14/Tue Jun 10 1:06:20 2008 Database Type: Generic Major Version: 11 Minor Version: 0 Profile: generic Connection Message: Sybase IQ 11.00.0000 JDBC-ODBC Bridge (ivslk20.dll) 2.0001 (01.41.0000) --------------------------- Debug Printouts -------------------------- 11:12:13 [DEBUG pool-3-thread-26 E.?] DefaultEditor-0: SybDatabaseMetaData.getUserName() 11:12:13 [DEBUG Thread-130 J.execute] Executing... 11:12:13 [DEBUG Thread-130 J.setCurrentCatalog] DbConnection='PROD_MBA_t' Catalog='prod_mba' Schema='null' NewCatalog='prod_mba' 11:12:13 [DEBUG pool-3-thread-26 E.?] DefaultEditor-0: SybDatabaseMetaData.getUserName() 11:12:13 [DEBUG Thread-130 J.setCurrentSchema] DbConnection='PROD_MBA_t' Catalog='null' Schema='rmei' NewSchema='rmei' 11:12:13 [DEBUG pool-3-thread-26 C.?] DefaultEditor-0: SybConnection.createStatement() 11:12:13 [DEBUG pool-3-thread-26 B.?] DefaultEditor-0: SybStatement.execute("select * from dbo.AccessDly") 11:12:14 [DEBUG AWT-EventQueue-1 J.stopExecution] Cancelling current statement... 11:12:14 [DEBUG pool-3-thread-26 B.?] DefaultEditor-0: SybStatement.cancel() 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/7 (java.sql.Date: accs_create_dt): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/7: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/8 (java.lang.Integer: nbr_os): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/8: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0P4: Protocol error. This message indicates an internal product problem. Report this error to Sybase Technical Support. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/9 (java.lang.String: bl_cd_val): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0P4: Protocol error. This message indicates an internal product problem. Report this error to Sybase Technical Support. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/9: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/10 (java.sql.Date: accs_last_upd_dt): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/10: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/11 (java.sql.Date: MBA_crte_dt): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/11: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/12 (java.lang.String: srvc_cd): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/12: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/13 (java.lang.String: srvc_cd_sub_typ): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/13: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/14 (java.lang.String: card_typ_shrt_form): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/14: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/15 (java.lang.String: card_grp_shrt_form): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/15: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/16 (java.lang.String: fut_card_typ): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/16: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/17 (java.lang.String: prev_bl_cd): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/17: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/18 (java.sql.Date: prev_bl_cd_dt): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/18: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/19 (java.sql.Date: bl_cd_dt): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/19: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/20 (java.lang.Integer: card_issued_nbr): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/20: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0P4: Protocol error. This message indicates an internal product problem. Report this error to Sybase Technical Support. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/21 (java.lang.Integer: card_ret_nbr): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0P4: Protocol error. This message indicates an internal product problem. Report this error to Sybase Technical Support. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/21: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0P4: Protocol error. This message indicates an internal product problem. Report this error to Sybase Technical Support. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/22 (java.sql.Date: last_issue_dt): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0P4: Protocol error. This message indicates an internal product problem. Report this error to Sybase Technical Support. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/22: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG pool-3-thread-26 B.?] DefaultEditor-0: EXCEPTION -> java.lang.NullPointerException: null 11:12:14 [DEBUG AWT-EventQueue-1 Y.stopExecution] Forced interrupt of executor runner 11:12:14 [DEBUG Thread-130 G.?] Could not getSchema for PROD_MBA_t:Execution interrupted 11:12:14 [DEBUG pool-3-thread-26 E.?] DefaultEditor-0: SybDatabaseMetaData.getUserName() ------------------------- Product Information ------------------------ Product: DbVisualizer Personal 8.0.5 Build: #1714 (2011/11/03 18:14) Java VM: Java HotSpot(TM) Client VM Java Version: 1.6.0_26 Java Vendor: Sun Microsystems Inc. OS Name: Windows XP OS Arch: x86 OS Version: 5.1 ------------------------- Connected Databases ------------------------ Database Type: Sybase SQL Anywhere Major Version: 15 Minor Version: 2 Profile: generic Connection Message: Sybase IQ Sybase IQ/15.2.0.5615/101123/P/ESD 2/Sun_Sparc/OS 5.10/64bit/2010-11-23 11:07:14 jConnect (TM) for JDBC (TM) jConnect (TM) for JDBC(TM)/6.05(Build 26312)/P/EBF15807/JDK14/Tue Jun 10 1:06:20 2008 Database Type: Generic Major Version: 11 Minor Version: 0 Profile: generic Connection Message: Sybase IQ 11.00.0000 JDBC-ODBC Bridge (ivslk20.dll) 2.0001 (01.41.0000) --------------------------- Debug Printouts -------------------------- 11:12:13 [DEBUG pool-3-thread-26 E.?] DefaultEditor-0: SybDatabaseMetaData.getUserName() 11:12:13 [DEBUG Thread-130 J.execute] Executing... 11:12:13 [DEBUG Thread-130 J.setCurrentCatalog] DbConnection='PROD_MBA_t' Catalog='prod_mba' Schema='null' NewCatalog='prod_mba' 11:12:13 [DEBUG pool-3-thread-26 E.?] DefaultEditor-0: SybDatabaseMetaData.getUserName() 11:12:13 [DEBUG Thread-130 J.setCurrentSchema] DbConnection='PROD_MBA_t' Catalog='null' Schema='rmei' NewSchema='rmei' 11:12:13 [DEBUG pool-3-thread-26 C.?] DefaultEditor-0: SybConnection.createStatement() 11:12:13 [DEBUG pool-3-thread-26 B.?] DefaultEditor-0: SybStatement.execute("select * from dbo.AccessDly") 11:12:14 [DEBUG AWT-EventQueue-1 J.stopExecution] Cancelling current statement... 11:12:14 [DEBUG pool-3-thread-26 B.?] DefaultEditor-0: SybStatement.cancel() 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/7 (java.sql.Date: accs_create_dt): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/7: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/8 (java.lang.Integer: nbr_os): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/8: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0P4: Protocol error. This message indicates an internal product problem. Report this error to Sybase Technical Support. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/9 (java.lang.String: bl_cd_val): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0P4: Protocol error. This message indicates an internal product problem. Report this error to Sybase Technical Support. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/9: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/10 (java.sql.Date: accs_last_upd_dt): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/10: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/11 (java.sql.Date: MBA_crte_dt): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/11: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/12 (java.lang.String: srvc_cd): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/12: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/13 (java.lang.String: srvc_cd_sub_typ): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/13: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/14 (java.lang.String: card_typ_shrt_form): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/14: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/15 (java.lang.String: card_grp_shrt_form): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/15: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/16 (java.lang.String: fut_card_typ): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/16: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/17 (java.lang.String: prev_bl_cd): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/17: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/18 (java.sql.Date: prev_bl_cd_dt): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/18: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/19 (java.sql.Date: bl_cd_dt): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/19: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/20 (java.lang.Integer: card_issued_nbr): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/20: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0P4: Protocol error. This message indicates an internal product problem. Report this error to Sybase Technical Support. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/21 (java.lang.Integer: card_ret_nbr): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0P4: Protocol error. This message indicates an internal product problem. Report this error to Sybase Technical Support. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/21: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0P4: Protocol error. This message indicates an internal product problem. Report this error to Sybase Technical Support. 11:12:14 [DEBUG Thread-130 E.?] Error (java.sql.SQLException) getting value for: 29927/22 (java.sql.Date: last_issue_dt): java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0P4: Protocol error. This message indicates an internal product problem. Report this error to Sybase Technical Support. 11:12:14 [DEBUG Thread-130 E.?] ... switching to getObject() 11:12:14 [DEBUG Thread-130 E.?] Error getting value for: 29927/22: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection. 11:12:14 [DEBUG pool-3-thread-26 B.?] DefaultEditor-0: EXCEPTION -> java.lang.NullPointerException: null 11:12:14 [DEBUG AWT-EventQueue-1 Y.stopExecution] Forced interrupt of executor runner 11:12:14 [DEBUG Thread-130 G.?] Could not getSchema for PROD_MBA_t:Execution interrupted 11:12:14 [DEBUG pool-3-thread-26 E.?] DefaultEditor-0: SybDatabaseMetaData.getUserName() 11:13:34 [DEBUG pool-3-thread-26 E.?] RootConnection: SybDatabaseMetaData.getDatabaseMajorVersion() 11:13:34 [DEBUG pool-3-thread-26 E.?] RootConnection: SybDatabaseMetaData.getDatabaseMinorVersion() 11:13:34 [DEBUG pool-3-thread-26 E.?] RootConnection: JdbcOdbcDatabaseMetaData.getDatabaseMajorVersion() 11:13:34 [DEBUG pool-3-thread-26 E.?] RootConnection: EXCEPTION -> java.lang.UnsupportedOperationException: null 11:13:34 [DEBUG pool-3-thread-26 E.?] RootConnection: JdbcOdbcDatabaseMetaData.getDatabaseProductVersion() 11:13:34 [DEBUG pool-3-thread-26 E.?] RootConnection: JdbcOdbcDatabaseMetaData.getDatabaseMinorVersion() 11:13:34 [DEBUG pool-3-thread-26 E.?] RootConnection: EXCEPTION -> java.lang.UnsupportedOperationException: null 11:13:34 [DEBUG pool-3-thread-26 E.?] RootConnection: JdbcOdbcDatabaseMetaData.getDatabaseProductVersion() 11:19:25 [DEBUG AWT-EventQueue-1 F.?] Freeing connection: DefaultEditor-0 for PROD_MBA_t 11:19:25 [DEBUG Thread-132 G.?] Disconnecting: PROD_MBA_t 11:19:25 [DEBUG pool-3-thread-31 C.?] DefaultEditor-0: SybConnection.close() 11:19:25 [DEBUG Thread-131 G.?] Disconnecting: PROD_MBA_t 11:19:25 [DEBUG pool-3-thread-30 C.?] RootConnection: SybConnection.close() 11:19:25 [DEBUG Thread-132 G.?] Connection closed: PROD_MBA_t 11:19:25 [DEBUG Thread-131 G.?] Connection closed: PROD_MBA_t 11:19:37 [DEBUG Thread-133 G.?] Connecting: PROD_MBA_t 11:19:37 [DEBUG Thread-133 L.?] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 11:19:37 [DEBUG Thread-133 L.?] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 11:19:37 [DEBUG pool-3-thread-30 D.?] RootConnection: SybDriver.acceptsURL("jdbc:sybase:Tds:pmba-appdb.bmogc.net:4480") 11:19:37 [DEBUG pool-3-thread-30 D.?] RootConnection: SybDriver.connect("jdbc:sybase:Tds:pmba-appdb.bmogc.net:4480", {user=****, password=********}) 11:19:37 [DEBUG pool-3-thread-30 C.?] RootConnection: SybConnection.setAutoCommit(true) 11:19:37 [DEBUG Thread-133 G.?] Using facade: sybase-asa for PROD_MBA_t 11:19:37 [DEBUG pool-3-thread-30 E.?] RootConnection: SybDatabaseMetaData.getDatabaseProductName() 11:19:37 [DEBUG pool-3-thread-30 E.?] RootConnection: SybDatabaseMetaData.getDatabaseProductVersion() 11:19:37 [DEBUG pool-3-thread-30 E.?] RootConnection: SybDatabaseMetaData.getDriverName() 11:19:37 [DEBUG pool-3-thread-30 E.?] RootConnection: SybDatabaseMetaData.getDriverVersion() 11:19:37 [DEBUG pool-3-thread-30 E.?] RootConnection: SybDatabaseMetaData.getDriverName() 11:19:37 [DEBUG pool-3-thread-30 E.?] RootConnection: SybDatabaseMetaData.getDriverVersion() 11:19:37 [DEBUG Thread-134 D.?] Loading profile /profiles/generic.xml 11:19:37 [DEBUG Thread-134 D.?] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'" 11:19:37 [DEBUG Thread-134 D.?] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'" 11:19:37 [DEBUG Thread-134 D.?] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'" 11:19:37 [DEBUG Thread-134 D.?] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'" 11:19:37 [DEBUG Thread-134 D.?] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'" 11:19:37 [DEBUG Thread-134 D.?] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'" 11:19:37 [DEBUG Thread-134 D.?] no match: If "#db.getDatabaseType().equals('firebird')" 11:19:37 [DEBUG Thread-134 D.?] no match: If "#db.getDatabaseType().equals('firebird')" 11:19:37 [DEBUG Thread-134 D.?] match: Else "null" 11:19:37 [DEBUG Thread-134 D.?] match: If "! #db.getDatabaseType().equals('firebird')" 11:19:37 [DEBUG Thread-134 D.?] no match: If "#db.getDatabaseType().equals('firebird')" 11:19:37 [DEBUG Thread-134 D.?] no match: If "#db.getDatabaseType().equals('firebird')" 11:19:37 [DEBUG Thread-134 D.?] match: Else "null" 11:19:37 [DEBUG Thread-134 D.?] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'" 11:19:37 [DEBUG Thread-134 D.?] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'" 11:19:37 [DEBUG Thread-134 D.?] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'" 11:19:37 [DEBUG Thread-134 D.?] match: If "#sp.getProperty('dbvis.license.type') eq 'Personal'" 11:19:37 [DEBUG Thread-134 K.?] Using profile: generic 11:19:37 [DEBUG Thread-134 A.?] Returning cloned generic Command for idref: getCatalogs 11:19:37 [DEBUG Thread-134 B.execute] CommandId: getCatalogs 11:19:37 [DEBUG AWT-EventQueue-1 A.?] Returning cloned generic Command for idref: getColumnNamesFor 11:19:37 [DEBUG Thread-134 N.?] DbConnection: PROD_MBA_t 11:19:37 [DEBUG pool-3-thread-30 E.?] RootConnection: SybDatabaseMetaData.getCatalogs() 11:19:37 [DEBUG Thread-136 J.?] elementName: 'DataNode' label: '${getCatalogs.TABLE_CAT}' type: 'Catalog' on-empty-output: 'continue' 11:19:37 [DEBUG Thread-136 A.?] Returning cloned generic Command for idref: getCatalogs 11:19:37 [DEBUG Thread-136 B.execute] CommandId: getCatalogs 11:19:37 [DEBUG Thread-136 N.?] DbConnection: PROD_MBA_t 11:19:37 [DEBUG pool-3-thread-30 E.?] RootConnection: SybDatabaseMetaData.getCatalogs() 11:19:37 [DEBUG Thread-134 B.execute] Total rows/columns: 1/1. Rows after filtering: 1 11:19:37 [DEBUG Thread-134 B.execute] CommandId: getSchemaNames 11:19:37 [DEBUG Thread-134 N.?] DbConnection: PROD_MBA_t 11:19:37 [DEBUG pool-3-thread-30 E.?] RootConnection: SybDatabaseMetaData.getSchemas() 11:19:37 [DEBUG Thread-136 B.execute] Total rows/columns: 1/1. Rows after filtering: 1 11:19:37 [DEBUG Thread-134 J.?] Error getting schemas: com.onseven.dbvis.H.B.O: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -1119: The 'FileVersion' property is no longer supported 11:19:37 [DEBUG Thread-134 K.run] Error getting schemas com.onseven.dbvis.H.B.O: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -1119: The 'FileVersion' property is no longer supported at com.onseven.dbvis.H.B.U.?(Z:2451) at com.onseven.dbvis.H.B.U.?(Z:1403) at com.onseven.dbvis.H.B.Y.processResultSet(Z:3268) at com.onseven.dbvis.H.B.Y.processResultSet(Z:3213) at com.onseven.dbvis.H.B.N.?(Z:3029) at com.onseven.dbvis.H.B.N.execute(Z:2471) at com.onseven.dbvis.H.B.Y.?(Z:591) at com.onseven.dbvis.H.B.Y.run(Z:1655) at com.onseven.dbvis.H.B.B.?(Z:2204) at com.onseven.dbvis.H.B.B.execute(Z:495) at com.onseven.dbvis.H.B.Y.?(Z:591) at com.onseven.dbvis.H.B.Y.run(Z:1655) at com.onseven.dbvis.db.AbstractFacade.getSchemaNames(Z:355) at com.onseven.dbvis.I.J.?(Z:2585) at com.onseven.dbvis.E.K$A.run(Z:346) at java.lang.Thread.run(Unknown Source) Caused by: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -1119: The 'FileVersion' property is no longer supported at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.tds.TdsResultSet.nextResult(Unknown Source) at com.sybase.jdbc3.tds.TdsResultSet.next(Unknown Source) at com.sybase.jdbc3.jdbc.SybResultSet.next(Unknown Source) at com.onseven.dbvis.H.B.U.?(Z:1845) ... 15 more 11:19:44 [DEBUG Thread-139 F.?] Creating new connection: DefaultEditor-0 for PROD_MBA_t 11:19:44 [DEBUG Thread-139 G.?] Connecting: PROD_MBA_t 11:19:44 [DEBUG Thread-139 L.?] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 11:19:44 [DEBUG Thread-139 L.?] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 11:19:44 [DEBUG pool-3-thread-30 D.?] DefaultEditor-0: SybDriver.acceptsURL("jdbc:sybase:Tds:pmba-appdb.bmogc.net:4480") 11:19:44 [DEBUG pool-3-thread-30 D.?] DefaultEditor-0: SybDriver.connect("jdbc:sybase:Tds:pmba-appdb.bmogc.net:4480", {user=****, password=********}) 11:19:44 [DEBUG pool-3-thread-30 C.?] DefaultEditor-0: SybConnection.setAutoCommit(true) 11:19:44 [DEBUG Thread-139 G.?] Using facade: sybase-asa for PROD_MBA_t 11:19:44 [DEBUG pool-3-thread-30 E.?] DefaultEditor-0: SybDatabaseMetaData.getDatabaseProductName() 11:19:45 [DEBUG pool-3-thread-30 E.?] DefaultEditor-0: SybDatabaseMetaData.getDatabaseProductVersion() 11:19:45 [DEBUG pool-3-thread-30 E.?] DefaultEditor-0: SybDatabaseMetaData.getDriverName() 11:19:45 [DEBUG pool-3-thread-30 E.?] DefaultEditor-0: SybDatabaseMetaData.getDriverVersion() 11:19:45 [DEBUG Thread-139 J.execute] Executing... 11:19:45 [DEBUG Thread-139 J.setCurrentCatalog] DbConnection='PROD_MBA_t' Catalog='prod_mba' Schema='null' NewCatalog='prod_mba' 11:19:45 [DEBUG Thread-139 J.setCurrentSchema] DbConnection='PROD_MBA_t' Catalog='null' Schema='null' NewSchema='rmei' 11:19:45 [DEBUG pool-3-thread-30 C.?] DefaultEditor-0: SybConnection.createStatement() 11:19:45 [DEBUG pool-3-thread-30 B.?] DefaultEditor-0: SybStatement.execute("select * from dbo.AccessDly") 11:19:59 [DEBUG AWT-EventQueue-1 J.stopExecution] Cancelling current statement... 11:19:59 [DEBUG pool-3-thread-30 B.?] DefaultEditor-0: SybStatement.cancel() 11:19:59 [DEBUG AWT-EventQueue-1 Y.stopExecution] Forced interrupt of executor runner 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/6 (java.sql.Date: accs_exp_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/6: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/7 (java.sql.Date: accs_create_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/7: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/8 (java.lang.Integer: nbr_os): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/8: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/9 (java.lang.String: bl_cd_val): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/9: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/10 (java.sql.Date: accs_last_upd_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/10: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/11 (java.sql.Date: MBA_crte_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/11: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/12 (java.lang.String: srvc_cd): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/12: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/13 (java.lang.String: srvc_cd_sub_typ): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/13: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/14 (java.lang.String: card_typ_shrt_form): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/14: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/15 (java.lang.String: card_grp_shrt_form): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/15: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/16 (java.lang.String: fut_card_typ): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/16: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/17 (java.lang.String: prev_bl_cd): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/17: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/18 (java.sql.Date: prev_bl_cd_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/18: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/19 (java.sql.Date: bl_cd_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/19: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/20 (java.lang.Integer: card_issued_nbr): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/20: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/21 (java.lang.Integer: card_ret_nbr): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/21: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] Error (java.sql.SQLException) getting value for: 22484/22 (java.sql.Date: last_issue_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 11:19:59 [DEBUG Thread-139 E.?] ... switching to getObject() 11:19:59 [DEBUG Thread-139 E.?] Error getting value for: 22484/22: java.sql.SQLException: JZ0R0: ResultSet has already been closed. Edited by: Richard Mei on 4-Apr-2012 5:25 PM Edited by: Richard Mei on 4-Apr-2012 5:27 PM
[This reply is migrated from our old forums.]

Re: Partial result set retrieval
Hi Richard, Thanks for the debug output. First, make sure that the SQL Commander progress shows the "Fetching Result Set" messages when you click stop. If you stop the job before that, i.e. while the database is executing the select statement, there will not be any rows to fetch. This is how it has always been. The debug output indicates that you click Stop during execution. If you indeed see "Fetching Result Set" but still don't get a partial result after clicking Stop, then please try with a pure Java JDBC driver instead of the JDBC/ODBC Bridge. I believe one of the jConnect or the jTDS driver works with Sybase IQ as well. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: Partial result set retrieval
Hi, Hans. Here is the output. ------------------------- Product Information ------------------------ Product: DbVisualizer Personal 8.0.5 Build: #1714 (2011/11/03 18:14) Java VM: Java HotSpot(TM) Client VM Java Version: 1.6.0_26 Java Vendor: Sun Microsystems Inc. OS Name: Windows XP OS Arch: x86 OS Version: 5.1 ------------------------- Connected Databases ------------------------ Database Type: Sybase ASE Major Version: 15 Minor Version: 2 Profile: sybase-ase Connection Message: Sybase IQ Sybase IQ/15.2.0.5615/101123/P/ESD 2/Sun_Sparc/OS 5.10/64bit/2010-11-23 11:07:14 jConnect (TM) for JDBC (TM) jConnect (TM) for JDBC(TM)/6.05(Build 26312)/P/EBF15807/JDK14/Tue Jun 10 1:06:20 2008 Database Type: Generic Major Version: 11 Minor Version: 0 Profile: generic Connection Message: Sybase IQ 11.00.0000 JDBC-ODBC Bridge (ivslk20.dll) 2.0001 (01.41.0000) --------------------------- Debug Printouts -------------------------- 13:56:27 [DEBUG Thread-109 F.?] Creating new connection: DefaultEditor-0 for PROD_MBA_t 13:56:27 [DEBUG Thread-109 G.?] Connecting: PROD_MBA_t 13:56:27 [DEBUG Thread-109 L.?] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 13:56:27 [DEBUG Thread-109 L.?] Loading class using dynamic ClassLoader: com.sybase.jdbc3.jdbc.SybDriver 13:56:27 [DEBUG pool-3-thread-18 D.?] DefaultEditor-0: SybDriver.acceptsURL("jdbc:sybase:Tds:pmba-appdb.bmogc.net:4480") 13:56:27 [DEBUG pool-3-thread-18 D.?] DefaultEditor-0: SybDriver.connect("jdbc:sybase:Tds:pmba-appdb.bmogc.net:4480", {user=****, password=********}) 13:56:28 [DEBUG pool-3-thread-18 C.?] DefaultEditor-0: SybConnection.setAutoCommit(true) 13:56:28 [DEBUG Thread-109 G.?] Using facade: sybase-ase for PROD_MBA_t 13:56:28 [DEBUG pool-3-thread-18 E.?] DefaultEditor-0: SybDatabaseMetaData.getUserName() 13:56:28 [DEBUG pool-3-thread-18 E.?] DefaultEditor-0: SybDatabaseMetaData.getDatabaseProductName() 13:56:28 [DEBUG pool-3-thread-18 E.?] DefaultEditor-0: SybDatabaseMetaData.getDatabaseProductVersion() 13:56:28 [DEBUG pool-3-thread-18 E.?] DefaultEditor-0: SybDatabaseMetaData.getDriverName() 13:56:28 [DEBUG pool-3-thread-18 E.?] DefaultEditor-0: SybDatabaseMetaData.getDriverVersion() 13:56:28 [DEBUG pool-3-thread-18 E.?] DefaultEditor-0: SybDatabaseMetaData.getUserName() 13:56:28 [DEBUG Thread-109 J.execute] Executing... 13:56:28 [DEBUG Thread-109 J.setCurrentCatalog] DbConnection='PROD_MBA_t' Catalog='prod_mba' Schema='null' NewCatalog='prod_mba' 13:56:28 [DEBUG pool-3-thread-18 E.?] DefaultEditor-0: SybDatabaseMetaData.getUserName() 13:56:28 [DEBUG Thread-109 J.setCurrentSchema] DbConnection='PROD_MBA_t' Catalog='null' Schema='rmei' NewSchema='rmei' 13:56:28 [DEBUG pool-3-thread-18 C.?] DefaultEditor-0: SybConnection.createStatement() 13:56:28 [DEBUG pool-3-thread-18 B.?] DefaultEditor-0: SybStatement.execute("select * from dbo.AccessDly") 13:56:37 [DEBUG AWT-EventQueue-1 J.stopExecution] Cancelling current statement... 13:56:37 [DEBUG pool-3-thread-18 B.?] DefaultEditor-0: SybStatement.cancel() 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/6 (java.sql.Date: accs_exp_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG AWT-EventQueue-1 Y.stopExecution] Forced interrupt of executor runner 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/6: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/7 (java.sql.Date: accs_create_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/7: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/8 (java.lang.Integer: nbr_os): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/8: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/9 (java.lang.String: bl_cd_val): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/9: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/10 (java.sql.Date: accs_last_upd_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/10: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/11 (java.sql.Date: MBA_crte_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/11: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/12 (java.lang.String: srvc_cd): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/12: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/13 (java.lang.String: srvc_cd_sub_typ): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/13: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/14 (java.lang.String: card_typ_shrt_form): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/14: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/15 (java.lang.String: card_grp_shrt_form): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/15: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/16 (java.lang.String: fut_card_typ): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/16: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/17 (java.lang.String: prev_bl_cd): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/17: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/18 (java.sql.Date: prev_bl_cd_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/18: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/19 (java.sql.Date: bl_cd_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/19: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/20 (java.lang.Integer: card_issued_nbr): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/20: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/21 (java.lang.Integer: card_ret_nbr): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/21: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] Error (java.sql.SQLException) getting value for: 3385/22 (java.sql.Date: last_issue_dt): java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 E.?] ... switching to getObject() 13:56:37 [DEBUG Thread-109 E.?] Error getting value for: 3385/22: java.sql.SQLException: JZ0R0: ResultSet has already been closed. 13:56:37 [DEBUG Thread-109 G.?] Could not getSchema for PROD_MBA_t:Execution interrupted 13:56:37 [DEBUG pool-3-thread-19 E.?] DefaultEditor-0: SybDatabaseMetaData.getUserName()
[This reply is migrated from our old forums.]

Re: Partial result set retrieval
Hi Richard, Can you please enabled debugging just before you run the query with Sybase IQ and send us the output for the whole process? Please see this FAQ for how to enable debugging: http://www.dbvis.com/products/dbvis/doc/faq/#4.14 Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

Re: Partial result set retrieval
Roger I confirm it's working for DB2 database (with embedded DB2 driver). But it is not working with Sybase IQ database in V8. Some users just upgraded from V4.3 and complained it was working in V4 but not in V8. Database driver stayed the same. So it appears to me it has something to do with V8. Please see attached screenshots.
[This reply is migrated from our old forums.]

Re: Partial result set retrieval
Richard, If you stop an execution in version 8 and rows has been fetched these are preserved even if you stop the execution. Just make sure you click the lower "Result Set" tab after stop as the Log is automatically selected when stopping. Regards Roger