File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JForum and the fly likes Oracle 10g jdbc encoding issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Oracle 10g jdbc encoding issue" Watch "Oracle 10g jdbc encoding issue" New topic

Oracle 10g jdbc encoding issue

Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424

I installed and manually configured JForum with Oracle 10g.

App server = Weblogic 8.1.4
Using a datasource to an Oracle JDBC thin Pool.

Getting an error when trying to hit the main page:

Error while trying to start ForumRepository:
java.sql.SQLException: ORA-00979: not a GROUP BY expression

at net.jforum.ForumStartup.startForumRepository(
at net.jforum.JForum.init(
. . .

The server log showing:
INFO [FileMonitor ] Watching C:\bea\user_projects\domains\portalDomain\portalServer\stage\_appsdir_jforum_war\jforum.war/WEB-INF/config/database/generic/generic_queries.sql
INFO [FileMonitor ] Watching C:\bea\user_projects\domains\portalDomain\portalServer\stage\_appsdir_jforum_war\jforum.war/WEB-INF/config/database/oracle/oracle.sql
INFO [FileMonitor ] Watching C:\bea\user_projects\domains\portalDomain\portalServer\stage\_appsdir_jforum_war\jforum.war/WEB-INF/config/

The JDBC trace is showing this:

SQLException: SQLState(null) vendor code(17055)
java.sql.SQLException: Invalid character encountered in: failAL32UTF8Conv
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.dbaccess.DBError.check_error(
at oracle.jdbc.dbaccess.DBConversion.failAL32UTF8Conv(
at oracle.jdbc.dbaccess.DBConversion.javaCharsToAL32UTF8Bytes(
at oracle.jdbc.dbaccess.DBConversion.stringToAL32UTF8Bytes(
at oracle.jdbc.dbaccess.DBConversion.stringToAccessCharBytes(
at oracle.jdbc.dbaccess.DBConversion.StringToCharBytes(
at oracle.jdbc.ttc7.O3log.setSessionFields(
at oracle.jdbc.ttc7.O3log.<init>(
at oracle.jdbc.ttc7.TTC7Protocol.logon(
at oracle.jdbc.driver.OracleConnection.<init>(
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(
at oracle.jdbc.driver.OracleDriver.connect(

I have tried the following property in the Pool:

Seems like some kind of error during the parsing of the SQL.

Any ideas?


[originally posted on by varsos]
Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Which jforum version?

[originally posted on by Rafael Steil]
Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
version 2.1.4

I have other apps in this server with the 10g backend, using the same JDBC driver, and they do not have an issue.

I did come accross a ClassNotFound exception before this problem.
It could not find the class
specified in the file.
So, in the (got from cvs) I changed it to instead which I saw deployed in the WEB-INF/classes and it worked.

Thanks for your help.
[originally posted on by Anonymous]
Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Version 2.1.4 does not correctly supports oracle. You have to use version 2.1.5. Check the pre-relese here:

[originally posted on by Rafael Steil]
Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I will try that one, thanks
[originally posted on by varsos]
It is sorta covered in the JavaRanch Style Guide.
subject: Oracle 10g jdbc encoding issue
Similar Threads
java.sql.SQLException: Protocol violation
JForum and Oracle 8i Standard Edition
Cannot Access JForum URL
Can't create new topics in JForum 2.1.7
unable to connect to oracle database