Command Line tool for DB Transactions

divinelight0705's Avatar, Join Date: Aug 2012
Newbie Member
Hi

I want to build a command line utility tool in Java for DB Transactions on Linux. My requirement is when we run the java program it should show command prompt. From there User can enter any sql statement and get the restuls. Java Program should log all these transactions. Please let me know by using Java can we connect to DB and provide DB prompt for DB transactions? Replies are highly appreciated.

Thanks in Advance
ManzZup's Avatar, Join Date: May 2009
Skilled contributor
yes, there are 2 ways
proper way been to use the necessary API of the db or the classes that come with java to run and access the DB [like mysql and oracle]

other way it to directly run the necessary console (for ex if mysql is installed in the server you can run the commanline of mysql and run any command through it)
this way is easier because you can directly output the output given by the commandline itself