Maria DB connection issues

[Ross Valenti]

Hello group,  I'm having a strange issue and thought I'd run it by you to see if anyone has any insight.  

On my dev server, running CF 2018 fully updated. I am connecting to a remote database server running  MariaDB  v10.3.17.  JAR file is mariadb_java_client-2.4.2.jar

I can successfully connect to one database on the server.  When I try to connect to a second database on the same db server, I receive this message

Connection verification failed for data source: shoptracey_wp
java.sql.SQLException: No suitable driver available for shoptracey_wp, please check the driver setting in resources file, error: org.maria.jdbc.driver
The root cause was that: java.sql.SQLException: No suitable driver available for shoptracey_wp, please check the driver setting in resources file, error: org.maria.jdbc.driver  

There are no differences in how the databases were created nor in any settings.

If anyone has any thoughts as to why I can connect to one database but not another I would be very appreciative - I've been banging my head against the wall over this issue for some time now

Thanks

Ross Valenti

[Pete Freitag]

Hi Ross,

Java class names are case sensitive, so I think you might need to uppercase the D in Driver and maria may need to be mariadb, eg try this: org.mariadb.jdbc.Driver

-------------------------------------------------

Pete Freitag
Foundeo Inc. 

 ↳ Fixinator  - CFML Code Security Scanner

 ↳ HackMyCF   - CF Server Security Scanner

 ↳ FuseGuard  - App Firewall for your CFML

 ↳ Consulting - Code/Server Review & Development

--
You received this message because you are subscribed to the Google Groups "Central New York ColdFusion Users Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cfugcny+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/cfugcny/CAE%3Dw1AhvDNHH3SwUPMBHMgafUVHjBviqdGT2RejUaO1OL7u0nA%40mail.gmail.com.

[charli...@carehart.org]

Great catch, Pete.

If that’s not it, Ross, do compare closely the two DSNs to see if there may be some other difference to explain things. (And if it remains a problem, tell us where you put the jar file. I realize it “worked” for the first one, but even it so, it could prove significant.)

/charlie

[Ross Valenti]

Pete, thanks for the suggestion. I mistyped the driver in my email, as you can see below they are both identical.  The JAR file is placed in \ColdFusion2018\cfusion\lib

 This DSN  works:

This one does not:

The IPs which I blacked out are identical - same server instance.

Here is more info on the databases:

Working:

Not working:

Ross

--
You received this message because you are subscribed to the Google Groups "Central New York ColdFusion Users Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cfugcny+u...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/cfugcny/12a501d55701%2435324b50%249f96e1f0%24%40carehart.org.

[Pete Freitag]

Hi Ross

The one that is not working says org.maria

 In the driver class it should be org.mariadb missing the db 

To view this discussion on the web visit https://groups.google.com/d/msgid/cfugcny/CAE%3Dw1Ag%2BtdGiAJLST%3DO_KrPOsgLRmWavg76wvSsFD2eqZhLgbA%40mail.gmail.com.

--