I am working on Import from Statement and from here https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20f712e175191014907393741fadcb97.html we know that there are two ways using 1) csv file and using 2) control file.
I creat...
SAP HANA DB version - 2.0SP3
ngdbc.jar version - 2.4.67
I am trying to use setClob on PreparedStmt and I am getting error "com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot convert Java type java.sql.Clob to SQL type CHAR."
...
Hello,
I am trying to do a batch insert using sap hana db's jdbc driver (version - 2.4.67)
A demo code is as below
(I have created Employee table with ID as INTEGER and is primary key, Name as VARCHAR(1))
String psBatchquery = "insert into S...
Hello,
I am trying to write below code that uses sap hana db's jdbc driver.
I am trying to do a batch insert, a demo code is as below
(I have created Employee table with ID as primary key, so that record 3 will fail.)
String psBatchquery = "...
I have updated ngdbc.jar and now I am using latest version 2.4.67. (updated query desctiption as well)scenario is still same, i.e. all records in a batch fail in case of wrong long field data in one record, the error code is -3 instead of -2.whereas ...
Is it okay if I handle exception of inner executeBatch() method within for loop (that is shown above), that ways next statements will still be executedif (++count % batchSize == 0){
try{
batchPs.executeBatch();
}
catch (BatchUpdateException...
