FileMaker ODBC and JDBC Guide

Size: px

Start display at page:

Download "FileMaker ODBC and JDBC Guide"

れんかはぎにわ
5 years ago
Views:

1 FileMaker 14 ODBC JDBC

2 FileMaker, Inc. All Rights Reserved. FileMaker, Inc Patrick Henry Drive Santa Clara, California FileMaker FileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgements URL FileMaker, Inc. 01

3 1 5 5 FileMaker 5 ODBC JDBC 5 ODBC FileMaker 6 ODBC 6 ODBC 6 FileMaker 7 FileMaker Pro SQL 9 ODBC 9 ODBC SQL 10 ODBC 11 FileMaker ODBC 11 3 FileMaker ODBC ODBC 13 ODBC Windows 14 Windows 15 ODBC Windows 15 DSN Windows 15 ODBC OS X 17 OS X 17 19

4 4 4 ODBC FileMaker 20 ODBC 20 ODBC 21 FileMaker 22 Windows FileMaker 22 FileMaker DSN ODBC Windows 22 ODBC Windows 23 OS X FileMaker 23 FileMaker DSN ODBC OS X 23 ODBC OS X 24 5 FileMaker JDBC JDBC 25 JDBC 26 6 JDBC FileMaker 27 JDBC 27 JDBC 27 JDBC 28 JDBC URL 28 URL 30 FileMaker 30 JDBC ODBC 32 JDBC DatabaseMetaData 32 FileMaker ODBC 32 FileMaker JDBC ODBC JDBC 34 ODBC 34 JDBC 34 35

5 1 FileMaker ODBCOpen Database Connectivity JDBCJava Database Connectivity FileMaker ODBC JDBC 1 FileMaker Pro 1 FileMaker Pro Advanced 1 FileMaker Server 1 ODBC FileMaker 1 SQL ODBC 1 FileMaker 1 FileMaker Pro ODBC ODBC [ ] > [ ] [ ] [SQL ] [ExecuteSQL] 1. ODBC JDBC 2. SQL 1 ODBC JDBC SQL FileMaker SQL FileMaker SQL SQL 1 FileMaker Pro Advanced FileMaker ProFileMaker Pro FileMaker Pro Advanced 1 FileMaker Pro 1 FileMaker Pro Advanced 1 FileMaker Server FileMaker Pro FileMaker SQL FileMaker 1 FileMaker Pro [ ] [ ] 1 FileMaker Server Admin Console [ ] > [FileMaker Server ] 1 FileMaker ODBC JDBC ODBC JDBC APIODBC C API JDBC Java API API FileMaker Pro FileMaker Server ODBC JDBC SQL SQL

6 1 6 ODBC JDBC API FileMaker ODBC FileMaker ODBC FileMaker SQL FileMaker ODBC SQL ODBC ODBC ODBC ODBC 1 [ ] ODBC FileMaker Pro SQL SQL 1 [ ] [SQL ] [ExecuteSQL] FileMaker SQL SQL ODBC SQL ODBC ODBC FileMaker SQL FileMaker SQL ODBC ODBC FileMaker SQL 1 ODBC 1 ODBC ODBC 1 1 FileMaker ODBC FileMaker Pro ODBC SQL FileMaker Pro OracleSQL Server MySQL FileMaker Pro ODBC 2 SQL FileMaker ODBC

7 1 7 FileMaker FileMaker ODBC JDBC FileMaker FileMaker ODBC JDBC SQL FileMaker FileMaker Pro FileMaker Server FileMaker Pro FileMaker ODBC JDBC FileMaker FileMaker FileMaker Server FileMaker Pro Web FileMaker FileMaker FileMaker ODBC ODBC ODBC JDBC FileMaker Pro FileMaker Server ODBC JDBC 1 ODBC FileMaker 3 FileMaker ODBC 1 FileMaker FileMaker ODBC 4 ODBC FileMaker 1 JDBC FileMaker 5 FileMaker JDBC 1 FileMaker JDBC FileMaker Java 6 JDBC FileMaker 1 FileMaker ODBC JDBC 7 FileMaker Pro FileMaker Server ODBC JDBC SQL FileMaker SQL ODBC/JDBC FileMaker Server FileMaker Pro ODBC JDBC FileMaker FileMaker

