I managed to get roller working fine with no issues on my personal machine. But as soon as I move it to the red hat server, with the same settings, I still get this in roller.log
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: invalid or unknown NLS parameter value specified It says DriverManager.getConnection() is throwing this error. I've tried completely turning off the firewall to make sure it was able to freely connect too. Has anyone been able to get roller working on RHEL 5? -Tim ________________________________________ From: Simon Haslam [EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 12:23 PM To: [email protected] Subject: RE: Oracle configuration problem Timothy Mizas wrote: > > I'm not sure how to tell if I'm using the thin or thick driver. I'm using > ojdbc14.jar. My custom properties file looks like: > > installation.type=auto > database.configurationType=jdbc > database.jdbc.driverClass=oracle.jdbc.driver.OracleDriver > database.jdbc.connectionURL=jdbc:oracle:thin:@url:port:sid > database.jdbc.username=rollerdb > database.jdbc.password=password > hibernate.dialect=org.hibernate.dialect.Oracle9Dialect > > I didn't set any other Oracle related env variables other than NLS_LANG > which I set to nothing. > The thick driver uses the Oracle database client installed on the app server (and "thin" is replaced with "oci" in the connection URL). My set up isn't the same - I'm on OC4J rather than Tomcat, and am using a pooled JNDI data source. However I do have these settings roller-custom.properties file: openjpa.jdbc.DBDictionary=oracle hibernate.dialect=org.hibernate.dialect.OracleDialect These were suggested by Gabe (see the mailing list archives). I don't know what the difference between Oracle9Dialect and OracleDialect is - might be worth looking up, just in case. :Simon -- View this message in context: http://www.nabble.com/Oracle-configuration-problem-tp17325911s12275p17344541.html Sent from the Roller - User mailing list archive at Nabble.com.
