I'm using MySQL-Max-3.23.51 with Resin's JDBC driver. My mapping.xml is attached. Thanks!
-----Original Message----- From: Patrick van Kann [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 9:51 AM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] enclosing quotes in SQL statement not being added What database are you using? I have seen similar behaviour before in either DB2 or MS SQL Server, but I resolved it. If you could post the full mapping and your database vendor I will see if I can find what caused it (and what the resolution was) Patrick Marc Dugger wrote: >The mapping I'm having problems with is below: > ><field name="name" type="string" required="true" get-method="getName" >set-method="setName" direct="false" lazy="false" transient="false" >container="false"> > <sql name="NAME" type="varchar" read-only="false" dirty="check" /> ></field> ><field name="description" type="string" required="false" >get-method="getDescription" set-method="setDescription" >direct="false" lazy="false" transient="false" container="false"> > <sql name="DESCRIPTION" type="varchar" read-only="false" dirty="check" /> ></field> > >When attempting to insert a database record, the single quotes that delimit >a string in a SQL statement are not being added by Castor. As a result, I >get a SQL exception. As a test, I hand-coded the quotes around the strings >and the statement executed successfully. I've also changed the sql type to >'char' and that didn't work. Has anyone had any similar problems? I've >search the mailing list for mention of this, but found nothing so it makes >me think its trivial. > >----------------------------------------------------------- >If you wish to unsubscribe from this mailing, send mail to >[EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev > > ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
mapping.xml
Description: Binary data
