• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Issues upgrading Mysql 4.1 to Mysql 5.1

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
i am not sure if i am posting in the right forum, if i am not please excuse me

i have an xml file which defines two actions, for two different states



i have a java class which parses this xml and updates the database.
in the first step, the field has to be updated from "reviewing_ofc" to "converting" and in the second step, i read this value of "converting" and then modify it to "awaiting_download".

we have used MySql 4.1 for a very long time now and we never had any issues with it. but now since i have upgraded to MySQL 5.1, i started having this problem.

on my developer machine, earlier i used to get an error no transition "notify_records" found for action "reviewing_ofc". so essentially before the write action is performed, the read action is taking place. i thought this might be some connector issues, so i searched for all the traces of the previous connector mysql-connector 3.0.8 , and when i removed all the traces of it. the application was working fine, i had no issues for a long time. when i work with the same application on different machines. on some machines , i got the same error, on some i never got that error even though i never changed anything or even removed the traces of previous connectors. now that was weird. there was this particular build machine, on which i had deployed the application and there were no issues for a long time. but one find day suddenly, i got that error, and that broke the application.
1) on some machines, i never got that error.
2) on some machines, i always get that error.
3) on some machines, it happens randomly

all the machines have same configurations.

windows xp, jboss 4.0.5, jdk 1.4, mysql 5.1 with connector 5.0.8.

the solution that i have right now is, if i go back to mysql 4.1, everything works like a charm, like nothing ever happened before. i would really appreciate it , if someone can help me with this issue. or else all the time i spent on upgrading from mysql 4.1 to 5.1 will be wasted.

Regards,
Shashi
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic