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].
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.

Reply via email to