We are developing a J2EE system that will need to access a flat file database using Java APIs. One proposal is to use JCA to connect to a server-side adapter using a simple socket connection that then uses the existing Java APIs to access the flat file database. Is this overkill? Would it be easier to just go directly to the back-end Java APIs with the socket connection or does JCA give us an advantage?

Thanks!