Erfahrungen mit OFBiz

Dies ist eine kleine Mitschrift zur Installation der aktuellen Version 10.04.02 unter OpenSUSE 12.1. Mein Ziel ist es erste Erfahrungen mit OFBiz zu sammeln um das Framework hinsichtlich eines Anforderungskatalogs evaluieren zu können. Primäres Ziel ist es einen mehrsprachigen Webshop verwalten zu können.

Dokumentation:
Wenn ich Suchergebnisse bzgl. Anleitungen und Hilfen als Grundlage nehme, dann scheint die Plattform im deutschsprachigem Raum nicht weit verbreitet zu sein. Zwei Webseiten dominieren die Suchergebnisse: Die Heimatseite http://ofbiz.apache.org

und www.ofbiz.biz was sich als Anlaufstelle für die deutschsprachige Gemeinde etablieren möchte.

Ein aktuelles Buch scheint es nicht zu geben. Was ich gefunden habe bezieht sich auf Version 09.04 (wobei Version 11.04 kurz vor der Freigabe zu stehen scheint).

Installation:


Ich verwende normalerweise Open JDK (in diesem Fall die 1.6er Version). Allerdings gibt es damit Probleme (was auch gut auf der Webseite dokumentiert ist). Bevor ich eine neue Java-Version einspiele (was Dank Oracles Lizenzpolitik nicht mehr über die zentrale Paketverwaltung läuft) wollte ich es dennoch ausprobieren. Das Ergebnis ist ein Kompilierungsfehler.
Ich probiere es mit Java 7 (jdk1.7.0_05) und komme zu dem gleichen Ergebnis: Compile Error.

Alle guten Dinge sind drei. Und siehe da mit jdk1.6.0_33 lässt sich System über den Befehl ~> ./ant run-install run installieren.

Jetzt muss localhost/catalog aufgerufen werden. Dabei erfolgt eine Umleitung auf die verschlüsselte Seite, bei der man noch das TLS-Zertifikat akzeptieren muss.


Die Anmeldung erfolgt mit username "admin" and password "ofbiz".

Der erste Schritt ist geschafft.

Erste Schritte:
Die Menge an Menüpunkten ist erstmal erschlagend. Ich stoße auf den Punkt "Visual Themes" und wechsle auf ein helleres, da mir das dunkle Thema (Theme) nicht gefällt.

Über die Menüpunkte Anwendungen->Inhalt kann ich mit "Create New Web Site" eine neue Webseite anlegen (gut, die Lokalisierung scheint nicht ganz vollständig zu sein).

Ich gebe der neuen Seite eine ID und einen Namen, setze das "Visual Theme Set" auf "Themes to be used for ECommerce applications" und stelle "Produkt Laden ID" auf "OFBiz E-Commerce Store". Auch wenn ich bei der Ergebnisseite nicht ganz sicher bin ob das funktioniert hat - es hat.

 An dem Punkt komme ich erstmal nicht weiter und beschliße die Dokumentation zu lesen. Aber erstmal schlafen gegen. Also abmelden und kurz darauf noch mal anmelden weil ich doch noch X, Y schauen wollte. Und schon sehe ich, dass irgend etwas nicht stimmen kann: 

Method public java.lang.String org.ofbiz.widget.screen.ScreenRenderer.render(java.lang.String,java.lang.String) throws org.ofbiz.base.util.GeneralException,java.io.IOException,org.xml.sax.SAXException,javax.xml.parsers.ParserConfigurationException threw an exception when invoked on org.ofbiz.widget.screen.ScreenRenderer@24dcf838 with arguments of types [java.lang.String,java.lang.String,] The problematic instruction: ---------- ==> ${screens.render(portlet.screenLocation, portlet.screenName)} [on line 25, column 7 in component://common/webcommon/portal/showPortlet.ftl] ---------- Java backtrace for programmers: ---------- freemarker.template.TemplateModelException: Method public java.lang.String org.ofbiz.widget.screen.ScreenRenderer.render(java.lang.String,java.lang.String) throws org.ofbiz.base.util.GeneralException,java.io.IOException,org.xml.sax.SAXException,javax.xml.parsers.ParserConfigurationException threw an exception when invoked on org.ofbiz.widget.screen.ScreenRenderer@24dcf838 with arguments of types [java.lang.String,java.lang.String,] at freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:134) at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93) at freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at freemarker.core.Expression.getStringValue(Expression.java:93) at freemarker.core.DollarVariable.accept(DollarVariable.java:76) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.Environment.process(Environment.java:189) at org.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:216) at org.ofbiz.widget.screen.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:225) at org.ofbiz.widget.screen.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:270) at org.ofbiz.widget.screen.HtmlWidget.renderWidgetString(HtmlWidget.java:130) at org.ofbiz.widget.screen.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1000) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(ModelScreenWidget.java:575) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:703) at org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:166) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:735) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:295) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:295) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:703) at org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:166) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:735) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:295) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:671) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(ModelScreenWidget.java:575) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:671) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) at org.ofbiz.widget.screen.MacroScreenViewHandler.render(MacroScreenViewHandler.java:104) at org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:846) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:562) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:269) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://projectmgr/widget/TaskScreens.xml#ListTaskContent]: org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in by condition find operation, rolling back transactionorg.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT WORK_EFFORT_ID, PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, ASSIGNED_BY_USER_LOGIN_ID, STATUS_ID, STATUS_DATE_TIME, EXPECTATION_ENUM_ID, DELEGATE_REASON_ENUM_ID, FACILITY_ID, COMMENTS, MUST_RSVP, AVAILABILITY_STATUS_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.WORK_EFFORT_PARTY_ASSIGNMENT WHERE ( AND ((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))) ORDER BY WORK_EFFORT_ID ASC, PARTY_ID ASC (Syntax error: Encountered "AND" at line 1, column 353.) (SQL Exception while executing the following:SELECT WORK_EFFORT_ID, PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, ASSIGNED_BY_USER_LOGIN_ID, STATUS_ID, STATUS_DATE_TIME, EXPECTATION_ENUM_ID, DELEGATE_REASON_ENUM_ID, FACILITY_ID, COMMENTS, MUST_RSVP, AVAILABILITY_STATUS_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.WORK_EFFORT_PARTY_ASSIGNMENT WHERE ( AND ((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))) ORDER BY WORK_EFFORT_ID ASC, PARTY_ID ASC (Syntax error: Encountered "AND" at line 1, column 353.)) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in by condition find operation, rolling back transactionorg.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT WORK_EFFORT_ID, PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, ASSIGNED_BY_USER_LOGIN_ID, STATUS_ID, STATUS_DATE_TIME, EXPECTATION_ENUM_ID, DELEGATE_REASON_ENUM_ID, FACILITY_ID, COMMENTS, MUST_RSVP, AVAILABILITY_STATUS_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.WORK_EFFORT_PARTY_ASSIGNMENT WHERE ( AND ((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))) ORDER BY WORK_EFFORT_ID ASC, PARTY_ID ASC (Syntax error: Encountered "AND" at line 1, column 353.) (SQL Exception while executing the following:SELECT WORK_EFFORT_ID, PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, ASSIGNED_BY_USER_LOGIN_ID, STATUS_ID, STATUS_DATE_TIME, EXPECTATION_ENUM_ID, DELEGATE_REASON_ENUM_ID, FACILITY_ID, COMMENTS, MUST_RSVP, AVAILABILITY_STATUS_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.WORK_EFFORT_PARTY_ASSIGNMENT WHERE ( AND ((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))) ORDER BY WORK_EFFORT_ID ASC, PARTY_ID ASC (Syntax error: Encountered "AND" at line 1, column 353.))) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:421) at org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(ModelScreenWidget.java:575) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:295) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) at sun.reflect.GeneratedMethodAccessor162.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at freemarker.ext.beans.BeansWrapper.invokeMethod(BeansWrapper.java:840) at freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:104) ... 78 more Caused by: org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in by condition find operation, rolling back transactionorg.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT WORK_EFFORT_ID, PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, ASSIGNED_BY_USER_LOGIN_ID, STATUS_ID, STATUS_DATE_TIME, EXPECTATION_ENUM_ID, DELEGATE_REASON_ENUM_ID, FACILITY_ID, COMMENTS, MUST_RSVP, AVAILABILITY_STATUS_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.WORK_EFFORT_PARTY_ASSIGNMENT WHERE ( AND ((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))) ORDER BY WORK_EFFORT_ID ASC, PARTY_ID ASC (Syntax error: Encountered "AND" at line 1, column 353.) (SQL Exception while executing the following:SELECT WORK_EFFORT_ID, PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, ASSIGNED_BY_USER_LOGIN_ID, STATUS_ID, STATUS_DATE_TIME, EXPECTATION_ENUM_ID, DELEGATE_REASON_ENUM_ID, FACILITY_ID, COMMENTS, MUST_RSVP, AVAILABILITY_STATUS_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.WORK_EFFORT_PARTY_ASSIGNMENT WHERE ( AND ((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))) ORDER BY WORK_EFFORT_ID ASC, PARTY_ID ASC (Syntax error: Encountered "AND" at line 1, column 353.)) at org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:159) at org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:131) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:387) ... 90 more Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT WORK_EFFORT_ID, PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, ASSIGNED_BY_USER_LOGIN_ID, STATUS_ID, STATUS_DATE_TIME, EXPECTATION_ENUM_ID, DELEGATE_REASON_ENUM_ID, FACILITY_ID, COMMENTS, MUST_RSVP, AVAILABILITY_STATUS_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.WORK_EFFORT_PARTY_ASSIGNMENT WHERE ( AND ((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))) ORDER BY WORK_EFFORT_ID ASC, PARTY_ID ASC (Syntax error: Encountered "AND" at line 1, column 353.) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:374) at org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:733) at org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:139) at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1727) at org.ofbiz.entity.finder.ListFinder.runFind(ListFinder.java:216) at org.ofbiz.minilang.method.entityops.EntityCondition.exec(EntityCondition.java:57) at org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:909) at org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:737) at org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:158) at org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:140) at org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:78) at org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:53) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:396) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:224) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:163) at org.ofbiz.widget.screen.ModelScreenAction$Service.runAction(ModelScreenAction.java:496) at org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:220) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) ... 90 more Caused by: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "AND" at line 1, column 353. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source) at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:291) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:291) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:362) ... 108 more Caused by: java.sql.SQLException: Syntax error: Encountered "AND" at line 1, column 353. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 124 more Caused by: ERROR 42X01: Syntax error: Encountered "AND" at line 1, column 353. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) ... 118 more

 

11.04 (vor Freigabe)

Jetzt muss ich mir auch noch die 11.04 anschauen, obwohl diese Version noch nicht freigeben ist.

Die Sourcen gibt es sowohl über git als auch über SVN. Wobei die Basis SVN ist.

http://svn.apache.org/repos/asf/ofbiz/branches/release11.04

Nach dem Laden der Quellen im Hauptverzeichnis ant aufrufen (default target ist build).

~> ant

Nun gilt es ein Datenset für Demonstrationsszwecke zu installieren
~> ant run-install
oder
~> java -jar ofbiz.jar -install

Für Produktionsumgebungen sollte statt dessen der Basisdatensatz geladen werden.
~>ant run-install-extseed
oder
~> java -jar ofbiz.jar -install -readers=seed,ext

Jetzt gilt es noch einen Account für einen Administrator anzulegen
~> ant create-admin-user-login

So, alles ist angelegt. Jetzt kann OFBiz gestartet werden.

~> ant run
oder
~>./startofbiz.sh

 

Über die URL localhost/myportal kann man sich nun einloggen. Das Kennwort für den soeben angelegten Administrationsaccount ist "ofbiz" und muss bei der ersten Anmeldung geändert werden.

Auf den ersten Eindruck ist die neue Version zumindest flüssiger.

 

http://g30h0und.wordpress.com/2011/02/23/checkout-und-konfiguration-von-apache-ofbiz-part-2/