Skip to Content
avatar image
Former Member

JDBC Lookup Error

Hello,

I have a message mapping with a UDF that execute a JDBC Lookup:

sql = "SELECT....";

DataBaseAccessor accessor = null;

DataBaseResult resultSet = null;

try {

Channel channel = LookupService.getChannel(constantService, constantChannel);

accessor = LookupService.getDataBaseAccessor(channel);

resultSet = accessor.execute(sql);

}

catch (Exception e) {

..............

All looks well but when I test the scenario I get the following exception:

'Error during processing local bean: localejbs/CallSapAdapter'. Cause Exception: 'Exception thrown in method process. The transaction is marked for rollback.'.

I don't have any additional configuration on the module page of the communication channel.

Thanks for your help.

Yuvan.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 03, 2008 at 09:43 PM

    Hi,

    Print the stack trace using the following code. you will be able to debug the issue by using this. You can see the logs in Communication channel of the adapter.

    
    AbstractTrace trace = container.getTrace();
    trace.addWarning("DEBUG....");
    try
    {
    trace.addWarning("BEFORE ACCESSOR GET CHANNEL");
    accessor = LookupService.getRfcAccessor(channel);
    }
    catch (Exception e)
    {
    StackTraceElement stack= e.getStackTrace();
    for(int i=0;i<stack.length;i++)
    {
    StackTraceElement stackTrace = stack;
    trace.addWarning("Exception is at : "+stackTrace.toString());
    }
    }
    

    thanks

    amit

    Add comment
    10|10000 characters needed characters exceeded