FileMaker ODBC と JDBC ガイド

Size: px

Start display at page:

Download "FileMaker ODBC と JDBC ガイド"

ゆいとおえづか
4 years ago
Views:

1 FileMaker ODBC JDBC

2 FileMaker, Inc. All Rights Reserved. FileMaker, Inc Patrick Henry Drive Santa Clara, California FileMakerFileMaker CloudFileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgments Documentation Acknowledgments URL FileMaker, Inc. 01

3 1 5 5 FileMaker 5 ODBC JDBC 6 ODBC FileMaker 6 ODBC 6 ODBC 7 FileMaker 7 FileMaker Pro Advanced SQL 9 ODBC 9 SQL ODBC 10 ODBC ODBC 11 3 FileMaker ODBC FileMaker Cloud ODBC 12 ODBC (Windows) 12 ODBC (Windows) 13 (Windows) 14 ODBC (Windows) 14 DSN (Windows) 14 ODBC (macos) 16 (macos) ODBC FileMaker 20 ODBC 20 ODBC 21 FileMaker 22

4 4 Windows FileMaker 22 FileMaker DSN ODBC (Windows) 22 ODBC (Windows) 23 macos FileMaker 23 FileMaker DSN ODBC (macos) 23 ODBC (macos) 24 5 FileMaker JDBC FileMaker Cloud JDBC 25 JDBC 25 JDBC 26 6 JDBC FileMaker 27 JDBC 27 JDBC 27 JDBC 28 JDBC URL 29 URL FileMaker 32 JDBC ODBC 33 JDBC DatabaseMetaData 33 FileMaker ODBC 33 FileMaker JDBC ODBC JDBC 35 ODBC 35 JDBC 35 37

5 1 FileMaker ODBC (Open Database Connectivity) JDBC (Java Database Connectivity) FileMaker ODBC JDBC 1 ODBC FileMaker 1 SQL ODBC ODBC [ ] > [...] [ ] [SQL ] [ExecuteSQL] 1 FileMaker Pro Advanced 1 FileMaker Server 1 FileMaker Cloud FileMaker Pro Advanced 1 FileMaker Cloud 1 FileMaker 1 FileMaker Pro ODBC 1. ODBC JDBC 2. SQL 1 FileMaker Pro Advanced 1 FileMaker Server 1 FileMaker Cloud FileMaker SQL 1 FileMaker Cloud ODBC JDBC SQL FileMaker SQL FileMaker SQL SQL FileMaker FileMaker

6 1 6 ODBC JDBC ODBC JDBC API () ODBC C API JDBC Java API API FileMaker Pro Advanced FileMaker Server ODBC JDBC SQL () SQL () ODBC JDBC API FileMaker ODBC FileMaker ODBC FileMaker SQL FileMaker ODBC SQL ODBC ODBC ODBC ODBC 1 [] ODBC FileMaker Pro Advanced SQL SQL 1 [] [SQL ] FileMaker SQL SQL ODBC SQL ODBC ODBC FileMaker SQL FileMaker SQL

7 1 7 ODBC ODBC FileMaker SQL : 1 ODBC 1 ODBC ODBC 1 1 FileMaker ODBC () FileMaker Pro Advanced ODBC SQL FileMaker Pro Advanced OracleSQL Server MySQL FileMaker Pro Advanced ODBC 2 SQL FileMaker ODBC FileMaker FileMaker ODBC JDBC FileMaker FileMaker ODBC JDBC SQL FileMaker FileMaker Pro Advanced FileMaker CloudFileMaker Server FileMaker Pro Advanced FileMaker ODBC JDBC FileMaker FileMaker FileMaker Cloud FileMaker Server FileMaker Pro Advanced ODBC JDBC () (Web ) 5 () FileMaker FileMaker FileMaker ODBC ODBC

8 1 8 ODBC JDBC FileMaker Pro Advanced FileMaker Server ODBC JDBC FileMaker Pro Advanced FileMaker Server ODBC JDBC SQL FileMaker SQL ODBC/JDBC FileMaker Cloud FileMaker Server FileMaker Pro Advanced ODBC JDBC ( FileMaker ) FileMaker Microsoft Access: Microsoft Access FileMaker Microsoft Access Microsoft Access FileMaker Server FileMaker TCP/IP FileMaker Pro Advanced () FileMaker Cloud Amazon EC2 FileMaker Pro Advanced FileMaker Server FileMaker 3 FileMaker ODBC 5 FileMaker JDBC 1 FileMaker (DSN) 1 DSN FileMaker 1 DSN 1 FileMaker Pro Advanced ODBC JDBC

9 2 SQL ODBC FileMaker SQL FileMaker ODBC SQL ODBC ODBC ODBC ODBC ODBC Oracle Oracle ODBC ODBC SQL ODBC FileMaker Pro Advanced SQL ODBC FileMaker Pro Advanced ODBC (Oracle Microsoft Access ) FileMaker Pro Advanced FileMaker Pro Advanced [] [] [SQL ] ODBC ODBC 1. ODBC 2. ODBC ODBC DSN 3. ODBC ( )

10 2 SQL FileMaker Pro Advanced : 1 FileMaker Pro Advanced [] > [] > [ODBC...] 1 FileMaker Pro Advanced [] > [...] [] (Windows) [] (macos) [ODBC...] 5. () [OK] FileMaker Pro Advanced SQL 6. FileMaker Pro Advanced SQL SQL [WHERE] [ORDER BY] SQL Query SQL [] [SQL ] FileMaker ODBC [SQL ] SQL FileMaker Pro Advanced Runtime SQL FileMaker FileMaker Pro Advanced FileMaker SQL FileMaker SQL SQL ODBC ODBC FileMaker Pro Advanced [SQL ] [ExecuteSQL] SQL [SQL ] INSERTUPDATE DELETE SQL [ExecuteSQL] SELECT SQL FileMaker Pro Advanced FileMaker Pro Advanced SQL Server SQL [SQL ] [ExecuteSQL] FileMaker FileMaker Pro Advanced FileMaker SQL FileMaker SQL

11 2 SQL 11 ODBC ODBC FileMaker SQL ODBC FileMaker Pro Advanced FileMaker Server SQL ODBC FileMaker Pro Advanced FileMaker Pro Advanced FileMaker Pro Advanced ServerCloud SQL FileMaker Pro Advanced FileMaker ODBC ODBC OracleMicrosoft SQL Server MySQL Community Edition SQL SQL FileMaker ODBC ODBC FileMaker Pro Advanced 1. ODBC 2. FileMaker Pro Advanced ODBC DSN 3. ODBC ( ) 4. ODBC FileMaker Pro Advanced 1 5. FileMaker Pro Advanced 6. ODBC ODBC ODBC ODBC ODBC FileMaker Pro Advanced

12 3 FileMaker ODBC ODBC FileMaker ODBC ODBC FileMaker ODBC ODBC FileMaker xdbc FileMaker FileMaker Server FileMaker FileMaker SQL ODBC FileMaker FileMaker TCP/IP FileMaker Cloud ODBC FileMaker Cloud ODBC FileMaker Cloud ODBC (Windows) FileMaker Windows ODBC

13 3 FileMaker ODBC 13 ODBC 1 ODBC ODBC ODBC (Windows) Windows Windows Windows ODBC : 1. : 1 (.exe ) 1 2. FileMaker Pro Advanced FileMaker Server Extras 3. xdbc 4. xdbcodbc Client Driver Installer 5. ODBC Client Driver Installer 1 32 (fmodbc32.dll) 32 FMODBC_Installer_Win32.msi 1 64 (fmodbc64.dll) 64 FMODBC_Installer_Win64.msi 6. ODBC 7. [] ODBC 1 32 Windows 32 (fmodbc32.dll) C: Windows System Windows 32 (fmodbc32.dll) C: Windows SysWOW Windows 64 (fmodbc64.dll) C: Windows System32 FileMaker ODBC [FileMaker ODBC]

14 3 FileMaker ODBC 14 (Windows) ODBC FileMaker FileMaker 2399 ODBC (Windows) ODBC [] [] 32 Windows 32 ODBC Windows [] > [ (ODBC)] 64 Windows 32 ODBC Windows [] > [ODBC (32 )] 64 Windows 64 ODBC Windows [] > [ODBC (64 )] DSN (Windows) ODBC 1. [ODBC ] [ DSN] [ DSN] FileMaker DSN 2. [...] 3. [FileMaker ODBC] [] 4. [] 5. [] FileMaker [] FileMaker []

15 3 FileMaker ODBC [] 1 FileMaker Pro Advanced localhost IP FileMaker Server SSL ODBC/JDBC [ ] FileMaker XDBC Listener CStore SSL SSL 1 ODBC [] 1 ODBC [] 1 [] [] [] 7. [] FileMaker FileMaker Server [] FileMaker Server FMServer_Sample ODBC ODBC 1 [...] [] [] [] [] [UTF-8] Microsoft Excel [] Web [UTF-8] FileMaker 3 UTF-8 1 Microsoft Word 255 PHP [ long varchar ] 255 (Windows) 255 (macos)

16 3 FileMaker ODBC 16 1 [ ] [] 8. FileMaker DSN 1 [] FileMaker ODBC FileMaker FileMaker ODBC/JDBC fmxdbc FileMaker ServerFileMaker Pro Advanced FileMaker Cloud ODBC/JDBC 1 [] ODBC (macos) /Library/ODBC ODBC : 1. : 1 (.dmg ) 1 2. FileMaker Pro Advanced FileMaker Server Extras 3. xdbc 4. xdbcodbc Client Driver Installer 5. ODBC Client Driver InstallerFileMaker ODBC.pkg 6. ODBC 7. [] ODBC //ODBC ODBC FileMaker ODBC [FileMaker ODBC]

17 3 FileMaker ODBC 17 (macos) ODBC FileMaker FileMaker Actual Technologies ODBC Manager FileMaker 2399 ODBC 1. ODBC Manager (ODBC Manager ) 2. [ DSN] [ DSN] FileMaker DSN 3. [...] 4. [FileMaker ODBC] [OK] 5. [] 6. [] FileMaker [] FileMaker [] 7. [] 1 FileMaker Pro Advanced localhost IP FileMaker Server SSL ODBC/JDBC [ ] FileMaker XDBC Listener CStore SSL SSL 1 ODBC [] 1 ODBC [] 1 [] [] []

18 3 FileMaker ODBC [] FileMaker FileMaker Server [] FileMaker Server FMServer_Sample ODBC ODBC 1 [...] [] [] 4 ODBC [ODBC API ] SQL_C_CHAR SQL_C_WCHAR [ Unicode ] [] [ (MacJapanese)] [UTF-8] Microsoft Excel [ ] Web [UTF-8] FileMaker 3 UTF-8 1 Microsoft Word 255 PHP [ long varchar ] 1 [ ] [ ()] [] 9. FileMaker DSN 1 [] FileMaker ODBC FileMaker FileMaker ODBC/JDBC fmxdbc FileMaker ServerFileMaker Pro Advanced FileMaker Cloud ODBC/JDBC 1 []

19 3 FileMaker ODBC 19 SQL FileMaker ODBC [] [SQL ] 4 ODBC FileMaker

20 4 ODBC FileMaker ODBC FileMaker ODBC FileMaker FileMaker ODBC FileMaker ODBC FileMaker Pro Advanced ODBC SQL ODBC ODBC SQL 2 SQL ODBC ODBC API ODBC ODBC SQL () SQL ( ) FileMaker ODBC SQL FileMaker SQL ODBC FileMaker SQL FileMaker FileMaker Server FileMaker () () /

21 4 ODBC FileMaker 21 Oracle ODBC SQL Server ODBC FileMaker ODBC Oracle Microsoft SQL Server FileMaker ODBC ODBC ODBC ODBC ODBC FileMaker 1 Microsoft Word 1 Microsoft Excel 1 FileMaker Microsoft SQL Server DBMS 1 FileMaker 1 FileMaker Pro Advanced Microsoft Visual Basic FileMaker FileMaker Pro Advanced ODBC/JDBC fmxdbc ODBC/JDBC FileMaker Pro Advanced FileMaker Server FileMaker Cloud FileMaker ODBC FileMaker FileMaker FileMaker ODBC

22 4 ODBC FileMaker 22 FileMaker XDBC Listener macos Windows XDBC Listener fmxdbc_listener FileMaker ODBC SQL FileMaker SQL ODBC FileMaker 1. FileMaker Pro Advanced ODBC/JDBC fmxdbc 2. FileMaker ServerFileMaker Pro Advanced FileMaker Cloud ODBC/JDBC FileMaker Pro Advanced FileMaker Server FileMaker Cloud 3. FileMaker FileMaker FileMaker 4. FileMaker 5. SQL FileMaker FileMaker DSN 1 FileMaker Windows FileMaker FileMaker DSN ODBC (Windows) FileMaker DSN DSN FileMaker ODBC FileMaker FileMaker DSN 14 (Windows)

23 4 ODBC FileMaker 23 ODBC (Windows) FileMaker ODBC 1. [ODBC ] 14 ODBC (Windows) 2. [ DSN] [ DSN] ( ) 3. FileMaker [] DSN [] [FileMaker ODBC] 4. [...] 5. [] [] 6. [] FileMaker [ ID] [] 1 FileMaker 1 1 FileMaker ODBC/JDBC fmxdbc 1 FileMaker Server FileMaker Pro Advanced ODBC/JDBC macos FileMaker FileMaker DSN ODBC (macos) FileMaker DSN DSN FileMaker ODBC FileMaker FileMaker DSN 17 (macos)

24 4 ODBC FileMaker 24 ODBC (macos) FileMaker ODBC 1. ODBC Manager (ODBC Manager ) 2. [ DSN] [ DSN] ( ) 3. FileMaker [] DSN [] [FileMaker ODBC] 4. [...] 5. [] [] 6. [] FileMaker [ ID] [] 1 FileMaker 1 1 FileMaker ODBC/JDBC fmxdbc 1 FileMaker Server FileMaker Pro Advanced ODBC/JDBC

25 5 FileMaker JDBC JDBC FileMaker JDBC JDBC FileMaker FileMaker FileMaker Server FileMaker FileMaker SQL JDBC FileMaker JDBC FileMaker JDBC JDK 1.6 Java (Windows) (macos) java -version FileMaker TCP/IP FileMaker Cloud JDBC FileMaker Cloud JDBC FileMaker Cloud JDBC JDBC

26 5 FileMaker JDBC 26 JDBC : 1. : 1 Windows: (.exe ) 1 macos: (.dmg ) 1 2. FileMaker Pro Advanced FileMaker Server Extras 3. xdbc 4. xdbcjdbc Client Driver 5. fmjdbc.jar 1 Windows:fmjdbc.jar Java (java.exe) Java ClassPath 1 macos:fmjdbc.jar//java/extensions Java ClassPath FileMaker JDBC JDBC JDBC Java JDBC JDBC URL (Uniform Resource Locator) FileMaker JDBC JDBC 6 JDBC FileMaker

27 6 JDBC FileMaker Java JDBC RAD (Rapid Application Development) FileMaker Java JDBC Java FileMaker JDBC JDBC SQL Java API JDBC JDBC SQL JDBC Java FileMaker SQL FileMaker FileMaker Server Java () FileMaker () / Java JDBC FileMaker JDBC Java Java RAD JDBC Java JDBC JDBC JDBC Java JDBC URL JDBC URL

28 6 JDBC FileMaker 28 JDBC JDBC JDBC 3.0 FileMaker 1 SAVEPOINT Ref 1 CLOBARRAY REF 1 1 DATALINK 1 1 JDBC SPI JDBC Java Development Kit (JDK) FileMaker JDBC Java (JDBC ) Java com.filemaker.jdbc.driver FileMaker FileMaker JDBC JDBC FileMaker FileMaker XDBC Listener macos Windows XDBC Listener fmxdbc_listener XDBC Listener FileMaker Server FileMaker Server Admin Console XDBC Listener FileMaker Server

29 6 JDBC FileMaker 29 JDBC URL Java URL JDBC URL JDBC JDBC URL 3 jdbc:<>:<> JDBC URL JDBC (jdbc) <> JDBC filemaker<>filemaker IP JDBC FileMaker JDBC 1. JDBC JDBC 2. FileMaker JDBC URL jdbc:filemaker:// /database 3.

30 6 JDBC FileMaker 30 import java.sql.*; class FMPJDBCTest { public static void main(string[ ] args) { // JDBC try { Driver d = (Driver)Class.forName("com.filemaker.jdbc.Driver").newInstance(); } catch(exception e) { System.out.println(e); } // FileMaker Connection con; try { con = DriverManager.getConnection("jdbc:filemaker:// /myda tabase"," ", " "); } catch(exception e) { System.out.println(e); } // SQLWarning warning = null; try { warning = con.getwarnings(); if (warning == null) { System.out.println(" "); return; } while (warning!= null) { System.out.println(" : "+warning); warning = warning.getnextwarning(); } } catch (Exception e) { Sysem.out.println(e); } } }

31 6 JDBC FileMaker 31 URL user password JDBC URL DriverManager.GetConnection 1 user: ODBC/JDBC fmxdbc FileMaker 1 password: FileMaker URL JDBC URL : jdbc:filemaker://<filemaker IP >/<> jdbc:filemaker:// /publications URL JDBC URL : jdbc:filemaker://<filemaker IP >/<>?user=< >&password=<> jdbc:filemaker:// /customers?user=collections&password=admin (&) : jdbc:filemaker://localhost/sales_db?user=ad&min&password=admin : jdbc:filemaker://localhost/sales_db?user=admin1&password=ad&min JDBC JDBC SocketTimeout

32 6 JDBC FileMaker 32 Connection conn = DriverManager.getConnection ( "jdbc:filemaker:// /customers?sockettimeout=100", "admin", "admin" ); FileMaker 1 JDBC URL FileMaker JDBC FMServer_Sample JDBC JDBC JDBC FileMaker 1 FileMaker 1 FileMaker ODBC/JDBC fmxdbc 1 FileMaker ServerFileMaker Pro Advanced FileMaker Cloud ODBC/JDBC FileMaker FileMaker Pro Advanced ODBC/JDBC fmxdbc ODBC/JDBC FileMaker Pro Advanced FileMaker Server FileMaker Cloud 1 JDBC JDBC URL (Java )

33 7 ODBC ODBC 1 SQLTables - 1 () 1 SQLColumns 1 SQLColumnPrivileges 1 SQLDescribeCol 1 SQLGetTypeInfo JDBC DatabaseMetaData JDBC DatabaseMetaData 1 getcolumns 1 gettables 1 getcolumnprivileges 1 getmetadata 1 gettypeinfo 1 gettabletypes 1 getversioncolumns FileMaker ODBC FileMaker ODBC FileMaker ODBC SQL_VARCHAR FileMaker [ ] 100 FileMaker NULL SQL_DOUBLE FileMaker SQL_DATE SQL_TIME FileMaker 24 0 SQL_TIMESTAMP

34 7 34 FileMaker ODBC (BLOB) SQL_LONGVARBINARY SELECT CAST() GetAs() ODBC Unicode FileMaker INSERT INTO mytable(repfield[3]) VALUES ( this is rep 3 ) SELECT "repfield"[1], "repfield"[2] FROM "mytable" FileMaker JDBC JDBC FileMaker JDBC SQL FileMaker JDBC SQL java.sql.types.varchar java.sql.types.double java.sql.types.date java.sql.types.time java.sql.types.timestamp java.sql.types.blob FileMaker JDBC JDBC SQL FileMaker JDBC java.sql.types.timestamp

35 ODBC API Windows ODBC API ODBC JDBC FileMaker ODBC/JDBC ODBC 1 ODBC 1 FileMaker FileMaker XDBC Listener FileMaker ODBC FileMaker XDBC Listener DSN [FileMaker] [FileMaker ODBC] [FileMaker] [FileMaker ODBC] Invalid Account/Password FileMaker JDBC FileMaker JDBC SQLException 1 JDBC 1 FileMaker FileMaker XDBC Listener

36 7 36 FileMaker JDBC FileMaker XDBC Listener DSN [FileMaker] [FileMaker JDBC] [FileMaker] [FileMaker JDBC] Invalid Account/Password FileMaker

37 32 ODBC (Windows) ODBC (Windows) (Windows) (Windows) A ARRAY 28 B BLOB 34 C CAST 34 CLOB 28 D DatabaseMetaData 33 DATALINK 28 DATE 34 DOUBLE 34 DSN (macos) 23 (Windows) E ExecuteSQL 10 F FileMaker Cloud JDBC 25 ODBC 12 FileMaker ODBC macos 16 Windows 13 FileMaker Server 5 FileMaker 7 FileMaker JDBC 31 ODBC (macos) 23 ODBC (Windows) 22 FileMaker ODBC JDBC 5 fmxdbc 21, 31 G GetAs 34 getcolumnprivileges 33 getcolumns 33 getmetadata 33 gettables 33 gettabletypes 33 gettypeinfo 33 getversioncolumns 33 J Java (JDK) 28 Java 25 JDBC SPI 28 JDBC 35 JDBC JDBC URL 29 JDBC 28 JDBC JDBC JDBC URL (Uniform Resource Locator) 29 JDBC 29 JDBC 27 JDBC 28 JDBC 28 M macos DSN 17 JDBC 25 ODBC 24 Microsoft Access 8 MySQL 11

38 38 N NULL 33 O ODBC Manager DSN 17 ODBC ODBC (macos) 24 ODBC 35 ODBC 33 ODBC (macos) 24 (Windows) ODBC ODBC DSN 14 ODBC ODBC 9 ODBC/JDBC 22 Oracle 11 P PDF 5 R Rapid Application Development (RAD) 27 REF 28 Runtime 10 S SAVEPOINT 28 SQL Server 11 SQL 6, 10 SQL 9, 10 SQL_DATE 33 SQL_DOUBLE 33 SQL_LONGVARBINARY 34 SQL_TIME 33 SQL_TIMESTAMP 33 SQL_VARCHAR 33 SQLColumnPrivileges 33 SQLColumns 33 SQLDescribeCol 33 SQLExceptions 35 SQLGetTypeInfo 33 SQLTables 33 T TCP/IP 8 TIME 34 TIMESTAMP 34 V VARCHAR 34 W Web FileMaker 5 Windows DSN 22 JDBC 25 ODBC 23 X XDBC Listener JDBC 28 ODBC ODBC (macos) 24 ODBC (Windows) 23 JDBC 32 JDBC 32 ODBC (macos) 24 ODBC (Windows) 23 12, JDBC 34 ODBC 34 5

39 39 SQL ODBC/JDBC 22 FileMaker 8 FileMaker 5 34 JDBC 25 ODBC JDBC 32 JDBC 31 ODBC (macos) 24 ODBC (Windows) 23 ODBC (macos) 23 ODBC (Windows) 22 FileMaker 1 DSN 8 FileMaker 8 JDBC 34 ODBC 33 8 JDBC 31 ODBC (macos) 23 ODBC (Windows) 22 JDBC 31 ODBC 23, 24 JDBC 26 ODBC (macos) 17 ODBC (Windows) JDBC 34 ODBC JDBC 26 ODBC (macos) 17 ODBC (Windows) ,

FileMaker 16 ODBC と JDBC ガイド

FileMaker 16 ODBC と JDBC ガイド FileMaker 16 ODBC JDBC 2004-2017 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMakerFileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker