MySQL Connector/J and XADataSources

2003-02-19 Thread Frank Gates
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

Native XADataSource for MySQL

2003-02-19 Thread Frank Gates
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

Re: Database Structure

2002-10-10 Thread Frank Gates
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

Re: SubQueries and Temp Tables

2002-06-27 Thread Frank Gates
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

Re: get months between two dates

2002-06-24 Thread Frank Gates
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