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, 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 5 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 15 11 ODBC 11 3 FileMaker ODBC 12 12 12 ODBC (Windows) 12 ODBC (Windows) 13 (Windows) 13 ODBC (Windows) 14 DSN (Windows) 14 ODBC (OS X) 15 (OS X) 16 17
4 4 ODBC FileMaker 18 ODBC 18 ODBC 19 FileMaker 20 Windows FileMaker 20 FileMaker DSN ODBC (Windows) 20 ODBC (Windows) 20 OS X FileMaker 21 FileMaker DSN ODBC (OS X) 21 ODBC (OS X) 21 5 FileMaker JDBC 23 23 23 JDBC 23 JDBC 24 6 JDBC FileMaker 25 JDBC 25 JDBC 25 JDBC 25 JDBC URL 26 URL 28 FileMaker 28 JDBC 29 7 30 ODBC 30 JDBC DatabaseMetaData 30 FileMaker ODBC 30 FileMaker JDBC 31 64 31 ODBC JDBC 32 ODBC 32 JDBC 32 33
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 ProFileMaker Pro FileMaker Pro Advanced FileMaker 1 FileMaker Pro [ ] > [ ] 1 FileMaker Server Admin Console [ ] > [FileMaker Server ] 1 FileMaker http://www.filemaker.co.jp/documentation/ja ODBC JDBC ODBC JDBC APIODBC C API JDBC Java API API FileMaker Pro FileMaker Server ODBC JDBC SQL SQL
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
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 5 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
1 8 Microsoft Access:Microsoft Access FileMaker Microsoft Access Microsoft Access FileMaker Server FileMaker TCP/IP FileMaker Pro FileMaker Pro FileMaker Server 15 FileMaker 15 FileMaker Pro FileMaker Server 3 FileMaker ODBC 5 FileMaker JDBC 1 FileMaker (DSN) 1 DSN FileMaker 1 DSN 1 FileMaker Pro ODBC JDBC http://www.filemaker.com/documentation/ja
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...]
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 15 FileMaker ODBC ODBC OracleMicrosoft SQL Server MySQL Community Edition SQL SQL http://filemaker-jp.custhelp.com 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 ODBC FileMaker xdbc URL : http://www.filemaker.com/jp/support/downloads 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 ] 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 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 [ ] ODBC (OS X) /Library/ODBC ODBC : 1. 1.dmg 1 2. FileMaker Pro FileMaker Server xdbc 3. xdbcodbc Client Driver Installer 4. ODBC Client Driver Installer [FileMaker ODBC.pkg] 5. ODBC
3 FileMaker ODBC 16 6. [ ] ODBC / /ODBC ODBC FileMaker ODBC [FileMaker ODBC] (OS X) ODBC FileMaker FileMaker http://www.odbcmanager.net 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 [ ] [ ] [ ] 8. [ ] FileMaker FileMaker Server [ ] FileMaker Server FMServer_Sample ODBC ODBC
3 FileMaker ODBC 17 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 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
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 19 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 ] FileMaker Server FileMaker Pro ODBC/JDBC FileMaker Pro FileMaker Server FileMaker ODBC FileMaker 15 FileMaker 15 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
4 ODBC FileMaker 20 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 1 FileMaker Windows FileMaker FileMaker DSN ODBC (Windows) FileMaker DSN DSN FileMaker ODBC FileMaker FileMaker DSN 13 (Windows) ODBC (Windows) FileMaker ODBC 1. [ODBC ] 13 ODBC (Windows) 2. [ DSN] [ DSN]
4 ODBC FileMaker 21 3. FileMaker [ ] [ ] [FileMaker ODBC] 4. [...] 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 16 (OS X) ODBC (OS X) FileMaker ODBC 1. ODBC Manager ODBC Manager 2. [ DSN] [ DSN] 3. FileMaker [ ] [ ] [FileMaker ODBC] 4. [...] 5. [ ] [ ] 6. [ ] FileMaker [ ] [ ]
4 ODBC FileMaker 22 1 FileMaker 1 1 FileMaker [ODBC/JDBC ] 1 FileMaker Server FileMaker Pro ODBC/JDBC
5 FileMaker JDBC JDBC FileMaker JDBC JDBC FileMaker URL : http://www.filemaker.com/jp/support/downloads FileMaker Server FileMaker FileMaker SQL JDBC FileMaker JDBC FileMaker JDBC JDK 1.6 Java (Windows) (OS X) java -version FileMaker TCP/IP JDBC JDBC JDBC : 1. 1 Windows:.exe 1 OS X:.dmg 1 2. FileMaker Pro FileMaker Server Extras 3. xdbc
5 FileMaker JDBC 24 4. xdbcjdbc Client Driver 5. 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 2399 2399 JDBC 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 1
6 JDBC FileMaker 26 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 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 URL (Uniform Resource Locator) 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
6 JDBC FileMaker 27 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://192.168.1.1/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); } }
6 JDBC FileMaker 28 URL user password JDBC URL DriverManager.GetConnection 1 user: [ODBC/JDBC ] 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 29 JDBC FMServer_Sample JDBC 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
7 ODBC ODBC 1 SQLTables - 1 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 10-308 10 +308 15 SQL_DATE SQL_TIME FileMaker 24 0 SQL_TIMESTAMP
7 31 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 32 64 Windows ODBC API 64 32 64 32 64
7 32 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
32 ODBC (Windows) 14 12 (Windows) 13 64 ODBC (Windows) 14 12 (Windows) 13 31 A ARRAY 26 B BLOB 31 C CAST 31 CLOB 26 D DatabaseMetaData 30 DATALINK 26 DATE 31 DOUBLE 31 DSN (OS X) 21 (Windows) 20 1 8 E ExecuteSQL 9, 10 F FileMaker ODBC OS X 16 Windows 13 FileMaker Server 5 FileMaker 7 FileMaker JDBC 28 ODBC (OS X) 21 ODBC (Windows) 20 FileMaker ODBC JDBC 5 G GetAs 31 getcolumnprivileges 30 getcolumns 30 getmetadata 30 gettables 30 gettabletypes 30 gettypeinfo 30 getversioncolumns 30 J Java (JDK) 26 Java 23 JDBC 32 25 25 JDBC SPI 26 JDBC JDBC URL 26 JDBC 26 29 31 26 JDBC URL (Uniform Resource Locator) 26 JDBC 26 JDBC 26 JDBC 26 M Microsoft Access 8 MySQL 11 O ODBC 32 31 18 ODBC Manager DSN 16 ODBC 21 16 ODBC (OS X) 21 ODBC 30 ODBC (OS X) 21 (Windows) 20 30
34 ODBC DSN 14 ODBC 20 14 ODBC 9 ODBC/JDBC 20 Oracle 11 OS X JDBC 23 P PDF 5 R Rapid Application Development (RAD) 25 REF 26 S SQL Server 11 SQL 6, 10 [SQL ] 9, 10 SQL_DATE 30 SQL_DOUBLE 30 SQL_LONGVARBINARY 31 SQL_TIME 30 SQL_TIMESTAMP 30 SQL_VARCHAR 30 SQLColumnPrivileges 30 SQLColumns 30 SQLDescribeCol 30 SQLExceptions 32 SQLGetTypeInfo 30 SQLTables 30 T TCP/IP 8 TIME 31 TIMESTAMP 31 V VARCHAR 31 W Web FileMaker 5 Windows JDBC 23 X XDBC Listener JDBC 26 ODBC 19 32 20 20 JDBC 29 ODBC (OS X) 21 ODBC (Windows) 20 JDBC 29 ODBC (OS X) 21 ODBC (Windows) 20 12, 23 32 JDBC 31 ODBC 31 5 SQL 9 11 20 30 ODBC/JDBC 20 FileMaker 7 FileMaker 5 31 JDBC 23 ODBC 12 25 6 25
35 JDBC 29 JDBC 28 ODBC (OS X) 21 ODBC (Windows) 20 ODBC (OS X) 21 ODBC (Windows) 20 FileMaker 1 DSN 8 FileMaker 7 JDBC 31 ODBC 30 JDBC 28 ODBC (OS X) 21 ODBC (Windows) 20 30 30 20 10 7 6 [ ] 9, 10 20 26 8 JDBC 28 ODBC 21 JDBC 24 ODBC (OS X) 16 ODBC (Windows) 13 20 1 7 JDBC 31 ODBC 30 2399 JDBC 24 ODBC (OS X) 16 ODBC (Windows) 13 5