Issue fixed by putting the jdbc jar file just above the Download directory, i.e. in my user’s home directory ; then I could see it while trying and adding it
Eventually, Matt’s screen copy helped me
Thx all
> Le 14 févr. 2021 à 23:20, Claude Rousseau via Squirrel-sql-users <squ...@li...> a écrit :
>
> Thx Gerd, but this is just what I’m doing and which does not work
>
>> Le 14 févr. 2021 à 22:18, Gerd Wagner <ger...@t-... <mailto:ger...@t-...>> a écrit :
>>
>> The best way to make a JDBC driver available in SQuirreL is to put the driver jar(s) some place outside of the SQuirreL installation directory. Then add the driver jar(s) to the "Extra class path" of SQuirreL's driver definition: Go to drivers list --> select a driver and choose "Modify driver" from the right mouse menu --> tab "Extra Class Path" --> button "Add".
>>
>> Gerd
>>
>> Am 14.02.21 um 20:45 schrieb Claude Rousseau via Squirrel-sql-users:
>>> I don’t understand how you can specify the specific jar file
>>>> Le 14 févr. 2021 à 18:57, Matt Ferreira <de...@ya... <mailto:de...@ya...> <mailto:de...@ya... <mailto:de...@ya...>>> a écrit :
>>>>
>>>> That’s the issue. I’ve never had luck with specifying the path. I specify the specific jar file then do list drivers.
>>>>
>>>> Sent from my mobile. Please excuse typos and brevity.
>>>>
>>>>> On Feb 14, 2021, at 12:53 PM, Claude Rousseau <cla...@me... <mailto:cla...@me...> <mailto:cla...@me... <mailto:cla...@me...>>> wrote:
>>>>>
>>>>> Hello
>>>>>
>>>>> I’ve left the jar driver in my Downloads folder (I’d try to move it to desktop, but no change)
>>>>>
>>>>> My Java version is:
>>>>> imac:~ cglr$ java -version
>>>>> java version "11.0.10" 2021-01-19 LTS
>>>>> Java(TM) SE Runtime Environment 18.9 (build 11.0.10+8-LTS-162)
>>>>> Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.10+8-LTS-162, mixed mode)
>>>>>
>>>>> Which plugin are you talking about?
>>>>> I don’t understand what you mean about class path: I’ve added Download directory, then clicked on List drivers ; isn’t it the right way to, proceed?
>>>>>
>>>>> Thx
>>>>>
>>>>>> Le 14 févr. 2021 à 18:28, Matt F <de...@ya... <mailto:de...@ya...> <mailto:de...@ya... <mailto:de...@ya...>>> a écrit :
>>>>>>
>>>>>> Hi Claude,
>>>>>> I tried to replicate this on my setup:
>>>>>> MacOs 11.1 (Big Sur)
>>>>>> I used the 4.1.0 release of Squirrel , I also installed the postgres plugin, standard and nothing else (side note, the latest snapshot 20210131_2217 failed to launch on my MacOS)
>>>>>>
>>>>>> I downloaded the PostGres Jar, and kept it in Downloads. When I addded it and clicked "List Drivers" the following populated in my Class Name Drop Down :
>>>>>>
>>>>>> org.postgresql.Driver
>>>>>>
>>>>>> So I'm unable to reproduce. The questions I have for you are:
>>>>>> Did you install the Postgres Plugin?
>>>>>> Is the postgres JAR in a location that you have read/write access to (should only need read, but for the purposes of troubleshooting, would make it easier if you had full access) ?
>>>>>> What version of Java do you have :
>>>>>> mattferreira@Matts-Air ~ % java -version
>>>>>> java version "11.0.1" 2018-10-16 LTS
>>>>>> Java(TM) SE Runtime Environment 18.9 (build 11.0.1+13-LTS)
>>>>>> Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.1+13-LTS, mixed mode)
>>>>>> mattferreira@Matts-Air ~ %
>>>>>>
>>>>>>
>>>>>> Without knowing for sure - my guess is You don't have proper access to the postgres jar path and/or the extra class path isn't fully specified. For example, my class path is direct to the JAR file, not the directory the jar file is in (/Users/mattferreira/Downloads/postgressql-42.2.18.jar)
>>>>>>
>>>>>> HTH
>>>>>> mattferreira@Matts-Air ~ % java -version
>>>>>> java version "11.0.1" 2018-10-16 LTS
>>>>>> Java(TM) SE Runtime Environment 18.9 (build 11.0.1+13-LTS)
>>>>>> Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.1+13-LTS, mixed mode)
>>>>>> mattferreira@Matts-Air ~ %
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> ==============================================
>>>>>> Matt Ferreira
>>>>>> de...@ya... <mailto:de...@ya...> <mailto:de...@ya... <mailto:de...@ya...>>
>>>>>>
>>>>>>
>>>>>> On Sunday, February 14, 2021, 06:58:13 AM EST, Claude Rousseau via Squirrel-sql-users <squ...@li... <mailto:squ...@li...> <mailto:squ...@li... <mailto:squ...@li...>>> wrote:
>>>>>>
>>>>>>
>>>>>> Hello
>>>>>>
>>>>>> I’ve installed SquirrelSQL on my Mac (4.1.0)
>>>>>> I’ve downloaded last release of the jdbc driver for PostgreSQL (postgresql-42.2.18.jar)
>>>>>> When adding the driver, in additional class path folder, having selected the folder where this jar is and having clicked on « List drivers », nothing happens, as if Squirrel didn’t find my jar driver.
>>>>>>
>>>>>> What can I do?
>>>>>>
>>>>>> Thx
>>>>>>
>>>>>> Claude Rousseau
>>>>>>
>>>>>> _______________________________________________
>>>>>> Squirrel-sql-users mailing list
>>>>>> Squ...@li... <mailto:Squ...@li...> <mailto:Squ...@li... <mailto:Squ...@li...>>
>>>>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users <https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users> <https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users <https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users>>
>>>>>
>>>>> Claude Rousseau
>>>>>
>>> Claude Rousseau
>>> _______________________________________________
>>> Squirrel-sql-users mailing list
>>> Squ...@li... <mailto:Squ...@li...>
>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
> Claude Rousseau
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Claude Rousseau
|