Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: Partial result set retrieval

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


Permlink Replies: 11 - Pages: 1 - Last Post: Apr 30, 2012 2:03 PM Last Post By: Roger Bjarevall
Richard Mei

Posts: 35
Registered: 01/23/08
Partial result set retrieval
Posted: Mar 20, 2012 10:00 PM
 
   thread.click_reply Reply
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: 5,222
Registered: 12/17/04
Re: Partial result set retrieval
Posted: Mar 21, 2012 12:55 AM    global.in_response_to.tooltip in response to: Richard Mei
 
   thread.click_reply 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    global.in_response_to.tooltip in response to: Roger Bjarevall
 
   thread.click_reply Reply
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,599
Registered: 10/11/06
Re: Partial result set retrieval
Posted: Apr 3, 2012 7:29 PM    global.in_response_to.tooltip in response to: Richard Mei
 
   thread.click_reply 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    global.in_response_to.tooltip in response to: Hans Bergsten
 
   thread.click_reply 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,599
Registered: 10/11/06
Re: Partial result set retrieval
Posted: Apr 4, 2012 12:33 AM    global.in_response_to.tooltip in response to: Richard Mei
 
   thread.click_reply 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    global.in_response_to.tooltip in response to: Hans Bergsten
 
   thread.click_reply Reply
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,599
Registered: 10/11/06
Re: Partial result set retrieval
Posted: Apr 4, 2012 9:35 PM    global.in_response_to.tooltip in response to: Richard Mei
 
   thread.click_reply 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    global.in_response_to.tooltip in response to: Hans Bergsten
 
   thread.click_reply 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: 5,222
Registered: 12/17/04
Re: Partial result set retrieval
Posted: Apr 12, 2012 8:10 AM    global.in_response_to.tooltip in response to: Richard Mei
 
   thread.click_reply 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    global.in_response_to.tooltip in response to: Roger Bjarevall
 
   thread.click_reply Reply
thanks, Roger.
Roger Bjarevall


Posts: 5,222
Registered: 12/17/04
Re: Partial result set retrieval
Posted: Apr 30, 2012 2:03 PM    global.in_response_to.tooltip in response to: Richard Mei
 
   thread.click_reply Reply
Richard,

This is now fixed in the 8.0.9 version.

Regards

Roger

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