cmp using mysql 4.0 and jboss 4.0.1 problems

[taz_is_dave]

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


Thanks

[joshua_hj]

Hi there!

I cannot even make a cmp bean to Jboss 4 using xdoclet 1.2.2. I have errors in deployment. I was wondering if u can tell me how did u make yours. Do i have to change something in lomboz or xdoclet? Did u follow any tutorial or something?

Thanks and i´m sorry could help


Joshua

[darranl]

taz_is_dave, Can you post the 'ds.xml' that you have deployed and the jboss.xml if you have one for the bean.

Joshua, Although your problems initially may have similar issues your problem is completely different, can you start a new post describing what you have done along with your errors.

[taz_is_dave]

thanks for the replies guys. I've managed to sort out what the problem was. Niether mysql or jboss was the culprit. It was in my usage of xdoclet 1.2.2.
I'd been trying to use the tag @jboss:table-name table-name="Audit"

I should have used @jboss:table-name Audit

The other tags I've used all took key/value pairs but this one doesn't