Menu

Oracle install problem

2006-01-13
2013-04-25
  • Toto Cottugno

    Toto Cottugno - 2006-01-13

    Hi,
    I'm new to OpenReports
    I'm installing release 1.0-M1  on Oracle 9.

    -I've
    -built from source and created War file.
    -created all tables & hib sequence in a dedicated schema.
    - manually created admin user.
    - set dialect to net.sf.hibernate.dialect.Oracle9Dialect in hibernate properties file.

    - now :
       I can connect with admin user but I always receive this message when I create any kind of object: org.efs.openreports.providers.ProviderException: Could not save object

    The log show this kind of message :
    java.sql.SQLException: ORA-00942: table or view does not exist
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:877)
        at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2513)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2857)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)

    I don't understand . help needed !

    Thank you for you help

     
    • Toto Cottugno

      Toto Cottugno - 2006-01-16

      To solve , I just added the dialect declaration in hibernate.cfg.xml file.

      <property name="dialect">   
         net.sf.hibernate.dialect.Oracle9Dialect
      </property>

      But why dialect is also declared in hibernate.properties ? is it required ?

       

Log in to post a comment.