You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "info@agentur-m3.de" <in...@agentur-m3.de> on 2014/12/07 13:09:02 UTC
connection with external database
Hi All!
still I try to connect ofbiz to a wordpress database.
After editing of the field-types (see below)
and reducing on a single table (wpposts) most of
the field-type errors disappered (one still remains
concerning the ID field, which is primary key, see below).
Here is the error, which occurs at starting ofbiz:
20141207125054905 |OFBiz-config-0 |DatabaseUtil |I| Getting
Table Info From Database
20141207125054905 |OFBiz-config-2 |DatabaseUtil |I| Getting
Table Info From Database
20141207125055178 |OFBiz-config-0 |DatabaseUtil |I| Getting
Column Info From Database
20141207125055178 |OFBiz-config-1 |DatabaseUtil |I| Getting
Column Info From Database
20141207125055278 |OFBiz-config-0 |DatabaseUtil |W| Error
getting primary key info from database with null tableName, will try
other means: java.sql.SQLException: Table name can not be null
20141207125055282 |OFBiz-config-0 |DatabaseUtil |I|
Searching in 6 tables for primary key fields ...
20141207125055322 |OFBiz-config-0 |DatabaseUtil |I|
Reviewed 8 primary key fields from database.
20141207125055681 |OFBiz-config-2 |DatabaseUtil |I| Getting
Column Info From Database
20141207125055723 |OFBiz-config-1 |DatabaseUtil |W| Error
getting primary key info from database with null tableName, will try
other means: java.sql.SQLException: Table name can not be null
20141207125055736 |OFBiz-config-1 |DatabaseUtil |I|
Searching in 4 tables for primary key fields ...
20141207125055781 |OFBiz-config-1 |DatabaseUtil |I|
Reviewed 6 primary key fields from database.
20141207125057044 |OFBiz-config-2 |DatabaseUtil |W| Error
getting primary key info from database with null tableName, will try
other means: java.sql.SQLException: Table name can not be null
20141207125057046 |OFBiz-config-2 |DatabaseUtil |I|
Searching in 841 tables for primary key fields ...
20141207125058131 |OFBiz-config-2 |DatabaseUtil |I|
Reviewed 1641 primary key fields from database.
20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Column
[ID] of table [OFBIZ.WP_POSTS] of entity [WpPosts] exists in the
database but has no corresponding field
20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Column
[I___D] of table [OFBIZ.WP_POSTS] of entity [WpPosts] exists in the
database but has no corresponding field
20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Column
[I__D] of table [OFBIZ.WP_POSTS] of entity [WpPosts] exists in the
database but has no corresponding field
20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Entity
[WpPosts] has 27 fields but table [OFBIZ.WP_POSTS] has 30 columns.
-----------------------------------------------
Both the entity-fields as the database have 23 fields (not 27 or 30) !??
The field ID seems to be defined. I also tried I_D and I__D, both
did not work as well.
Here the content of the tree involved entity-files:
--------------------------entitymodel.xml----------------------------------------------------
<entitymodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitymodel.xsd">
<!-- ========================================================= -->
<!-- ======================== Defaults ======================= -->
<!-- ========================================================= -->
<title>Entity of an Apache Open For Business Project (Apache OFBiz)
Component</title>
<description>None</description>
<copyright>Copyright 2001-2012 The Apache Software
Foundation</copyright>
<author>None</author>
<version>1.0</version>
<entity entity-name="WpPosts"
package-name=""
title="None"
copyright="Copyright 2001-2014 The Apache Software Foundation">
<field name="menuOrder" type="id"></field>
<field name="postModified" type="id"></field>
<field name="postMimeType" type="id"></field>
<field name="guid" type="id"></field>
<field name="postAuthor" type="id"></field>
<field name="postModifiedGmt" type="id"></field>
<field name="postName" type="id"></field>
<field name="commentCount" type="id"></field>
<field name="postDate" type="id"></field>
<field name="postContentFiltered" type="id"></field>
<field name="pingStatus" type="id"></field>
<field name="postParent" type="id"></field>
<field name="toPing" type="id"></field>
<field name="postExcerpt" type="id"></field>
<field name="commentStatus" type="id"></field>
<field name="pinged" type="id"></field>
<field name="postStatus" type="id"></field>
<field name="ID" type="id"></field>
<field name="postDateGmt" type="id"></field>
<field name="postTitle" type="id"></field>
<field name="postPassword" type="id"></field>
<field name="postContent" type="id"></field>
<field name="postType" type="id"></field>
<prim-key field="ID"/>
</entity>
</entitymodel>
----------------------END
entitymodel.xml----------------------------------------------------
----------------------entitygroup.xml:-------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!-- Licensed to the Apache Software Foundation (ASF) under one or more
contributor
license agreements. See the NOTICE file distributed with this work for
additional
information regarding copyright ownership. The ASF licenses this file to
you under the Apache License, Version 2.0 (the "License"); you may not use
this file except in compliance with the License. You may obtain a copy of
the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required
by applicable law or agreed to in writing, software distributed under the
License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR
CONDITIONS
OF ANY KIND, either express or implied. See the License for the specific
language governing permissions and limitations under the License. -->
<entitygroup xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitygroup.xsd">
</entitygroup>
<delegator name="test_mysql" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz.test_mysql"
datasource-name="test_mysql"/>
</delegator>
<entity-group group="test_mysql" entity="WpPosts" />
----------------------entitygroup.xml:-------------------------------------------------------
(below is only the added part of the existing file
/framework/entitydef/config/entityengine.xml)
----------------------entityengine.xml (the data-source
part)-------------------------------
<datasource name="test_mysql"
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="latin1"
collate="latin1_general_cs">
<read-data reader-name="seed"/>
<read-data reader-name="seed-initial"/>
<read-data reader-name="demo"/>
<read-data reader-name="ext"/>
<read-data reader-name="main"/>
<inline-jdbc
jdbc-driver="com.mysql.jdbc.Driver"
jdbc-uri="jdbc:mysql://127.0.0.1:3306/wp_platfo"
jdbc-username="test"
jdbc-password="test"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"
time-between-eviction-runs-millis="600000" />
</datasource>
----------------------END entityengine.xml------------------------------
Meanwhile searching in the entity with
https://localhost:8443/webtools/control/FindGeneric?entityName=WpPosts
does not lead to errors anymore but to empty records.
(the wordpress-table has some entries which could be imported).
Thank you for further ideas to get the import to work correctly!
Re: connection with external database
Posted by "info@agentur-m3.de" <in...@agentur-m3.de>.
I did and the error disappeared.
Thanks!
Am 07.12.2014 um 16:26 schrieb Adrian Crum:
> Use the col-name attribute in the <field> element to specify the MySQL
> field name.
>
> Adrian Crum
> Sandglass Software
> www.sandglass-software.com
>
> On 12/7/2014 12:09 PM, info@agentur-m3.de wrote:
>> Hi All!
>>
>> still I try to connect ofbiz to a wordpress database.
>>
>> After editing of the field-types (see below)
>> and reducing on a single table (wpposts) most of
>> the field-type errors disappered (one still remains
>> concerning the ID field, which is primary key, see below).
>>
>> Here is the error, which occurs at starting ofbiz:
>>
>> 20141207125054905 |OFBiz-config-0 |DatabaseUtil |I| Getting
>> Table Info From Database
>> 20141207125054905 |OFBiz-config-2 |DatabaseUtil |I| Getting
>> Table Info From Database
>> 20141207125055178 |OFBiz-config-0 |DatabaseUtil |I| Getting
>> Column Info From Database
>> 20141207125055178 |OFBiz-config-1 |DatabaseUtil |I| Getting
>> Column Info From Database
>> 20141207125055278 |OFBiz-config-0 |DatabaseUtil |W| Error
>> getting primary key info from database with null tableName, will try
>> other means: java.sql.SQLException: Table name can not be null
>> 20141207125055282 |OFBiz-config-0 |DatabaseUtil |I|
>> Searching in 6 tables for primary key fields ...
>> 20141207125055322 |OFBiz-config-0 |DatabaseUtil |I|
>> Reviewed 8 primary key fields from database.
>> 20141207125055681 |OFBiz-config-2 |DatabaseUtil |I| Getting
>> Column Info From Database
>> 20141207125055723 |OFBiz-config-1 |DatabaseUtil |W| Error
>> getting primary key info from database with null tableName, will try
>> other means: java.sql.SQLException: Table name can not be null
>> 20141207125055736 |OFBiz-config-1 |DatabaseUtil |I|
>> Searching in 4 tables for primary key fields ...
>> 20141207125055781 |OFBiz-config-1 |DatabaseUtil |I|
>> Reviewed 6 primary key fields from database.
>> 20141207125057044 |OFBiz-config-2 |DatabaseUtil |W| Error
>> getting primary key info from database with null tableName, will try
>> other means: java.sql.SQLException: Table name can not be null
>> 20141207125057046 |OFBiz-config-2 |DatabaseUtil |I|
>> Searching in 841 tables for primary key fields ...
>> 20141207125058131 |OFBiz-config-2 |DatabaseUtil |I|
>> Reviewed 1641 primary key fields from database.
>> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Column
>> [ID] of table [OFBIZ.WP_POSTS] of entity [WpPosts] exists in the
>> database but has no corresponding field
>> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Column
>> [I___D] of table [OFBIZ.WP_POSTS] of entity [WpPosts] exists in the
>> database but has no corresponding field
>> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Column
>> [I__D] of table [OFBIZ.WP_POSTS] of entity [WpPosts] exists in the
>> database but has no corresponding field
>> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Entity
>> [WpPosts] has 27 fields but table [OFBIZ.WP_POSTS] has 30 columns.
>>
>>
>> -----------------------------------------------
>> Both the entity-fields as the database have 23 fields (not 27 or 30) !??
>> The field ID seems to be defined. I also tried I_D and I__D, both
>> did not work as well.
>>
>> Here the content of the tree involved entity-files:
>>
>>
>> --------------------------entitymodel.xml----------------------------------------------------
>>
>> <entitymodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>
>> xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitymodel.xsd">
>>
>> <!-- ========================================================= -->
>> <!-- ======================== Defaults ======================= -->
>> <!-- ========================================================= -->
>> <title>Entity of an Apache Open For Business Project (Apache OFBiz)
>> Component</title>
>> <description>None</description>
>> <copyright>Copyright 2001-2012 The Apache Software
>> Foundation</copyright>
>> <author>None</author>
>> <version>1.0</version>
>>
>> <entity entity-name="WpPosts"
>> package-name=""
>> title="None"
>> copyright="Copyright 2001-2014 The Apache Software
>> Foundation">
>> <field name="menuOrder" type="id"></field>
>> <field name="postModified" type="id"></field>
>> <field name="postMimeType" type="id"></field>
>> <field name="guid" type="id"></field>
>> <field name="postAuthor" type="id"></field>
>> <field name="postModifiedGmt" type="id"></field>
>> <field name="postName" type="id"></field>
>> <field name="commentCount" type="id"></field>
>> <field name="postDate" type="id"></field>
>> <field name="postContentFiltered" type="id"></field>
>> <field name="pingStatus" type="id"></field>
>> <field name="postParent" type="id"></field>
>> <field name="toPing" type="id"></field>
>> <field name="postExcerpt" type="id"></field>
>> <field name="commentStatus" type="id"></field>
>> <field name="pinged" type="id"></field>
>> <field name="postStatus" type="id"></field>
>> <field name="ID" type="id"></field>
>> <field name="postDateGmt" type="id"></field>
>> <field name="postTitle" type="id"></field>
>> <field name="postPassword" type="id"></field>
>> <field name="postContent" type="id"></field>
>> <field name="postType" type="id"></field>
>> <prim-key field="ID"/>
>> </entity>
>> </entitymodel>
>> ----------------------END
>> entitymodel.xml----------------------------------------------------
>> ----------------------entitygroup.xml:-------------------------------------------------------
>>
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <!-- Licensed to the Apache Software Foundation (ASF) under one or more
>> contributor
>> license agreements. See the NOTICE file distributed with this work
>> for
>> additional
>> information regarding copyright ownership. The ASF licenses this
>> file to
>> you under the Apache License, Version 2.0 (the "License"); you may
>> not use
>> this file except in compliance with the License. You may obtain a
>> copy of
>> the License at http://www.apache.org/licenses/LICENSE-2.0 Unless
>> required
>> by applicable law or agreed to in writing, software distributed
>> under the
>> License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR
>> CONDITIONS
>> OF ANY KIND, either express or implied. See the License for the
>> specific
>> language governing permissions and limitations under the License. -->
>>
>> <entitygroup xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>> xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitygroup.xsd">
>>
>> </entitygroup>
>>
>> <delegator name="test_mysql" entity-model-reader="main"
>> entity-group-reader="main" entity-eca-reader="main"
>> distributed-cache-clear-enabled="false">
>> <group-map group-name="org.ofbiz.test_mysql"
>> datasource-name="test_mysql"/>
>> </delegator>
>>
>>
>> <entity-group group="test_mysql" entity="WpPosts" />
>> ----------------------entitygroup.xml:-------------------------------------------------------
>>
>>
>> (below is only the added part of the existing file
>> /framework/entitydef/config/entityengine.xml)
>>
>> ----------------------entityengine.xml (the data-source
>> part)-------------------------------
>>
>> <datasource name="test_mysql"
>> 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="latin1"
>> collate="latin1_general_cs">
>> <read-data reader-name="seed"/>
>> <read-data reader-name="seed-initial"/>
>> <read-data reader-name="demo"/>
>> <read-data reader-name="ext"/>
>> <read-data reader-name="main"/>
>> <inline-jdbc
>> jdbc-driver="com.mysql.jdbc.Driver"
>> jdbc-uri="jdbc:mysql://127.0.0.1:3306/wp_platfo"
>> jdbc-username="test"
>> jdbc-password="test"
>> isolation-level="ReadCommitted"
>> pool-minsize="2"
>> pool-maxsize="250"
>> time-between-eviction-runs-millis="600000" />
>> </datasource>
>>
>>
>> ----------------------END entityengine.xml------------------------------
>>
>> Meanwhile searching in the entity with
>> https://localhost:8443/webtools/control/FindGeneric?entityName=WpPosts
>>
>> does not lead to errors anymore but to empty records.
>> (the wordpress-table has some entries which could be imported).
>>
>>
>> Thank you for further ideas to get the import to work correctly!
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
Re: connection with external database
Posted by Adrian Crum <ad...@sandglass-software.com>.
Use the col-name attribute in the <field> element to specify the MySQL
field name.
Adrian Crum
Sandglass Software
www.sandglass-software.com
On 12/7/2014 12:09 PM, info@agentur-m3.de wrote:
> Hi All!
>
> still I try to connect ofbiz to a wordpress database.
>
> After editing of the field-types (see below)
> and reducing on a single table (wpposts) most of
> the field-type errors disappered (one still remains
> concerning the ID field, which is primary key, see below).
>
> Here is the error, which occurs at starting ofbiz:
>
> 20141207125054905 |OFBiz-config-0 |DatabaseUtil |I| Getting
> Table Info From Database
> 20141207125054905 |OFBiz-config-2 |DatabaseUtil |I| Getting
> Table Info From Database
> 20141207125055178 |OFBiz-config-0 |DatabaseUtil |I| Getting
> Column Info From Database
> 20141207125055178 |OFBiz-config-1 |DatabaseUtil |I| Getting
> Column Info From Database
> 20141207125055278 |OFBiz-config-0 |DatabaseUtil |W| Error
> getting primary key info from database with null tableName, will try
> other means: java.sql.SQLException: Table name can not be null
> 20141207125055282 |OFBiz-config-0 |DatabaseUtil |I|
> Searching in 6 tables for primary key fields ...
> 20141207125055322 |OFBiz-config-0 |DatabaseUtil |I|
> Reviewed 8 primary key fields from database.
> 20141207125055681 |OFBiz-config-2 |DatabaseUtil |I| Getting
> Column Info From Database
> 20141207125055723 |OFBiz-config-1 |DatabaseUtil |W| Error
> getting primary key info from database with null tableName, will try
> other means: java.sql.SQLException: Table name can not be null
> 20141207125055736 |OFBiz-config-1 |DatabaseUtil |I|
> Searching in 4 tables for primary key fields ...
> 20141207125055781 |OFBiz-config-1 |DatabaseUtil |I|
> Reviewed 6 primary key fields from database.
> 20141207125057044 |OFBiz-config-2 |DatabaseUtil |W| Error
> getting primary key info from database with null tableName, will try
> other means: java.sql.SQLException: Table name can not be null
> 20141207125057046 |OFBiz-config-2 |DatabaseUtil |I|
> Searching in 841 tables for primary key fields ...
> 20141207125058131 |OFBiz-config-2 |DatabaseUtil |I|
> Reviewed 1641 primary key fields from database.
> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Column
> [ID] of table [OFBIZ.WP_POSTS] of entity [WpPosts] exists in the
> database but has no corresponding field
> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Column
> [I___D] of table [OFBIZ.WP_POSTS] of entity [WpPosts] exists in the
> database but has no corresponding field
> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Column
> [I__D] of table [OFBIZ.WP_POSTS] of entity [WpPosts] exists in the
> database but has no corresponding field
> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Entity
> [WpPosts] has 27 fields but table [OFBIZ.WP_POSTS] has 30 columns.
>
>
> -----------------------------------------------
> Both the entity-fields as the database have 23 fields (not 27 or 30) !??
> The field ID seems to be defined. I also tried I_D and I__D, both
> did not work as well.
>
> Here the content of the tree involved entity-files:
>
>
> --------------------------entitymodel.xml----------------------------------------------------
> <entitymodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>
> xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitymodel.xsd">
> <!-- ========================================================= -->
> <!-- ======================== Defaults ======================= -->
> <!-- ========================================================= -->
> <title>Entity of an Apache Open For Business Project (Apache OFBiz)
> Component</title>
> <description>None</description>
> <copyright>Copyright 2001-2012 The Apache Software
> Foundation</copyright>
> <author>None</author>
> <version>1.0</version>
>
> <entity entity-name="WpPosts"
> package-name=""
> title="None"
> copyright="Copyright 2001-2014 The Apache Software Foundation">
> <field name="menuOrder" type="id"></field>
> <field name="postModified" type="id"></field>
> <field name="postMimeType" type="id"></field>
> <field name="guid" type="id"></field>
> <field name="postAuthor" type="id"></field>
> <field name="postModifiedGmt" type="id"></field>
> <field name="postName" type="id"></field>
> <field name="commentCount" type="id"></field>
> <field name="postDate" type="id"></field>
> <field name="postContentFiltered" type="id"></field>
> <field name="pingStatus" type="id"></field>
> <field name="postParent" type="id"></field>
> <field name="toPing" type="id"></field>
> <field name="postExcerpt" type="id"></field>
> <field name="commentStatus" type="id"></field>
> <field name="pinged" type="id"></field>
> <field name="postStatus" type="id"></field>
> <field name="ID" type="id"></field>
> <field name="postDateGmt" type="id"></field>
> <field name="postTitle" type="id"></field>
> <field name="postPassword" type="id"></field>
> <field name="postContent" type="id"></field>
> <field name="postType" type="id"></field>
> <prim-key field="ID"/>
> </entity>
> </entitymodel>
> ----------------------END
> entitymodel.xml----------------------------------------------------
> ----------------------entitygroup.xml:-------------------------------------------------------
>
> <?xml version="1.0" encoding="UTF-8"?>
> <!-- Licensed to the Apache Software Foundation (ASF) under one or more
> contributor
> license agreements. See the NOTICE file distributed with this work for
> additional
> information regarding copyright ownership. The ASF licenses this file to
> you under the Apache License, Version 2.0 (the "License"); you may not use
> this file except in compliance with the License. You may obtain a copy of
> the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required
> by applicable law or agreed to in writing, software distributed under the
> License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR
> CONDITIONS
> OF ANY KIND, either express or implied. See the License for the specific
> language governing permissions and limitations under the License. -->
>
> <entitygroup xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitygroup.xsd">
> </entitygroup>
>
> <delegator name="test_mysql" entity-model-reader="main"
> entity-group-reader="main" entity-eca-reader="main"
> distributed-cache-clear-enabled="false">
> <group-map group-name="org.ofbiz.test_mysql"
> datasource-name="test_mysql"/>
> </delegator>
>
>
> <entity-group group="test_mysql" entity="WpPosts" />
> ----------------------entitygroup.xml:-------------------------------------------------------
>
> (below is only the added part of the existing file
> /framework/entitydef/config/entityengine.xml)
>
> ----------------------entityengine.xml (the data-source
> part)-------------------------------
>
> <datasource name="test_mysql"
> 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="latin1"
> collate="latin1_general_cs">
> <read-data reader-name="seed"/>
> <read-data reader-name="seed-initial"/>
> <read-data reader-name="demo"/>
> <read-data reader-name="ext"/>
> <read-data reader-name="main"/>
> <inline-jdbc
> jdbc-driver="com.mysql.jdbc.Driver"
> jdbc-uri="jdbc:mysql://127.0.0.1:3306/wp_platfo"
> jdbc-username="test"
> jdbc-password="test"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="250"
> time-between-eviction-runs-millis="600000" />
> </datasource>
>
>
> ----------------------END entityengine.xml------------------------------
>
> Meanwhile searching in the entity with
> https://localhost:8443/webtools/control/FindGeneric?entityName=WpPosts
>
> does not lead to errors anymore but to empty records.
> (the wordpress-table has some entries which could be imported).
>
>
> Thank you for further ideas to get the import to work correctly!
>
>
>
>
>
>
>
>
>
>
>
>
>
Re: connection with external database
Posted by gil portenseigne <gi...@nereide.fr>.
We already answered you, we can't do it for you. Please just send a mail
to user-unsubscribe@ofbiz.apache.org and you'll be unsubscribed.
Gil
On 07/12/2014 14:34, Sumit Sabu wrote:
> REMOVE me from this crap email chain,.
>
> I am not a part of this email chain.
>
> On Sun, Dec 7, 2014 at 5:39 PM, info@agentur-m3.de <in...@agentur-m3.de>
> wrote:
>
>> Hi All!
>>
>> still I try to connect ofbiz to a wordpress database.
>>
>> After editing of the field-types (see below)
>> and reducing on a single table (wpposts) most of
>> the field-type errors disappered (one still remains
>> concerning the ID field, which is primary key, see below).
>>
>> Here is the error, which occurs at starting ofbiz:
>>
>> 20141207125054905 |OFBiz-config-0 |DatabaseUtil |I| Getting
>> Table Info From Database
>> 20141207125054905 |OFBiz-config-2 |DatabaseUtil |I| Getting
>> Table Info From Database
>> 20141207125055178 |OFBiz-config-0 |DatabaseUtil |I| Getting
>> Column Info From Database
>> 20141207125055178 |OFBiz-config-1 |DatabaseUtil |I| Getting
>> Column Info From Database
>> 20141207125055278 |OFBiz-config-0 |DatabaseUtil |W| Error
>> getting primary key info from database with null tableName, will try
>> other means: java.sql.SQLException: Table name can not be null
>> 20141207125055282 |OFBiz-config-0 |DatabaseUtil |I|
>> Searching in 6 tables for primary key fields ...
>> 20141207125055322 |OFBiz-config-0 |DatabaseUtil |I|
>> Reviewed 8 primary key fields from database.
>> 20141207125055681 |OFBiz-config-2 |DatabaseUtil |I| Getting
>> Column Info From Database
>> 20141207125055723 |OFBiz-config-1 |DatabaseUtil |W| Error
>> getting primary key info from database with null tableName, will try
>> other means: java.sql.SQLException: Table name can not be null
>> 20141207125055736 |OFBiz-config-1 |DatabaseUtil |I|
>> Searching in 4 tables for primary key fields ...
>> 20141207125055781 |OFBiz-config-1 |DatabaseUtil |I|
>> Reviewed 6 primary key fields from database.
>> 20141207125057044 |OFBiz-config-2 |DatabaseUtil |W| Error
>> getting primary key info from database with null tableName, will try
>> other means: java.sql.SQLException: Table name can not be null
>> 20141207125057046 |OFBiz-config-2 |DatabaseUtil |I|
>> Searching in 841 tables for primary key fields ...
>> 20141207125058131 |OFBiz-config-2 |DatabaseUtil |I|
>> Reviewed 1641 primary key fields from database.
>> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Column
>> [ID] of table [OFBIZ.WP_POSTS] of entity [WpPosts] exists in the
>> database but has no corresponding field
>> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Column
>> [I___D] of table [OFBIZ.WP_POSTS] of entity [WpPosts] exists in the
>> database but has no corresponding field
>> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Column
>> [I__D] of table [OFBIZ.WP_POSTS] of entity [WpPosts] exists in the
>> database but has no corresponding field
>> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Entity
>> [WpPosts] has 27 fields but table [OFBIZ.WP_POSTS] has 30 columns.
>>
>>
>> -----------------------------------------------
>> Both the entity-fields as the database have 23 fields (not 27 or 30) !??
>> The field ID seems to be defined. I also tried I_D and I__D, both
>> did not work as well.
>>
>> Here the content of the tree involved entity-files:
>>
>>
>>
>> --------------------------entitymodel.xml----------------------------------------------------
>> <entitymodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>
>> xsi:noNamespaceSchemaLocation="
>> http://ofbiz.apache.org/dtds/entitymodel.xsd">
>> <!-- ========================================================= -->
>> <!-- ======================== Defaults ======================= -->
>> <!-- ========================================================= -->
>> <title>Entity of an Apache Open For Business Project (Apache OFBiz)
>> Component</title>
>> <description>None</description>
>> <copyright>Copyright 2001-2012 The Apache Software
>> Foundation</copyright>
>> <author>None</author>
>> <version>1.0</version>
>>
>> <entity entity-name="WpPosts"
>> package-name=""
>> title="None"
>> copyright="Copyright 2001-2014 The Apache Software Foundation">
>> <field name="menuOrder" type="id"></field>
>> <field name="postModified" type="id"></field>
>> <field name="postMimeType" type="id"></field>
>> <field name="guid" type="id"></field>
>> <field name="postAuthor" type="id"></field>
>> <field name="postModifiedGmt" type="id"></field>
>> <field name="postName" type="id"></field>
>> <field name="commentCount" type="id"></field>
>> <field name="postDate" type="id"></field>
>> <field name="postContentFiltered" type="id"></field>
>> <field name="pingStatus" type="id"></field>
>> <field name="postParent" type="id"></field>
>> <field name="toPing" type="id"></field>
>> <field name="postExcerpt" type="id"></field>
>> <field name="commentStatus" type="id"></field>
>> <field name="pinged" type="id"></field>
>> <field name="postStatus" type="id"></field>
>> <field name="ID" type="id"></field>
>> <field name="postDateGmt" type="id"></field>
>> <field name="postTitle" type="id"></field>
>> <field name="postPassword" type="id"></field>
>> <field name="postContent" type="id"></field>
>> <field name="postType" type="id"></field>
>> <prim-key field="ID"/>
>> </entity>
>> </entitymodel>
>> ----------------------END
>> entitymodel.xml----------------------------------------------------
>>
>> ----------------------entitygroup.xml:-------------------------------------------------------
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <!-- Licensed to the Apache Software Foundation (ASF) under one or more
>> contributor
>> license agreements. See the NOTICE file distributed with this work
>> for
>> additional
>> information regarding copyright ownership. The ASF licenses this
>> file to
>> you under the Apache License, Version 2.0 (the "License"); you may
>> not use
>> this file except in compliance with the License. You may obtain a
>> copy of
>> the License at http://www.apache.org/licenses/LICENSE-2.0 Unless
>> required
>> by applicable law or agreed to in writing, software distributed
>> under the
>> License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR
>> CONDITIONS
>> OF ANY KIND, either express or implied. See the License for the
>> specific
>> language governing permissions and limitations under the License.
>> -->
>>
>> <entitygroup xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>> xsi:noNamespaceSchemaLocation="
>> http://ofbiz.apache.org/dtds/entitygroup.xsd">
>> </entitygroup>
>>
>> <delegator name="test_mysql" entity-model-reader="main"
>> entity-group-reader="main" entity-eca-reader="main"
>> distributed-cache-clear-enabled="false">
>> <group-map group-name="org.ofbiz.test_mysql"
>> datasource-name="test_mysql"/>
>> </delegator>
>>
>>
>> <entity-group group="test_mysql" entity="WpPosts" />
>>
>> ----------------------entitygroup.xml:-------------------------------------------------------
>>
>> (below is only the added part of the existing file
>> /framework/entitydef/config/entityengine.xml)
>>
>> ----------------------entityengine.xml (the data-source
>> part)-------------------------------
>>
>> <datasource name="test_mysql"
>> 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="latin1"
>> collate="latin1_general_cs">
>> <read-data reader-name="seed"/>
>> <read-data reader-name="seed-initial"/>
>> <read-data reader-name="demo"/>
>> <read-data reader-name="ext"/>
>> <read-data reader-name="main"/>
>> <inline-jdbc
>> jdbc-driver="com.mysql.jdbc.Driver"
>> jdbc-uri="jdbc:mysql://127.0.0.1:3306/wp_platfo"
>> jdbc-username="test"
>> jdbc-password="test"
>> isolation-level="ReadCommitted"
>> pool-minsize="2"
>> pool-maxsize="250"
>> time-between-eviction-runs-millis="600000" />
>> </datasource>
>>
>>
>> ----------------------END entityengine.xml------------------------------
>>
>> Meanwhile searching in the entity with
>> https://localhost:8443/webtools/control/FindGeneric?entityName=WpPosts
>>
>> does not lead to errors anymore but to empty records.
>> (the wordpress-table has some entries which could be imported).
>>
>>
>> Thank you for further ideas to get the import to work correctly!
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
--
<www.nereide.fr>
Gil Portenseigne
Consultant ERP OFBiz
Société Néréide
3b Les isles
37270 Veretz
Tel : 09 74 53 46 09, puis 1, poste 61
Mob : 06 82 740 444
www.nereide.fr <http://www.nereide.fr>
Re: connection with external database
Posted by Sumit Sabu <sa...@gmail.com>.
REMOVE me from this crap email chain,.
I am not a part of this email chain.
On Sun, Dec 7, 2014 at 5:39 PM, info@agentur-m3.de <in...@agentur-m3.de>
wrote:
> Hi All!
>
> still I try to connect ofbiz to a wordpress database.
>
> After editing of the field-types (see below)
> and reducing on a single table (wpposts) most of
> the field-type errors disappered (one still remains
> concerning the ID field, which is primary key, see below).
>
> Here is the error, which occurs at starting ofbiz:
>
> 20141207125054905 |OFBiz-config-0 |DatabaseUtil |I| Getting
> Table Info From Database
> 20141207125054905 |OFBiz-config-2 |DatabaseUtil |I| Getting
> Table Info From Database
> 20141207125055178 |OFBiz-config-0 |DatabaseUtil |I| Getting
> Column Info From Database
> 20141207125055178 |OFBiz-config-1 |DatabaseUtil |I| Getting
> Column Info From Database
> 20141207125055278 |OFBiz-config-0 |DatabaseUtil |W| Error
> getting primary key info from database with null tableName, will try
> other means: java.sql.SQLException: Table name can not be null
> 20141207125055282 |OFBiz-config-0 |DatabaseUtil |I|
> Searching in 6 tables for primary key fields ...
> 20141207125055322 |OFBiz-config-0 |DatabaseUtil |I|
> Reviewed 8 primary key fields from database.
> 20141207125055681 |OFBiz-config-2 |DatabaseUtil |I| Getting
> Column Info From Database
> 20141207125055723 |OFBiz-config-1 |DatabaseUtil |W| Error
> getting primary key info from database with null tableName, will try
> other means: java.sql.SQLException: Table name can not be null
> 20141207125055736 |OFBiz-config-1 |DatabaseUtil |I|
> Searching in 4 tables for primary key fields ...
> 20141207125055781 |OFBiz-config-1 |DatabaseUtil |I|
> Reviewed 6 primary key fields from database.
> 20141207125057044 |OFBiz-config-2 |DatabaseUtil |W| Error
> getting primary key info from database with null tableName, will try
> other means: java.sql.SQLException: Table name can not be null
> 20141207125057046 |OFBiz-config-2 |DatabaseUtil |I|
> Searching in 841 tables for primary key fields ...
> 20141207125058131 |OFBiz-config-2 |DatabaseUtil |I|
> Reviewed 1641 primary key fields from database.
> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Column
> [ID] of table [OFBIZ.WP_POSTS] of entity [WpPosts] exists in the
> database but has no corresponding field
> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Column
> [I___D] of table [OFBIZ.WP_POSTS] of entity [WpPosts] exists in the
> database but has no corresponding field
> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Column
> [I__D] of table [OFBIZ.WP_POSTS] of entity [WpPosts] exists in the
> database but has no corresponding field
> 20141207125058168 |OFBiz-config-2 |DatabaseUtil |W| Entity
> [WpPosts] has 27 fields but table [OFBIZ.WP_POSTS] has 30 columns.
>
>
> -----------------------------------------------
> Both the entity-fields as the database have 23 fields (not 27 or 30) !??
> The field ID seems to be defined. I also tried I_D and I__D, both
> did not work as well.
>
> Here the content of the tree involved entity-files:
>
>
>
> --------------------------entitymodel.xml----------------------------------------------------
> <entitymodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>
> xsi:noNamespaceSchemaLocation="
> http://ofbiz.apache.org/dtds/entitymodel.xsd">
> <!-- ========================================================= -->
> <!-- ======================== Defaults ======================= -->
> <!-- ========================================================= -->
> <title>Entity of an Apache Open For Business Project (Apache OFBiz)
> Component</title>
> <description>None</description>
> <copyright>Copyright 2001-2012 The Apache Software
> Foundation</copyright>
> <author>None</author>
> <version>1.0</version>
>
> <entity entity-name="WpPosts"
> package-name=""
> title="None"
> copyright="Copyright 2001-2014 The Apache Software Foundation">
> <field name="menuOrder" type="id"></field>
> <field name="postModified" type="id"></field>
> <field name="postMimeType" type="id"></field>
> <field name="guid" type="id"></field>
> <field name="postAuthor" type="id"></field>
> <field name="postModifiedGmt" type="id"></field>
> <field name="postName" type="id"></field>
> <field name="commentCount" type="id"></field>
> <field name="postDate" type="id"></field>
> <field name="postContentFiltered" type="id"></field>
> <field name="pingStatus" type="id"></field>
> <field name="postParent" type="id"></field>
> <field name="toPing" type="id"></field>
> <field name="postExcerpt" type="id"></field>
> <field name="commentStatus" type="id"></field>
> <field name="pinged" type="id"></field>
> <field name="postStatus" type="id"></field>
> <field name="ID" type="id"></field>
> <field name="postDateGmt" type="id"></field>
> <field name="postTitle" type="id"></field>
> <field name="postPassword" type="id"></field>
> <field name="postContent" type="id"></field>
> <field name="postType" type="id"></field>
> <prim-key field="ID"/>
> </entity>
> </entitymodel>
> ----------------------END
> entitymodel.xml----------------------------------------------------
>
> ----------------------entitygroup.xml:-------------------------------------------------------
>
> <?xml version="1.0" encoding="UTF-8"?>
> <!-- Licensed to the Apache Software Foundation (ASF) under one or more
> contributor
> license agreements. See the NOTICE file distributed with this work
> for
> additional
> information regarding copyright ownership. The ASF licenses this
> file to
> you under the Apache License, Version 2.0 (the "License"); you may
> not use
> this file except in compliance with the License. You may obtain a
> copy of
> the License at http://www.apache.org/licenses/LICENSE-2.0 Unless
> required
> by applicable law or agreed to in writing, software distributed
> under the
> License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR
> CONDITIONS
> OF ANY KIND, either express or implied. See the License for the
> specific
> language governing permissions and limitations under the License.
> -->
>
> <entitygroup xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:noNamespaceSchemaLocation="
> http://ofbiz.apache.org/dtds/entitygroup.xsd">
> </entitygroup>
>
> <delegator name="test_mysql" entity-model-reader="main"
> entity-group-reader="main" entity-eca-reader="main"
> distributed-cache-clear-enabled="false">
> <group-map group-name="org.ofbiz.test_mysql"
> datasource-name="test_mysql"/>
> </delegator>
>
>
> <entity-group group="test_mysql" entity="WpPosts" />
>
> ----------------------entitygroup.xml:-------------------------------------------------------
>
> (below is only the added part of the existing file
> /framework/entitydef/config/entityengine.xml)
>
> ----------------------entityengine.xml (the data-source
> part)-------------------------------
>
> <datasource name="test_mysql"
> 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="latin1"
> collate="latin1_general_cs">
> <read-data reader-name="seed"/>
> <read-data reader-name="seed-initial"/>
> <read-data reader-name="demo"/>
> <read-data reader-name="ext"/>
> <read-data reader-name="main"/>
> <inline-jdbc
> jdbc-driver="com.mysql.jdbc.Driver"
> jdbc-uri="jdbc:mysql://127.0.0.1:3306/wp_platfo"
> jdbc-username="test"
> jdbc-password="test"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="250"
> time-between-eviction-runs-millis="600000" />
> </datasource>
>
>
> ----------------------END entityengine.xml------------------------------
>
> Meanwhile searching in the entity with
> https://localhost:8443/webtools/control/FindGeneric?entityName=WpPosts
>
> does not lead to errors anymore but to empty records.
> (the wordpress-table has some entries which could be imported).
>
>
> Thank you for further ideas to get the import to work correctly!
>
>
>
>
>
>
>
>
>
>
>
>
>
>