Jag Bains

Hi,

I have the same issue. If you have a fix, can you paste a copy of your JSP and the relevant part of your backing bean and session bean so that I can see how you managed to get it to work.

Thanks a lot

Hi,

Not sure if this is the right forum, but I just wanted to know your ideas on the Visual Web Framework.
I have been using netbeans 6.5 and the Visual Web JSF Framework to create web site. I just downloaded Netbeans 6.7 and notice that this framework is not available when creating a new project.

Does anyone know why?

Is this framework superseded by another framework, or is there a plugin that I am not aware of?

I would appreciate your thought on this as I don't want to go down a track where in the medium term the framework becomes not supported.

Thanks
J

thanks. Works a treat.

Is this the correct way to enforce pessimist locking?

Hi,

I was wondering how I could implement database locking using EJBs and JPA.
I am using glassfish and MySQL and I believe I have to set up some properties in the persistence.xml, but I don't know what these are.

It would also be useful if I could specify which entities beans need this locking strategy.

The reason for the question is that I wrote a simple ejbClient that accesses a session bean which in turn adds 1 to a column in the database table using an entity manager.
The client spawns 3 threads each try to update the same row but in there own transaction. When I run the client the different threads use the same entity and hence produce the folliwng output :

t = 79 for caller2 runs = 0 t = 80 for caller3 runs = 0 t = 79 for caller1 runs = 0 t = 80 for caller2 runs = 1 t = 80 for caller1 runs = 1 t = 81 for caller3 runs = 1

What I really need is to somehow synchronise the access to the entity beans, so that only 1 client can update it at once.

The code below is of the test client

