The usage of sqlclient
is
stilts <stilts-flags> sqlclient db=<jdbc-url> user=<value> password=<value> sql=<sql> ofmt=<out-format>If you don't have the
stilts
script installed,
write "java -jar stilts.jar
" instead of
"stilts
" - see Section 3.
The available <stilts-flags>
are listed
in Section 2.1.
For programmatic invocation,
the Task class for this
command is uk.ac.starlink.ttools.task.SqlClient
.
Parameter values are assigned on the command line as explained in Section 2.3. They are as follows:
db = <jdbc-url>
(Connection)
jdbc:<subprotocol>:<subname>
- the details are database- and driver-dependent.
Consult Sun's JDBC documentation and that for the particular
JDBC driver you are using for details.
Note that the relevant driver class will need to be on your
classpath and referenced in the jdbc.drivers
system property as well for the connection to be made.
ofmt = <out-format>
(String)
(auto)
"
(the default),
then the output filename will be
examined to try to guess what sort of file is required
usually by looking at the extension.
If it's not obvious from the filename what output format is
intended, an error will result.
[Default: text
]
password = <value>
(String)
sql = <sql>
(String)
;
") characters.
user = <value>
(String)
[Default: mbt
]