JDBC

From 360Works Product Documentation Wiki
Revision as of 16:00, 6 August 2012 by Sarah (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

The 360Works JDBC plugin for FileMaker Pro allows execution of arbitrary SQL statements on one or more JDBC databases, iterating result sets, and importing from any database which supports the JDBC protocol.

Drivers

You will need a JDBC driver to connect to the data source. If you already have a driver, point the plug-in to it using either a URL or uploading it to a container field. If you do not have a driver, the website of the database company will have the .jar file you need. Download a driver using these URLs:

For JConnect, navigate to http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect For PostgreSQL, navigate to http://jdbc.postgresql.org/download MySQL: http://dev.mysql.com/downloads/connector/j/3.1.html / MS SQL Server: http://msdn.microsoft.com/en-us/library/ms378672.aspx Oracle: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html FileMaker Server: http://java.net/projects/woof/

For a good list of drivers of many technologies:

http://developers.sun.com/product/jdbc/drivers

Personal tools
Namespaces

Variants
Actions
Plug-in Products
Other Products
Navigation
Toolbox