Autoincrement Default on UltraliteJ

#1

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

#2

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

#3

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

#4

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

#5

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

#6

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

#7

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

#8

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

#9

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

#10

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