RE: access-mysql
thnx to all! am checking this links out.. looks great! :) -Original Message- From: Crercio O. Silva [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 5 de Dezembro de 2002 12:30 To: MySQL List Subject: Re: access-mysql DBTools works great on this matter. You find it at http://www.dbtools.com.br/EN and is totally free. []s Crercio - Original Message - From: Sandeep Murphy [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 12:39 PM Subject: access-mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - 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 - 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 - 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
access-mysql
Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - 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
Connection pool
Hi, Does anyone has a connection pool built for MySQL using JAva (the application run on Tomcat).. I have one but its not running satisfactorily and leaves some processes suspended.. thnx in adv, sands - 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 processes..
hi, I have a problem with the connections and would appreicate a lot if anyone can provide a soln.. Our JSP application has connections to both Oracle and MySQL... In each page there are nearly a dozen queries executing on a MySQL db. at the begining of each page, a connection is opened and at the end they are close.. Ideally, if the user waits for the page to load completely and then hit the button Next or Cancel, the connection is freed.. But what happens often is that soon after entering the page, many users just click on Next resulting in the connection not getting closed...and soon, the no of connections exceed the allotted number (because they dont get freed automatically) and thus crashes the application.. My question is this: Is there anyway to kill the processes in MySQL (ofcourse i can do it manually but am talking about real time) ??? thnx for any suggestions.. sands - 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: MySQL processes..
Hi Mark,
Yes, the code is wrapped by a try , catch, finally block but still we r facing
suspended connections.. :(
am using MysqlFront to administer the dbs and i can kill the suspended/delayed
processes manually..
Does mysqladmin provide any other additional services??
thnx,
sands
-Original Message-
From: Mark Matthews [mailto:mark;mysql.com]
Sent: quinta-feira, 17 de Outubro de 2002 13:05
To: Sandeep Murphy
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL processes..
Sandeep Murphy wrote:
hi,
I have a problem with the connections and would appreicate a lot if anyone can
provide a soln..
Our JSP application has connections to both Oracle and MySQL... In each page there
are nearly a dozen queries executing on a MySQL db. at the begining of each page, a
connection is opened and at the end they are close.. Ideally, if the user waits for
the page to load completely and then hit the button Next or Cancel, the connection is
freed..
But what happens often is that soon after entering the page, many users just click
on Next resulting in the connection not getting closed...and soon, the no of
connections exceed the allotted number (because they dont get freed automatically)
and thus crashes the application..
Wrap your code with a try/finally{} block, and in the finally block, put
your connection.close(). It will always get called, no matter whether or
not the user clicks next.
My question is this: Is there anyway to kill the processes in MySQL (ofcourse i can
do it manually but am talking about real time) ???
mysqladmin will let you kill threads.
-Mark
--
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
___/ www.mysql.com
-
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
