title: Connect to Filemaker Database using JDBC, Python, and JayDeBeApi
body: <p>I'm trying to write an AWS Lambda Python Package that will connect to a FileMaker database over JDBC. To test, I've launched an EC2 instance with the Lambda Linux AMI, and created a virtualenv (/venv) that I'm testing in. I've uploaded the fmjdbc.jar to the instance using WinSCP to /venv/lib/fmjdbc.jar. The code uses JayDeBeApi, following the usage example here: <a href="https://pypi.python.org/pypi/JayDeBeApi/#usage" rel="nofollow">https://pypi.python.org/pypi/JayDeBeApi/#usage</a></p>
  
  <p>My code so far is the following:</p>
  
  <pre><code>import jaydebeapi as jdb
  
  driverclass = 'com.filemaker.jdbc.Driver'
  jdbcURL = 'jdbc:filemaker://url:port;database'
  
  
  jar = '/home/ec2-user/lambda-test-project/venv/lib/fmjdbc.jar'
  print jar
  
  conn = jdb.connect(driverclass,[jdbcURL,'username','password'],jar)
  </code></pre>
  
  <p>Which gives me the error:</p>
  
  <pre><code>Traceback (most recent call last):
    File "&lt;stdin&gt;", line 1, in &lt;module&gt;
    File "/home/ec2-user/lambda-test-project/venv/local/lib/python2.7/site-package                                               s/jaydebeapi/__init__.py", line 359, in connect
      jconn = _jdbc_connect(jclassname, jars, libs, *driver_args)
    File "/home/ec2-user/lambda-test-project/venv/local/lib/python2.7/site-package                                               s/jaydebeapi/__init__.py", line 183, in _jdbc_connect_jpype
      return jpype.java.sql.DriverManager.getConnection(*driver_args)
  jpype._jexception.SQLExceptionPyRaisable: java.sql.SQLException: No suitable driver found for jdbc:filemaker://&lt;MY URL STUFF IS HERE&gt;
  </code></pre>
  
  <p>How can I get the jdbc driver to be read by Python's virtual environment? I'd like to have this code work in a Lambda package eventually, so I'm hoping there's a solution that can be integrated to the Python code that will work repeatedly on newly created servers.</p>