Has anyone implemented Faceted Search using SOLR?

[praveen.agrawal]

Robert,

Find the java files SolrServices.java and SolrEvents.java under src
directory of osafe component.

Regards,
Praveen Agrawal

On Wed, Jul 11, 2012 at 11:53 PM, Robert G. <[hidden email]> wrote:

> thank you, im allrady searching for the java classes, but I cannot find :)
> can you help on it (location of these files), I think the rest I get by my
> self
>
> many thanks!
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4634704.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Robert Gan]

great, thank you...I only checked the osafe-admin :) great!

[barkavi]

Wow... Happy to find the integrated code for Apache Ofbiz and Solr.

I have followed the steps given in the link http://bigfish.salmonllc.com/bfDownload.html

When I run the command 'ant run-install-seed', I get the following error

 [java] 2012-10-10 13:22:26,982 (main) [       DatabaseUtil.java:1060:ERROR] Unable to establish a connection with the database... Error was:java.sql.SQLException: Unable to acquire a new connection from the pool
 [java] 2012-10-10 13:22:26,982 (main) [       DatabaseUtil.java:144:ERROR] Could not get table name information from the database, aborting.
 [java] 2012-10-10 13:22:26,982 (main) [   GenericDelegator.java:260:INFO ] Delegator "default" initializing helper "localderbytenant" for entity group "org.ofbiz.tenant".
 [java] 2012-10-10 13:22:26,982 (main) [   GenericDelegator.java:270:INFO ] Doing database check as requested in entityengine.xml with addMissing=true
 [java] 2012-10-10 13:22:26,982 (main) [       DatabaseUtil.java:1060:ERROR] Unable to establish a connection with the database... Error was:java.sql.SQLException: Unable to acquire a new connection from the pool
 [java] 2012-10-10 13:22:26,982 (main) [       DatabaseUtil.java:144:ERROR] Could not get table name information from the database, aborting.
 [java] 2012-10-10 13:24:29,202 (main) [  GenericDispatcher.java:69 :INFO ] Creating new dispatcher [entity-default] (main)
 [java] 2012-10-10 13:24:29,202 (main) [  ServiceDispatcher.java:88 :INFO ] [ServiceDispatcher] : Creating new instance.
 [java] 2012-10-10 13:24:29,499 (main) [ ServiceGroupReader.java:88 :INFO ] Loaded [1] Group definitions from file:/C:/Ofbiz/apache-ofbiz/framework/common/servicedef/groups_test.xml
 [java] 2012-10-10 13:24:29,514 (main) [ ServiceGroupReader.java:88 :INFO ] Loaded [4] Group definitions from file:/C:/Ofbiz/apache-ofbiz/framework/entityext/servicedef/groups.xml
 [java] 2012-10-10 13:24:29,561 (main) [ ServiceGroupReader.java:88 :INFO ] Loaded [2] Group definitions from file:/C:/Ofbiz/apache-ofbiz/applications/workeffort/servicedef/service_groups.xml
 
 [java] 2012-10-10 13:24:33,405 (main) [      EntityEcaUtil.java:128:INFO ] Loaded [1] Entity ECA definitions from C:/Ofbiz/apache-ofbiz/applications/commonext/entitydef/eecas.xml in loader main
 [java] 2012-10-10 13:24:33,780 (main) [EntityDataLoadContainer.java:374:INFO ] =-=-=-=-=-=-= Doing a data load with the following files:
 [java] 2012-10-10 13:24:33,780 (main) [EntityDataLoadContainer.java:376:INFO ] file:/C:/Ofbiz/apache-ofbiz/framework/security/data/SecurityData.xml
 [java] 2012-10-10 13:24:33,780 (main) [EntityDataLoadContainer.java:376:INFO ] file:/C:/Ofbiz/apache-ofbiz/framework/common/data/CommonSecurityData.xml
 [java] 2012-10-10 13:24:33,780 (main) [EntityDataLoadContainer.java:376:INFO ] file:/C:/Ofbiz/apache-ofbiz/framework/common/data/CommonTypeData.xml
 [java] 2012-10-10 13:24:33,780 (main) [EntityDataLoadContainer.java:376:INFO ] file:/C:/Ofbiz/apache-ofbiz/framework/common/data/CountryCodeData.xml
 [java] 2012-10-10 13:24:33,780 (main) [EntityDataLoadContainer.java:376:INFO ] file:/C:/Ofbiz/apache-ofbiz/framework/common/data/CurrencyData.xml
 [java] 2012-10-10 13:24:33,780 (main) [EntityDataLoadContainer.java:376:INFO ] file:/C:/Ofbiz/apache-ofbiz/framework/common/data/GeoData.xml
 
 [java] 2012-10-10 13:24:41,686 (main) [    EntitySaxReader.java:258:INFO ] Transaction Timeout set to 2 hours (7200 seconds)
 [java] 2012-10-10 13:24:41,765 (main) [    EntitySaxReader.java:277:INFO ] Finished 7 values from file:/C:/Ofbiz/apache-ofbiz/framework/common/data/PeriodData.xml
 [java] 2012-10-10 13:24:41,765 (main) [    EntitySaxReader.java:220:INFO ] Beginning import from URL: file:/C:/Ofbiz/apache-ofbiz/framework/common/data/DimensionTypeData.xml
 [java] 2012-10-10 13:24:41,765 (main) [    EntitySaxReader.java:258:INFO ] Transaction Timeout set to 2 hours (7200 seconds)
 [java] 2012-10-10 13:24:41,780 (main) [   GenericDelegator.java:1447:ERROR]
 [java] ---- exception report ----------------------------------------------------------
 [java] Failure in storeAll operation: org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. (Unable to acquire a new connection from the pool). Rolling back transaction.
 [java] Exception: org.ofbiz.entity.GenericDataSourceException
 [java] Message: Unable to esablish a connection with the database. (Unable to acquire a new connection from the pool)
 [java] ---- cause ---------------------------------------------------------------------
 [java] Exception: java.sql.SQLException
 [java] Message: Unable to acquire a new connection from the pool
 [java] ---- cause ---------------------------------------------------------------------
 [java] Exception: java.lang.NullPointerException
 [java] Message: connection is null
 [java] ---- stack trace ---------------------------------------------------------------
 [java] java.lang.NullPointerException: connection is null
 [java] org.apache.commons.dbcp.managed.TransactionRegistry.registerConnection(TransactionRegistry.java:63)
 [java] org.apache.commons.dbcp.managed.LocalXAConnectionFactory.createConnection(LocalXAConnectionFactory.java:68)
 [java] org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
 [java] org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
 [java] org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:117)
 [java] org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55)
 [java] org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
 [java] org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:55)
 [java] org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:135)
 [java] org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:84)
 [java] org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:97)
 [java] org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:85)
 [java] org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:249)
 [java] org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:355)
 [java] org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:339)
 [java] org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:517)
 [java] org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:488)
 [java] org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:79)
 [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1404)
 [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285)
 [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264)
 [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221)
 [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213)
 [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:383)
 [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100)
 [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
 [java] org.ofbiz.base.start.Start.startServer(Start.java:322)
 [java] org.ofbiz.base.start.Start.start(Start.java:326)
 [java] org.ofbiz.base.start.Start.main(Start.java:411)
 [java] --------------------------------------------------------------------------------
 
 [java] 2012-10-10 13:24:47,936 (main) [    EntitySaxReader.java:258:INFO ] Transaction Timeout set to 2 hours (7200 seconds)
 [java] 2012-10-10 13:24:48,046 (main) [      EntityEcaRule.java:119:INFO ] Running Entity ECA Service: clearAssociatedRenderCache, triggered by rule on Entity: ElectronicText
 [java] 2012-10-10 13:24:48,218 (main) [     AbstractEngine.java:73 :INFO ] Loaded Service Locations : {main-rmi=rmi://localhost:1099/RMIDispatcher, main-http=http://localhost:8080/webtools/control/httpService, entity-sync-rmi=rmi://localhost:1099/RMIDispatcher, entity-sync-http=http://localhost:8080/webtools/control/httpService, rita-rmi=rmi://localhost:1099/RMIDispatcher, eedcc-test=http://localhost:8080/webtools/control/httpService}
 [java] 2012-10-10 13:24:48,452 (main) [   FreeMarkerWorker.java:110:INFO ] loading properties: file:/C:/Ofbiz/apache-ofbiz/framework/webapp/config/freemarkerTransforms.properties



Can you please let me know why do I get this error.

On starting my Ofbiz, http://localhost:8080/online/control/main does not load.

https://localhost:8443/webtools/control/main and https://localhost:8443/osafe-admin/control/main are loading.

[Paul Piper]

Perhaps, you may be interested in this: https://issues.apache.org/jira/browse/OFBIZ-5042

[barkavi]

It was very helpful. Thanks :)

[Paul Piper]

Hi,

there is a fully committed solr component available for you (no need for
third party plugins): https://issues.apache.org/jira/browse/OFBIZ-5042

Just download and run. It comes with an example schema.xml that is set up
for facetted search and several functions that make use of it.



--
View this message in context: http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4637967.html
Sent from the OFBiz - User mailing list archive at Nabble.com.