How update the data from my database in my application java with Hibernate?

Question

I'm new to using Hibernate. And my problem is: I'm developing a desktop application. This application is used in different computers. When a computer adds a new user to my database, the other computer can't see the new user until he does not close and open the application again.

I undestand that is because the sessionFactory is different.

I use Hibernate to read users.

session = Settings.sessionFactory.openSession();

String selectSql = "select c.idClient, c.name FROM Clients c WHERE c.active=1 ORDER BY c.name";

Query query = session.createQuery(selectSql);
List<Object[]> listUsers = query.list();

for (Object[] data : listUsers) 
{
     cmbClient.addItem(new ItemCombobox(data[0].toString(), data[1].toString()));
}

Is your desktop app using Hibernate internally, or do you have Hibernate in your server? Do you re-run the query periodically? Are you using the query cache? — Alexander Torstling
– Alexander Torstling, Commented Oct 21, 2015 at 11:53

cristianhh · Accepted Answer · 2015-10-21 11:28:21Z

1

try opening and closing a transaction every time you are done with an operation

// Non-managed environment idiom Session sess = factory.openSession(); Transaction tx = null; try {
    tx = sess.beginTransaction();

    // do some work
    ...

    tx.commit(); } catch (RuntimeException e) {
    if (tx != null) tx.rollback();
    throw e; // or display error message } finally {
    sess.close(); }

See: https://docs.jboss.org/hibernate/orm/3.3/reference/en/html/transactions.html

answered Oct 21, 2015 at 11:28

cristianhh

14812 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Edwin Jarosiński · Accepted Answer · 2015-10-21 11:41:53Z

0

First of all the thougt :

I undestand that is because the sessionFactory is different.

is completly not true. I'd rather better to you read some information how java apps communicate with databases.

If you make your query you fetch data from database and have your local copy in jvm(Java virtual machine) memory. So if you want to get new copy of data from database you have to simply make a query to database once again(after on second computer the add an user operation done), not reset your application.

edit: note : the SessionFactory is only used once in whole application.

edited Oct 21, 2015 at 11:41

answered Oct 21, 2015 at 11:32

Edwin Jarosiński

711 silver badge4 bronze badges

Comments

Szarpul · Accepted Answer · 2015-10-22 07:28:22Z

0

It is probably associated with Hibernate second-level catch. You can read about it here. From this text:

Second level cache is created in session factory scope and is available to be used in all sessions which are created using that particular session factory. It also means that once session factory is closed, all cache associated with it die and cache manager also closed down.

You can turn off second level catch, but you have to be careful as it may influence your performance. How to configure second-level catch in Hibernate, you can read here.

edited Oct 22, 2015 at 7:28

answered Oct 21, 2015 at 12:03

Szarpul

1,58111 silver badges23 bronze badges

2 Comments

karim mohsen Over a year ago

it had to do nothing with second level caching , you had to enable the second level caching yourself

Szarpul Over a year ago

@karim How do you know he didn't take the project after someone with this option already enabled?

Collectives™ on Stack Overflow

How update the data from my database in my application java with Hibernate?

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related