|Regaurding that alpha release... Well, there have
been some COM issues that have delayed me. Specifically, the
Type library indicates that
the overloaded java methods are represented in the type library as accepting variants for input.
However, when I attempt to call one of the methods from another language, only the last overloaded
method's data type is accepted, even though the type library indicates a variant. Apparently there
is a problem with using overloaded methods in COM with JAVA.
So I have two possible solutions. Use javareg, which works great and correctly with the polymorhism issue, but you don't get intellisense in the development environment and you must copy the class files to the trustlib and register them with javareg on the target machine. (Sounds like a distribution ass-pain to m although some creative scripting might help) or make a VB mirror port just for the ActiveX component, thus keeping two projects really.
I have to think about this, but any suggestions would be helpfull on the COM issue. Use the Sourceforge forum for this project if you have any insights... The alpha should be out soon, one way or another.
I am publishing the Alpha 0.5 version tonight with API documentation
published online and as part of the JAVA package.
I have published the Pre-Alpha version of the interface and the Oracle 8i
implementation. You can get them at https://sourceforge.net/projects/j-sql-api/.
It's definately functional for JAVA based select, update, insert and delete
statements, even complex ones. But a few features still need to be implemented
like Case-Select logic and some other more complex stuff.
The ActiveX DLL is working crappy for now. It will work, but you can't see the function names in intellisense in VB and you can't see any of the static Operators in the O8OPERATORS class. You can still just pass the right string to make it work, but this needs to be fixed. I have to edit the type library manually for the ActiveX DLL. I will be doing that this weekend.
Note that there is no way to do joins at this point. So this is really academic until I implement that code (unless you're not doing any joins.) I would reccomend that developers wait until the alpha is out before trying to use this seriously, unless you feel like implementing the join functionality yourself. :] And if you do send me the code for shit sake!
Here's an example JAVA class (with output).
Looking for feedback and bugs right now.
The purpose of this project is to create an interface for a JAVA Dynamic SQL Generator that can be included in any java application
or compiled to a MS COM DLL and called from any programming language under Windows that can reference a COM DLL. This project is
cross-platform in the sense that under LINUX one can use JAVA and include the ADO-SQL-API package to gain this set of functionality.
Further, I intend to implement this interface for Oracle 8i and perhaps 9i, but I will probably leave implementations for MySQL, MS SQL Server and other databases to others. I intend to stricty enforce compliance with the most recent version of the interface.
Since this project is in the planning stages currently, (though I have written the first interface and partially implemented it for Oracle 8i at this time), this site will be spartan and devoted to talking about devlopment until I/we get a usable alpha out.
Shortly, I will be uploading the interface in it's alpha release form such that others can implement it for other databases.
The Sourceforge page for this project is located at https://sourceforge.net/projects/j-sql-api/.
Scott D. Keefe
Boston, Ma. (USA)
firstname.lastname@example.org (soon to be @comcast.com because the world is full of morons... :/)