2.10. Create a Connection to a VDB Using the Data Source Class

Procedure 2.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();
     }
  }

  Copy to Clipboard Toggle word wrap