Autoincrement Default on UltraliteJ

#11

Hi,

Unfortunately there was a bug in the autoincrement in the
initial release of UltraLiteJ. If you get a recent Express
Bug Fix (EBF) release you will find this has been fixed.

You can download EBFs from here (you need a free
registration on sybase.com):
http://downloads.sybase.com/swd/base.do

The click SQL Anywhere and find the "Platform: Windows x86"
(as development is on Windows UltraLiteJ goes out in the
Windows release) and get the latest (build 11.0.0.1526 I
believe).

Tom

Quote:

Hi,

I understand that this place is more for ultralite on
other platform but I am really stuck and I am hoping
someone can help me here. I am trying to setup a really
simple database on a mobile device (Blackberry) using
UltraliteJ with a Autoincrement primary key. I set it up
as follows:

TableSchema table_schema = _conn.createTable("SomeTable");

column_schema = table_schema.createColumn("tid",
Domain.BIG ); column_schema.setDefault(
ColumnSchema.COLUMN_DEFAULT_AUTOINC);

index_schema =
table_schema.createPrimaryIndex("prime_keys");
index_schema.addColumn("tid", IndexSchema.ASCENDING);

But when I try to insert an item to a non-empty table
without the primary key column, I get the "tid column"
cannot be NULL error. And the funny thing is that things
worked (insert was successful) when I try to insert when
the table was first created. Any ideas?

Kenny

#12

Hi,

Unfortunately there was a bug in the autoincrement in the
initial release of UltraLiteJ. If you get a recent Express
Bug Fix (EBF) release you will find this has been fixed.

You can download EBFs from here (you need a free
registration on sybase.com):
http://downloads.sybase.com/swd/base.do

The click SQL Anywhere and find the "Platform: Windows x86"
(as development is on Windows UltraLiteJ goes out in the
Windows release) and get the latest (build 11.0.0.1526 I
believe).

Tom

Quote:

Hi,

I understand that this place is more for ultralite on
other platform but I am really stuck and I am hoping
someone can help me here. I am trying to setup a really
simple database on a mobile device (Blackberry) using
UltraliteJ with a Autoincrement primary key. I set it up
as follows:

TableSchema table_schema = _conn.createTable("SomeTable");

column_schema = table_schema.createColumn("tid",
Domain.BIG ); column_schema.setDefault(
ColumnSchema.COLUMN_DEFAULT_AUTOINC);

index_schema =
table_schema.createPrimaryIndex("prime_keys");
index_schema.addColumn("tid", IndexSchema.ASCENDING);

But when I try to insert an item to a non-empty table
without the primary key column, I get the "tid column"
cannot be NULL error. And the funny thing is that things
worked (insert was successful) when I try to insert when
the table was first created. Any ideas?

Kenny

#13

Hey Tom,

You're right. It worked. Thanks!

Kenny

On Dec 14, 3:54*pm, Tom Slee wrote:

Quote:

Hi,

Unfortunately there was a bug in the autoincrement in the
initial release of UltraLiteJ. If you get a recent Express
Bug Fix (EBF) release you will find this has been fixed.

You can download EBFs from here (you need a free
registration on sybase.com):http://downloads.sybase.com/swd/base.do

The click SQL Anywhere and find the "Platform: Windows x86"
(as development is on Windows UltraLiteJ goes out in the
Windows release) and get the latest (build 11.0.0.1526 I
believe).

Tom

Hi,

I understand that this place is more for ultralite on
other platform but I am really stuck and I am hoping
someone can help me here. *I am trying to setup a really
simple database on a mobile device (Blackberry) using
UltraliteJ with a Autoincrement primary key. *I set it up
as follows:

TableSchema table_schema = _conn.createTable("SomeTable");

column_schema = table_schema.createColumn("tid",
Domain.BIG ); column_schema.setDefault(
ColumnSchema.COLUMN_DEFAULT_AUTOINC);

index_schema =
table_schema.createPrimaryIndex("prime_keys");
index_schema.addColumn("tid", IndexSchema.ASCENDING);

But when I try to insert an item to a non-empty table
without the primary key column, I get the "tid column"
cannot be NULL error. *And the funny thing is that things
worked (insert was successful) when I try to insert when
the table was first created. *Any ideas?

Kenny

#14

Hey Tom,

You're right. It worked. Thanks!

Kenny

On Dec 14, 3:54*pm, Tom Slee wrote:

Quote:

Hi,

Unfortunately there was a bug in the autoincrement in the
initial release of UltraLiteJ. If you get a recent Express
Bug Fix (EBF) release you will find this has been fixed.

You can download EBFs from here (you need a free
registration on sybase.com):http://downloads.sybase.com/swd/base.do

The click SQL Anywhere and find the "Platform: Windows x86"
(as development is on Windows UltraLiteJ goes out in the
Windows release) and get the latest (build 11.0.0.1526 I
believe).

Tom

Hi,

I understand that this place is more for ultralite on
other platform but I am really stuck and I am hoping
someone can help me here. *I am trying to setup a really
simple database on a mobile device (Blackberry) using
UltraliteJ with a Autoincrement primary key. *I set it up
as follows:

TableSchema table_schema = _conn.createTable("SomeTable");

column_schema = table_schema.createColumn("tid",
Domain.BIG ); column_schema.setDefault(
ColumnSchema.COLUMN_DEFAULT_AUTOINC);

index_schema =
table_schema.createPrimaryIndex("prime_keys");
index_schema.addColumn("tid", IndexSchema.ASCENDING);

But when I try to insert an item to a non-empty table
without the primary key column, I get the "tid column"
cannot be NULL error. *And the funny thing is that things
worked (insert was successful) when I try to insert when
the table was first created. *Any ideas?

Kenny

#15

Hey Tom,

You're right. It worked. Thanks!

Kenny

On Dec 14, 3:54*pm, Tom Slee wrote:

Quote:

Hi,

Unfortunately there was a bug in the autoincrement in the
initial release of UltraLiteJ. If you get a recent Express
Bug Fix (EBF) release you will find this has been fixed.

You can download EBFs from here (you need a free
registration on sybase.com):http://downloads.sybase.com/swd/base.do

The click SQL Anywhere and find the "Platform: Windows x86"
(as development is on Windows UltraLiteJ goes out in the
Windows release) and get the latest (build 11.0.0.1526 I
believe).

Tom

Hi,

I understand that this place is more for ultralite on
other platform but I am really stuck and I am hoping
someone can help me here. *I am trying to setup a really
simple database on a mobile device (Blackberry) using
UltraliteJ with a Autoincrement primary key. *I set it up
as follows:

TableSchema table_schema = _conn.createTable("SomeTable");

column_schema = table_schema.createColumn("tid",
Domain.BIG ); column_schema.setDefault(
ColumnSchema.COLUMN_DEFAULT_AUTOINC);

index_schema =
table_schema.createPrimaryIndex("prime_keys");
index_schema.addColumn("tid", IndexSchema.ASCENDING);

But when I try to insert an item to a non-empty table
without the primary key column, I get the "tid column"
cannot be NULL error. *And the funny thing is that things
worked (insert was successful) when I try to insert when
the table was first created. *Any ideas?

Kenny

#16

Hey Tom,

You're right. It worked. Thanks!

Kenny

On Dec 14, 3:54*pm, Tom Slee wrote:

Quote:

Hi,

Unfortunately there was a bug in the autoincrement in the
initial release of UltraLiteJ. If you get a recent Express
Bug Fix (EBF) release you will find this has been fixed.

You can download EBFs from here (you need a free
registration on sybase.com):http://downloads.sybase.com/swd/base.do

The click SQL Anywhere and find the "Platform: Windows x86"
(as development is on Windows UltraLiteJ goes out in the
Windows release) and get the latest (build 11.0.0.1526 I
believe).

Tom

Hi,

I understand that this place is more for ultralite on
other platform but I am really stuck and I am hoping
someone can help me here. *I am trying to setup a really
simple database on a mobile device (Blackberry) using
UltraliteJ with a Autoincrement primary key. *I set it up
as follows:

TableSchema table_schema = _conn.createTable("SomeTable");

column_schema = table_schema.createColumn("tid",
Domain.BIG ); column_schema.setDefault(
ColumnSchema.COLUMN_DEFAULT_AUTOINC);

index_schema =
table_schema.createPrimaryIndex("prime_keys");
index_schema.addColumn("tid", IndexSchema.ASCENDING);

But when I try to insert an item to a non-empty table
without the primary key column, I get the "tid column"
cannot be NULL error. *And the funny thing is that things
worked (insert was successful) when I try to insert when
the table was first created. *Any ideas?

Kenny

#17

Hey Tom,

You're right. It worked. Thanks!

Kenny

On Dec 14, 3:54*pm, Tom Slee wrote:

Quote:

Hi,

Unfortunately there was a bug in the autoincrement in the
initial release of UltraLiteJ. If you get a recent Express
Bug Fix (EBF) release you will find this has been fixed.

You can download EBFs from here (you need a free
registration on sybase.com):http://downloads.sybase.com/swd/base.do

The click SQL Anywhere and find the "Platform: Windows x86"
(as development is on Windows UltraLiteJ goes out in the
Windows release) and get the latest (build 11.0.0.1526 I
believe).

Tom

Hi,

I understand that this place is more for ultralite on
other platform but I am really stuck and I am hoping
someone can help me here. *I am trying to setup a really
simple database on a mobile device (Blackberry) using
UltraliteJ with a Autoincrement primary key. *I set it up
as follows:

TableSchema table_schema = _conn.createTable("SomeTable");

column_schema = table_schema.createColumn("tid",
Domain.BIG ); column_schema.setDefault(
ColumnSchema.COLUMN_DEFAULT_AUTOINC);

index_schema =
table_schema.createPrimaryIndex("prime_keys");
index_schema.addColumn("tid", IndexSchema.ASCENDING);

But when I try to insert an item to a non-empty table
without the primary key column, I get the "tid column"
cannot be NULL error. *And the funny thing is that things
worked (insert was successful) when I try to insert when
the table was first created. *Any ideas?

Kenny

#18

Hey Tom,

You're right. It worked. Thanks!

Kenny

On Dec 14, 3:54*pm, Tom Slee wrote:

Quote:

Hi,

Unfortunately there was a bug in the autoincrement in the
initial release of UltraLiteJ. If you get a recent Express
Bug Fix (EBF) release you will find this has been fixed.

You can download EBFs from here (you need a free
registration on sybase.com):http://downloads.sybase.com/swd/base.do

The click SQL Anywhere and find the "Platform: Windows x86"
(as development is on Windows UltraLiteJ goes out in the
Windows release) and get the latest (build 11.0.0.1526 I
believe).

Tom

Hi,

I understand that this place is more for ultralite on
other platform but I am really stuck and I am hoping
someone can help me here. *I am trying to setup a really
simple database on a mobile device (Blackberry) using
UltraliteJ with a Autoincrement primary key. *I set it up
as follows:

TableSchema table_schema = _conn.createTable("SomeTable");

column_schema = table_schema.createColumn("tid",
Domain.BIG ); column_schema.setDefault(
ColumnSchema.COLUMN_DEFAULT_AUTOINC);

index_schema =
table_schema.createPrimaryIndex("prime_keys");
index_schema.addColumn("tid", IndexSchema.ASCENDING);

But when I try to insert an item to a non-empty table
without the primary key column, I get the "tid column"
cannot be NULL error. *And the funny thing is that things
worked (insert was successful) when I try to insert when
the table was first created. *Any ideas?

Kenny

#19

Hey Tom,

You're right. It worked. Thanks!

Kenny

On Dec 14, 3:54*pm, Tom Slee wrote:

Quote:

Hi,

Unfortunately there was a bug in the autoincrement in the
initial release of UltraLiteJ. If you get a recent Express
Bug Fix (EBF) release you will find this has been fixed.

You can download EBFs from here (you need a free
registration on sybase.com):http://downloads.sybase.com/swd/base.do

The click SQL Anywhere and find the "Platform: Windows x86"
(as development is on Windows UltraLiteJ goes out in the
Windows release) and get the latest (build 11.0.0.1526 I
believe).

Tom

Hi,

I understand that this place is more for ultralite on
other platform but I am really stuck and I am hoping
someone can help me here. *I am trying to setup a really
simple database on a mobile device (Blackberry) using
UltraliteJ with a Autoincrement primary key. *I set it up
as follows:

TableSchema table_schema = _conn.createTable("SomeTable");

column_schema = table_schema.createColumn("tid",
Domain.BIG ); column_schema.setDefault(
ColumnSchema.COLUMN_DEFAULT_AUTOINC);

index_schema =
table_schema.createPrimaryIndex("prime_keys");
index_schema.addColumn("tid", IndexSchema.ASCENDING);

But when I try to insert an item to a non-empty table
without the primary key column, I get the "tid column"
cannot be NULL error. *And the funny thing is that things
worked (insert was successful) when I try to insert when
the table was first created. *Any ideas?

Kenny

#20

Hey Tom,

You're right. It worked. Thanks!

Kenny

On Dec 14, 3:54*pm, Tom Slee wrote:

Quote:

Hi,

Unfortunately there was a bug in the autoincrement in the
initial release of UltraLiteJ. If you get a recent Express
Bug Fix (EBF) release you will find this has been fixed.

You can download EBFs from here (you need a free
registration on sybase.com):http://downloads.sybase.com/swd/base.do

The click SQL Anywhere and find the "Platform: Windows x86"
(as development is on Windows UltraLiteJ goes out in the
Windows release) and get the latest (build 11.0.0.1526 I
believe).

Tom

Hi,

I understand that this place is more for ultralite on
other platform but I am really stuck and I am hoping
someone can help me here. *I am trying to setup a really
simple database on a mobile device (Blackberry) using
UltraliteJ with a Autoincrement primary key. *I set it up
as follows:

TableSchema table_schema = _conn.createTable("SomeTable");

column_schema = table_schema.createColumn("tid",
Domain.BIG ); column_schema.setDefault(
ColumnSchema.COLUMN_DEFAULT_AUTOINC);

index_schema =
table_schema.createPrimaryIndex("prime_keys");
index_schema.addColumn("tid", IndexSchema.ASCENDING);

But when I try to insert an item to a non-empty table
without the primary key column, I get the "tid column"
cannot be NULL error. *And the funny thing is that things
worked (insert was successful) when I try to insert when
the table was first created. *Any ideas?

Kenny