Mckoi SQL Database Mailing list

B. Sporb | 7 Jan 2008 20:24

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

(Continue reading)

headers

André Rothe | 9 Jan 2008 23:30

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

Hello,

I think your problem is a part of the isolation level of McKoi. Every 
statement (also DDL like CREATE TABLE) creates a new transaction for the 
calling connection. So you cannot see a table on other connection till 
you call COMMIT.

It could be, that you didn't call commit till Monday...
Regards
Andre

B. Sporb schrieb:
> 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)

(Continue reading)

headers

Antonello Provenzano | 9 Jan 2008 11:08

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.

(Continue reading)

headers

Bayless Kirtley | 9 Jan 2008 16:04

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).
>>

(Continue reading)

headers

Robert Manning | 9 Jan 2008 18:50

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:

(Continue reading)

headers

Bayless Kirtley | 9 Jan 2008 20:35

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

(Continue reading)

headers

Robert Manning | 9 Jan 2008 21:21

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

On Jan 9, 2008 2:35 PM, Bayless Kirtley <bkirt <at> cox.net> wrote:
> 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

Perhaps you mean dynamic SQL that is constructed in stored procedures?
 Derby seems to support java.sql.Statement just fine for me.

Rob

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

headers

Bayless Kirtley | 9 Jan 2008 23:23

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

Thanks for the clarification Rob. That really had me concerned. I guess I
must have misread or overlooked something. Honestly, I didn't really
study it that close as I won't even consider changing without Boolean
support. I did read somewhere that it is coming in the next major revision.
I probably still won't change since HSQL seems to be working fine for
me.

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

> On Jan 9, 2008 2:35 PM, Bayless Kirtley <bkirt <at> cox.net> wrote:
>> 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
>
> Perhaps you mean dynamic SQL that is constructed in stored procedures?

(Continue reading)

headers

Alexander Finger | 9 Jan 2008 20:38

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

I converted my mckoi DB to Derby on a piece of software I developed and most of my problems instantly disappeared. Oh, and Derby is very fast actually

Alex

headers

B. Sporb | 9 Jan 2008 16:33

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:
> >> 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
> >> ava:1096)
> >>         at com.mckoi.database.Database.init(Database.java:1803)
> >>         at
> >> com.mckoi.database.control.DBController.startDatabase(DBController.ja
> >> va:131)
> >>         at
> >> com.mckoi.database.jdbcserver.DefaultLocalBootable.boot(DefaultLocalB
> >> ootable.java:135)
> >>         at
> >> com.mckoi.database.jdbc.MDriver.connectToLocal(MDriver.java:448)
> >>         at com.mckoi.database.jdbc.MDriver.connect(MDriver.java:484)
> >>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
> >>         at java.sql.DriverManager.getConnection(DriverManager.java:185)
> >>         at com.mckoi.tools.JDBCQueryTool.main(JDBCQueryTool.java:357)
> >> Exception in thread "main" java.lang.Error: IO Error: Pointer out of
> >> range: 1312
> >>  > 32 > 7128
> >>         at com.mckoi.database.Database.init(Database.java:1845)
> >>         at
> >> com.mckoi.database.control.DBController.startDatabase(DBController.ja
> >> va:131)
> >>         at
> >> com.mckoi.database.jdbcserver.DefaultLocalBootable.boot(DefaultLocalB
> >> ootable.java:135)
> >>         at
> >> com.mckoi.database.jdbc.MDriver.connectToLocal(MDriver.java:448)
> >>         at com.mckoi.database.jdbc.MDriver.connect(MDriver.java:484)
> >>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
> >>         at java.sql.DriverManager.getConnection(DriverManager.java:185)
> >>         at com.mckoi.tools.JDBCQueryTool.main(JDBCQueryTool.java:357)
> >>
> >> thanks
> >> -sporb
> >>
> >>
> >> ---------------------------------------------------------------
> >> Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> >> To unsubscribe, send a message to mckoidb-unsubscribe <at> mckoi.com
> >>
> >>
> >
> >
> > ---------------------------------------------------------------
> > Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> > To unsubscribe, send a message to mckoidb-unsubscribe <at> mckoi.com
> >
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.5.516 / Virus Database: 269.17.13/1214 - Release Date: 1/8/2008
> > 1:38 PM
>
> >
> >
>
>
>
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> To unsubscribe, send a message to mckoidb-unsubscribe <at> mckoi.com
>
>

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