Kevin.H.Lee | 28 Aug 19:01 2008

Kevin H Lee/CA/KAIPERM is out of the office.


I will be out of the office starting  08/22/2008 and will not return until
09/02/2008.

I will be out of the office until Tuesday, Sept 2

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

rent | 28 Aug 15:44 2008

Re: Capital One Bank important update

Due to spam, we have change our email address to floridavacationhomes (at) fvh.com...Thank you!!

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

Tobias Downer | 4 Mar 04:35 2008

Mckoi 2.0 work in progress download

Hi all,

I have just uploaded a work in progress release of Mckoi 2.  You can 
download it here;

http://www.mckoi.com/database/ver2/mckoi20wip01.zip

I will be continuing to add releases to this directory as development 
continues.

Please be aware this release is a work in progress and it's missing some 
important features.  First I'll quickly describe what is complete and 
I'm most interested in getting feedback on at the moment.

The Mckoi 2.0 data store;  I expect the new snapshot data store engine 
and API will be the main focus of the 2 release.  The data store is the 
part of a database engine that deals with modeling structures for 
storing and indexing data in a database and mapping this data to a 
storage medium (such as in a persistent local file system or a transient 
heap).  Version 2.0 provides developers with a fairly straight forward 
API for modeling and manipulating primitive data structures freely in a 
strict snapshot transactional environment.  The problems of caching, 
memory allocation/deallocation, transaction management and structural 
representation are dealt with by the data store engine.

One way to think of the data store engine in 2.0 is a file system that 
is designed for database software and so supports strict isolation 
enforcement, discrete and controllable commit states, and supports files 
of various sizes and quantities with efficient creation and deletion. 
Most importantly, the data store supports very efficient copying of data 
(Continue reading)

M. A. Sridhar | 29 Jan 17:05 2008
Picon

Mailing list content update (was Re: Any update on Mckoi's status?)

On a sort-of-related note, the Mckoi mailing list contents don't seem to get updated on the Mckoi website (at http://mckoi.com/database/mail/list.jsp?list=mckoidb). That seems to imply that the service is shut off. Seems odd.
 
M. A. Sridhar
m_a_sridhar at yahoo dot com


----- Original Message ----
From: Tena Sakai <tsakai <at> gallo.ucsf.edu>
To: mckoidb <at> mckoi.com; mckoidb <at> mckoi.com
Sent: Monday, January 28, 2008 2:07:15 PM
Subject: RE: Any update on Mckoi's status?

RE: Any update on Mckoi's status?

Hello Alex,

I am sure you have reasons to declare/pronounce mcKoi dead,
but that opinion of yours may not be shared universally.
Some of us are dreamers and wanting to be more stupid than
necessary.  I regret that period in my life is over.

Tena


-----Original Message-----
From: mckoidb <at> mckoi.com on behalf of Alexander Finger
Sent: Mon 1/28/2008 1:44 PM
To: mckoidb <at> mckoi.com
Subject: Re: Any update on Mckoi's status?

Personally I can't imagine why anyone would waste their time. If you're
going to try and help continue development on a database their are plenty of
better open source ones out there. McKoi is dead I am sure and nothing is
going to bring her back...

A

On Jan 28, 2008 4:42 PM, Tena Sakai <tsakai <at> gallo.ucsf.edu> wrote:

>  Hi folks,
>
> If I were 10 years younger,
> If my mortgage was a bit less and therefore I could afford to work less
> than full time,
> If I were a bit more fluent in database,
> If I were a bit smarter and more ambitious,
>
> THEN I would write to Tobi (is that his name?) and ask:
>
> a) would he be willing to play a role of assisting a small group of
> developers,
> b) what plans he had had for the future of mcKoi while he was leading the
> project actively,
>
> AND
>
> If his response were positive, I would assemble a small group (fewer than
> 6) of java programmers...
>
> Oops, I just woke up from a nice dream and back into a reality.  I think
> that's what they call this
> thing I live in.  But some of you may be freer, more ambirious, more
> devoting...
> McKoi doesn't have to die.
>
> Tena Sakai
> tsakai <at> gallo.ucsf.edu
>
>
>
> -----Original Message-----
> From: mckoidb <at> mckoi.com on behalf of Richard S. Hall
> Sent: Mon 1/28/2008 1:07 PM
> To: mckoidb <at> mckoi.com
> Subject: Re: Any update on Mckoi's status?
>
> The benefit of Mckoi being open source is that anyone that wants to can
> pick up and start where the original developers left off...
>
> -> richard
>
> Alexander Molochnikov wrote:
> > Two days ago I asked he same question on this mailing list.
> >
> > So far, no reply from the developers of the database.
> >
> > It does not look promising.
> >
> > Alex
> >
> > ----- Original Message -----
> > From: "M. A. Sridhar" <m_a_sridhar <at> yahoo.com>
> > Date: Monday, January 28, 2008 11:46 am
> > Subject: Any update on Mckoi's status?
> > To: Mckoi mailing list <mckoidb <at> mckoi.com>
> >
> > > Does anyone know what's happening with Mckoi? As  you know,
> > > the last email in the archives is dated last June, so I'm
> > > wondering if/when the next version might be available.
> > >
> > > Regards.
> > >
> > > M. A. Sridhar
> > > m_a_sridhar at yahoo dot com
> > >
> > >
> > >
>
>
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> To unsubscribe, send a message to mckoidb-unsubscribe <at> mckoi.com
>
>
>


