Forum Stats

  • 3,770,157 Users
  • 2,253,079 Discussions
  • 7,875,349 Comments

Discussions

File Adapter Sync read with FileName = Prefix + wild card file name. Is this possible?

Hari Selva
Hari Selva Member Posts: 282 Blue Ribbon
edited Mar 28, 2019 2:20PM in SOA & Process Management

Hi Experts,

Is there a way to do Sync Read a file using FileAdapter with jca.file.FileName = "ABC100815709_XY564630900*.pdf"

Please advise.

I am getting this error message:

Caused by: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/CompName/WSDLs/DBPoller/fileSyncRead.wsdl [ SynchRead_ptt::SynchRead(Empty,opaque) ] - WSIF JCA Execute of operation 'SynchRead' failed due to: No Data to process.

No Data to process.

File /app/dev/utils/ABC100815709_XY564630900*.pdf to be processed was not found or not available or has no content

; nested exception is:

        BINDING.JCA-11007

No Data to process.

Workaround I think of:

1. Get the list of files on that directory using another File Adapter List.

2. Do a string compare based on the prefix and get the file name.

3.  Assign the file name to jca.file.FileName on the sync read.

Thanks

Tagged:
Martien van den AkkerRaj__K

Best Answer

  • vladodias
    vladodias Member Posts: 2,283 Gold Trophy
    edited Mar 27, 2019 6:40PM Accepted Answer

    Hi Hari,

    No, sync read won't accept wild cards... the workaround you are planning will work, do a list first to find out what the actual file name is...

    Cheers,

    Vlad

    Martien van den AkkerHari SelvaRaj__K

Answers

  • vladodias
    vladodias Member Posts: 2,283 Gold Trophy
    edited Mar 27, 2019 6:40PM Accepted Answer

    Hi Hari,

    No, sync read won't accept wild cards... the workaround you are planning will work, do a list first to find out what the actual file name is...

    Cheers,

    Vlad

    Martien van den AkkerHari SelvaRaj__K