we have a custom database engine that also provides an (almost) jdbc compliant driver.
Browsing the schema with generic type works correctly (table names are listed, table rows show up, etc)
Unfortunately, running any sql command from within the sql editor results in the windows with connection not up and please reconnect (and it doesn't) due to:
FINE 367 [ExecutorRunner-pool-4-thread-8 - AbstractFacade.isValid] isValid() check returned false. Physical connection: 'RootConnection' for: 'IBSUAT2'
Browser doesn't seem to check isvalid (because it works).
Any way to disable isValid checking for sql editor ? Tried single physical connection and still doesn't work (so it is sql editor specific).
Best Answer
R
Roger Bjärevall
said
over 8 years ago
Andrei,
Please check the following article how to setup a custom statement for the isValid check.
andrei.muresanu@gmail.com
Hi,
we have a custom database engine that also provides an (almost) jdbc compliant driver.
Browsing the schema with generic type works correctly (table names are listed, table rows show up, etc)
Unfortunately, running any sql command from within the sql editor results in the windows with connection not up and please reconnect (and it doesn't) due to:
FINE 367 [ExecutorRunner-pool-4-thread-8 - AbstractFacade.isValid] isValid() check returned false. Physical connection: 'RootConnection' for: 'IBSUAT2'
Browser doesn't seem to check isvalid (because it works).
Any way to disable isValid checking for sql editor ? Tried single physical connection and still doesn't work (so it is sql editor specific).
Andrei,
Please check the following article how to setup a custom statement for the isValid check.
http://support.dbvis.com/solution/articles/1000196590-any-statement-i-execute-in-the-sql-commander-results-in-database-connection-is-not-open-
Regards
Roger
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstRoger Bjärevall
Andrei,
Please check the following article how to setup a custom statement for the isValid check.
http://support.dbvis.com/solution/articles/1000196590-any-statement-i-execute-in-the-sql-commander-results-in-database-connection-is-not-open-
Regards
Roger
andrei.muresanu@gmail.com
-
Forward Engineering
-
DB2 Database Connection Dropping every 20-30mins or so ?
-
roles are not unfolded
-
Install4j: Java(Tm) VM could not be started
-
Worksheet name default when exporting to Excel?
-
sqlformatter and extract
-
Bug with empty password
-
dbvis 5.0 gives error after opening
-
Saving file makes it incompatible with other SQL tools!!!?!?!?!?
-
Error Schema Name in References view.
See all 1316 topics