mkamesh wrote:
I have a Derby database and am desperately trying to append/import hundreds
of products into an existing table in ooBase.
Hello Kamesh,
Let me be sure that I understand also.
You have an existing Derby db with hundreds of records that you want to
import into a Base embedded database - yes?
You currently have 2 Base odb files - yes?
One Base file connects to Derby via JDBC and the other is the embedded
database.
You open both then drag a table object from the Derby connected Base
file window to the other Base window to launch the import wizard - yes?
However I am facing error
messages like the import trying to insert Varchar in a Blob column, and if I
ask to not import that column it says it fails to create the primary key
which is a UUid . The option to generate UUid appears grayed out in the
import screen. OObase tries importing a single line and then quits
The varchar column is in the Derby database and the blob field is in the
Base embedded database - is that right?
The UUid column has to be in the Derby database as Base's embedded
database (HSQLdb) does not have that as a native data type.
So are you importing the actual UUid column data to a column in the
embedded database of type Big Int and is the PK field for the table - yes?
The import column is defined as AutoIncrement?
If all of that is true then most likely the problem with the UUid (PK)
sounds like a simple mistake your are making in the import wizard...I
say simple cause it sounds like something I have done a bunch of time.
The varchar, blob thing well...
Well, do you mind if I just ask your those questions first.
Thanks
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