M. A. Sridhar | 28 Jan 19:46 2008
Picon

Any update on Mckoi's status?

Does anyone know what's happening with Mckoi? As  you know, the last email in the archives is dated last June, so I'm wondering if/when the next version might be available.

Regards.
 
M. A. Sridhar
m_a_sridhar at yahoo dot com

Alex Molochnikov | 27 Jan 04:25 2008
Picon

Future of McKoi?

Is McKoi database still actively developed and supported? The last release was made 3.5 years ago...
B. Sporb | 7 Jan 20:24 2008
Picon

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

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

André Rothe | 4 Jan 16:37 2008
Picon
Picon

General access problem

Hi,

I think in the mailing list could be a lot of JDBC experienced users, so 
  it could be, that I get an answer for a general problem:

I select some data from a table ADDRESS. The selection is sorted by 
different columns. The table has a primary key column id.

------------------------------------------
id  name    street      city      postcode
------------------------------------------
1   bob     mainstreet  leipzig   04107
2   alice   2nd street  berlin    01200
3   nate                munich
------------------------------------------

The application displays the records in a JTable and the user can change 
the order of the records, like name, street and so on. The order is 
processed by McKoi, I create a dynamic SQL statement and exchange the 
ORDER BY part.

If the user selects a row, the JTable returns an index, which I can use 
to get data from the Resultset by absolute(index).

Now I try to insert a new record. The id is taken from a sequence.

---------------------------------------
4   dave    jump st.   hamburg    30567
---------------------------------------

I refresh the Resultset and the JTable to display the new record. But I 
need to select the record in the table. The table expects an index - I 
have the database id. And now?

McKoi doesn't have a ROWNUM feature like Oracle, which I could use to 
execute the following:

select *
   from (
     select rownum tmp, id, name, city, postcode
       from address
      order by name asc
   )
  where id = 4;

The column tmp would hold the index. The previous example has also a 
mistake. I select new data from the database, another client could 
already have update it and the index doesn't match with the old data in 
the JTable.

So the only way to find the index is to search through the complete 
Resultset. I cannot use a fast search algorithm, because the id is not 
sorted (order by name!). This is a long time job, if the table has a lot 
of records.

In the McKoi examples I saw a possibility to sync multiple clients: the 
triggers. If a client changes the table, the other client will be 
informed by the triggers. So all clients "see" the same data and I can 
calculate the row index with an additional query without a table lock.

How can I solve the ROWNUM problem? I think about the following algorithm:

* get a unique transaction id from a sequence (CYCLE)
* try to create a temporary sequence with a static name plus the
   transaction-id
* if you get an exception, get another transaction-id and try it again
* if the temporary sequence was created, try the following query:

   select *
     from (
        select nextval('tempseq' || trans-id) rownum,
               id, name, street, city, postcode
          from address
         order by name asc
          )
    where id = 4;

* drop the temporary sequence
* get the index from the column rownum

I did not implemented it yet, what are your ideas? Could it work? Any 
other solutions out there?

Regards
Andre

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

André Rothe | 4 Jan 15:51 2008
Picon
Picon

Insert strings

Hi,

I have defined a column varchar(60), but I can insert longer strings 
without an exception. Is it correct? As work-around I check the length 
of the strings on client side and produce my own exception. But it 
prevents an simple update of the database, I have to exchange some code 
in the client application if I have to change the column size.

Regards
Andre

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

André Rothe | 4 Jan 15:46 2008
Picon
Picon

Parsing constraint exceptions

Hi,

I have configured a lot of named constraints in the database. If the 
user tries to insert wrong data, an exception occurs. Currently I parse 
the exception strings with regular expressions, but is there a simpler 
way to differ the exceptions?

Regards
Andre

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

John Garrett Smith | 9 Oct 12:06 2007
Picon

Still Alive?

Hi guys,
I would like to receive some information about the state of the
project McKoi: I have seen in some old posts to the list  the project
is supposed to be still alive, but since the announcement from Toby of
an incoming release, everything seems death calm.
I tried contacting Toby directly couple of weeks ago, but since then I
had no response.

I've been working for a while in an organization which makes use of
McKoi for some  embedded systems: we're quite happy of the
performances and the project manageability itself.
Anyway, since we need to would like some assurances about the vitality
of the tools we're going to use, we are considering switching to some
other systems (such as SQLite or similar), although we wouldn't.

Hope I will get a positive response from the list.

Cheers.
John

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


Gmane