8 1 8 Microsoft Access: Microsoft Access FileMaker Microsoft Access Microsoft Access FileMaker Server FileMaker TCP/IP FileMaker Pro FileMaker Pro FileMaker Server 14 FileMaker 14 FileMaker Pro FileMaker Server 3 FileMaker ODBC 5 FileMaker JDBC 1 FileMaker DSN DSN FileMaker DSN 1 FileMaker Pro ODBC JDBC

9 2 SQL ODBC FileMaker SQL FileMaker ODBC SQL ODBC ODBC ODBC ODBC ODBC Oracle Oracle ODBC ODBC SQL ODBC FileMaker Pro SQL ODBC FileMaker Pro ODBC Oracle Microsoft Access FileMaker Pro FileMaker Pro [ ] [ ] [SQL ] [ExecuteSQL] ODBC ODBC 1. ODBC 2. FileMaker Pro ODBC DSN 3. ODBC 4. FileMaker Pro 1 FileMaker Pro [] > [] > [ODBC...] 1 FileMaker Pro [ ] [...] [...] [ ]Windows [ ]OS X [ODBC...]

10 2 SQL [OK] FileMaker Pro SQL 6. FileMaker Pro SQL SQL [WHERE] [ORDER BY] SQL Query SQL [ ] [SQL ] [ExecuteSQL] FileMaker ODBC [SQL ] SQL FileMaker Pro Advanced SQL FileMaker FileMaker Pro FileMaker SQL FileMaker SQL ODBC SQL ODBC FileMaker Pro [SQL ] [ExecuteSQL] SQL [SQL ] INSERTUPDATE DELETE SQL [ExecuteSQL] SELECT FileMaker Pro SQL FileMaker Pro SQL Server SQL [SQL ] [ExecuteSQL] FileMaker FileMaker Pro FileMaker SQL FileMaker SQL

11 2 SQL 11 ODBC ODBC FileMaker SQL ODBC FileMaker Pro FileMaker Server SQL ODBC FileMaker Pro FileMaker Pro FileMaker Pro FileMaker Server SQL FileMaker Pro FileMaker 14 ODBC FileMaker ODBC SQL 1 Oracle 1 Microsoft SQL Server 1 MySQL Community Edition ODBC FileMaker ODBC ODBC FileMaker Pro 1. ODBC 2. FileMaker Pro ODBC DSN 3. ODBC 4. ODBC FileMaker Pro

12 2 SQL FileMaker Pro 6. ODBC ODBC ODBC ODBC ODBC FileMaker Pro

13 3 FileMaker ODBC ODBC FileMaker ODBC ODBC FileMaker xdbc URL : FileMaker Server FileMaker FileMaker SQL ODBC FileMaker Web FileMaker TCP/IP ODBC FileMaker Windows OS X ODBC ODBC 1 ODBC ODBC 64 64

14 3 FileMaker ODBC 14 ODBC Windows Windows Windows Windows ODBC : 1. 1.exe 1 2. FileMaker Pro FileMaker Server xdbc 3. xdbcodbc Client Driver Installer 4. ODBC Client Driver Installer 1 32 fmodbc32.dll32 [FMODBC_Installer_Win32.msi] 1 64 fmodbc64.dll64 [FMODBC_Installer_Win64.msi] FileMaker ODBC Driver 5. ODBC 6. [ ] ODBC 1 32 Windows 32 fmodbc32.dll C:WindowsSystem Windows 32 fmodbc32.dll C:WindowsSysWOW Windows 64 fmodbc64.dll C:WindowsSystem32 FileMaker ODBC [FileMaker ODBC]

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

16 3 FileMaker ODBC [ ] 1 FileMaker Pro localhost IP FileMaker Server FileMaker Server IP ODBC/JDBC [ ] [ ] [ ] 7. [ ] FileMaker FileMaker Server [ ] FileMaker Server 1 [...] [ ] [ ] [ ] [ ] [ ] [UTF-8] Microsoft Excel [ ] Web [UTF-8] 1 MS Word 255 PHP [ long varchar ] 255 Windows 255 OS X 1 [ ] [ ] 8. FileMaker DSN 1 [ ] FileMaker ODBC FileMaker FileMaker ODBC/JDBC FileMaker Server FileMaker Pro ODBC/JDBC 1 [ ]

17 3 FileMaker ODBC 17 ODBC OS X OS X / /ODBC FileMaker ODBC.bundleODBC ODBC : 1. 1.dmg 1 2. FileMaker Pro FileMaker Server xdbc 3. xdbcodbc Client Driver Installer 4. ODBC Client Driver Installer [FileMaker ODBC.pkg] FileMaker ODBC 5. ODBC 6. [ ] ODBC / /ODBC ODBC FileMaker ODBC [FileMaker ODBC] OS X ODBC FileMaker FileMaker Actual Technologies ODBC Manager ODBC ODBC FileMaker DSN ODBC FileMaker 2399

18 3 FileMaker ODBC 18 ODBC 1. ODBC Manager ODBC Manager 2. [ DSN] [ DSN] FileMaker DSN 3. [...] [ ] 4. [FileMaker ODBC] [OK] [FileMaker DSN ] 5. [ ] 6. [ ] FileMaker [ ] FileMaker [ ] 7. [ ] 1 FileMaker Pro localhost IP FileMaker Server FileMaker Server IP ODBC/JDBC [ ] [ ] [ ] 8. [ ] FileMaker FileMaker Server [ ] FileMaker Server 1 [...] [ ] [ ] [ ] 4 ODBC [ ODBC API ] SQL_C_CHAR SQL_C_WCHAR [ Unicode ] [ ] [ (MacJapanese)] [UTF-8] Microsoft Excel [ ] Web [UTF-8]

19 3 FileMaker ODBC 19 1 MS Word 255 PHP [ long varchar ] 1 [ ] [ ] [ ] 9. FileMaker DSN 1 [ ] FileMaker ODBC FileMaker FileMaker ODBC/JDBC FileMaker Server FileMaker Pro ODBC/JDBC 1 [ ] SQL FileMaker ODBC [ ] [SQL ] ODBC FileMaker 4 ODBC FileMaker

20 4 ODBC FileMaker ODBC FileMaker ODBC FileMaker FileMaker ODBC FileMaker ODBC FileMaker Pro 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 FileMaker 1 Microsoft Word 1 Microsoft Excel 1 FileMaker Microsoft SQL Server DBMS 1 FileMaker 1 FileMaker Pro Microsoft Visual Basic FileMaker FileMaker Pro [ODBC/JDBC ] FileMaker Server FileMaker Pro ODBC/JDBC FileMaker Pro FileMaker Server FileMaker ODBC FileMaker 14 FileMaker 14 ODBC FileMaker XDBC Listener OS X Windows FileMaker XDBC Listener fmxdbc_listener FileMaker XDBC Listener FileMaker Server FileMaker Server Admin Console XDBC Listener FileMaker Server ODBC/JDBC [ ] XDBC Listener ODBC/JDBC [ ] XDBC Listener

22 4 ODBC FileMaker 22 FileMaker ODBC SQL FileMaker SQL ODBC FileMaker 1. FileMaker Pro [ODBC/JDBC ] 2. FileMaker ServerFileMaker Server Admin Console FileMaker Pro ODBC/JDBC FileMaker Server Admin Console [ ] > [ODBC/JDBC] [ODBC/JDBC ] FileMaker Pro [ ] > [ ] > [ODBC/JDBC...] [ODBC/JDBC ] [ ] 3. FileMaker FileMaker FileMaker 4. FileMaker 5. SQL FileMaker FileMaker DSN FileMaker Windows FileMaker FileMaker DSN ODBC Windows FileMaker DSN DSN FileMaker ODBC FileMaker FileMaker DSN 15 Windows

23 4 ODBC FileMaker 23 ODBC Windows FileMaker ODBC 1. Windows [ ] > [ (ODBC)] [ ] [ ] [ODBC ] 2. [ DSN] [ DSN] 3. FileMaker [ ] [ ] [FileMaker ODBC] 4. [...] [FileMaker DSN ] 5. [ ] [ ] 6. [ ] FileMaker [ ] [ ] 1 FileMaker 1 1 FileMaker [ODBC/JDBC ] 1 FileMaker Server FileMaker Pro ODBC/JDBC OS X FileMaker FileMaker DSN ODBC OS X FileMaker DSN DSN FileMaker ODBC FileMaker FileMaker DSN 17 OS X

24 4 ODBC FileMaker 24 ODBC OS X FileMaker ODBC 1. ODBC Manager ODBC Manager 2. [ DSN] [ DSN] 3. FileMaker [ ] [ ] [FileMaker ODBC] 4. [...] [FileMaker DSN ] 5. [ ] [ ] 6. [ ] FileMaker [ ] [ ] 1 FileMaker 1 1 FileMaker [ODBC/JDBC ] 1 FileMaker Server FileMaker Pro ODBC/JDBC

25 5 FileMaker JDBC JDBC FileMaker FileMaker DVDxDBC URL : FileMaker Server FileMaker FileMaker SQL JDBC FileMaker JDBC FileMaker JDBC JDK 1.6 Java Windows OS Xjava -version FileMaker TCP/IP JDBC JDBC JDBC : 1. 1 Windows:.exe 1 OS X:.dmg 1 2. FileMaker Pro FileMaker Server xdbc 3. xdbcjdbc Client Driver

26 5 FileMaker JDBC fmjdbc.jar 1 Windows: fmjdbc.jar Java java.exe Java ClassPath 1 OS X: fmjdbc.jar/ /Java/Extensions Java ClassPath FileMaker JDBC JDBC JDBC Java JDBC JDBC URL FileMaker JDBC JDBC JDBC 6 JDBC FileMaker

27 6 JDBC FileMaker Java JDBC RADRapid 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 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 OS X Windows FileMaker XDBC Listener fmxdbc_listener FileMaker XDBC Listener FileMaker Server FileMaker Server Admin Console XDBC Listener FileMaker Server ODBC/JDBC [ ] XDBC Listener ODBC/JDBC [ ] XDBC Listener JDBC URL Java URLUniform Resource LocatorJDBC URL JDBC JDBC URL jdbc:< >:< > JDBC URL JDBC jdbc< > JDBC < > filemaker< > FileMaker IP

29 6 JDBC FileMaker 29 JDBC FileMaker JDBC 1. JDBC JDBC 2. FileMaker JDBC URL jdbc:filemaker:// /database 3. import java.sql.*; class FMPJDBCTest { public static void main(string[ ] args) { } // register the JDBC client driver try { Driver d = (Driver)Class.forName("com.filemaker.jdbc.Driver").newInstance(); } catch(exception e) { System.out.println(e); } // establish a connection to FileMaker Connection con; try { con = DriverManager.getConnection("jdbc:filemaker:// /mydatabase","username", "password"); } catch (Exception e) { System.out.println(e); } // get connection warnings SQLWarning warning = null; try { warning = con.getwarnings(); if (warning == null) { System.out.println("No warnings"); return; } while (warning!= null) { System.out.println("Warning:"+warning); warning = warning.getnextwarning(); } } catch (Exception e) { Sysem.out.println(e); } }

30 6 JDBC FileMaker 30 URL user password JDBC URL DriverManager.GetConnection 1 user: [ODBC/JDBC ] 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 FileMaker JDBC URL FileMaker

