Hi,
I’m making tests on data file load using Denodo Express 8.0 for Windows 64 bits.
I have an Oracle instance running on the same computer.
I run catldr.sql as sysdba on the Oracle database.
I created a data source (dstrcr) and activated "Use Bulk Data Load APIs".
I created a very simple table on Oracle and a base view on this table.
When i try to insert data in the base view with the request
"insert into bvtrcrtmppsa select 'test' from dual()"
i have the error :
Finished with error: Error executing data movement from view pdual3818fcb2-25ac-4bfc-8837-0fd9b44dd470 to source dstrcr
Exception of plan pdual3818fcb2-25ac-4bfc-8837-0fd9b44dd470: com.denodo.vdb.util.tablemanagement.TableManagerException: Error executing sqlldr command
Can you help me ?
Here are the vdp script :
CREATE OR REPLACE DATASOURCE JDBC ds_trcr
DRIVERCLASSNAME = 'oracle.jdbc.OracleDriver'
DATABASEURI = 'jdbc:oracle:thin:@###'
USERNAME = '###'
USERPASSWORD = '###' ENCRYPTED
CLASSPATH = 'oracle-12c-v12.2.0.1'
DATABASENAME = 'oracle'
DATABASEVERSION = '12c'
FETCHSIZE = 1000
VALIDATIONQUERY = 'SELECT COUNT(*) FROM SYS.DUAL'
INITIALSIZE = 4
MAXIDLE = -1
MINIDLE = 0
MAXACTIVE = 20
EXHAUSTEDACTION = 1
TESTONBORROW = true
TESTONRETURN = false
TESTWHILEIDLE = false
TIMEBETWEENEVICTION = -1
NUMTESTPEREVICTION = 3
MINEVICTABLETIME = 1800000
POOLPREPAREDSTATEMENTS = false
MAXOPENPREPAREDSTATEMENTS = -1
PROPERTIES ('includeSynonyms'='false', 'remarksReporting'='false')
DATA_LOAD_CONFIGURATION (
BATCHINSERTSIZE = 200
BULK_LOAD_CONFIGURATION (
SQLLDR_EXECUTABLE_LOCATION = 'C:\app\###\virtual\product\12.2.0\dbhome_1\bin\sqlldr.exe'
)
USEEXTERNALTABLES (
ONMOVEREAD = false,
ONMOVEWRITE = true
)
);
CREATE OR REPLACE WRAPPER JDBC bv_trcr_tmp_psa
DATASOURCENAME=ds_trcr
SCHEMANAME='###'
RELATIONNAME='TMP_PSA'
OUTPUTSCHEMA (
c1 = 'C1' :'java.lang.String' (OPT) (sourcetyperadix='10', sourcetypesize='10', sourcetypeid='12', sourcetypename='VARCHAR2') SORTABLE
);
CREATE OR REPLACE TABLE bv_trcr_tmp_psa I18N fr_euro (
c1:text (sourcetypeid = '12', sourcetyperadix = '10', sourcetypesize = '10')
)
CACHE OFF
TIMETOLIVEINCACHE DEFAULT
ADD SEARCHMETHOD bv_trcr_tmp_psa(
I18N fr_euro
CONSTRAINTS (
ADD c1 (any) OPT ANY
)
OUTPUTLIST (c1
)
WRAPPER (jdbc bv_trcr_tmp_psa)
);
