[jira] [Closed] (SOLR-10495) Loading JDBC driver in custom SearchComponent

["Christian Harke (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SOLR-10495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Christian Harke closed SOLR-10495.
----------------------------------
       Resolution: Not A Problem
    Fix Version/s: 6.4.2

Finally, it turned out that it's a user level issue (it was my own fault). I wasn't able to pass the correct parameter values to DriverManager.getConnection().

Actually, I was misled by the error message of the exception thrown. Never mind!

> Loading JDBC driver in custom SearchComponent
> ---------------------------------------------
>
>                 Key: SOLR-10495
>                 URL: https://issues.apache.org/jira/browse/SOLR-10495
>             Project: Solr
>          Issue Type: Wish
>      Security Level: Public(Default Security Level. Issues are Public) 
>          Components: SearchComponents - other
>    Affects Versions: 6.4.2
>         Environment: Docker Container (https://store.docker.com/images/solr)
>            Reporter: Christian Harke
>            Priority: Minor
>              Labels: newbie
>             Fix For: 6.4.2
>
>
> I'd like to access a postgres database from my custom SearchComponent but unfortunately, I get the following error:
> {noformat}
> java.sql.SQLException: No suitable driver found for postgres
>         at java.sql.DriverManager.getConnection(DriverManager.java:689)
> 	at java.sql.DriverManager.getConnection(DriverManager.java:247)
> 	at ch.guidelines.util.SimpleDataSource.getConnection(SimpleDataSource.java:50)
> ...
> {noformat}
> ... when I try to connect to the database using:
> {code:title=SimpleDataSource.java}
> private String dbUrl = "jdbc:postgresql://db/mydb";
> public Connection getConnection(String dbUser, String dbPasswd) throws SQLException {
>     this.dbUser = dbUser;
>     this.dbPasswd = dbPasswd;
>     this.conn = DriverManager.getConnection(dbUrl, dbUser, dbPasswd); // line 50
>     return conn;
> }
> {code}
> I already use the DataImportHandler using the Postgres JDBC driver successfully. I tried putting the driver's jar in different locations:
> - /opt/solr/dist (with added <lib ... /> entry in solrconfig.xml)
> - /opt/solr/lib
> - /opt/solr/server/lib
> - /opt/solr/server/lib/ext
> - /opt/solr/server/solr/lib (lib-folder in the solr.solr.home directory)
> But nothing worked so far... How can I get the driver loaded in my custom SearchComponent?
> I'd really appreciate your help.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org