On 9/7/05, Daniel Perry <[EMAIL PROTECTED]> wrote: > What i mean, is that you cant do: > > <field-descriptor > name="deleted" > column="deleted" > jdbc-type="TINYINT" > conversion="org.apache.ojb.broker.accesslayer.conversions.Boolean2IntFieldCo > nversion"/> > > It would make sense to use tinyint for booleans.... as they only really need > 1bit! > > Problem is... i am using xdoclet to make the repository and torque to make > the database. So, i have to use INTEGER in the xdoclet comment, so it ends > up as integer in the database. I previously have put it as INTEGER then > used tinyint in mysql - but with xdoclet, everything is automated.
What is the problem with this declaration ? Does XDoclet complain (it shouldn't) or does the JDBC driver complain or Torque ? Could you post the error and the generated SQL ? Btw, you could also try to use BIT as the datatype, it's meant to be used for boolean columns. Tom --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]