I am looking for a way to open my Java EE application server through an ODBC connection. I.e; I need to serve data from my AS for applications that connect to it with ODBC.
This would probably mean that I should write my own ODBC driver in Java, which seems to be a daunting task.
Anyone here with experience? Has this been done before? What libraries to start with? I'm out of my mind?
EDIT: This is an integration issue between my application server and clients reading data from it through ODBC. In particular, it is the first iteration of Microsoft SharePoint. I already have JAX-WS, but unfortunately this is not a problem for SharePoint / Cudes / MS Analysis / MS Reporting services, etc.
The data will be presented mainly as one flat table. The problem I am facing is going to the lower end. Protocol, negotiation, authentication. If I come to a point where I can accept an ODBC connection and click on tabular data, I'm free to go home.
source
share