1.11. Create a Connection to a VDB Using the Data Source Class
1.11. Create a Connection to a VDB Using the Data Source Class Prerequisites The client application must have the JBoss Data Virtualization EAP_HOME /dataVirtualization/jdbc/teiid- VERSION -redhat- N -jdbc.jar JAR file in its classpath. (If the application is running on the same application server as the JBoss Data Virtualization instance to which the connection is desired, then this will already be the case.) JBoss Data Virtualization must be installed and running, with the relevant virtual databases (VDBs) deployed. Procedure 1.2. Create a Connection to a VDB Using the Data Source Class Create a Connection Object Create a org.teiid.jdbc.TeiidDataSource object, set the required properties, and use the TeiidDataSource.getConnection() method to obtain a Connection object. For example: See Also: Section 1.9, "Connection Properties for the Driver and Data Source Classes" Section 1.12, "Additional Data Source Connection Properties"
public class TeiidClient { public Connection getConnection(String user, String password) throws Exception { TeiidDataSource ds = new TeiidDataSource(); ds.setUser(user); ds.setPassword(password); ds.setServerName("localhost"); ds.setPortNumber(31000); ds.setDatabaseName("myVDB"); return ds.getConnection(); } }