diff options
author | Matthew Newhook <matthew@zeroc.com> | 2015-03-18 12:58:16 -0230 |
---|---|---|
committer | Matthew Newhook <matthew@zeroc.com> | 2015-03-18 12:58:16 -0230 |
commit | 9b7668c7c92cf9cb311fe444cdddb489cd2a219d (patch) | |
tree | 5016567c58c81f5654e9d01935e199c6bf4761d2 /cpp/demo/Database/Oracle/proc/DeptFactoryI.pc | |
parent | VS add-in & build updates: (diff) | |
download | ice-9b7668c7c92cf9cb311fe444cdddb489cd2a219d.tar.bz2 ice-9b7668c7c92cf9cb311fe444cdddb489cd2a219d.tar.xz ice-9b7668c7c92cf9cb311fe444cdddb489cd2a219d.zip |
Removed demos.
Moved demoscript to distribution.
Diffstat (limited to 'cpp/demo/Database/Oracle/proc/DeptFactoryI.pc')
-rw-r--r-- | cpp/demo/Database/Oracle/proc/DeptFactoryI.pc | 155 |
1 files changed, 0 insertions, 155 deletions
diff --git a/cpp/demo/Database/Oracle/proc/DeptFactoryI.pc b/cpp/demo/Database/Oracle/proc/DeptFactoryI.pc deleted file mode 100644 index c54c02550d1..00000000000 --- a/cpp/demo/Database/Oracle/proc/DeptFactoryI.pc +++ /dev/null @@ -1,155 +0,0 @@ -// ********************************************************************** -// -// Copyright (c) 2003-2015 ZeroC, Inc. All rights reserved. -// -// This copy of Ice is licensed to you under the terms described in the -// ICE_LICENSE file included in this distribution. -// -// ********************************************************************** - -#include <DeptFactoryI.h> -#include <Util.h> -#include <sqlca.h> - -EXEC SQL WHENEVER SQLERROR DO handleSqlError(sqlca, ctx); - -using namespace std; - -DeptFactoryI::DeptFactoryI(const CurrentSqlContext& currentCtx, const string& deptCategory, const string& empCategory) : - _currentCtx(currentCtx), - _deptCategory(deptCategory), - _empCategory(empCategory) -{ -} - -HR::DeptPrx -DeptFactoryI::createDept(int key, const HR::DeptDesc& desc, const Ice::Current& current) -{ - sqlca sqlca; - EXEC SQL BEGIN DECLARE SECTION; - sql_context ctx = _currentCtx; - int deptno = key; - const char* dname = desc.dname.c_str(); - const char* loc = desc.loc.c_str(); - EXEC SQL END DECLARE SECTION; - - EXEC SQL CONTEXT USE :ctx; - EXEC SQL INSERT INTO DEPT(deptno, dname, loc) VALUES(:deptno, :dname, :loc); - EXEC SQL COMMIT; - - Ice::Identity deptId; - deptId.name = encodeName(deptno); - deptId.category = _deptCategory; - return HR::DeptPrx::uncheckedCast(current.adapter->createProxy(deptId)); -} - -EXEC SQL WHENEVER NOT FOUND DO break; - -HR::DeptPrxSeq -DeptFactoryI::findAll(const Ice::Current& current) -{ - sqlca sqlca; - EXEC SQL BEGIN DECLARE SECTION; - sql_context ctx = _currentCtx; - int deptno; - EXEC SQL END DECLARE SECTION; - - EXEC SQL CONTEXT USE :ctx; - EXEC SQL DECLARE depCursor1 CURSOR FOR SELECT DEPTNO FROM DEPT; - EXEC SQL OPEN depCursor1; - - HR::DeptPrxSeq result; - - for(;;) - { - EXEC SQL FETCH depCursor1 INTO :deptno; - - Ice::Identity deptId; - deptId.category = _deptCategory; - deptId.name = encodeName(deptno); - - result.push_back(HR::DeptPrx::uncheckedCast(current.adapter->createProxy(deptId))); - } - - EXEC SQL CLOSE depCursor1; - EXEC SQL COMMIT; - return result; -} - -HR::DeptPrxSeq -DeptFactoryI::findByName(const string& name, const Ice::Current& current) -{ - sqlca sqlca; - EXEC SQL BEGIN DECLARE SECTION; - const char* dname = name.c_str(); - sql_context ctx = _currentCtx; - int deptno; - EXEC SQL END DECLARE SECTION; - - EXEC SQL CONTEXT USE :ctx; - EXEC SQL DECLARE depCursor2 CURSOR FOR SELECT DEPTNO FROM DEPT WHERE DNAME = :dname; - EXEC SQL OPEN depCursor2; - - HR::DeptPrxSeq result; - - for(;;) - { - EXEC SQL FETCH depCursor2 INTO :deptno; - - Ice::Identity deptId; - deptId.category = _deptCategory; - deptId.name = encodeName(deptno); - - result.push_back(HR::DeptPrx::uncheckedCast(current.adapter->createProxy(deptId))); - } - - EXEC SQL CLOSE depCursor2; - EXEC SQL COMMIT; - return result; -} - -HR::DeptPrx -DeptFactoryI::findDeptByNo(int deptno, const Ice::Current& current) -{ - Ice::Identity deptId; - deptId.category = _deptCategory; - deptId.name = encodeName(deptno); - Ice::ObjectPrx prx = current.adapter->createProxy(deptId); - - // - // Check that this deptno exists - // - try - { - prx->ice_ping(); - } - catch(const Ice::ObjectNotExistException&) - { - return 0; - } - - return HR::DeptPrx::uncheckedCast(prx); -} - -HR::EmpPrx -DeptFactoryI::findEmpByNo(int empno, const Ice::Current& current) -{ - Ice::Identity empId; - empId.category = _empCategory; - empId.name = encodeName(empno); - Ice::ObjectPrx prx = current.adapter->createProxy(empId); - - // - // Check that this empno exists - // - try - { - prx->ice_ping(); - } - catch(const Ice::ObjectNotExistException&) - { - return 0; - } - - return HR::EmpPrx::uncheckedCast(prx); -} |