2 questions: created tables not visible from java; Pointer out of bounds exception
|
View:
New views
10 Messages
—
Rating Filter:
Alert me
|
 |
2 questions: created tables not visible from java; Pointer out of bounds exception
by B. Sporb
::
Rate this Message:
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@... |
|
|
Re: 2 questions: created tables not visible from java; Pointer out of bounds exception
by Antonello Provenzano-3
::
Rate this Message:
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@...> 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 SQL Database mailing list http://www.mckoi.com/database/ To unsubscribe, send a message to mckoidb-unsubscribe@... |
|
|
Re: 2 questions: created tables not visible from java; Pointer out of bounds exception
by Bayless Kirtley
::
Rate this Message:
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@...> To: <mckoidb@...> 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@...> 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 SQL Database mailing list http://www.mckoi.com/database/ > To unsubscribe, send a message to mckoidb-unsubscribe@... > > > > -- > 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@... |
|
|
Re: 2 questions: created tables not visible from java; Pointer out of bounds exception
by B. Sporb
::
Rate this Message:
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@...> 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@...> > To: <mckoidb@...> > 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@...> 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 SQL Database mailing list http://www.mckoi.com/database/ > > To unsubscribe, send a message to mckoidb-unsubscribe@... > > > > > > > > -- > > 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 SQL Database mailing list http://www.mckoi.com/database/ To unsubscribe, send a message to mckoidb-unsubscribe@... |
|
|
Re: 2 questions: created tables not visible from java; Pointer out of bounds exception
by manningr
::
Rate this Message:
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@...> 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@...> > To: <mckoidb@...> > 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@...> 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 SQL Database mailing list http://www.mckoi.com/database/ > > To unsubscribe, send a message to mckoidb-unsubscribe@... > > > > > > > > -- > > 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 SQL Database mailing list http://www.mckoi.com/database/ To unsubscribe, send a message to mckoidb-unsubscribe@... |
|
|
Re: 2 questions: created tables not visible from java; Pointer out of bounds exception
by Bayless Kirtley
::
Rate this Message:
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@...> To: <mckoidb@...> 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@...> 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@...> >> To: <mckoidb@...> >> 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@...> 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 SQL Database mailing list http://www.mckoi.com/database/ >> > To unsubscribe, send a message to mckoidb-unsubscribe@... >> > >> > >> > >> > -- >> > 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 SQL Database mailing list http://www.mckoi.com/database/ > To unsubscribe, send a message to mckoidb-unsubscribe@... > > > > -- > 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 mckoidb-unsubscribe@... |
|
|
RE: 2 questions: created tables not visible from java; Pointer out of bounds exception
by Alexander Finger-2
::
Rate this Message:
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
|
|
|
Re: 2 questions: created tables not visible from java; Pointer out of bounds exception
by manningr
::
Rate this Message:
On Jan 9, 2008 2:35 PM, Bayless Kirtley <bkirt@...> 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@... |
|
|
Re: 2 questions: created tables not visible from java; Pointer out of bounds exception
by Bayless Kirtley
::
Rate this Message:
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@...> To: <mckoidb@...> 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@...> 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@... > > > > -- > 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 mckoidb-unsubscribe@... |
|
|
Re: 2 questions: created tables not visible from java; Pointer out of bounds exception
by "André" Rothe
::
Rate this Message:
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) > 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 SQL Database mailing list http://www.mckoi.com/database/ To unsubscribe, send a message to mckoidb-unsubscribe@... |
| Free Forum Powered by Nabble | Forum Help |