icescrum on ec2 tomcat7 connect to rds mysql5.6

[Kagilum]

Hi All,

I have icescum working on the internal db, but I can not get it to work to a rds mysql 5.6 version.
Any pointers would be great,
thx
Art

The webapp seems to fail on an sql insert, catalina.out showing

014-06-26 17:08:53,377 [localhost-startStop-1] ERROR context.ContextLoader  - Context initialization failed

org.springframework.beans.factory.access.BootstrapException: Error executing bootstraps; nested exception is org.springframework.dao.DataIntegrityViolationException: could not insert: [org.icescrum.core.domain.User]; SQL [insert into icescrum2_user (version, account_expired, account_external, account_locked, date_created, email, enabled, first_name, last_name, last_updated, passwd, password_expired, preferences_id, uid, username) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not insert: [org.icescrum.core.domain.User]

at org.codehaus.groovy.grails.web.context.GrailsContextLoader.createWebApplicationContext(GrailsContextLoader.java:87)

at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)

at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)

at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:983)

at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1660)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

at java.util.concurrent.FutureTask.run(FutureTask.java:262)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:744)

Caused by: org.springframework.dao.DataIntegrityViolationException: could not insert: [org.icescrum.core.domain.User]; SQL [insert into icescrum2_user (version, account_expired, account_external, account_locked, date_created, email, enabled, first_name, last_name, last_updated, passwd, password_expired, preferences_id, uid, username) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not insert: [org.icescrum.core.domain.User]

at org.icescrum.core.security.AuthorityManager$__clinit__closure1.doCall(AuthorityManager.groovy:43)

at org.icescrum.core.security.AuthorityManager$__clinit__closure2.doCall(AuthorityManager.groovy:58)

at org.icescrum.core.services.BootStrapService.start(BootStrapService.groovy:45)

at org.icescrum.core.services.BootStrapService$$FastClassByCGLIB$$79776cdd.invoke()

at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)

at org.icescrum.core.services.BootStrapService$$EnhancerByCGLIB$$d4a9b368.start()

at org.icescrum.core.services.BootStrapService$start.call(Unknown Source)

at IcescrumCoreGrailsPlugin$_closure4.doCall(IcescrumCoreGrailsPlugin.groovy:341)

... 5 more

Caused by: org.hibernate.exception.DataException: could not insert: [org.icescrum.core.domain.User]

at com.sun.proxy.$Proxy28.saveOrUpdate(Unknown Source)

... 13 more

Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'date_created' at row 1

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2973)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)

at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1129)

at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:681)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1268)

... 14 more

[Nicolas Noullet]

Hi

That’s the first time I see this error.

Could you provide your config.groovy (with obfuscated passwords)?

What version of Tomcat and Java do you use?

[Author]

Posts