1.7. Create a Connection to a VDB Using the Driver 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.1. Create a Connection to a VDB Using the Driver Class

  • Create a Connection to the VDB

    Within your client application code, create a Connection to the VDB using the DriverManager.getConnection() method: 
    public class TeiidClient 
{
   public Connection getConnection(String user, String password) throws Exception 
   {
      String url = "jdbc:teiid:myVDB@mm://localhost:31000;ApplicationName=myApp";
      return DriverManager.getConnection(url, user, password);
    }
}

See Also: