Return-Path: Delivered-To: apmail-jakarta-commons-dev-archive@apache.org Received: (qmail 43571 invoked from network); 15 Nov 2002 16:38:48 -0000 Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131) by daedalus.apache.org with SMTP; 15 Nov 2002 16:38:48 -0000 Received: (qmail 22519 invoked by uid 97); 15 Nov 2002 16:39:45 -0000 Delivered-To: qmlist-jakarta-archive-commons-dev@jakarta.apache.org Received: (qmail 22462 invoked by uid 97); 15 Nov 2002 16:39:44 -0000 Mailing-List: contact commons-dev-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Jakarta Commons Developers List" Reply-To: "Jakarta Commons Developers List" Delivered-To: mailing list commons-dev@jakarta.apache.org Received: (qmail 22440 invoked by uid 98); 15 Nov 2002 16:39:43 -0000 X-Antivirus: nagoya (v4218 created Aug 14 2002) Reply-To: From: "Steven Caswell" To: "'Jakarta Commons Developers List'" Subject: RE: [DBUtils] Introduction and some thoughts Date: Fri, 15 Nov 2002 11:38:26 -0500 Message-ID: <000d01c28cc5$6d939670$7b00a8c0@YellowJacket> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N > -----Original Message----- > From: Henri Yandell [mailto:bayard@generationjava.com] > Sent: Thursday, November 14, 2002 11:48 PM > To: Jakarta Commons Developers List > Subject: RE: [DBUtils] Introduction and some thoughts > > > > Nope. Looks good, Apache licence too so it's usable. Why am I > not surprised that Strachan is on it :) He gets everywhere. > My rule of thumb is becoming: "it's not an open source Java > project if Strachan's not on it. " [Damn, hurry up and join > DbUtils James]. > > I'll try to learn more about it so that DbUtils doesn't grow > in that direction, which a couple of Mike's suggestions > concering the ColumnData might be getting towards (?). > > Assuming you're the Travis who's heading up crossdb.com, what > do you think? Is DbUtils redundant? Can you see a clear > separation of concern? Are there any things you think would > go well there. > > The reason why I think there's not a cross-pupose: > I'm not an amazing Db coder or anything, I do bits etc. When > I look around at all the libraries to help me with DBs, they > all involve me having to get religious about them, OO-db's, > ObjectBridge, Castor/JDO, CrossDB[I think]. I like getting > religious about things, but it's expensive to do properly [in > time], so when I haven't got that time I like to just make > the boring old religion that little bit easier. > > One of the issues I believe DbUtils has to watch for is > introducing any religion. So, if someone _has_ to use a > framework to get the power, then we're starting to compete > with the other projects and not fitting the currently empty > niche. Idea is just to make JDBC(tm) easier. > > Currently I'm wrestling with a DbPoller. It's a simple piece > of code which polls the db to notify something when that > table changes. Issues being: > > 1) I introduce a PKey class to hold a column-data info. > Basically akin to Mike's suggestion. Is this a framework yet? > > 2) DB-specific. Oracle has some irritating bugs with jdbc and > I extend DbPoller to get OracleDbPoller. This provides some > issues for building, but I'm sure they can easily be fixed. > More importantly, should DbUtils fill up with lots of > DB-specific extensions [or in a side repository anyway]. > > Another idea is GUID/Sequencers. Would be nice to have a > Sequencer interface and then I make an OracleSequencer which > uses a select on nextval etc, or a MySql sequencer with > last_insert_id. Issues being, how do I enforce the last > transaction there? There'd also be java-level random-number > Sequencers, which would use the sequence-id code from > Patterns sandbox, or other ideas. > > Is this getting towards a framework? > > Thoughts? I think all of these are reasonable things to put into dbutils without it becoming a framework. I guess somewhere there is a "framework" test that defines the boundary, but I don't think we're close to that with these items. And the things I plan to throw in are definitely not famework. I'm certainly +1 on dbutils not becoming a framework, but being a place for simple stuff that stands alone or nearly alone. As has already been suggested, commons-sql provides excellent coverage for Mike's suggestions. Steven Caswell steven@caswell.name a.k.a Mungo Knotwise of Michel Delving "One ring to rule them all, one ring to find them..." > > Hen > > On Thu, 14 Nov 2002 travis@thinkvirtual.com wrote: > > > Anybody looked at www.crossdb.com ? > > > > Travis > > > > ---- Original Message ---- > > From: Mike Bryant > > Sent: 2002-11-14 > > To: commons-dev@jakarta.apache.org > > Subject: [DBUtils] Introduction and some thoughts > > > > Hello all, > > > > My name is Mike Bryant. I just wanted to send an email to > introduce > > myself and say that I am excited about the DBUtils package. I've > > spent a good bit of time at my current job writing database utility > > code, a package like this could have really saved some time. > > > > The code so far looks great I think. I am especially > impressed with > > the EnhancedResultSet class and the DbUtils.resultSetToArray method. > > > > Some thoughts I have on this package: > > - Data class (ColumnData) to hold a DB field's data. This might > > contain data like column index, data type, column name, value. > > - Method (similar to DbUtils.resultSetToArray method) that > would build > > a List (or maybe Map) of ColumnData objects. This might be > useful if > > users need more information than the resultSetToArray > method provides. > > - Method to take a SQL stmt as a param, execute it, build a List of > > ColumnData objects (or a List of Strings), representing a vertical > > list of column data. An example of this would be to use a > stmt like > > 'select user_name from users' to get a List of all users. > > > > Anyway, those are some general thoughts. I look forward to > > (hopefully) spending alot of time with this. > > > > Thanks > > > > Mike Bryant (mike@MikeBryant.com) > > > > > > > > > > -- > > To unsubscribe, e-mail: > unsubscribe@jakarta.apache.org> > > For > additional commands, > e-mail: > > > > > > > > > > -- > > To unsubscribe, e-mail: > unsubscribe@jakarta.apache.org> > > For > additional commands, > e-mail: > > > > > > > > > -- > To unsubscribe, e-mail: > unsubscribe@jakarta.apache.org> > For > additional commands, > e-mail: > > -- To unsubscribe, e-mail: For additional commands, e-mail: