Hi, Ricky!
You can do explicate commit and rollback, but not the way you're doing
it. What you need to do is take a look at using Bean Managed
Transactions, rather than the default container managed. This lets you do
commit/rollback at the transaction level.
You could also look at putting your key fetching code in a stateless
session bean whose methods are marked as 'RequiresNew' transaction. This
will also make porting to a different database easier.
On Wed, 28 Mar 2001, Ricky wrote:
>
> Hi all , i am using jboss2.1 , linux6.1 ,Tomcat 3.2.1 and jdk1.3.
> Can implemented the code below in my stateless bean ???
> Can i do commit and rollback explicit in EJB ??
>
> Thanks wt.
>
> try{
>
> conn = this.getConnection() ;
> conn.setAutoCommit(false);
> ps = conn.prepareStatement("Select NEXTVAL('userprojectinfo_seq')
> from userprojectinfo_seq");
> rs = ps.executeQuery();
> conn.commit()
>
> if(rs.next()){
> projectinfojb.setProjectid(rs.getInt("nextval"));
> }
> }
> catch(Exception ce){
> ce.printStackTrace();
> try{
> conn.rollback();
> }
> catch(SQLException se){}
> }
> projectinfohome.create(projectinfojb);
> }
> else throw new UserException("Project no is already exist ");
> }
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
--
Dan Christopherson (danch)
nVisia Technical Architect (www.nvisia.com)
Opinions expressed are mine and do not neccessarily reflect any
position or opinion of nVISIA.
---------------------------------------------------------------------------
If you're a capitalist and you have the best goods and they're
free, you don't have to proselytize, you just have to wait.
-Eben Moglen
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
