MySqlDataSourceClient.java

package com.jboss.teiid.client;

import java.sql.Connection;

import com.jboss.teiid.client.util.JDBCUtil;

public class MySqlDataSourceClient {
	
	private static final String JDBC_DRIVER = "org.teiid.jdbc.TeiidDriver";
	private static final String JDBC_URL = "jdbc:teiid:BrokerInfo_VDB@mm://localhost:31000;version=1";
	private static final String JDBC_USER = "user";
	private static final String JDBC_PASS = "user";
	
	static final String SQL_QUERY_BROKER = "SELECT * FROM BrokerInfo_VBL.Broker";
	static final String SQL_QUERY_CUSTOMER = "SELECT * FROM BrokerInfo_VBL.Customer";

	public static void main(String[] args) throws Exception {

		Connection conn = JDBCUtil.getDriverConnection(JDBC_DRIVER, JDBC_URL, JDBC_USER, JDBC_PASS);
		
		try {
			JDBCUtil.executeQuery(conn, SQL_QUERY_BROKER);
			JDBCUtil.executeQuery(conn, SQL_QUERY_CUSTOMER);
		} catch (Exception e) {
			throw e;
		} finally {
			JDBCUtil.close(conn);
		}
	}

}