Go4Expert (http://www.go4expert.com/)
-   Java (http://www.go4expert.com/forums/java/)
-   -   Command Line tool for DB Transactions (http://www.go4expert.com/forums/command-line-tool-db-transactions-t28958/)

divinelight0705 29Aug2012 13:12

Command Line tool for DB Transactions

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:crazy:

ManzZup 15Sep2012 16:54

Re: Command Line tool for DB Transactions
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

All times are GMT +5.5. The time now is 07:39.