Oracle Lite Windows CE 4.0.1 2000 10 : J02401-01
Oracle Lite Windows CE, 4.0.1 : J02401-01 Oracle Lite Windows CE Developper s Guide,Release4.0.1 A86147-01 Copyright 2000, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Corporation Restricted Rights Notice Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial computer software" and use, duplication, and disclosure of the Programs, including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR 52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.
... iii 1... 1-2... 1-3... 1-3 ODBC... 1-4... 1-4... 1-5... 1-6... 1-6... 1-8... 1-9 SAMPLE.EXE... 1-10 REPSVR.EXE... 1-10... 1-10 2... 2-2... 2-9... 2-9 i
ii
Oracle Lite Windows CE Oracle8i Lite Oracle Lite Windows CE Oracle Lite 1 2 Oracle Lite for Windows CE Oracle Lite for Windows CE Oracle Lite for Windows CE iii
iv
1 Oracle Lite for Windows CE 1-1
Oracle Lite Windows CE 2.0 Oracle Lite SQL Windows CE Oracle Lite Windows CE Oracle Lite ODBC Oracle Oracle Server Oracle Lite for Windows CE Oracle Lite Oracle Lite for Windows CE HTTP Oracle Application Server 2 SQL*Net Oracle Net8 : Oracle Lite for Windows CE Oracle Lite.ODB 2 Oracle Lite for Windows CE.ODB 1-2 Oracle Lite Windows CE
Windows CE Oracle Lite for Windows CE Oracle Lite for Windows 95 98 NT Windows CE Windows NT Windows CE Windows CE Windows CE SQL*Plus Oracle8 Navigator Windows CE Oracle Lite ODBC:CE : Windows CE Oracle Lite Oracle8 Navigator Oracle Lite Windows CE CREATEDB REMOVEDB ODBINFO ENCRYPDB DECRYPDB Oracle Lite : Oracle Lite for Windows CE Visual C++ for Windows CE 1-3
ODBC Windows CE Toolkit SQL.H ODBC Visual C++ for Windows CE Visual C++ ODBC Windows CE ODBC Windows CE Visual C++ ODBC Oracle Lite Visual C++ Windows CE Toolkit for Visual C++ SQL.H SQLEXT.H SQLTYPES.H SQLUCODE.H program files devstudio vc include program files devstudio wce include wce200 Visual C++ c: DevStudio SQLTYPES.H #include <wchar.h> #include <tchar.h> -D SQL_NOUNICODEMAP Oracle_Home lite pda40 wince platform Lib olod2040.lib platform MIPS SH-3 OLE repsvr8.cpp repsvr8.h Oracle_Home lite pda40 wince SAMPLES REPLICATION Oracle Lite for Windows CE Oracle_Home bin 32 Oracle Lite DLL SAMPLE.EXE ODBC 1-4 Oracle Lite Windows CE
1. CREATEDB Oracle Lite 2. WCE MFC AppWizard exe SAMPLE C++ 3. Oracle_Home lite pda40 wince samples odbc.cpp.h StdAfx.* 4. dbaccess.cpp FileView sampledlg.cpp 5. MFCCE20D.DLL program files devstudio wce mfc lib wce200 x86em program files windows ce platform sdk wce emul hpc 6. : Windows CE Oracle Lite 7. Windows CE Windows POLITE DSN Oracle Lite for Windows CE SH-3 MIPS Windows CE Handheld PC, Windows CE 2.0Handheld PC Professional Edition, Windows CE 2.1 Palm-size PC, Windows CE 2.1 8MB RAM Oracle8 Enterprise Edition Server 1-5
Windows NT Oracle Application Server 4.0HTTP Windows CE Toolkit for Visual C++ 5.0Windows CE : RAS Windows 95 Oracle Lite Windows CE RAS Oracle8 Navigator SQL*Plus REPSVR.EXE HTTP RAS Oracle Lite for Windows CE Oracle8i Lite Oracle Lite for Windows CE Windows CE Oracle_Home lite pda40 wince CESETUP.EXE Windows CE Remove Programs Oracle Lite for Windows CE : Oracle Lite 1-6 Oracle Lite Windows CE
1. REGSVRCE.EXE CE ATLCE.DLL REPSVR8.DLL 2. CESETUP.INI CESETUP.INI [DELETE] ORACE odbc.txt ORACE polite.txt ORACE olite40.msb Windows olobj40.dll Windows olod2040.dll Windows olrep840.dll Windows olsql40.dll Windows polhttp8.dll WINDOWS polfile8.dll WINDOWS poloma8.dll Windows polrep8.dll ORACE createdb.exe ORACE removedb.exe ORACE decrypdb.exe ORACE encrypdb.exe ORACE odbinfo.exe ORACE remodbc.exe ORACE HTML INDEX.HTML ORACE HTML IMAGE Oracle.gif ORACE HTML INDEX.HTML ORACE repsvr.exe ORACE sample.exe [DIRECTORY] [COPY] [EXECUTE] regsvrce /u windows atlce.dll regsvrce /u windows repsvr8.dll CESETUP.EXE 1-7
Oracle Lite for Windows CE Oracle_Home lite pda40 wince [ ] CESETUP.EXE Windows CE CESETUP.INI Windows CE CESETUP.EXE ODBC.TXT POLITE.TXT Oracle Lite OLITE40.MSB ODBC.TXT POLITE.TXT Windows CE.INI.TXT Windows CE POLITE.TXT.INIOracle Lite Mips MIPS Windows CE DLL EXE MIPS Windows CE MIPS Windows CE Mips Orace Oracle Lite SAMPLE.EXE REPSVR.EXE Mips Lib Oracle Lite Mips include Oracle Lite Mips Windows Windows CE Oracle Lite 1-8 Oracle Lite Windows CE
Sh3 SH-3 Windows CE DLL EXE SH-3 Windows CE SH-3 Windows CE Sh3 Orace Oracle Lite SAMPLE.EXE REPSVR.EXE Sh3 lib Oracle Lite Sh3 include Oracle Lite Sh3 Windows Windows CE Oracle Lite Samples SAMPLE.EXE REPSVR.EXE Oracle Lite for Windows CE REPSVR.EXE: Oracle Lite for Windows CE SAMPLE.EXE: Windows CE 2 : Visual C++ Debug Build Release Build 1-9
SAMPLE.EXE SAMPLE.EXE Oracle Lite for Windows CE CESETUP.EXE Windows CE My Handheld PC orace SAMPLE.EXE Oracle_Home lite pda40 wince samples odbc Windows CE SAMPLE.EXE TT POLITE.ODB TT 'Test1' 'Testing Oracle Lite' SAMPLE.EXE TT Windows CE REPSVR.EXE REPSVR.EXE Oracle Lite for Windows CE CESETUP.EXE Windows CE My Handheld PC orace replication REPSVR.EXE Oracle_Home lite pda40 wince samples replication Windows CE REPSVR.EXE Windows CE Oracle Server Java Oracle Lite JAC JDBC Windows CE Windows CE ODBC DSN CREATEDB Oracle Lite ANSIOUT.TXT... OK CESETUP.EXE orace POLITE.TXT ODBC.TXT CESETUP.EXE CESETUP.INI DELETE POLITE.ODB 1-10 Oracle Lite Windows CE
CESETUP.INI DELETE orace polite.odb 1-11
1-12 Oracle Lite Windows CE
2 Oracle Lite for Windows CE Oracle Lite for Windows CE 2-1
Oracle Lite for Windows CE Oracle Application Server HTTP Oracle8 Oracle Application Server 4.0 1. Oracle Lite for Windows CE Oracle Lite for Windows CE Oracle8i Lite : 2. RAS Windows CE RAS IP IP 3. CESETUP.EXE Oracle_Home lite pda40 wince CESETUP.EXE Windows CE Windows CE DSNWindows CE POLITE.ODB orace CESETUP.INI 4. Oracle Application Server HTTP HTTP Oracle Application Server 4.0 5. HTTP Oracle Application Server a. Oracle Application Server http://machine_name:8888 2-2 Oracle Lite Windows CE
machine_name Oracle Application Server 8888 b. OK Oracle Application Server c. OAS Manager Web d. Primary e. Web f. + g. C Web h. repcartx Replication Cartridge 4.0 Success 6. HTTP a. Success b. 2-3
repcartx Replication Cartridge Oracle_Home lite repcartx rephttp8.dll POLite_Entry /repcartx Oracle_Home lite repcartx c. Replication Cartridge d. Web Tx e. 1 f. Web MIME MIME 7. HTTP a. Replication Cartridge CWEB b. c. 2-4 Oracle Lite Windows CE
1 1 1 1000 1000 d. CWEB CWEB e. CWEB Oracle_Home lite repcartx rephttp8.dll POLite_Entry f. Oracle Application Server 8. Oracle Server cedemo cedemo Oracle Server DOS Server Manager Server Manager SQL connect system/manager create user cedemo identified by cedemo; grant dba, connect, resource, all privileges to cedemo; 2-5
9. Oracle Server Oracle Server TT a. Server Manager cedemo/cedemo b. cedemo VARCHAR2(10) VARCHAR2(20) 2 COL1 COL2 TT SQL create table TT (COL1 varchar2 (10) primary key, COL2 varchar2(20)); insert into TT values ('foo', 'foo'); 10. Oracle Server Windows NT Replication Manager a. RepMgr.exe b. tcp-loopback.world system manager c. OK cedemo cedemo d. a. tcp-loopback.world b. CEDEMO c. d. CEDEMO e. f. g. h. OK Replication Manager TT 2-6 Oracle Lite Windows CE
11. Oracle Application Server 12. Oracle Application Server Pocket Internet Explorer Windows CE Oracle Application Server 13. REPSVR.EXE a. Windows CE orace REPSVR.EXE b. Oracle Server cedemo cedemo Oracle Application Server Oracle Server tcp-loopbak.world URL URL Oracle Application Server http://server.oracle.com/repcartx HTTP OK c. Oracle Lite Oracle Lite DSN d. CE e. TT SQL select * from cedemo.tt OK 14. 15. OK REPSVR.EXE 2-7
16. SQL*Plus SAMPLE.EXE SQL*Plus : a. ODBC:CE Windows CE Oracle Lite b. Oracle Server SELECT * FROM TT; c. TT INSERT INTO TT VALUES ('test1', 'testing oracle lite'); d. SAMPLE.EXE : a. TT Windows CE orace SAMPLE.EXE TEST1,TESTING ORACLE LITE : SAMPLE.EXE TT TT OK 17. Windows CE TT TT : Oracle Lite CE DSN SQL*Plus Oracle8 Navigator CE DSN odbc:ce 2-8 Oracle Lite Windows CE
18. REPSVR.EXE TT Oracle Lite for Windows CE Oracle_Home lite pda40 wince CESETUP.INI DELETE Windows CE DIRECTORY Oracle Lite COPY Windows CE Oracle Lite EXECUTE Oracle Lite OLE Windows CE ODBC CE DSN CESETUP.INI Oracle Lite DEMO.EXE Windows CE CESETUP.INI [COPY] $CPU$ ORACE DEMO.EXE Windows DEMO.EXE Windows CE Oracle Application Server Oracle Application Server Oracle Server TNSNAMES 2-9
Windows CE Windows CE Windows CE Oracle Application Server Pocket Internet Explorer Oracle Application Server REPSVR.EXE Oracle Application Server IP Windows RAS RAS Windows CE Windows CE IP HTTP Windows CE IP Windows CE CESETUP.EXE IP Windows CE Windows Windows Windows CE Windows CE Windows NT 2-10 Oracle Lite Windows CE