Jdbc datasource


I have a jdbc driver for FileMaker database.


Which folder do I place it in Lucee to have it appear as a datasource option?

or I can use the normal jdbc lucee driver but still need to place the class somewhere?


bump -:slight_smile: still stuck…


the official new way in lucee 5 is to create an extension, so the driver can be installed and loaded
without restarting the server via OSGI

it’s pretty simple wrapper which looks like this

maybe @micstriit can create an empty repo under lucee and you can file
a pull request with the details filled in, then you’ll have filemaker always
available as an installable extention

The JDBC other (Deprecated) history is explained here

You can try just dropping the jar file in \WEB-INF\lucee\lib under your webroot
and then restart lucee and use the JDBC other interface

or just use a custom datasource like this in application.cfc with the correct details
(hint: they all need to be changed)

this.datasources["mydatasource"] = {
      class: 'org.gjt.mm.mysql.Driver'
    , connectionString: 'jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&useLegacyDatetimeCode=true'
    , username: 'test'
    , password: "encrypted:902d6d9d2b807986450ed5b16031129b28d51bdae637995a"