Problems in setting up ofbiz on MY SQL

[SRINIKALLS]

Hi,
1)I changed the data source to mysql in entity engine.xml , also updated the same in the deligator.

2) I created a data base called ofbiz in MYSQL.

3) at the command prompt i issued the following command java -jar ofbiz.jar -install

4) After few seconds of execution(full of exceptions)

5) I see a lot of MYSQL exceptions saying that tables are not existing.

please let me know if i need to follow any other alternative steps in this regard

I am using  mysql-connector-java-5.1.7 driver for this activity.

thanks
Srinivas




The Sample Exception is

2009-06-22 17:40:02,472 (main) [       DatabaseUtil.java:343:WARN ] Entity [FacilityContactMechPurpose] has no table in the database
2009-06-22 17:40:02,472 (main) [       DatabaseUtil.java:351:ERROR] Could not create table [FACILITY_CONTACT_MECH_PURPOSE]: SQL Exception while executing the following:
CREATE TABLE FACILITY_CONTACT_MECH_PURPOSE (FACILITY_ID VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL, CONTACT_MECH_ID VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL, CONTACT_MECH_PURPOSE_TYPE_ID VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL, FROM_DATE DATETIME NOT NULL, THRU_DATE DATETIME, LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_FACILITY_CONTACT_MECH_PURPO PRIMARY KEY (FACILITY_ID, CONTACT_MECH_ID, CONTACT_MECH_PURPOSE_TYPE_ID, FROM_DATE))
TYPE InnoDB CHARACTER SET latin1 COLLATE latin1_general_cs
Error was: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE InnoDB CHARACTER SET latin1 COLLATE latin1_general_cs' at line 1

[David E. Jones-2]

The error message the image shows looks like it is in the phase of the  
install process for loading seed and demo data, and it is not finding  
tables in the database that should already be created.

What are the settings for the mysql datasource in the entityengine.xml  
file? Do you have the create-missing attribute set to true?

One way or another the table is not in the database, and must be  
created first. Normally OFBiz looks for missing tables and columns on  
startup and adds the missing ones (ie in the entity model but not in  
the database). If that is turned off, this is the expected behavior.  
There could be other problems too, so look at the beginning of the log  
to see the first error(s) during startup.

-David


On Jun 22, 2009, at 6:49 AM, SRINIKALLS wrote:

>
> Hi,
> 1)I changed the data source to mysql in entity engine.xml , also  
> updated the
> same in the deligator.
>
> 2) I created a data base called ofbiz in MYSQL.
>
> 3) at the command prompt i issued the following command java -jar  
> ofbiz.jar
> -install
>
> 4) After few seconds of execution(full of exceptions)
>
> 5) I see a lot of MYSQL exceptions saying that tables are not  
> existing.
>
> please let me know if i need to follow any other alternative steps  
> in this
> regard
>
> I am using  mysql-connector-java-5.1.7 driver for this activity.
>
> thanks
> Srinivas
>
> http://www.nabble.com/file/p24146609/MSQL%2BError.gif
> --
> View this message in context: http://www.nabble.com/Problems-in-setting-up-ofbiz-on-MY-SQL-tp24146609p24146609.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[BJ Freeman]

when you first start ofbiz it has to build the database.
if you see this the second time then you probably have connection problems.


SRINIKALLS sent the following on 6/22/2009 5:49 AM:

> Hi,
> 1)I changed the data source to mysql in entity engine.xml , also updated the
> same in the deligator.
>
> 2) I created a data base called ofbiz in MYSQL.
>
> 3) at the command prompt i issued the following command java -jar ofbiz.jar
> -install
>
> 4) After few seconds of execution(full of exceptions)
>
> 5) I see a lot of MYSQL exceptions saying that tables are not existing.
>
> please let me know if i need to follow any other alternative steps in this
> regard
>
> I am using  mysql-connector-java-5.1.7 driver for this activity.
>
> thanks
> Srinivas
>
> http://www.nabble.com/file/p24146609/MSQL%2BError.gif 

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.

[anil.soni]

Did *you* use ant run-install command after database creation ?  If not
then open a command prompt and cd to the folder you have ofbiz
in, then do a *ant run-install and *start the OFBiz server.

Hope that Helps.


On Mon, Jun 22, 2009 at 8:23 PM, BJ Freeman <[hidden email]> wrote:

> when you first start ofbiz it has to build the database.
> if you see this the second time then you probably have connection problems.
>
>
> SRINIKALLS sent the following on 6/22/2009 5:49 AM:
>  > Hi,
> > 1)I changed the data source to mysql in entity engine.xml , also updated
> the
> > same in the deligator.
> >
> > 2) I created a data base called ofbiz in MYSQL.
> >
> > 3) at the command prompt i issued the following command java -jar
> ofbiz.jar
> > -install
> >
> > 4) After few seconds of execution(full of exceptions)
> >
> > 5) I see a lot of MYSQL exceptions saying that tables are not existing.
> >
> > please let me know if i need to follow any other alternative steps in
> this
> > regard
> >
> > I am using  mysql-connector-java-5.1.7 driver for this activity.
> >
> > thanks
> > Srinivas
> >
> > http://www.nabble.com/file/p24146609/MSQL%2BError.gif
>
> --
> BJ Freeman
> http://www.businessesnetwork.com/automation
> http://bjfreeman.elance.com
>
> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
> Systems Integrator.
>
>

