Record Locking in JAVA

[ttkong]

Hi all,

I am new in JAVA programming. However, I am now doing a research on developing back office application using JAVA technology. The languages involved are HTML, Java script, JSP, servlet, and JAVA. Browser is served as client, a web server to accommodate JSPs and java classes, and a database server to hosts INFORMIX database.

For those that work with back office system may experience that in many cases where more than one users accessing database records concurrently. Functions like receipting and payment require records to be locked when selected and release after it is being updated.

The main reason of record locking is to prevent other user from updating the records that are retrieved and displayed while keying in the entry base on it.

As I know, the JSP (calling program) is disconnected from database once the desired records are retrieved. Hence, record locking is impossible.

Is anyone has any idea? Can EJBs and application server resolve the mentioned problem? Anyone has experience in developing back office using JAVA languages?

Thank you so much.

Rgrds,
TTKong

 

[carpeliam]

Are you using JDBC (Java Database Connectivity) to access the database, or some other API? Liam Morley
lmorley@gdc.wpi.edu
"light the deep, and bring silence to the world.
light the world, and bring depth to the silence."

 

[daniel135]

you shouldn't have to keep track of that in the Java part... that's the job of the database.

 

[ttkong]

Hi Imotic,

I am currently using INFORMIX JDBC driver for database connection. I ever tried INFORMIX-CLI (ODBC driver) too. However, how does it relates to record locking?

Rgrds,
TTKong

 

[ttkong]

Dear Daniel,

I understand that record locking should be handled by database itself. However, there are circumstances where records need to be retrieved, locked and pending for user interaction. Do you have any suggestion?

Rgrds,
TTKong