diff options
| -rw-r--r-- | cpp/demo/Database/Oracle/occi/README | 62 | ||||
| -rw-r--r-- | cpp/demo/Database/Oracle/proc/README | 33 |
2 files changed, 49 insertions, 46 deletions
diff --git a/cpp/demo/Database/Oracle/occi/README b/cpp/demo/Database/Oracle/occi/README index 839007613b1..7fb4ab8fc84 100644 --- a/cpp/demo/Database/Oracle/occi/README +++ b/cpp/demo/Database/Oracle/occi/README @@ -6,7 +6,7 @@ through its Oracle C++ Call Interface (OCCI) API. It is a fairly simple demo that illustrates how to: - - Map relational data to Ice objects, in particular convert between + - Map relational data to Ice objects, in particular convert between Ice and OCCI types. - Use an OCCI pool to provide Oracle connections to Ice requests. - Use an Ice servant locator. @@ -15,71 +15,73 @@ It is a fairly simple demo that illustrates how to: Building the demo ----------------- -OCCI is only available for some C++ compilers. Make sure to select a +OCCI is only available for some C++ compilers. Make sure to select a platform and C++ compiler supported by both Ice and OCCI. -OCCI oracle drivers are available at: +OCCI Oracle drivers are available at: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html -- Setup an Oracle database with the traditional EMP/DEPT schema. - With Oracle server 12c, the corresponding SQL script is +- Setup an Oracle database with the traditional EMP/DEPT schema. + With Oracle Server 12c, the corresponding SQL script is $ORACLE_HOME/rdbms/admin/utlsampl.sql. - Ensure that your user (by default, scott) has the CREATE VIEW privilege. -- Create object types and views using the provided createTypes.sql +- Create object types and views using the provided createTypes.sql script. For example: % sqlplus /nolog SQL> @createTypes.sql - This script assumes that you can connect to your database with + This script assumes that you can connect to your database with 'scott/tiger@orcl'. If you need another connect-string, edit createTypes.sql. -- Oracle's ott utility needs to connect to the database in order to +- Oracle's ott utility needs to connect to the database in order to generate code from the file 'DbTypes.typ'. The default connect- string is "scott/tiger@orcl". If this is not appropriate, edit the corresponding Makefile target, or the Custom build rule for - Visual Studio projects. + Visual Studio projects. - Set the environment variable ORACLE_HOME to point to your Oracle installation home directory. -- On Windows with Visual Studio Project Files: +- On Windows with Visual Studio Project Files: - Oracle settings are configured using a property sheet named oracle - that is attached to the server project configurations, open the - Visual Studio Property Manager from "View > Property Manager" menu. + that is attached to the server project configurations. Open the + Visual Studio Property Manager from "View > Property Manager" menu. - - Expand the server configuration and double click oracle property - sheet to edit it. + - Expand the server configuration and double click the oracle + property sheet to edit it. - - Click "Common Properties > User Macros" and set ORACLE_HOME value to - match your Oracle deployment. + - Click "Common Properties > User Macros" and set the ORACLE_HOME + value to match your Oracle deployment. - Occi libraries and drivers for Visual Studio 2012 x64 are included - with Oracle 12c, if you are using a different compiler or arch you - will need to install the correspoding oracle instant client package - from: + with Oracle 12c. If you are using a different compiler or arch you + will need to install the corresponding Oracle instant client + package from: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html - Follow the link corresponding the platform you want to use and setup both: + Follow the link corresponding to the platform you want to use and + setup both: - - instantclient-basic-nt-12.1.0.2.0.zip - - instantclient-sdk-nt-12.1.0.2.0.zip + - instantclient-basic-nt-12.1.0.2.0.zip + - instantclient-sdk-nt-12.1.0.2.0.zip - After that set ORACLE_INSTANTCLIENT_HOME value in the oracle property sheet - to match you setup. + After that set the ORACLE_INSTANTCLIENT_HOME value in the oracle + property sheet to match your setup. - - Make sure to save the changes to the property sheet using the save button in the Propery - Manager windows so changes take effect. + - Make sure to save the changes to the property sheet using the save + button in the Property Manager windows so changes take effect. -- On Windows, when using nmake Makefiles, set ORACLE_HOME and ORACLE_INSTANTCLIENT_HOME - variables in your enviroment to match you Oracle setup and review Makefile.mak. +- On Windows, when using nmake Makefiles, set the ORACLE_HOME and + ORACLE_INSTANTCLIENT_HOME variables in your enviroment to match your + Oracle setup and review Makefile.mak. - Then build as usual. @@ -87,8 +89,8 @@ OCCI oracle drivers are available at: Running the demo ---------------- -- Review the Oracle properties in the config.server file. - You may need to change them to connect to your Oracle instance. +- Review the Oracle properties in the config.server file. You may need + to change them to connect to your Oracle instance. - Start the server: diff --git a/cpp/demo/Database/Oracle/proc/README b/cpp/demo/Database/Oracle/proc/README index e7a957d20a3..7ccc439ca0f 100644 --- a/cpp/demo/Database/Oracle/proc/README +++ b/cpp/demo/Database/Oracle/proc/README @@ -6,8 +6,8 @@ through its Embedded SQL (Pro*C/C++) API. It is a fairly simple demo that illustrates how to: - - Map relational data to Ice objects, in particular convert - between Ice and Oracle Pro*C/C++ types. + - Map relational data to Ice objects, in particular convert between + Ice and Oracle Pro*C/C++ types. - Associate an Oracle Pro*C/C++ context and database connection to each thread in the Ice server thread pool. - Use Ice default servants. @@ -19,28 +19,29 @@ Building the demo On Linux or Unix, set ORACLE_HOME to point to your Oracle installation home directory. Then build as usual. -On Windows with Visual Studio Project Files: +On Windows with Visual Studio Project Files: - Oracle settings are configured using a property sheet named oracle - that is attached to the server project configurations, open the - Visual Studio Property Manager from "View > Property Manager" menu. + that is attached to the server project configurations. Open the + Visual Studio Property Manager from "View > Property Manager" menu. - - Expand the server configuration and double click oracle property - sheet to edit it. + - Expand the server configuration and double click the oracle + property sheet to edit it. - - Click "Common Properties > User Macros" and set ORACLE_HOME value to - match your Oracle deployment. + - Click "Common Properties > User Macros" and set the ORACLE_HOME + value to match your Oracle deployment. - - Oracle 12c just include 64 bit libraries and binaries to buid with Win32 - configurations you need to install the winnt_12c_client32.zip package - available at Oracle 12c download page: + - Oracle 12c only includes 64-bit libraries and binaries. To build + Win32 configurations you need to install the winnt_12c_client32.zip + package available at the Oracle 12c download page: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-1968077.html and set the ORACLE_CLIENT_HOME value to match your deployment. -On Windows, when using nmake Makefiles, set ORACLE_HOME and ORACLE_CLIENT_HOME -variables in your enviroment to match you Oracle setup and review Makefile.mak. +On Windows, when using nmake Makefiles, set the ORACLE_HOME and +ORACLE_CLIENT_HOME variables in your enviroment to match your Oracle +setup and review Makefile.mak. Then build as usual. @@ -48,8 +49,8 @@ Then build as usual. Running the demo ---------------- -- Setup an Oracle database with the traditional EMP/DEPT schema. - With Oracle server 12c, the corresponding SQL script is +- Setup an Oracle database with the traditional EMP/DEPT schema. + With Oracle Server 12c, the corresponding SQL script is $ORACLE_HOME/rdbms/admin/utlsampl.sql. - Review the Oracle.ConnectInfo property in the config.server file. |