ODBC interface/driver written in Java

Question

I'm looking for a way to expose my Java EE application server through an ODBC connection. That is; I need to serve data from my AS to applications which connect to it with ODBC.

This would probably mean I have to write up a custom ODBC driver in Java, which seems to be a daunting task.

Anyone here with experience of this? Have this been done before? Any libraries to start out with? Am I crazy?

EDIT: It's a matter of integration between my appserver and clients reading data from it through ODBC. Specifically in it's first iteration, Microsoft SharePoint. I already have a JAX-WS, but unfortunately that is a no go for SharePoint/Cudes/MS Analysis services/MS Reporting services etc.

The data would be represented basically as one flat table. The problem I'm having goes to the low end stuff. Protocol, negotiation, authentication. If I come to the point where I can accept an ODBC connection and push tabular data, I'm home free..

Answer 1

Elijah:

One suggestion is to use an SDK to build a driver. 90% of the work is already done in the SDK. I work for Simba Technologies and we do exactly that. Help people like you build ODBC drivers in C++, Java and C#. Take a look at our website www.simba.com

Suzanne

Answer 2

Run a separate database to which your clients can connect. Your server just pushes data to this database. But, this will not be a request-response based mechanism. Server will have to populate tables before it anticipates client requests. You might have to manage authentication/authorization by creating a db user for each client and then have a table for each db user and restricting db user to only his table.

Not that elegant, huh?