I installed the jforum app on weblogic 8.1 sp5 with oracle backend. I configured it and brought it up.
When I tried creating a Category, I got the following exception
Caused by: java.sql.SQLException: Unsupported feature
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.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBEr
ror.java:689)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection
.java:3360)
at weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_OracleConnect
ion.prepareStatement(Unknown Source)
at net.jforum.dao.generic.AutoKeys.getStatementForAutoKeys(AutoKeys.java
:95)
at net.jforum.dao.generic.AutoKeys.getStatementForAutoKeys(AutoKeys.java
:107)
at net.jforum.dao.generic.GenericCategoryDAO.addNew(GenericCategoryDAO.j
ava:171)
at net.jforum.view.admin.CategoryAction.insertSave(CategoryAction.java:1
51)
... 21 more
You are correct. I have 2.1.6. I tried changing from using Application DataSource to Connection Pool to SimpleConnection. All result in the same error. But I could not understand why it gave that error. The SQL statement which throws the exception does not give exception when executed from the SQL prompt.
Any ideas or alternatives to solve this problem ??? [originally posted on jforum.net by ppk]