Labkey.Query.insertRows throws null value exception for primary key

LabKey Support Forum (Inactive)
Labkey.Query.insertRows throws null value exception for primary key Matthew Bellew  2011-11-28 17:31
Status: Closed
 
This is very strange behavior. I'll take a look as soon as I have a second. My guess is that the code does not realize that m_requirementid is a serial.

I should know, but I'm not sure how this is reported by JDBC. I do know that there is a way to specify this in the schema xml.

        <ns:datatype>serial</ns:datatype>
        <ns:isAutoInc>true</ns:isAutoInc>
        <ns:isReadOnly>true</ns:isReadOnly>
        <ns:isKeyField>true</ns:isKeyField>