Error when running with LDAP and Oracle 9i

[Migrated From Jforum.net]

Hello all,

I am having an interesting issue with Oracle 9i. I get the following stack trace when I try to log in against an LDAP server.
The funny bit is that I do not get this error when logging in against an MySQL server (using the same LDAP).

Any ideas?
Thanks,
E/.


<!-- BEGIN ERROR STACK TRACE <br /> java.lang.reflect.InvocationTargetException <br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) <br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) <br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) <br /> at java.lang.reflect.Method.invoke(Method.java:585) <br /> at net.jforum.Command.process(Command.java:116) <br /> at net.jforum.JForum.service(JForum.java:182) <br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:860) <br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) <br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) <br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) <br /> at java.lang.reflect.Method.invoke(Method.java:585) <br /> at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249) <br /> at java.security.AccessController.doPrivileged(Native Method) <br /> at javax.security.auth.Subject.doAsPrivileged(Subject.java:517) <br /> at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282) <br /> at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:165) <br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:257) <br /> at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:55) <br /> at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:161) <br /> at java.security.AccessController.doPrivileged(Native Method) <br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) <br /> at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59) <br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:210) <br /> at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:55) <br /> at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:161) <br /> at java.security.AccessController.doPrivileged(Native Method) <br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) <br /> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:263) <br /> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551) <br /> at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:225) <br /> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:173) <br /> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551) <br /> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161) <br /> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551) <br /> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:933) <br /> at com.sun.enterprise.web.connector.httpservice.HttpServiceProcessor.process(HttpServiceProcessor.java:226) <br /> at com.sun.enterprise.web.HttpServiceWebContainer.service(HttpServiceWebContainer.java:2071) <br /> Caused by: java.sql.SQLException: Invalid column type: getInt not implemented for class oracle.jdbc.driver.T4CRowidAccessor <br /> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) <br /> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) <br /> at oracle.jdbc.driver.Accessor.unimpl(Accessor.java:358) <br /> at oracle.jdbc.driver.Accessor.getInt(Accessor.java:468) <br /> at oracle.jdbc.driver.OracleReturnResultSet.getInt(OracleReturnResultSet.java:265) <br /> at net.jforum.dao.generic.AutoKeys.executeAutoKeysQuery(AutoKeys.java:123) <br /> at net.jforum.dao.generic.AutoKeys.executeAutoKeysQuery(AutoKeys.java:112) <br /> at net.jforum.dao.generic.GenericUserDAO.addNew(GenericUserDAO.java:248) <br /> at net.jforum.sso.SSOUtils.register(SSOUtils.java:108) <br /> at net.jforum.sso.LDAPAuthenticator.validateLogin(LDAPAuthenticator.java:128) <br /> at net.jforum.dao.generic.GenericUserDAO.validateLogin(GenericUserDAO.java:537) <br /> at net.jforum.view.forum.UserAction.validateLogin(UserAction.java:453) <br /> at net.jforum.view.forum.UserAction.validateLogin(UserAction.java:334) <br /> ... 37 more <br /> <br /> END ERROR STACK TRACE-->
[originally posted on jforum.net by ewise]

[Migrated From Jforum.net]

Look at the error:

Invalid column type: getInt not implemented for class oracle.jdbc.driver.T4CRowidAccessor 

Looks like a problem with the JDBC Driver, OR the LDAP authenticator you're using.

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

[Migrated From Jforum.net]

I got this error when the setting database.support.autokeys is set to true instead of false in WEB-INF/config/jforum-custom.conf and I use the database client from Oracle 10i R2. Also check that the dao.driver is configured to net.jforum.dao.oracle.OracleDataAccessDriver.
[originally posted on jforum.net by peter.rosell]

[Migrated From Jforum.net]

For v2.1.8, the following changes to WEB-INF/config/jforum-custom.conf would work for Oracle setup:

dao.driver=net.jforum.dao.oracle.OracleDataAccessDriver
database.support.autokeys=false

But why doesn't the install script correctly use the selection made in the installation page to generate this? It seems to insist on using MySQL when data source is seleted. Is there a bug already log for this?
[originally posted on jforum.net by lukechiam]