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 a org.teiid.jdbc.TeiidDataSource object, set the required properties, and use the TeiidDataSource.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();
       }
    }