[
https://issues.apache.org/jira/browse/SOLR-10495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15970561#comment-15970561
]
Erick Erickson commented on SOLR-10495:
---------------------------------------
If you have the time energy to submit a patch, that'd be great!
> 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: [email protected]
For additional commands, e-mail: [email protected]
