| Re: database access using JAVA or COM [message #49758] |
Tue, 15 August 2006 08:41  |
Mike Wallace
Messages: 25
Registered: May 2006
|
Junior Member |
|
|
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
|
|
|
|
| Re: database access using JAVA or COM [message #49765 is a reply to message #49758] |
Tue, 15 August 2006 06:33  |
Paul[2]
Messages: 13
Registered: January 2006
|
Junior Member |
|
|
Rick Towler 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 :)
>
>
> An update:
>
> IDLcomIDispatch seems to still suffer from partialimplementationitus.
> Certain methods work and certain properties are accessible, but other
> properties and methods don't work and fail with unspecified errors.
>
>
> cstring='Provider=OraOLEDB.Oracle;Data Source=somedb;User ' + $
> 'Id=user;Password=pass'
> db = OBJ_NEW('IDLcomIDispatch$PROGID$ADODB_Connection')
> db -> SetProperty, ConnectionString=cstring
> db -> Open
> db -> GetProperty, Provider=p, State=s
>
> print, p
> OraOLEDB.Oracle.1
> print, s
> 1
>
> So far so good. I was thinking I was home free...
>
> rs = OBJ_NEW('IDLcomIDispatch$PROGID$ADODB_RecordSet')
> sql = 'Select * from ship'
> rs -> Open, sql, db
>
> % IDLCOMIDISPATCH$PROGID$ADODB_RECORDSET::OPEN: Unable to call method OPEN.
> <unknown system error>
>
> Humm. Here's the interface definition:
>
> [id(0x000003fe), helpcontext(0x0012c8d7)]
> void Open(
> [in, optional] VARIANT Source,
> [in, optional] VARIANT ActiveConnection,
> [in, optional, defaultvalue(-1)] CursorTypeEnum CursorType,
> [in, optional, defaultvalue(-1)] LockTypeEnum LockType,
> [in, optional, defaultvalue(-1)] long Options);
>
>
> O.K. How about something simpler:
>
> rs -> GetProperty, Status=s
>
> % IDLCOMIDISPATCH$PROGID$ADODB_RECORDSET::GETPROPERTY: Unable to access
> property STATUS.
> <unknown system error>
>
> The interface definition:
>
> [id(0x00000405), propget, helpcontext(0x0012c949)]
> long Status();
>
>
> Doesn't get much simpler than that.
>
>
> After writing a couple of wildly successful functions using COM+ADODB in
> MATLAB, I am left a bit underwhelmed with IDL's poor support for COM.
> I've been waiting for a working implementation of IDLcomIDispatch ever
> since it's release in 5.5. I must be the only one... :(
>
> -Rick
Hi Rick,
Is the ADODB a .exe, .dll or .ocx component? My guess is it's an
Application Object stored in a .exe. If so, I have a solution for you
(that will be included in the 6.4 distribution). GIve me a call and
I'll tell you more - 303-402-4679.
Thanks,
-Paul
|
|
|
|
| Re: database access using JAVA or COM [message #49770 is a reply to message #49765] |
Mon, 14 August 2006 16:45 |
Rick Towler
Messages: 821
Registered: August 1998
|
Senior Member |
|
|
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 :)
An update:
IDLcomIDispatch seems to still suffer from partialimplementationitus.
Certain methods work and certain properties are accessible, but other
properties and methods don't work and fail with unspecified errors.
cstring='Provider=OraOLEDB.Oracle;Data Source=somedb;User ' + $
'Id=user;Password=pass'
db = OBJ_NEW('IDLcomIDispatch$PROGID$ADODB_Connection')
db -> SetProperty, ConnectionString=cstring
db -> Open
db -> GetProperty, Provider=p, State=s
print, p
OraOLEDB.Oracle.1
print, s
1
So far so good. I was thinking I was home free...
rs = OBJ_NEW('IDLcomIDispatch$PROGID$ADODB_RecordSet')
sql = 'Select * from ship'
rs -> Open, sql, db
% IDLCOMIDISPATCH$PROGID$ADODB_RECORDSET::OPEN: Unable to call method OPEN.
<unknown system error>
Humm. Here's the interface definition:
[id(0x000003fe), helpcontext(0x0012c8d7)]
void Open(
[in, optional] VARIANT Source,
[in, optional] VARIANT ActiveConnection,
[in, optional, defaultvalue(-1)] CursorTypeEnum CursorType,
[in, optional, defaultvalue(-1)] LockTypeEnum LockType,
[in, optional, defaultvalue(-1)] long Options);
O.K. How about something simpler:
rs -> GetProperty, Status=s
% IDLCOMIDISPATCH$PROGID$ADODB_RECORDSET::GETPROPERTY: Unable to access
property STATUS.
<unknown system error>
The interface definition:
[id(0x00000405), propget, helpcontext(0x0012c949)]
long Status();
Doesn't get much simpler than that.
After writing a couple of wildly successful functions using COM+ADODB in
MATLAB, I am left a bit underwhelmed with IDL's poor support for COM.
I've been waiting for a working implementation of IDLcomIDispatch ever
since it's release in 5.5. I must be the only one... :(
-Rick
|
|
|
|
| Re: database access using JAVA or COM [message #50046 is a reply to message #49758] |
Sun, 03 September 2006 17:47 |
rs.usenet
Messages: 1
Registered: September 2006
|
Junior Member |
|
|
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.usenet@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
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
