Re: [Exist-open] Installing mysql connector

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

Please try this:

https://github.com/lcahlander/open-source-jdbs.git <https://github.com/lcahlander/open-source-jdbs.git>

Please let me know if this works for you.

If there are other open source JDBC drivers out there, then I would appreciate to know about them.

If this works fine, then I will transfer it over to the eXist-db account.

Cheers,
Loren


> On Jan 9, 2021, at 1:57 PM, Loren Cahlander <lor...@gm...> wrote:
> 
> I will probably call the XAR open-source-jdbc
> 
>> On Jan 9, 2021, at 1:54 PM, Loren Cahlander <lor...@gm... <mailto: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 <https://lists.sourceforge.net/lists/listinfo/exist-open>
>> 
>