Hello
I need your Help. I am using Linux (fedora 7) for ofbiz. When i am using derby database, it working fine. but when shifted to MySql 5. it show some exceptions: like table not found. but table exist in lower case. that is the issue case sensitive?. Please help me resolve this issue Thanks in Advance Regards Vishal Kataria |
linux and java are case sensitive.
Vishalkataria sent the following on 8/8/2008 5:58 AM: > Hello > > I need your Help. I am using Linux (fedora 7) for ofbiz. When i am using > derby database, it working fine. but when shifted to MySql 5. it show some > exceptions: like table not found. but table exist in lower case. that is the > issue case sensitive?. > > Please help me resolve this issue > > Thanks in Advance > > Regards > > Vishal Kataria |
Hi Bj
please guide me how can i resolve this issue in ofbiz like: in which file required changes. Thanks in Advance Regards Vishal Kataria
|
Not sure how you got this table created.
or if you have data in the db. if the db is clean then I suggest you delete the table and let ofbiz re-create it. when it reboots. this requires you have the check-on-start="true" add-missing-on-start="true" in the entityengine.xml as they are now. if you have data, then it would take a db admin program to go in and change the table name to match. Usually, though I don't know about mysql, this takes care of any FK that may be attached to the db. Vishalkataria sent the following on 8/8/2008 6:08 AM: > Hi Bj > > please guide me how can i resolve this issue in ofbiz > > like: in which file required changes. > > Thanks in Advance > > Regards > Vishal Kataria > > BJ Freeman wrote: >> linux and java are case sensitive. >> >> Vishalkataria sent the following on 8/8/2008 5:58 AM: >>> Hello >>> >>> I need your Help. I am using Linux (fedora 7) for ofbiz. When i am using >>> derby database, it working fine. but when shifted to MySql 5. it show >>> some >>> exceptions: like table not found. but table exist in lower case. that is >>> the >>> issue case sensitive?. >>> >>> Please help me resolve this issue >>> >>> Thanks in Advance >>> >>> Regards >>> >>> Vishal Kataria >> >> > |
In reply to this post by Vishalkataria
You should change the case sensitive settings in the my.cnf file.
In my linux box it exists in /etc/ See the Fedora is also derived from Red Hat so my.cnf will also present in /etc/ Here is the settings :- lower_case_table_names=1 Below article will help you. http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html I remembered that after doing this change you may need to do clean installation of Database. Please let us know if you need more help on this. On Fri, Aug 8, 2008 at 6:38 PM, Vishalkataria <[hidden email]>wrote: > > Hi Bj > > please guide me how can i resolve this issue in ofbiz > > like: in which file required changes. > > Thanks in Advance > > Regards > Vishal Kataria > > BJ Freeman wrote: > > > > linux and java are case sensitive. > > > > Vishalkataria sent the following on 8/8/2008 5:58 AM: > >> Hello > >> > >> I need your Help. I am using Linux (fedora 7) for ofbiz. When i am using > >> derby database, it working fine. but when shifted to MySql 5. it show > >> some > >> exceptions: like table not found. but table exist in lower case. that is > >> the > >> issue case sensitive?. > >> > >> Please help me resolve this issue > >> > >> Thanks in Advance > >> > >> Regards > >> > >> Vishal Kataria > > > > > > > > -- > View this message in context: > http://www.nabble.com/Table-no-found-exception-in-ofbiz-on-fedora-7-tp18891401p18891557.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > > -- Ashish Vijaywargiya Indore (M.P), India http://en.wikipedia.org/wiki/Indore |
Thanks Vijay
Everthing Working fine now REgards Vishal Kataria
|
I am feeling very happy to see it worked for you :-)
On Fri, Aug 8, 2008 at 8:05 PM, Vishalkataria <[hidden email]>wrote: > > Thanks Vijay > > Everthing Working fine now > > > REgards > > Vishal Kataria > > > Ashish Vijaywargiya-4 wrote: > > > > You should change the case sensitive settings in the my.cnf file. > > In my linux box it exists in /etc/ > > > > See the Fedora is also derived from Red Hat so my.cnf will also present > in > > /etc/ > > > > Here is the settings :- > > lower_case_table_names=1 > > > > Below article will help you. > > http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html > > > > I remembered that after doing this change you may need to do clean > > installation of Database. > > Please let us know if you need more help on this. > > > > > > > > On Fri, Aug 8, 2008 at 6:38 PM, Vishalkataria > > <[hidden email]>wrote: > > > >> > >> Hi Bj > >> > >> please guide me how can i resolve this issue in ofbiz > >> > >> like: in which file required changes. > >> > >> Thanks in Advance > >> > >> Regards > >> Vishal Kataria > >> > >> BJ Freeman wrote: > >> > > >> > linux and java are case sensitive. > >> > > >> > Vishalkataria sent the following on 8/8/2008 5:58 AM: > >> >> Hello > >> >> > >> >> I need your Help. I am using Linux (fedora 7) for ofbiz. When i am > >> using > >> >> derby database, it working fine. but when shifted to MySql 5. it show > >> >> some > >> >> exceptions: like table not found. but table exist in lower case. that > >> is > >> >> the > >> >> issue case sensitive?. > >> >> > >> >> Please help me resolve this issue > >> >> > >> >> Thanks in Advance > >> >> > >> >> Regards > >> >> > >> >> Vishal Kataria > >> > > >> > > >> > > >> > >> -- > >> View this message in context: > >> > http://www.nabble.com/Table-no-found-exception-in-ofbiz-on-fedora-7-tp18891401p18891557.html > >> Sent from the OFBiz - User mailing list archive at Nabble.com. > >> > >> > > > > > > -- > > Ashish Vijaywargiya > > Indore (M.P), India > > http://en.wikipedia.org/wiki/Indore > > > > > > -- > View this message in context: > http://www.nabble.com/Table-no-found-exception-in-ofbiz-on-fedora-7-tp18891401p18892923.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > > -- Ashish Vijaywargiya Indore (M.P), India http://en.wikipedia.org/wiki/Indore |
Free forum by Nabble | Edit this page |