Simpleclient Quickstart

Level: Beginners Technologies: Teiid, JDBC Target Product: DV Product Versions: DV 6.1 Source: https://github.com/teiid/teiid-quickstarts

What is it?

Simpleclient quickstart demonstrates how to make a connection to Teiid using both a Driver and a DataSource.

The JDBCClient.java is the example code that shows a developer the basic connection logic that can be used to connect to a Teiid instance running in a JBoss AS server.

The program expects four arguments . The pom.xml defines these arguments in the pom.xml:

.... JDBCClient localhost 31000 ${vdb} ${sql} ....

Notice that the and are preset. To point to a different server and/or port, change "localhost" and/or "31000" arguments, respectively, in the pom.xml.

---

System requirements

If you have not done so, please review the System Requirements (../README.md)

#############

Build

############# First, build the project by running

mvn clean install

#############

Execution

############# To execute a sql query using the simpleclient, use the following format:

	   mvn install -Dvdb="<vdb>" -Dsql="<sql>"

Example: mvn install -Dvdb="twitter" -Dsql="select * from tweet where query= 'jboss'" -Dusername="teiidUser" -Dpassword="pwd"

Note that the query is in quotes so that it is understood as a single argument.

NOTE: To run more advanced queries, it would be better a fully featured Java client, such as SQuirreL [http://www.squirrelsql.org/].