views:

281

answers:

2

Hello, I add entity to my database and it works fine. But when i retrieve the List, i get the old entity, the new entities i add are not shown until i undeploy the application and redeploy it again. This means are my entities cached by default? But, I haven't made any settings for caching entities in my persistence.xml or any such file.

I have even tried calling flush(), refresh() and merge(). But still it shows the old entities only. Am i missing something? Please help me.

+1  A: 

Welcome to JPA. If you use it, it means you will have huge problems if you update the database outside of JPA unless you know what you're doing and are very careful. This means you have to figure out how to flush any cached entities so they can be reloaded.

Basically, don't update entities outside JPA if you can at all help it and if you do you will probably have to get into the workings of the caching model used by your particular JPA provider. If you need to update outside JPA a lot then JPA probably isn't the right choice for you.

cletus
But i am not updating database outside of JPA. I used persist method of jpa and record is seen in database. But when i retrieve list, i don't see the newly added entity. Please help me.
Ankit Rathod
Also, even more weird is the fact that if i change the provider from TopLink to EclipseLink, everything works fine! With TopLink only this problem is coming. I am using Netbeans 6.8 and Glassfish v3.
Ankit Rathod
@Nitesh are you using transactions? If so are you committing them?
cletus
I am not using any transaction using entitymanager.getTransaaction or any container managed transaction. I could see the record in database but not in the list i retrieve. Basically, what happens is say there are employee and department tables. Department table has employee collection. So if i persist employee record, then it is seen in database but not in collection of employees in department until i explicitly add it to the collection of employees. Is this necessary step? if i have 10 tables relating to one entity. Do i have to add it to collection of all 10 tables? That's too tedious?
Ankit Rathod
@Nitesh oh different problem. Yes you absolutely must manage the Java objects by putting it into that collection.
cletus
So, if i have 10 tables, i must remember all the table names and add it to those collections? I thought, ORM is super smart to detect the links and modify it accordingly.
Ankit Rathod
@Nitesh it's the other way: you update the objects and the database is updated to reflect that. You have to consider if you want your one-to-many relationships to be unidirectional or bidirectional too. Just because you can have a collection of entities on the one side doesn't mean you should.
cletus
+1  A: 

This means are my entities cached by default?

JPA 1.0 does not define a L2 cache ("shared cache"), JPA 1.0 only defines an L1 cache ("transactional cache") but JPA providers can support a shared object cache, and most do. This is the case of TopLink Essentials which supports L1 and L2 cache through JPA Extensions for Caching (per JVM).

Now, as explained in the great article Understanding the cache of TopLink Essentials(GlassFish JPA):

  • All EntityManagers from same persistence unit shares the session cache (that's how TopLink calls the 2nd-level cache).
  • Session cache is turned on by default.
  • If there is modifications/deletions of entities in the persistence context they are synchronized to session cache after a transaction committed, so the state of session cache is updated (or such a cache wouldn't be usable at all).

So there must be something else wrong with your setup. You can try do disable the shared session cache for testing purpose (and only for testing purpose) by adding the following property:

<property name="toplink.cache.shared.default" value="false"/>

But I would be surprised if this changes anything. As I said, I think there is another problem somewhere.

PS: This doesn't answer the question but, if you are using GlassFish v3, why don't you use EclipseLink?

Update: answering a comment of the OP

So if i persist employee record, then it is seen in database but not in collection of employees in department until i explicitly add it to the collection of employees. Is this necessary step?

Well, if you don't create the link between entities at the Java level, JPA won't be able to create it at the database (JPA only does what you tell him to do). So, yes, you need to create the link and, in case of a bidirectional association, you even need to set both sides of the link (for example add the employee to the collection of employees on the Department and set the department of an Employee).

Pascal Thivent
Hi Pascal Thivent, i provider to EclipseLink in my persistence.xml and everything worked fine. But still i have another doubt, that i asked to cletus also :-Basically, what happens is say there are employee and department tables. Department table has employee collection. So if i persist employee record, then it is seen in database but not in collection of employees in department until i explicitly add it to the collection of employees. Is this necessary step? if i have 10 tables relating to one entity. Do i have to add it to collection of all 10 tables? That's too tedious?
Ankit Rathod