Re: [Exist-open] Installing mysql connector

[Loren C. <lor...@gm...>]

I will create an XAR that loads all of the open source JDBC drivers.  It is actually quite simple.  I am sorry that I did not do this already.  I should have it ready in a week.  I did this for an application of mine.  I will extract that into its own XAR and make my application dependent on it.  Each commercial JDBC driver will require its own XAR.


> On Jan 9, 2021, at 12:52 PM, Joe Wicentowski <jo...@gm...> wrote:
> 
> See also Loren Cahlander's reply to the question on StackOverflow:
> 
>   https://stackoverflow.com/questions/65483026/exist-db-installing-mysql-connector <https://stackoverflow.com/questions/65483026/exist-db-installing-mysql-connector>
> On Thu, Jan 7, 2021 at 8:31 AM Eduard Drenth <ed...@fr... <mailto:ed...@fr...>> wrote:
> I run exist-db in docker, in my Dockerfile I do for additional jars:
> 
> COPY exist-db-addons-${EXISTADDONSERSION}.jar $EXIST_HOME/lib/
> ENV CLASSPATH=$EXIST_HOME/lib/exist.uber.jar:$EXIST_HOME/lib/exist-db-addons-${EXISTADDONSERSION}.jar
> RUN --mount=type=secret,id=adminpw,required,target=/tmp/adminpw [ "java", "org.exist.start.Main", "client", "--no-gui",  "-l", "-u", "admin", "-P", "", "-F", "/tmp/adminpw" ]
> 
> So perhaps put the connector in lib?
> 
> Bye, Eduard
> 
> -----Original Message-----
> From: Len Schultz <le...@wi... <mailto:Len%20Schultz%20%3c...@wi...%3e>>
> To: exi...@li... <mailto:exi...@li...> <exi...@li... <mailto:%22e...@li...%22%20%3ce...@li...%3e>>
> Subject: [Exist-open] Installing mysql connector
> Date: Wed, 06 Jan 2021 17:06:51 +0000
> 
> Hello,
> 
> Where can I find the steps to correctly install the mysql JDBC driver onto MacOS?  I’m following http://www.exist-db.org/exist/apps/wiki/HowTo/SQLDatabases/QueryingSQLDatabases <http://www.exist-db.org/exist/apps/wiki/HowTo/SQLDatabases/QueryingSQLDatabases>, but am stuck at 1.2.  Everything I try results in
> 
>> ERROR (GetConnectionFunction.java [eval]:161) - sql:get-connection() Cannot connect to database: jdbc:mysql://127.0.0.1:3306/db <>
>> java.sql.SQLException: No suitable driver found for jdbc:mysql
> 
> I’ve installed mysql-connector-java-8.0.22.jar into
> 
> /Applications/eXist-db.app/Contents/Java/
> /Applications/eXist-db.app/Contents/lib/user/
> /Applications/eXist-db.app/Contents/Resources/lib/user/
> /Applications/eXist-db.app/Contents/Resources/etc/webapp/WEB-INF/lib/
> 
> And none of these locations resolved the error.  I must be missing a step.  Any suggestions or links to the proper installation steps?
> 
> --len
> 
> _______________________________________________
> Exist-open mailing list
>  Exi...@li...
>  <mailto:Exi...@li...>
>  https://lists.sourceforge.net/lists/listinfo/exist-open
>  <https://lists.sourceforge.net/lists/listinfo/exist-open>
>  --
> Eduard Drenth, Software Architekt
> 
> ed...@fr... <mailto:ed...@fr...>
> 
> Doelestrjitte 8
> 8911 DX  Ljouwert
> +31 58 234 30 47
> +31 62 094 34 28 (privé)
> 
> skype: eduarddrenth
> https://github.com/eduarddrenth <https://github.com/eduarddrenth>
> frisian.eu <http://frisian.eu/>
> gpg: https://pgp.surfnet.nl/pks/lookup?search=eduarddrenth <https://pgp.surfnet.nl/pks/lookup?search=eduarddrenth>
> 
> 
> Op freed bin ik thús/wurkje ik minder
> 
> 
> 
> _______________________________________________
> Exist-open mailing list
> Exi...@li... <mailto:Exi...@li...>
> https://lists.sourceforge.net/lists/listinfo/exist-open <https://lists.sourceforge.net/lists/listinfo/exist-open>
> _______________________________________________
> Exist-open mailing list
> Exi...@li...
> https://lists.sourceforge.net/lists/listinfo/exist-open