wiew and export data with DbVisualizer

regis8 years ago

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

regis8 years ago

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

Anton Tananaev8 years ago

OK, so the problem is solved, right? Thanks for sharing the information by the way.