Hello:

I am doing research on combining Swing and Hibernate in a Java desktop app.
My requirement is very simple, we have a database with about 30 tables and I need
to create CRUD (Create, Read, Update and Delete) forms ASAP.

I have experience doing SWING to JDBC using hand coded SQL statements and
I have some experience using Hibernate in a 3 tier Web app.

What is your opinion? Can Hibernate be used behind a Swing app to eliminate the
joy of writing the SQL by hand?

Thank you for your attention to this matter

Best Regards

kd

Definitely.



Farzad-

are there any samples? anywhere.

kd

I don't know any samples but you can think of a simple DAO layer over a hibernate session or a mix with Spring.



Farzad-

Of course it works with swing.

The problem you might encounter is that of handling sessions.

In a web application a unit of work (i.e. a session) is most of the time simply identified by a single request. There are well known, easy to implement solutions to that problem.

In a rich client application this is different.

You might open a list of objects, which need a Session for lazy loading.

You might start Editor like Windows from that list for manipulations of these objects. But now you start getting issues with the session handling.

My recommendation is to essentially use a Session per Dialog. And reload any Object in the Session of the target Dialog, when it gets passed from one Dialog to another.

I described the sessionhandling in rich client applications in a german blog article. It includes a list of relevant links at the end, which describe the problem of session handling in rich client applications.

Jens

This is very very helpful.

Please note my requirement is very simple, CRUD forms for about thirty tables. There will be at max six users.

The only thing I could see the users doing across sessions would be two users deleting the same record or two users attempting to add the same record.

What would hibernate do in this case?

Many thanks

kd

Check the documentation for optimistic locking.

christian wrote a demo apps for swing. I think it's a point to start.
http://in.relation.to/Bloggers/HibernateAndSwingDemoApp

I wrote a englisch version of my blog post session handling in two tier rich client applications mentioned above.