UnityJDBC 驅動程式可以在單個 SQL 查詢中整合和查詢任意數量的 JDBC 可存取資料來源（包括 Oracle、SQL Server、MySQL 和 Postgres）。UnityJDBC 包含一個內置的資料庫引擎和優化器，可與集成系統分開使用。UnityJDBC 會自動翻譯 SQL 函數和方言，並在從一個資料庫系統轉換為另一個資料庫系統時使用。 特徵： 集成所有內容：UnityJDBC 允許您編寫單個 SQL 查詢，以從任意數量的 JDBC 可存取資料來源中提取資料。查詢可以聯接或匹配源之間的資料，並返回單個 ResultSet。 最高性能：UnityJDBC 的開銷最小，並且包含一種獨特的聯接演算法，它返回的結果速度比以前的演算法快。內置優化器重組查詢以創建最有效的執行計劃。 它可以處理大於主記憶體的查詢。 基於標準：UnityJDBC 是純 JAva，可用於任何支援 Java 的平臺（Windows、Linux、UNIX）。系統支持標準 SQL 查詢，與其他 JDBC 驅動程式完全一樣工作。這允許快速開發訪問多個資料庫的應用程式，而無需新的中間件軟體或培訓程式員在不同的開發環境中。 它可以部署在應用程式和 Web 伺服器以及獨立的 Java 應用程式中。 資料庫註釋：系統允許開發人員重新命名正在查詢的資料庫中的欄位和表。這樣可以更輕鬆地跟蹤和查詢資料庫。 匹配和合併數據：MERGE 運算符允許超出標準聯接的查詢並追蹤數據來源。 函數轉換：UnityJDBC 支援所有標準 SQL 函數、使用者定義的函數，並翻譯特定於每個資料庫系統方言和支援級別的函數，包括日期/時間函數、字串操作和 LIMIT/OFFSET 分頁。
版本歷史記錄
- 版本 4.0 發佈於 2011-08-11
軟體細節
終端使用者許可協定
IMPORTANT--READ THESE TERMS CAREFULLY BEFORE DOWNLOADING THIS SOFTWARE. BY DOWNLOADING OR USING THIS SOFTWARE, YOU ACKNOWLEDGE THAT YOU HAVE READ THIS LICENSE AGREEMENT, THAT YOU UNDERSTAND IT, AND THAT YOU AGREE TO BE BOUND BY ITS TERMS. IF YOU DO NOT AGREE TO THE TERMS AND CONDITIONS OF THIS LICENSE AGREEMENT, PROMPTLY EXIT THIS PAGE WITHOUT DOWNLOADING THE SOFTWARE. Grant of License for Registered Users UnityJDBC, grants you a non-exclusive, non-transferable license to use program with which this license is distributed ("UnityJDBC driver"), including any documentation files accompanying Software ("User Guide") on a single computer. If this computer is a server (if Software is server based) then a server license must be purchased. Each client license allows software to be installed and used on a personal computer (not a server) provided that: (i) Software is NOT modified; (ii) all copyright notices are maintained on Software; and (iii) you agree to be bound by terms of this License Agreement. Software and Documentation shall be used only by you, only for your own personal or internal business use and not in operation of a service bureau or for benefit of any other person or entity. Ownership You have no ownership rights in Software. Rather, you have a license to use Software as long as this License Agreement remains in full force and effect. Ownership of Software, Documentation and all intellectual property rights therein shall remain at all times with UnityJDBC. Any other use of Software by any person, business, corporation, government organization or any other entity is strictly forbidden and is a violation of this License Agreement. Copyright Software and Documentation contain material that is protected by United States Copyright Law and trade secret law, and by international treaty provisions. All rights not granted to you herein are expressly reserved by UnityJDBC. You may not remove any proprietary notice of UnityJDBC from any copy of Software or Documentation. Restrictions You may not publish, display, disclose, rent, lease, modify, loan, distribute, or create derivative works based on Software or any part thereof. You may not reverse engineer, decompile, translate, adapt, or disassemble Software, nor shall you attempt to create source code from object code for Software. You may not transmit Software over any network or between any devices, although you may use Software to make such transmissions of other materials. A registered version of the software cannot be copied between machines or distributed as part of another application or system. A single client license is only valid for the machine where the software is registered. Confidentiality You acknowledge that Software contains proprietary trade secrets of UnityJDBC and you hereby agree to maintain confidentiality of Software using at least as great a degree of care as you use to maintain confidentiality of your own most confidential information. You agree to reasonably communicate terms and conditions of this Software License Agreement to those persons employed by you who come into contact with Software, and to use reasonable best efforts to ensure their compliance with such terms and conditions, including, without limitation, not knowingly permitting such persons to use any portion of Program for purpose of deriving source code of the program or defeating the registration and key system. Limitation of Liability UnityJDBC driver is supplied as is. The author disclaims all warranties, expressed or implied, including, without limitation, warranties of merchantability and of fitness for any purpose. The author assumes no liability for damages, direct or consequential, which may result from use of UnityJDBC driver. In no event will UnityJDBC be liable to you or any third party for any incidental or consequential damages (including, without limitation, indirect, special, punitive, or exemplary damages for loss of business, loss of profits, business interruption, or loss of business information) arising out of use of or inability to use program, or for any claim by any other party, even if UnityJDBC has been advised of possibility of such damages. Export Restrictions This license agreement is expressly made subject to any laws, regulations, orders, or other restrictions on export from Canada of software or information about such software which may be imposed from time to time by government of Canada. You shall not export software, documentation, or information about software and documentation without consent of UnityJDBC and compliance with such laws, regulations, orders, or other restrictions. Termination This License Agreement is effective until it is terminated. You may terminate this License Agreement at any time by destroying or returning to UnityJDBC all copies of Software and Documentation in your possession or under your control. UnityJDBC may terminate this License Agreement for any reason, including, but not limited to, if UnityJDBC finds that you have violated any of terms of this License Agreement. Upon notification of termination, you agree to destroy or return to UnityJDBC all copies of Software and Documentation and to certify in writing that all known copies, including backup copies, have been destroyed. All provisions relating to confidentiality, proprietary rights, and non-disclosure shall survive termination of this Software License Agreement. General This License Agreement shall be construed, interpreted and governed by laws of Canada without regard to conflicts of law provisions thereof. exclusive forum for any disputes arising out of or relating to this License Agreement shall be an appropriate court sitting in British Columbia, Canada. This License Agreement shall constitute entire Agreement between parties hereto. Any waiver or modification of this License Agreement shall only be effective if it is in writing and signed by both parties hereto. If any part of this License Agreement is found invalid or unenforceable by a court of competent jurisdiction, remainder of this License Agreement shall be interpreted so as to reasonably effect intention of parties. Copyright 2011 UnityJDBC