java.sql.SQLException: ORA-12705: invalid or unknown NLS parameter value

KNIME Analytics Platform
1

Hi, you all.

I have a problem: when a create a new Database Connector with Oracle, y I try to connect it shows me the following error:

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: invalid or unknown NLS parameter value specified
 
Please help.
 
2

How does your statement look like, are you using PL/SQL, can you use a simple SELECT * FROM to see if the connection works?

3

Hi, Gabriel.

Is SELECT * FROM dual;

In SQL Developer works fine.

It's works with odbc, but too slow.

 

4

I assume it works now, but it's slow using JDBC/ODBC compared to SQL Developer?

5

Not too slow. But I see the diference.

I did this steps:

Download from oracle ojdbc14.jar, and put into c:\knime_2.7.4\jre\lib\

Open Knime-->Node Repository-->Database-->Database Connector

driver1: oracle.jdbc.driver.OracleDriver

Url 1: jdbc:oracle:thin://maahsa1:1521/maahsa

Error 1: WARN Database Connector java.sql.SQLException: java.sql.SQLException: java.sql.SQLException: Excepción de E/S: The Network Adapter could not establish the connection

url 2: jdbc:oracle:thin:@maahsa1:1521/maahsa
error2: WARN Database Connector java.sql.SQLException: java.sql.SQLException: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: invalid or unknown NLS parameter value specified
 
driver 2: oracle.jdbc.OracleDriver
Url1: jdbc:oracle:thin://maahsa1:1521/maahsa
Error 1:WARN   Database Connector  java.sql.SQLException: java.sql.SQLException: java.sql.SQLException: Excepción de E/S: The Network Adapter could not establish the connection
 
url2: jdbc:oracle:thin:@maahsa1:1521/maahsa
error2: WARN Database Connector java.sql.SQLException: java.sql.SQLException: java.util.concurrent.TimeoutException
 
I just dont want to use the odbc.
 
Thanks.
6

Understood. You need to register the driver within the preference page, go to File > Preferences > KNIME > Database Driver and load the Jar into the settings. The Jar within the lib folder can be removed and KNIME need to be restarted to pick up the one from the preferences.

7

Thanks, Gabriel.

Now it's working.