-
Language:
English
-
Language:
English
Red Hat Training
A Red Hat training course is available for Red Hat JBoss Data Virtualization
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 aorg.teiid.jdbc.TeiidDataSource
object, set the required properties, and use theTeiidDataSource.getConnection()
method to obtain a Connection object. For example: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(); } }