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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
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 ?