Win a copy of JDBC Workbook this week in the JDBC and Relational Databases forum
or A Day in Code in the A Day in Code forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
  • Piet Souris
  • salvin francis
  • fred rosenberger

Issues upgrading Mysql 4.1 to Mysql 5.1

Posts: 1
  • Mark post as helpful
  • send pies
  • 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.

For my next trick, I'll need the help of a tiny ad ...
Devious Experiments for a Truly Passive Greenhouse!
    Bookmark Topic Watch Topic
  • New Topic