Revision [714]

This is an old revision of CommandXsql made by DavidLee on 2009-09-05 17:30:37.

 

Command xsql


Name

xsql queries a a relational database using jdbc


Synopsis

xsql [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



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/db -u dave -p pass1 -d org.gjt.mm.mysql.Driver  -q 'select * from address'



Return Value

Returns 0 if the command executed successfully, 1 if there was an error.

CategoryCommands
CommandsInternal
There are no comments on this page.
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki