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 Cloud FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgments URL FileMaker, Inc. http://www.filemaker.com/jp 01
1 5 5 FileMaker 5 ODBC JDBC 6 ODBC FileMaker 6 ODBC 6 ODBC 6 FileMaker 7 FileMaker Pro 7 8 8 8 2 SQL 9 ODBC 9 ODBC SQL 10 ODBC 11 FileMaker 16 11 ODBC 11 3 FileMaker ODBC 12 12 12 ODBC (Windows) 12 ODBC (Windows) 13 (Windows) 13 ODBC (Windows) 14 DSN (Windows) 14 ODBC (macos) 15 (macos) 16 18
4 4 ODBC FileMaker 19 ODBC 19 ODBC 20 FileMaker 21 Windows FileMaker 21 FileMaker DSN ODBC (Windows) 21 ODBC (Windows) 22 macos FileMaker 22 FileMaker DSN ODBC (macos) 22 ODBC (macos) 22 5 FileMaker JDBC 24 24 24 JDBC 24 JDBC 25 6 JDBC FileMaker 26 JDBC 26 JDBC 26 JDBC 26 JDBC URL 27 URL 29 FileMaker 29 JDBC 30 7 31 ODBC 31 JDBC DatabaseMetaData 31 FileMaker ODBC 31 FileMaker JDBC 32 64 32 ODBC JDBC 32 ODBC 32 JDBC 33 34
1 FileMaker ODBC (Open Database Connectivity) JDBC (Java Database Connectivity) FileMaker ODBC JDBC 1 ODBC FileMaker 1 SQL ODBC 1. 2. ODBC [ ] > [ ] [ ] [SQL ] [ExecuteSQL] 1 FileMaker Pro 1 FileMaker Pro Advanced 1 FileMaker Server 1. 2 2. FileMaker Pro 1 FileMaker 1 FileMaker Pro ODBC 1. ODBC JDBC 2. SQL 1 FileMaker Pro 1 FileMaker Pro Advanced 1 FileMaker Server 1. 3 6 2. FileMaker SQL 1 ODBC JDBC SQL FileMaker SQL FileMaker SQL SQL 1 FileMaker Pro Advanced FileMaker Pro FileMaker Pro FileMaker Pro Advanced FileMaker 1 FileMaker Pro [ ] > [ ] 1 FileMaker Server Admin Console [ ] > [FileMaker Server ] 1 FileMaker
1 6 ODBC JDBC ODBC JDBC APIODBC C API JDBC Java API API FileMaker Pro 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 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 7 1 FileMaker ODBC FileMaker Pro ODBC SQL FileMaker Pro OracleSQL Server MySQL FileMaker Pro ODBC 2 SQL FileMaker ODBC 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 5 FileMaker FileMaker FileMaker ODBC ODBC ODBC JDBC FileMaker Pro FileMaker Server ODBC JDBC FileMaker Pro FileMaker Server ODBC JDBC SQL FileMaker SQL ODBC/JDBC FileMaker Server FileMaker Pro ODBC JDBC FileMaker FileMaker
1 8 Microsoft Access: Microsoft Access FileMaker Microsoft Access Microsoft Access FileMaker Server FileMaker TCP/IP FileMaker Pro FileMaker Pro FileMaker Server 16 FileMaker 16 FileMaker Pro FileMaker Server 3 FileMaker ODBC 5 FileMaker JDBC 1 FileMaker (DSN) 1 DSN FileMaker 1 DSN 1 FileMaker Pro ODBC JDBC
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) [ ] (macos) [ODBC...]
2 SQL 10 5. [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
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 16 FileMaker ODBC ODBC OracleMicrosoft SQL Server MySQL Community Edition SQL SQL FileMaker ODBC ODBC FileMaker Pro 1. ODBC 2. FileMaker Pro ODBC DSN 3. ODBC 4. ODBC FileMaker Pro 1 5. FileMaker Pro 6. ODBC ODBC ODBC ODBC ODBC FileMaker Pro
3 FileMaker ODBC ODBC FileMaker ODBC ODBC FileMaker ODBC ODBC FileMaker xdbc FileMaker FileMaker Server FileMaker FileMaker SQL ODBC FileMaker Server FileMaker TCP/IP ODBC (Windows) FileMaker Windows 32 64 32 64 ODBC ODBC 1 ODBC 32 32 1 ODBC 64 64
3 FileMaker ODBC 13 ODBC (Windows) Windows 32 64 32 Windows 32 64 Windows 32 64 ODBC : 1. 1.exe 1 2. FileMaker Pro 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 System32 1 64 Windows 32 (fmodbc32.dll) C: Windows SysWOW64 1 64 Windows 64 (fmodbc64.dll) C: Windows System32 FileMaker ODBC [FileMaker ODBC] (Windows) ODBC FileMaker FileMaker 2399
3 FileMaker ODBC 14 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 [ ] 6. [ ] 1 FileMaker Pro localhost IP 127.0.0.1 1 FileMaker Server FileMaker Server IP ODBC/JDBC [ ] [ ] [ ] 7. [ ] FileMaker FileMaker Server [ ] FileMaker Server FMServer_Sample ODBC ODBC
3 FileMaker ODBC 15 1 [...] [ ] [ ] [ ] [ ] [UTF-8] Microsoft Excel [ ] Web [UTF-8] FileMaker 3 UTF-8 1 Microsoft Word 255 PHP [ long varchar ] 255 (Windows) 255 (macos) 1 [ ] [ ] 8. FileMaker DSN 1 [ ] FileMaker ODBC SSL SSL SSL xdbc Listener CStore SSL FileMaker Server FileMaker FileMaker ODBC/JDBC fmxdbc FileMaker Server FileMaker Pro ODBC/JDBC 1 [ ] ODBC (macos) /Library/ODBC ODBC : 1. 1.dmg 1 2. FileMaker Pro FileMaker Server ExtrasxDBC
3 FileMaker ODBC 16 3. xdbcodbc Client Driver Installer 4. ODBC Client Driver InstallerFileMaker ODBC.pkg 5. ODBC 6. [ ] ODBC / /ODBC ODBC FileMaker ODBC [FileMaker ODBC] (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 localhost IP 127.0.0.1 1 FileMaker Server FileMaker Server IP ODBC/JDBC [ ] [ ] [ ]
3 FileMaker ODBC 17 8. [ ] 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 SSL SSL SSL xdbc Listener CStore SSL FileMaker Server FileMaker FileMaker ODBC/JDBC fmxdbc FileMaker Server FileMaker Pro ODBC/JDBC 1 [ ]
3 FileMaker ODBC 18 SQL FileMaker ODBC [ ] [SQL ] 4 ODBC FileMaker
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 /
4 ODBC FileMaker 20 Oracle ODBC SQL Server ODBC FileMaker ODBC Oracle Microsoft SQL Server FileMaker ODBC ODBC ODBC 3.0 1 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 fmxdbc FileMaker Server FileMaker Pro ODBC/JDBC FileMaker Pro FileMaker Server FileMaker ODBC FileMaker 16 FileMaker 16 ODBC
4 ODBC FileMaker 21 FileMaker XDBC Listener macos 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 FileMaker ODBC SQL FileMaker SQL ODBC FileMaker 1. FileMaker Pro ODBC/JDBC fmxdbc 2. FileMaker Server (FileMaker 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 1 FileMaker Windows FileMaker FileMaker DSN ODBC (Windows) FileMaker DSN DSN FileMaker ODBC FileMaker FileMaker DSN 13 (Windows)
4 ODBC FileMaker 22 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 ODBC/JDBC macos FileMaker FileMaker DSN ODBC (macos) FileMaker DSN DSN FileMaker ODBC FileMaker FileMaker DSN 16 (macos) ODBC (macos) FileMaker ODBC 1. ODBC Manager ODBC Manager 2. [ DSN] [ DSN] 3. FileMaker [ ] DSN [ ] [FileMaker ODBC]
4 ODBC FileMaker 23 4. [...] 5. [ ] [ ] 6. [ ] FileMaker [ ID] [ ] 1 FileMaker 1 1 FileMaker ODBC/JDBC fmxdbc 1 FileMaker Server FileMaker Pro ODBC/JDBC
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 JDBC JDBC JDBC : 1. 1 Windows:.exe 1 macos:.dmg 1 2. FileMaker Pro FileMaker Server Extras 3. xdbc
5 FileMaker JDBC 25 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 2399 2399 JDBC 6 JDBC FileMaker
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 JDBC JDBC JDBC 3.0 FileMaker 1 SAVEPOINT 1
6 JDBC FileMaker 27 1 1 1 Ref 1 CLOBARRAY REF 1 1 DATALINK 1 1 JDBC SPI JDBC Java Development Kit (JDK) 1.61.7 1.8 4 FileMaker JDBC Java JDBC Java com.filemaker.jdbc.driver FileMaker FileMaker JDBC JDBC FileMaker FileMaker XDBC Listener macos 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 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://192.168.1.1/database 3.
6 JDBC FileMaker 28 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://192.168.1.1/mydatabase,, ); } 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); } }
6 JDBC FileMaker 29 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://192.168.1.1/publications URL JDBC URL : jdbc:filemaker://<filemaker IP >/< >?user=< >&password= < > jdbc:filemaker://192.168.1.1/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 1 JDBC URL FileMaker
6 JDBC FileMaker 30 JDBC FMServer_Sample JDBC JDBC JDBC FileMaker 1 FileMaker 1 FileMaker ODBC/JDBC fmxdbc 1 FileMaker Server FileMaker Pro ODBC/JDBC FileMaker FileMaker Pro ODBC/JDBC fmxdbc FileMaker Server FileMaker Pro ODBC/JDBC FileMaker Pro FileMaker Server 1 JDBC JDBC URL Java
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 gettabletypes 1 getmetadata 1 getversioncolumns 1 gettypeinfo FileMaker ODBC FileMaker Pro ODBC FileMaker ODBC SQL_VARCHAR FileMaker [ ] 100 FileMaker NULL SQL_DOUBLE FileMaker 10-308 10 +308 15 SQL_DATE SQL_TIME FileMaker 24 0 SQL_TIMESTAMP (BLOB) SQL_LONGVARBINARY SELECT CAST() GetAs() ODBC
7 32 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 32 64 Windows ODBC API 64 32 64 32 64 ODBC JDBC FileMaker ODBC/JDBC ODBC 1 ODBC 1 FileMaker FileMaker XDBC Listener
7 33 FileMaker ODBC FileMaker Listener DSN [FileMaker] [FileMaker ODBC] [FileMaker] [FileMaker ODBC] Invalid Username/Password FileMaker JDBC FileMaker JDBC SQLException 1 JDBC 1 FileMaker FileMaker XDBC Listener FileMaker JDBC FileMaker Listener DSN [FileMaker] [FileMaker JDBC] [FileMaker] [FileMaker JDBC] Invalid Username/Password FileMaker
32 ODBC (Windows) 14 12 (Windows) 13 64 ODBC (Windows) 14 12 (Windows) 13 32 A ARRAY 27 B BLOB 32 C CAST 31 CLOB 27 D DatabaseMetaData 31 DATALINK 27 DATE 32 DOUBLE 32 DSN (macos) 22 (Windows) 21 1 8 E ExecuteSQL 9, 10 F FileMaker ODBC macos 16 Windows 13 FileMaker Server 5 FileMaker 7 FileMaker JDBC 29 ODBC (macos) 22 ODBC (Windows) 21 FileMaker ODBC JDBC 5 fmxdbc 20, 29 G GetAs 31 getcolumnprivileges 31 getcolumns 31 getmetadata 31 gettables 31 gettabletypes 31 gettypeinfo 31 getversioncolumns 31 J Java (JDK) 27 Java 24 JDBC SPI 27 JDBC 33 JDBC JDBC URL 27 JDBC 26 JDBC JDBC 27 30 32 27 JDBC URL (Uniform Resource Locator) 27 JDBC 27 JDBC 26 JDBC 27 JDBC 27 M macos DSN 16 JDBC 24 ODBC 22 Microsoft Access 8 MySQL 11 N NULL 31 O ODBC Manager DSN 16 ODBC 22 16 ODBC (macos) 22
35 ODBC 32 ODBC 31 ODBC (macos) 22 (Windows) 22 31 ODBC 32 19 ODBC DSN 14 ODBC 22 14 ODBC 9 ODBC/JDBC 21 Oracle 11 P PDF 5 R Rapid Application Development (RAD) 26 REF 27 S SAVEPOINT 26 SQL Server 11 SQL 6, 10 9, 10 9, 10 SQL_DATE 31 SQL_DOUBLE 31 SQL_LONGVARBINARY 31 SQL_TIME 31 SQL_TIMESTAMP 31 SQL_VARCHAR 31 SQLColumnPrivileges 31 SQLColumns 31 SQLDescribeCol 31 SQLExceptions 33 SQLGetTypeInfo 31 SQLTables 31 SSL 15, 17 T TCP/IP 8 TIME 32 TIMESTAMP 32 V VARCHAR 32 W Web FileMaker 5 Windows DSN 21 JDBC 24 ODBC 22 X XDBC Listener JDBC 27 ODBC 21 32 21 21 21 ODBC (macos) 22 ODBC (Windows) 22 JDBC 30 JDBC 30 ODBC (macos) 22 ODBC (Windows) 22 12, 24 32 JDBC 32 ODBC 31 5 SQL 9 11 21 31 ODBC/JDBC 21 FileMaker 7 FileMaker 5 32
36 JDBC 24 ODBC 12 26 7 JDBC 30 JDBC 29 ODBC (macos) 22 ODBC (Windows) 22 ODBC (macos) 22 ODBC (Windows) 21 FileMaker 1 DSN 8 FileMaker 7 JDBC 32 ODBC 31 8 JDBC 29 ODBC (macos) 22 ODBC (Windows) 21 2399 JDBC 25 ODBC (macos) 16 ODBC (Windows) 13 5 31 10 7 6 9, 10 9, 10 21 27 8 JDBC 29 ODBC 22, 23 JDBC 25 ODBC (macos) 16 ODBC (Windows) 13 21 1 7 JDBC 32 ODBC 31