asked on

how to update a null date in JAVA

I would like to ask JAVA developers this question. I encounter a situation where my java program failed to read a null date in a Oracle table. The compile error is 'JAVA NULL POINTER EXCEPTION'. What should be the logic in code to handle this situation. I am initialize my date field as date. I try to initialize my date field as string to get around this issue and not working either. All input welcome. Thanks

SOLUTION

for_yan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CEHJ

You could try the following or ResultSet.wasNull

Object date = resultSet.getObject(n);
if (date == null) {
   // Take action
}

Open in new window

for_yan

Post your code and we'll try to find the solution.
This is definitely better than trying to store date as string - sooner or later
you'll regret doing it in your database - I had a few cases like that in the old tables - since then
trying to cope with this unfortuinate decision

and I'm sure we'll find something how to deal with null pointer

ASKER CERTIFIED SOLUTION

fobosik

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

lmymusic2000

ASKER

I've found the solution on my own. Thank you for all of your respond

lmymusic2000

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for lmymusic2000's comment http:/Q_27430686.html#37126318

for the following reason:

I've found the solutions. Thank you for all the responds.

CEHJ

>>I've found the solution on my own. Thank you for all of your respond

Sorry - that's not an acceptable response

lmymusic2000

ASKER

Hi Mod,
Actually other team members in this project found the solution to this question and I do not know what is the actual coding behind this. Please close this question and thank you for all the respond

CEHJ

Sorry that's not acceptable either. No refund