[Jprogramming] How can get access to JDB?

[Alex Rufon]

Hi.

You question isn't stupid. A few years back I investigated ways on how to access J data through the "standard" interfaces:
1. ODBC
2. JDBC
3. ADO.Net
4. OLE DB
5. XML Data Streaming

There were a few notable SDK's which would allow you to build a driver (i.e. SimbaEngine ODBC SDK, DataDirect OpenAccess SDK, etc) or if your courageous enough ... build one from the ground up. 

What I am implying is that there are no available interfaces right now but it can be done. The JDB interface is already well defined and can be mapped into an ODBC driver. Still, someone has got to sit down and work on it though. 

In the company I work for, we actually had a need for exposing an in-memory tables/database to C# programmers who don't know and doesn't want to know anything about J. So instead of making an ODBC driver, I built an ADO.NET Custom Data Provider in C#. You can find more technical information here: http://msdn.microsoft.com/en-us/magazine/cc301611.aspx

So following the general guideline in building ADO.NET custom data providers, I made on in C# and use my J.Session class (which can be found here: http://www.jsoftware.com/jwiki/Guides/J%20VB.NET ) to access and manipulate the my inverted tables where were stored in J. The C# developers would just use the new data providers and even submit some complicated SQL statements (which are sent directly and parsed in J) and treat J as a normal database.

r/Alex

-----Original Message-----
From: programming-bounces at jsoftware.com [mailto:programming-bounces at jsoftware.com] On Behalf Of dnk0785
Sent: Sunday, November 15, 2009 10:43 PM
To: programming at jsoftware.com
Subject: [Jprogramming] How can get access to JDB?


How can I get access to JDB into external interface, for example Java or C?
Perhaps have ODBC driver to JDB or anything else?

PS: Sorry, if my question is very stupid...
-- 
View this message in context: http://old.nabble.com/How-can-get-access-to-JDB--tp26359649s24193p26359649.html
Sent from the J Programming mailing list archive at Nabble.com.

----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm