Hi all,

I am inserting data into a table via EJB. The problem is that sometimes that data cannot be retrieved by a SQL query (EJB and manually). I can see the data in a data view but if I try to query like:

SELECT * FROM user_detail WHERE user_name='someguy'

it doesn't show... BUT:

SELECT * FROM user_detail

returns all users... including 'someguy'

AND:
If I wait a while or restart the server, the top query works. Does anyone know why this is happening? It's quite frustrating because in many places in the application I rely on that data being available. Any help on this matter would be greatly appreciated.

Cheers,
Dave

I'm using:
JBoss 3.0.0
MySql 3.23.49
Driver: mm.mysql-2.0.1.1-bin.jar

MySqlDS



<config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://localhost:3306/moxrocks</config-property>
<config-property name="DriverClass" type="java.lang.String">com.mysql.jdbc.Driver</config-property>
<!--set these only if you want only default logins, not through JAAS -->
<config-property name="UserName" type="java.lang.String"></config-property>
<config-property name="Password" type="java.lang.String"></config-property>




<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->


0
50
5000
15
<!--criteria indicates if Subject (from security domain) or app supplied
parameters (such as from getConnection(user, pw)) are used to distinguish
connections in the pool. Choices are
ByContainerAndApplication (use both),
ByContainer (use Subject),
ByApplication (use app supplied params only),
ByNothing (all connections are equivalent, usually if adapter supports
reauthentication)-->
ByContainer