Hi, I have an issue at the moment that makes an insert operation fail.
My table is defined as having a nullable FK and when inserting a new row with a null FK value, the statement (as reported by p6spy) contains an empty string instead of NULL as its value - in this case it means that the insert fails as the column itself is a Long/BIGINT. I am using Postgres and OJB 1.0.1. Anyone have any ideas why my statements are being generated this way? Cheers, Phil ================================================================ CAUTION: This e-mail and any attachment(s) contains information that is intended to be read only by the named recipient(s). It may contain information that is confidential, proprietary or the subject of legal privilege. This information is not to be used by any other person and/or organisation. If you are not the intended recipient, please advise us immediately and delete this e-mail from your system. Do not use any information contained in it. ================================================================ For more information on the Television New Zealand Group, visit us online at http://www.tvnz.co.nz ================================================================
