Revision [1235]
This is an old revision of CommandXsql made by DavidLee on 2010-02-15 10:25:50.
Command xsql
Name
xsql queries a a relational database using jdbcSynopsis
xsql [ serialization options ] [options]Options
| -cp,-classpath path | Specifies an additional classpath to use to load the jdbc driver |
| -d,-driver class | Specifies the jdbc driver classname |
| -u,-user user | Username |
| -p,-password password | Password |
| -root root | Root element for generated xml |
| -row row | Row element name for generated xml |
| -attr | Use attribute normal form instead of element normal form for column data |
| -c,-connect string | Connect string for jdbc connections |
| -q query | SQL query to run |
| -o,-option name=value | Specifiy additional connection options, may be repeated (-o opt1=value1 -o opt2=value2) |
Supports the standard [ serialization options ]
Description
xsql connects to a database using the java jdbc interface, executes an sql statement and returns the result as an xml document. The xml document is formatted similarly to csv2xml.Example using the mysql JDBC connector
xsql -cp mysql-connector-java-5.1.7-bin.jar -c jdbc:mysql://host.com/xmlsh -u xmlsh -p password -d org.gjt.mm.mysql.Driver -q 'select * from books'
Example using the csvjdbc driver from http://csvjdbc.sourceforge.net/
xsql -cp csvjdbc.jar -d org.relique.jdbc.csv.CsvDriver -c "jdbc:relique:csv:$PWD" "select * from books"
Added suppressHeaders option
xsql -cp csvjdbc.jar -d org.relique.jdbc.csv.CsvDriver -o suppressHeaders=true -c "jdbc:relique:csv:$PWD" "select * from books"
Oracle Example using ojdbc14.jar with failover
xsql -cp ojdbc14.jar -driver oracle.jdbc.OracleDriver \ -connect "jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=myhost.com)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=myhost2.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=MYSERVICE)))" \ -user myuser -password mypass \ -q "SELECT * from TABLE" > drugs.xml
Return Value
Returns 0 if the command executed successfully, 1 if there was an error.Commands
CategoryCommands
