[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
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@gmail.com>
To: <mckoidb@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
>
> On Jan 9, 2008 10:04 AM, Bayless Kirtley <bkirt@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@deveel.com>
>> To: <mckoidb@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@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@mckoi.com
>> >>
>> >>
>> >
>> >
>> > ---------------------------------------------------------------
>> > Mckoi SQL Database mailing list http://www.mckoi.com/database/
>> > To unsubscribe, send a message to mckoidb-unsubscribe@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@mckoi.com
>>
>>
>
>
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list http://www.mckoi.com/database/
> To unsubscribe, send a message to mckoidb-unsubscribe@mckoi.com
>
>
>
> --
> 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
>
>