osage-users Mailing List for Osage - Persistence Plus XML (Page 8)
Status: Beta
Brought to you by:
gstewart4
You can subscribe to this list here.
2000 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(35) |
Sep
(39) |
Oct
(4) |
Nov
(6) |
Dec
(30) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2001 |
Jan
(40) |
Feb
(28) |
Mar
(9) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
2004 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
|
From: george s. <geo...@ya...> - 2000-08-18 19:17:29
|
Hello, This is too late for the next release, but it would be very helpful to have a volunteer network for minimal testing of each osage pre-release on the various databases prior to uploading to file release. It's not practical for me to test each database and driver, and it would be nice to have a volunteer for each database so effort is not duplicated. Here's my suggestion of the process. Volunteers are notified 1 week before release. I need weekend for preparing one. "Pre" pre-prelease is made available via anonymous ftp. Volunteers get Test.java running and report problems or success on Monday. Volunteers are needed for: Oracle MySQL SQL Server PostgreSQL InstantDB Sybase Interbase Hypersonic If you have both commercial and non-commercial, please volunteer for more costly, less readily availabe commercial one. I kick this off by volunteering for PostgreSQL. ;-) It won't hurt to have more than 1 volunteer per database. My hope is to eventually have small test harness and test cases for verifying correct operation of the system. Tom Copeland <to...@ro...> has volunteered to start this. Regards, george __________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-18 06:41:25
|
Hello, I added an array of int for sqltypes to Statement. This seems like the most portable way to support pstmt.setNull(xx, sqlType). Some open-source drivers were fine with pstmt.setObject(xxx, null), but oracle is not. I also added caching of the sqltypes to the class map. Regards, george __________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-18 01:39:07
|
Hello, Chritoph Oechslein mentioned that using class instead of string for hashing class maps would be more efficient. Originally, I debated with self and decided there was value in keeping string. With string, you have possibility of "classmap" without a class. Now, this is losing ground with me. Is there any worth in keeping the string hashing? Regards, george __________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-17 00:05:18
|
To all, Dave Ballard posted a little note about Osage not correctly handling null values for the Oracle driver. In fact, osage isn't doing anything for null values. One easy fix to this is to use the meta data from the prepared statement. Check for null, and use setNull() with type from meta data. Problem with this is that most, if not all, non-commercial dbs don't support meta data from prepared statements. I haven't tried MySQL or Hypersonic yet. InstantDB and PostgreSQL don't support precompiling statements. Does anyone have more experience or input on this? Regards, george __________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-16 03:25:36
|
To all, The changes for multiple persistence engines are in CVS. The doc is also updated. The main difference in usage is that, to create a Database instance, you have to use a reference to a persistence engine (class PersistenceManager). Please see Test.java in examples for usage. Regards, george __________________________________________________ Do You Yahoo!? Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-15 15:26:39
|
To all, I like Dave's comments on Open Discussion. I tried to send to list yesterday, but I can't find it. Dava Ballard wrote: > From the looks of the config files, In 'conf.xml', I > specify for the dbmap a single file, 'database.xml', > for connectivity. In 'database.xml' I can specify > connectivity for multiple databases. So far so good. > Now, 'conf.xml' also specifies the classmap file > name. > In the classmap file, for each class, I specify a > 'database' attribute. I assume that 'database' here > refers back to the database names in 'database.xml', > and that this lends itself to to having class A > persist in one DB, and class B persist in another. > Please correct me if I'm wrong. > > In my case, > Each organization has their own supporting database > instance. So, instance1 will store data for Class A > and B for org1, instance2 will store data for Class > A > and B for org2, etc. The 'classmap' for each > instance > will be identical. > > Seems to me the only way to do this would be to have > conf_org1.xml and conf_org2.xml files pointing to > 'database_org1.xml' and 'database_org2.xml' files, > but > pointing to the same classmap file. > > The problem here would be that the > PersistenceBroker, > via setConfiguration(), is static, and only allows > one > 'conf' file per Servlet Engine instance. Dave is right about the above. It would be better to support multiple persistence engines. Regards, george __________________________________________________ Do You Yahoo!? Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-15 05:16:31
|
Hello to all, I would like to get some feed back on some proposed enhancements which I posted on Open Discussion. The top three for me are caching, lazy loading (suggested by Ralph Schaer), and user-defined types. By user-defined types, I mean support the use of types which can be persisted in database by conversion to DBMS native types. For example, you could have a Currency class which is persisted as a string. Implementing caching is the most difficult of the 3, but the payoff is big. Having cache for db objects would give the system performance which cannot be matched by SQL or lower-level systems. One issue for using cache is that configuration is required to make it useful. You might want to specify cache none, for the database instance or for the persistence engine. Is anyone familiar with configuration variables in commercial systems? Support for multiple persistence engines should be in the system by end of the week. Are there any enhancement requests that should have higher priority than these? Implementation of all the above may take 4-8 weeks. btw, up to now I haven't bothered labeling a release. System is still incomplete for building a production system. If anyone needs a labeled release sooner than completion of the above, please inform me. Regards, george __________________________________________________ Do You Yahoo!? Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-14 23:30:39
|
On my last mail, I have Tom Copeland's first name, and Dave Ballard's last. My apologies for incorrectly putting them together. Regards, george __________________________________________________ Do You Yahoo!? Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-13 15:07:04
|
To, Sorry for boasting but I have to share excitment about osage reaching 117 on SF most active. Thanks to everyone who's used osage. I would like to change license to lesser (library) GNU. This way, osage could get reference link at www.gnu.org. I love GNU software, and I'm big fan of Richard Stallman's philosophy. It would be dream for me to have FSF take ownership of this project. I don't care about owning it, and having foundation ownership would give contributors better assurance that their contributions would not be missused. First, I want to change license. The lesser license is not anymore restrictive than BSD. Does anyone have huge objection to this? Regards, george __________________________________________________ Do You Yahoo!? Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-13 06:00:10
|
To list, Sorry for this. In pre5, there was an index problem in saving objects which caused errors when saving related objects. Error message is "No such attribute [attribute] for [class]". Strangely, this didn't occur when I ran Test.java on my JDK1.2 machine. Dave Watanabe reported this error running on JDK1.3. For Dave, the problem only occured on updating complex objects. This is the case where the index in the save() method of DatabaseCore is incorrectly calculated. A one line change fixes it. While looking at this, I changed all routines which iterate over attributes or relation maps to use the list instead of the hashtable. Regards, george __________________________________________________ Do You Yahoo!? Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-12 21:17:44
|
To all, I've just uploaded 1.0pre5. Please inform me of any problems. I wanted more feedback on recent changes and to wait for Fedor's testing on Interbase. But, with the qjml and JDK1.2 changes, I didn't want to postpone until next weekend. It is much easier for people to use the distro than collect sources from CVS and JARs from all corners. Regards, george __________________________________________________ Do You Yahoo!? Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-12 21:13:11
|
To all, Many thanks to everyone for making this happen. I have to save that page. ;-) Regards, george __________________________________________________ Do You Yahoo!? Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-12 03:49:28
|
To all, Here's comments from Oleg Nitz on Osage "highlow" generator. Oleg uses select ("for update") followed by update. Osage uses update followed by select. George >>>>>>>>>>>>>>> > If it's in scope of user's transaction, won't updated > value only be visible to user's select. Oleg >>>>>>>>>>>>>>>>>>>>>>> Yes, you are right. If the concurrent transaction has isolation level 1 (TRANSACTION_READ_COMMITTED), then it won't see the updated value. It performs SELECT, gets the old value, increases it, updates, tries to commit and recieves deadlock notification (if the first transaction has been committed first). Am I right now? If yes, then I prefer to hold lock until the end of the transaction, than to get deadlocks. __________________________________________________ Do You Yahoo!? Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-12 02:12:57
|
Hi all, Some small things in CVS: null pointer check in ClassMap.getFieldHandler (replaces "FIXME"), InterbaseInterface (Fedor Karpelevitch), removed some unused locals, removed wasteful strings in KeyKeeper. Last 2 from Tom Copeland. Regards, george __________________________________________________ Do You Yahoo!? Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-10 04:02:05
|
Ralph, I posted small change to highlow. Now, it has separate connection. Oleg Nitz, Castor key-generator contributor, points out that using larger trans. for key gen might deadlock. Don't you think separate conn. will help concurrency? Regards, george __________________________________________________ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-10 02:36:12
|
Ralph, I put changes in CVS for new relation model. I also changed RelationMap to support multi-state for retrieve. QJML now contrains this to 'auto' and 'none'. I added new class RetrieveEditor for text <=> int for retrieve mode. If you freshen your sources, please see maps.qjml and modify your XML class maps accordingly. Regards, george __________________________________________________ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-09 02:41:54
|
Ralph, Another excuse to clog mailing list. Should I check in changes for 2nd model? Would you have time or interest for excercising it before Monday? I added small bit of code for retrieving clobs/blobs. Nothing for storing; it's messy and db-specific. I would like to publish another release, maybe this weekend. These QJML changes should be done quickly because people are building XML based on it. I added support for lazy/auto/none to RelationMap. QJML constrains this to 'auto' and 'none' since no code for 'lazy'. A little kludgy, but I can live with it. These changes aren't in CVS because I want to do QJML changes in 1 go. Best regards, george __________________________________________________ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-08 17:23:42
|
Ralph, Thanks much for joining list. If I could get others to join, it would make my life little easier. ;-). Not really, just easier to communicate changes, and get cooperation on using / developing "osage". Probably won't ever be enough traffic for 2 lists. I don't think tons remains for development. I have short list in userguide. I really like benefit of supporting user-defined types. I'll go ahead with mapping changes for 'lazy' but hold off on class builder changes. You must be too busy to give feedback on 2nd model for relations. I think Assaf Arkin (guru of Castor) calls these "dependent" (model 1) and "related" (model 2) objects. No rush on this. I would like to have labeled release in 4-6 weeks, so production systems can be built using Osage. I did want to ask you about your "softreference". Is this for recycling objects? I wouldn't normally clutter list with prattle such as this, but I'm compelled to send you first one (however unworthy) with list. ;-) Regards, george __________________________________________________ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ |
From: george s. <geo...@ya...> - 2000-08-07 13:07:39
|
Hi George, I've put changes in CVS for this. You'll need to get the latest version of maps.qjml, changes in the mapping package and a new package for convertors. For each field where the sql datatype is 'text', you'll need to add a 'convertTo' attribute. An example is below. <field name="someText" type="string" convertTo="BytesToString"> <sql name="some_text" type="longvarchar" table="test"/> For going the other way, field -> db, using String is no problem for the MM driver. The problem here is that the MM driver doesn't know that the 'text' data is not binary; so it returns byte[]. I've posted a query to Mark Matthews on this, though this is more an issue for the general list. He has support for returning string for longvarchar if it's known that the type is not binary. btw, I think Mark's work is great. This is very nice open-source software. Later, I'll expand on convertors and add a 'convertFrom' attribute, for user-specified conversions. For example, you might have user-type "Currency" and want to persist this as a string in the database. I think this qualifies as the first, genuine support issue in osage. Thanks for your great assistance with this. Oh, maybe second. Lucas Koster reported bug in MaxKeyGenerator for Oracle. btw, I'm changing the syntax slightly for the keys element in relation. Along with this will be more user-friendliness for updating related columns. If you want to beat this change, please grab changes from CVS quickly. Regards, george __________________________________________________ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ |