database access using JAVA or COM [message #49780] |
Mon, 14 August 2006 11:19  |
Rick Towler
Messages: 821 Registered: August 1998
|
Senior Member |
|
|
Has anyone made any database connectivity tools publicly available? I
know that Mike Wallace has done a lot of work with the IDL-Java bridge
and JDBC but I don't think he has released anything. I have worked with
the ADODB COM object and plan to experiment with it in IDL this
afternoon but ideally someone will have already done this :)
-Rick
|
|
|
Re: database access using JAVA or COM [message #50767 is a reply to message #49780] |
Wed, 18 October 2006 09:25  |
Rick Towler
Messages: 821 Registered: August 1998
|
Senior Member |
|
|
My quest for database connectivity continues...
ADO + IDL's COM interface is a no go. Despite the work of Paul and
others, IDL's com interface is still not complete. It is unable to
properly return arrays of type variant containing mixed types nor is it
able (as best as I can tell) return arrays of arrays of type variant. I
will submit my feature request and hope for the best but I am not
holding breath.
Renaud, I have dropped you a couple of emails with no response so I will
try one last time by posting here. I would very much like to test
DataJiver. Please email me or post additional information.
-Rick
On Sep 3, 5:47 pm, rs.use...@gmail.com wrote:
> Hello,
>
> I will be releasing such a tool at the ADASS conference
> (http://www.adass.org/) next month. Here is the abstract that I have
> submitted for a poster:
>
> "We have developped a Java middleware to access relational databases
> from IDL (Interactive Data Language by RSI, now ITT). Our middleware
> combines the new Java-Bridge feature available in IDL from version 6.0
> with the proven JDBC interface, drivers for which are available for all
> relational databases from PostgreSQL and MySQL to Oracle and Sybase
> etc. DataJiver simplifies access to these databases by providing the
> developers with IDLs object that can dynamically map to the result set
> from SQL statements, thus facilitating the developments of business
> objects capable of hibernation."
>
> In the meantime if you are interested to test the package, please drop
> me an email.
> ---
> Renaud Savalle <rs.use...@gmail.com>
> Research Engineer, CNRS, France
>
> Mike Wallace wrote:
>> Rick Towler wrote:
>>> Has anyone made any database connectivity tools publicly available? I
>>> know that Mike Wallace has done a lot of work with the IDL-Java bridge
>>> and JDBC but I don't think he has released anything. I have worked
with
>>> the ADODB COM object and plan to experiment with it in IDL this
>>> afternoon but ideally someone will have already done this :)
>>
>> Yes, I have played around with it quite a bit, but unfortunately I'm in
>> a situation where it's difficult for me to release code (too much red
>> tape and hassle). As far as COM goes, you're on your own. I've only
>> worked with the Java side.
>
>> -Mike
|
|
|