I'm using a small spring boot application. I'm using Spring JdbcTemplate to
access h2 db 1.4.186.
When I try to make an insert in the db I've this exception.
I don't understand why poolableConnectionFactory is not supported. Maybe it
is not with autoserver=true?
Thanks
17/03/2015 09:40:44 ERROR InboundSmsHandler:78 -
org.springframework.transaction.CannotCreateTransactionException: Could not
open JDBC Connection for transaction; nested exception is java.sql.
SQLException: Cannot create PoolableConnectionFactory (Feature not supported
: "autoServerMode && (readOnly || fileLockMethod == NO ||
fileLockMethod == SERIALIZED || inMemory)" [50100-186])
at org.springframework.jdbc.datasource.DataSourceTransactionManager.
doBegin(DataSourceTransactionManager.java:245)
at org.springframework.transaction.support.
AbstractPlatformTransactionManager.getTransaction(
AbstractPlatformTransactionManager.java:373)
at org.springframework.transaction.interceptor.
TransactionAspectSupport.createTransactionIfNecessary(
TransactionAspectSupport.java:463)
at org.springframework.transaction.interceptor.
TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.
java:276)
at org.springframework.transaction.interceptor.
TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.
proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.
CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
at it.service.SmsDao$$EnhancerBySpringCGLIB$$7bf52b4c.
saveInboundMessage(<generated>)
at it.smshandler.InboundSmsHandler.process(InboundSmsHandler.java:49
)
at org.smslib.threading.CallbackManager$CallbackManagerDispatcher.
run(CallbackManager.java:240)
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (
Feature not supported: "autoServerMode && (readOnly || fileLockMethod == NO
|| fileLockMethod == SERIALIZED || inMemory)" [50100-186])
at org.apache.commons.dbcp2.BasicDataSource.
createPoolableConnectionFactory(BasicDataSource.java:2152)
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(
BasicDataSource.java:1903)
at org.apache.commons.dbcp2.BasicDataSource.getConnection(
BasicDataSource.java:1413)
at org.springframework.jdbc.datasource.DataSourceTransactionManager.
doBegin(DataSourceTransactionManager.java:204)
... 9 more
Caused by: org.h2.jdbc.JdbcSQLException: Feature not supported: "autoServerMode
&& (readOnly || fileLockMethod == NO || fileLockMethod == SERIALIZED ||
inMemory)" [50100-186]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.message.DbException.getUnsupportedException(DbException.
java:216)
at org.h2.engine.Database.open(Database.java:616)
at org.h2.engine.Database.openDatabase(Database.java:266)
at org.h2.engine.Database.<init>(Database.java:260)
at org.h2.engine.Engine.openSession(Engine.java:60)
at org.h2.engine.Engine.openSession(Engine.java:167)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)
at org.h2.engine.Engine.createSession(Engine.java:128)
at org.h2.engine.Engine.createSession(Engine.java:26)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote
.java:347)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92)
at org.h2.Driver.connect(Driver.java:72)
at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection
(DriverConnectionFactory.java:39)
at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(
PoolableConnectionFactory.java:205)
at org.apache.commons.dbcp2.BasicDataSource.
validateConnectionFactory(BasicDataSource.java:2162)
at org.apache.commons.dbcp2.BasicDataSource.
createPoolableConnectionFactory(BasicDataSource.java:2148)
... 12 more
17/03/2015 09:40:44 ERROR CallbackManager:245 - Error in
InboundMessageCallback!
--
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.
