OFBiz › OFBiz - User

Product Search Error when using Postgres database.

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

6 messages Options

rohit

Product Search Error when using Postgres database.

Hi,

I am using the latest SVN with postgres database 8.2.11. When searching for products for certain keyword, its throwing the below error. Did anyone notice such error? Its best to try some random keywords to reproduce the error.

Any help will be appreciated.

Thanks,

Rohit

010-06-13 04:05:37,506 (TP-Processor7) [ SequenceUtil.java:337:INFO ] Got bank of sequenced IDs for [ProductSearchResult]; curSeqId=10010, maxSeqId=10020, bankSize=10
2010-06-13 04:05:37,508 (TP-Processor7) [ GenericDelegator.java:900:ERROR]
---- exception report ----------------------------------------------------------
Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-13 04:05:37.507(java.sql.Timestamp)][createdTxStamp,2010-06-13 04:05:37.377(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-13 04:05:37.507(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-13 04:05:37.377(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10010(java.lang.String)][searchDate,2010-06-13 04:05:37.412(java.sql.Timestamp)][secondsTotal,0.011(java.lang.Double)][visitId,10015(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)). Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-13 04:05:37.507(java.sql.Timestamp)][createdTxStamp,2010-06-13 04:05:37.377(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-13 04:05:37.507(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-13 04:05:37.377(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10010(java.lang.String)][searchDate,2010-06-13 04:05:37.412(java.sql.Timestamp)][secondsTotal,0.011(java.lang.Double)][visitId,10015(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)
---- cause ---------------------------------------------------------------------
Exception: org.postgresql.util.PSQLException
Message: ERROR: current transaction is aborted, commands ignored until end of transaction block
---- stack trace ---------------------------------------------------------------
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:195)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:419)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:878)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:744)
org.ofbiz.entity.GenericValue.create(GenericValue.java:125)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237)
org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133)
KeywordSearch.run(KeywordSearch.groovy:35)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:270)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2010-06-13 04:05:37,509 (TP-Processor7) [ TransactionUtil.java:370:WARN ]
---- exception report ----------------------------------------------------------
[TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening:
Exception: java.lang.Exception
Message: Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-13 04:05:37.507(java.sql.Timestamp)][createdTxStamp,2010-06-13 04:05:37.377(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-13 04:05:37.507(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-13 04:05:37.377(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10010(java.lang.String)][searchDate,2010-06-13 04:05:37.412(java.sql.Timestamp)][secondsTotal,0.011(java.lang.Double)][visitId,10015(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)). Rolling back transaction.
---- stack trace ---------------------------------------------------------------

saanjhi.com

Jacques Le Roux

Re: Product Search Error when using Postgres database.

Administrator

I can' reproduce on the trunk demo (Derby on Ubuntu) nor locally (Postgres 8.4 on XP)
Have you a specific reproductible keyword?

Jacques

rohit wrote:

> Hi,
>
> I am using the latest SVN with postgres database 8.2.11. When searching for
> products for certain keyword, its throwing the below error. Did anyone
> notice such error? Its best to try some random keywords to reproduce the
> error.
>
> Any help will be appreciated.
>
> Thanks,
>
> Rohit
>
>
> 010-06-13 04:05:37,506 (TP-Processor7) [ SequenceUtil.java:337:INFO ]
> Got bank of sequenced IDs for [ProductSearchResult]; curSeqId=10010,
> maxSeqId=10020, bankSize=10
> 2010-06-13 04:05:37,508 (TP-Processor7) [ GenericDelegator.java:900:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Failure in create operation for entity [ProductSearchResult]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-13
> 04:05:37.507(java.sql.Timestamp)][createdTxStamp,2010-06-13
> 04:05:37.377(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-13
> 04:05:37.507(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-13
> 04:05:37.377(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10010(java.lang.String)][searchDate,2010-06-13
> 04:05:37.412(java.sql.Timestamp)][secondsTotal,0.011(java.lang.Double)][visitId,10015(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)). Rolling back
> transaction.
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-13
> 04:05:37.507(java.sql.Timestamp)][createdTxStamp,2010-06-13
> 04:05:37.377(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-13
> 04:05:37.507(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-13
> 04:05:37.377(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10010(java.lang.String)][searchDate,2010-06-13
> 04:05:37.412(java.sql.Timestamp)][secondsTotal,0.011(java.lang.Double)][visitId,10015(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block))
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.postgresql.util.PSQLException
> Message: ERROR: current transaction is aborted, commands ignored until end
> of transaction block
> ---- stack trace
> ---------------------------------------------------------------
> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
> commands ignored until end of transaction block
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:195)
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:419)
> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:878)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:744)
> org.ofbiz.entity.GenericValue.create(GenericValue.java:125)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237)
> org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
> org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown
> Source)
> org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133)
> KeywordSearch.run(KeywordSearch.groovy:35)
> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:270)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2010-06-13 04:05:37,509 (TP-Processor7) [ TransactionUtil.java:370:WARN ]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
> stack trace shows where this is happening:
> Exception: java.lang.Exception
> Message: Failure in create operation for entity [ProductSearchResult]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-13
> 04:05:37.507(java.sql.Timestamp)][createdTxStamp,2010-06-13
> 04:05:37.377(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-13
> 04:05:37.507(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-13
> 04:05:37.377(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10010(java.lang.String)][searchDate,2010-06-13
> 04:05:37.412(java.sql.Timestamp)][secondsTotal,0.011(java.lang.Double)][visitId,10015(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)). Rolling back
> transaction.
> ---- stack trace
> ---------------------------------------------------------------

rohit

Re: Product Search Error when using Postgres database.

it was showing for the keyword 'giz'.

u mentioned that you are using postgres 8.4, do we necessarily have to use 8.4. I am getting the error when using 8.2.

Does the SQL generated as shown in the error seem correct to you.

Thanks,

Rohit

saanjhi.com

Jacques Le Roux

Re: Product Search Error when using Postgres database.

Administrator

No, it's only that I'm using 8.4 locally

giz returns results here and on trunk demo (and stable), just tested

Jacques

rohit wrote:

> it was showing for the keyword 'giz'.
>
> u mentioned that you are using postgres 8.4, do we necessarily have to use
> 8.4. I am getting the error when using 8.2.
>
> Does the SQL generated as shown in the error seem correct to you.
>
> Thanks,
>
> Rohit

rohit

Re: Product Search Error when using Postgres database.

does the error log, provide any help or point to any potential problem. I spent the whole day today to resolve this but no success yet.

I also updated postgres to 8.4 and the jdbc driver and did the ant run-install. to freshly populate the database but no help.

I guess its more of an environment issue, than with the code. I am using jdk 1.6-17, postgres 8.4 and postgres8.4-jdbc4, on FC-8.

If u get any pointers, from the log please do let me know.

Thanks,

Rohit

saanjhi.com

Jacques Le Roux

Re: Product Search Error when using Postgres database.

Administrator

I'd try with the same instance but with another DB: Derby is at hand

Jacques

From: "rohit" <[hidden email]>

> does the error log, provide any help or point to any potential problem. I
> spent the whole day today to resolve this but no success yet.
>
> I also updated postgres to 8.4 and the jdbc driver and did the ant
> run-install. to freshly populate the database but no help.
>
> I guess its more of an environment issue, than with the code. I am using jdk
> 1.6-17, postgres 8.4 and postgres8.4-jdbc4, on FC-8.
>
> If u get any pointers, from the log please do let me know.
>
> Thanks,
>
> Rohit
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Product-Search-Error-when-using-Postgres-database-tp2253277p2253573.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>