FileMaker 15 ODBC JDBC
2004-2016 FileMaker, Inc.. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc.. FileMaker WebDirect FileMaker, Inc... FileMaker. FileMaker. FileMaker.,, URL,, URL.. URL. FileMaker, Inc.. (http://www.filemaker.com/kr). Edition: 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 10 FileMaker 15 11 ODBC 11 3 FileMaker ODBC 클라이언트드라이버설치하기 12 12 12 ODBC (Windows) 12 ODBC (Windows) 13 (Windows) 13 ODBC (Windows) 13 DSN (Windows) 14 ODBC (OS X) 15 (OS X) 16 17
4 4 ODBC 를사용하여 FileMaker 데이터공유하기 18 ODBC 18 ODBC 19 FileMaker 19 Windows FileMaker 20 FileMaker DSN ODBC (Windows) 20 ODBC (Windows) 20 OS X FileMaker 21 FileMaker DSN(OS X) ODBC 21 ODBC (OS X) 21 5 FileMaker JDBC 클라이언트드라이버설치하기 22 22 22 JDBC 22 JDBC 23 6 JDBC 를사용하여 FileMaker 데이터공유하기 24 JDBC 24 JDBC 24 JDBC 24 JDBC URL 25 URL 27 FileMaker 27 JDBC 28 7 참조정보 29 ODBC 29 JDBC DatabaseMetaData 29 FileMaker ODBC 29 FileMaker JDBC 30 64 30 ODBC JDBC 31 ODBC 31 JDBC 31 인덱스 32
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 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. 5 ~ 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 > FileMaker Server. 1 FileMaker http://www.filemaker.com/documentation/ko. ODBC JDBC ODBC JDBC API(Application Programming Interfaces). ODBC C API JDBC Java API. API FileMaker Pro FileMaker Server. ODBC JDBC SQL( ). SQL (, ) FileMaker,.
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 Oracle, SQL Server MySQL. FileMaker Pro ODBC. 2, " SQL," ODBC FileMaker.
1 7 FileMaker, FileMaker ODBC- JDBC-. FileMaker FileMaker, ODBC JDBC SQL FileMaker. FileMaker Pro FileMaker Server FileMaker Pro, ODBC JDBC FileMaker. FileMaker. FileMaker FileMaker Server FileMaker Pro ( ) ( ). 5 ( ). FileMaker FileMaker,. FileMaker, ODBC JDBC.. FileMaker Pro FileMaker Server ODBC JDBC ODBC JDBC. 1 3, "FileMaker ODBC," ODBC FileMaker. 1 4, "ODBC FileMaker," FileMakerr ODBC FileMaker. 1 5, "FileMaker JDBC," JDBC FileMaker. 1 6, "JDBC FileMaker," FileMaker Java FileMaker JDBC. 1 7, "," FileMaker ODBC JDBC. FileMaker Pro FileMaker Server ODBC JDBC SQL FileMaker SQL. ODBC/JDBC, FileMaker Server FileMaker Pro. ODBC JDBC.. 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(Data Source Name). FileMaker DSN, ( DSN ). 1 FileMaker Pro ODBC JDBC http://www.filemaker.com/documentation/ko.
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 FileMaker Pro ODBC ( : Oracle Microsoft Access ).,.,., FileMaker Pro., SQL ExecuteSQL ODBC. ODBC. 1. ODBC. 2. FileMaker Pro, ODBC DSN(Data Source Name). 3. ODBC (, ). 4. FileMaker Pro. 1 FileMaker Pro > > ODBC. 1 FileMaker Pro >. (Windows) (OS X) ODBC. 5. ( ) FileMaker Pro SQL.
2 SQL 10 6. FileMaker Pro SQL Query. SQL.. SQL 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 INSERT, UPDATE DELETE SQL. ExecuteSQL SELECT. FileMaker Pro SQL. FileMaker Pro SQL Server SQL. SQL ExecuteSQL FileMaker FileMaker Pro. FileMaker SQL FileMaker SQL. ODBC ODBC, FileMaker SQL. FileMaker Pro FileMaker Server ODBC, SQL ODBC. FileMaker Pro FileMaker Pro FileMaker Pro FileMaker Server SQL FileMaker Pro
2 SQL 11 FileMaker 15 FileMaker ODBC, Oracle, Microsoft SQL Server MySQL Community Edition SQL ODBC. SQL http://www.filemaker.com/kr/support/kb/index.html FileMaker Knowledge Base. ODBC ODBC FileMaker Pro. 1. ODBC. 2. FileMaker Pro, ODBC DSN(Data Source Name). 3. ODBC (, ). 4. ODBC FileMaker Pro. 5. FileMaker Pro. 6., ODBC. ODBC, ODBC, ODBC ODBC FileMaker Pro.
3 FileMaker ODBC FileMaker ODBC, ODBC. ODBC FilleMaker ODBC.. ODBC FileMaker xdbc. URL. www.filemaker.com/kr/support/index.html FileMaker Server FileMaker,., FileMaker SQL. ODBC FileMaker. 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. 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) ODBC FileMaker,.,. FileMaker 2399. ODBC (Windows) ODBC. 32 ODBC 32 Windows : Windows > (ODBC).
3 FileMaker ODBC 14 32 ODBC 64 Windows : Windows > ODBC (32). 64 ODBC 64 Windows : 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. 1,..., System UTF-8., Microsoft Excel System UTF-8.,. FileMaker 3 UTF-8.
3 FileMaker ODBC 15 1 long varchar Microsoft Word Mail Merge 255 PHP. 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. xdbc, ODBC Client Driver Installer. 4. ODBC Client Driver Installer, FileMaker ODBC.pkg. 5. ODBC. 6.. ODBC. /Library/ODBC ODBC. ODBC, FileMaker ODBC FileMaker.
3 FileMaker ODBC 16 (OS X) ODBBC FileMaker,.,. Actual Technologies ODBC Manager http://www.odbcmanager.net FileMaker. 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, localhost IP 127.0.0.1. 1 FileMaker Server, FileMaker Server IP. ODBC/JDBC,... 8., FileMaker. FileMaker Server,. FileMaker Server. FMServer_Sample ODBC. ODBC. 1,... ODBC 4, " " ODBC API.
3 FileMaker ODBC 17 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.,. FileMaker, FileMaker ODBC/JDBC FileMaker Server FileMaker Pro ODBC/JDBC. 1., FileMaker SQL. ODBC. SQL.. ODBC FileMaker 4, "ODBC FileMaker.".
4 ODBC FileMaker ODBC ODBC FileMaker. ODBC FileMaker. FileMaker ODBC FileMaker ODBC. FileMaker Pro 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 Driver SQL Server ODBC Driver FileMaker ODBC Client Driver Oracle Microsoft SQL Server FileMaker
4 ODBC FileMaker 19 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 XDBC Listener. FileMaker Server XDBC Listener ODBC/JDBC XDBC Listener ODBC/JDBC. FileMaker ODBC, FileMaker SQL. ODBC SQL. FileMaker. 1. FileMaker Pro,. ODBC/JDBC. 2. FileMaker Server(FileMaker Server ) FileMaker Pro ODBC/JDBC. FileMaker Server : > ODBC/JDBC ODBC/JDBC. FileMaker Pro: > > ODBC/JDBC ODBC/JDBC.
4 ODBC FileMaker 20 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 13 " (Windows)". ODBC (Windows) FileMaker ODBC. 1. ODBC. 13 "ODBC (Windows)".. 2. DSN DSN ( ). 3. FileMaker. FileMaker ODBC. 4.. 5.. 6.. FileMaker ( ) ( ).. : 1 FileMaker. 1.
4 ODBC FileMaker 21 1 FileMaker ODBC/JDBC. 1 FileMaker Server FileMaker Pro ODBC/JDBC. OS X FileMaker FileMaker DSN(OS X) ODBC 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 ( ) ( ).. : 1 FileMaker. 1. 1 FileMaker ODBC/JDBC. 1 FileMaker Server FileMaker Pro ODBC/JDBC.
5 FileMaker JDBC FileMaker JDBC, JDBC. JDBC FilleMaker JDBC.. URL. www.filemaker.com/kr/support/index.html 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. 4. xdbc, JDBC Client Driver Installer.
5 FileMaker JDBC 23 5. fmjdbc.jar. 1 Windows: fmjdbc.jar Java (java.exe) Java ClassPath. 1 OS X: fmjdbc.jar Java /Library/Java/Extensions Java ClassPath. JDBC FileMaker. JDBC Java JDBC 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 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 25 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 FileMaker XDBC Listener. fmxdbc_listener. FileMaker XDBC Listener FileMaker Server. FileMaker Server XDBC Listener. FileMaker Server XDBC Listener ODBC/JDBC XDBC Listener ODBC/JDBC. JDBC URL Java, URL(Uniform Resource Locators). 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
6 JDBC FileMaker 26 3.. 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/mydataba se, username, password ); } catch(exception e) { System.out.println(e); } // 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 27 URL JDBC URL. Properties DriverManager.getConnection. 1 : ODBC/JDBC 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 FileMaker FileMaker FileMaker,,. JDBC URL. FileMaker.
6 JDBC FileMaker 28 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 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 ODBC. FileMaker ODBC SQL_VARCHAR FileMaker 100. FileMaker NULL. SQL_DOUBLE FileMaker 15 10-308 10 +308. SQL_DATE SQL_TIME FileMaker. 0 24 ( 0 ). SQL_TIMESTAMP
7 30 FileMaker ODBC (BLOB) SQL_LONGVARBINARY,. SELECT CAST() GetAs(). ODBC... 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.
7 31 ODBC JDBC FileMaker ODBC/JDBC. ODBC. 1 ODBC 1 FileMaker FileMaker XDBC Listener FileMaker ODBC FileMaker Listener. [FileMaker] [FileMaker ODBC], FileMaker. [FileMaker] [FileMaker ODBC] /. FileMaker.. JDBC FileMaker JDBC SQLExceptions.. 1 JDBC 1 FileMaker FileMaker XDBC Listener FileMaker JDBC FileMaker Listener. [FileMaker] [FileMaker JDBC], FileMaker. [FileMaker] [FileMaker JDBC] /. FileMaker.
32 ODBC (Windows) 13 12 (Windows) 13 64 ODBC (Windows) 14 30 12 (Windows) 13 A ARRAY 25 B BLOB 30 C CAST 30 CLOB 25 D DatabaseMetaData 29 DATALINK 25 DATE 30 DOUBLE 30 DSN (OS X) 21 (Windows) 20 8 E ExecuteSQL 9, 10 F FileMaker ODBC OS X 15 Windows 13 FileMaker Server 5 FileMaker JDBC 27 ODBC(OS X) 21 ODBC(Windows) 20 FileMaker 7 FileMaker ODBC JDBC 5 G GetAs 30 getcolumnprivileges 29 getcolumns 29 getmetadata 29 gettables 29 gettabletypes 29 gettypeinfo 29 getversioncolumns 29 J Java 22 JDBC 24 31, 24 JDBC SPI 25 JDBC 24 JDBC JDBC URL 25 JDBC 25 25 30 28 JDBC 25 JDBC URL(Uniform Resource Locator) 25 JDBC 24 JDK(Java Development Kit) 25 M Microsoft Access 8 MySQL 11 N null 29 O ODBC 30 18 31 ODBC Manager DSN 16 ODBC 21 16 ODBC (OS X) 21
33 ODBC 9 ODBC DSN 14 ODBC 20 13 ODBC 29 ODBC 29 (OS X) 21 (Windows) 20 ODBC/JDBC 19 Oracle 11 OS X DSN 16 JDBC 22 ODBC 21 P PDF 5 R RAD(Rapid Application Development) 24 REF 25 S savepoint 24 SQL Server 11 SQL 9, 10 SQL 6, 9 SQL_DATE 29 SQL_DOUBLE 29 SQL_LONGVARBINARY 30 SQL_TIME 29 SQL_TIMESTAMP 29 SQL_VARCHAR 29 SQLColumnPrivileges 29 SQLColumns 29 SQLDescribeCol 29 SQLExceptions 31 SQLGetTypeInfo 29 SQLTables 29 T TCP/IP 8 TIME 30 TIMESTAMP 30 V VARCHAR 30 W Windows DSN 20 JDBC 22 ODBC 20 X XDBC Listener JDBC 25 ODBC 19 31 19 FileMaker 7, ODBC/JDBC 19 6 19, 19 8 FileMaker DSN 8 JDBC 28 JDBC 27 ODBC (OS X) 21 ODBC (Windows) 20 ODBC (OS X) 21 ODBC (Windows) 20 FileMaker 7 JDBC 30 ODBC 29 JDBC 27 ODBC (OS X) 21 ODBC (Windows) 20, 8, 10 9, 10 JDBC 30 ODBC 29 29
34 30 25 5 12, 22 6 JDBC 22 ODBC 12 JDBC 30 ODBC 29 JDBC 23 ODBC(OS X) 16 ODBC(Windows) 13 19 JDBC 27 ODBC 20, 21 20 31 5 SQL 9 11 7, FileMaker 5 24 JDBC 28 ODBC (OS X) 21 ODBC (Windows) 20 JDBC 28 ODBC (OS X) 21 ODBC (Windows) 20 29 JDBC 30 ODBC 30, FileMaker 5 19 7 2399 JDBC 23 ODBC (OS X) 16 ODBC (Windows) 13