Re: [Exist-open] Installing mysql connector

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

I will probably call the XAR open-source-jdbc

> On Jan 9, 2021, at 1:54 PM, Loren Cahlander <lor...@gm...> wrote:
> 
> 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... <mailto: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... <mailto:Exi...@li...>
>> https://lists.sourceforge.net/lists/listinfo/exist-open
>