can not autodetect the dialect

View: New views
13 Messages — Rating Filter:   Alert me  

can not autodetect the dialect

by snow75 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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

Re: can not autodetect the dialect

by Simon Brandhof-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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



Re: can not autodetect the dialect

by snow75 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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




Re: can not autodetect the dialect

by Simon Brandhof-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

What are your database and driver versions ?

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

    http://xircles.codehaus.org/manage_email



Re: can not autodetect the dialect

by snow75 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

i'm using Oracle Database 10g Express Edition and ojdbc14 and I got the following errors too if it helps:

[pmd:cpd]
[INFO] ------------------------------------------------------------------------
[INFO] Building B4ONE
[INFO]    task-segment: [org.codehaus.sonar:sonar-core-maven-plugin:1.4.3:collect]
[INFO] ------------------------------------------------------------------------
[INFO] snapshot org.codehaus.sonar.runtime:jdbc-driver:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.jdbc-driver:jdbc-driver_ext_0:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime:plugins:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_0:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_1:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_2:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_3:1.0-SNAPSHOT: checking for updates from sonar
[INFO] [sonar-core:collect]
16:11:23.831 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 17090, SQLState: null
16:11:23.832 ERROR o.h.util.JDBCExceptionReporter - opération interdite: streams type cannot be used in batching
16:11:23.833 ERROR o.h.e.d.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not insert: [ch.hortis.sonar.model.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.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2272)
    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.save(BatchDatabaseManager.java:84)
    at org.sonar.plugins.java.JavaMeasuresRecorder.createClassSource(JavaMeasuresRecorder.java:80)
    at org.sonar.plugins.sources.SourcesJavaMavenCollector.parseDirectory(SourcesJavaMavenCollector.java:66)
    at org.sonar.plugins.sources.SourcesJavaMavenCollector.collect(SourcesJavaMavenCollector.java:51)
    at org.sonar.maven.CollectMojo.doExecute(CollectMojo.java:73)
    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: opération interdite: streams type cannot be used in batching
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
    at oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:3999)
    at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:31)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)
    ... 45 common frames omitted
16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation de contrainte unique (SONAR.SYS_C004093)

16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation de contrainte unique (SONAR.SYS_C004093)

.....


2008/11/17 Simon Brandhof <simon.brandhof@...>
What are your database and driver versions ?

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

   http://xircles.codehaus.org/manage_email




Re: can not autodetect the dialect

by Cédric Munger :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

OK got an hint for you : to my knowledge, the message 'streams type cannot be used in batching' indicates that you're using an old oracle JDBC driver version. Try to upgrade it and it should fix the issue. Please let us know.

Regards

On Mon, Nov 17, 2008 at 4:31 PM, ilazaar ilazaar <ilazaar@...> wrote:
i'm using Oracle Database 10g Express Edition and ojdbc14 and I got the following errors too if it helps:

[pmd:cpd]
[INFO] ------------------------------------------------------------------------
[INFO] Building B4ONE
[INFO]    task-segment: [org.codehaus.sonar:sonar-core-maven-plugin:1.4.3:collect]
[INFO] ------------------------------------------------------------------------
[INFO] snapshot org.codehaus.sonar.runtime:jdbc-driver:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.jdbc-driver:jdbc-driver_ext_0:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime:plugins:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_0:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_1:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_2:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_3:1.0-SNAPSHOT: checking for updates from sonar
[INFO] [sonar-core:collect]
16:11:23.831 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 17090, SQLState: null
16:11:23.832 ERROR o.h.util.JDBCExceptionReporter - opération interdite: streams type cannot be used in batching
16:11:23.833 ERROR o.h.e.d.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not insert: [ch.hortis.sonar.model.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.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2272)

    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.save(BatchDatabaseManager.java:84)
    at org.sonar.plugins.java.JavaMeasuresRecorder.createClassSource(JavaMeasuresRecorder.java:80)
    at org.sonar.plugins.sources.SourcesJavaMavenCollector.parseDirectory(SourcesJavaMavenCollector.java:66)
    at org.sonar.plugins.sources.SourcesJavaMavenCollector.collect(SourcesJavaMavenCollector.java:51)
    at org.sonar.maven.CollectMojo.doExecute(CollectMojo.java:73)

    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: opération interdite: streams type cannot be used in batching

    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
    at oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:3999)
    at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:31)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)
    ... 45 common frames omitted
16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation de contrainte unique (SONAR.SYS_C004093)

16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation de contrainte unique (SONAR.SYS_C004093)

.....


2008/11/17 Simon Brandhof <simon.brandhof@...>
What are your database and driver versions ?


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

   http://xircles.codehaus.org/manage_email





Re: can not autodetect the dialect

by Cédric Munger :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Give a try to version 10.2.0.4 at http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html
Please don't forget to recreate the database from scratch. Maybe that the old driver did some mess in the data of the current one.

Regards

On Mon, Nov 17, 2008 at 4:53 PM, Cédric Munger <cedric.munger@...> wrote:
OK got an hint for you : to my knowledge, the message 'streams type cannot be used in batching' indicates that you're using an old oracle JDBC driver version. Try to upgrade it and it should fix the issue. Please let us know.

Regards


On Mon, Nov 17, 2008 at 4:31 PM, ilazaar ilazaar <ilazaar@...> wrote:
i'm using Oracle Database 10g Express Edition and ojdbc14 and I got the following errors too if it helps:

[pmd:cpd]
[INFO] ------------------------------------------------------------------------
[INFO] Building B4ONE
[INFO]    task-segment: [org.codehaus.sonar:sonar-core-maven-plugin:1.4.3:collect]
[INFO] ------------------------------------------------------------------------
[INFO] snapshot org.codehaus.sonar.runtime:jdbc-driver:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.jdbc-driver:jdbc-driver_ext_0:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime:plugins:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_0:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_1:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_2:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_3:1.0-SNAPSHOT: checking for updates from sonar
[INFO] [sonar-core:collect]
16:11:23.831 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 17090, SQLState: null
16:11:23.832 ERROR o.h.util.JDBCExceptionReporter - opération interdite: streams type cannot be used in batching
16:11:23.833 ERROR o.h.e.d.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not insert: [ch.hortis.sonar.model.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.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2272)

    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.save(BatchDatabaseManager.java:84)
    at org.sonar.plugins.java.JavaMeasuresRecorder.createClassSource(JavaMeasuresRecorder.java:80)
    at org.sonar.plugins.sources.SourcesJavaMavenCollector.parseDirectory(SourcesJavaMavenCollector.java:66)
    at org.sonar.plugins.sources.SourcesJavaMavenCollector.collect(SourcesJavaMavenCollector.java:51)
    at org.sonar.maven.CollectMojo.doExecute(CollectMojo.java:73)

    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: opération interdite: streams type cannot be used in batching

    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
    at oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:3999)
    at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:31)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)
    ... 45 common frames omitted
16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation de contrainte unique (SONAR.SYS_C004093)

16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation de contrainte unique (SONAR.SYS_C004093)

.....


2008/11/17 Simon Brandhof <simon.brandhof@...>
What are your database and driver versions ?


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

   http://xircles.codehaus.org/manage_email






Re: can not autodetect the dialect

by snow75 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

ok thanks cédric, i'm doing it ... I will let you know


2008/11/17 Cédric Munger <cedric.munger@...>
Give a try to version 10.2.0.4 at http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html
Please don't forget to recreate the database from scratch. Maybe that the old driver did some mess in the data of the current one.

Regards


On Mon, Nov 17, 2008 at 4:53 PM, Cédric Munger <cedric.munger@...> wrote:
OK got an hint for you : to my knowledge, the message 'streams type cannot be used in batching' indicates that you're using an old oracle JDBC driver version. Try to upgrade it and it should fix the issue. Please let us know.

Regards


On Mon, Nov 17, 2008 at 4:31 PM, ilazaar ilazaar <ilazaar@...> wrote:
i'm using Oracle Database 10g Express Edition and ojdbc14 and I got the following errors too if it helps:

[pmd:cpd]
[INFO] ------------------------------------------------------------------------
[INFO] Building B4ONE
[INFO]    task-segment: [org.codehaus.sonar:sonar-core-maven-plugin:1.4.3:collect]
[INFO] ------------------------------------------------------------------------
[INFO] snapshot org.codehaus.sonar.runtime:jdbc-driver:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.jdbc-driver:jdbc-driver_ext_0:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime:plugins:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_0:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_1:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_2:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_3:1.0-SNAPSHOT: checking for updates from sonar
[INFO] [sonar-core:collect]
16:11:23.831 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 17090, SQLState: null
16:11:23.832 ERROR o.h.util.JDBCExceptionReporter - opération interdite: streams type cannot be used in batching
16:11:23.833 ERROR o.h.e.d.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not insert: [ch.hortis.sonar.model.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.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2272)

    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.save(BatchDatabaseManager.java:84)
    at org.sonar.plugins.java.JavaMeasuresRecorder.createClassSource(JavaMeasuresRecorder.java:80)
    at org.sonar.plugins.sources.SourcesJavaMavenCollector.parseDirectory(SourcesJavaMavenCollector.java:66)
    at org.sonar.plugins.sources.SourcesJavaMavenCollector.collect(SourcesJavaMavenCollector.java:51)
    at org.sonar.maven.CollectMojo.doExecute(CollectMojo.java:73)

    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: opération interdite: streams type cannot be used in batching

    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
    at oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:3999)
    at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:31)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)
    ... 45 common frames omitted
16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation de contrainte unique (SONAR.SYS_C004093)

16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation de contrainte unique (SONAR.SYS_C004093)

.....


2008/11/17 Simon Brandhof <simon.brandhof@...>
What are your database and driver versions ?


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

   http://xircles.codehaus.org/manage_email







Re: can not autodetect the dialect

by snow75 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I upgraded the jdbc to ojbc6.jar , I used the following link: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_111060.html and it Works !!!! thank you so much guys ...

2008/11/17 ilazaar ilazaar <ilazaar@...>
ok thanks cédric, i'm doing it ... I will let you know


2008/11/17 Cédric Munger <cedric.munger@...>

Give a try to version 10.2.0.4 at http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html
Please don't forget to recreate the database from scratch. Maybe that the old driver did some mess in the data of the current one.

Regards


On Mon, Nov 17, 2008 at 4:53 PM, Cédric Munger <cedric.munger@...> wrote:
OK got an hint for you : to my knowledge, the message 'streams type cannot be used in batching' indicates that you're using an old oracle JDBC driver version. Try to upgrade it and it should fix the issue. Please let us know.

Regards


On Mon, Nov 17, 2008 at 4:31 PM, ilazaar ilazaar <ilazaar@...> wrote:
i'm using Oracle Database 10g Express Edition and ojdbc14 and I got the following errors too if it helps:

[pmd:cpd]
[INFO] ------------------------------------------------------------------------
[INFO] Building B4ONE
[INFO]    task-segment: [org.codehaus.sonar:sonar-core-maven-plugin:1.4.3:collect]
[INFO] ------------------------------------------------------------------------
[INFO] snapshot org.codehaus.sonar.runtime:jdbc-driver:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.jdbc-driver:jdbc-driver_ext_0:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime:plugins:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_0:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_1:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_2:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_3:1.0-SNAPSHOT: checking for updates from sonar
[INFO] [sonar-core:collect]
16:11:23.831 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 17090, SQLState: null
16:11:23.832 ERROR o.h.util.JDBCExceptionReporter - opération interdite: streams type cannot be used in batching
16:11:23.833 ERROR o.h.e.d.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not insert: [ch.hortis.sonar.model.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.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2272)

    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.save(BatchDatabaseManager.java:84)
    at org.sonar.plugins.java.JavaMeasuresRecorder.createClassSource(JavaMeasuresRecorder.java:80)
    at org.sonar.plugins.sources.SourcesJavaMavenCollector.parseDirectory(SourcesJavaMavenCollector.java:66)
    at org.sonar.plugins.sources.SourcesJavaMavenCollector.collect(SourcesJavaMavenCollector.java:51)
    at org.sonar.maven.CollectMojo.doExecute(CollectMojo.java:73)

    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: opération interdite: streams type cannot be used in batching

    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
    at oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:3999)
    at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:31)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)
    ... 45 common frames omitted
