Partial result set retrieval ... - DbVisualizer Forums

Richard Mei

Posts: 35
Registered: 01/23/08

Partial result set retrieval
Posted: Mar 20, 2012 10:00 PM

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

Roger Bjarevall

Posts: 4,563
Registered: 12/17/04

Re: Partial result set retrieval
Posted: Mar 21, 2012 12:55 AM

in response to: Richard Mei

Reply

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

Richard Mei

Posts: 35
Registered: 01/23/08

Re: Partial result set retrieval
Posted: Apr 3, 2012 7:13 PM

in response to: Roger Bjarevall

Reply

dbvis_stop_button.jpg (114.3 KB )

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.

Hans Bergsten

Posts: 1,255
Registered: 10/11/06

Re: Partial result set retrieval
Posted: Apr 3, 2012 7:29 PM

in response to: Richard Mei

Reply

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

Richard Mei

Posts: 35
Registered: 01/23/08

Re: Partial result set retrieval
Posted: Apr 3, 2012 7:54 PM

in response to: Hans Bergsten

Reply

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()

Hans Bergsten

Posts: 1,255
Registered: 10/11/06

Re: Partial result set retrieval
Posted: Apr 4, 2012 12:33 AM

in response to: Richard Mei

Reply

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

Richard Mei

Posts: 35
Registered: 01/23/08

Re: Partial result set retrieval
Posted: Apr 4, 2012 5:25 PM

in response to: Hans Bergsten

Reply

	dbvis_stop_button_2.jpg (96.6 KB )
	dbvis_stop_button_1.jpg (134.0 KB )
	dbvis_stop_button_3.jpg (98.8 KB )

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

Hans Bergsten

Posts: 1,255
Registered: 10/11/06

Re: Partial result set retrieval
Posted: Apr 4, 2012 9:35 PM

in response to: Richard Mei

Reply

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

Richard Mei

Posts: 35
Registered: 01/23/08

Re: Partial result set retrieval
Posted: Apr 10, 2012 4:34 PM

in response to: Hans Bergsten

Reply

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.

Roger Bjarevall

Posts: 4,563
Registered: 12/17/04

Re: Partial result set retrieval
Posted: Apr 12, 2012 8:10 AM

in response to: Richard Mei

Reply

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

Richard Mei

Posts: 35
Registered: 01/23/08

Re: Partial result set retrieval
Posted: Apr 12, 2012 4:01 PM

in response to: Roger Bjarevall

Reply

thanks, Roger.

Roger Bjarevall

Posts: 4,563
Registered: 12/17/04

Re: Partial result set retrieval
Posted: Apr 30, 2012 2:03 PM

in response to: Richard Mei

Reply

Richard,

This is now fixed in the 8.0.9 version.

Regards

Roger

SupportSupport

Thread: Partial result set retrieval