Were using JBoss 3.2.3 with MySQL 4.1.13 and using JDBC connector 3.1.10 for a development that has lots of different sub-systems. Each sub-system has its own connection pool. When part A of the system gets a message from an external source it writes some data to the database, then passes that data's ID to another part of the system (B) which then eventually sends that data onto part C of the system. Part C of the system then tries to retrieve the data that part A put into the database using the passed ID.
Our problem is that every so often part C cannot retrieve the row in the database - even although part A specifically comitted the data to the database. It is an occasional issue (say 1 out of every 20 times). Each part uses its own connection pool as I said earlier. It seems to be a cache issue to do with JBoss.
I was wondering if this was a known issue with JBoss 3.2.3 or if anyone else has had this problem and knows what it is.
Thanks for any help with this,