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 |
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. > |
In reply to this post by SRINIKALLS
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. |
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 +91-9930302283cell |
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
|
In reply to this post by David E. Jones-2
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.
|
In reply to this post by BJ Freeman
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
|
Free forum by Nabble | Edit this page |