Troubleshooting
Problem
when creating nickname using JDBC wrapper for table on OpenEdge 10.1c server. We met error: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL1476N The current transaction was rolled back because of error "-430". SQLSTATE=40506
Symptom
-- ---------------------------
-- DDL Statements for SERVER
-- ---------------------------
create server qadjdbc2 type jdbc version 3.0 wrapper jdbc options
(driver_package 'C:\JDBCDRIVER\base.jar;C:\JDBCDRIVER\openedge.jar;C:\JDBCDRIVER\progress.jar;C:\JDBCDRIVER\util.jar',
driver_class 'com.ddtek.jdbc.openedge.OpenEdgeDriver',
JDBC_LOG 'Y',
url 'jdbc:datadirect:openedge://9.112.232.92:3334;databaseName=oedb;defaultSchema=PUB;user=administrator');
-- --------------------------------
-- DDL Statements for USER MAPPING
-- --------------------------------
create user mapping for administrator server qadjdbc2 options (add remote_authid 'administrator', REMOTE_PASSWORD 'Superh0t')
PASSTHRU is succesful;
db2 => set passthru QADJDBC2;
DB20000I The SQL command completed successfully.
db2 => select count(*) from pub.Customer;
count(*)
--------------------
1117
1 record(s) selected.
when create the nickname it will hang a while then report SQL1476N
db2 => create nickname customer for qadjdbc2.pub.Customer;
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1476N The current transaction was rolled back because of error "-430".
SQLSTATE=40506
Log InLog in to view more of this document
Was this topic helpful?
Document Information
Modified date:
25 April 2025
UID
swg21978251