Native XADataSource for MySQL
Hello, Earlier I asked Mark about XA and Connector/J. He said that it was dropped from the 3.0 releases because MySQL doesn't natively support XA, but when it does he will add it back in. Mark suggested that I ask for XA on these lists if I wish to expedite it in the pipeline. I am raising the flag here for XA, but not to exceed work on stored procedures and views. I believe that two-phase commit with XA should be natively supported so that it will compete effectively with other database providers in those instances where two-phase is valuable. My personal requirement for it is minimal at this time. I am developing an application server development framework (which is MySQL-centric) and so have need to support XA connection pooling and resources. I had already developed an XAResource-wrapper for PooledConnection's when I discovered that XA was dropped from Connector/J 3.0. It is a small task for me to wrap ConnectionPoolDataSource's with an XADataSource implementation for now. But I do express my desire for native XA in MySQL. (The app server framework is intended to build customizable containers as well as EJB containers. The motive for this framework is that there are some applications that fit the application server model but not the EJB model or only part of the J2EE model.) Frank Gates [EMAIL PROTECTED] - 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
MySQL Connector/J and XADataSources
Mark, I read in the release notes that there is an implementation of XADataSource (MySQLXADataSource), which does exist in the 2.0.14 release. I've looked in the 3.x releases and do not see it. Am I just not seeing it? Is this also planned for the 3.x releases? Thanks, Frank - 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
Re: Database Structure
Stephanie, Without knowing the architecture of your program I cannot give a precise answer. But I'll make a few stabs at it... First, MySQL, being an application in its own right, can be installed separately from your application. Alternately, your application's installation program could include calling the MySQL installer. The user could bypass that step if it has already been installed. Future upgrades of your program would not require MySQL to be reinstalled, though the tables and databases it uses may need refreshing. Second, MySQL is network-based, so that you may have MySQL installed on one or more machines and your application installed on other machines. It would require as part of the installation process that the IP address for the MySQL server, its port, username, password, etc. be supplied. Hope this helps, Frank Stephanie Piet wrote: > Does anyone know if there's a way in MySQL have the same functionality > without installing the whole program on a users machine? I'm using a Java > program along with Connector/J and a MySQL DB. We are trying to make it so > the user doesn't have to install MySQL everytime they want to install the > program on their machine. > > Thanks, > Stephanie > > - > 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
Re: SubQueries and Temp Tables
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
Re: get months between two dates
Use the month(date) function. select month(firstDate) - month(secondDate) from someTable where ...; Hope this helps. Frank "D.K.Dubey" wrote: > Hi, Can anybody tell me how i can calculate the months between two dates in > mysql. > thanks in advance > Regards > D K Dubey > > - > 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