File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Linux / UNIX and the fly likes database access in shell script Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Engineering » Linux / UNIX
Bookmark "database access in shell script" Watch "database access in shell script" New topic

database access in shell script

Minal Silimkar-Urankar
Ranch Hand

Joined: Nov 25, 2007
Posts: 136
Can I access data base in shell script?

Minal Silimkar
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 17276

You certainly can. Almost all DBMS's have some sort of command-line utility and many of them are even powerfule enough to generate reports, HTML pages and even XML.

For the PostgreSQL DBMS, the basic command-line tool is "psql". For MySQL, it's "mysql". For Oracle, it's "sqlplus". I forget what DB2 uses.

For SQL Server, the command line tool is iSql, but of course, you have to be running a Windows client in order to use it. Microsoft lives in their own little world.

An IDE is no substitute for an Intelligent Developer.
It is sorta covered in the JavaRanch Style Guide.
subject: database access in shell script
jQuery in Action, 3rd edition