Re: [Lucee] Informix database setup

[AJ Mercer]

in the datasource type, choose 'other' [just looked in my Lucee 5 and it sayd deprecated??]

you will need the Informix JAR and know its class path

Not sure if Lucee 5 needs an Informix datasource extension created

On 28 October 2016 at 00:31, J Mac <jayan...@gmail.com> wrote:

I am trying to setup a connection to an informix database.

Preferrably using JDBC.

I have not found any examples or instructions on this and thought I would ask here for help.

any thoughts would be appreciated.

--
Get 10% off of the regular price for this years CFCamp in Munich, Germany (Oct. 20th & 21st) with the Lucee discount code Lucee@cfcamp. 189€ instead of 210€. Visit https://ti.to/cfcamp/cfcamp-2016/discount/Lucee@cfcamp
---
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/760c27f9-f3b3-45a3-bf77-ae64d50ec29f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

AJ Mercer
<webonix:net strength="Industrial" /> | <webonix:org community="Open" />
http://twitter.com/webonix

[AJ Mercer]

general doco
http://docs.lucee.org/guides/cookbooks/datasource-define-datasource.html

[J Mac]

I tried just adding the jar and linking that way but it did not work for me.

I think it will need a new extension created.

On Thursday, October 27, 2016 at 11:51:15 PM UTC-5, AJ Mercer wrote:

in the datasource type, choose 'other' [just looked in my Lucee 5 and it sayd deprecated??]

you will need the Informix JAR and know its class path

Not sure if Lucee 5 needs an Informix datasource extension created

On 28 October 2016 at 00:31, J Mac <jayan...@gmail.com> wrote:

I am trying to setup a connection to an informix database.

Preferrably using JDBC.

I have not found any examples or instructions on this and thought I would ask here for help.

any thoughts would be appreciated.

--
Get 10% off of the regular price for this years CFCamp in Munich, Germany (Oct. 20th & 21st) with the Lucee discount code Lucee@cfcamp. 189€ instead of 210€. Visit https://ti.to/cfcamp/cfcamp-2016/discount/Lucee@cfcamp
---
You received this message because you are subscribed to the Google Groups "Lucee" group.

To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.

To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/760c27f9-f3b3-45a3-bf77-ae64d50ec29f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Jonathan D'Andries]

I'm working on this with Jay. We're using FROM lucee/lucee5-nginx:latest as our base image in Docker, and we've tried the following:

# Add the driver Jar to the location where all the other jdbc drivers are loaded with hope it will be included in the classpath:
COPY ifxjdbc.jar /opt/lucee/server/lucee-server/bundles/

# Define a new Datasource of type "Other - JDBC Driver (depricated)" here:
/lucee/admin/server.cfm?action=services.datasource

Class Name: com.informix.jdbc.IfxDriver
Connection String: jdbc:informix-sqli://...

But we're getting the following error message:

cannot load class through its string name, because no definition for the class with the specified name [com.informix.jdbc.IfxDriver] could be found


What am I missing?

Thanks,

Jonathan

On Thursday, October 27, 2016 at 11:52:31 PM UTC-5, AJ Mercer wrote:

general doco
http://docs.lucee.org/guides/cookbooks/datasource-define-datasource.html

On 28 October 2016 at 00:31, J Mac <jayan...@gmail.com> wrote:

I am trying to setup a connection to an informix database.

Preferrably using JDBC.

I have not found any examples or instructions on this and thought I would ask here for help.

any thoughts would be appreciated.

--
Get 10% off of the regular price for this years CFCamp in Munich, Germany (Oct. 20th & 21st) with the Lucee discount code Lucee@cfcamp. 189€ instead of 210€. Visit https://ti.to/cfcamp/cfcamp-2016/discount/Lucee@cfcamp
---
You received this message because you are subscribed to the Google Groups "Lucee" group.

To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.

To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/760c27f9-f3b3-45a3-bf77-ae64d50ec29f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[AJ Mercer]

here are some more links

general discussion - Micha explains differences in version 5 and an offer to assist

    https://groups.google.com/forum/?utm_medium=email&utm_source=footer#!msg/lucee/BvDAUY43pEA/hZNUFXhxDwAJ

some extensions

    https://github.com/lucee/JDBC-extension-factory

    https://github.com/lucee/JDBC-extension-factory/blob/master/build/mssqljdbc-4.0.2206.100/MSSQL.cfc     

To unsubscribe from this group and stop receiving emails from it, send an email to lucee+unsubscribe@googlegroups.com.

To post to this group, send email to lu...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/cf1f42ab-54dc-4055-9e6a-a6f6653b1ff5%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Jonathan D'Andries]

Perfect, thanks. Those links helped answer two questions:

1. If we want to use "Other - JDBC Driver (depricated)" with our custom driver, where do we put fxjdbc.jar so that it's added to the CLASSPATH?
  Answer: put it in the same directory with lucee.jar. In the version we are running, that location is as follows: /usr/local/tomcat/lucee/

2. If we want to define a custom extension (not necessary, but would be nice for the community), how do you get started?
  Answer: You can start by modifying an existing extension: "You can modify the one in your server in lucee-server/context/context/admin/MSSQL.cfc selectMethod and sendStringParametersAsUnicode are even there as helpful examples."

I was able to add the "Other - JDBC Driver (depricated)" data source now, but I haven't tried using it yet. I'll post back if it doesn't work...

Cheers,

Jonathan

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/cf1f42ab-54dc-4055-9e6a-a6f6653b1ff5%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.