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

[André Rothe <cyberdyne_systems@xxxxxx>]

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