Hi,

We got error
Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: invalid or unknown NLS parameter value specified

When we try to connect to OracleDB 10.1.0.3 from OracleAS 10.1.0.2 with Hibernate version 2.1.7.

It works on OracleAS 9.0.4!

Regards,
Alireza Fattahi

****************
The Stack Trace is:
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:647)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:149)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:551)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.evermind.sql.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:213)
at com.evermind.sql.DriverManagerConnectionPoolDataSource.getPooledConnection(DriverManagerConnectionPoolDataSource.java:36)
at com.evermind.sql.OrionPooledDataSource.getPooledConnection(OrionPooledDataSource.java:582)
at com.evermind.sql.PooledConnectionUsage.getPooledConnection(PooledConnectionUsage.java:22)
at com.evermind.sql.OrionPooledDataSource.getConnection(OrionPooledDataSource.java:346)
at com.liferay.util.dao.hibernate.DSConnectionProvider.getConnection(DSConnectionProvider.java:61)
at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:289)


********
The DSConnectionProvider is

public class DSConnectionProvider implements ConnectionProvider {

public void configure(Properties props) throws HibernateException {
String location = props.getProperty(Environment.DATASOURCE);

try {
_ds = (DataSource)JNDIUtil.lookup(new InitialContext(), location);
}
catch (Exception e) {
throw new HibernateException(e.getMessage());
}
}

public Connection getConnection() throws SQLException {
return _ds.getConnection();
}

public void closeConnection(Connection con) throws SQLException {
con.close();
}

public boolean isStatementCache() {
return false;
}

public void close() {
}

private DataSource _ds;

}