Parsing constraint exceptions

Hi,

I have configured a lot of named constraints in the database. If the 
user tries to insert wrong data, an exception occurs. Currently I parse 
the exception strings with regular expressions, but is there a simpler 
way to differ the exceptions?

Regards
Andre

---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-unsubscribe <at> mckoi.com

Insert strings

Hi,

I have defined a column varchar(60), but I can insert longer strings 
without an exception. Is it correct? As work-around I check the length 
of the strings on client side and produce my own exception. But it 
prevents an simple update of the database, I have to exchange some code 
in the client application if I have to change the column size.

Regards
Andre

---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-unsubscribe <at> mckoi.com

General access problem

Hi,

I think in the mailing list could be a lot of JDBC experienced users, so 
  it could be, that I get an answer for a general problem:

I select some data from a table ADDRESS. The selection is sorted by 
different columns. The table has a primary key column id.

------------------------------------------
id  name    street      city      postcode
------------------------------------------
1   bob     mainstreet  leipzig   04107
2   alice   2nd street  berlin    01200
3   nate                munich
------------------------------------------

The application displays the records in a JTable and the user can change 
the order of the records, like name, street and so on. The order is 
processed by McKoi, I create a dynamic SQL statement and exchange the 
ORDER BY part.

If the user selects a row, the JTable returns an index, which I can use 
to get data from the Resultset by absolute(index).

Now I try to insert a new record. The id is taken from a sequence.

---------------------------------------
4   dave    jump st.   hamburg    30567
---------------------------------------

2 questions: created tables not visible from java; Pointer out of bounds exception

Hi;

I am using the JDBC Query Tool to create tables that are then used by
my Java program. When I CREATE/ALTER tables using the Tool, these are
not immediately visible to the app. For example, I added a field to a
table on Friday, it wasn't visible then, but is visible to the app
today (Monday).

Also: further progress is halted because I am now getting the
following error while trying to start the Query Tool, and trying to
access the db from the Java app:

Using JDBC Driver: com.mckoi.JDBCDriver
java.io.IOException: Pointer out of range: 1312 > 32 > 7128
        at com.mckoi.store.AbstractStore.checkPointer(AbstractStore.java:778)
        at com.mckoi.store.AbstractStore.addToBinChain(AbstractStore.java:981)
        at com.mckoi.store.AbstractStore.cropArea(AbstractStore.java:1126)
        at com.mckoi.store.AbstractStore.alloc(AbstractStore.java:1286)
        at com.mckoi.store.AbstractStore.createArea(AbstractStore.java:1382)
        at com.mckoi.database.IndexSetStore.createBlankIndexBlock(IndexSetStore.
java:189)
        at com.mckoi.database.IndexSetStore.addIndexLists(IndexSetStore.java:434
)
        at com.mckoi.database.V2MasterTableDataSource.readStoreHeaders(V2MasterT
ableDataSource.java:306)
        at com.mckoi.database.V2MasterTableDataSource.open(V2MasterTableDataSour
ce.java:384)
        at com.mckoi.database.TableDataConglomerate.readVisibleTables(TableDataC
onglomerate.java:383)
        at com.mckoi.database.TableDataConglomerate.open(TableDataConglomerate.j

Re: 2 questions: created tables not visible from java; Pointer out of bounds exception

Man,

Unfortunately the project McKoi is dead and I don't think you will
find any support here or bugfix...

Good luck!

On Jan 7, 2008 8:24 PM, B. Sporb <umsporb <at> gmail.com> wrote:
> Hi;
>
> I am using the JDBC Query Tool to create tables that are then used by
> my Java program. When I CREATE/ALTER tables using the Tool, these are
> not immediately visible to the app. For example, I added a field to a
> table on Friday, it wasn't visible then, but is visible to the app
> today (Monday).
>
> Also: further progress is halted because I am now getting the
> following error while trying to start the Query Tool, and trying to
> access the db from the Java app:
>
>
>
> Using JDBC Driver: com.mckoi.JDBCDriver
> java.io.IOException: Pointer out of range: 1312 > 32 > 7128
>         at com.mckoi.store.AbstractStore.checkPointer(AbstractStore.java:778)
>         at com.mckoi.store.AbstractStore.addToBinChain(AbstractStore.java:981)
>         at com.mckoi.store.AbstractStore.cropArea(AbstractStore.java:1126)
>         at com.mckoi.store.AbstractStore.alloc(AbstractStore.java:1286)
>         at com.mckoi.store.AbstractStore.createArea(AbstractStore.java:1382)
>         at com.mckoi.database.IndexSetStore.createBlankIndexBlock(IndexSetStore.

Re: 2 questions: created tables not visible from java; Pointer out of bounds exception

I'm afraid Antonello is right about McKoi. I switched some time ago to
HSQLDB. It is also free open source java and seems to have all the
good features of McKoi. It supports all the same data types and runs
as a server or imbedded.

Good Luck!

----- Original Message ----- 
From: "Antonello Provenzano" <antonello <at> deveel.com>
To: <mckoidb <at> mckoi.com>
Sent: Wednesday, January 09, 2008 4:08 AM
Subject: Re: 2 questions: created tables not visible from java; Pointer out 
of bounds exception

> Man,
>
> Unfortunately the project McKoi is dead and I don't think you will
> find any support here or bugfix...
>
> Good luck!
>
> On Jan 7, 2008 8:24 PM, B. Sporb <umsporb <at> gmail.com> wrote:
>> Hi;
>>
>> I am using the JDBC Query Tool to create tables that are then used by
>> my Java program. When I CREATE/ALTER tables using the Tool, these are
>> not immediately visible to the app. For example, I added a field to a
>> table on Friday, it wasn't visible then, but is visible to the app
>> today (Monday).
>>

Re: 2 questions: created tables not visible from java; Pointer out of bounds exception

Thanks for your thoughts! I had downloaded HSQLDB but was trying mckoi
first. I'll check it out!

-sporb

On Jan 9, 2008 9:04 AM, Bayless Kirtley <bkirt <at> cox.net> wrote:
> I'm afraid Antonello is right about McKoi. I switched some time ago to
> HSQLDB. It is also free open source java and seems to have all the
> good features of McKoi. It supports all the same data types and runs
> as a server or imbedded.
>
> Good Luck!
>
> ----- Original Message -----
> From: "Antonello Provenzano" <antonello <at> deveel.com>
> To: <mckoidb <at> mckoi.com>
> Sent: Wednesday, January 09, 2008 4:08 AM
> Subject: Re: 2 questions: created tables not visible from java; Pointer out
> of bounds exception
>
>
>
> > Man,
> >
> > Unfortunately the project McKoi is dead and I don't think you will
> > find any support here or bugfix...
> >
> > Good luck!
> >
> > On Jan 7, 2008 8:24 PM, B. Sporb <umsporb <at> gmail.com> wrote:

Re: 2 questions: created tables not visible from java; Pointer out of bounds exception

Also, there is of course the Java DB (Apache Derby), and H2
(www.h2database.com).  Both are open source Java databases that
support embedded as well as network server modes.

Rob

On Jan 9, 2008 10:04 AM, Bayless Kirtley <bkirt <at> cox.net> wrote:
> I'm afraid Antonello is right about McKoi. I switched some time ago to
> HSQLDB. It is also free open source java and seems to have all the
> good features of McKoi. It supports all the same data types and runs
> as a server or imbedded.
>
> Good Luck!
>
> ----- Original Message -----
> From: "Antonello Provenzano" <antonello <at> deveel.com>
> To: <mckoidb <at> mckoi.com>
> Sent: Wednesday, January 09, 2008 4:08 AM
> Subject: Re: 2 questions: created tables not visible from java; Pointer out
> of bounds exception
>
>
> > Man,
> >
> > Unfortunately the project McKoi is dead and I don't think you will
> > find any support here or bugfix...
> >
> > Good luck!
> >
> > On Jan 7, 2008 8:24 PM, B. Sporb <umsporb <at> gmail.com> wrote:

Re: 2 questions: created tables not visible from java; Pointer out of bounds exception

I haven't tried H2 but it has an excellent web page and its performance 
looks pretty darn
impressive. It is still a little new though. I looked at Derby, even started 
to convert when
I discovered that it does not support the Boolean data type. That was a 
killer for me.
Since selecting HSQLDB, I have read that Derby is significantly slower in 
most cases.
Also I just recently checked into it again and found a disturbing comment in 
the docs.
It claims to not support dynamic SQL but only prepared statements. My 
current apps
just don't need the extra and somewhat confusing code of prepared statements 
so to
change over would be a miserable experience.

Bayless

----- Original Message ----- 
From: "Robert Manning" <robert.m.manning <at> gmail.com>
To: <mckoidb <at> mckoi.com>
Sent: Wednesday, January 09, 2008 11:50 AM
Subject: Re: 2 questions: created tables not visible from java; Pointer out 
of bounds exception

> Also, there is of course the Java DB (Apache Derby), and H2
> (www.h2database.com).  Both are open source Java databases that
> support embedded as well as network server modes.
>
> Rob

RE: 2 questions: created tables not visible from java; Pointer out of bounds exception