can't persist entities on app engine using jpa
i am trying to persist two entities(with one to many relationship) using jpa but on persit it throws an exception java.lang.IllegalArgumentException: out of field index :2 i'm struck. ...
jpa
[Toplink] How to add c3p0 or DBCP Connection pool?
Hello, Could you please explain to me how to add a standalone c3pO or DBCP connection pool to my toplink-based JPA project? I have a persistence.xml file, and everytime I want to query the database, I'm doing this: EntityManagerFactory emf = this.getEntityManagerFactory(); // Surely using persistence.xml to set up the factory Enti...
JPA : many-to-many - only one foreign key in the association table
I mapped two classes in a ManyToMany association with these annotations : @Entity @Inheritance(strategy=InheritanceType.TABLE_PER_CLASS) public abstract class TechnicalItem extends GenericBusinessObject implements Resumable{ @SequenceGenerator(name="TECHNICAL_ITEM_ID_GEN", sequenceName="TECHNICAL_ITEM_ID_SEQ") @Id @Column(n...
How to create a Clob in JPA in an implementation agnostic way
Hello I am using Ejb3 and JPA (based on Hibernate and Oracle 10g at the moment) I have an entity that contains a clob @Entity @Table(name = "My_TAB") public class ExampleEntity implements java.io.Serializable { private Clob someText; public void setSomeText(Clob someText) { this.someText= someText; } @Column...
Is JPA persistence.xml classpath located?
Here's what I'm trying to do. I'm using JPA persistence in a web application, but I have a set of unit tests that I want to run outside of a container. I have my primary persistence.xml in the META_INF folder of my main app and it works great in the container (Glassfish). I placed a second persistence.xml in the META-INF folder of my ...
Class not found exception (org.apache.openjpa.enhance.PersistenceCapable) thrown in a client of WLS 10
I am developing an aplication using WLS 10 When i try to conect (lookup) to an EJB from a specific jar of my ear aplication, an exception of type "ClassNotFoundException" of the class "org.apache.openjpa.enhance.PersistenceCapable" is thrown in the client has anybody found a reason for this workaround? Thanks in advance ...
Can't create EntityManager
New to EJB3, please help/explain. Inside a session bean I declare an EntityManager as follow @PersistenceContext(unitName="ScheduleUnit") private EntityManager em; and this works. But when I do this private EntityManager em; private EntityManagerFactory emf; public void myFunction() { emf = Persistence.createEntityManagerFactory...
JPA 2.0 EclipseLink Check for unique
Hello... I have a collumn as unique=true.. in Exam class.... I found that because transactions are commited automaticaly so to force the commit i use em.commit() However i would like to know how to check if it is unique.Running a query isnt a solution because it may be an instert after checking because of the concurency.... Which is ...
Examples of good JPA Java Desktop Application
I have learnt JPA recently. Now I want to use it in one of my commercial product. But before proceeding, I want to see some example JPA Java Desktop applications so as to have a better understanding of using JPA in desktop applications. I have searched google for this but all I found was tutorials on JPA with examples of entities. I ne...
How do i set the Transaction Isolation in EJB?
Hello, I am not able to find a way to set TransactionIsolation in ejb. Can anybody tell me how do i set it? I am using persistence. I have looked the following classes : EntityManager , EntityManagerFactory, UserTransaction. None of them seems to have any method like setTransactionIsolation or such. Do we need to change persistence.xm...
Saving order of a List in JPA
Hello, I have the following question about JPA: Can I save the order of the elements in a java.util.List? In my application the order in which I put elements in the Lists is important but after I get those collections from the database the order is not the same (as expected). Can you show me a way to deal with this problem? P.S. There...
How to use Hibernate SchemaUpdate class with a JPA persistence.xml?
I've a main method using SchemaUpdate to display at the console what tables to alter/create and it works fine in my Hibernate project: public static void main(String[] args) throws IOException { //first we prepare the configuration Properties hibProps = new Properties(); hibProps.load(Thread.currentThread().getContextClassLoader(...
hibernate insert to a collection causes a delete then all the items in the collection to be inserted again
I have a many to may relationship CohortGroup and Employee. Any time I insert an Employee into the CohortGroup hibernate deletes the group from the resolution table and inserts all the members again, plus the new one. Why not just add the new one? The annotation in the Group: @ManyToMany(cascade = { PERSIST, MERGE, REFRESH }) @JoinTab...
JPA - How to persist java.util.Set through JPA?
I have a field aliases of type java.util.Set in one Entity. This Set doesn't denote any relationship to an Entity. Q1. How can I store this aliases field through JPA? Q2. How this field get stored in database? I think that for the database, this field is a multi-valued attribute. ...
Why does Hibernate ignore the JPA2 standardized properties in my persistence.xml?
I have an extremely simple web application running in Tomcat using Spring 3.0.2, Hibernate 3.5.1, JPA 2, and Derby. I am defining all of my database connectivity in persistence.xml and merely using Spring for dependency injection. I am using embedded Derby as my database. Everything works correctly when I define the driver and url pro...
Deleting orphans with JPA
I have a one-to-one relation where I use CascadeType.PERSIST. This has over time build up a huge amount of child records that has not been deleted, to such an extend that it is reflected in the performance. Now I wish to add some code that cleans up the database removing all the child records that are not referenced by a parent. At the m...
JPA ManyToMany referencing issue
I have three tables. AvailableOptions and PlanTypeRef with a ManyToMany association table called AvailOptionPlanTypeAssoc. The trimmed down schemas look like this CREATE TABLE [dbo].[AvailableOptions]( [SourceApplication] [char](8) NOT NULL, [OptionId] [int] IDENTITY(1,1) NOT NULL, ... ) CREATE TABLE [dbo].[AvailOptionPlanTypeA...
What transaction manager should I use for JBDC template When using JPA ?
I am using standard JPA transaction manager for my JPA transactions. However, now I want to add some JDBC entities which will share the same 'datasource'. How can I make the JDBC operations transactional with spring transaction? Do I need to swith to JTA transaction managers? Is it possible to use both JPA & JDBC transactional service wi...
ORM in the realworld
I am begining a new project that i think will last for some years. Am in the point of deciding the ORM framework to use (or whether to use one at all). Can anyone with experience tell me whether orm frameworks are used in realworld applications. The problem i have in mind is this: The orm tool will generate for me tables and columns etc ...
Is this possible: JPA/Hibernate query with list property in result ?
In hibernate I want to run this JPQL / HQL query: select new org.test.userDTO( u.id, u.name, u.securityRoles) FROM User u WHERE u.name = :name userDTO class: public class UserDTO { private Integer id; private String name; private List<SecurityRole> securityRoles; public UserDTO(Integer id, String name, List<SecurityRole>...