| 
Sonar user

 « Return to Thread: can not autodetect the dialect

Re: can not autodetect the dialect

by mvadlamudi1 :: Rate this Message:

Reply to Author | View in Thread


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.

 « Return to Thread: can not autodetect the dialect

Free embeddable forum powered by Nabble Forum Help