Version 1



       Some body can give me some link, tutorial or sample code

       How in the EJB function there to get the connection to Database that can call Oracle Sequence like this


       GetSequenceID( SequenceName SN){


         sql="select "+SN +".nextval from dual";



         Connection conn = DBHelper.getConnection();


        stmt = conn.createStatement();

        rs = stmt.executeQuery(sql)








             Properties props=new Properties();


             props.put(Context.INITIAL_CONTEXT_FACTORY, "org.jnp.interfaces.NamingContextFactory");




             props.put(Context.URL_PKG_PREFIXES, "org.jboss.naming:org.jnp.interfaces");


             InitialContext context=new InitialContext(props);



            Object obj = (new javax.naming.InitialContext()).lookup(JNDI_DATASOURCE);


            DataSource ds = (DataSource) obj;

            return ds.getConnection();





      How to define the JNDI_DATASOURCE??

      It is posible use xDoclet to generate it?

      What is the xDoclet command?


      My System Enviroment Here:

      a) JBOSS EAP 4.3

      b) EJB 2.1

      c) JDK 1.6