31 6 JDBC FileMaker 31 JDBC JDBC FileMaker 1 FileMaker 1 FileMaker [ODBC/JDBC ] 1 FileMaker Server FileMaker Pro ODBC/JDBC FileMaker FileMaker Pro [ODBC/JDBC ] FileMaker Server FileMaker Pro ODBC/JDBC FileMaker Pro FileMaker Server 1 JDBC JDBC URL Java

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

33 7 33 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 64 ODBC API Windows ODBC API

34 7 34 ODBC JDBC FileMaker ODBC/JDBC ODBC 1 ODBC 1 FileMaker FileMaker XDBC Listener FileMaker ODBC FileMaker Listener [FileMaker] [FileMaker ODBC] FileMaker [FileMaker] [FileMaker ODBC] Invalid Username/Password FileMaker JDBC FileMaker JDBC SQLException 1 JDBC 1 FileMaker FileMaker XDBC Listener FileMaker JDBC FileMaker Listener [FileMaker] [FileMaker JDBC] FileMaker [FileMaker] [FileMaker JDBC] Invalid Username/Password FileMaker

35 32 ODBC OS X 17 ODBC Windows Windows 14 OS X ODBC OS X 17 ODBC Windows Windows 14 OS X A ARRAY 28 B BLOB 33 C CAST 33 CLOB 28 D DatabaseMetaData 32 DATALINK 28 DATE 33 DOUBLE 33 DSN OS X 23 Windows 22 8 E ExecuteSQL 9, 10 F FileMaker ODBC OS X 17 Windows 14 FileMaker Server 5 FileMaker 7 FileMaker JDBC 30 ODBC OS X 23 ODBC Windows 22 FileMaker ODBC JDBC 5 G GetAs 33 getcolumnprivileges 32 getcolumns 32 getmetadata 32 gettables 32 gettabletypes 32 gettypeinfo 32 getversioncolumns 32 J Java JDK 28 Java 25 JDBC JDBC SPI 28 JDBC JDBC URL 28 JDBC JDBC URLUniform Resource Locator 28 JDBC 29 JDBC 28 JDBC 28 M Microsoft Access 8 MySQL 11 O ODBC ODBC Manager DSN 18 ODBC ODBC OS X 24 ODBC 32 ODBC OS X 24 Windows 23 32

36 36 ODBC DSN 15 ODBC ODBC 9 ODBC/JDBC 22 Oracle 11 OS X DSN 17 JDBC 25 ODBC 24 P PDF 5 R RAD (Rapid Application Development) 27 REF 28 S SQL Server 11 SQL 6, 10 [SQL ] 9, 10 SQL_DATE 32 SQL_DOUBLE 32 SQL_LONGVARBINARY 33 SQL_TIME 32 SQL_TIMESTAMP 32 SQL_VARCHAR 32 SQLColumnPrivileges 32 SQLColumns 32 SQLDescribeCol 32 SQLExceptions 34 SQLGetTypeInfo 32 SQLTables 32 T TCP/IP 8 TIME 33 TIMESTAMP 33 V VARCHAR 33 W Web FileMaker 5 Windows DSN 22 JDBC 25 ODBC 23 X XDBC Listener JDBC 28 ODBC JDBC 31 ODBC Windows 23 ODBC OS X 24 JDBC 31 ODBC Windows 23 ODBC OS X 24 13, 25 13, JDBC 33 ODBC 33 5 SQL ODBC/JDBC 22 FileMaker 7 FileMaker 5 33 JDBC 25 ODBC 13 28

37 JDBC 31 JDBC 30 ODBC Windows 23 ODBC OS X 24 ODBC OS X 23 ODBC Windows 22 FileMaker DSN 8 FileMaker 7 JDBC 33 ODBC JDBC 30 ODBC Windows 22 ODBC OS X JDBC 26 ODBC OS X 17 ODBCWindows [ ] 9, JDBC 30 ODBC 23, 24 JDBC 26 ODBC OS X 17 ODBC Windows JDBC 33 ODBC 32

FileMaker 15 ODBC と JDBC ガイド

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