| 
Sonar user

 « Return to Thread: can not autodetect the dialect

Re: can not autodetect the dialect

by snow75 :: Rate this Message:

Reply to Author | View in Thread

thanks Simon for your answer, but I got another error:

16:11:23.962 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 17002, SQLState: null
16:11:23.962 ERROR o.h.util.JDBCExceptionReporter - Exception d'E/S: Socket closed
16:11:23.962 ERROR o.h.e.d.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
    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.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
    at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
    at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
    at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2229)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2665)
    at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:60)
    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
    at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:297)
    at org.sonar.commons.database.BatchDatabaseManager.flush(BatchDatabaseManager.java:115)
    at org.sonar.commons.database.BatchDatabaseManager.commit(BatchDatabaseManager.java:60)
    at org.sonar.commons.database.BatchDatabaseManager.stop(BatchDatabaseManager.java:50)
    at org.sonar.commons.DaoFacade.stop(DaoFacade.java:47)
    at org.sonar.commons.DaoFacade.finalize(DaoFacade.java:79)
    at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
    at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)
    at java.lang.ref.Finalizer.access$100(Finalizer.java:14)
    at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)
Caused by: java.sql.SQLException: Exception d'E/S: Socket closed
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
    at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3695)
    at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:618)
    at oracle.jdbc.driver.OracleStatement.open(OracleStatement.java:575)
    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:4108)
    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
    ... 22 common frames omitted



I wrote this in my settings.xml:
<profile>
            <id>sonar</id>
            <activation>
                <activeByDefault>true</activeByDefault>
            </activation>
            <properties>
                <sonar.jdbc.url>jdbc:oracle:thin:@localhost:1521:XE</sonar.jdbc.url>
                <sonar.jdbc.driver>oracle.jdbc.driver.OracleDriver</sonar.jdbc.driver>
                <sonar.jdbc.username>sonar</sonar.jdbc.username>
                <sonar.jdbc.password>sonar</sonar.jdbc.password>

                <!-- SERVER ON A REMOTE HOST -->
                <!--<sonar.host.url>http://myserver:1234</sonar.host.url>-->
            </properties>
    </profile>

thanks


2008/11/17 Simon Brandhof <simon.brandhof@...>
Hi,

You forgot to configure maven2, like described in step 4 of the
installation guide. This one-shot configuration is needed even on
non-maven projects.

Regards

On Mon, Nov 17, 2008 at 4:01 PM, ilazaar ilazaar <ilazaar@...> wrote:
>
> Hi,
>
> I'm using oracle, I added the ojdbc14.jar in extensions/jdbc-driver/oracle,  sonar has created in my database tables like: users, schema_info, rules ...etc. On my project i'm not using maven2 but I added a pom.xml as shown in the guide of installation. when I tried to build my project, I got the following error:
> [INFO] [sonar-core:prepare]
> [ERROR] Cannot execute the command org.codehaus.sonar:sonar-core-maven-plugin:1.4.3:prepare
> javax.persistence.PersistenceException: can not autodetect the dialect
>     at org.sonar.commons.database.AbstractDatabaseConnector.getDialect(AbstractDatabaseConnector.java:169)
>     at org.sonar.commons.database.DriverDatabaseConnector.getEntityManagerFactory(DriverDatabaseConnector.java:110)
>     at org.sonar.commons.database.DriverDatabaseConnector.createEntityManager(DriverDatabaseConnector.java:138)
>     at org.sonar.commons.database.BatchDatabaseManager.start(BatchDatabaseManager.java:45)
>     at org.sonar.commons.DaoFacade.<init>(DaoFacade.java:39)
>     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>     at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>     at org.picocontainer.injectors.AbstractInjector.newInstance(AbstractInjector.java:149)
>     at org.picocontainer.injectors.ConstructorInjector.instantiate(ConstructorInjector.java:196)
>     at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInjector.java:169)
>     at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:263)
>     at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(ConstructorInjector.java:192)
>     at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:66)
>     at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:85)
>     at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:62)
>     at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:875)
>     at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:641)
>     at ch.hortis.sonar.mvn.CoreMojo.getContainer(CoreMojo.java:239)
>     at ch.hortis.sonar.mvn.PrepareMojo.checkPluginsPresenceForProjectLanguage(PrepareMojo.java:147)
>     at ch.hortis.sonar.mvn.PrepareMojo.doExecute(PrepareMojo.java:46)
>     at ch.hortis.sonar.mvn.CoreMojo.execute(CoreMojo.java:130)
>     at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:451)
>     at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:558)
>     at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:512)
>     at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:482)
>     at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:330)
>     at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:291)
>     at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142)
>     at ch.hortis.sonar.mvn.SonarMavenEmbedder.execute(SonarMavenEmbedder.java:151)
>     at ch.hortis.sonar.mvn.SonarMojo.executeMaven(SonarMojo.java:248)
>     at ch.hortis.sonar.mvn.SonarMojo.executeGoals(SonarMojo.java:231)
>     at ch.hortis.sonar.mvn.SonarMojo.execute(SonarMojo.java:116)
>     at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:451)
>     at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:558)
>     at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:512)
>     at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:482)
>     at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:330)
>     at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:227)
>     at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142)
>     at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:336)
>     at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:129)
>     at org.apache.maven.cli.MavenCli.main(MavenCli.java:287)
>     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:597)
>     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: java.sql.SQLException: SQL driver not found org.apache.derby.jdbc.ClientDriver
>     at org.sonar.commons.database.DriverDatabaseConnector.getConnection(DriverDatabaseConnector.java:87)
>     at org.sonar.commons.database.AbstractDatabaseConnector.getDialect(AbstractDatabaseConnector.java:165)
>     ... 51 more
> [INFO] ------------------------------------------------------------------------
> [ERROR] BUILD ERROR
> [INFO] ------------------------------------------------------------------------
> [INFO] Cannot execute the command org.codehaus.sonar:sonar-core-maven-plugin:1.4.3:prepare
>
> Embedded error: can not autodetect the dialect
> SQL driver not found org.apache.derby.jdbc.ClientDriver
>
>
> Thanks for your help



--
Simon Brandhof
Hortis, Consulting & Innovation team
Sonar, embrace Quality - http://sonar.codehaus.org

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

   http://xircles.codehaus.org/manage_email



 « Return to Thread: can not autodetect the dialect

Free embeddable forum powered by Nabble Forum Help