Jdbc datasource


#1

Hi,
I have a jdbc driver for FileMaker database.

fmjdbc.jar

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?


#2

bump -:slight_smile: still stuck…


#3

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
https://luceeserver.atlassian.net/browse/LDEV-804

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"
};