package ejbclientexample; import com.jag.sessionBeans.NewSessionRemote; import javax.ejb.EJB; public class Main { @EJB private static NewSessionRemote newSessionBean; /** * @param args the command line arguments */ public static void main(String[] args) { System.out.println("In Main()"); System.out.println(newSessionBean.toString()); int t = newSessionBean.incCounter("Main"); System.out.println("t = "+t); //System.out.println("Finished"); ThreadTest ca1 = new ThreadTest("caller1"); ThreadTest ca2 = new ThreadTest("caller2"); ThreadTest ca3 = new ThreadTest("caller3"); System.out.println("created 3 threads"); ca1.start(); ca2.start(); ca3.start(); while (ca1.isAlive() && ca2.isAlive() && ca3.isAlive()) { try { Thread.sleep(1000); } catch (InterruptedException e) { e.printStackTrace(); } } } } package ejbclientexample; import com.jag.sessionBeans.NewSessionRemote; import javax.ejb.EJB; import javax.naming.InitialContext; public class ThreadTest extends Thread { private int runs; private String name; @EJB private static NewSessionRemote newSessionBean; public ThreadTest(String name) { super(); runs = 0; this.name = name; } @Override public void run() { for (runs = 0; runs < 10; runs++) { //System.out.println("In run () for " + name); newSessionBean = retrieveRemoteInterface(); //System.out.println(newSessionBean.toString()); int t = newSessionBean.incCounter(name); System.out.println("t = " + t + " for " + name +" runs = " + runs); //System.out.println("runs = " + runs + " for " + name); } System.out.println("Finished for " + name); } public int getRuns() { return runs; } private NewSessionRemote retrieveRemoteInterface(){ try { InitialContext ic = new InitialContext(); NewSessionRemote ns = (NewSessionRemote) ic.lookup(NewSessionRemote.class.getName()); return ns; } catch (Exception ex) { System.out.println("Couldn’t create newsession bean."+ ex.getMessage()); } return null; } }


The session bean method does the following:
@TransactionAttribute(TransactionAttributeType.REQUIRED) public int incCounter(String name) { Query q = em.createNamedQuery("Test.findByIdtable1") .setParameter("idtable1", 1); Test t = (Test)q.getSingleResult(); t.setCounter(t.getCounter()+1); em.persist(t); em.flush(); return t.getCounter(); }

I would appreciate if someone could point me in the right direction.

Thanks

Hi,

I have the same issue. Did you get to the bottom of what was wrong?

Thanks

Jag

I found out how

Needed to add :

@Resource
protected SessionContext ctx;

Then to rollback

ctx.setRollBackOnly();

Works a treat.

Hi,

I am new to J2EE v5 and I am trying to understand how CMT and JTA work

I want to rollback a transaction in Stateless SessionBean and all the documentation I have read is that I should use setRollBack on the EJBContext.

I have created a testcase where I increment a number in the DB, call the persist on the EntityManager and then try to roll it back using em.getTransaction().setRollbackOnly(); . When I do this I get returned an error
'java.lang.IllegalStateException: Exception Description: Cannot use an EntityTransaction while using JTA. '

I used netbeans 6.5 to create the sessionbean and the corresponding enity

Below is my session bean

package com.jag.sessionBeans; import com.jag.entities.Test; import javax.ejb.Stateless; import javax.persistence.Query; import javax.persistence.EntityManager; import javax.persistence.NonUniqueResultException; import javax.persistence.PersistenceContext; import javax.persistence.Transient; import org.apache.log4j.Logger; import com.jag.entities.User; import javax.ejb.TransactionAttribute; import javax.ejb.TransactionAttributeType; /** * Login stateless Session bean * @author */ @TransactionAttribute(TransactionAttributeType.REQUIRED) @Stateless public class LoginBean implements LoginRemote, LoginLocal { @PersistenceContext private EntityManager em; @Transient private static transient Logger log = Logger.getLogger(LoginBean.class); public void persist(Object object){ em.persist(object); } public int incrementCounter(){ log.debug("in incrementCounter"); Query q = em.createNamedQuery("Test.findByIdtable1") .setParameter("idtable1", 1); Test t = (Test)q.getSingleResult(); log.debug("got back "+t); t.setCounter(t.getCounter()+1); persist(t); em.getTransaction().setRollbackOnly(); log.debug("should have saved "+t); return t.getCounter(); } }

I would appreciate if someone could put me on the right track and even post an example session bean that I could use as a template.

Thanks

Sorry I should have mentioned that I am using Netbeans 6.5

My JSF page is (login.jsp):

<jsp:root version="2.1" xmlns:f="http://java.sun.com/jsf/core" xmlns:h="http://java.sun.com/jsf/html" xmlns:jsp="http://java.sun.com/JSP/Page" xmlns:webuijsf="http://www.sun.com/webui/webuijsf"> <jsp:directive.page contentType="text/html;charset=UTF-8" pageEncoding="UTF-8"/> <f:view> <webuijsf:page id="page1"> <webuijsf:html id="html1"> <webuijsf:head id="head1" title="Hawkstone Res"> <webuijsf:link id="link1" url="/resources/stylesheet.css"/> <webuijsf:script id="script1" url="/test.js"/> </webuijsf:head> <webuijsf:body id="body1" onLoad="onLoadFunction()" style="-rave-layout: grid"> <webuijsf:form id="form1"> <webuijsf:label for="userCode" id="labelLab" style="position: absolute; left: 312px; top: 216px; width: 96px; height: 24px" text="#{msgs.User_Code}"/> <webuijsf:textField binding="#{Login.userCode}" id="userCode" maxLength="10" required="true" style="left: 432px; top: 216px; position: absolute" toolTip="User Code"/> <webuijsf:label for="password" id="passwordLab" style="height: 24px; left: 312px; top: 264px; position: absolute; width: 96px" text="Password"/> <webuijsf:passwordField binding="#{Login.password}" id="password" maxLength="10" required="true" style="position: absolute; left: 432px; top: 264px; width: 120px; height: 24px" toolTip="password"/> <webuijsf:button actionExpression="#{Login.loginBtn_action}" id="loginBtn" style="position: absolute; left: 312px; top: 336px; width: 120px; height: 24px" text="Login"/> <webuijsf:messageGroup id="messageGroup1" showGlobalOnly="true" style="left: 288px; top: 384px; position: absolute; width: 358px"/> <webuijsf:message for="userCode" id="errorMessage" showDetail="false" showSummary="true" style="left: 576px; top: 216px; position: absolute"/> <webuijsf:message for="password" id="message1" showDetail="false" showSummary="true" style="position: absolute; left: 576px; top: 264px; width: 120px; height: 24px"/> </webuijsf:form> </webuijsf:body> </webuijsf:html> </webuijsf:page> </f:view> </jsp:root>

I have a webuijsf:messageGroup id="messageGroup1" on the page and I want to populate it with a message from the page bean login.java as follows:
package vjsftest; import com.sun.rave.web.ui.appbase.AbstractPageBean; import com.sun.webui.jsf.component.PasswordField; import com.sun.webui.jsf.component.TextField; import org.apache.log4j.Logger; import javax.ejb.EJB; import javax.faces.FacesException; import javax.persistence.Transient; import com.sun.webui.jsf.component.Hyperlink; public class Login extends AbstractPageBean { private void _init() throws Exception { } private TextField userCode = new TextField(); public TextField getUserCode() { return userCode; } public void setUserCode(TextField tf) { this.userCode = tf; } private PasswordField password = new PasswordField(); public PasswordField getPassword() { return password; } public void setPassword(PasswordField pf) { this.password = pf; } public Login() { } @Override public void init() { super.init(); try { _init(); } catch (Exception e) { log("Login Initialization Failure", e); throw e instanceof FacesException ? (FacesException) e: new FacesException(e); } } @Override public void preprocess() { } @Override public void prerender() { } @Override public void destroy() { } protected SessionBean1 getSessionBean1() { return (SessionBean1) getBean("SessionBean1"); } protected ApplicationBean1 getApplicationBean1() { return (ApplicationBean1) getBean("ApplicationBean1"); } protected RequestBean1 getRequestBean1() { return (RequestBean1) getBean("RequestBean1"); } public String loginBtn_action() { this.info("Message from resource bundle"); return null; } }

In my loginBtn_action, I want to display a message that is displayed in messageGroup1.
What should I do to display a message from the resource bundle?

Hi

I have a backing been which extends AbstractPageBean.
I want to output a message from the bundle

e.g.
this.info("message fro m bundle");

How do I do this?

Thanks

Jag

Hi,

Does anyone know how to configure XA datasource Orion.

I am usineg ms sql server 2000 and i need to know how to set up data-source.xml so that i can use BMT with my stateless session bean.

Thanks.

jag

hi,

I have my log4j.jar and my log4j.properties in my Orion/lib dir.

That seems to work fine for me

how do i find the correct class to use for the XA data source?
I'm using MS sql server 2000.

Hi Roger,

My vender is Orion. Looking at the documentation, it states I should be setting up the datasource as:

3.5 Configuring a vendor XA DataSource for EJB or CMT usage

In order to use a vendor implementation of a XA DataSource for EJB or CMT usage, the DataSource has to be wrapped by the OrionCMTDataSource class in order for Orion to add support for distributed transactions and pooling as necessary.

This setup requires two DataSource configuration entries; one defining the vendor XA DataSource and another defining the wrapping Orion DataSource (OrionCMTDataSource) for EJB or CMT usage.

Below is an example of such a setup using Inet Opta 2000 XDataSource for MS SQL Server 7.0:

<data-sources> <!-- vendor XA DataSource -->
<data-source
name="vendorXA"
location="jdbc/vendorXACoreDS"
class="com.inet.tds.XDataSource"
username="sa" password="" host="localhost" > <property name="databaseName" value="sample"/> </data-source>
<!-- Orion CMT DataSource --> <data-source name="default" location="jdbc/defaultCoreDS" class="com.evermind.sql.OrionCMTDataSource" xa-source-location="jdbc/vendorXACoreDS" schema="database-schemas/ms-sql.xml" /> </data-sources>


Listing 5: A sample XA Datasource for EJB or CMT usage DataSource entry.

The first DataSource configuration entry listed above creates a Inet Opta2000 DataSource and binds it to the JNDI location " jdbc/vendorXACoredDS". The name of the database to use is stated in a parameter name-value pair as this parameter is not part of the normal parameters defined for data-source.xml entries, but the vendor's implementation needs this value.

The second DataSource configuration entry listed above creates a OrionCMTDataSource on top of the first DataSource and binds it to the JNDI location " jdbc/defaultCoreDS". As this DataSource needs to be used on top of a existing XA DataSource, the JNDI location value of the xa-source-location attribute is given a value of " jdbc/vendorXACoredDS", which will point it to the first DataSource (see above).

The second DataSource configuration entry listed above would become the default DataSource for all applications deployed after this DataSource descriptor has been deployed as its the first DataSource listed to use the OrionCMTDataSource.

Hi Valentin,

Understand what you are saying and will change.

However, I not 100% sure this will make any difference. Its almost as if I am missing something obvious when setting up the datasource or connection or UserTransaction.

How do I create a TX data source?