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. -Tim ________________________________________ From: Simon Haslam [EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 3:20 AM To: [email protected] Subject: Re: Oracle configuration problem Timothy Mizas wrote: > > I'm trying to install roller 4.0 on red hat RHEL 5. Roller.log is printing > out that everything has loaded ok. The correct username, db url, driver > class, and of course the password is hidden. But then it says it's unable > to connect to the database and later prints out a root cause of > > java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 > ORA-12705: invalid or unknown NLS parameter value specified > > I can connect to the database using the exact same credentials and url > using a GUI. > > From Googling, I'm told to set the env var NLS_LANG to nothing. So I've > tried doing an export NLS_LANG= but I still get the same error. I've also > looked at the source that does the test connection. I didn't really > understand how it could work since it is trying to connect with a url, > username, and pass but never specifies a driver. > I assume from your previous post that you're using Tomcat? Where is NLS_LANG getting set - the profile of the user running Tomcat? What locale are you in? According to the Oracle docs, the error means: ORA-12705: Cannot access NLS data files or invalid environment specified Cause: Either an attempt was made to issue an ALTER SESSION command with an invalid NLS parameter or value; or the environment variable(s) NLS_LANG, ORA_NLSxx, or ORACLE_HOME was incorrectly specified, therefore the NLS data files cannot be located. Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify the correct directory path/values in the environment variables. Are you using the thin or thick (OCI) Oracle JDBC driver? Perhaps you could post your roller-custom.properties (minus passwords) and any Oracle-related environment variables you set? :Simon -- View this message in context: http://www.nabble.com/Oracle-configuration-problem-tp17325911s12275p17334711.html Sent from the Roller - User mailing list archive at Nabble.com.
