Re: Witango-Talk: crashing witango 5 on OS X

[Roland Dumas]

On Dec 1, 2005, at 1:20 PM, Robert Shubert wrote: Next thoughts:   Can you upgrade your software to the latest versions?   Mac OS DB Driver MySQL Witango in theory, yes. This is an ecommerce site and it's the holidays. Who knows how long it would take to do the clean install of everything and get it working again.    (HINT: you can try asking WT for a 15-30 day temporary server license for 5.5, that way you can set it up side-by-side on your server and test without spending any $.)   Also, can you use another method of connecting to your database, JDBC vs ODBC? I tried switching to JDBC when ODBC was crashing it. JDBC crashed it more often, so we upgraded everything to get ODBC stable and working. There was  a signature for ODBC failures. It showed up in the crash log and is unmistakeable. This isn't that kinda crash. The crashed thread is witango   From a database perspective:   Copy all the data into a new table Drop the existing table Recreate your table Copy all the data back will try this... Drop and recreate all indexes how do you do that?   This has only helped me solve a problem back on older versions of P.SQL, but might be worth trying.   And the test best for last:   Create a Stored Procedure that retrieves the records you need and just call it with a Witango DirectDBMS. I think mysql's latest incarnation allows for stored procedures (I'm not running version 5), but I'm a little fuzzy on how you'd do that to be the equivalent of select * from orders where order_number = x   Robert ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf