what does your database URL look like?

On 2013-01-09 16:08, Kais Haddadin wrote:
the stacktrace is attached


On Wed, Jan 9, 2013 at 2:13 PM, Noel Grandin <[email protected] <mailto:[email protected]>> wrote:

    Can you please post the entire stacktrace?


    On 2013-01-09 15:03, kais haddadin wrote:
    Hello,

    I try to open the H2 database version (1.3.168) and am getting
    this error:

    "Sequenz "SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F"
    nicht gefunden
    Sequence "SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F"
    not found; SQL statement:
    CREATE CACHED TABLE FCM.LAGERBESTÄNDE(
        "#id" INTEGER DEFAULT (NEXT VALUE FOR
    FCM.SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F) NOT
    NULL NULL_TO_DEFAULT SEQUENCE
    FCM.SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F
    SELECTIVITY 100,
        SCENARIO VARCHAR(32672) SELECTIVITY 1,
        JAHR VARCHAR(32672) SELECTIVITY 1,
        MONAT VARCHAR(32672) SELECTIVITY 1,
        ARTIKEL VARCHAR(32672) SELECTIVITY 97,
        LAGERORT VARCHAR(32672) SELECTIVITY 1,
        EINHEIT VARCHAR(32672) SELECTIVITY 1,
        "#VALUE" DOUBLE SELECTIVITY 6
    )
    
<http://192.168.2.52:8082/login.do?jsessionid=e60f6ed39eaa5eb82e5e62554c7147e1#>"

    but I did not create this, I created a table with Autoincrement
    column, the query should look like this :

    CREATE TABLE FCM.LAGERBESTÄNDE
    
<http://192.168.2.52:8082/login.do?jsessionid=e60f6ed39eaa5eb82e5e62554c7147e1#>

    ("#id" INTEGER PRIMARY KEY AUTO_INCREMENT,...

    Is this a known bug? I can not reproduce the problem, but It
    seems to happen sometimes.
    I can attach the database but it is 30MB after compression.

    Regards,

    Kais
-- You received this message because you are subscribed to the
    Google Groups "H2 Database" group.
    To view this discussion on the web visit
    https://groups.google.com/d/msg/h2-database/-/iDm121_u8oUJ.
    To post to this group, send email to [email protected]
    <mailto:[email protected]>.
    To unsubscribe from this group, send email to
    [email protected]
    <mailto:[email protected]>.
    For more options, visit this group at
    http://groups.google.com/group/h2-database?hl=en.



--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to