aspose file tools*
The moose likes JForum and the fly likes Installing on Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "Installing on Oracle" Watch "Installing on Oracle" New topic
Author

Installing on Oracle

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi,

I'm trying to run JForum on Oracle11G.

I get the below error:

et.jforum.exceptions.ForumStartupException: Error while starting jforum
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.prepare_for_new_get(OracleStatement.java:3378)
at oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java:3627)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:460)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1482)
at net.jforum.dao.generic.GenericUserDAO.getLastUserInfo(GenericUserDAO.java:610)
at net.jforum.repository.ForumRepository.loadUsersInfo(ForumRepository.java:788)
at net.jforum.repository.ForumRepository.start(ForumRepository.java:131)
at net.jforum.ForumStartup.startForumRepository(ForumStartup.java:100)
at net.jforum.JForum.init(JForum.java:111)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1172)
at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:808)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:129)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: net.jforum.exceptions.RepositoryStartupException: Error while trying to start ForumRepository: net.jforum.exceptions.DatabaseException: java.sql.SQLException: Opbrugt resultats�t
... 24 more
Caused by: net.jforum.exceptions.DatabaseException: java.sql.SQLException: Opbrugt resultats�t
... 24 more
Caused by: java.sql.SQLException: Opbrugt resultats�t
... 24 more
27-11-2008 17:34:07 org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Allocate exception for servlet jforum
java.sql.SQLException: Opbrugt resultats�t
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.prepare_for_new_get(OracleStatement.java:3378)
at oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java:3627)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:460)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1482)
at net.jforum.dao.generic.GenericUserDAO.getLastUserInfo(GenericUserDAO.java:610)
at net.jforum.repository.ForumRepository.loadUsersInfo(ForumRepository.java:788)
at net.jforum.repository.ForumRepository.start(ForumRepository.java:131)
at net.jforum.ForumStartup.startForumRepository(ForumStartup.java:100)
at net.jforum.JForum.init(JForum.java:111)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1172)
at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:808)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:129)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)


Here is my settings:

#Wed Sep 12 20:47:59 BRT 2007
database.driver.name=oracle
database.connection.password=jform
database.connection.dbname=STADSADM
database.connection.string_local=jdbc\racle\ci\:${database.connection.username}/${database.connection.password}@${database.connection.dbname}
database.support.autokeys=false
database.connection.host=panter
database.connection.pool.min=5
database.support.subqueries=true
database.connection.pool.timeout=120
database.connection.port=1521
database.connection.username=jform
database.connection.string=${database.connection.string_thin}
dbencoding=utf-8
database.connection.pool.max=50
dao.driver=net.jforum.dao.oracle.OracleDataAccessDriver
database.connection.driver=oracle.jdbc.OracleDriver
database.connection.string_thin=jdbc\racle\:thin\:${database.connection.username}/${database.connection.password}@${database.connection.host}\:${database.connection.port}\:${database.connection.dbname}


I use a schema called JFORM. Please help :-)
[originally posted on jforum.net by clausfod]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I don't use Oracle but here are some thoughts:

First, a common problem is that the doa.driver gets set incorrectly sometimes.. but your settings show you're using the correct one.

Another problem might be a mismatch in JDBC drivers. Make sure their is only one in your apps classpath (e.g. in commons/lib and not in WEB-INF/lib or vice versa). And that the driver matches your Oracle version.

Finally, the error indicates that it is failing while doing the query below. (Located in the config/database/oracle/oracle.sql file). Perhaps your version or configuration does not support this query. You may need to tweak it (and others).


[originally posted on jforum.net by monroe]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Installing on Oracle
 
Similar Threads
i have a problem when i modify server.xml
jforum / oracle manual install - error
Exhausted Resultset Exception
cursors and sql error
java.sql.SQLException: Exhausted Resultset