16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation de contrainte unique (SONAR.SYS_C004093)

16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation de contrainte unique (SONAR.SYS_C004093)

.....


2008/11/17 Simon Brandhof <simon.brandhof@...>
What are your database and driver versions ?


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

   http://xircles.codehaus.org/manage_email








Re: can not autodetect the dialect

by Cédric Munger :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Ok good news,
Note that ojbc6.jar is for 11g not 10g. I hope it will not bring other jdbc driver issues :)
Enjoy sonar :)

Regards.


On Mon, Nov 17, 2008 at 5:35 PM, ilazaar ilazaar <ilazaar@...> wrote:
I upgraded the jdbc to ojbc6.jar , I used the following link: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_111060.html and it Works !!!! thank you so much guys ...

2008/11/17 ilazaar ilazaar <ilazaar@...>

ok thanks cédric, i'm doing it ... I will let you know


2008/11/17 Cédric Munger <cedric.munger@...>

Give a try to version 10.2.0.4 at http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html
Please don't forget to recreate the database from scratch. Maybe that the old driver did some mess in the data of the current one.

Regards


On Mon, Nov 17, 2008 at 4:53 PM, Cédric Munger <cedric.munger@...> wrote:
OK got an hint for you : to my knowledge, the message 'streams type cannot be used in batching' indicates that you're using an old oracle JDBC driver version. Try to upgrade it and it should fix the issue. Please let us know.

Regards


On Mon, Nov 17, 2008 at 4:31 PM, ilazaar ilazaar <ilazaar@...> wrote:
i'm using Oracle Database 10g Express Edition and ojdbc14 and I got the following errors too if it helps:

[pmd:cpd]
[INFO] ------------------------------------------------------------------------
[INFO] Building B4ONE
[INFO]    task-segment: [org.codehaus.sonar:sonar-core-maven-plugin:1.4.3:collect]
[INFO] ------------------------------------------------------------------------
[INFO] snapshot org.codehaus.sonar.runtime:jdbc-driver:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.jdbc-driver:jdbc-driver_ext_0:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime:plugins:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_0:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_1:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_2:1.0-SNAPSHOT: checking for updates from sonar
[INFO] snapshot org.codehaus.sonar.runtime.plugins:plugins_ext_3:1.0-SNAPSHOT: checking for updates from sonar
[INFO] [sonar-core:collect]
16:11:23.831 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 17090, SQLState: null
16:11:23.832 ERROR o.h.util.JDBCExceptionReporter - opération interdite: streams type cannot be used in batching
16:11:23.833 ERROR o.h.e.d.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not insert: [ch.hortis.sonar.model.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.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2272)

    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.save(BatchDatabaseManager.java:84)
    at org.sonar.plugins.java.JavaMeasuresRecorder.createClassSource(JavaMeasuresRecorder.java:80)
    at org.sonar.plugins.sources.SourcesJavaMavenCollector.parseDirectory(SourcesJavaMavenCollector.java:66)
    at org.sonar.plugins.sources.SourcesJavaMavenCollector.collect(SourcesJavaMavenCollector.java:51)
    at org.sonar.maven.CollectMojo.doExecute(CollectMojo.java:73)

    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: opération interdite: streams type cannot be used in batching

    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
    at oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:3999)
    at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:31)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)
    ... 45 common frames omitted
16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation de contrainte unique (SONAR.SYS_C004093)

16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation de contrainte unique (SONAR.SYS_C004093)

.....


2008/11/17 Simon Brandhof <simon.brandhof@...>
What are your database and driver versions ?


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

   http://xircles.codehaus.org/manage_email









Re: can not autodetect the dialect

by mvadlamudi1 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


snow75 wrote:
I upgraded the jdbc to ojbc6.jar , I used the following link:
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_111060.htmland
it Works !!!! thank you so much guys ...

2008/11/17 ilazaar ilazaar <ilazaar@gmail.com>

