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" <[email protected]>
To: <[email protected]>
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
>
> On Jan 9, 2008 10:04 AM, Bayless Kirtley <[email protected]> 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" <[email protected]>
>> To: <[email protected]>
>> 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 <[email protected]> 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 [email protected]
>> >>
>> >>
>> >
>> >
>> > ---------------------------------------------------------------
>> > Mckoi SQL Database mailing list  http://www.mckoi.com/database/
>> > To unsubscribe, send a message to [email protected]
>> >
>> >
>> >
>> > --
>> > 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 [email protected]
>>
>>
>
>
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> To unsubscribe, send a message to [email protected]
>
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.19.0/1216 - Release Date: 1/9/2008 
> 10:16 AM
>
> 



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]