[jboss-user] [JCA/JBoss] - OracleDS - ORA-12705: Cannot access NLS data

[joseantonioribeiro]

I'm evaluating Jboss, after declined Apache Geronimo.

I've configured a datasource to connect to my oracle database (10g) by the book.

After that, I created a JSP that has this code:

...
DataSource ds = null;
  Connection con = null; 
  PreparedStatement pr = null; 
  InitialContext ic; 
  try {
  ic = new InitialContext();
  out.println(" 1");
  ds = (DataSource)ic.lookup( "java:/OracleDS" );
  out.println(" 2");
  con = ds.getConnection(); 
  out.println(" 3");
...

When I execute the same after deployement it returns:

1

2
Exception thrown org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified ); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified )) end

For testing porposes, I've added in my datasource:
<connection-property name="char.encoding">UTF-8</connection-property>

But still I've got the same error. 

My environment is Microsoft XP and my Oracle database NLS_LANG is AMERICAN_AMERICA.WE8MSWIN1252

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4110512#4110512

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4110512