> ok thanks cédric, i'm doing it ... I will let you know
>
>
> 2008/11/17 Cédric Munger <cedric.munger@gmail.com>
>
> Give a try to version 10.2.0.4 at
>> http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html
>> Please don't forget to recreate the database from scratch. Maybe that the
>> old driver did some mess in the data of the current one.
>>
>> Regards
>>
>>
>> On Mon, Nov 17, 2008 at 4:53 PM, Cédric Munger <cedric.munger@gmail.com>wrote:
>>
>>> OK got an hint for you : to my knowledge, the message 'streams type
>>> cannot be used in batching' indicates that you're using an old oracle JDBC
>>> driver version. Try to upgrade it and it should fix the issue. Please let us
>>> know.
>>>
>>> Regards
>>>
>>>
>>> On Mon, Nov 17, 2008 at 4:31 PM, ilazaar ilazaar <ilazaar@gmail.com>wrote:
>>>
>>>> i'm using Oracle Database 10*g* Express Edition and ojdbc14 and I got
>>>> the following errors too if it helps:
>>>>
>>>> [pmd:cpd]
>>>> [INFO]
>>>> ------------------------------------------------------------------------
>>>> [INFO] Building B4ONE
>>>> [INFO]    task-segment:
>>>> [org.codehaus.sonar:sonar-core-maven-plugin:1.4.3:collect]
>>>> [INFO]
>>>> ------------------------------------------------------------------------
>>>> [INFO] snapshot org.codehaus.sonar.runtime:jdbc-driver:1.0-SNAPSHOT:
>>>> checking for updates from sonar
>>>> [INFO] snapshot
>>>> org.codehaus.sonar.runtime.jdbc-driver:jdbc-driver_ext_0:1.0-SNAPSHOT:
>>>> checking for updates from sonar
>>>> [INFO] snapshot org.codehaus.sonar.runtime:plugins:1.0-SNAPSHOT:
>>>> checking for updates from sonar
>>>> [INFO] snapshot
>>>> org.codehaus.sonar.runtime.plugins:plugins_ext_0:1.0-SNAPSHOT: checking for
>>>> updates from sonar
>>>> [INFO] snapshot
>>>> org.codehaus.sonar.runtime.plugins:plugins_ext_1:1.0-SNAPSHOT: checking for
>>>> updates from sonar
>>>> [INFO] snapshot
>>>> org.codehaus.sonar.runtime.plugins:plugins_ext_2:1.0-SNAPSHOT: checking for
>>>> updates from sonar
>>>> [INFO] snapshot
>>>> org.codehaus.sonar.runtime.plugins:plugins_ext_3:1.0-SNAPSHOT: checking for
>>>> updates from sonar
>>>> [INFO] [sonar-core:collect]
>>>> 16:11:23.831 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 17090,
>>>> SQLState: null
>>>> 16:11:23.832 ERROR o.h.util.JDBCExceptionReporter - opération interdite:
>>>> streams type cannot be used in batching
>>>> 16:11:23.833 ERROR o.h.e.d.AbstractFlushingEventListener - Could not
>>>> synchronize database state with session
>>>> org.hibernate.exception.GenericJDBCException: could not insert:
>>>> [ch.hortis.sonar.model.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.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2272)
>>>>     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.save(BatchDatabaseManager.java:84)
>>>>     at
>>>> org.sonar.plugins.java.JavaMeasuresRecorder.createClassSource(JavaMeasuresRecorder.java:80)
>>>>     at
>>>> org.sonar.plugins.sources.SourcesJavaMavenCollector.parseDirectory(SourcesJavaMavenCollector.java:66)
>>>>     at
>>>> org.sonar.plugins.sources.SourcesJavaMavenCollector.collect(SourcesJavaMavenCollector.java:51)
>>>>     at org.sonar.maven.CollectMojo.doExecute(CollectMojo.java:73)
>>>>
>>>>     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: opération interdite: streams type
>>>> cannot be used in batching
>>>>     at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>>>>     at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
>>>>     at
>>>> oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:3999)
>>>>     at
>>>> org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:31)
>>>>     at
>>>> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)
>>>>     ... 45 common frames omitted
>>>> 16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1,
>>>> SQLState: 23000
>>>> 16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation
>>>> de contrainte unique (SONAR.SYS_C004093)
>>>>
>>>> 16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1,
>>>> SQLState: 23000
>>>> 16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation
>>>> de contrainte unique (SONAR.SYS_C004093)
>>>>
>>>> .....
>>>>
>>>>
>>>> 2008/11/17 Simon Brandhof <simon.brandhof@sonarsource.com>
>>>>
>>>>> What are your database and driver versions ?
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe from this list, please visit:
>>>>>
>>>>>    http://xircles.codehaus.org/manage_email
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>

