3 Replies Latest reply on Mar 14, 2005 7:51 AM by dave wright

    cmp using mysql 4.0 and jboss 4.0.1 problems

    dave wright Newbie

      I am currently using mysql 4.0 and jboss 4.0.1. I'm trying to use cmp beans but having problems with the deployment.

      I've copied the msql-ds.xml file into the deploy directory and successfully got the jbosscmp-jdbc.xml file in the jar. all looks good until I try and access the database via the bean. an sql syntax error is thrown. looking in the server log indicates that the insert sql being written is
      2005-03-11 12:36:37,756 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.G_Audit] Insert Entity SQL: INSERT INTO table-name="G_Audit" (pk_G_AuditId, auditText, auditDate, auditType) VALUES (?, ?, ?, ?)

      This sql doesn't work. Replacing table-name="G_Audit" with G_Audit does

      Can anybody help with suggestions of what part of my config is wrong