How to make primitive types accept null values in jbosscmp-j

[rakeshkamat]

Hi,
I am a beginner with Jboss and I am trying to crete a CMP entity bean with JBoss-4.0.2. The requirement is that only the primary key field is not null and the others could be null.
The problem is whenever i declare any integer fields, jboss creates them as not-null fields. When i call the create method on the entity bean it throws an error. Because some of the fields are not null fields(fields other than the pk). Is there anyway I can override this??? Thanks for all ur help.
My jbosscmp-jdbc.xml looks like this
<jbosscmp-jdbc>

<enterprise-beans>

<ejb-name>cabinEJB</ejb-name>
<table-name>cabin</table-name>
<cmp-field>
<field-name>shipId</field-name>
<column-name>shipId</column-name>

</cmp-field>
<cmp-field>
<field-name>bedCount</field-name>
<column-name>bedCount</column-name>

</cmp-field>
<cmp-field>
<field-name>deckLevel</field-name>
<column-name>deckLevel</column-name>

</cmp-field>
<cmp-field>
<field-name>name</field-name>
<column-name>name</column-name>

</cmp-field>
<cmp-field><!--PRIMARY KEY-->
<field-name>id</field-name>
<column-name>id</column-name>
<not-null/>
</cmp-field>

</enterprise-beans>

</jbosscmp-jdbc>

[iwadasn]

Generally, you should use the wrapper types for this, such as Integer, for exactly this reason. Just rewrite your code to change....

int -> Integer
boolean -> Boolean
double -> Double
etc...

That will allow you the freedom to use/detect nulls.

[rakeshkamat]

Thanks iwasdasn,
I converted all ints to Integers, didn't have any doubles or booleans in the code.
Unfortunately the problem persists. Is there any change to be made to the jbosscmp-jdbc.xml file?

Appreciate ur help.

[iwadasn]

Ah, there must be a setting for it....

There is a simple way to find these settings. Look at your jbosscmp-jdbc.xml file. If this was properly made (perhaps by XDoclet) then it should have a dtd. This DTD will give you a webpage, here's what the address should be...

http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_4_0.dtd

The parser uses the document at this location to verify your file, therefore, any options that are allowed in the file will be defined in this page.

Search this page for "null" and you should find what you're looking for. If you can't read a DTD, you should take a few minutes to learn the basics, but pretty much, you need to write something that looks like this...


<cmp-field>
<field-name>id</field-name>
<column-name>fid</column-name>
<not-null />
</cmp-field>

[rakeshkamat]

o i c...
well i am not using xdoclet.. my jbosscmp-jdbc.xml is manually created by me :(

could u kindly paste a sample jbosscmp-jdbc.xml for me...

Thanks for all ur help.

Thanks and Regards.