Hi

i am also having the same issue,

please any one can provide the solution.

Re: can not autodetect the dialect

by mvadlamudi1 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


mvadlamudi1 wrote:
snow75 wrote:
I upgraded the jdbc to ojbc6.jar , I used the following link:
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_111060.htmland
it Works !!!! thank you so much guys ...

2008/11/17 ilazaar ilazaar <ilazaar@gmail.com>

> ok thanks cédric, i'm doing it ... I will let you know
>
>
> 2008/11/17 Cédric Munger <cedric.munger@gmail.com>
>
> Give a try to version 10.2.0.4 at
>> http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html
>> Please don't forget to recreate the database from scratch. Maybe that the
>> old driver did some mess in the data of the current one.
>>
>> Regards
>>
>>
>> On Mon, Nov 17, 2008 at 4:53 PM, Cédric Munger <cedric.munger@gmail.com>wrote:
>>
>>> OK got an hint for you : to my knowledge, the message 'streams type
>>> cannot be used in batching' indicates that you're using an old oracle JDBC
>>> driver version. Try to upgrade it and it should fix the issue. Please let us
>>> know.
>>>
>>> Regards
>>>
>>>
>>> On Mon, Nov 17, 2008 at 4:31 PM, ilazaar ilazaar <ilazaar@gmail.com>wrote:
>>>
>>>> i'm using Oracle Database 10*g* Express Edition and ojdbc14 and I got
>>>> the following errors too if it helps:
>>>>
>>>> [pmd:cpd]
>>>> [INFO]
>>>> ------------------------------------------------------------------------
>>>> [INFO] Building B4ONE
>>>> [INFO]    task-segment:
>>>> [org.codehaus.sonar:sonar-core-maven-plugin:1.4.3:collect]
>>>> [INFO]
>>>> ------------------------------------------------------------------------
>>>> [INFO] snapshot org.codehaus.sonar.runtime:jdbc-driver:1.0-SNAPSHOT:
>>>> checking for updates from sonar
>>>> [INFO] snapshot
>>>> org.codehaus.sonar.runtime.jdbc-driver:jdbc-driver_ext_0:1.0-SNAPSHOT:
>>>> checking for updates from sonar
>>>> [INFO] snapshot org.codehaus.sonar.runtime:plugins:1.0-SNAPSHOT:
>>>> checking for updates from sonar
>>>> [INFO] snapshot
>>>> org.codehaus.sonar.runtime.plugins:plugins_ext_0:1.0-SNAPSHOT: checking for
>>>> updates from sonar
>>>> [INFO] snapshot
>>>> org.codehaus.sonar.runtime.plugins:plugins_ext_1:1.0-SNAPSHOT: checking for
>>>> updates from sonar
>>>> [INFO] snapshot
>>>> org.codehaus.sonar.runtime.plugins:plugins_ext_2:1.0-SNAPSHOT: checking for
>>>> updates from sonar
>>>> [INFO] snapshot
>>>> org.codehaus.sonar.runtime.plugins:plugins_ext_3:1.0-SNAPSHOT: checking for
>>>> updates from sonar
>>>> [INFO] [sonar-core:collect]
>>>> 16:11:23.831 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 17090,
>>>> SQLState: null
>>>> 16:11:23.832 ERROR o.h.util.JDBCExceptionReporter - opération interdite:
>>>> streams type cannot be used in batching
>>>> 16:11:23.833 ERROR o.h.e.d.AbstractFlushingEventListener - Could not
>>>> synchronize database state with session
>>>> org.hibernate.exception.GenericJDBCException: could not insert:
>>>> [ch.hortis.sonar.model.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.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2272)
>>>>     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.save(BatchDatabaseManager.java:84)
>>>>     at
>>>> org.sonar.plugins.java.JavaMeasuresRecorder.createClassSource(JavaMeasuresRecorder.java:80)
>>>>     at
>>>> org.sonar.plugins.sources.SourcesJavaMavenCollector.parseDirectory(SourcesJavaMavenCollector.java:66)
>>>>     at
>>>> org.sonar.plugins.sources.SourcesJavaMavenCollector.collect(SourcesJavaMavenCollector.java:51)
>>>>     at org.sonar.maven.CollectMojo.doExecute(CollectMojo.java:73)
>>>>
>>>>     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: opération interdite: streams type
>>>> cannot be used in batching
>>>>     at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>>>>     at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
>>>>     at
>>>> oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:3999)
>>>>     at
>>>> org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:31)
>>>>     at
>>>> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)
>>>>     ... 45 common frames omitted
>>>> 16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1,
>>>> SQLState: 23000
>>>> 16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation
>>>> de contrainte unique (SONAR.SYS_C004093)
>>>>
>>>> 16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1,
>>>> SQLState: 23000
>>>> 16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001: violation
>>>> de contrainte unique (SONAR.SYS_C004093)
>>>>
>>>> .....
>>>>
>>>>
>>>> 2008/11/17 Simon Brandhof <simon.brandhof@sonarsource.com>
>>>>
>>>>> What are your database and driver versions ?
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe from this list, please visit:
>>>>>
>>>>>    http://xircles.codehaus.org/manage_email
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>