--
Anil Soni
[phone]cell

[SRINIKALLS]

What u say is true , if you see the point number 3 it addressess that , Is it any thing to do with upper case and lower case of creation scripts have u any time attempeted creating a DB on MY SQL , did u face any problem of this sought if yes please let me know that would be useful for me

toanilsoni wrote

Did *you* use ant run-install command after database creation ?  If not
then open a command prompt and cd to the folder you have ofbiz
in, then do a *ant run-install and *start the OFBiz server.

Hope that Helps.


On Mon, Jun 22, 2009 at 8:23 PM, BJ Freeman <[e-mail]> wrote:

> when you first start ofbiz it has to build the database.
> if you see this the second time then you probably have connection problems.
>
>
> SRINIKALLS sent the following on 6/22/2009 5:49 AM:
>  > Hi,
> > 1)I changed the data source to mysql in entity engine.xml , also updated
> the
> > same in the deligator.
> >
> > 2) I created a data base called ofbiz in MYSQL.
> >
> > 3) at the command prompt i issued the following command java -jar
> ofbiz.jar
> > -install
> >
> > 4) After few seconds of execution(full of exceptions)
> >
> > 5) I see a lot of MYSQL exceptions saying that tables are not existing.
> >
> > please let me know if i need to follow any other alternative steps in
> this
> > regard
> >
> > I am using  mysql-connector-java-5.1.7 driver for this activity.
> >
> > thanks
> > Srinivas
> >
> > http://www.nabble.com/file/p24146609/MSQL%2BError.gif
>
> --
> BJ Freeman
> http://www.businessesnetwork.com/automation
> http://bjfreeman.elance.com
>
> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
> Systems Integrator.
>
>


--
Anil Soni
[phone]cell

[SRINIKALLS]

I have to check it out , I think the same settings hold true for derby too , so when i install ofbiz for the first time , obviously there would be no tables right , then the tables are automatically created so , if feel it might be some thing to do with latin related settings , i get the error from the very first table.

David E Jones-4 wrote

The error message the image shows looks like it is in the phase of the  
install process for loading seed and demo data, and it is not finding  
tables in the database that should already be created.

What are the settings for the mysql datasource in the entityengine.xml  
file? Do you have the create-missing attribute set to true?

One way or another the table is not in the database, and must be  
created first. Normally OFBiz looks for missing tables and columns on  
startup and adds the missing ones (ie in the entity model but not in  
the database). If that is turned off, this is the expected behavior.  
There could be other problems too, so look at the beginning of the log  
to see the first error(s) during startup.

-David


On Jun 22, 2009, at 6:49 AM, SRINIKALLS wrote:

>
> Hi,
> 1)I changed the data source to mysql in entity engine.xml , also  
> updated the
> same in the deligator.
>
> 2) I created a data base called ofbiz in MYSQL.
>
> 3) at the command prompt i issued the following command java -jar  
> ofbiz.jar
> -install
>
> 4) After few seconds of execution(full of exceptions)
>
> 5) I see a lot of MYSQL exceptions saying that tables are not  
> existing.
>
> please let me know if i need to follow any other alternative steps  
> in this
> regard
>
> I am using  mysql-connector-java-5.1.7 driver for this activity.
>
> thanks
> Srinivas
>
> http://www.nabble.com/file/p24146609/MSQL%2BError.gif
> --
> View this message in context: http://www.nabble.com/Problems-in-setting-up-ofbiz-on-MY-SQL-tp24146609p24146609.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[SRINIKALLS]

I think it is not a connection problem , if that is the case it would not have said , no table found in the database.
-srinivas

BJ Freeman wrote

when you first start ofbiz it has to build the database.
if you see this the second time then you probably have connection problems.


SRINIKALLS sent the following on 6/22/2009 5:49 AM:
> Hi,
> 1)I changed the data source to mysql in entity engine.xml , also updated the
> same in the deligator.
>
> 2) I created a data base called ofbiz in MYSQL.
>
> 3) at the command prompt i issued the following command java -jar ofbiz.jar
> -install
>
> 4) After few seconds of execution(full of exceptions)
>
> 5) I see a lot of MYSQL exceptions saying that tables are not existing.
>
> please let me know if i need to follow any other alternative steps in this
> regard
>
> I am using  mysql-connector-java-5.1.7 driver for this activity.
>
> thanks
> Srinivas
>
> http://www.nabble.com/file/p24146609/MSQL%2BError.gif 

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.