JDBC Connections

Friday, August 24, 2007

JLINQ really isn't


I was going to reserve comment on IBM's recent article on JLINQ but I really can't help myself. Here's a link to the article:

http://www.ibm.com/developerworks/db2/library/techarticle/dm-0708ahadian/index.html?ca=drs

LINQ stands for Language INtegrated Query, which this clearly is not. I don't know if Microsoft has any rights to the name LINQ or not, but I think it very poor form of IBM to actually use the term for something that is not technically correct. LINQ is something that is actually integrated into the programming language itself, like Microsoft is integrating it into C# for instance. Then, you can actually do your queries in C# instead of SQL (examples here).

JLINQ is nothing of the sort. This is merely a new ORM style code generator for Eclipse that IBM has made. It's certainly an interesting idea on ORM to me, but that's all it is. In a nutshell, you install the JLINQ package and tell your application what JDBC driver to use. Then, it connects to the database and your Eclipse project suddenly becomes "Database Aware". Neato, this is a cool idea. By being database aware, you can then have better SQL validation as you write the queries (or optionally generate them) as you code. Example: if you type "selct" the SQL validator will ask to change it to "select" (I've got some friends who can't type and really need this!). Also, since you're connected to the DB, you can get instant validation of columns and metadata as you go, which is also helpful. Once you define what you want in terms of a query (or object definition for the ORM stuff) you can right click and have choices to generate a SQL Bean or JLINQ code. Furthermore, you can simply right-click on a table in the Database Explorer and choose "Generate JLINQ Code" and you'll automagically get a CRUD interface for your table. Certainly seems like this will save some time.

All things considered, this seems like it is a neat idea in that it combines a nice database aware project with content assist and automagic code generation of CRUD objects and/or beans.......but by no stretch of the imagination is it LINQ. I will certainly be playing around with it in the upcoming weeks; however, I'll be using our DataDirect Connect for JDBC drivers to do the work and so I'll let you all know how it goes.

-J

Oh, some posters on channel9 at Microsoft certainly have strong opinions if you're interested: http://channel9.msdn.com/ShowPost.aspx?PostID=335603

Labels:

Thursday, August 23, 2007

The Desktop Revived?



I've just finished a really good article in Dr. Dobb's Journal entitled, "The Return of the Desktop". The basic premise of the article is that for several years applications have become more and more web-centric and now it's time to break free of the browser and return to the desktop. I couldn't agree more.

Several months ago I was browsing Adobe's lab site, labs.adobe.com, when I came across a really neat technology called Apollo (It's since been renamed AIR - Adobe Integrated Runtime). I played with some of the demo applications and they were simply breathtaking! However, what really caught my eye was what eBay was doing with it. They had written an Apollo application that you could place on your desktop and run outside the browser, making it appear as a normal desktop application. Just Cool.

I'm really digging the new technologies popping up in this area. Things are just getting started so it will be interesting to see where we end up with all these new models popping up. I for one will continue to read, investigate, and try to keep up with all the new technology and terminology - bringing my personal views of it to you here on my blog. I'm especially interested in where data access is going in this area. The bottom line is that whatever you do eventually deals with data, which is one of the reasons I work at the company thats the leader of data access.

It's going to be a fun ride....

Labels: