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

Discussion:

B. Sporb

2008-01-07 19:24:38 UTC

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-***@mckoi.com

Antonello Provenzano

2008-01-09 10:08:05 UTC

Permalink

Man,

Unfortunately the project McKoi is dead and I don't think you will
find any support here or bugfix...

Good luck!

Post by B. Sporb
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
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

Post by B. Sporb
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/

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

Bayless Kirtley

2008-01-09 15:04:06 UTC

Permalink

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" <***@deveel.com>
To: <***@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

Post by Antonello Provenzano
Man,
Unfortunately the project McKoi is dead and I don't think you will
find any support here or bugfix...
Good luck!

Post by B. Sporb
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
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

Post by B. Sporb
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/

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
--
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-***@mckoi.com

B. Sporb

2008-01-09 15:33:07 UTC

Permalink

Thanks for your thoughts! I had downloaded HSQLDB but was trying mckoi
first. I'll check it out!

-sporb

Post by Bayless Kirtley
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 -----
Sent: Wednesday, January 09, 2008 4:08 AM
Subject: Re: 2 questions: created tables not visible from java; Pointer out
of bounds exception

Post by Antonello Provenzano
Man,
Unfortunately the project McKoi is dead and I don't think you will
find any support here or bugfix...
Good luck!

Post by B. Sporb
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
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

Post by B. Sporb
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/

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/

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

Robert Manning

2008-01-09 17:50:49 UTC

Permalink

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

Post by Antonello Provenzano
Man,
Unfortunately the project McKoi is dead and I don't think you will
find any support here or bugfix...
Good luck!

Post by B. Sporb
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
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

Post by B. Sporb
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/

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/

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

Bayless Kirtley

2008-01-09 19:35:02 UTC

Permalink

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" <***@gmail.com>
To: <***@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

Post by Robert Manning
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

Post by Antonello Provenzano
Man,
Unfortunately the project McKoi is dead and I don't think you will
find any support here or bugfix...
Good luck!

Post by B. Sporb
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
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

Post by B. Sporb
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/

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/

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

Alexander Finger

2008-01-09 19:38:33 UTC

Permalink

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

Robert Manning

2008-01-09 20:21:15 UTC

Permalink

Post by Bayless Kirtley
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-***@mckoi.com

Bayless Kirtley

2008-01-09 22:23:46 UTC

Permalink

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" <***@gmail.com>
To: <***@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

Post by Robert Manning

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/
--
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-***@mckoi.com

André Rothe

2008-01-09 22:30:41 UTC

Permalink

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

Post by B. Sporb
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/

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