error executing mvn sonar:sonar: 'Incorrect string value: '...' for column 'data' at row 1'

Hello,

When I try to execute

mvn sonar:sonar

I get the following error (full stack trace below):

Caused by: java.sql.SQLException: Incorrect string value:
'\xF0\x93\xB1\x93\xEF\xBF...' for column 'data' at row 1
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
       

I have Sonar setup to use MySQL and it is apparently connecting fine
(I can see http://localhost:9000/projects) but for some reason the
maven plugin fails to insert in the database. I used the following
command to create the database:

CREATE DATABASE sonar CHARACTER SET utf8 COLLATE utf8_general_ci;

I am guessing this has something to do with the source files' encoding,
but I am not sure what I have to configure to get it working.

My source encoding is Shift_JIS (Japanese). I tried setting
-Dfile.encoding=Shift_JIS in MAVEN_OPTS, but that didn't help.
I also have this in my root pom, but it doesn't seem to make
a difference:

<properties>
  <project.build.sourceEncoding>Shift_JIS</project.build.sourceEncoding>
</properties>

Any pointers are much appreciated.


An here is the full stack trace:



[INFO] myapp webapp [class org.sonar.plugins.squid.SquidMavenCollector]
executing
[INFO] myapp webapp Starting audit...
[INFO] myapp webapp Audit done.
[INFO] myapp webapp [class
org.sonar.plugins.core.SaveProfileMavenCollector] executing
[INFO] myapp webapp [class
org.sonar.plugins.core.sources.ImportJavaSourcesMavenCollector] executing
[WARN] myapp webapp SQL Error: 1366, SQLState: HY000
[ERROR] myapp webapp Incorrect string value:
'\xF0\x93\xB1\x93\xEF\xBF...' for column 'data' at row 1
[INFO]
------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO]
------------------------------------------------------------------------
[INFO] Can not execute Sonar

Embedded error: org.hibernate.exception.GenericJDBCException: could not
insert: [org.sonar.commons.resources.SnapshotSource]
Incorrect string value: '\xF0\x93\xB1\x93\xEF\xBF...' for column 'data'
at row 1
[INFO]
------------------------------------------------------------------------
[INFO] Trace
org.apache.maven.lifecycle.LifecycleExecutionException: Can not execute
Sonar
        at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:703)
        at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:553)
        at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:523)
        at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:371)
        at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:268)
        at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:181)
        at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:356)
        at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:137)
        at org.apache.maven.cli.MavenCli.main(MavenCli.java:356)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
        at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
        at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
        at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
Caused by: org.apache.maven.plugin.MojoExecutionException: Can not
execute Sonar
        at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:87)
        at org.codehaus.mojo.sonar.Bootstraper.start(Bootstraper.java:65)
        at org.codehaus.mojo.sonar.SonarMojo.execute(SonarMojo.java:117)
        at
org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:483)
        at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:678)
        ... 16 more
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.GenericJDBCException: could not insert:
[org.sonar.commons.resources.SnapshotSource]
        at
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:630)
        at
org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:219)
        at
org.sonar.commons.database.DatabaseSession.internalSave(DatabaseSession.java:116)
        at org.sonar.commons.database.DatabaseSession.save(DatabaseSession.java:93)
        at org.sonar.mojo.ProjectContextImpl.addSource(ProjectContextImpl.java:170)
        at
org.sonar.plugins.api.maven.AbstractImportSourceMavenCollector.parseFiles(AbstractImportSourceMavenCollector.java:79)
        at
org.sonar.plugins.api.maven.AbstractImportSourceMavenCollector.parseSourceDirs(AbstractImportSourceMavenCollector.java:64)
        at
org.sonar.plugins.api.maven.AbstractImportSourceMavenCollector.collect(AbstractImportSourceMavenCollector.java:55)
        at org.sonar.mojo.InternalMojo.executeCollectors(InternalMojo.java:295)
        at org.sonar.mojo.InternalMojo.processModules(InternalMojo.java:177)
        at org.sonar.mojo.InternalMojo.execute(InternalMojo.java:156)
        at
org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:483)
        at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:82)
        ... 20 more
Caused by: org.hibernate.exception.GenericJDBCException: could not
insert: [org.sonar.commons.resources.SnapshotSource]
        at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2163)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2643)
        at
org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
        at
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
        at
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
        at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
        at
org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:49)
        at
org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:131)
        at
org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:87)
        at
org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:38)
        at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:618)
        at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:592)
        at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:596)
        at
org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:213)
        ... 31 more
Caused by: java.sql.SQLException: Incorrect string value:
'\xF0\x93\xB1\x93\xEF\xBF...' for column 'data' at row 1
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
        at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
        at
org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
        at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
        ... 46 more
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 1 minute 15 seconds
[INFO] Finished at: Mon Jun 29 15:15:35 JST 2009
[INFO] Final Memory: 32M/57M
[INFO]
------------------------------------------------------------------------
Finished: FAILURE


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email