submitting null in one column of db table.

I have 26 fields to be entered in the database registartion tables.All the other values are inserted into the database only one value is being filled <null> .

when this same query i run it manually from db then its accepting the value and not showing null.

Its taking null value in the bean itself.i check it that when we insert a value into the bean getValue() method for this particular it taking <NULL>

Can any one help me.

[463 byte] By [java@mania] at [2007-11-27 6:33:00]

«« Adding Box to BoxLayout JPanel
»» ant not creating jar file

# 1

I don't understand the exact problem nor the exact question. Can you please rephrase?Do you say that it is putting the string "null" literally in the database?

BalusCa at 2007-7-12 17:58:46 >

top of Java-index,Enterprise & Remote Computing,Web Tier APIs...

# 2

Yes for the address column in the database its specifying <null> .rest all the other values it showing all the values i am inserting.

java@mania at 2007-7-12 17:58:46 >

# 3

Then use the keyword null instead of the String "null".

BalusCa at 2007-7-12 17:58:46 >

# 4

I am not getting what u want to say?are u giving me clue to the solution or just advacing to use this.

java@mania at 2007-7-12 17:58:46 >

# 5

You have to use the keywordnullinstead of the String"null"Or don't you understand what's a "keyword" and a "String" ?

BalusCa at 2007-7-12 17:58:46 >

# 6

I am not assigning any null value to the address field.while entering the value to the database it automatically specifies the null.

i have declared the variable like

String address;

created getter and setter for it.

So while getting the values from the bean its giving null. And henceforth

submiting this value into the database null.

java@mania at 2007-7-12 17:58:46 >

# 7

Well, then I still don't understand what's the exact problem and question.

BalusCa at 2007-7-12 17:58:46 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

submitting null in one column of db table.

Enterprise & Remote Computing Hot Topic

Enterprise & Remote Computing

All Classified