Crodys using Oracle synonym Solutions

Take a list of process business information to illustrate the use of Oracle synonym solutions.
The following objects are available in the Oracle database Bpm_sun User:

Object Name	type	Description
Sun_biz_base	Table
Sub_focusprocess	Table
Sub_biz_info	Synonym	Create synonym sun_biz_info for bpm_manager.biz_info;

The query list SQL statement looks like this:

select a.title,to_char(a.live_date,‘yyyy-mm-dd‘),b.endflow from sun_biz_info a,sun_biz_base b where a.info_id = b.info_id and a.rvsn_number=b.rvsn_number;

The query results are as follows:

Synonyms Using Solutions

In the data source (database Matedata), Oracle Databases objects are only: Tables, views, procedures three, no synonym synonyms option.

How can I use synonyms (synonyms)?
When creating WebService, select the tables in one or more of the databases that are visible, and select the Sun_biz_base and sun_focusprocess two tables as shown in the example.
Create a new custom WebService with the name: Querybizlist

With the Ws-appserver package tool, the following Java code is generated, and then the code for the synonym SQL statement is written by synchronizing the code to SVN, based on the Eclipse development tool.

/ * This class had been generated by the Code generator*/ PackageCom.unicom.sun.sunpackage;ImportCom.cordys.cpc.bsf.busobject.BusObjectConfig;ImportCom.cordys.cpc.bsf.busobject.QueryObject; Public  class sun_biz_base extends sun_biz_basebase{     Public Sun_biz_base()    { This((Busobjectconfig)NULL); } Public Sun_biz_base(busobjectconfig config) {Super(config); } Public StaticStringquerybizlist() {String sql="Select A.title,to_char (a.live_date, ' yyyy-mm-dd '), B.endflow"; SQL + ="from Sun_biz_info a,sun_biz_base B"; SQL + ="Where a.info_id = b.info_id and A.rvsn_number=b.rvsn_number"; Queryobject query =NewQueryobject (SQL);//TODO Implement body        returnQuery.getobject (). toString (); }}

Note: the "table" Sun_biz_info is synonymous with the above SQL statement.

By using SVN to bring the Java code back to the Cordys platform, compile the code and publish and publish the WebService, the test tool is operation with the WebService test tools and the results are as follows:

Conclusion

This verification enables the use of the Oracle synonym Technology Scheme on the Cordys platform, with the following conclusions:

• 1. Private synonyms do not differ from public synonyms;
• Services for synonyms are not provided in 2.Database Metadata, and synonyms are not recognized as tables. That is, you cannot create a method directly for a synonym through database Metadata;
• 3. Using synonyms is the first way to create a method from another table (Tables), and then modify the method's SQL statement to operate on the synonym instead.

Due to the limited author level, feedback discussion is welcome.

Related documents: Oracle Synonyms Concise usage Sho Yongwei 2015.5

Crodys using Oracle synonym Solutions