oracle error after build

[Migrated From Jforum.net]

I deloyed the war file, from an ant build of the 2.1.5 source.

When tying to list topics in a forum, the following error is thrown:
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:187)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:241)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1477)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:677)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2285)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2525)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:452)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:382)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at net.jforum.dao.generic.GenericForumDAO.isUserSubscribed(GenericForumDAO.java:665)
at net.jforum.view.forum.ForumAction.show(ForumAction.java:221)
... 39 more



this error does not occur when deployig the downloaded version (zip) directly to tomcat.
[originally posted on jforum.net by steve_db]

[Migrated From Jforum.net]

I resolved this by:
- dropping all jforum tables and sequences (these were originally created and populated by the install).
- made all of my changes manually to systemglobal.properties and oracle.properties
- created tables (using oracle_db_struct.sql)
- populated tables (using oracle_data_dump.sql)
- ant clean; ant compile; ant deploy;
- my resulting war file is good to go.

forum is awesome.
just my cleanup and problems with e-mail that I'm working on.

awesome.
I'm grateful for this. :lol:
[originally posted on jforum.net by steve_db]

[Migrated From Jforum.net]

Installer didn't work? strange.. But good that you found a solution

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Rafael Steil wrote:Installer didn't work? strange.. But good that you found a solution

Rafael

The installer did work, if I continued to use the automatically installed version.

I was trying to use a manually installed version after the auto-install.

I built this from the CVS Source using ant.
I made notes of all my steps to build and deploy, with specs on the specific code changes (minor) that I made.

I have it deployed as a pilot part of another Web app that I'm building.
It's deployed on an internal enterprise-wide Oracle Application Server and is running very fast and clean.

I'm extremely pleased with the results so far, but will probably need some help - working on the e-mail piece with an exchange server.


[originally posted on jforum.net by steve_db]

[Migrated From Jforum.net]

Feel free to ask. We can then share the information in the wiki - http://www.jforum.net/confluence

Rafael
[originally posted on jforum.net by Rafael Steil]