Our company is using native foxpro application on MS-DOS since last 10-12 years.
We would like to deploy new java application on fedora core 5(Linux) using same foxpro data tables those are used by existing native foxpro application over MS-DOS.
We are now testing our new java application (Linux Platform) with existing Native Foxpro application over MS-DOS simultaneously, (1 linux user java, 6 MS-DOS users(foxpro)).
We have purchased license copy of HXTT DBF Driver type 4 JDBC(1.2, 2.0, 3.0) package.
While using our newly java based application with our existing native Foxpro application simultaneouly, we are facing the problem of RECORD LOCK Type. In multiuser environment (Java & Native Foxpro Application),when java application is going to insert a new record in foxpro table that simultaneously used by another user/s with our native foxpro application over MS-DOS , our java application straight-away 'overwrites' the same record which is locked by existing native foxpro application(another user).It could not detect lock/unlock status of record.
Our native foxpro uses 'RLOCK' command to lock record in table.
We also tested our java application with setting property locktype to FOXPRO & SoftC... but not successfull.
Which locktype should we use so that our multiuser system should work successfully.
We are very appreaciate if you give use suggesion for the same .
Thanx with regards,