A string parser for QBE fields (Java clone)?
Posted in 1999
Topics: Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Clustering, Grid & MACH11, Java & JDBC Development
Hi. Not strictly speaking an Informix question, but... Those of us who've been programming in Informix 4GL for the last 10 years++ have come to appreciate the sheer utility of the CONSTRUCT statement. Unfortunately, the attempts by Informix to provide a GUI equivalent to 4GL have failed dismally. Jury's out on D4GL, but I for one am putting no time or effort into learning it. Another proprietary 4GL? I don't think so. I'm far enough along on the Java push to think that it's going to do what I want, even without the database-aware components from 3rd party vendors such as Inprise, Symantec et al. For now, I've decided to bypass these as my previous experience has not been good; their rules of operation were frequently different from how I wanted my database activity to work. All I really need right now are Type 4 JDBC 2 drivers with at least scrollable ResultSet functionality. We've built a database currently over 30Gb using nothing but Java for data acquisition & maintenence. I've proven to my own satisfaction that I can with minimal tweaking switch database engines between Informix, Oracle & PostgreSQL. (The tweaking, BTW, is nearly all in the areas of timestamps). On to the reporting end and I want my Query by Example functionality. I've had a quick hack at it - 2 nights - and have come up with something that works, by extending JTextField. It works well enough that a second attempt incorporating the lessons from the first should give me pretty much what CONSTRUCT does, though I haven't figured out how to cluster the fields as elegantly yet. Now.... I don't really want to re-invent the wheel yet AGAIN and write another goddam string parser. I've already written enough JavaBeans to provide missing functionality in JTextField. Does anyone know where I can get the source code to one that does QBE already? Language is irrelevant; I can read/program in all the common ones & figure out most of the rest. Of course, a JavaBean with all the functionality already included would be a lot better, so I'm open to all offers. I'd prefer any replies to be to the n/g rather than to my email address, but I've listed one below that I check daily. The hotmail one, I check much less frequently. Thanks, Peter Wiley Email: peter_wil@antdiv.gov.au