AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  SQL and the LGP-30          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message Roedy Green Guest Posted: Fri Jun 18, 2004 6:37 am    Post subject: SQL and the LGP-30 You can see a picture of my first personal computer, an LGP-30 at http://mindprod.com/jgloss/mindprod.com/equipment.html It had no transistors, just tubes, a rotating drum, and a few diodes. You programmed the thing with absolute addresses, a hex track and sector number on the drum. Programming with JDBC took be back to those thrilling days of yesteryear. Every parameter is numbered, one based. I can't believe the incompetence of this intefarce. At the very least it should have named parameters in the prepareStatement. It is a nightmare trying to write code where the PreparedStatements are nowhere near the code that has to used counted fieldnames in them. You CAN'T proofread the damn things. Further the debugging tools to figure out what is going on are non-existent. You have to pepper your code with debug output to narrow down where the problem is. You can't even cut and paste into MySQL to test the SQL. You'd think after 30 years or so they have got this stuff polished. -- Canadian Mind Products, Roedy Green. Coaching, problem solving, economical contract programming. See http://mindprod.com/jgloss/jgloss.html for The Java Glossary. Back to top Roedy Green Guest Posted: Fri Jun 18, 2004 7:44 am    Post subject: Re: SQL and the LGP-30 On Fri, 18 Jun 2004 06:37:28 GMT, Roedy Green <look-on (AT) mindprod (DOT) com.invalid> wrote or quoted : Quote: You'd think after 30 years or so they have got this stuff polished. What needs to happen is a tighter integration of Java and SQL. Then you could do compile time checking to make sure column names are correct and the types of local variables could be generated from the database. The syntax of prepared statements could be analysed and verified at compile time. It might be another layer similar to the way JSP is implemented. SQL allows fully dynamic work that could not be type checked, but the bread and butter stuff could be. It is much like Java itself where most of the time you can use typechecking, but for fully dynamic work you can subvert the type system. There is no reason not to lock the local variable names to being the same as the column names. -- Canadian Mind Products, Roedy Green. Coaching, problem solving, economical contract programming. See http://mindprod.com/jgloss/jgloss.html for The Java Glossary. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.