Hi Shiv,

If your database, jdbc driver, or application server does not support the
conversion then the following is a solution:

// bean fields
private boolean _married;
public char married; // cmp field

in ejbLoad...
  _married = (married=='Y'); // the married cmp field will be set prior to
this call

in ejbStore...
  married = (_married) ? 'Y' : 'N'; // synch the cmp field before storing..
this is why WebLogic should call ejbStore and then try to detect change

in ejbCreate...
  _married = married;

// bean methods
boolean isMarried() { return _married; }
isMarried(boolean married) { _married = married; }

Very quickly and untested but I think this should be a workaround. There is
probably something more elegant in the jdbc driver or appserver manual.

kind regards

William Louth

> -----Original Message-----
> From: Shiv Kumar [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 02, 2000 12:27 PM
> To:   [EMAIL PROTECTED]
> Subject:      Oracle - boolean - CMP
>
> Hi all
>
> One of the columns in my table should be interpreted as boolean data type.
>
>   1. How do I create the table (if not for EJB, I would have had char(1)
> with
>      'Y' and 'N' as valid values)?
>
>   2. What special settings should be done in the deployment descriptor so
> that
>      my CMP entity bean can work this way:
>
>           home.create(int empID, String empName, boolean married);
>
> Thanks.
> --
> shiv
> [EMAIL PROTECTED]
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://im.yahoo.com
>
> ==========================================================================
> =
> 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".


***********************************************************************
Bear Stearns is not responsible for any recommendation, solicitation,
offer or agreement or any information about any transaction, customer
account or account activity contained in this communication.
***********************************************************************

===========================================================================
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".

Reply via email to