Problem: mysql with ofbiz 10.4
Locked
 
|
I am running commond ./ant run-install with ofbiz 10.4 but it is not running...........
I am getting following message [java] 2011-06-22 20:39:46,192 (main) [ ModelEntityChecker.java:502:INFO ] [initReservedWords] array length=1023 [java] Exception in thread "main" java.lang.NullPointerException [java] at org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:548) [java] at org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) [java] at org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:245) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:33) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25) [java] at org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:202) [java] at org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:47) [java] at org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:230) [java] at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] at org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) [java] at org.ofbiz.base.start.Start.start(Start.java:326) [java] at org.ofbiz.base.start.Start.main(Start.java:411) [java] 2011-06-22 20:39:46,253 (OFBiz_Shutdown_Hook) [ ContainerLoader.java:113:INFO ] Shutting down containers [java] Java Result: 1 Please suggest any solution. Thanks in advance Rakesh |
Re: Problem: mysql with ofbiz 10.4
|
|
What does your framework/entity/config/entityengine.xml look like?
What steps did you take to set up ofbiz with mysql? Does it start ok with the default Derby config? On Wed, Jun 22, 2011 at 2:52 AM, Rakesh_Ists <[hidden email]> wrote: > I am running commond ./ant run-install with ofbiz 10.4 but it is not > running........... > > I am getting following message > > [java] 2011-06-22 20:39:46,192 (main) [ ModelEntityChecker.java:502:INFO ] > [initReservedWords] array length=1023 > [java] Exception in thread "main" java.lang.NullPointerException > [java] at > org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:548) > [java] at > org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) > [java] at > org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:245) > [java] at > org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:33) > [java] at > org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25) > [java] at > org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:202) > [java] at > org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:47) > [java] at > org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:230) > [java] at > org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) > [java] at > org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) > [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) > [java] at org.ofbiz.base.start.Start.start(Start.java:326) > [java] at org.ofbiz.base.start.Start.main(Start.java:411) > [java] 2011-06-22 20:39:46,253 (OFBiz_Shutdown_Hook) [ > ContainerLoader.java:113:INFO ] Shutting down containers > [java] Java Result: 1 > > Please suggest any solution. > > Thanks in advance > Rakesh > > > > -- > View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3616546.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > -- James McGill Phoenix AZ |
Re: Problem: mysql with ofbiz 10.4
|
|
In reply to this post by Rakesh_Ists
hi.......................
if u want to configure mysql with ofbiz10.4 first u have to download mysql jar file . which u have to placed in the directory structure named- component name--->lib-->jdbc-------->mysql jar file. now reconfigure entityengine.xml of entity directry . and then recreate the database then start server. surely it will run . try it. Thanks Vishal Agrawal Hotwax Media Pvt. Ltd. On Wed, Jun 22, 2011 at 3:22 PM, Rakesh_Ists <[hidden email]> wrote: > I am running commond ./ant run-install with ofbiz 10.4 but it is not > running........... > > I am getting following message > > [java] 2011-06-22 20:39:46,192 (main) [ ModelEntityChecker.java:502:INFO ] > [initReservedWords] array length=1023 > [java] Exception in thread "main" java.lang.NullPointerException > [java] at > > org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:548) > [java] at > > org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) > [java] at > org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:245) > [java] at > > org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:33) > [java] at > > org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25) > [java] at > org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:202) > [java] at > org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:47) > [java] at > > org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:230) > [java] at > org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) > [java] at > org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) > [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) > [java] at org.ofbiz.base.start.Start.start(Start.java:326) > [java] at org.ofbiz.base.start.Start.main(Start.java:411) > [java] 2011-06-22 20:39:46,253 (OFBiz_Shutdown_Hook) [ > ContainerLoader.java:113:INFO ] Shutting down containers > [java] Java Result: 1 > > Please suggest any solution. > > Thanks in advance > Rakesh > > > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3616546.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
Re: Problem: mysql with ofbiz 10.4
|
|
Hi It was runinng with default derby. I have already placed the jar ..............and also did all the steps ... but still not able to run ofbiz.. Any other mistake which i can committ during configuration. Please do let me know Regards Rakesh |
Re: Problem: mysql with ofbiz 10.4
|
|
In reply to this post by James McGill-5
Hi,
It started proper with derby. my entityEngine.xml look likes as folows <?xml version="1.0" encoding="UTF-8" ?> <entity-config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entity-config.xsd"> <resource-loader name="fieldfile" class="org.ofbiz.base.config.FileLoader" prepend-env="ofbiz.home" prefix="/framework/entity/fieldtype/"/> <transaction-factory class="org.ofbiz.geronimo.GeronimoTransactionFactory"/> <connection-factory class="org.ofbiz.entity.connection.DBCPConnectionFactory"/> <delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false"> <group-map group-name="org.ofbiz" datasource-name="localmysql"/> <group-map group-name="org.ofbiz.olap" datasource-name="odbcmysql"/> </delegator> <delegator name="default-no-eca" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" entity-eca-enabled="false" distributed-cache-clear-enabled="false"> <group-map group-name="org.ofbiz" datasource-name="localmysql"/> <group-map group-name="org.ofbiz.olap" datasource-name="odbcmysql"/> </delegator> <delegator name="test" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main"> <group-map group-name="org.ofbiz" datasource-name="localmysql"/> <group-map group-name="org.ofbiz.olap" datasource-name="odbcmysql"/> </delegator> <delegator name="other" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main"> <group-map group-name="org.ofbiz" datasource-name="localpostgres"/> </delegator> <entity-model-reader name="main"/> <entity-group-reader name="main"/> <entity-eca-reader name="main"/> <entity-data-reader name="seed"/> <entity-data-reader name="seed-initial"/> <entity-data-reader name="demo"/> <entity-data-reader name="ext"/> <entity-data-reader name="ext-test"/> <entity-data-reader name="ext-demo"/> <field-type name="hsql" loader="fieldfile" location="fieldtypehsql.xml"/> <field-type name="derby" loader="fieldfile" location="fieldtypederby.xml"/> <field-type name="cloudscape" loader="fieldfile" location="fieldtypecloudscape.xml"/> <field-type name="daffodil" loader="fieldfile" location="fieldtypedaffodil.xml"/> <field-type name="axion" loader="fieldfile" location="fieldtypeaxion.xml"/> <field-type name="mysql" loader="fieldfile" location="fieldtypemysql.xml"/> <field-type name="postgres" loader="fieldfile" location="fieldtypepostgres.xml"/> <field-type name="postnew" loader="fieldfile" location="fieldtypepostnew.xml"/> <field-type name="oracle" loader="fieldfile" location="fieldtypeoracle.xml"/> <field-type name="sapdb" loader="fieldfile" location="fieldtypesapdb.xml"/> <field-type name="sybase" loader="fieldfile" location="fieldtypesybase.xml"/> <field-type name="firebird" loader="fieldfile" location="fieldtypefirebird.xml"/> <field-type name="mssql" loader="fieldfile" location="fieldtypemssql.xml"/> <field-type name="advantage" loader="fieldfile" location="fieldtypeadvantage.xml"/> <datasource name="localmysql" helper-class="org.ofbiz.entity.datasource.GenericHelperDAO" field-type-name="mysql" check-on-start="true" add-missing-on-start="true" check-pks-on-start="false" use-foreign-keys="true" join-style="ansi-no-parenthesis" alias-view-columns="false" drop-fk-use-foreign-key-keyword="true" table-type="InnoDB" character-set="utf8" collate="utf8_general_ci"> <read-data reader-name="seed"/> <read-data reader-name="seed-initial"/> <read-data reader-name="demo"/> <read-data reader-name="ext"/> <inline-jdbc jdbc-driver="com.mysql.jdbc.Driver" jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true" jdbc-username="root" jdbc-password="abc" isolation-level="ReadCommitted" pool-minsize="2" pool-maxsize="250"/> </datasource> <datasource name="odbcmysql" helper-class="org.ofbiz.entity.datasource.GenericHelperDAO" field-type-name="mysql" check-on-start="true" add-missing-on-start="true" check-pks-on-start="false" use-foreign-keys="true" join-style="ansi-no-parenthesis" alias-view-columns="false" drop-fk-use-foreign-key-keyword="true" table-type="InnoDB" character-set="utf8" collate="utf8_general_ci"> <read-data reader-name="seed"/> <inline-jdbc jdbc-driver="com.mysql.jdbc.Driver" jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz_odbc?autoReconnect=true" jdbc-username="root" jdbc-password="abc" isolation-level="ReadCommitted" pool-minsize="2" pool-maxsize="250"/> </datasource> </entity-config> |
|
|
In reply to this post by Rakesh_Ists
hi,
please update what error/exception you are getting. Thanks prasath rajan On Mon, Jun 27, 2011 at 11:41 AM, Rakesh_Ists <[hidden email]> wrote: > > Hi > > It was runinng with default derby. > > > I have already placed the jar ..............and also did all the steps ... > but still not able to run ofbiz.. > > Any other mistake which i can committ during configuration. > > Please do let me know > > Regards > Rakesh > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3627022.html > Sent from the OFBiz - User mailing list archive at Nabble.com. >
prasath rajan
9442369696
|
Re: Problem: mysql with ofbiz 10.4
|
|
In reply to this post by Rakesh_Ists
Hello Rakesh,
Try with mysql port on which you are working like: - jdbc-uri="jdbc:mysql://127.0.0.1:3309/ofbiz?autoReconnect=true<http://127.0.0.1/ofbiz?autoReconnect=true> " -- Thanks and Regards Santosh Malviya On Mon, Jun 27, 2011 at 1:03 PM, Rakesh_Ists <[hidden email]> wrote: > Hi, > > It started proper with derby. > > my entityEngine.xml look likes as folows > > <?xml version="1.0" encoding="UTF-8" ?> > > <entity-config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > > xsi:noNamespaceSchemaLocation=" > http://ofbiz.apache.org/dtds/entity-config.xsd"> > <resource-loader name="fieldfile" > class="org.ofbiz.base.config.FileLoader" > prepend-env="ofbiz.home" prefix="/framework/entity/fieldtype/"/> > > > > <transaction-factory > class="org.ofbiz.geronimo.GeronimoTransactionFactory"/> > > > > > > > <connection-factory > class="org.ofbiz.entity.connection.DBCPConnectionFactory"/> > > <delegator name="default" entity-model-reader="main" > entity-group-reader="main" entity-eca-reader="main" > distributed-cache-clear-enabled="false"> > <group-map group-name="org.ofbiz" datasource-name="localmysql"/> > <group-map group-name="org.ofbiz.olap" > datasource-name="odbcmysql"/> > > </delegator> > <delegator name="default-no-eca" entity-model-reader="main" > entity-group-reader="main" entity-eca-reader="main" > entity-eca-enabled="false" distributed-cache-clear-enabled="false"> > <group-map group-name="org.ofbiz" datasource-name="localmysql"/> > <group-map group-name="org.ofbiz.olap" datasource-name="odbcmysql"/> > </delegator> > > > <delegator name="test" entity-model-reader="main" > entity-group-reader="main" entity-eca-reader="main"> > <group-map group-name="org.ofbiz" datasource-name="localmysql"/> > <group-map group-name="org.ofbiz.olap" datasource-name="odbcmysql"/> > </delegator> > <delegator name="other" entity-model-reader="main" > entity-group-reader="main" entity-eca-reader="main"> > <group-map group-name="org.ofbiz" datasource-name="localpostgres"/> > </delegator> > > > <entity-model-reader name="main"/> > > > <entity-group-reader name="main"/> > > > <entity-eca-reader name="main"/> > > > > <entity-data-reader name="seed"/> > <entity-data-reader name="seed-initial"/> > <entity-data-reader name="demo"/> > <entity-data-reader name="ext"/> > <entity-data-reader name="ext-test"/> > <entity-data-reader name="ext-demo"/> > > <field-type name="hsql" loader="fieldfile" > location="fieldtypehsql.xml"/> > <field-type name="derby" loader="fieldfile" > location="fieldtypederby.xml"/> > <field-type name="cloudscape" loader="fieldfile" > location="fieldtypecloudscape.xml"/> > <field-type name="daffodil" loader="fieldfile" > location="fieldtypedaffodil.xml"/> > <field-type name="axion" loader="fieldfile" > location="fieldtypeaxion.xml"/> > <field-type name="mysql" loader="fieldfile" > location="fieldtypemysql.xml"/> > <field-type name="postgres" loader="fieldfile" > location="fieldtypepostgres.xml"/> > <field-type name="postnew" loader="fieldfile" > location="fieldtypepostnew.xml"/> > <field-type name="oracle" loader="fieldfile" > location="fieldtypeoracle.xml"/> > <field-type name="sapdb" loader="fieldfile" > location="fieldtypesapdb.xml"/> > <field-type name="sybase" loader="fieldfile" > location="fieldtypesybase.xml"/> > <field-type name="firebird" loader="fieldfile" > location="fieldtypefirebird.xml"/> > <field-type name="mssql" loader="fieldfile" > location="fieldtypemssql.xml"/> > <field-type name="advantage" loader="fieldfile" > location="fieldtypeadvantage.xml"/> > > > > > <datasource name="localmysql" > helper-class="org.ofbiz.entity.datasource.GenericHelperDAO" > field-type-name="mysql" > check-on-start="true" > add-missing-on-start="true" > check-pks-on-start="false" > use-foreign-keys="true" > join-style="ansi-no-parenthesis" > alias-view-columns="false" > drop-fk-use-foreign-key-keyword="true" > table-type="InnoDB" > character-set="utf8" > collate="utf8_general_ci"> > <read-data reader-name="seed"/> > <read-data reader-name="seed-initial"/> > <read-data reader-name="demo"/> > <read-data reader-name="ext"/> > <inline-jdbc > jdbc-driver="com.mysql.jdbc.Driver" > jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true" > jdbc-username="root" > jdbc-password="abc" > isolation-level="ReadCommitted" > pool-minsize="2" > pool-maxsize="250"/> > > </datasource> > <datasource name="odbcmysql" > helper-class="org.ofbiz.entity.datasource.GenericHelperDAO" > field-type-name="mysql" > check-on-start="true" > add-missing-on-start="true" > check-pks-on-start="false" > use-foreign-keys="true" > join-style="ansi-no-parenthesis" > alias-view-columns="false" > drop-fk-use-foreign-key-keyword="true" > table-type="InnoDB" > character-set="utf8" > collate="utf8_general_ci"> > <read-data reader-name="seed"/> > <inline-jdbc > jdbc-driver="com.mysql.jdbc.Driver" > > jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz_odbc?autoReconnect=true" > jdbc-username="root" > jdbc-password="abc" > isolation-level="ReadCommitted" > pool-minsize="2" > pool-maxsize="250"/> > </datasource> > > </entity-config> > > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3627126.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
Re: Problem: mysql with ofbiz 10.4
|
|
In reply to this post by prasath
HI,
I am getting following exceptions..... [java] 2011-06-28 16:24:06,503 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: totQuantityAvailable of view-entity OrderItemAndShipGrpInvResAndItemSum [java] 2011-06-28 16:24:06,570 (main) [ ModelReader.java:389:INFO ] FINISHED LOADING ENTITIES - ALL FILES; #Entities=849 #ViewEntities=267 #Fields=8870 #Relationships=2925 #AutoRelationships=2157 [java] 2011-06-28 16:24:06,583 (main) [ GenericDelegator.java:244:INFO ] Doing entity definition check... [java] 2011-06-28 16:24:06,587 (main) [ ModelEntityChecker.java:502:INFO ] [initReservedWords] array length=1023 [java] Exception in thread "main" java.lang.NullPointerException [java] at org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:548) [java] at org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) [java] at org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:245) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:33) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25) [java] at org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:202) [java] at org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:47) [java] at org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:230) [java] at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] at org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) [java] at org.ofbiz.base.start.Start.start(Start.java:326) [java] at org.ofbiz.base.start.Start.main(Start.java:411) [java] 2011-06-28 16:24:06,644 (OFBiz_Shutdown_Hook) [ ContainerLoader.java:113:INFO ] Shutting down containers [java] Java Result: 1 BUILD SUCCESSFUL |
Re: Problem: mysql with ofbiz 10.4
|
|
In reply to this post by Santosh Malviya-3
Hi Santosh.....
I have followed your suggestion but could not work out for me. Regards, Rakesh |
Re: Problem: mysql with ofbiz 10.4
|
|
In reply to this post by Rakesh_Ists
The exception you posted is not complete, post full exception.
-- Thanks and Regards Santosh Malviya On Tue, Jun 28, 2011 at 10:40 AM, Rakesh_Ists <[hidden email]> wrote: > HI, > > I am getting following exceptions..... > > [java] 2011-06-28 16:24:06,503 (main) [ ModelViewEntity.java:532:WARN > ] Conversion for complex-alias needs to be implemented for cache and > in-memory eval stuff to work correctly, will not work for alias: > totQuantityAvailable of view-entity OrderItemAndShipGrpInvResAndItemSum > [java] 2011-06-28 16:24:06,570 (main) [ > ModelReader.java:389:INFO ] FINISHED LOADING ENTITIES - ALL FILES; > #Entities=849 #ViewEntities=267 #Fields=8870 #Relationships=2925 > #AutoRelationships=2157 > [java] 2011-06-28 16:24:06,583 (main) [ > GenericDelegator.java:244:INFO ] Doing entity definition check... > [java] 2011-06-28 16:24:06,587 (main) [ > ModelEntityChecker.java:502:INFO ] [initReservedWords] array length=1023 > [java] Exception in thread "main" java.lang.NullPointerException > [java] at > > org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:548) > [java] at > > org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) > [java] at > org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:245) > [java] at > > org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:33) > [java] at > > org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25) > [java] at > org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:202) > [java] at > org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:47) > [java] at > > org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:230) > [java] at > org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) > [java] at > org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) > [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) > [java] at org.ofbiz.base.start.Start.start(Start.java:326) > [java] at org.ofbiz.base.start.Start.main(Start.java:411) > [java] 2011-06-28 16:24:06,644 (OFBiz_Shutdown_Hook) [ > ContainerLoader.java:113:INFO ] Shutting down containers > [java] Java Result: 1 > > BUILD SUCCESSFUL > > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3629471.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
|
|
In reply to this post by Rakesh_Ists
A couple of things I noticed. When I used mysql (I don't anymore, I
use PG) I had this: <delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false"> <group-map group-name="org.ofbiz" datasource-name="localmysql"/> <group-map group-name="org.ofbiz.olap" datasource-name="localmysql"/> </delegator> I used "localmysql" for both (even olap). Maybe this is wrong, but it seemed to work for me. For my localmysql, it looked like this (I noticed you used UTF8, which is good). <datasource name="localmysql" helper-class="org.ofbiz.entity.datasource.GenericHelperDAO" field-type-name="mysql" check-on-start="true" add-missing-on-start="true" check-pks-on-start="false" use-foreign-keys="true" join-style="ansi-no-parenthesis" alias-view-columns="false" drop-fk-use-foreign-key-keyword="true" table-type="InnoDB" character-set="utf8" collate="utf8_general_ci"> <read-data reader-name="seed"/> <read-data reader-name="seed-initial"/> <read-data reader-name="demo"/> <read-data reader-name="ext"/> <inline-jdbc jdbc-driver="com.mysql.jdbc.Driver" jdbc-uri="jdbc:mysql://10.2.10.101/ofbiz?autoReconnect=true;characterEncoding=UTF-8" jdbc-username="ofbiz" jdbc-password="ofbizpass" isolation-level="ReadCommitted" pool-minsize="2" pool-maxsize="250"/> </datasource> "10.2.10.101" is my DB server. Yours may be 127.0.0.1 I believe you need the "characterEncoding=UTF-8" to the URI. On another note, I noticed that you are using "root" as your login to mysql. This is not considered a good practice. In the above example, you should create a user login for mysql for the user "ofbiz" and assign a password to it. The user "ofbiz" has to have sufficient credentials (i.e. "grant all") as to allow creation of a database. If your mysql database is on a separate machine, then you need to make sure you are able to login remotely, which is what ofbiz does. Example(s): mysql> grant all on *.* to 'ofbiz'@'host_where_ofbiz_runs' identified by 'ofbizpass'; mysql> drop database ofbiz; mysql> create database ofbiz; You can test whether you can login remotely by doing something like this: # mysql -u ofbiz -h dbhost -pofbizpass -A -D ofbiz -e "show databases" +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | ofbiz | +--------------------+ There are a lot of examples on the web on how to configure mysql for this. To restart, you probably have to drop the "ofbiz" database to restart the whole process. Also, ofbiz has over 800 tables, so you must optimize mysql. If you don't, it will be dog-slow. The table_cache is real important. This is what I used to use (probably overkill). bind-address = 0.0.0.0 # # * Fine Tuning # key_buffer = 64M max_allowed_packet = 640M thread_stack = 192K thread_cache_size = 8 max_connections = 50 table_cache = 2400 table_definition_cache = 2400 max_heap_table_size = 512M tmp_table_size = 512M join_buffer_size = 5M query_cache_limit = 64M query_cache_size = 128M Good luck. On Mon, Jun 27, 2011 at 12:33 AM, Rakesh_Ists <[hidden email]> wrote: > Hi, > > It started proper with derby. > > my entityEngine.xml look likes as folows > > <?xml version="1.0" encoding="UTF-8" ?> > > <entity-config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > > xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entity-config.xsd"> > <resource-loader name="fieldfile" > class="org.ofbiz.base.config.FileLoader" > prepend-env="ofbiz.home" prefix="/framework/entity/fieldtype/"/> > > > > <transaction-factory > class="org.ofbiz.geronimo.GeronimoTransactionFactory"/> > > > > > > > <connection-factory > class="org.ofbiz.entity.connection.DBCPConnectionFactory"/> > > <delegator name="default" entity-model-reader="main" > entity-group-reader="main" entity-eca-reader="main" > distributed-cache-clear-enabled="false"> > <group-map group-name="org.ofbiz" datasource-name="localmysql"/> > <group-map group-name="org.ofbiz.olap" > datasource-name="odbcmysql"/> > > </delegator> > <delegator name="default-no-eca" entity-model-reader="main" > entity-group-reader="main" entity-eca-reader="main" > entity-eca-enabled="false" distributed-cache-clear-enabled="false"> > <group-map group-name="org.ofbiz" datasource-name="localmysql"/> > <group-map group-name="org.ofbiz.olap" datasource-name="odbcmysql"/> > </delegator> > > > <delegator name="test" entity-model-reader="main" > entity-group-reader="main" entity-eca-reader="main"> > <group-map group-name="org.ofbiz" datasource-name="localmysql"/> > <group-map group-name="org.ofbiz.olap" datasource-name="odbcmysql"/> > </delegator> > <delegator name="other" entity-model-reader="main" > entity-group-reader="main" entity-eca-reader="main"> > <group-map group-name="org.ofbiz" datasource-name="localpostgres"/> > </delegator> > > > <entity-model-reader name="main"/> > > > <entity-group-reader name="main"/> > > > <entity-eca-reader name="main"/> > > > > <entity-data-reader name="seed"/> > <entity-data-reader name="seed-initial"/> > <entity-data-reader name="demo"/> > <entity-data-reader name="ext"/> > <entity-data-reader name="ext-test"/> > <entity-data-reader name="ext-demo"/> > > <field-type name="hsql" loader="fieldfile" > location="fieldtypehsql.xml"/> > <field-type name="derby" loader="fieldfile" > location="fieldtypederby.xml"/> > <field-type name="cloudscape" loader="fieldfile" > location="fieldtypecloudscape.xml"/> > <field-type name="daffodil" loader="fieldfile" > location="fieldtypedaffodil.xml"/> > <field-type name="axion" loader="fieldfile" > location="fieldtypeaxion.xml"/> > <field-type name="mysql" loader="fieldfile" > location="fieldtypemysql.xml"/> > <field-type name="postgres" loader="fieldfile" > location="fieldtypepostgres.xml"/> > <field-type name="postnew" loader="fieldfile" > location="fieldtypepostnew.xml"/> > <field-type name="oracle" loader="fieldfile" > location="fieldtypeoracle.xml"/> > <field-type name="sapdb" loader="fieldfile" > location="fieldtypesapdb.xml"/> > <field-type name="sybase" loader="fieldfile" > location="fieldtypesybase.xml"/> > <field-type name="firebird" loader="fieldfile" > location="fieldtypefirebird.xml"/> > <field-type name="mssql" loader="fieldfile" > location="fieldtypemssql.xml"/> > <field-type name="advantage" loader="fieldfile" > location="fieldtypeadvantage.xml"/> > > > > > <datasource name="localmysql" > helper-class="org.ofbiz.entity.datasource.GenericHelperDAO" > field-type-name="mysql" > check-on-start="true" > add-missing-on-start="true" > check-pks-on-start="false" > use-foreign-keys="true" > join-style="ansi-no-parenthesis" > alias-view-columns="false" > drop-fk-use-foreign-key-keyword="true" > table-type="InnoDB" > character-set="utf8" > collate="utf8_general_ci"> > <read-data reader-name="seed"/> > <read-data reader-name="seed-initial"/> > <read-data reader-name="demo"/> > <read-data reader-name="ext"/> > <inline-jdbc > jdbc-driver="com.mysql.jdbc.Driver" > jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true" > jdbc-username="root" > jdbc-password="abc" > isolation-level="ReadCommitted" > pool-minsize="2" > pool-maxsize="250"/> > > </datasource> > <datasource name="odbcmysql" > helper-class="org.ofbiz.entity.datasource.GenericHelperDAO" > field-type-name="mysql" > check-on-start="true" > add-missing-on-start="true" > check-pks-on-start="false" > use-foreign-keys="true" > join-style="ansi-no-parenthesis" > alias-view-columns="false" > drop-fk-use-foreign-key-keyword="true" > table-type="InnoDB" > character-set="utf8" > collate="utf8_general_ci"> > <read-data reader-name="seed"/> > <inline-jdbc > jdbc-driver="com.mysql.jdbc.Driver" > > jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz_odbc?autoReconnect=true" > jdbc-username="root" > jdbc-password="abc" > isolation-level="ReadCommitted" > pool-minsize="2" > pool-maxsize="250"/> > </datasource> > > </entity-config> > > > -- > View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3627126.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
Re: Problem: mysql with ofbiz 10.4
|
|
In reply to this post by Rakesh_Ists
Hi
you don't need to include jar file for derby because derby is an ASF product setup defaultly with OFBiz i will suggest you first take svn update and then start working with OFBiz project Regards Ricky Khatri |
Re: Problem: mysql with ofbiz 10.4
|
|
In reply to this post by Santosh Malviya-3
Hi,
Following is complete log when i run ./ant run-install command................... [subant] No sub-builds to iterate on clean-svninfo: [echo] Resetting svninfo... [echo] Done! [echo] [build] ========== Done Building (Compile) ========== run-install: [java] Set OFBIZ_HOME to - /opt/Radical/ofbiz [java] Admin socket not configured; set to port 0 [java] 2011-06-29 16:01:59,398 (main) [ ContainerLoader.java:50 :INFO ] [Startup] Loading containers... [java] 2011-06-29 16:01:59,656 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/framework] [java] 2011-06-29 16:01:59,681 (main) [ ComponentContainer.java:238:INFO ] Loading component : [geronimo] [java] 2011-06-29 16:01:59,696 (main) [ ComponentContainer.java:238:INFO ] Loading component : [sql] [java] 2011-06-29 16:01:59,715 (main) [ ComponentContainer.java:238:INFO ] Loading component : [entity] [java] 2011-06-29 16:01:59,726 (main) [ ComponentContainer.java:238:INFO ] Loading component : [catalina] [java] 2011-06-29 16:01:59,740 (main) [ ComponentContainer.java:238:INFO ] Loading component : [security] [java] 2011-06-29 16:01:59,750 (main) [ ComponentContainer.java:238:INFO ] Loading component : [datafile] [java] 2011-06-29 16:01:59,760 (main) [ ComponentContainer.java:238:INFO ] Loading component : [minilang] [java] 2011-06-29 16:01:59,776 (main) [ ComponentContainer.java:238:INFO ] Loading component : [common] [java] 2011-06-29 16:01:59,787 (main) [ ComponentContainer.java:238:INFO ] Loading component : [service] [java] 2011-06-29 16:01:59,794 (main) [ ComponentContainer.java:238:INFO ] Loading component : [entityext] [java] 2011-06-29 16:01:59,800 (main) [ ComponentContainer.java:238:INFO ] Loading component : [bi] [java] 2011-06-29 16:01:59,814 (main) [ ComponentContainer.java:238:INFO ] Loading component : [birt] [java] 2011-06-29 16:01:59,829 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webapp] [java] 2011-06-29 16:01:59,840 (main) [ ComponentContainer.java:238:INFO ] Loading component : [guiapp] [java] 2011-06-29 16:01:59,847 (main) [ ComponentContainer.java:238:INFO ] Loading component : [widget] [java] 2011-06-29 16:01:59,852 (main) [ ComponentContainer.java:238:INFO ] Loading component : [appservers] [java] 2011-06-29 16:01:59,859 (main) [ ComponentContainer.java:238:INFO ] Loading component : [testtools] [java] 2011-06-29 16:01:59,864 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webtools] [java] 2011-06-29 16:01:59,870 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webslinger] [java] 2011-06-29 16:01:59,884 (main) [ ComponentContainer.java:238:INFO ] Loading component : [images] [java] 2011-06-29 16:01:59,895 (main) [ ComponentContainer.java:238:INFO ] Loading component : [example] [java] 2011-06-29 16:01:59,901 (main) [ ComponentContainer.java:238:INFO ] Loading component : [exampleext] [java] 2011-06-29 16:01:59,901 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/themes] [java] 2011-06-29 16:01:59,907 (main) [ ComponentContainer.java:238:INFO ] Loading component : [bizznesstime] [java] 2011-06-29 16:01:59,913 (main) [ ComponentContainer.java:238:INFO ] Loading component : [bluelight] [java] 2011-06-29 16:01:59,926 (main) [ ComponentContainer.java:238:INFO ] Loading component : [droppingcrumbs] [java] 2011-06-29 16:01:59,936 (main) [ ComponentContainer.java:238:INFO ] Loading component : [flatgrey] [java] 2011-06-29 16:01:59,941 (main) [ ComponentContainer.java:238:INFO ] Loading component : [multiflex] [java] 2011-06-29 16:01:59,946 (main) [ ComponentContainer.java:238:INFO ] Loading component : [tomahawk] [java] 2011-06-29 16:01:59,947 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/applications] [java] 2011-06-29 16:01:59,957 (main) [ ComponentContainer.java:238:INFO ] Loading component : [party] [java] 2011-06-29 16:01:59,962 (main) [ ComponentContainer.java:238:INFO ] Loading component : [securityext] [java] 2011-06-29 16:01:59,980 (main) [ ComponentContainer.java:238:INFO ] Loading component : [content] [java] 2011-06-29 16:01:59,989 (main) [ ComponentContainer.java:238:INFO ] Loading component : [workeffort] [java] 2011-06-29 16:02:00,004 (main) [ ComponentContainer.java:238:INFO ] Loading component : [product] [java] 2011-06-29 16:02:00,010 (main) [ ComponentContainer.java:238:INFO ] Loading component : [manufacturing] [java] 2011-06-29 16:02:00,021 (main) [ ComponentContainer.java:238:INFO ] Loading component : [accounting] [java] 2011-06-29 16:02:00,022 (main) [ ComponentContainer.java:276:WARN ] Location '/opt/Radical/ofbiz/applications/accounting/lib/cybersource' does not exist [java] 2011-06-29 16:02:00,022 (main) [ ComponentContainer.java:276:WARN ] Location '/opt/Radical/ofbiz/applications/accounting/lib/worldpay' does not exist [java] 2011-06-29 16:02:00,027 (main) [ ComponentContainer.java:238:INFO ] Loading component : [humanres] [java] 2011-06-29 16:02:00,035 (main) [ ComponentContainer.java:238:INFO ] Loading component : [order] [java] 2011-06-29 16:02:00,048 (main) [ ComponentContainer.java:238:INFO ] Loading component : [marketing] [java] 2011-06-29 16:02:00,064 (main) [ ComponentContainer.java:238:INFO ] Loading component : [commonext] [java] 2011-06-29 16:02:00,065 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/specialpurpose] [java] 2011-06-29 16:02:00,071 (main) [ ComponentContainer.java:238:INFO ] Loading component : [ecommerce] [java] 2011-06-29 16:02:00,075 (main) [ ComponentContainer.java:238:INFO ] Loading component : [pos] [java] 2011-06-29 16:02:00,080 (main) [ ComponentContainer.java:238:INFO ] Loading component : [hhfacility] [java] 2011-06-29 16:02:00,084 (main) [ ComponentContainer.java:238:INFO ] Loading component : [assetmaint] [java] 2011-06-29 16:02:00,088 (main) [ ComponentContainer.java:238:INFO ] Loading component : [cmssite] [java] 2011-06-29 16:02:00,091 (main) [ ComponentContainer.java:238:INFO ] Loading component : [ofbiz] [java] 2011-06-29 16:02:00,095 (main) [ ComponentContainer.java:238:INFO ] Loading component : [projectmgr] [java] 2011-06-29 16:02:00,099 (main) [ ComponentContainer.java:238:INFO ] Loading component : [oagis] [java] 2011-06-29 16:02:00,106 (main) [ ComponentContainer.java:238:INFO ] Loading component : [googlebase] [java] 2011-06-29 16:02:00,110 (main) [ ComponentContainer.java:238:INFO ] Loading component : [googlecheckout] [java] 2011-06-29 16:02:00,114 (main) [ ComponentContainer.java:238:INFO ] Loading component : [ebay] [java] 2011-06-29 16:02:00,118 (main) [ ComponentContainer.java:238:INFO ] Loading component : [ebaystore] [java] 2011-06-29 16:02:00,122 (main) [ ComponentContainer.java:238:INFO ] Loading component : [myportal] [java] 2011-06-29 16:02:00,125 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webpos] [java] 2011-06-29 16:02:00,129 (main) [ ComponentContainer.java:238:INFO ] Loading component : [crowd] [java] 2011-06-29 16:02:00,130 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/hot-deploy] [java] 2011-06-29 16:02:00,168 (main) [ ComponentContainer.java:146:INFO ] All components loaded [java] 2011-06-29 16:02:00,232 (main) [ClassLoaderContainer.java:50 :INFO ] CachedClassLoader created [java] 2011-06-29 16:02:00,252 (main) [ ContainerLoader.java:95 :INFO ] [Startup] Starting containers... [java] 2011-06-29 16:02:00,256 (main) [DelegatorFactoryImpl.java:30 :INFO ] Creating new delegator [default] (main) [java] Loaded ESAPI properties from classpath [java] ========Master Configuration======== [java] | LogEncodingRequired=false [java] | LogLevel=ALL [java] | MaxUploadFileBytes=500000000 [java] | ResponseContentType=text/html; charset=UTF-8 [java] | ValidExtensions=.zip,.pdf,.doc,.docx,.ppt,.pptx,.tar,.gz,.tgz,.rar,.war,.jar,.ear,.xls,.rtf,.properties,.java,.class,.txt,.xml,.jsp,.jsf,.exe,.dll [java] | Validator.AccountName=^[a-zA-Z0-9]{3,20}$ [java] | Validator.CreditCard=^(\d{4}[- ]?){3}\d{4}$ [java] | Validator.DirectoryName=^[a-zA-Z0-9.-\_ ]{0,255}$ [java] | Validator.Email=^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+\.[a-zA-Z]{2,4}$ [java] | Validator.FileName=^[a-zA-Z0-9.\-_ ]{0,255}$ [java] | Validator.HTTPCookieName=^[a-zA-Z0-9\-_]{0,32}$ [java] | Validator.HTTPCookieValue=^[a-zA-Z0-9\-\/+=_ ]*$ [java] | Validator.HTTPHeaderName=^[a-zA-Z0-9\-_]{0,32}$ [java] | Validator.HTTPHeaderValue=^[a-zA-Z0-9()\-=\*\.\?;,+\/:&_ ]*$ [java] | Validator.HTTPParameterName=^[a-zA-Z0-9_]{0,32}$ [java] | Validator.HTTPParameterValue=^[a-zA-Z0-9.\-\/+=_ ]*$ [java] | Validator.IPAddress=^(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$ [java] | Validator.Redirect=^\/test.*$ [java] | Validator.RoleName=^[a-z]{1,20}$ [java] | Validator.SSN=^(?!000)([0-6]\d{2}|7([0-6]\d|7[012]))([ -]?)(?!00)\d\d\3(?!0000)\d{4}$ [java] | Validator.SafeString=^[p{L}p{N}.]{0,1024}$ [java] | Validator.SystemCommand=^[a-zA-Z\-\/]{0,64}$ [java] | Validator.URL=^(ht|f)tp(s?)\:\/\/[0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*(:(0-9)*)*(\/?)([a-zA-Z0-9\-\.\?\,\:\'\/\\\+=&%\$#_]*)?$ [java] | event.test.actions=disable,log [java] | event.test.count=2 [java] | event.test.interval=10 [java] | org.owasp.esapi.errors.IntegrityException.actions=log,disable,logout [java] | org.owasp.esapi.errors.IntegrityException.count=10 [java] | org.owasp.esapi.errors.IntegrityException.interval=5 [java] | org.owasp.esapi.errors.IntrusionException.actions=log,disable,logout [java] | org.owasp.esapi.errors.IntrusionException.count=1 [java] | org.owasp.esapi.errors.IntrusionException.interval=1 [java] 2011-06-29 16:02:01,114 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: statusDelay of view-entity ExampleStatusDetail [java] 2011-06-29 16:02:01,169 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortAssocFromView because one already exists with the alias name [sequenceNum] and field name [WEFROM(WorkEffort).sequenceNum], existing field name is [WEA.sequenceNum] [java] 2011-06-29 16:02:01,169 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortAssocToView because one already exists with the alias name [sequenceNum] and field name [WETO(WorkEffort).sequenceNum], existing field name is [WEA.sequenceNum] [java] 2011-06-29 16:02:01,171 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [facilityId] and field name [PROD(Product).facilityId], existing field name is [WE.facilityId] [java] 2011-06-29 16:02:01,172 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [description] and field name [PROD(Product).description], existing field name is [WE.description] [java] 2011-06-29 16:02:01,173 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [reserv2ndPPPerc] and field name [PROD(Product).reserv2ndPPPerc], existing field name is [WE.reserv2ndPPPerc] [java] 2011-06-29 16:02:01,174 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [reservNthPPPerc] and field name [PROD(Product).reservNthPPPerc], existing field name is [WE.reservNthPPPerc] [java] 2011-06-29 16:02:01,175 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [createdDate] and field name [PROD(Product).createdDate], existing field name is [WE.createdDate] [java] 2011-06-29 16:02:01,175 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [createdByUserLogin] and field name [PROD(Product).createdByUserLogin], existing field name is [WE.createdByUserLogin] [java] 2011-06-29 16:02:01,176 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [lastModifiedDate] and field name [PROD(Product).lastModifiedDate], existing field name is [WE.lastModifiedDate] [java] 2011-06-29 16:02:01,176 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [lastModifiedByUserLogin] and field name [PROD(Product).lastModifiedByUserLogin], existing field name is [WE.lastModifiedByUserLogin] [java] 2011-06-29 16:02:01,218 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered of view-entity OrderItemQuantityReportGroupByItem [java] 2011-06-29 16:02:01,220 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOpen of view-entity OrderItemQuantityReportGroupByItem [java] 2011-06-29 16:02:01,220 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered of view-entity OrderItemQuantityReportGroupByProduct [java] 2011-06-29 16:02:01,221 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOpen of view-entity OrderItemQuantityReportGroupByProduct [java] 2011-06-29 16:02:01,222 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered of view-entity OrderReportSalesGroupByProduct [java] 2011-06-29 16:02:01,225 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered of view-entity OrderItemAndShipGrpInvResAndItemSum [java] 2011-06-29 16:02:01,226 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: totQuantityAvailable of view-entity OrderItemAndShipGrpInvResAndItemSum [java] 2011-06-29 16:02:01,293 (main) [ ModelReader.java:389:INFO ] FINISHED LOADING ENTITIES - ALL FILES; #Entities=849 #ViewEntities=267 #Fields=8870 #Relationships=2925 #AutoRelationships=2157 [java] 2011-06-29 16:02:01,304 (main) [ GenericDelegator.java:244:INFO ] Doing entity definition check... [java] 2011-06-29 16:02:01,308 (main) [ ModelEntityChecker.java:502:INFO ] [initReservedWords] array length=1023 [java] Exception in thread "main" java.lang.NullPointerException [java] at org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:548) [java] at org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) [java] at org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:245) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:33) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25) [java] at org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:202) [java] at org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:47) [java] at org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:230) [java] at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] at org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) [java] at org.ofbiz.base.start.Start.start(Start.java:326) [java] at org.ofbiz.base.start.Start.main(Start.java:411) [java] 2011-06-29 16:02:01,363 (OFBiz_Shutdown_Hook) [ ContainerLoader.java:113:INFO ] Shutting down containers [java] Java Result: 1 BUILD SUCCESSFUL |
RE: Problem: mysql with ofbiz 10.4
|
|
Try to clean cache of the application first.
May be this should work -----Original Message----- From: Rakesh_Ists [mailto:[hidden email]] Sent: Wednesday, June 29, 2011 11:01 AM To: [hidden email] Subject: Re: Problem: mysql with ofbiz 10.4 Hi, Following is complete log when i run ./ant run-install command................... [subant] No sub-builds to iterate on clean-svninfo: [echo] Resetting svninfo... [echo] Done! [echo] [build] ========== Done Building (Compile) ========== run-install: [java] Set OFBIZ_HOME to - /opt/Radical/ofbiz [java] Admin socket not configured; set to port 0 [java] 2011-06-29 16:01:59,398 (main) [ ContainerLoader.java:50 :INFO ] [Startup] Loading containers... [java] 2011-06-29 16:01:59,656 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/framework] [java] 2011-06-29 16:01:59,681 (main) [ ComponentContainer.java:238:INFO ] Loading component : [geronimo] [java] 2011-06-29 16:01:59,696 (main) [ ComponentContainer.java:238:INFO ] Loading component : [sql] [java] 2011-06-29 16:01:59,715 (main) [ ComponentContainer.java:238:INFO ] Loading component : [entity] [java] 2011-06-29 16:01:59,726 (main) [ ComponentContainer.java:238:INFO ] Loading component : [catalina] [java] 2011-06-29 16:01:59,740 (main) [ ComponentContainer.java:238:INFO ] Loading component : [security] [java] 2011-06-29 16:01:59,750 (main) [ ComponentContainer.java:238:INFO ] Loading component : [datafile] [java] 2011-06-29 16:01:59,760 (main) [ ComponentContainer.java:238:INFO ] Loading component : [minilang] [java] 2011-06-29 16:01:59,776 (main) [ ComponentContainer.java:238:INFO ] Loading component : [common] [java] 2011-06-29 16:01:59,787 (main) [ ComponentContainer.java:238:INFO ] Loading component : [service] [java] 2011-06-29 16:01:59,794 (main) [ ComponentContainer.java:238:INFO ] Loading component : [entityext] [java] 2011-06-29 16:01:59,800 (main) [ ComponentContainer.java:238:INFO ] Loading component : [bi] [java] 2011-06-29 16:01:59,814 (main) [ ComponentContainer.java:238:INFO ] Loading component : [birt] [java] 2011-06-29 16:01:59,829 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webapp] [java] 2011-06-29 16:01:59,840 (main) [ ComponentContainer.java:238:INFO ] Loading component : [guiapp] [java] 2011-06-29 16:01:59,847 (main) [ ComponentContainer.java:238:INFO ] Loading component : [widget] [java] 2011-06-29 16:01:59,852 (main) [ ComponentContainer.java:238:INFO ] Loading component : [appservers] [java] 2011-06-29 16:01:59,859 (main) [ ComponentContainer.java:238:INFO ] Loading component : [testtools] [java] 2011-06-29 16:01:59,864 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webtools] [java] 2011-06-29 16:01:59,870 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webslinger] [java] 2011-06-29 16:01:59,884 (main) [ ComponentContainer.java:238:INFO ] Loading component : [images] [java] 2011-06-29 16:01:59,895 (main) [ ComponentContainer.java:238:INFO ] Loading component : [example] [java] 2011-06-29 16:01:59,901 (main) [ ComponentContainer.java:238:INFO ] Loading component : [exampleext] [java] 2011-06-29 16:01:59,901 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/themes] [java] 2011-06-29 16:01:59,907 (main) [ ComponentContainer.java:238:INFO ] Loading component : [bizznesstime] [java] 2011-06-29 16:01:59,913 (main) [ ComponentContainer.java:238:INFO ] Loading component : [bluelight] [java] 2011-06-29 16:01:59,926 (main) [ ComponentContainer.java:238:INFO ] Loading component : [droppingcrumbs] [java] 2011-06-29 16:01:59,936 (main) [ ComponentContainer.java:238:INFO ] Loading component : [flatgrey] [java] 2011-06-29 16:01:59,941 (main) [ ComponentContainer.java:238:INFO ] Loading component : [multiflex] [java] 2011-06-29 16:01:59,946 (main) [ ComponentContainer.java:238:INFO ] Loading component : [tomahawk] [java] 2011-06-29 16:01:59,947 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/applications] [java] 2011-06-29 16:01:59,957 (main) [ ComponentContainer.java:238:INFO ] Loading component : [party] [java] 2011-06-29 16:01:59,962 (main) [ ComponentContainer.java:238:INFO ] Loading component : [securityext] [java] 2011-06-29 16:01:59,980 (main) [ ComponentContainer.java:238:INFO ] Loading component : [content] [java] 2011-06-29 16:01:59,989 (main) [ ComponentContainer.java:238:INFO ] Loading component : [workeffort] [java] 2011-06-29 16:02:00,004 (main) [ ComponentContainer.java:238:INFO ] Loading component : [product] [java] 2011-06-29 16:02:00,010 (main) [ ComponentContainer.java:238:INFO ] Loading component : [manufacturing] [java] 2011-06-29 16:02:00,021 (main) [ ComponentContainer.java:238:INFO ] Loading component : [accounting] [java] 2011-06-29 16:02:00,022 (main) [ ComponentContainer.java:276:WARN ] Location '/opt/Radical/ofbiz/applications/accounting/lib/cybersource' does not exist [java] 2011-06-29 16:02:00,022 (main) [ ComponentContainer.java:276:WARN ] Location '/opt/Radical/ofbiz/applications/accounting/lib/worldpay' does not exist [java] 2011-06-29 16:02:00,027 (main) [ ComponentContainer.java:238:INFO ] Loading component : [humanres] [java] 2011-06-29 16:02:00,035 (main) [ ComponentContainer.java:238:INFO ] Loading component : [order] [java] 2011-06-29 16:02:00,048 (main) [ ComponentContainer.java:238:INFO ] Loading component : [marketing] [java] 2011-06-29 16:02:00,064 (main) [ ComponentContainer.java:238:INFO ] Loading component : [commonext] [java] 2011-06-29 16:02:00,065 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/specialpurpose] [java] 2011-06-29 16:02:00,071 (main) [ ComponentContainer.java:238:INFO ] Loading component : [ecommerce] [java] 2011-06-29 16:02:00,075 (main) [ ComponentContainer.java:238:INFO ] Loading component : [pos] [java] 2011-06-29 16:02:00,080 (main) [ ComponentContainer.java:238:INFO ] Loading component : [hhfacility] [java] 2011-06-29 16:02:00,084 (main) [ ComponentContainer.java:238:INFO ] Loading component : [assetmaint] [java] 2011-06-29 16:02:00,088 (main) [ ComponentContainer.java:238:INFO ] Loading component : [cmssite] [java] 2011-06-29 16:02:00,091 (main) [ ComponentContainer.java:238:INFO ] Loading component : [ofbiz] [java] 2011-06-29 16:02:00,095 (main) [ ComponentContainer.java:238:INFO ] Loading component : [projectmgr] [java] 2011-06-29 16:02:00,099 (main) [ ComponentContainer.java:238:INFO ] Loading component : [oagis] [java] 2011-06-29 16:02:00,106 (main) [ ComponentContainer.java:238:INFO ] Loading component : [googlebase] [java] 2011-06-29 16:02:00,110 (main) [ ComponentContainer.java:238:INFO ] Loading component : [googlecheckout] [java] 2011-06-29 16:02:00,114 (main) [ ComponentContainer.java:238:INFO ] Loading component : [ebay] [java] 2011-06-29 16:02:00,118 (main) [ ComponentContainer.java:238:INFO ] Loading component : [ebaystore] [java] 2011-06-29 16:02:00,122 (main) [ ComponentContainer.java:238:INFO ] Loading component : [myportal] [java] 2011-06-29 16:02:00,125 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webpos] [java] 2011-06-29 16:02:00,129 (main) [ ComponentContainer.java:238:INFO ] Loading component : [crowd] [java] 2011-06-29 16:02:00,130 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/hot-deploy] [java] 2011-06-29 16:02:00,168 (main) [ ComponentContainer.java:146:INFO ] All components loaded [java] 2011-06-29 16:02:00,232 (main) [ClassLoaderContainer.java:50 :INFO ] CachedClassLoader created [java] 2011-06-29 16:02:00,252 (main) [ ContainerLoader.java:95 :INFO ] [Startup] Starting containers... [java] 2011-06-29 16:02:00,256 (main) [DelegatorFactoryImpl.java:30 :INFO ] Creating new delegator [default] (main) [java] Loaded ESAPI properties from classpath [java] ========Master Configuration======== [java] | LogEncodingRequired=false [java] | LogLevel=ALL [java] | MaxUploadFileBytes=500000000 [java] | ResponseContentType=text/html; charset=UTF-8 [java] | ValidExtensions=.zip,.pdf,.doc,.docx,.ppt,.pptx,.tar,.gz,.tgz,.rar,.war,.jar,.ear,.xls,.rtf,.properties,.java,.class,.txt,.xml,.jsp,.jsf,.exe,.dll [java] | Validator.AccountName=^[a-zA-Z0-9]{3,20}$ [java] | Validator.CreditCard=^(\d{4}[- ]?){3}\d{4}$ [java] | Validator.DirectoryName=^[a-zA-Z0-9.-\_ ]{0,255}$ [java] | Validator.Email=^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+\.[a-zA-Z]{2,4}$ [java] | Validator.FileName=^[a-zA-Z0-9.\-_ ]{0,255}$ [java] | Validator.HTTPCookieName=^[a-zA-Z0-9\-_]{0,32}$ [java] | Validator.HTTPCookieValue=^[a-zA-Z0-9\-\/+=_ ]*$ [java] | Validator.HTTPHeaderName=^[a-zA-Z0-9\-_]{0,32}$ [java] | Validator.HTTPHeaderValue=^[a-zA-Z0-9()\-=\*\.\?;,+\/:&_ ]*$ [java] | Validator.HTTPParameterName=^[a-zA-Z0-9_]{0,32}$ [java] | Validator.HTTPParameterValue=^[a-zA-Z0-9.\-\/+=_ ]*$ [java] | Validator.IPAddress=^(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$ [java] | Validator.Redirect=^\/test.*$ [java] | Validator.RoleName=^[a-z]{1,20}$ [java] | Validator.SSN=^(?!000)([0-6]\d{2}|7([0-6]\d|7[012]))([ -]?)(?!00)\d\d\3(?!0000)\d{4}$ [java] | Validator.SafeString=^[p{L}p{N}.]{0,1024}$ [java] | Validator.SystemCommand=^[a-zA-Z\-\/]{0,64}$ [java] | Validator.URL=^(ht|f)tp(s?)\:\/\/[0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*(:(0-9)*)*(\/?)([a-zA-Z0-9\-\.\?\,\:\'\/\\\+=&%\$#_]*)?$ [java] | event.test.actions=disable,log [java] | event.test.count=2 [java] | event.test.interval=10 [java] | org.owasp.esapi.errors.IntegrityException.actions=log,disable,logout [java] | org.owasp.esapi.errors.IntegrityException.count=10 [java] | org.owasp.esapi.errors.IntegrityException.interval=5 [java] | org.owasp.esapi.errors.IntrusionException.actions=log,disable,logout [java] | org.owasp.esapi.errors.IntrusionException.count=1 [java] | org.owasp.esapi.errors.IntrusionException.interval=1 [java] 2011-06-29 16:02:01,114 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: statusDelay of view-entity ExampleStatusDetail [java] 2011-06-29 16:02:01,169 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortAssocFromView because one already exists with the alias name [sequenceNum] and field name [WEFROM(WorkEffort).sequenceNum], existing field name is [WEA.sequenceNum] [java] 2011-06-29 16:02:01,169 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortAssocToView because one already exists with the alias name [sequenceNum] and field name [WETO(WorkEffort).sequenceNum], existing field name is [WEA.sequenceNum] [java] 2011-06-29 16:02:01,171 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [facilityId] and field name [PROD(Product).facilityId], existing field name is [WE.facilityId] [java] 2011-06-29 16:02:01,172 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [description] and field name [PROD(Product).description], existing field name is [WE.description] [java] 2011-06-29 16:02:01,173 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [reserv2ndPPPerc] and field name [PROD(Product).reserv2ndPPPerc], existing field name is [WE.reserv2ndPPPerc] [java] 2011-06-29 16:02:01,174 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [reservNthPPPerc] and field name [PROD(Product).reservNthPPPerc], existing field name is [WE.reservNthPPPerc] [java] 2011-06-29 16:02:01,175 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [createdDate] and field name [PROD(Product).createdDate], existing field name is [WE.createdDate] [java] 2011-06-29 16:02:01,175 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [createdByUserLogin] and field name [PROD(Product).createdByUserLogin], existing field name is [WE.createdByUserLogin] [java] 2011-06-29 16:02:01,176 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [lastModifiedDate] and field name [PROD(Product).lastModifiedDate], existing field name is [WE.lastModifiedDate] [java] 2011-06-29 16:02:01,176 (main) [ ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity WorkEffortProductGoods because one already exists with the alias name [lastModifiedByUserLogin] and field name [PROD(Product).lastModifiedByUserLogin], existing field name is [WE.lastModifiedByUserLogin] [java] 2011-06-29 16:02:01,218 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered of view-entity OrderItemQuantityReportGroupByItem [java] 2011-06-29 16:02:01,220 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOpen of view-entity OrderItemQuantityReportGroupByItem [java] 2011-06-29 16:02:01,220 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered of view-entity OrderItemQuantityReportGroupByProduct [java] 2011-06-29 16:02:01,221 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOpen of view-entity OrderItemQuantityReportGroupByProduct [java] 2011-06-29 16:02:01,222 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered of view-entity OrderReportSalesGroupByProduct [java] 2011-06-29 16:02:01,225 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered of view-entity OrderItemAndShipGrpInvResAndItemSum [java] 2011-06-29 16:02:01,226 (main) [ ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: totQuantityAvailable of view-entity OrderItemAndShipGrpInvResAndItemSum [java] 2011-06-29 16:02:01,293 (main) [ ModelReader.java:389:INFO ] FINISHED LOADING ENTITIES - ALL FILES; #Entities=849 #ViewEntities=267 #Fields=8870 #Relationships=2925 #AutoRelationships=2157 [java] 2011-06-29 16:02:01,304 (main) [ GenericDelegator.java:244:INFO ] Doing entity definition check... [java] 2011-06-29 16:02:01,308 (main) [ ModelEntityChecker.java:502:INFO ] [initReservedWords] array length=1023 [java] Exception in thread "main" java.lang.NullPointerException [java] at org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:548) [java] at org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) [java] at org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:245) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:33) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25) [java] at org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:202) [java] at org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:47) [java] at org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:230) [java] at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] at org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) [java] at org.ofbiz.base.start.Start.start(Start.java:326) [java] at org.ofbiz.base.start.Start.main(Start.java:411) [java] 2011-06-29 16:02:01,363 (OFBiz_Shutdown_Hook) [ ContainerLoader.java:113:INFO ] Shutting down containers [java] Java Result: 1 BUILD SUCCESSFUL -- View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3632128.html Sent from the OFBiz - User mailing list archive at Nabble.com. ::DISCLAIMER:: ----------------------------------------------------------------------------------------------------------------------- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any mail and attachments please check them for viruses and defect. ----------------------------------------------------------------------------------------------------------------------- |
|
|
In reply to this post by Rakesh_Ists
I see a typo:
collate="utf8_general_ci"> should be (on both): collate="utf8_general_ci"/> On Tue, Jun 28, 2011 at 10:31 PM, Rakesh_Ists <[hidden email]> wrote: > Hi, > > Following is complete log when i run ./ant run-install > command................... > > > > [subant] No sub-builds to iterate on > > clean-svninfo: > [echo] Resetting svninfo... > [echo] Done! > [echo] [build] ========== Done Building (Compile) ========== > > run-install: > [java] Set OFBIZ_HOME to - /opt/Radical/ofbiz > [java] Admin socket not configured; set to port 0 > [java] 2011-06-29 16:01:59,398 (main) [ ContainerLoader.java:50 > :INFO ] [Startup] Loading containers... > [java] 2011-06-29 16:01:59,656 (main) [ > ComponentContainer.java:177:INFO ] Auto-Loading component directory : > [/opt/Radical/ofbiz/framework] > [java] 2011-06-29 16:01:59,681 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [geronimo] > [java] 2011-06-29 16:01:59,696 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [sql] > [java] 2011-06-29 16:01:59,715 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [entity] > [java] 2011-06-29 16:01:59,726 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [catalina] > [java] 2011-06-29 16:01:59,740 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [security] > [java] 2011-06-29 16:01:59,750 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [datafile] > [java] 2011-06-29 16:01:59,760 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [minilang] > [java] 2011-06-29 16:01:59,776 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [common] > [java] 2011-06-29 16:01:59,787 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [service] > [java] 2011-06-29 16:01:59,794 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [entityext] > [java] 2011-06-29 16:01:59,800 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [bi] > [java] 2011-06-29 16:01:59,814 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [birt] > [java] 2011-06-29 16:01:59,829 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [webapp] > [java] 2011-06-29 16:01:59,840 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [guiapp] > [java] 2011-06-29 16:01:59,847 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [widget] > [java] 2011-06-29 16:01:59,852 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [appservers] > [java] 2011-06-29 16:01:59,859 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [testtools] > [java] 2011-06-29 16:01:59,864 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [webtools] > [java] 2011-06-29 16:01:59,870 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [webslinger] > [java] 2011-06-29 16:01:59,884 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [images] > [java] 2011-06-29 16:01:59,895 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [example] > [java] 2011-06-29 16:01:59,901 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [exampleext] > [java] 2011-06-29 16:01:59,901 (main) [ > ComponentContainer.java:177:INFO ] Auto-Loading component directory : > [/opt/Radical/ofbiz/themes] > [java] 2011-06-29 16:01:59,907 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [bizznesstime] > [java] 2011-06-29 16:01:59,913 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [bluelight] > [java] 2011-06-29 16:01:59,926 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [droppingcrumbs] > [java] 2011-06-29 16:01:59,936 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [flatgrey] > [java] 2011-06-29 16:01:59,941 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [multiflex] > [java] 2011-06-29 16:01:59,946 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [tomahawk] > [java] 2011-06-29 16:01:59,947 (main) [ > ComponentContainer.java:177:INFO ] Auto-Loading component directory : > [/opt/Radical/ofbiz/applications] > [java] 2011-06-29 16:01:59,957 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [party] > [java] 2011-06-29 16:01:59,962 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [securityext] > [java] 2011-06-29 16:01:59,980 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [content] > [java] 2011-06-29 16:01:59,989 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [workeffort] > [java] 2011-06-29 16:02:00,004 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [product] > [java] 2011-06-29 16:02:00,010 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [manufacturing] > [java] 2011-06-29 16:02:00,021 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [accounting] > [java] 2011-06-29 16:02:00,022 (main) [ > ComponentContainer.java:276:WARN ] Location > '/opt/Radical/ofbiz/applications/accounting/lib/cybersource' does not exist > [java] 2011-06-29 16:02:00,022 (main) [ > ComponentContainer.java:276:WARN ] Location > '/opt/Radical/ofbiz/applications/accounting/lib/worldpay' does not exist > [java] 2011-06-29 16:02:00,027 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [humanres] > [java] 2011-06-29 16:02:00,035 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [order] > [java] 2011-06-29 16:02:00,048 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [marketing] > [java] 2011-06-29 16:02:00,064 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [commonext] > [java] 2011-06-29 16:02:00,065 (main) [ > ComponentContainer.java:177:INFO ] Auto-Loading component directory : > [/opt/Radical/ofbiz/specialpurpose] > [java] 2011-06-29 16:02:00,071 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [ecommerce] > [java] 2011-06-29 16:02:00,075 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [pos] > [java] 2011-06-29 16:02:00,080 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [hhfacility] > [java] 2011-06-29 16:02:00,084 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [assetmaint] > [java] 2011-06-29 16:02:00,088 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [cmssite] > [java] 2011-06-29 16:02:00,091 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [ofbiz] > [java] 2011-06-29 16:02:00,095 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [projectmgr] > [java] 2011-06-29 16:02:00,099 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [oagis] > [java] 2011-06-29 16:02:00,106 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [googlebase] > [java] 2011-06-29 16:02:00,110 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [googlecheckout] > [java] 2011-06-29 16:02:00,114 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [ebay] > [java] 2011-06-29 16:02:00,118 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [ebaystore] > [java] 2011-06-29 16:02:00,122 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [myportal] > [java] 2011-06-29 16:02:00,125 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [webpos] > [java] 2011-06-29 16:02:00,129 (main) [ > ComponentContainer.java:238:INFO ] Loading component : [crowd] > [java] 2011-06-29 16:02:00,130 (main) [ > ComponentContainer.java:177:INFO ] Auto-Loading component directory : > [/opt/Radical/ofbiz/hot-deploy] > [java] 2011-06-29 16:02:00,168 (main) [ > ComponentContainer.java:146:INFO ] All components loaded > [java] 2011-06-29 16:02:00,232 (main) [ClassLoaderContainer.java:50 > :INFO ] CachedClassLoader created > [java] 2011-06-29 16:02:00,252 (main) [ ContainerLoader.java:95 > :INFO ] [Startup] Starting containers... > [java] 2011-06-29 16:02:00,256 (main) [DelegatorFactoryImpl.java:30 > :INFO ] Creating new delegator [default] (main) > [java] Loaded ESAPI properties from classpath > [java] ========Master Configuration======== > [java] | LogEncodingRequired=false > [java] | LogLevel=ALL > [java] | MaxUploadFileBytes=500000000 > [java] | ResponseContentType=text/html; charset=UTF-8 > [java] | > ValidExtensions=.zip,.pdf,.doc,.docx,.ppt,.pptx,.tar,.gz,.tgz,.rar,.war,.jar,.ear,.xls,.rtf,.properties,.java,.class,.txt,.xml,.jsp,.jsf,.exe,.dll > [java] | Validator.AccountName=^[a-zA-Z0-9]{3,20}$ > [java] | Validator.CreditCard=^(\d{4}[- ]?){3}\d{4}$ > [java] | Validator.DirectoryName=^[a-zA-Z0-9.-\_ ]{0,255}$ > [java] | > Validator.Email=^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+\.[a-zA-Z]{2,4}$ > [java] | Validator.FileName=^[a-zA-Z0-9.\-_ ]{0,255}$ > [java] | Validator.HTTPCookieName=^[a-zA-Z0-9\-_]{0,32}$ > [java] | Validator.HTTPCookieValue=^[a-zA-Z0-9\-\/+=_ ]*$ > [java] | Validator.HTTPHeaderName=^[a-zA-Z0-9\-_]{0,32}$ > [java] | Validator.HTTPHeaderValue=^[a-zA-Z0-9()\-=\*\.\?;,+\/:&_ > ]*$ > [java] | Validator.HTTPParameterName=^[a-zA-Z0-9_]{0,32}$ > [java] | Validator.HTTPParameterValue=^[a-zA-Z0-9.\-\/+=_ ]*$ > [java] | > Validator.IPAddress=^(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$ > [java] | Validator.Redirect=^\/test.*$ > [java] | Validator.RoleName=^[a-z]{1,20}$ > [java] | Validator.SSN=^(?!000)([0-6]\d{2}|7([0-6]\d|7[012]))([ > -]?)(?!00)\d\d\3(?!0000)\d{4}$ > [java] | Validator.SafeString=^[p{L}p{N}.]{0,1024}$ > [java] | Validator.SystemCommand=^[a-zA-Z\-\/]{0,64}$ > [java] | > Validator.URL=^(ht|f)tp(s?)\:\/\/[0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*(:(0-9)*)*(\/?)([a-zA-Z0-9\-\.\?\,\:\'\/\\\+=&%\$#_]*)?$ > [java] | event.test.actions=disable,log > [java] | event.test.count=2 > [java] | event.test.interval=10 > [java] | > org.owasp.esapi.errors.IntegrityException.actions=log,disable,logout > [java] | org.owasp.esapi.errors.IntegrityException.count=10 > [java] | org.owasp.esapi.errors.IntegrityException.interval=5 > [java] | > org.owasp.esapi.errors.IntrusionException.actions=log,disable,logout > [java] | org.owasp.esapi.errors.IntrusionException.count=1 > [java] | org.owasp.esapi.errors.IntrusionException.interval=1 > [java] 2011-06-29 16:02:01,114 (main) [ > ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be > implemented for cache and in-memory eval stuff to work correctly, will not > work for alias: statusDelay of view-entity ExampleStatusDetail > [java] 2011-06-29 16:02:01,169 (main) [ > ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity > WorkEffortAssocFromView because one already exists with the alias name > [sequenceNum] and field name [WEFROM(WorkEffort).sequenceNum], existing > field name is [WEA.sequenceNum] > [java] 2011-06-29 16:02:01,169 (main) [ > ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity > WorkEffortAssocToView because one already exists with the alias name > [sequenceNum] and field name [WETO(WorkEffort).sequenceNum], existing field > name is [WEA.sequenceNum] > [java] 2011-06-29 16:02:01,171 (main) [ > ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity > WorkEffortProductGoods because one already exists with the alias name > [facilityId] and field name [PROD(Product).facilityId], existing field name > is [WE.facilityId] > [java] 2011-06-29 16:02:01,172 (main) [ > ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity > WorkEffortProductGoods because one already exists with the alias name > [description] and field name [PROD(Product).description], existing field > name is [WE.description] > [java] 2011-06-29 16:02:01,173 (main) [ > ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity > WorkEffortProductGoods because one already exists with the alias name > [reserv2ndPPPerc] and field name [PROD(Product).reserv2ndPPPerc], existing > field name is [WE.reserv2ndPPPerc] > [java] 2011-06-29 16:02:01,174 (main) [ > ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity > WorkEffortProductGoods because one already exists with the alias name > [reservNthPPPerc] and field name [PROD(Product).reservNthPPPerc], existing > field name is [WE.reservNthPPPerc] > [java] 2011-06-29 16:02:01,175 (main) [ > ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity > WorkEffortProductGoods because one already exists with the alias name > [createdDate] and field name [PROD(Product).createdDate], existing field > name is [WE.createdDate] > [java] 2011-06-29 16:02:01,175 (main) [ > ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity > WorkEffortProductGoods because one already exists with the alias name > [createdByUserLogin] and field name [PROD(Product).createdByUserLogin], > existing field name is [WE.createdByUserLogin] > [java] 2011-06-29 16:02:01,176 (main) [ > ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity > WorkEffortProductGoods because one already exists with the alias name > [lastModifiedDate] and field name [PROD(Product).lastModifiedDate], existing > field name is [WE.lastModifiedDate] > [java] 2011-06-29 16:02:01,176 (main) [ > ModelViewEntity.java:690:INFO ] Throwing out field alias in view entity > WorkEffortProductGoods because one already exists with the alias name > [lastModifiedByUserLogin] and field name > [PROD(Product).lastModifiedByUserLogin], existing field name is > [WE.lastModifiedByUserLogin] > [java] 2011-06-29 16:02:01,218 (main) [ > ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be > implemented for cache and in-memory eval stuff to work correctly, will not > work for alias: quantityOrdered of view-entity > OrderItemQuantityReportGroupByItem > [java] 2011-06-29 16:02:01,220 (main) [ > ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be > implemented for cache and in-memory eval stuff to work correctly, will not > work for alias: quantityOpen of view-entity > OrderItemQuantityReportGroupByItem > [java] 2011-06-29 16:02:01,220 (main) [ > ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be > implemented for cache and in-memory eval stuff to work correctly, will not > work for alias: quantityOrdered of view-entity > OrderItemQuantityReportGroupByProduct > [java] 2011-06-29 16:02:01,221 (main) [ > ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be > implemented for cache and in-memory eval stuff to work correctly, will not > work for alias: quantityOpen of view-entity > OrderItemQuantityReportGroupByProduct > [java] 2011-06-29 16:02:01,222 (main) [ > ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be > implemented for cache and in-memory eval stuff to work correctly, will not > work for alias: quantityOrdered of view-entity > OrderReportSalesGroupByProduct > [java] 2011-06-29 16:02:01,225 (main) [ > ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be > implemented for cache and in-memory eval stuff to work correctly, will not > work for alias: quantityOrdered of view-entity > OrderItemAndShipGrpInvResAndItemSum > [java] 2011-06-29 16:02:01,226 (main) [ > ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be > implemented for cache and in-memory eval stuff to work correctly, will not > work for alias: totQuantityAvailable of view-entity > OrderItemAndShipGrpInvResAndItemSum > [java] 2011-06-29 16:02:01,293 (main) [ > ModelReader.java:389:INFO ] FINISHED LOADING ENTITIES - ALL FILES; > #Entities=849 #ViewEntities=267 #Fields=8870 #Relationships=2925 > #AutoRelationships=2157 > [java] 2011-06-29 16:02:01,304 (main) [ > GenericDelegator.java:244:INFO ] Doing entity definition check... > [java] 2011-06-29 16:02:01,308 (main) [ > ModelEntityChecker.java:502:INFO ] [initReservedWords] array length=1023 > [java] Exception in thread "main" java.lang.NullPointerException > [java] at > org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:548) > [java] at > org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) > [java] at > org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:245) > [java] at > org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:33) > [java] at > org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25) > [java] at > org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:202) > [java] at > org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:47) > [java] at > org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:230) > [java] at > org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) > [java] at > org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) > [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) > [java] at org.ofbiz.base.start.Start.start(Start.java:326) > [java] at org.ofbiz.base.start.Start.main(Start.java:411) > [java] 2011-06-29 16:02:01,363 (OFBiz_Shutdown_Hook) [ > ContainerLoader.java:113:INFO ] Shutting down containers > [java] Java Result: 1 > > BUILD SUCCESSFUL > > > -- > View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3632128.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
Re: Problem: mysql with ofbiz 10.4
|
|
Mike,
This is correct........... anything else you can help to get out of it. Thanks in advance Regards, Rakesh Chnadra Pandey |
Re: Problem: mysql with ofbiz 10.4
|
|
In reply to this post by Rakesh_Ists
If someone hasn't suggested it already then get rid of this section:
> <delegator name="other" entity-model-reader="main" > entity-group-reader="main" entity-eca-reader="main"> > <group-map group-name="org.ofbiz" datasource-name="localpostgres"/> > </delegator> You don't have a localpostgres datasource defined so you're going to get errors there. Regards Scott HotWax Media http://www.hotwaxmedia.com On 27/06/2011, at 7:33 PM, Rakesh_Ists wrote: > Hi, > > It started proper with derby. > > my entityEngine.xml look likes as folows > > <?xml version="1.0" encoding="UTF-8" ?> > > <entity-config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > > xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entity-config.xsd"> > <resource-loader name="fieldfile" > class="org.ofbiz.base.config.FileLoader" > prepend-env="ofbiz.home" prefix="/framework/entity/fieldtype/"/> > > > > <transaction-factory > class="org.ofbiz.geronimo.GeronimoTransactionFactory"/> > > > > > > > <connection-factory > class="org.ofbiz.entity.connection.DBCPConnectionFactory"/> > > <delegator name="default" entity-model-reader="main" > entity-group-reader="main" entity-eca-reader="main" > distributed-cache-clear-enabled="false"> > <group-map group-name="org.ofbiz" datasource-name="localmysql"/> > <group-map group-name="org.ofbiz.olap" > datasource-name="odbcmysql"/> > > </delegator> > <delegator name="default-no-eca" entity-model-reader="main" > entity-group-reader="main" entity-eca-reader="main" > entity-eca-enabled="false" distributed-cache-clear-enabled="false"> > <group-map group-name="org.ofbiz" datasource-name="localmysql"/> > <group-map group-name="org.ofbiz.olap" datasource-name="odbcmysql"/> > </delegator> > > > <delegator name="test" entity-model-reader="main" > entity-group-reader="main" entity-eca-reader="main"> > <group-map group-name="org.ofbiz" datasource-name="localmysql"/> > <group-map group-name="org.ofbiz.olap" datasource-name="odbcmysql"/> > </delegator> > <delegator name="other" entity-model-reader="main" > entity-group-reader="main" entity-eca-reader="main"> > <group-map group-name="org.ofbiz" datasource-name="localpostgres"/> > </delegator> > > > <entity-model-reader name="main"/> > > > <entity-group-reader name="main"/> > > > <entity-eca-reader name="main"/> > > > > <entity-data-reader name="seed"/> > <entity-data-reader name="seed-initial"/> > <entity-data-reader name="demo"/> > <entity-data-reader name="ext"/> > <entity-data-reader name="ext-test"/> > <entity-data-reader name="ext-demo"/> > > <field-type name="hsql" loader="fieldfile" > location="fieldtypehsql.xml"/> > <field-type name="derby" loader="fieldfile" > location="fieldtypederby.xml"/> > <field-type name="cloudscape" loader="fieldfile" > location="fieldtypecloudscape.xml"/> > <field-type name="daffodil" loader="fieldfile" > location="fieldtypedaffodil.xml"/> > <field-type name="axion" loader="fieldfile" > location="fieldtypeaxion.xml"/> > <field-type name="mysql" loader="fieldfile" > location="fieldtypemysql.xml"/> > <field-type name="postgres" loader="fieldfile" > location="fieldtypepostgres.xml"/> > <field-type name="postnew" loader="fieldfile" > location="fieldtypepostnew.xml"/> > <field-type name="oracle" loader="fieldfile" > location="fieldtypeoracle.xml"/> > <field-type name="sapdb" loader="fieldfile" > location="fieldtypesapdb.xml"/> > <field-type name="sybase" loader="fieldfile" > location="fieldtypesybase.xml"/> > <field-type name="firebird" loader="fieldfile" > location="fieldtypefirebird.xml"/> > <field-type name="mssql" loader="fieldfile" > location="fieldtypemssql.xml"/> > <field-type name="advantage" loader="fieldfile" > location="fieldtypeadvantage.xml"/> > > > > > <datasource name="localmysql" > helper-class="org.ofbiz.entity.datasource.GenericHelperDAO" > field-type-name="mysql" > check-on-start="true" > add-missing-on-start="true" > check-pks-on-start="false" > use-foreign-keys="true" > join-style="ansi-no-parenthesis" > alias-view-columns="false" > drop-fk-use-foreign-key-keyword="true" > table-type="InnoDB" > character-set="utf8" > collate="utf8_general_ci"> > <read-data reader-name="seed"/> > <read-data reader-name="seed-initial"/> > <read-data reader-name="demo"/> > <read-data reader-name="ext"/> > <inline-jdbc > jdbc-driver="com.mysql.jdbc.Driver" > jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true" > jdbc-username="root" > jdbc-password="abc" > isolation-level="ReadCommitted" > pool-minsize="2" > pool-maxsize="250"/> > > </datasource> > <datasource name="odbcmysql" > helper-class="org.ofbiz.entity.datasource.GenericHelperDAO" > field-type-name="mysql" > check-on-start="true" > add-missing-on-start="true" > check-pks-on-start="false" > use-foreign-keys="true" > join-style="ansi-no-parenthesis" > alias-view-columns="false" > drop-fk-use-foreign-key-keyword="true" > table-type="InnoDB" > character-set="utf8" > collate="utf8_general_ci"> > <read-data reader-name="seed"/> > <inline-jdbc > jdbc-driver="com.mysql.jdbc.Driver" > > jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz_odbc?autoReconnect=true" > jdbc-username="root" > jdbc-password="abc" > isolation-level="ReadCommitted" > pool-minsize="2" > pool-maxsize="250"/> > </datasource> > > </entity-config> > > > -- > View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3627126.html > Sent from the OFBiz - User mailing list archive at Nabble.com. |
smime.p7s (3K)
Re: Problem: mysql with ofbiz 10.4
|
|
Hi Scott,
I removed section suggested by you.................. but still getting the same problem. Regards, Rakesh Chandra Pandey |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |