Oracle Database Lite 10 g GUI Win32
Agenda Win32
Oracle Database Lite 10g Mobile Database WorkbenchGUI Oracle Database Lite 10g 10.2.0 21 Win32 Mobile Database Workbench
Oracle Database Lite10g Release2 R10.2.0.1 Hostname:client Windows 2000 professional Mobile JDK1.4.2_10 LiteLiteDB Hostname: server Windows 2000 professional Mobile Development Kit MDK Mobile JDK1.4.2_10 Oracle 10g R10.1.0.x SIDORCL PORT AS_HOME DB_HOME
Oracle Database Lite 10g 10.2.0 Mobile MDK
Oracle_HOME Mobile AS_HOME C: AS10g DB_HOME C: DB10g Oracle Lite Mobile LITE_HOME C: mobileclient
Mobile URL http://<mobileserver>:<port>/webtogo / http://server/webtogo Administrator / <> / TOM / TOMJONES JDBC <dbserver>:<port>:<sid> server:1521:orcl / SYSTEM / <> / MOBILEADMIN / <> / MASTER / <> Oracle Lite Mobile DSN <mobileuser>_<clientdb> TOM_MFS Lite / SYSTEM / TOMJONES / TOM / TOMJONES
Mobile Lite10g Oracle Universal InstallerOUI Mobile ORACLE_HOME AS_HOME C: AS10g Oracle 10g R10.1.x ORACLE_HOME DB_HOME
Mobile Mobile Server
Mobile server :1521 SID:ORCL
Mobile
Mobile 80 Oracle Application Server 10gORACLE_HOME
Mobile
Mobile
Mobile SYSTEM <>
Mobile MOBILEADMIN <>
Mobile Mobile Administrator <>
Mobile MASTER <>
Mobile
Mobile
MDK Lite10gOUI Mobile ORACLE_HOME AS_HOME C: AS10g
MDK MDK
MDK
Mobile Mobile OC4JOracle Application Server Containers for J2EE MobileAS_HOME > cd C: AS10g Mobile Server bin runmobileserver Mobile OC4JAS_HOME > cd C: AS10g mobile_oc4j j2ee mobileserver > java -jar admin.jar ormi://<mobileserver>:<port> <admin user> <pass> - shutdown force Oracle Application Server 10gASORACLE_HOME ASMobile
App App App App App Mobile Database WorkbenchMDW MDW / API Mobile Manager / ActiveSync or msync
1. MDW LiteDB LiteDB LiteDB Mobile Database WorkbenchMDW
LiteDB OracleDB PI SQL LiteDB
PI LiteDB Oracle PI PI /
1 1 2 3 :NO :NO= :NO= :NO= PI SELECT * FROM T1 WHERE COL3=:NO
1 2 LiteDB Oracle 12 PI /
1 1 3 57911 2 4 6 810 32 40 1 2 2 3 12 20 22 30 2 2 10 8 Lite ++x
2. App C / C++ C Visual Basic Java SODA ODBC.NET ADOCECOM COM SQL JDBC msync.exe C / C++ C.NET C / C++ / Visual Basic Mobile Sync API ADOCECOM COM Java
3. Mobile App
4. Setup.exe 3 a. b. c. Mobile Setup Mobile
5. / Mobile / 3 DB Obj App msyncexe, API
Win32
Win32 Mobile Field ServicesMFS ODBC TASK ToDo msync TomDickHarry
MASTER.TASK TASK NUMBER4 Description VARCHAR40 CustName VARCHAR30 CustPhone VARCHAR12 CustAddr VARCHAR40 CustCity VARCHAR40 Notes VARCHAR100 Primary Key Not Null Not Null Not Null Not Null
SYSTEM.TASK MFS MASTER.TASK Tom WHERE CustCity = Cupertino Lite SYSTEM.TASK MFS Dick WHERE CustCity = Mountain View Lite MFS Oracle Mobile SYSTEM.TASK MFS MFS Harry WHERE CustCity = Palo Alto Lite Mobile
1. TASK LiteDB 2. Lite LiteDBWin32 MFS 3. MFSMobile 4. Mobile 5. LiteDBMFS MFS
1. 1. 2. 3. 4. 5. Mobile 6. 7. 8. Lite Mobile Database Workbench Oracle
1-1. 1. MDW 2. 3. MFS C: MFS
1-1. 4. Mobile mobileadmin <> JDBC Oracle Thin <your hostname> DB 1521 DB SID ORCL DBSID
1-1. 5. master <> 6.
1-2. 1. SQL 2. Oracle Database 3. master <> <your hostname> 1521 SID ORCL SID
1-2. 4. 5. AS_HOME Mobile Sdk samples odbc win32 mfs src mfs.sql 6. Exit ORA-00900 SQL
1-2. 7. Select * from task; 4
1-3. 1. SQL 2. PI_TASK <>
1-3. 3. MASTER 4. 5. TASK
1-3. 6.
1-3. 7. SQL WHERE CustCity = :city 8.
1-4. 1. 2. MFS MFS
1-4. 3. PI_TASK 1
1-5. Mobile 1. MobileAdministrator http://<mobileserver>:<port>/webtogo/ Administrator <> 2.
1-5. Mobile 3.
1-5. Mobile 4. Tom Jones Tom tomjones
1-6. 1. 2. TEST MFS MDWDB Tom Mobile
1-6. 3. CITY Cupertino
1-6. 4. tomjones URL http://<mobileserver>:<port>/webtogo/
1-6. 5. SQL 6. Oracle Lite 7. Lite system LiteDBsystem tomjones LiteDBMobile MobileTom DSN tom_mfs Mobile_
1-6. 8. TASK select * from TASK; Custcity= Cupertino 2
1-7. 1. MobileAdministrator http://<mobileserver>:<port>/webtogo/ Administrator <> 2.
1-7. 3.
1-7.
1-8. 1. 1-6-8TASK update task set Notes= Replaced the motor:$65 where ID=1; commit; ID=1
1-8. 2. 3. TEST
1-8. 4. SQL 5. Oracle Database 6. master <> <your hostname> 1521 SID ORCL SID
1-8. 7. select * from TASK;
1-8. 8. TASK update TASK set Description= Garbage Disposal Leaking, Notes = Urgent:house is getting flooded where ID=2; commit; ID=2
1-8. 9. 10. TEST
1-8. 11. SQL 12. Oracle Lite 13. Lite system Litesystem tomjones LiteMobile MobileTom DSN tom_mfs Mobile_
1-8. 14. TASK select * from TASK;
1-8. 15.
2. ODBC MFS - AS_HOME Mobile Sdk Samples ODBC Win32 MFS bin srcmakefile - mfs.exe <DSN> <username> <password> - TASK - ODBC - APImSync API=mSync.exe App
3. 1. App 2.
3-1. 1. - AS_HOME Mobile Sdk Samples ODBC Win32 MFS bin mfs.exec: MFSDEV
3-1. 2. wtgpack MDW 3.
3-1. 4. Oracle Lite Win32;JA
3-1. 5. MFS /mfs Mobile Field Service C: MFSDEV MFS / MDW
3-1. 6. 7. Mobile URL http://<mobileserver>:<port>/webtogo MobileURL Administrator <>
3-1. 8.
3-2. 1. MFS
3-2. 2. 3. TOM
3-2. 4.
4. 1. Mobile Setup Mobile DB
4-1. Mobile 1. MobileURL http://<mobileserver>:<port>/webtogo/setup
4-1. Mobile 2. Win32 3. TOM tomjones
4-1. Mobile 4. Mobilelite,syncdll Mobile
5. 1. 2. DB Obj App msyncexe, API
5-1. 1. msync LITE_HOME bin msync.exe 2. DSN
5-1. 3. msync
5-1. Mobile Mobilelitemsync mfs.exe mfs.odb
5-2. 1. mfs.exe C: > cd LITE_HOME mfs LITE_HOME mfs> mfs.exe tom_mfs system tomjones userapp Lite : system : <mobileuser_password> tomjones DSNWin32 : <mobileuser_name>_<dbname> tom_mfs DSN PPC : <dbname> mfs
OracleOracle Corporation Oracle Corporation