• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Devaka Cooray
  • Tim Cooke
Sheriffs:
  • Rob Spoor
  • Liutauras Vilda
  • paul wheaton
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Mikalai Zaikin
  • Carey Brown
  • Piet Souris
Bartenders:
  • Stephan van Hulst

Oracle 10g jdbc encoding issue

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: https://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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I will try that one, thanks
[originally posted on jforum.net by varsos]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic