dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

Hi Knut

Seems like something schizophrenic is happening.  As far as I know MySQL
does not support or use sequences.  It uses auto-incrementing instead.

It looks almost like you're trying to import something from postgres sql to
mysql.  What are you doing when you get this error?  Any chance that you
have a mixed up config -eg using postgresql dialect but loading mysql
driver?

Bob

2009/8/30 Knut Staring <knutst@xxxxxxxxx>

> Indeed. I wonder if someone knows what that query is, as it seems to want
> to access the information_schema database, and not the DHIS2 database.
>
> I suppose DHIS2 needs for there to be a Sequences table in the MySql
> information_schema base - does anyone know the details? And has anyone
> encountered this problem before? Could it have to do with privileges for
> that db?
>
> K
>
> On Sun, Aug 30, 2009 at 6:04 AM, Orvalho Joaquim Augusto <
> orvaquim@xxxxxxxxx> wrote:
>
>> Well, this means that somewhere there is a query referincing a table with
>> name 'sequences' and it does not exist on the database.
>>
>> Start by checking that.
>>
>> Caveman
>>
>>
>> Knut Staring wrote:
>>
>>> I am getting the below error.
>>>
>>> * ERROR 14:11:12,988 could not get database metadata (SchemaUpdate.java
>>> [main])
>>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table
>>> 'sequences' in information_schema
>>>
>>>
>>> --
>>> Cheers,
>>> Knut Staring
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>>
>>
>
>
> --
> Cheers,
> Knut Staring
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp
>
>