Problem with parsing sql-type field in jbosscmp-jdbc.xml

dirk.versavel Sep 4, 2002 1:32 PM

When adding an 'sql-type' element in the 'cmp-field' element in the jbosscmp-jdbc.xml file (JBOSS 3.0), I get following error: "org.xml.sax.SAXParserException: Element 'cmp-field' does not allow "sql-type" here."

Although, this sql-type is documented and according to the related dtd which comes with the jboss fileset ($JBOSS_HOME/docs/dtd/jbosscmp-jdbc_3_0.dtd) the sql-type is allowed in the cmp-field element.

But, the PUBLIC version of the dtd which should be availabe on the www.jboss.org site is not available!

What is wrong here??? Which dtd is used by the xml parser here? How to get further???

Please HELP!

1. Re: Problem with parsing sql-type field in jbosscmp-jdbc.xml

dsundstrom Sep 6, 2002 4:32 PM (in response to dirk.versavel)

The order of the child elements matters. Make sure they are in exactally the same order as presented in the dtd.
Actions
2. Re: Problem with parsing sql-type field in jbosscmp-jdbc.xml

dirk.versavel Sep 9, 2002 9:49 AM (in response to dirk.versavel)

I finally found the error!

sql-type should always be used together with jdbc-type!

Rereading the dtd is always interesting.

Dirk
Actions

Go to original post