0 Replies Latest reply on Jan 6, 2003 4:32 PM by Dave E

    Cannot query inserted data

    Dave E Newbie

      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