FileMaker ODBC JDBC
2004-2019 FileMaker, Inc.. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker, FileMaker Cloud, FileMaker Go FileMaker, Inc.. FileMaker WebDirect FileMaker, Inc... FileMaker. FileMaker. FilmMaker.,, URL,, URL... URL. FileMaker, Inc.. www.filemaker.com/kr. : 01
1 소개 5 5 FileMaker 5 ODBC JDBC 6 ODBC FileMaker 6 ODBC 6 ODBC 6 FileMaker 7 FileMaker Pro Advanced 7 8 8 8 2 외부 SQL 데이터원본접근하기 9 ODBC 9 ODBC SQL 10 ODBC 11 11 ODBC 11 3 FileMaker ODBC 클라이언트드라이버설치하기 12 12 12 FileMaker Cloud ODBC 12 ODBC (Windows) 12 ODBC (Windows) 13 (Windows) 13 ODBC (Windows) 13 DSN (Windows) 14 ODBC (macos) 15 (macos) 16 18 4 ODBC 를사용하여 FileMaker 데이터공유하기 19 ODBC 19 ODBC 20 FileMaker 20
4 Windows FileMaker 21 FileMaker DSN ODBC (Windows) 21 ODBC (Windows) 21 macos FileMaker 22 FileMaker DSN ODBC (macos) 22 ODBC (macos) 22 5 FileMaker JDBC 클라이언트드라이버설치하기 23 23 23 FileMaker Cloud JDBC 23 JDBC 23 JDBC 24 6 JDBC 를사용하여 FileMaker 데이터공유하기 25 JDBC 25 JDBC 25 JDBC 25 JDBC URL 26 URL 28 28 FileMaker 29 JDBC 29 7 참조정보 30 ODBC 30 JDBC DatabaseMetaData 30 FileMaker ODBC 30 FileMaker JDBC 31 64 31 ODBC JDBC 31 ODBC 31 JDBC 32 33
1 FileMaker ODBC ODBC(Open Database Connectivity) JDBC(Java Database Connectivity). FileMaker ODBC JDBC.. 1 ODBC FileMaker 1 SQL ODBC 1. 2. ODBC >.,, SQL SQL 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(Application Programming Interfaces). ODBC C API JDBC Java API. API FileMaker Pro Advanced FileMaker Server. ODBC JDBC SQL( ). SQL (, ) FileMaker,. 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 참조. ODBC ODBC, FileMaker SQL.. 1 ODBC. 1 ODBC ODBC. 1,. 1 FileMaker ODBC (" ").
1 7 FileMaker Pro Advanced ODBC SQL, FileMaker Pro Advanced Oracle, SQL Server MySQL.. FileMaker Pro Advanced ODBC 2, " SQL," ODBC FileMaker. FileMaker, FileMaker ODBC- JDBC-. FileMaker FileMaker, ODBC JDBC SQL FileMaker. FileMaker Pro Advanced FileMaker Cloud, FileMaker Server FileMaker Pro Advanced, ODBC JDBC FileMaker. FileMaker. FileMaker FileMaker Cloud FileMaker Server FileMaker Pro Advanced ODBC JDBC. ( ) ( ). 5 ( ). FileMaker FileMaker,. FileMaker, ODBC JDBC.. FileMaker Pro Advanced FileMaker Server ODBC JDBC ODBC JDBC. FileMaker Pro Advanced FileMaker Server ODBC JDBC SQL FileMaker SQL 참조. ODBC/JDBC, FileMaker Cloud, FileMaker Server FileMaker Pro Advanced. ODBC JDBC.. FileMaker,.
1 8 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(Data Source Name). FileMaker DSN, ( 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 FileMaker Pro Advanced ODBC ( : Oracle Microsoft Access ).,.,., FileMaker Pro Advanced., SQL ODBC. ODBC. 1. ODBC. 2. ODBC ODBC DSN. 3. ODBC (, ). 4. FileMaker Pro Advanced. 1 FileMaker Pro Advanced > > ODBC.
2 SQL 10 1 FileMaker Pro Advanced >. (Windows) (macos) ODBC. 5. ( ) FileMaker Pro Advanced SQL. 6. FileMaker Pro Advanced SQL Query. WHERE ORDER BY. SQL SQL., SQL FileMaker. ODBC, SQL SQL FileMaker Pro Advanced., SQL FileMaker FileMaker Pro Advanced. FileMaker SQL FileMaker SQL 참조. ODBC SQL ODBC FileMaker Pro Advanced SQL ExecuteSQL SQL. SQL INSERT, UPDATE DELETE SQL. ExecuteSQL SELECT. FileMaker Pro Advanced SQL. FileMaker Pro Advanced SQL Server SQL. SQL ExecuteSQL FileMaker FileMaker Pro Advanced. FileMaker SQL FileMaker SQL 참조.
2 SQL 11 ODBC ODBC, FileMaker SQL. FileMaker Pro Advanced FileMaker Server ODBC, SQL ODBC. FileMaker Pro Advanced FileMaker Pro Advanced FileMaker Pro Advanced, Server, Cloud SQL FileMaker Pro Advanced FileMaker ODBC, Oracle, Microsoft SQL Server MySQL Community Edition SQL ODBC. SQL FileMaker. ODBC ODBC FileMaker Pro Advanced. 1. ODBC. 2. FileMaker Pro Advanced ODBC DSN. 3. ODBC (, ). 4. FileMaker Pro Advanced ODBC. 5. FileMaker Pro Advanced. 6., ODBC. ODBC, ODBC, ODBC ODBC FileMaker Pro Advanced.
3 FileMaker ODBC FileMaker ODBC, ODBC. ODBC FilleMaker 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. 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 Advanced FileMaker Server Extras. 3. xdbc. 4. xdbc, ODBC 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. ODBC, FileMaker ODBC FileMaker. (Windows) ODBBC FileMaker,.,. FileMaker 2399. ODBC (Windows) ODBC.
3 FileMaker ODBC 14 32 ODBC 32 Windows : Windows > (ODBC). 32 ODBC 64 Windows : Windows > ODBC (32). 64 ODBC 64 Windows : Windows > ODBC (64). DSN (Windows) ODBC : 1. ODBC DSN DSN. FileMaker DSN. 2.. 3. FileMaker ODBC. 4.. 5. FileMaker. FileMaker ().. 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...
3 FileMaker ODBC 15 7., FileMaker. FileMaker Server,. FileMaker Server. FMServer_Sample ODBC. ODBC. 1,..., System UTF-8., Microsoft Excel System UTF-8.,. FileMaker 3 UTF-8. 1 long varchar Microsoft Word Mail Merge 255 PHP. 255, (Windows) 255 (macos). 1,.. 8. FileMaker DSN. 1 FileMaker ODBC.,. FileMaker, FileMaker ODBC/JDBC FileMaker Server FileMaker Pro Advanced FileMaker Cloud ODBC/JDBC. 1. ODBC (macos) /Library/ODBC. ODBC : 1.. 1 (.dmg ). 1,.
3 FileMaker ODBC 16 2. FileMaker Pro Advanced FileMaker Server Extras. 3. xdbc. 4. xdbc, ODBC Client Driver Installer. 5. ODBC Client Driver Installer, FileMaker ODBC.pkg. 6. ODBC. 7.. ODBC. /Library/ODBC ODBC. ODBC, FileMaker ODBC FileMaker. (macos) ODBBC FileMaker,.,. FileMaker Actual Technologies ODBC Manager. FileMaker 2399. ODBC : 1. ODBC Manager. (ODBC Manager.) 2. DSN DSN. FileMaker DSN. 3.. 4. FileMaker ODBC. 5.. 6. FileMaker. FileMaker ().. 7. : 1 FileMaker Pro Advanced, localhost IP 127.0.0.1. 1 FileMaker Server, SSL. ODBC/JDBC,.
3 FileMaker ODBC 17 FileMaker XDBC Listener CStore SSL ( ). SSL. 1 ODBC. 1 ODBC. 1... 8., FileMaker. FileMaker Server,. FileMaker Server. FMServer_Sample ODBC. ODBC. 1,... ODBC 4, " " ODBC API. SQL_C_CHAR SQL_C_WCHAR,., System(MacRoman) UTF-8., Microsoft Excel System UTF-8.,. FileMaker 3 UTF-8. 1 long varchar Microsoft Word Mail Merge 255 PHP. 1,... 9. FileMaker DSN. 1 FileMaker ODBC.
3 FileMaker ODBC 18,. FileMaker, FileMaker ODBC/JDBC FileMaker Server FileMaker Server, FileMaker Pro Advanced FileMaker Cloud ODBC/JDBC. 1., FileMaker SQL. ODBC. SQL.. 4, "ODBC FileMaker.".
4 ODBC FileMaker ODBC ODBC FileMaker. ODBC FileMaker. FileMaker ODBC FileMaker ODBC. FileMaker Pro Advanced ODBC SQL ODBC. ODBC SQL 2, " SQL,". ODBC API. ODBC. ODBC SQL( ). SQL (, ) FileMaker,. ODBC, SQL FileMaker SQL 참조. ODBC FileMaker. SQL FileMaker. FileMaker Server FileMaker, ( ). 클라이언트 / 서버구성. Oracle ODBC SQL Server ODBC FileMaker ODBC Oracle Microsoft SQL Server FileMaker
4 ODBC FileMaker 20 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. FileMaker XDBC Listener, OS X Windows XDBC Listener. fmxdbc_listener. FileMaker ODBC, FileMaker SQL. ODBC SQL. FileMaker. 1. FileMaker Pro Advanced. ODBC/JDBC fmxdbc. 2. FileMaker Server, FileMaker Pro Advanced FileMaker Cloud ODBC/JDBC. FileMaker Pro Advanced, FileMaker Server FileMaker Cloud 시작가이드. 3. FileMaker. FileMaker FileMaker,. 4. FileMaker.
4 ODBC FileMaker 21 5. SQL. FileMaker ( FileMaker DSN ).. 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 ( ). 3. FileMaker. DSN FileMaker ODBC. 4.. 5.. 6.. FileMaker ( ) ( ).. : 1 FileMaker. 1. 1 FileMaker ODBC/JDBC fmxdbc. 1 FileMaker Server FileMaker Pro Advanced ODBC/JDBC.
4 ODBC FileMaker 22 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.. 5.. 6.. FileMaker ( ) ( ).. : 1 FileMaker. 1. 1 FileMaker ODBC/JDBC fmxdbc. 1 FileMaker Server FileMaker Pro Advanced ODBC/JDBC.
5 FileMaker JDBC FileMaker JDBC, JDBC. JDBC FilleMaker JDBC.. 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. JDBC : 1.. 1 Windows: (.exe ). 1 macos: (.dmg ). 1,. 2. FileMaker Pro Advanced FileMaker Server Extras.
5 FileMaker JDBC 24 3. xdbc. 4. xdbc, JDBC Client Driver Installer. 5. fmjdbc.jar. 1 Windows: fmjdbc.jar Java (java.exe) Java ClassPath. 1 macos: fmjdbc.jar Java /Library/Java/Extensions Java ClassPath. JDBC FileMaker. JDBC Java JDBC 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 SQL.. Java JDBC FileMaker. SQL FileMaker. FileMaker Server, FileMaker ( ), Java ( ). 클라이언트 / 서버구성. Java JDBC FileMaker JDBC JDBC Java RAD Java. Java, JDBC. JDBC, Java JDBC JDBC URL. JDBC URL. JDBC JDBC JDBC 3.0. FileMaker. 1 SAVEPOINT 1 1 1
6 JDBC FileMaker 26 1 Ref 1 CLOB, ARRAY REF 1 1 DATALINK 1 1 JDBC SPI Connector JDBC JDK(Java Development Kit) 1.6, 1.7 1.8. Type 4, JDBC FileMaker Java. Java (, JDBC ).. com.filemaker.jdbc.driver JDBC FileMaker JDBC FileMaker. FileMaker,. FileMaker XDBC Listener, OS X Windows XDBC Listener. fmxdbc_listener. XDBC Listener FileMaker Server. FileMaker Server Admin Console XDBC Listener. FileMaker Server. JDBC URL Java, URL. JDBC URL JDBC. JDBC URL. jdbc:<subprotocol>:<subname> JDBC URL JDBC (jdbc). subprotocol. JDBC filemaker. subname FileMaker IP. JDBC FileMaker () JDBC. 1. JDBC JDBC. 2. FileMaker. JDBC URL. jdbc:filemaker://192.168.1.1/database 3..
6 JDBC FileMaker 27 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 28 URL JDBC URL. Properties DriverManager.getConnection. 1 : ODBC/JDBC fmxdbc FileMaker 1 : FileMaker URL JDBC URL : jdbc:filemaker://<filemaker host IP address>/<databasename> jdbc:filemaker://192.168.1.1/publications URL, JDBC URL : jdbc:filemaker://<filemaker host IP address>/<databasename>?user=<databaseusername>&password=<databasepassword> 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. Connection conn = DriverManager.getConnection ( "jdbc:filemaker://192.168.1.1/customers?sockettimeout=100", "admin", "admin" );
6 JDBC FileMaker 29 FileMaker FileMaker FileMaker,,. JDBC URL. FileMaker. JDBC FMServer_Sample JDBC. JDBC. JDBC FileMaker. 1 FileMaker 1 FileMaker ODBC/JDBC fmxdbc 1 FileMaker Server FileMaker 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 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 15 10-308 SQL_DATE 10 +308. SQL_TIME FileMaker. 0 24 ( 0 ). SQL_TIMESTAMP (BLOB) SQL_LONGVARBINARY,. SELECT CAST() GetAs(). ODBC.
7 31.. FileMaker. INSERT INTO mytable(repfield[3]) VALUES ( this is rep 3 ) SELECT repfield[1], repfield[2] FROM mytable FileMaker JDBC FileMaker JDBC, SQL JDBC. 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 JDBC FileMaker JDBC SQL., JDBC FileMaker java.sql.types.timestamp. 64 32 ODBC API,. 64 Windows. 64 ODBC API. 64 32. 32 64. ODBC JDBC FileMaker ODBC/JDBC. ODBC. 1 ODBC 1 FileMaker FileMaker XDBC Listener
7 32 FileMaker ODBC FileMaker XDBC Listener DSN. [FileMaker] [FileMaker ODBC] [FileMaker] [FileMaker ODBC] /. FileMaker.. JDBC FileMaker JDBC SQLExceptions.. 1 JDBC 1 FileMaker FileMaker XDBC Listener FileMaker JDBC FileMaker XDBC Listener DSN. [FileMaker] [FileMaker JDBC] [FileMaker] [FileMaker JDBC] /. FileMaker.
32 ODBC (Windows) 14 12 (Windows) 13 64 ODBC (Windows) 14 31 12 (Windows) 13 A ARRAY 26 B BLOB 31 C CAST 30 CLOB 26 D DatabaseMetaData 30 DATALINK 26 DATE 31 DOUBLE 31 DSN (macos) 22 (Windows) 21 8 E ExecuteSQL 10 F FileMaker Cloud JDBC 23 ODBC 12 FileMaker ODBC macos 16 Windows 13 FileMaker Server 5 FileMaker JDBC 28 ODBC(macOS) 22 ODBC(Windows) 21 FileMaker 7 FileMaker ODBC JDBC 5 fmxdbc 20, 28 G GetAs 30 getcolumnprivileges 30 getcolumns 30 getmetadata 30 gettables 30 gettabletypes 30 gettypeinfo 30 getversioncolumns 30 J Java 23 JDBC 25 32, 25 JDBC SPI 26 JDBC 25 JDBC JDBC URL 26 JDBC 26 26 31 29 JDBC 26 JDBC URL(Uniform Resource Locator) 26 JDBC 25 JDK(Java Development Kit) 26 M macos DSN 16 JDBC 23 ODBC 22 Microsoft Access 8 MySQL 11 N null 30
34 O ODBC 31 19 31 ODBC Manager DSN 16 ODBC 22 16 ODBC (macos) 22 ODBC 9 ODBC DSN 14 ODBC 21 14 ODBC 30 ODBC 30 (macos) 22 (Windows) 21 ODBC/JDBC 20 Oracle 11 P PDF 5 R RAD(Rapid Application Development) 25 REF 26 S SAVEPOINT 25 SQL Server 11 SQL 9, 10 SQL 6, 10 SQL_DATE 30 SQL_DOUBLE 30 SQL_LONGVARBINARY 30 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 Windows DSN 21 JDBC 23 ODBC 21 X XDBC Listener JDBC 26 ODBC 20 31 20 FileMaker 7, ODBC/JDBC 20 6 20, 20 8 FileMaker DSN 8 JDBC 29 JDBC 28 ODBC (macos) 22 ODBC (Windows) 21 ODBC (macos) 22 ODBC (Windows) 21 FileMaker 7 JDBC 31 ODBC 30 JDBC 28 ODBC (macos) 22 ODBC (Windows) 21, 8, 10 9, 10
35 JDBC 31 ODBC 30 30 31 26 5 12, 23 7 JDBC 23 ODBC 12 20 7 2399 JDBC 24 ODBC (macos) 16 ODBC (Windows) 13 JDBC 31 ODBC 30 JDBC 24 ODBC(macOS) 16 ODBC(Windows) 13 20 JDBC 28 ODBC 21, 22 21 31 5 SQL 9 11 7, FileMaker 5 25 JDBC 29 ODBC (macos) 22 ODBC (Windows) 21 JDBC 29 ODBC (macos) 22 ODBC (Windows) 21 30 JDBC 31 ODBC 30, FileMaker 5