« Relational Data Sources

MySQL

Query any MySQL database with XQuery through the Stylus XQuery XQJ API. Only the JDBC URL changes across vendors — the XQJ code below is identical for every supported database.

JDBC URL

jdbc:xquery:mysql://host:3306;databaseName=your_database

XQJ example

import javax.xml.xquery.*;
import java.util.Properties;
import com.ddtek.xquery.xqj.DDXQDataSource;

public class MySqlExample {
  public static void main(String[] args) throws XQException {
    DDXQDataSource ds = new DDXQDataSource();
    ds.setProperty(DDXQDataSource.JDBCURL,
        "jdbc:xquery:mysql://server1:3306;databaseName=pubs;User=root;Password=secret");
    XQConnection cn = ds.getConnection();
    XQPreparedExpression q = cn.prepareExpression(
        "for $c in fn:collection('customers')/* return <name>{$c/CompanyName/text()}</name>");
    System.out.println(q.executeQuery().getSequenceAsString(new Properties()));
    cn.close();
  }
}

What we test on MySQL