Java software with Client Server RDBMS

Please, i am trying to design a software with java that will have a database running on a network connected to a single offline server system (the server is not necessarily connected to the

the Network with the server system is already existing, but i need ideas on how best to achieve a solution.

i am quite familiar with embedded databases using SQLite. however from my little research SQLite is not good for or does not support client-server databases. and for sure there might be concurrent update operations which i think will lock up an SQLite database.

Now my questions are:

• Please what are the steps involved to achieve my goal


• which RDBMS system is best to use in this scenario. i have read about PostgreSQL, Microsoft SQL, Microsoft Access and MySQL (i would love something a bit similar to SQLite).


• must the software be web based or can i make it a desktop app? (i am quite comfortable with the latter).


• the previous software had it's database files located on a shared folder in the server system. the files had extension *.mdb which suggested a Microsoft Access database. but i dont really know how effective that really is.


• I have also heard of the possibility of writing softwares without worrying about the database end. dont really know how that works...

i have seen this Getting started with client-server networking and this JAVA Client-Server software, Multiple machines but they didn't mention anything about RDBMS. i also checked SQLite over a network out because its a bit related to what i want to achieve...but nothing much there. i also saw Use of sqlite on network share which was quite enlightening too...but i need more info.

thanks a lot in advance guys. much help is really appreciated.