You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Vishalkataria <vi...@hytechpro.com> on 2008/08/08 14:58:06 UTC
Table no found exception in ofbiz on fedora 7
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-tp18891401p18891401.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Table no found exception in ofbiz on fedora 7
Posted by BJ Freeman <bj...@free-man.net>.
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
>>
>>
>
Re: Table no found exception in ofbiz on fedora 7
Posted by Ashish Vijaywargiya <vi...@gmail.com>.
I am feeling very happy to see it worked for you :-)
On Fri, Aug 8, 2008 at 8:05 PM, Vishalkataria
<vi...@hytechpro.com>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
> > <vi...@hytechpro.com>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
Re: Table no found exception in ofbiz on fedora 7
Posted by Vishalkataria <vi...@hytechpro.com>.
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
> <vi...@hytechpro.com>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.
Re: Table no found exception in ofbiz on fedora 7
Posted by Ashish Vijaywargiya <vi...@gmail.com>.
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
<vi...@hytechpro.com>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
Re: Table no found exception in ofbiz on fedora 7
Posted by Vishalkataria <vi...@hytechpro.com>.
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.
Re: Table no found exception in ofbiz on fedora 7
Posted by BJ Freeman <bj...@free-man.net>.
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