Dave, The language that the server is written in is irrelevant. Oracle, SQL Server, Sybase and most other databases are written in C and Java developers do business in them just fine. That's why JDBC is for. Many legacy systems are written in C, C++, or other language. That is another area where EJB shines, in frontending legacy systems with Java/JSP clients. The reason this makes sense to most is because this is how the real world works.
I love writing in Java and don't want to go back to C/C++; but C/C++ makes sense for operating systems like Linux or db systems like MySQL. That isn't likely to change in the next 10-20 years, if ever. Even when 20Ghz+ machines come about and a "Java Linux" would be reasonable, the C version is already there and would still greatly outperform a Java version. The same is true for any of the database systems out there, including MySQL So bridges between these worlds is where the action is. Other people can best answer your objections to MySQL itself. For myself, I believe that it does support most of '89 but do wish it had Stored Procedures. Subselects are on the way. Foreign key support is coming, though I don't care for that much. The transactional tables covered the biggest objections I had. I am able to do "real" database applications with it as are many professional database developers. Cheers, Frank Dave Morse wrote: > NO - mine is a honest question. An "open source" server in C and a > client in Java makes sense, I guess to some. > > > -----Original Message----- > > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, June 26, 2002 5:37 PM > > To: Dave Morse; 'Arul'; [EMAIL PROTECTED] > > Cc: 'MySQL' > > Subject: RE: SubQueries and Temp Tables > > > > > > At 7:16 -0700 6/26/02, Dave Morse wrote: > > >MySQL is barely an SQL database - it doesn't support much > > basic SQL 89 > > >functionality. Can any one throw some light on why professional SQL > > >database developers want to use it for anything but simple file > > >management? AND It is written in C as well so why do Java developers > > >use it? > > > > Given that the server is a separate program than Java developers > > would write *clients* for, why would it matter in the least what > > language the server is written in. > > > > You're trolling, right? > > > > > > > >Regards, > > > > > >Dave > > > > > >> -----Original Message----- > > >> From: Arul [mailto:[EMAIL PROTECTED]] > > >> Sent: Tuesday, June 25, 2002 9:05 PM > > >> To: [EMAIL PROTECTED] > > >> Cc: MySQL > > >> Subject: SubQueries and Temp Tables > > >> > > >> > > >> Hi All > > >> > > >> I am currently porting our application from Oracle to MySQL. > > >> We have some subqueries in oracle which cannot be ported into > > >> MySQL.We even > > >> tried some joins which didnt work out.. > > >> > > >> So Could anyone throw some light on Temporary tables.Is this > > >> the right way > > >> to do it.. > > >> > > >> Since our main query is dependent on the inner query we > > >> thought we could > > >> run > > >> the inner queryfirst and create a temp table.Then we could > > >> have a join > > >> between the main table and the inner table. > > >> > > >> Is this advisable.. > > >> > > >> Any other better options? > > >> > > >> Regards, > > >> -Arul > > >> > > >> > > >> > > >> > > --------------------------------------------------------------------- > > >> Please check > > >> "http://www.mysql.com/Manual_chapter/manual> _toc.html" before > > >> > > >> posting. To request this thread, e-mail > > >> [EMAIL PROTECTED] > > >> > > >> To unsubscribe, send a message to the address shown in the > > >> List-Unsubscribe header of this message. If you cannot see it, > > >> e-mail [EMAIL PROTECTED] instead. > > >> > > > > > > > > > > > >--------------------------------------------------------------------- > > >Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > > >To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > >Trouble unsubscribing? Try: > > http://lists.mysql.com/php/unsubscribe.php > > > > > > --------------------------------------------------------------------- > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before > posting. To request this thread, e-mail [EMAIL PROTECTED] > > To unsubscribe, send a message to the address shown in the > List-Unsubscribe header of this message. If you cannot see it, > e-mail [EMAIL PROTECTED] instead. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
