download
A Query
Java Execution code
An Insert/Update
Connector
Connectors can be made to use standard JDBC Drivers, or DataSources retrieved from JNDI.
org.shiftone.exq.test.test_connector.xml
<connector>
<driver>
<class>oracle.jdbc.driver.OracleDriver</class>
<url>jdbc:oracle:thin:@hostname:sid</url>
<properties>
<property>
<name>user</name>
<value>scott</value>
</property>
<property>
<name>password</name>
<value>tiger</value>
</property>
</properties>
</driver>
</connector>
|
<connector>
<datasource>
<name>jdbc.acmeDS</name>
<context>
<property>
<name>PROVIDER_URL</name>
<value>provider</value>
</property>
<property>
<name>INITIAL_CONTEXT_FACTORY</name>
<value>context factory</value>
</property>
</context>
</datasource>
</connector>
|
A Query
org.shiftone.exq.test.test1_query.xml
<query>
<connectorName>org.shiftone.exq.test.test_connector</connectorName>
<cache>
<timeout>60000</timeout>
<maxSize>50</maxSize>
</cache>
<sql>
select * from user_objects
<ifdef param="object_type">
where object_type = <param name="object_type" type="string"/>
</ifdef>
</sql>
</query>
|
Java Execution code
QueryBuilder queryBuilder = QueryBuilder.newInstance();
Query test1Query =
queryBuilder.getQuery("org.shiftone.exq.test.test1_query");
test1Query.setParameter("object_type", "VARCHAR");
Cursor test1Cursor = test1Query.execute();
|
An Insert/Update
ConnectionBuilder connectionBuilder = ConnectionBuilder.newInstance();
Connection connection =
connectionBuilder.getConnection("org.shiftone.exq.test.test_connector");
CallableStatement cStmt = connection.prepareCall("insertionFunction(?)");
...
|
