FileMaker ODBC JDBC
2004-2019 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMakerFileMaker CloudFileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgments Documentation Acknowledgments URL FileMaker, Inc. www.filemaker.com/jp 01
1 5 5 FileMaker 5 ODBC JDBC 6 ODBC FileMaker 6 ODBC 6 ODBC 7 FileMaker 7 FileMaker Pro Advanced 7 8 8 8 2 SQL 9 ODBC 9 SQL ODBC 10 ODBC 11 11 ODBC 11 3 FileMaker ODBC 12 12 12 FileMaker Cloud ODBC 12 ODBC (Windows) 12 ODBC (Windows) 13 (Windows) 14 ODBC (Windows) 14 DSN (Windows) 14 ODBC (macos) 16 (macos) 17 19 4 ODBC FileMaker 20 ODBC 20 ODBC 21 FileMaker 22
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 25 25 25 FileMaker Cloud JDBC 25 JDBC 25 JDBC 26 6 JDBC FileMaker 27 JDBC 27 JDBC 27 JDBC 28 JDBC URL 29 URL 31 31 FileMaker 32 JDBC 32 7 33 ODBC 33 JDBC DatabaseMetaData 33 FileMaker ODBC 33 FileMaker JDBC 34 64 35 ODBC JDBC 35 ODBC 35 JDBC 35 37
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 Advanced 1 FileMaker Server 1 FileMaker Cloud 1 2 1 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 1 3 6 1 FileMaker SQL 1 FileMaker Cloud ODBC JDBC SQL FileMaker SQL FileMaker SQL SQL FileMaker FileMaker
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
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
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
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 ( )
2 SQL 10 4. 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
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
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 32 64 32 64 ODBC
3 FileMaker ODBC 13 ODBC 1 ODBC 32 32 1 ODBC 64 64 ODBC (Windows) Windows 32 64 32 Windows 32 64 Windows 32 64 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 System32 1 64 Windows 32 (fmodbc32.dll) C: Windows SysWOW64 1 64 Windows 64 (fmodbc64.dll) C: Windows System32 FileMaker ODBC [FileMaker ODBC]
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 []
3 FileMaker ODBC 15 6. [] 1 FileMaker Pro Advanced localhost IP 127.0.0.1 1 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)
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]
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 127.0.0.1 1 FileMaker Server SSL ODBC/JDBC [ ] FileMaker XDBC Listener CStore SSL SSL 1 ODBC [] 1 ODBC [] 1 [] [] []
3 FileMaker ODBC 18 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 FileMaker FileMaker ODBC/JDBC fmxdbc FileMaker ServerFileMaker Pro Advanced FileMaker Cloud ODBC/JDBC 1 []
3 FileMaker ODBC 19 SQL FileMaker ODBC [] [SQL ] 4 ODBC FileMaker
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 () () /
4 ODBC FileMaker 21 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 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
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)
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)
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
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
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 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
6 JDBC FileMaker 28 JDBC JDBC JDBC 3.0 FileMaker 1 SAVEPOINT 1 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 XDBC Listener fmxdbc_listener XDBC Listener FileMaker Server FileMaker Server Admin Console XDBC Listener FileMaker Server
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://192.168.1.1/database 3.
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://192.168.1.1/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); } } }
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://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 JDBC JDBC SocketTimeout
6 JDBC FileMaker 32 Connection conn = DriverManager.getConnection ( "jdbc:filemaker://192.168.1.1/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 )
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 10-308 10 +308 15 SQL_DATE SQL_TIME FileMaker 24 0 SQL_TIMESTAMP
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
7 35 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 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
7 36 FileMaker JDBC FileMaker XDBC Listener DSN [FileMaker] [FileMaker JDBC] [FileMaker] [FileMaker JDBC] Invalid Account/Password FileMaker
32 ODBC (Windows) 14 64 ODBC (Windows) 14 32 13 64 13 32 (Windows) 13 64 (Windows) 13 35 A ARRAY 28 B BLOB 34 C CAST 34 CLOB 28 D DatabaseMetaData 33 DATALINK 28 DATE 34 DOUBLE 34 DSN (macos) 23 (Windows) 22 1 8 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 29 32 34 28 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 N NULL 33 O ODBC Manager DSN 17 ODBC 24 17 ODBC (macos) 24 ODBC 35 ODBC 33 ODBC (macos) 24 (Windows) 23 33 ODBC 34 20 ODBC DSN 14 ODBC 23 14 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 22 35 22 22 22 ODBC (macos) 24 ODBC (Windows) 23 JDBC 32 JDBC 32 ODBC (macos) 24 ODBC (Windows) 23 12, 25 35 JDBC 34 ODBC 34 5
39 SQL 9 11 22 33 ODBC/JDBC 22 FileMaker 8 FileMaker 5 34 JDBC 25 ODBC 12 28 7 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) 14 22 1 7 JDBC 34 ODBC 33 2399 JDBC 26 ODBC (macos) 17 ODBC (Windows) 14 5 33 7 7 9, 10 22 28 8