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.