Bugs item #516500, was opened at 2002-02-12 09:30 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=516500&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole >Status: Closed >Resolution: Rejected Priority: 5 Submitted By: Matthew Bishop (mattbishop) >Assigned to: Dain Sundstrom (dsundstrom) Summary: jboss uses the wrong CREATE TABLE stmt Initial Comment: Hypersonic has two storage states--in-memory and on disk. The standard CREATE TABLE command sets the database to the in-memory state, meaning the entire database has to be read into memory at startup, and it stays there for the life of the application. This is unnaceptable for all but the teeniest of databases. Please use the statement CREATE CACHED TABLE to set the storage state of a table to on-disk. Maybe add an entry in jboss-jdbc.xml/jaws.xml to hold this command mapping. This occurs on OSX, Linux (Red Hat 7.1) and Win2K, all JDK 1.3.1 ---------------------------------------------------------------------- >Comment By: Dain Sundstrom (dsundstrom) Date: 2002-02-12 10:10 Message: Logged In: YES user_id=251431 The Hypersonic settings are designed to make development easiest. If you want a custom table creation or setup for any database you will have to create your tables outside of JBossCMP. ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=516500&group_id=22866 _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development