{{:: 'dataservice-documentation.LoadingCodeSamples' | translate}}
{{vm.connectionDetailTitle}}
   JDBC: {{vm.jdbcConnectionString}}
   OData: {{vm.odataUrl}}

public void execute() throws SQLException {
    String url = "{{vm.jdbcConnectionString}}";
    String sql = "select 1"; //CHANGE ME
 
    Class.forName("org.teiid.jdbc.TeiidDriver");
 
    Connection connection;
    try{
        connection = DriverManager.getConnection(url, "{user}", "{user}"); //Update credentials accordingly
        Statement statement = connection.createStatement();
        ResultSet results = statement.executeQuery(sql);
        while(results.next()) {
          System.out.println(results.getString(1));
        }
        results.close();
        statement.close();
    } catch (SQLException e){
        e.printStackTrace();
        throw e;
    } finally {
        try{
          connection.close();
        }catch(SQLException e1){
          // ignore
        }
    }
}

$.ajax({
             type: 'GET',
             dataType: 'json',
             headers: {
                          Accept: 'application: 'application/json',
                          Authorization: 'Basic xxxxxxxxxxx',
                          url: '{{vm.odataUrl}}',
             success: function(data)
                          for (var x = 0; x < data.length; x++) {
                                      console.log(data[i]);
                          }
             },
             error: function(data) {
                         console.log('Error code: ' + data.errorCode);
                         console.log('Error message: ' + data.errorMessage);
             }
});

o('{{vm.odataUrl}}').get(function(data) {
  console.log(data); //returns an array of data
});

import requests
from requests.auth import HTTPBasicAuth

headers = {'accept': 'application/json;odata=verbose'}
r = requests.get({{vm.odataUrl}}, auth=HTTPBasicAuth('someUser', 'somePassword'), headers=headers)

print r.json()

$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_TIMEOUT, 100);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Authorization: Basic xxxxxxxxxx'));
$api_request_parameters = array('filter'=>"some_field eq 'some value'");
$api_request_url = "{{vm.odataUrl}}";
$api_request_url .= "?".http_build_query($api_request_parameters);
$curl_setopt($ch, CURLOPT_URL, $api_request_url);
$response = curl_exec($ch);
curl_close($ch);