Hi, The "unexpected status" exception usually occurs if you have "incompatible" H2 client and server. You should to ensure all applications that use H2 are using a similar version.
Background: in theory, old and new versions of H2 should work together (old server with new client, new server with old client), because when they connect, they have a handshake to define which protocol version to use. However, in some versions of H2 there was a bug where the protocol version was not checked correctly in some cases. Regards, Thomas On Wed, Oct 7, 2015 at 6:04 PM, Dipan Bhattacharyya <[email protected] <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > Hi All, > > I am facing a similar problem with H2 running in the Automatic Mixed mode. > Let me provide the context first. > 1. Using H2 as the database in a Spring MVC App, with MyBatis ORM (via > MyBatis-Spring) with data source ppoled using HirakiCP > 2. Spring version 4.1.6-RELEASE. > 3. MyBatis-Spring - 1.2.3 > 4. Mybatis - 3.3.0 > 5. HirakiCP - 2.4.1 > 6. H2 - 1.4.189 > > I am using H2 in an encrypted mode. The URL > is > jdbc:h2:file:$dbhome}/databases/${dbname};CIPHER=AES;IFEXISTS=TRUE;AUTO_SERVER=TRUE > The app runs fine when I start it up. With the App running, when I try to > connect my IDE (IntelliJ IDEA 14 Ultimate) to the database, with exactly > the same URL, I get an error: "unexpected status 16843008", and the IDE > fails to connect. > > When I restart the app again, this time WITHOUT the "AUTO_SERVER=TRUE" > directive, both the app and the IDE (which is also now changed to remove > the AUTO_SERVER directive) connect and work fine. > > As of now - this setup provides me with the intended functionality. > However, is this the right way? I am planning to deploy a few > auto-scheduled spring batch jobs that connect to this database, so I am > keen to ensure that I do it the right way. > > I posted this in the same thread because the topic is the same. I hope > that is the right thing to do. I can post it separately as well if that is > required. > > Thanks! > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
