Need help

[Hussein Baghdadi]

Hi.
I'm creatin a simple EJB system.
I have the following database schema :
Table User :
id PK
name not null
email not null
Here is ejbCreate( ) method :

  
public Integer ejbCreate(Integer i, String n, String e) throws create Exception {
setId(i);
setName(n);
setEmail(e);

When running the application in JBoss & MySQl server, I got the following exception :
name field can't be null.
Then I modified my table to allow null values, and every thing is Ok !
any help please ...

[Roger Chung-Wee]

What values were passed in to ejbCreate?

[Hussein Baghdadi]

home.create(new Integer(1), name, email);
nothing special !!

[Roger Chung-Wee]

Ah, what I'm getting at is whether name had a null value. Does your code check for this before invoking home.create?

[Hussein Baghdadi]

Yes, All fields have valid values !

[Dan Bizman]

Well, first check that the value is not null (in two spots):

1. In ejbCreate, simply do a System.out.println( n );
2. In your client, after create check: System.out.println( myBean.getName() );

If both show it's not null, then I'd check the log for the database (if using JBoss' default, it'd be in hypersonic, so check:
$JBoss_Home/server/data/hypersonic/somelogfile.log"

And see what SQL commands it's executing. It's possible that instead of using:

INSERT INTO MyBean VALUES (1, "My Name", "[email protected]")

it could be using:
INSERT INTO MyBean VALUES (1, null, null)
UPDATE MyBean SET Name = "My Name", Email = "[email protected]" WHERE ID = 1

That would be dumb, but you never know.