Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle 10g jdbc encoding issue

 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I installed and manually configured JForum with Oracle 10g.
The NLS_DATABASE_PARAMETERS are:
NLS_LANGUAGE=AMERICAN
NLS_CHARACTERSET=AL32UTF8

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:

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

at net.jforum.ForumStartup.startForumRepository(ForumStartup.java:102)
at net.jforum.JForum.init(JForum.java:112)
. . .


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/SystemGlobals.properties


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(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)
at oracle.jdbc.dbaccess.DBConversion.failAL32UTF8Conv(DBConversion.java:2762)
at oracle.jdbc.dbaccess.DBConversion.javaCharsToAL32UTF8Bytes(DBConversion.java:2678)
at oracle.jdbc.dbaccess.DBConversion.stringToAL32UTF8Bytes(DBConversion.java:2624)
at oracle.jdbc.dbaccess.DBConversion.stringToAccessCharBytes(DBConversion.java:391)
at oracle.jdbc.dbaccess.DBConversion.StringToCharBytes(DBConversion.java:456)
at oracle.jdbc.ttc7.O3log.setSessionFields(O3log.java:796)
at oracle.jdbc.ttc7.O3log.<init>(O3log.java:124)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:256)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)

I have tried the following property in the Pool:
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
NLS_LANG=AMERICAN_AMERICA.UTF8

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

Any ideas?

Thanks

DV
[originally posted on jforum.net by varsos]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Which jforum version?

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 net.jforum.dao.oracle.OracleDataAccessDriver
specified in the oracle.properties file.
So, in the oracle.properties (got from cvs) I changed it to dao.driver=net.jforum.drivers.oracle.DataAccessDriver instead which I saw deployed in the WEB-INF/classes and it worked.

Thanks for your help.
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Version 2.1.4 does not correctly supports oracle. You have to use version 2.1.5. Check the pre-relese here: http://www.coderanch.com/t/575752

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I will try that one, thanks
[originally posted on jforum.net by varsos]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic