[This topic is migrated from our old forums. The original author name has been removed] [Attachment has been removed.]
Hi,
I am getting the below error while executing sql statement in dbvisualizer
*The database connection has been lost.*
*Re-establish database connection for:*
Can you please help how to resolve this issue.
Attached the screen shot for reference:
Appreciate your help in advance!
Thanks
*DB Visualizer Details:*
Product: DbVisualizer Pro 9.1.6
Build: #2117 (2014/01/26 21:20)
Java VM: Java HotSpot(TM) 64-Bit Server VM
Java Version: 1.7.0_45
Java Vendor: Oracle Corporation
OS Name: Windows 7
OS Arch: amd64
OS Version: 6.1
Murugan,
What database are you using and what JDBC driver?
Is you connection lost regularly or does it happen after some time of inactivity in DbVisualizer?
Regards
Roger
a
anonymous
said
almost 11 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Database connection has been lost Error
Thanks Roger!
I am using Neoview Data base and HPT4Driver-3.11 JDBC driver.
Connection is getting lost every time while executing the sql query in SQL commander, but I am able to browse the tables and see the rows from Explorer tree.
Hans Bergsten
said
almost 11 years ago
[This reply is migrated from our old forums.]
Re: Database connection has been lost Error
Hi Murugan,
I believe thus FAQ will help you resolve the problem:
http://confluence.dbvis.com/pages/viewpage.action?pageId=3146430
Best Regards,
Hans
a
anonymous
said
almost 11 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Database connection has been lost Error
Hi Hans,
I tried below option, still I am facing the same issue.
Thanks!
Hans Bergsten
said
almost 11 years ago
[This reply is migrated from our old forums.]
Re: Database connection has been lost Error
Hi Murugan,
Please enable debugging for DbVisualizer in Tools->Debug Window and then try to execute a query in the SQL Commander, and post or email us the debug output.
Best Regards,
Hans
a
anonymous
said
almost 11 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Database connection has been lost Error
Hi Hans,
Please find below my debug output:
------------------------- Product Information ------------------------
Product: DbVisualizer Pro 9.1.6
Build: #2117 (2014/01/26 21:20)
Java VM: Java HotSpot(TM) 64-Bit Server VM
Java Version: 1.7.0_45
Java Vendor: Oracle Corporation
OS Name: Windows 7
OS Arch: amd64
OS Version: 6.1
------------------------- Connected Databases ------------------------
Database Type: Generic
Major Version: 1
Minor Version: 4
Profile: generic
Connection Message:
HP Neoview Database
1.4
com.hp.jdbc.HPT4Driver
HP JDBC Version 3.4.0 Release 1.4.0 (Build release [29772])
--------------------------- Debug Printouts --------------------------
10:54:18 [DEBUG ExecutorRunner-pool-3-thread-1 G.?] Disconnecting: BER_EDW
10:54:18 [DEBUG pool-4-thread-2 C.?] RootConnection: HPT4Connection.close()
SQLState(08003) vendor code(-29002)
10:54:18 [DEBUG ExecutorRunner-pool-3-thread-1 G.?] Connection closed: BER_EDW
com.hp.jdbc.HPT4Exception: Connection does not exist
at com.hp.jdbc.HPT4Messages.createSQLException(HPT4Messages.java:283)
at com.hp.jdbc.HPT4Connection.validateConnection(HPT4Connection.java:80)
at com.hp.jdbc.HPT4Connection.getAutoCommit(HPT4Connection.java:242)
at com.onseven.dbvis.g.B.C.?(Z:344)
at com.onseven.dbvis.g.B.F$A.call(Z:1474)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
SQLState(08003) vendor code(-29002)
10:54:18 [DEBUG ExecutorRunner-pool-3-thread-1 G.?] Connecting: BER_EDW
10:54:18 [DEBUG ExecutorRunner-pool-3-thread-1 L.?] Loading class using dynamic ClassLoader: com.hp.jdbc.HPT4Driver
10:54:18 [DEBUG ExecutorRunner-pool-3-thread-1 L.?] Loading class using dynamic ClassLoader: com.hp.jdbc.HPT4Driver
10:54:18 [DEBUG pool-4-thread-2 D.?] RootConnection: HPT4Driver.acceptsURL("jdbc:hpt4jdbc://beryl-mxoas1.houston.hp.com:18650/:")
10:54:18 [DEBUG pool-4-thread-2 D.?] RootConnection: HPT4Driver.connect("jdbc:hpt4jdbc://beryl-mxoas1.houston.hp.com:18650/:", {user=************************, password=*************, url=jdbc:hpt4jdbc://beryl-mxoas1.houston.hp.com:18650/:, serverDataSource=BER_EDW})
10:54:21 [DEBUG pool-4-thread-2 C.?] RootConnection: HPT4Connection.setAutoCommit(true)
10:54:21 [DEBUG pool-4-thread-2 E.?] RootConnection: HPT4DatabaseMetaData.supportsTransactionIsolationLevel(1)
10:54:21 [DEBUG pool-4-thread-2 C.?] RootConnection: HPT4Connection.setTransactionIsolation(1)
10:54:21 [DEBUG ExecutorRunner-pool-3-thread-1 G.?] Using facade: generic for BER_EDW
10:54:21 [DEBUG pool-4-thread-2 E.?] RootConnection: HPT4DatabaseMetaData.getDatabaseProductName()
10:54:21 [DEBUG pool-4-thread-2 E.?] RootConnection: HPT4DatabaseMetaData.getDatabaseProductVersion()
10:54:21 [DEBUG pool-4-thread-2 E.?] RootConnection: HPT4DatabaseMetaData.getDriverName()
10:54:21 [DEBUG pool-4-thread-2 E.?] RootConnection: HPT4DatabaseMetaData.getDriverVersion()
10:54:21 [DEBUG pool-4-thread-2 E.?] RootConnection: HPT4DatabaseMetaData.getDriverName()
10:54:21 [DEBUG pool-4-thread-2 E.?] RootConnection: HPT4DatabaseMetaData.getDriverVersion()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] Loading profile C:\Program Files\DbVisualizer/resources/profiles\generic.xml
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 P.?] Setting attribute: desc="Generic profile for any database" for: DatabaseProfile
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 P.?] Setting attribute: version="$Revision: 17189 $" for: DatabaseProfile
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 P.?] Setting attribute: date="$Date: 2013-12-02 23:32:42 +0100 (Mån, 02 Dec 2013) $" for: DatabaseProfile
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 P.?] Setting attribute: minver="9.1" for: DatabaseProfile
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] no match: If "#db.getDatabaseType().equals('firebird')"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] no match: If "#db.getDatabaseType().equals('firebird')"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: Else "null"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: If "! #db.getDatabaseType().equals('firebird')"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] no match: If "#db.getDatabaseType().equals('firebird')"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] no match: If "#db.getDatabaseType().equals('firebird')"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: Else "null"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] no match: If "#db.getDatabaseType().equals('informix')"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}"
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 A.?] Profile merging and post processing: 0.038 secs
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 L.?] Using profile: generic
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 B.execute] Execute Command: getCatalogs
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 N.?] DbConnection: BER_EDW
10:54:22 [DEBUG pool-4-thread-2 E.?] RootConnection: HPT4DatabaseMetaData.getCatalogs()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 1 (java.lang.String) "TABLE_CAT" using getString()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 B.execute] Total rows/columns: 3/1. Rows after filtering: 3
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 B.execute] Execute Command: getSchemaNames
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 N.?] DbConnection: BER_EDW
10:54:22 [DEBUG pool-4-thread-2 E.?] RootConnection: HPT4DatabaseMetaData.getSchemas()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 1 (java.lang.String) "TABLE_SCHEM" using getString()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 2 (java.lang.String) "TABLE_CATALOG" using getString()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 B.execute] Total rows/columns: 46/2. Rows after filtering: 46
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 N.?] DbConnection: BER_EDW
10:54:22 [DEBUG pool-4-thread-2 E.?] RootConnection: HPT4DatabaseMetaData.getTypeInfo()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 1 (java.lang.String) "TYPE_NAME" using getString()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 2 (java.lang.Integer) "DATA_TYPE" using getInt()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 3 (java.lang.Integer) "PRECISION" using getInt()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 4 (java.lang.String) "LITERAL_PREFIX" using getString()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 5 (java.lang.String) "LITERAL_SUFFIX" using getString()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 6 (java.lang.String) "CREATE_PARAMS" using getString()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 7 (java.lang.Integer) "NULLABLE" using getInt()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 8 (java.lang.Integer) "CASE_SENSITIVE" using getInt()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 9 (java.lang.Integer) "SEARCHABLE" using getInt()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 10 (java.lang.Integer) "UNSIGNED_ATTRIBUTE" using getInt()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 11 (java.lang.Integer) "FIXED_PREC_SCALE" using getInt()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 12 (java.lang.Integer) "AUTO_INCREMENT" using getInt()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 13 (java.lang.String) "LOCAL_TYPE_NAME" using getString()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 14 (java.lang.Integer) "MINIMUM_SCALE" using getInt()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 15 (java.lang.Integer) "MAXIMUM_SCALE" using getInt()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 16 (java.lang.Integer) "SQL_DATA_TYPE" using getInt()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 17 (java.lang.Integer) "SQL_DATETIME_SUB" using getInt()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 18 (java.lang.Integer) "NUM_PREC_RADIX" using getInt()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 19 (java.lang.Integer) "INTERVAL_PRECISION" using getInt()
10:54:22 [DEBUG pool-4-thread-2 E.?] RootConnection: HPT4DatabaseMetaData.getDatabaseMajorVersion()
10:54:22 [DEBUG pool-4-thread-2 E.?] RootConnection: HPT4DatabaseMetaData.getDatabaseMinorVersion()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 P.getChildCount] getChildCount() for: BER_EDW in current thread
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 K.?] elementName: 'DataNode' label: '${getCatalogs.TABLE_CAT}' type: 'Catalog' on-empty-output: 'continue'
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 B.execute] Execute Command: getCatalogs
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 N.?] DbConnection: BER_EDW
10:54:22 [DEBUG pool-4-thread-2 E.?] RootConnection: HPT4DatabaseMetaData.getCatalogs()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 E.?] getting column 1 (java.lang.String) "TABLE_CAT" using getString()
10:54:22 [DEBUG ExecutorRunner-pool-3-thread-1 B.execute] Total rows/columns: 3/1. Rows after filtering: 3
Hans Bergsten
said
almost 11 years ago
[This reply is migrated from our old forums.]
Re: Database connection has been lost Error
Hi Murugan,
I'm sure I'm missing something but this log seems to show output from a reconnect, not from running a query in the SQL Commander. Can you please clarify what you did to generate this, and what problem you see?
Best Regards,
Hans
anonymous
[Attachment has been removed.]
1 person has this question