Difference between revisions of "JDBC"

From 360Works Product Documentation Wiki
Jump to navigation Jump to search
(Created page with "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 w...")
 
Line 5: Line 5:
 
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:
 
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 JConnect: http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect
For PostgreSQL, navigate to http://jdbc.postgresql.org/download
+
*For PostgreSQL: http://jdbc.postgresql.org/download
MySQL: http://dev.mysql.com/downloads/connector/j/3.1.html /
+
*MySQL: http://dev.mysql.com/downloads/connector/j/3.1.html /
MS SQL Server: http://msdn.microsoft.com/en-us/library/ms378672.aspx
+
*MS SQL Server: http://msdn.microsoft.com/en-us/library/ms378672.aspx
Oracle: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
+
*Oracle: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
FileMaker Server: http://java.net/projects/woof/
+
*FileMaker Server: http://java.net/projects/woof/
  
 
For a good list of drivers of many technologies:
 
For a good list of drivers of many technologies:
  
 
http://developers.sun.com/product/jdbc/drivers
 
http://developers.sun.com/product/jdbc/drivers

Revision as of 16:00, 6 August 2012

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 a good list of drivers of many technologies:

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