Re: can not autodetect the dialect

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