Hi Eric, On Mon, 2003-08-18 at 20:38, Eric Emminger wrote: > Peter > > >>I am calling save on an object from the following table :- > >> > >> <table idMethod="native" name="name"> > >> <column name="id" primaryKey="true" required="true" type="BIGINT"/> > >> <column name="projectid" type="BIGINT"/> > >> <column name="title" size="255" type="VARCHAR"/> > >> <column name="status" size="255" type="VARCHAR"/> > >> <column name="released" type="BOOLEANCHAR"/> > >> <column name="open" type="TIMESTAMP"/> > >> <column name="closed" type="TIMESTAMP"/> > >> <column name="reference" size="255" type="VARCHAR"/> > >> <column name="summary" type="LONGVARCHAR"/> > >> <column name="wcategory" size="255" type="VARCHAR"/> > >> <column name="valuerange" type="BIGINT"/> > >> <column name="location" type="BIGINT"/> > >> <column name="accesslistno" type="BIGINT"/> > >> <column name="notes" type="LONGVARCHAR"/> > >> <column name="useapprlist" type="BOOLEANCHAR"/> > >> <column name="listing" size="255" type="VARCHAR"/> > >> <column description="Flag to enable bid handling" > >> name="enablebidhandling" type="BOOLEANCHAR"/> > >> <column description="xml fragment giving policy" > >> name="policy" type="CLOB"/> > >> <column name="createdat" type="TIMESTAMP"/> > >> <column name="modifiedat" type="TIMESTAMP"/> > >> <column name="tclass" type="BIGINT"/> > >> </table> > >> > > I am not using any arrays. Since my original post, I have discovered > > that this error occurs when I try to save an incomplete record, not sure > > which field is causing the error, but I'm not sure that it should throw > > an error like this anyway. > > Interesting. I believe the "policy" field is causing the error. The > org.postgresql.jdbc1.AbstractJdbc1Statement.setBinaryStream(AbstractJdbc1Statement.java:1257) > > method is a Large OBject (LOB) thing, and policy is a CLOB. > According to some logging code inserted into village it is the LONGVARCHAR fields that are causing the problem when they are null. The empty CLOB is not causing a problem. Now I have to work out why? ...
Regards, Peter > Eric > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- Peter Courcoux <[EMAIL PROTECTED]> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
