Hi
I didnt hard code all those "jdbc:oracle:thin:@..","scott","sss"...
I use weblogics connection pool
static
{
new weblogic.jdbc.jts.Driver(); // force static initialization
}
public Connection getConnection()
throws SQLException
{
//return
DriverManager.getConnection("jdbc:weblogic:jts:oraclePool");
InitialContext ctx = null;
try {
ctx = new InitialContext();
DataSource ds = (javax.sql.DataSource)
ctx.lookup("java:comp/env/jdbc/oraclePool");
return ds.getConnection();
} catch(NamingException ne) {
ne.printStackTrace();
return null;
} finally {
try {
if(ctx != null) ctx.close();
} catch(NamingException ne) {
ne.printStackTrace();
return null;
}
}
}
U can avoid hardcoding easily by setting those parameters as JNDI
name./value pairs.
For ejb1.0 u can set env props.
Ana
-----Original Message-----
From: Vdaygiri, Subu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 2:44 PM
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Primary Key - sequence from Oracle
Ana,
Thanks for your reply.
The solution you provide works fine. Is there a way to not hard-code the
getconnection ("jdbc:oracle:thin:@..","scott","sss") ?
Also, I saw a solution using "BeforeInsert" method in the PK class but the
container (I am testing with J2EE) never calls it. I am copying the code
from the message by Malcolm Sparks ..
public class CustomerPK implements java.io.Serializable {
public double id;
....
public void beforeInsert(java.sql.Connection conn) throws
java.sql.SQLException {
java.sql.Statement statement=conn.createStatement();
java.sql.ResultSet rs=statement.executeQuery("select
customer_seq.nextval from dual");
rs.next();
this.id=rs.getDouble(1);
}
}
This appears to be a cleaner way of doing but the container in my app never
calls the beforInsert. Did you have any luck with similar solutions.
Thanks a lot,
Subu
e-mail: [EMAIL PROTECTED]
> -----Original Message-----
> From: Bhattacharyya, Ana [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 25, 2000 12:52 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Primary Key - sequence from Oracle
>
>
> 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".
