Hi All,

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(),
com.wm.adapter.wmjdbc.services.ExecuteService.PIPELINE_CONNECTION);
try {
java.sql.PreparedStatement pstmt=conn.prepareStatement(“Insert into PROFILE_UPDATE_REQUEST (REQUESTID) values(null)”);
pstmt.execute();
}
catch(Throwable e)
{
e.printStackTrace();

			 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.

Thanks,
Sathya

what is Integration server version, JDBC Adapter version, which database you are connecting to.

Try fully qualifying your table name.

Yes, try to use fully qualified name like schema_name.<table_name> in the query.

Thanks,