untitled

Size: px

Start display at page:

Download "untitled"

かつかげにばし
5 years ago
Views:

1 Oracle Database Lite 10 g GUI Win32

2 Agenda Win32

3 Oracle Database Lite 10g Mobile Database WorkbenchGUI Oracle Database Lite 10g Win32 Mobile Database Workbench

5 Oracle Database Lite10g Release2 R 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 R x SIDORCL PORT AS_HOME DB_HOME

6 Oracle Database Lite 10g Mobile MDK

7 Oracle_HOME Mobile AS_HOME C: AS10g DB_HOME C: DB10g Oracle Lite Mobile LITE_HOME C: mobileclient

8 Mobile URL / 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

10 Mobile Lite10g Oracle Universal InstallerOUI Mobile ORACLE_HOME AS_HOME C: AS10g Oracle 10g R10.1.x ORACLE_HOME DB_HOME

11 Mobile Mobile Server

12 Mobile server :1521 SID:ORCL

13 Mobile

14 Mobile 80 Oracle Application Server 10gORACLE_HOME

15 Mobile

16 Mobile

17 Mobile SYSTEM <>

18 Mobile MOBILEADMIN <>

19 Mobile Mobile Administrator <>

20 Mobile MASTER <>

21 Mobile

22 Mobile

23 MDK Lite10gOUI Mobile ORACLE_HOME AS_HOME C: AS10g

24 MDK MDK

25 MDK

26 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

28 App App App App App Mobile Database WorkbenchMDW MDW / API Mobile Manager / ActiveSync or msync

29 1. MDW LiteDB LiteDB LiteDB Mobile Database WorkbenchMDW

30 LiteDB OracleDB PI SQL LiteDB

31 PI LiteDB Oracle PI PI /

32 :NO :NO= :NO= :NO= PI SELECT * FROM T1 WHERE COL3=:NO

33 1 2 LiteDB Oracle 12 PI /

34 Lite ++x

35 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

36 3. Mobile App

37 4. Setup.exe 3 a. b. c. Mobile Setup Mobile

38 5. / Mobile / 3 DB Obj App msyncexe, API

39 Win32

40 Win32 Mobile Field ServicesMFS ODBC TASK ToDo msync TomDickHarry

41 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

42 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

43 1. TASK LiteDB 2. Lite LiteDBWin32 MFS 3. MFSMobile 4. Mobile 5. LiteDBMFS MFS

44 Mobile Lite Mobile Database Workbench Oracle

45 MDW MFS C: MFS

46 Mobile mobileadmin <> JDBC Oracle Thin <your hostname> DB 1521 DB SID ORCL DBSID

47 master <> 6.

48 SQL 2. Oracle Database 3. master <> <your hostname> 1521 SID ORCL SID

49 AS_HOME Mobile Sdk samples odbc win32 mfs src mfs.sql 6. Exit ORA SQL

50 Select * from task; 4

51 SQL 2. PI_TASK <>

52 MASTER TASK

54 SQL WHERE CustCity = :city 8.

55 MFS MFS

56 PI_TASK 1

57 1-5. Mobile 1. MobileAdministrator Administrator <> 2.

58 1-5. Mobile 3.

59 1-5. Mobile 4. Tom Jones Tom tomjones

60 TEST MFS MDWDB Tom Mobile

61 CITY Cupertino

62 tomjones URL

63 SQL 6. Oracle Lite 7. Lite system LiteDBsystem tomjones LiteDBMobile MobileTom DSN tom_mfs Mobile_

64 TASK select * from TASK; Custcity= Cupertino 2

65 MobileAdministrator Administrator <> 2.

67 1-7.

68 TASK update task set Notes= Replaced the motor:$65 where ID=1; commit; ID=1

69 TEST

70 SQL 5. Oracle Database 6. master <> <your hostname> 1521 SID ORCL SID

71 select * from TASK;

72 TASK update TASK set Description= Garbage Disposal Leaking, Notes = Urgent:house is getting flooded where ID=2; commit; ID=2

73 TEST

74 SQL 12. Oracle Lite 13. Lite system Litesystem tomjones LiteMobile MobileTom DSN tom_mfs Mobile_

75 TASK select * from TASK;

77 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

78 3. 1. App 2.

79 AS_HOME Mobile Sdk Samples ODBC Win32 MFS bin mfs.exec: MFSDEV

80 wtgpack MDW 3.

81 Oracle Lite Win32;JA

82 MFS /mfs Mobile Field Service C: MFSDEV MFS / MDW

83 Mobile URL MobileURL Administrator <>

85 MFS

86 TOM

88 4. 1. Mobile Setup Mobile DB

89 4-1. Mobile 1. MobileURL

90 4-1. Mobile 2. Win32 3. TOM tomjones

91 4-1. Mobile 4. Mobilelite,syncdll Mobile

92 DB Obj App msyncexe, API

93 msync LITE_HOME bin msync.exe 2. DSN

94 msync

95 5-1. Mobile Mobilelitemsync mfs.exe mfs.odb

5-2. 1. mfs.exe C: > cd LITE_HOME mfs LITE_HOME mfs> mfs.

96 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

97 OracleOracle Corporation Oracle Corporation

BC4J...4 BC4J Association JSP BC4J JSP OC4J

BC4J...4 BC4J Association JSP BC4J JSP OC4J lê~åäévá=gaéîéäçééê= 9.0.3/9.0.4 BC4J Creation Date: Oct 08, 2003 Last Update: Feb 27, 2004 Version 1.0 ...3... 3 BC4J...4 BC4J...4... 4... 5... 6...7... 8... 9 Association... 13... 15... 20... 22... 25