Hi Tarun,
Your problem is to update a table where some of the columns don't accept
null values. Actually You can always define whether to accept null values or
not in your database itself. The simplest solution would be to change the
property of the column to accept the null values. But in some of the cases
it is not advisable to do so. Suppose you have a product_id field in your
product table then you shouldn't store null values in the database for
product_id. In this case you need to put a check in your bean where you
should avoid sending null values. For an instance, suppose your updating
string then replace null with " " (blank).
I hope this will solve your problem.
Manish.
> ----------
> From: bhatt[SMTP:[EMAIL PROTECTED]]
> Reply To: A mailing list for Enterprise JavaBeans development
> Sent: Thursday, July 20, 2000 8:14 AM
> To: [EMAIL PROTECTED]
> Subject: Re: your mail
>
> > Hi all,
> >
> > I'm having one problem in BMP that whenever there is null value in
> column
> > then it stores "null" in variable and thus when it tries to update the
> value
> > in the database with "null" value in variable then it gives an error.
> >
> > Somebody pls. explain me the complete solution for this.
>
> I am still unclear about that problem...
> Is it simply not retireving the value or it is retrieving it and not
> correctly throwing it at the client..
> Or is it that the problem is while you try to update in the database by
> sending a null..?
>
> The sol..for the first is that you need to put a check in your bean to
> not to throw a null to the client..
>
> For the second.. iot makes sense again to put a check ..you will not like
> to put a null in your data base..
>
>
>
>
> >
> > Thanks in advance.
> >
> > Tarun
> >
> >
> ==========================================================================
> =
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> > of the message "signoff EJB-INTEREST". For general help, send email to
> > [EMAIL PROTECTED] and include in the body of the message "help".
> >
>
> ==========================================================================
> =
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
