Can't connect to MariaDB

[Thorsten27751974bpgq]

Cant connect Adobe Admin Panel my MariaDB.

i have to connect to an external Database. its a MariaDB 11.4.4. Version

i only have in the admin to select :

• Apache Derby Client
• Apache Derby Embedded
• Microsoft SQL Server
• Mysql (DataDirect)
• Mysql 5
• other
• PostgeSQL

How i can connect to MariaDB 11.4.4

Where i can find the KDBC Connector to download. on MariaDB Site i cant find a .JAR file like Mysql....

Who can help me?

Kindly Regards

Thorsten

I have Coldfusion 2016 , Ubuntu 18

[Charlie Arehart]

There's more than one way to get cf to talk to a db, including Maria, (whether via driver settings in the cf admin or at the app level, and different ways to implement the jar for such a driver not built into CF). But as you're asking about the admin:

1. Get that jdbc (java) connector jar, at https://mariadb.com/kb/en/installing-mariadb-connectorj/
2. Save that jar into cf's cfusion/lib folder (or technically any folder in cf's "classpath")
3. restart cf
4. In the cf admin datasource page, create a new one with the "other" driver type
5. For the class name, use org.mariadb.jdbc.Driver
6. For the jdbc url, you could use something like jdbc:mariadb://localhost:3306/yourdbname. This is assuming the Maria instance is on the same machine as cf, and listening in its default port of 3306
7. For the driver field, it's just a label. You could say simply mariadb
8. Fill in the rest to suit your needs 
9. On submitting that, it will attempt to verify it. If any error, correct what you can and try again

Let us know how it goes. These are steps off the top of my head and pulling together some resources I looked up. If I have any mistake, I'll gladly correct it.

For those who may want to setup an app-level dsn instead, there are cf docs and other resources on that. But here is one specifically on doing that for Maria. 

[Thorsten27751974bpgq]

Many thanks for the information.
Yes, my problem is that I have already downloaded it, but I can't find the right package that contains the JAR file.
Here is the screenshot where I end up with the download.
What do I have to select to get the right file?

[Thorsten27751974bpgq]

Many thanks for the information.

Yes, my problem is that I have already downloaded it, but I can't find the right package that contains the JAR file.

Here is the screenshot where I end up with the download.

What do I have to select to get the right file?

[Charlie Arehart]

Do you see the option on the right for "product" defaulting to "c connector". Change that to pick the one for "Java 8+", which will work for your cf version and later (there's no option that says "jdbc", but this is what you want). That will show that what you'll get is the needed jar. 

[Dave Watts]

It looks like @Charlie Arehart responded correctly before I even had a chance to read your question! But I think you can probably just use the MySQL driver, as the client protocol is the same between MySQL and MariaDB.

[Charlie Arehart]

Yep, Dave, perhaps. (And thanks for the kind regards.)

As for using cf's provided mysql dsn driver choices, note that one of them works only with a licensed mysql, and the other requires you to implement the mysql connector/jar yourself--it's not included with CF (though at least it doesn't require using the "other" driver).

Just clarifying for future readers who may find this. Indeed, I spelled out the details for what Thorsten asked because I didn't find any resource online that did. (Others talked about using app level settings for a Maria dsn,or they discussed the "other" driver option without detailing Maria).

But you're right that someone may find they could just implement the mysql jar and then use the mysql driver option in the admin. I did start my first reply acknowledging that there are many ways to do such things. 🙂 

[BKBK]

@Thorsten27751974bpgq , I have the same suggestion as Dave: for MariaDB you can use the MySQL driver.

However, there is bad news. Before you proceed any further, be aware that what you are trying to achieve may not be possible. The reason is as follows.

Your ColdFusion version is 2016. Its highest Java version was Java 11. Both of these are too old when compared with MariaDB v11.4.4, which was released in November 2024. That is, it is very likely that MariaDB 11.4.4 is incompatible with ColdFusion 2016.

Now, on to the good news. It is possible to solve the problem. You can do so, for example, by combining the following compatible technologies:

• ColdFusion 2016 running on Java 8, alternatively, ColdFusion 2016 Update 8 or above running on Java 11;
• MariaDB v10.1.x, for example, v10.1.48;
• MySQL Connector/J version 8, for example, v8.0.33. 

[Charlie Arehart]

Bkbk, note that while cf2016 came out on Java 8, that's not the "highest" it can run. It was modified to allow moving to Java 11, per that cf2016 update 8. It can be hard to keep track and FWIW, I keep updated a post offering table of what cf versions support what Java versions.

That said, I'm not proposing to you Thorsten that you should update to Java 11. You could, of course, but Java 8 IS in fact still updated by Oracle. And I do a blog post confirming that each time Java is updated (quarterly), at carehart.org/blog.

Finally, I'll repeat that the original answer I offered does not require changing Java versions. BKBK's point here is addressing Dave's idea of using the mysql connector/j driver.

All that said, we've all held off saying something I know we'd all agree on: you're walking on thin ice running cf2016, which hasn't gotten updates since 2021 (including for critical cf security vulns). Note that if you may be open to considering that there's a special discount to get it at 25% off, for those on cf2018 and earlier, until the ending this month. It's not offered by Adobe but a reseller. More in a post I did, here.

But either way, do let us know if you get to running with Maria. It should work with any of these options. 

[BKBK]

Thanks, Charlie, for your remark on Java 11's introduction to ColdFusion 2016 from Update 8 onwards. I am aware of that, but there was an oversight during typing.

I have duly modified the relevant bulleted point to: "ColdFusion 2016 running on Java 8, alternatively, ColdFusion 2016 Update 8 or above running on Java 11;"

[Charlie Arehart]

@Thorsten27751974bpgq, any ultimate resolution?