How to insert data in database.

[pvs22]

I'm designing an application which using jsf and jpa. I want to insert the data in the database. I tried using named query but I'm getting an error:

Exception Description: Syntax error parsing the query
line 1, column 0: unexpected token [INSERT].

When I try to do it this way:

em.getTransaction().begin();
em.persist(objDefectInfo);
em.getTransaction().commit();

I get the following error:
Cannot use an EntityTransaction while using JTA.

I'm really confused about the way to insert data in the database.

[gusto2]

[Naum Dicovski]

Hi,

Basically, the named queries are used for gathering information from the
database and not for performing DML queries.

The other exception that you get is about the transaction itself. If you
are using EJB to back the JSF, the bean has transaction integrated
transparently (unless you explicitly specify that you don't want to use
JTA). In fact JTA stands for Java Transaction API.
So, when you are using EJBs, you don't need (and obviously can not use)
explicitly declared transaction. The code should work if you remove the
"em.getTransaction().begin();" and "em.getTransaction().commit();" from
the code.
Each EJB call is executed as one transaction which is handled by the EJB
container implicitly. So if you have multiple JPA operations in one EJB
method, then they will all be either commited, or rolled back.


On 03/21/2011 11:17 PM, pvs22 wrote:

[pvs22]

Thanks gusto2 and Naum.

I'm really new to JavaEE, Netbeans and JPA development. I resolved the error just by using em.persist().