Hi

i am also having the same issue,

please any one can provide the solution.

i am using the oracle 10g ,spring 2.0.5 and hibernate3.0

Re: can not autodetect the dialect

by Olivier Gaudin-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Did you upgrade to the jdbc to ojbc6.jar ?

Olivier


On Wed, Jun 24, 2009 at 1:27 PM, mvadlamudi1 <vadlamudi24@...> wrote:



mvadlamudi1 wrote:
>
>
>
> snow75 wrote:
>>
>> I upgraded the jdbc to ojbc6.jar , I used the following link:
>> http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_111060.htmland
>> it Works !!!! thank you so much guys ...
>>
>> 2008/11/17 ilazaar ilazaar <ilazaar@...>
>>
>>> ok thanks cédric, i'm doing it ... I will let you know
>>>
>>>
>>> 2008/11/17 Cédric Munger <cedric.munger@...>
>>>
>>> Give a try to version 10.2.0.4 at
>>>> http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html
>>>> Please don't forget to recreate the database from scratch. Maybe that
>>>> the
>>>> old driver did some mess in the data of the current one.
>>>>
>>>> Regards
>>>>
>>>>
>>>> On Mon, Nov 17, 2008 at 4:53 PM, Cédric Munger
>>>> <cedric.munger@...>wrote:
>>>>
>>>>> OK got an hint for you : to my knowledge, the message 'streams type
>>>>> cannot be used in batching' indicates that you're using an old oracle
>>>>> JDBC
>>>>> driver version. Try to upgrade it and it should fix the issue. Please
>>>>> let us
>>>>> know.
>>>>>
>>>>> Regards
>>>>>
>>>>>
>>>>> On Mon, Nov 17, 2008 at 4:31 PM, ilazaar ilazaar
>>>>> <ilazaar@...>wrote:
>>>>>
>>>>>> i'm using Oracle Database 10*g* Express Edition and ojdbc14 and I got
>>>>>> the following errors too if it helps:
>>>>>>
>>>>>> [pmd:cpd]
>>>>>> [INFO]
>>>>>> ------------------------------------------------------------------------
>>>>>> [INFO] Building B4ONE
>>>>>> [INFO]    task-segment:
>>>>>> [org.codehaus.sonar:sonar-core-maven-plugin:1.4.3:collect]
>>>>>> [INFO]
>>>>>> ------------------------------------------------------------------------
>>>>>> [INFO] snapshot org.codehaus.sonar.runtime:jdbc-driver:1.0-SNAPSHOT:
>>>>>> checking for updates from sonar
>>>>>> [INFO] snapshot
>>>>>> org.codehaus.sonar.runtime.jdbc-driver:jdbc-driver_ext_0:1.0-SNAPSHOT:
>>>>>> checking for updates from sonar
>>>>>> [INFO] snapshot org.codehaus.sonar.runtime:plugins:1.0-SNAPSHOT:
>>>>>> checking for updates from sonar
>>>>>> [INFO] snapshot
>>>>>> org.codehaus.sonar.runtime.plugins:plugins_ext_0:1.0-SNAPSHOT:
>>>>>> checking for
>>>>>> updates from sonar
>>>>>> [INFO] snapshot
>>>>>> org.codehaus.sonar.runtime.plugins:plugins_ext_1:1.0-SNAPSHOT:
>>>>>> checking for
>>>>>> updates from sonar
>>>>>> [INFO] snapshot
>>>>>> org.codehaus.sonar.runtime.plugins:plugins_ext_2:1.0-SNAPSHOT:
>>>>>> checking for
>>>>>> updates from sonar
>>>>>> [INFO] snapshot
>>>>>> org.codehaus.sonar.runtime.plugins:plugins_ext_3:1.0-SNAPSHOT:
>>>>>> checking for
>>>>>> updates from sonar
>>>>>> [INFO] [sonar-core:collect]
>>>>>> 16:11:23.831 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 17090,
>>>>>> SQLState: null
>>>>>> 16:11:23.832 ERROR o.h.util.JDBCExceptionReporter - opération
>>>>>> interdite:
>>>>>> streams type cannot be used in batching
>>>>>> 16:11:23.833 ERROR o.h.e.d.AbstractFlushingEventListener - Could not
>>>>>> synchronize database state with session
>>>>>> org.hibernate.exception.GenericJDBCException: could not insert:
>>>>>> [ch.hortis.sonar.model.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.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2272)
>>>>>>     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.save(BatchDatabaseManager.java:84)
>>>>>>     at
>>>>>> org.sonar.plugins.java.JavaMeasuresRecorder.createClassSource(JavaMeasuresRecorder.java:80)
>>>>>>     at
>>>>>> org.sonar.plugins.sources.SourcesJavaMavenCollector.parseDirectory(SourcesJavaMavenCollector.java:66)
>>>>>>     at
>>>>>> org.sonar.plugins.sources.SourcesJavaMavenCollector.collect(SourcesJavaMavenCollector.java:51)
>>>>>>     at org.sonar.maven.CollectMojo.doExecute(CollectMojo.java:73)
>>>>>>
>>>>>>     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: opération interdite: streams type
>>>>>> cannot be used in batching
>>>>>>     at
>>>>>> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>>>>>>     at
>>>>>> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
>>>>>>     at
>>>>>> oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:3999)
>>>>>>     at
>>>>>> org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:31)
>>>>>>     at
>>>>>> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)
>>>>>>     ... 45 common frames omitted
>>>>>> 16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1,
>>>>>> SQLState: 23000
>>>>>> 16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001:
>>>>>> violation
>>>>>> de contrainte unique (SONAR.SYS_C004093)
>>>>>>
>>>>>> 16:11:23.858 WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1,
>>>>>> SQLState: 23000
>>>>>> 16:11:23.858 ERROR o.h.util.JDBCExceptionReporter - ORA-00001:
>>>>>> violation
>>>>>> de contrainte unique (SONAR.SYS_C004093)
>>>>>>
>>>>>> .....
>>>>>>
>>>>>>
>>>>>> 2008/11/17 Simon Brandhof <simon.brandhof@...>
>>>>>>
>>>>>>> What are your database and driver versions ?
>>>>>>>
>>>>>>> ---------------------------------------------------------------------
>>>>>>> To unsubscribe from this list, please visit:
>>>>>>>
>>>>>>>    http://xircles.codehaus.org/manage_email
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>>
>
>
> Hi
>
> i am also having the same issue,
>
> please any one can provide the solution.
>


i am using the oracle 10g ,spring 2.0.5 and hibernate3.0

--
View this message in context: http://www.nabble.com/can-not-autodetect-the-dialect-tp20541051p24183002.html
Sent from the Sonar user mailing list archive at Nabble.com.


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

   http://xircles.codehaus.org/manage_email