Can't insert into Derby dbase / BD server license expired??

[Yvan]

I am getting the following error message when trying to do a simple SQL
insert statement into my Derby database.

Query Error DB2 SQL error: SQLCODE: -1, SQLSTATE: 23502, SQLERRMC:
ID 23502
Native Error Code -1
SQL State 23502

I am able to query the tabe without any errors. It's only when I'm
trying to insert that it fails. Also, I am getting a Javascript alert
message when attempting to refresh the page which reads "Developer's
License for Bluedragon".

Could it be that my developer's license has expired, and that this is
one of the consequences? If this is the case, is there another version
of BDServer that I should download and install that does not have this
limitation? Or does this error code above indicate that something is
wrong with my query?

thanks,
- yvan

[Phil Cruz]

Not sure what the error code means. Look in the derby docs and it
should give more info.

Yes, your trial license seems to have expired so it drops to developer
mode which means access from other than localhost will get a nag
screen. There is no other version of BD to get as only BD/J2EE will
work for CFE. This has nothing to do with your query.

-Phil

[Yvan]

Well, I figured it out. It turns out that I had designed my table
without a proper, auto-incrementing primary key. Unfortunately, the
DBEdit plugin for Eclipse doesn't seem to allow for this type of
setting (or am I mistaken about this?), so the only way I was able to
create a table with an auto-incrementing ID column was by using a CF
query / script.

By the way, the correct Derby-specifc syntax for creating an
auto-incrementing primary key is as follows:

ID SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1,
INCREMENT BY 1)

As for the trial license, I am accesing my app via localhost
(127.0.0.1), and I am still getting the nag screens continually. It
seems to happen about every 20 page requests or so. I'm using the BD
Server RC2 Beta. Is this normal? Because I'll want to switch over to
the non-beta version if this is a known bug with RC2.

- yvan

[Phil Cruz]

>
> As for the trial license, I am accesing my app via localhost
> (127.0.0.1), and I am still getting the nag screens continually. It
> seems to happen about every 20 page requests or so. I'm using the BD
> Server RC2 Beta. Is this normal? Because I'll want to switch over to
> the non-beta version if this is a known bug with RC2.
>

Haven't heard about that being a bug. You should post this one to the
BD mailing list.

-Phil

[Yvan]

Phil -- is it common knowledge that the javascript nag screen is the
expected behavior with all versions of BDServer after the 30-day
evaluation period? Because that's what I was told when I inquired
about it in the BD mailing list. Apparently, according to Charlie
Arehart at New Atlanta, .. some licensing fees are now in order.

- yvan

[Phil Cruz]

I imagine it is.  I seem to have forgotten about the nag screen because I've been working with licensed versions.  However, though the developer mode gives a nag screen it's still free for development.

-Phil

[Brian O'Reilly]

Yvan:

 

I would be happy to review the options you have as a BlueDragon VAR/OEM.  Please call or write me.

 

Thanks,

 

Brian O'Reilly

BlueDragon Sales

BORe...@NewAtlanta.com

Office:  678-256-5392

Cell:  404-734-1900

www.NewAtlanta.com/BlueDragon