0 Replies Latest reply on Oct 28, 2002 11:12 AM by Mads Hansen

    Is JBoss generating incorrect SQL?

    Mads Hansen Newbie

      I cannot get a simple CMP example to work (e.g.
      http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/ I have enabled debugging and during deployment the SQL statements JBoss will use are written to the console (se below). All statements but insertion seem to missing a where-clause. Why is the SQL incorrect? Am I missing something in my deployment descriptor (se above link). Can I overwrite the SQL statements JBoss will use for entity check, removal etc. I have the problem with both PostgreSQL and MySQL.

      Any help would be appreciated. I have purchased the JBoss admin and cmp docs but I can seem to find anything related to my problem.

      17:13:39,704 INFO [EjbModule] Creating
      17:13:39,725 INFO [EjbModule] Deploying Account
      17:13:39,910 INFO [EjbModule] Deploying Customer
      17:13:39,983 INFO [EjbModule] Deploying CurrencyConverter
      17:13:40,166 INFO [EjbModule] Created
      17:13:40,167 INFO [EjbModule] Starting
      17:13:40,266 DEBUG [Customer] Initializing CMP plugin for Customer
      17:13:40,457 DEBUG [Customer] Loading standardjbosscmp-jdbc.xml : file:/opt/jboss-3.0.3_new/server/default/conf/standardjbosscmp-jdbc.xml
      17:13:41,221 DEBUG [Customer] jar:file:/opt/jboss-3.0.3_new/server/default/tmp/deploy/server/default/deploy/myjar.jar/64.myjar.jar!/META-INF/jbosscmp-jdbc.xml found. Overriding defaults
      17:13:42,834 INFO [STDOUT] New customer created.
      17:13:42,835 INFO [STDOUT] New customer created.
      17:13:42,852 DEBUG [Customer] Entity Exists SQL: SELECT COUNT(*) FROM customers WHERE
      17:13:42,853 DEBUG [Customer] Insert Entity SQL: INSERT INTO customers (ssn, name) VALUES (?, ?)
      17:13:42,859 DEBUG [Customer] Remove SQL: DELETE FROM customers WHERE
      17:13:43,287 INFO [Customer] Table 'customers' already exists
      17:13:43,300 DEBUG [findByPrimaryKey] SQL: SELECT FROM customers WHERE
      17:13:43,307 DEBUG [Customer] Added findByPrimaryKey query command for home interface
      17:13:43,308 INFO [EjbModule] Started