Feedback

Feedback

Did this article resolve your question/issue?

   

Article

How to use passthrough mode against JDBC databases using OpenAccess SDK 8.1 for Java

Printable View

Information

 
TitleHow to use passthrough mode against JDBC databases using OpenAccess SDK 8.1 for Java
URL NameHow-to-use-passthrough-mode-against-JDBC-databases-using-OpenAccess-SDK-8-1-for-Java
Article Number000179601
EnvironmentProduct: Openaccess SDK
Version: 8.1
OS: All supported platforms
Database: All supported databases
Application: All supported applications
Question/Problem Description
How to use pass through mode against JDBC databases using OpenAccess SDK 8.1 for Java
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
The passthrough Java IP is a sample IP developed to test the “passthrough” mode of the OpenAccess SDK SQL Engine.  In the passthrough mode, the IP is responsible for executing the query against the backend.  The OpenAccess SDK SQL engine handles the parsing and schema validation and then exposes the parsed statement tree to the IP through the parse-tree API.  A typical IP using the passthrough mode translates the passed in query to the language the backend supports.  Joins, where clause processing, and all expressions must be handled by the IP but the post processing (GROUP BY, ORDER BY) can be delegated to the OpenAccess SDK SQL engine.

This sample IP can be configured to operate in two execution modes:
  • Full Execution mode - execute queries using a backend JDBC driver. This mode requires to have JDBC connectivity from the machine where the OpenAccess SDK Server is installed.
  • Format-Only mode - writes the formatted query to the log and no results are returned.
The code in the passthrough IP is modular to allow it's use with custom IP code.  This sample is coded for SELECT commands only and exposes a schema that is defined in the code itself. 

Download the attached sample and follow the instructions in the document passjdbcSetup.doc.
Workaround
Notes
Last Modified Date11/25/2023 8:30 PM
Files 1. passjdbc
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.


Copyright © 2022 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, Ipswitch, Chef, Kemp, Flowmon and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.

Terms of Use Privacy Center Security Center Trademarks License Agreements Code of Conduct Careers Offices
Do Not Sell My Personal Information