- This topic has 3 replies, 2 voices, and was last updated 19 years, 2 months ago by
.
-
Posts
-
Hi,
I’ve seen this mentioned in a few other posts, but the reasoning tends to be: “It would be nice to have the same support for XYZ as you have for Oracle”. Actually, I think there is a good business reason for doing this.
Oracle of course provides java tools for their own database. Last time I looked, JDeveloper, for instance, is free, and provides integrated support for every Oracle-specific feature imaginable. This puts MyEclipse in the odd position, in spite of your extremely reasonable pricing, of charging more for Oracle tools than Oracle itself. If I had to do a project based on Oracle, I would probably choose to use their own toolset, rather than Eclipse in general, or MyEclipse in particular.
Microsoft, on the other hand, provides no real java tool support of MSSQL at all. What tools they do provide for developing stored procedures, triggers, etc., are expensive (i.e., Visual Studio > $1000). This would make MyEclipse Professional, at $50, an extremely attractive alternative. As I mentioned, if you are doing J2EE development against SQL Server, you are pretty much forced to seek a non-Microsoft tool solution anyway.
Retrieving and storing stored procedure, trigger, and user function names and content are simple SQL queries against the sysobjects, syscomments, etc. tables. “Run procedure” could be implemented using a simple “EXEC”. The biggest job would probably be prvoiding syntax highlighting for T-SQL in the editor.
If you were willing to use JNI, you could probably even tie in to the SQL Server Debugging COM components, which would let you debug T-SQL in the IDE, but thats probably hoping for too much 😀 .
Dave
Dave
Your reasons are all very sound and well thought out, we agree that the Oracle support maybe seem like an odd choice but it was specifically financed by a large customer of ours that needed it. Although your reasoning for supporting other DBMS’s are all good suggestions, I will send your comments on to management to let them decide if this is something we want to target right now, or if this is down-the-road type work.Ah well, if the Oracle enhancements were funded externally, I understand completely. And I would revise my statement about using Oracle tools somewhat: If I were targeting the entire Oracle J2EE stack, it would make sense to use their own tools, but if I simply needed to use an Oracle database behind, say a WebLogic server, using Hibernate instead of TopLink, MyEclipse would definitely be a better choice.
I also looked into the TSQL debugging idea over the weekend, and it seems that would not be possible. The debugging API is completely private to MS, and as far as I know, nobody has ever reverse-engineered it. So, unless MS gave you the super-secret COM interfaces, (and as far as I can tell, they’ve never done that for anyone), forget it.
Still, stored procedure editing would be nice.
Dave
Dave I brought this to the attention of management this morning and was notified that this is already a strategy we are looking into possibly before 5.0, so your wish may be granted sooner than I thought. No promises, this is just speculation at this point, some issues may push these types of features back.
