Table no found exception in ofbiz on fedora 7

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

Table no found exception in ofbiz on fedora 7

Vishalkataria
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
Reply | Threaded
Open this post in threaded view
|

Re: Table no found exception in ofbiz on fedora 7

BJ Freeman
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

Reply | Threaded
Open this post in threaded view
|

Re: Table no found exception in ofbiz on fedora 7

Vishalkataria
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
Reply | Threaded
Open this post in threaded view
|

Re: Table no found exception in ofbiz on fedora 7

BJ Freeman
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
>>
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: Table no found exception in ofbiz on fedora 7

Ashish Vijaywargiya
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
Reply | Threaded
Open this post in threaded view
|

Re: Table no found exception in ofbiz on fedora 7

Vishalkataria
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
<vishal.kataria@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
Reply | Threaded
Open this post in threaded view
|

Re: Table no found exception in ofbiz on fedora 7

Ashish Vijaywargiya
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