hello trying a work around to export datas with dbvisalizer can't connect (but can ping) with :
database
setting format : server info
type : auto detect (H2)
driver : h2 server
server : localhost
port : 8082
filename : ~/myh2 (given by the wizzard)
authentification
userid : sa
password : (null) or blank
option
auto commit yes
result :
An error occurred while establishing the connection:
Long Message:
Connection is broken: "unexpected status 1213486160" [90067-176]
Details:
Type: org.h2.jdbc.JdbcSQLException
Error Code: 90067
SQL State: 90067
any idea ? must have for me since i need to export the data to ms access
thanks for your great job
found what was wrong the driver must be H2 embedded; so correct connection setup is :
database
setting format : server info
type : auto detect (H2)
driver : h2 embedded
filename : ~/myh2 (given by the wizzard)
authentification
userid : sa
password : "(null)" > type the whole text between ""
then to export datas follow instructions on http://confluence.dbvis.com/display/UG91/Exporting+Query+Results
OK, so the problem is solved, right? Thanks for sharing the information by the way.
hello trying a work around to export datas with dbvisalizer can't connect (but can ping) with :
database
setting format : server info
type : auto detect (H2)
driver : h2 server
server : localhost
port : 8082
filename : ~/myh2 (given by the wizzard)
authentification
userid : sa
password : (null) or blank
option
auto commit yes
result :
An error occurred while establishing the connection:
Long Message:
Connection is broken: "unexpected status 1213486160" [90067-176]
Details:
Type: org.h2.jdbc.JdbcSQLException
Error Code: 90067
SQL State: 90067
any idea ? must have for me since i need to export the data to ms access
thanks for your great job