??????Aw: ??????Solr 5.5.0 Configure global jndi DS for dataimport
I just tested, the success of the need to amend two points
1??the jetty.xml comment out
2??Jndi's name is this: java:comp/env/jdbc/mysqlds
The complete steps are as follows:
jetty.xml
java:comp/env/jdbc/mysqlds
jdbc:mysql://localhost:3306/ka_ka
root
123456
db-data-config.xml
I wish you success
-- --
??: "Per Newgro";<per.new...@gmx.ch>;
: 2017??2??7??(??) 8:44
??: "solr-user"<solr-user@lucene.apache.org>;
: Aw: ??Solr 5.5.0 Configure global jndi DS for dataimport
Maybe someone is interested in solution:
AND
java:comp/env/jdbc/myds
Both need the complete lookup name.
Per
> Gesendet: Dienstag, 07. Februar 2017 um 10:29 Uhr
> Von: "Per Newgro" <per.new...@gmx.ch>
> An: solr-user@lucene.apache.org
> Betreff: Aw: ??Solr 5.5.0 Configure global jndi DS for dataimport
>
> Changed db-data-config.xml
>
>
> This leads to
> Caused by: javax.naming.NameNotFoundException; remaining name 'env/jdbc/myds'
> at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:538)
> at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:569)
> at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:584)
> at
> org.eclipse.jetty.jndi.java.javaRootURLContext.lookup(javaRootURLContext.java:108)
> at javax.naming.InitialContext.lookup(InitialContext.java:417)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$1.getFromJndi(JdbcDataSource.java:250)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:182)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:172)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:463)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.(JdbcDataSource.java:309)
> ... 39 more
>
> Do i need to install other libraries? Do i need to enable jndi?
> Can i configure something useful for logging?
>
> Thanks for your support
> Per
>
> > Gesendet: Dienstag, 07. Februar 2017 um 10:02 Uhr
> > Von: alias <524839...@qq.com>
> > An: solr-user <solr-user@lucene.apache.org>
> > Betreff: ??Solr 5.5.0 Configure global jndi DS for dataimport
> >
> > jndiName="java:comp/env/jdbc/myds"
> >
> >
> > ---------- ???? --
> > ??: "Per Newgro";<per.new...@gmx.ch>;
> > : 2017??2??7??(??) 4:47
> > ??: "solr-user-group"<solr-user@lucene.apache.org>;
> >
> > : Solr 5.5.0 Configure global jndi DS for dataimport
> >
> >
> >
> > Hello,
> >
> > I would like to configure a JNDI datasource for use in dataimport. From the
> > documentation it shall be possible and easy.
> >
> > My environment:
> > Debian
> > OpenJDK Runtime Environment (build 1.8.0_111-8u111-b14-2~bpo8+1-b14)
> > Solr 5.5.0 downloaded and installed as service in /opt/solr
> > Installed core in /var/lib/solr/data/collection1
> >
> > Solr is running and core can be managed.
> >
> > Put into /opt/solr/server/lib
> > jetty-jndi-9.2.13.v20150730.jar
> > jetty-plus-9.2.13.v20150730.jar
> > Put into /opt/solr/server/lib/ext
> > sqljdbc4-4.0.jar
> >
> > /opt/solr/server/etc/jetty.xml
> > ...
> >
> >
> > jdbc/myds
> >
> >
> > > name="URL">jdbc:sqlserver://;databaseName=dbname;
> > user
> > password
> >
> >
> >
> > ...
> >
> > /var/lib/solr/data/collection1/conf/db-data-config.xml
> >
> >
> >
> > > name="bodyshop"
> > query="SELECT b.id as ID,
> > customer_number as CUSTOMER_NUMBER,
> > customer_name as CUSTOMER_NAME
> > FROM schema.body_shops b
> >WHERE '${dataimporter.request.clean}' != 'false'
> > OR b.last_modified >
> > '${dataimporter.last_index_time}'">
> > ...
> >
> > But all i get is an exception
> > Caused by
Aw: 回复：Solr 5.5.0 Configure global jndi DS for dataimport
Maybe someone is interested in solution:
AND
java:comp/env/jdbc/myds
Both need the complete lookup name.
Per
> Gesendet: Dienstag, 07. Februar 2017 um 10:29 Uhr
> Von: "Per Newgro" <per.new...@gmx.ch>
> An: solr-user@lucene.apache.org
> Betreff: Aw: 回复：Solr 5.5.0 Configure global jndi DS for dataimport
>
> Changed db-data-config.xml
>
>
> This leads to
> Caused by: javax.naming.NameNotFoundException; remaining name 'env/jdbc/myds'
> at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:538)
> at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:569)
> at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:584)
> at
> org.eclipse.jetty.jndi.java.javaRootURLContext.lookup(javaRootURLContext.java:108)
> at javax.naming.InitialContext.lookup(InitialContext.java:417)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$1.getFromJndi(JdbcDataSource.java:250)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:182)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:172)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:463)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.(JdbcDataSource.java:309)
> ... 39 more
>
> Do i need to install other libraries? Do i need to enable jndi?
> Can i configure something useful for logging?
>
> Thanks for your support
> Per
>
> > Gesendet: Dienstag, 07. Februar 2017 um 10:02 Uhr
> > Von: alias <524839...@qq.com>
> > An: solr-user <solr-user@lucene.apache.org>
> > Betreff: 回复：Solr 5.5.0 Configure global jndi DS for dataimport
> >
> > jndiName="java:comp/env/jdbc/myds"
> >
> >
> > ------ 原始邮件 ----------
> > 发件人: "Per Newgro";<per.new...@gmx.ch>;
> > 发送时间: 2017年2月7日(星期二) 下午4:47
> > 收件人: "solr-user-group"<solr-user@lucene.apache.org>;
> >
> > 主题: Solr 5.5.0 Configure global jndi DS for dataimport
> >
> >
> >
> > Hello,
> >
> > I would like to configure a JNDI datasource for use in dataimport. From the
> > documentation it shall be possible and easy.
> >
> > My environment:
> > Debian
> > OpenJDK Runtime Environment (build 1.8.0_111-8u111-b14-2~bpo8+1-b14)
> > Solr 5.5.0 downloaded and installed as service in /opt/solr
> > Installed core in /var/lib/solr/data/collection1
> >
> > Solr is running and core can be managed.
> >
> > Put into /opt/solr/server/lib
> > jetty-jndi-9.2.13.v20150730.jar
> > jetty-plus-9.2.13.v20150730.jar
> > Put into /opt/solr/server/lib/ext
> > sqljdbc4-4.0.jar
> >
> > /opt/solr/server/etc/jetty.xml
> > ...
> >
> >
> > jdbc/myds
> >
> >
> > > name="URL">jdbc:sqlserver://;databaseName=dbname;
> > user
> > password
> >
> >
> >
> > ...
> >
> > /var/lib/solr/data/collection1/conf/db-data-config.xml
> >
> >
> >
> > > name="bodyshop"
> > query="SELECT b.id as ID,
> > customer_number as CUSTOMER_NUMBER,
> > customer_name as CUSTOMER_NAME
> > FROM schema.body_shops b
> >WHERE '${dataimporter.request.clean}' != 'false'
> > OR b.last_modified >
> > '${dataimporter.last_index_time}'">
> > ...
> >
> > But all i get is an exception
> > Caused by: javax.naming.NameNotFoundException; remaining name 'jdbc/myds'
> > at
> > org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:487)
> > at
> > org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:533)
> > at javax.naming.InitialContext.lookup(InitialContext.java:417)
> > at
> > org.apache.solr.handler.dataimport.JdbcDataSource$1.getFromJndi(JdbcDataSource.java:250)
> > at
> > org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:182)
> > at
> > org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:172)
> > at
> > org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:463)
> > at
> > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.(JdbcDataSource.java:309)
> > ... 39 more
> >
> > I've searched across the web for a solution but all i found did not work.
> > It would be great if someone could help me out.
> >
> > Thanks
> > Per
>
Aw: 回复：Solr 5.5.0 Configure global jndi DS for dataimport
Changed db-data-config.xml
This leads to
Caused by: javax.naming.NameNotFoundException; remaining name 'env/jdbc/myds'
at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:538)
at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:569)
at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:584)
at
org.eclipse.jetty.jndi.java.javaRootURLContext.lookup(javaRootURLContext.java:108)
at javax.naming.InitialContext.lookup(InitialContext.java:417)
at
org.apache.solr.handler.dataimport.JdbcDataSource$1.getFromJndi(JdbcDataSource.java:250)
at
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:182)
at
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:172)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:463)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.(JdbcDataSource.java:309)
... 39 more
Do i need to install other libraries? Do i need to enable jndi?
Can i configure something useful for logging?
Thanks for your support
Per
> Gesendet: Dienstag, 07. Februar 2017 um 10:02 Uhr
> Von: alias <524839...@qq.com>
> An: solr-user <solr-user@lucene.apache.org>
> Betreff: 回复：Solr 5.5.0 Configure global jndi DS for dataimport
>
> jndiName="java:comp/env/jdbc/myds"
>
>
> -- 原始邮件 --
> 发件人: "Per Newgro";<per.new...@gmx.ch>;
> 发送时间: 2017年2月7日(星期二) 下午4:47
> 收件人: "solr-user-group"<solr-user@lucene.apache.org>;
>
> 主题: Solr 5.5.0 Configure global jndi DS for dataimport
>
>
>
> Hello,
>
> I would like to configure a JNDI datasource for use in dataimport. From the
> documentation it shall be possible and easy.
>
> My environment:
> Debian
> OpenJDK Runtime Environment (build 1.8.0_111-8u111-b14-2~bpo8+1-b14)
> Solr 5.5.0 downloaded and installed as service in /opt/solr
> Installed core in /var/lib/solr/data/collection1
>
> Solr is running and core can be managed.
>
> Put into /opt/solr/server/lib
> jetty-jndi-9.2.13.v20150730.jar
> jetty-plus-9.2.13.v20150730.jar
> Put into /opt/solr/server/lib/ext
> sqljdbc4-4.0.jar
>
> /opt/solr/server/etc/jetty.xml
> ...
>
>
> jdbc/myds
>
>
> name="URL">jdbc:sqlserver://;databaseName=dbname;
> user
> password
>
>
>
> ...
>
> /var/lib/solr/data/collection1/conf/db-data-config.xml
>
>
>
> name="bodyshop"
> query="SELECT b.id as ID,
> customer_number as CUSTOMER_NUMBER,
> customer_name as CUSTOMER_NAME
> FROM schema.body_shops b
>WHERE '${dataimporter.request.clean}' != 'false'
> OR b.last_modified >
> '${dataimporter.last_index_time}'">
> ...
>
> But all i get is an exception
> Caused by: javax.naming.NameNotFoundException; remaining name 'jdbc/myds'
> at
> org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:487)
> at
> org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:533)
> at javax.naming.InitialContext.lookup(InitialContext.java:417)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$1.getFromJndi(JdbcDataSource.java:250)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:182)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:172)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:463)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.(JdbcDataSource.java:309)
> ... 39 more
>
> I've searched across the web for a solution but all i found did not work.
> It would be great if someone could help me out.
>
> Thanks
> Per
??????Solr 5.5.0 Configure global jndi DS for dataimport
jndiName="java:comp/env/jdbc/myds" -- -- ??: "Per Newgro";<per.new...@gmx.ch>; : 2017??2??7??(??) 4:47 ??: "solr-user-group"<solr-user@lucene.apache.org>; : Solr 5.5.0 Configure global jndi DS for dataimport Hello, I would like to configure a JNDI datasource for use in dataimport. From the documentation it shall be possible and easy. My environment: Debian OpenJDK Runtime Environment (build 1.8.0_111-8u111-b14-2~bpo8+1-b14) Solr 5.5.0 downloaded and installed as service in /opt/solr Installed core in /var/lib/solr/data/collection1 Solr is running and core can be managed. Put into /opt/solr/server/lib jetty-jndi-9.2.13.v20150730.jar jetty-plus-9.2.13.v20150730.jar Put into /opt/solr/server/lib/ext sqljdbc4-4.0.jar /opt/solr/server/etc/jetty.xml ... jdbc/myds jdbc:sqlserver://;databaseName=dbname; user password ... /var/lib/solr/data/collection1/conf/db-data-config.xml ... But all i get is an exception Caused by: javax.naming.NameNotFoundException; remaining name 'jdbc/myds' at org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:487) at org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:533) at javax.naming.InitialContext.lookup(InitialContext.java:417) at org.apache.solr.handler.dataimport.JdbcDataSource$1.getFromJndi(JdbcDataSource.java:250) at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:182) at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:172) at org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:463) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.(JdbcDataSource.java:309) ... 39 more I've searched across the web for a solution but all i found did not work. It would be great if someone could help me out. Thanks Per
Solr 5.5.0 Configure global jndi DS for dataimport
Hello, I would like to configure a JNDI datasource for use in dataimport. From the documentation it shall be possible and easy. My environment: Debian OpenJDK Runtime Environment (build 1.8.0_111-8u111-b14-2~bpo8+1-b14) Solr 5.5.0 downloaded and installed as service in /opt/solr Installed core in /var/lib/solr/data/collection1 Solr is running and core can be managed. Put into /opt/solr/server/lib jetty-jndi-9.2.13.v20150730.jar jetty-plus-9.2.13.v20150730.jar Put into /opt/solr/server/lib/ext sqljdbc4-4.0.jar /opt/solr/server/etc/jetty.xml ... jdbc/myds jdbc:sqlserver://;databaseName=dbname; user password ... /var/lib/solr/data/collection1/conf/db-data-config.xml ... But all i get is an exception Caused by: javax.naming.NameNotFoundException; remaining name 'jdbc/myds' at org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:487) at org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:533) at javax.naming.InitialContext.lookup(InitialContext.java:417) at org.apache.solr.handler.dataimport.JdbcDataSource$1.getFromJndi(JdbcDataSource.java:250) at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:182) at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:172) at org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:463) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.(JdbcDataSource.java:309) ... 39 more I've searched across the web for a solution but all i found did not work. It would be great if someone could help me out. Thanks Per
