Start a new topic

Database connection has been lost Error

[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

1 person has this question

[This reply is migrated from our old forums.]

Re: Database connection has been lost Error
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
[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.
[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
[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!
[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
[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
[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