Hi Ana,
If you open a connection like this for every user, then the whole purpose of
connection pooling used by the EJB Server is lost I suppose. (In CMP).
By the way, is there anyway, I can get access to the connection pools used by
the EJB Servers?? Does any of the EJB servers provide API to access the
connections in their connection pool??
Regards,
Sripada
"Bhattacharyya, Ana" wrote:
> Hi Subu,
> u need to do something like this in your ejbCreate method for CMP
>
> public CustomerPK ejbCreate(String custname, int age)
> throws CreateException,
> RemoteException
> {
> System.out.println(" In create of Cust");
> this.custcode = getSeqCode();//This is the PK say..
> this.custname = custname;
> this.age = age;
>
> return null;
> }
>
> private int getSeqCode()
> {
>
> try
> {
> Connection con = getConnection();
> PreparedStatement ps = con.prepareStatement("select
> testseq.nextval from dual");
> ps.executeQuery();
> ResultSet rs = ps.getResultSet();
> int i = 0;
> while (rs.next())
> {
> i = rs.getInt(1);
> }
> rs.close();
> return i;
> }
> catch(Exception e)
> {
> e.printStackTrace();
> return 0;
> }
> }
>
> This will work. But I think there are lot other solutions for this ---
> namely one followed by IAS. U can check the archive for those.
> HTH
> Anamitra
>
> -----Original Message-----
> From: Vdaygiri, Subu [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 25, 2000 12:34 PM
> To: [EMAIL PROTECTED]
> Subject: Primary Key - sequence from Oracle
>
> In J2EE CMP (container - managed) bean, what changes I might need to make to
> the bean or PK class in order to use a sequence from Oracle to generate the
> primary key ?
>
> Thanks a lot for the 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".
===========================================================================
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".
