I created an execute service adapter template and called a java service which inserts data into the DB. But, i get table or view doesn’t exist error.The table do exists in DB. Below is the java code.
java.sql.Connection conn = (java.sql.Connection)IDataUtil.get(pipeline.getCursor(),
java.sql.PreparedStatement pstmt=conn.prepareStatement(“Insert into PROFILE_UPDATE_REQUEST (REQUESTID) values(null)”);
throw new ServiceException(e); }
Please let me know on where i went wrong in this. And need your valuable inputs on how to fetch data from a select query using execute service.
I am using execute template instead of normal insert as the blob insert through normal insert template is not writing the data properly and going through forums I got to know many use custom java services.