Re: [jug-discussion] Programming around Database Problems?
Caveat: I've found that oracle applies query timeouts between steps in its execution plans. If oracle is spending 2 days waiting on a single lock or doing a massive table scan, it's going to be sitting on a single step and the timeout won't work. -Steve TR wrote: Chris, Welcome ! setQueryTimeout works to my knowledge, or at lease was working when I did JDBC support for Oracle. the mechanism it uses is spawn a thread that times out and issues a break on the SQL.So what is the code you are using with setQueryTimeout? On 10/11/07, Christopher Robbins [EMAIL PROTECTED] wrote: I've lurked this list for awhile, so I might as well formally introduce myself. My name is Chris, and I write Java apps for the Department of English at UA. I also do some sysadmin work... And to my question - how does one program around database problems? I've been working on an application that queries a UA database (Oracle), and if the query hangs or doesn't return a result, the application hangs. Even better, I can't use setQueryTimeou() because the Oracle driver (and possibly the database) don't support it. I've never used threads aside from once in a CS class, but would that be the wisest way around this problem? Throw the query into a thread and have the program wait? Any thoughts/insight/snark would be GREATLY appreciated :) - Chris -- Chris Robbins Systems Programmer Department of English - University of Arizona http://www.homerengineeringcorp.net - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [jug-discussion] JUG Group for NFJS?
VMS is sending me a Bashar. That's two. -Steve Andrew Lenards wrote: Are we going to get a group together for NFJS? I know the early-bird deadline is looming. I'm planning on going. I know that Danny Mandel is looking to go. Previously, I believe 3 or 4 people said they would like to I'm just curious that the status is - and how do we sign-up such that we get the reduced rate? Thanks, Andy - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [jug-discussion] Jug dinner
Steve +1 TR wrote: The Jug Holiday meeting will be Tuesday, 12/16 at 6:pm at feast. RSVP is a must, reply here, only if coming please! TR - To unsubscribe, e-mail: jug-discussion-unsubscr...@tucson-jug.org For additional commands, e-mail: jug-discussion-h...@tucson-jug.org
Re: [jug-discussion] another suggestion
I've never heard about sql injection plaguing the mars rover, but it's something you need to be aware of when you're writing webapps. The simplest example of sql injection is a login page that takes a user and a password. Imagine it reads the fields from the web form and runs a sql statement: executeSql(select * from users where login = ' + form.login + ' and password = ' + form.password + '. Works great if I enter steve/pass. Now what if I enter admin' -- for the login and whatever for the password? Your sql statement is effectively: select * from users where login = 'admin' --' and password = 'whatever' By putting the closing quote in my form input, I've injected a -- into the sql statement itself and rendered the rest of the statement a comment. I've logged in as admin without knowing the password. Even worse would be user'; drop table users; --. This is why you should always parameterize your sql. -Steve liz_ravenw...@beaerospace.com wrote: I'm sorry I had to leave last night. Rene, that was very interesting. You did a good job and I'm glad I went. Gosh I have a lot to learn! Anyway, I've been hearing things about this sql injection threat and that the Mars Rover actually had that issue. Could anyone explain what it is and how to prevent it? Respectfully, Liz, Data Base Administrator, Methods Engineering - This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. - To unsubscribe, e-mail: jug-discussion-unsubscr...@tucson-jug.org For additional commands, e-mail: jug-discussion-h...@tucson-jug.org
Re: [jug-discussion] Spring directory path
I'm not claiming this is the best solution (it's sleazy), but if your problem is getting this information out of spring without having access to the spring context, you could use an old-style singleton. Configure your bean in spring and make its no-arg constructor set the static reference to the singleton. The you can use MyPojo.getInstance() to get a handle to the singleton that spring has configured. As a more general solution, I usually have a singleton lying around with a reference to my application context so I can get the context when I'm not in a servlet. -Steve Karl M. Davis wrote: I'm not a Spring guy myself but writing files to an application-relative path doesn't sound like a great idea: what if you're application isn't exploded/unpacked (i.e. what if everything is running from a WAR/JAR)? Why not load a writable path for the application from System.getProperty(myapp.fileStore), using a Preferences instance, or something along those lines? Best regards, Karl - Original Message - From: Steven Elliott elli...@interactivetec.com To: jug-discussion@tucson-jug.org Sent: Wednesday, February 11, 2009 2:24:38 PM GMT -07:00 U.S. Mountain Time (Arizona) Subject: [jug-discussion] Spring directory path Sorry for posting this here but I am pretty sure someone has the answer that seems to elude me. I have a POJO that contains application specific constants. One of the constants I want to put there is the file system root path of the application so that I can write files relative to the root from other POJOs. I want to do this in a generic way so the field in the POJO I would want to be either a string or a File (in otherwords I don’t want to use a Resource which binds me to Spring). Normally I would do this through servletContext.getRealPath(“/”) but the POJO is not a Servlet and has no access to ServletContext. What is the best practice of doing this the IOC Spring (2.0) way? Thanks for the help. Steven - To unsubscribe, e-mail: jug-discussion-unsubscr...@tucson-jug.org For additional commands, e-mail: jug-discussion-h...@tucson-jug.org
Re: [jug-discussion] Hudson?
Easy to set up the server is nice, but what I'd really like to hear is how easy it is to set up a project or manage builds. A couple years ago I switched from anthill to continuum and adding/managing projects got a lot easier. I'm still on version 1.1, but my only hangups with continuum are - killing a build doesn't always kill the forked child process - occasionally a project will get in a bad state where all its builds error out until I restart the service - Too many steps to click through to see how far along a running build is If anyone out there has used both continuum and hudson, I'd love to hear why you like one or the other. I've been meaning to upgrade continuum for a while now, but a really good recommendation might convince me to go another route. -Steve Todd Ellermann wrote: We are using Hudson and loving it. Easy to setup and get running. The automated upgrades have worked everytime. The plugins updates have worked. After spending a week fighting with cruisecontrol I switched to hudson and haven't looked back. -T On a parallel note, issue tracking, we are miserable with Trac and dreaming of JIRA. But still don't miss bugzilla. *** Todd R. Ellermann VP of Engineering VirtualTourist.com Founder Webagogy.com Researcher Betterwebapp.com Personal: todde...@yahoo.com 805-850-8044 cell *** Does getting an ASU MBA with existing UofA BSCE make me a SunCat? or a WildDevil? Go Cats! ...said with a Devilish grin ;) *From:* Andrew Lenards andrew.lena...@gmail.com *To:* jug-discussion@tucson-jug.org *Sent:* Wednesday, May 20, 2009 3:57:08 PM *Subject:* [jug-discussion] Hudson? Is anyone using Hudson (it's an extensible continuous integration engine)? Has anyone played with it? https://hudson.dev.java.net/ I just noticed that Apache is using it. - To unsubscribe, e-mail: jug-discussion-unsubscr...@tucson-jug.org For additional commands, e-mail: jug-discussion-h...@tucson-jug.org
Re: [jug-discussion] Tuesday Meeting May 12
I took a quick look at using it for diffs. It wasn't as comprehensive as oracle's tools. I can't remember exactly what was missing, but I think it was oversights with constraints and functions. If you're just looking to diff the table columns, it's much faster and more stable that oracle's change management pack, but if you want an exhaustive schema comparison, you'll need something better. -Steve Tom Michaud wrote: Has anybody really dug into Liquibase and Oracle 10? Does it work as advertised? I'm considering using it for its diff tool. Thanks in advance, Tom On Sun, May 10, 2009 at 1:30 PM, TR tr...@pobox.com mailto:tr...@pobox.com wrote: JUG, Evan Deaubl will be presentign: Better Database Migration using Liquibase: a presentation on good practices for database migration, and how Liquibase, a tool for database refactoring, can make the implementation and maintenance of those practices simpler. See you ther ! TR - To unsubscribe, e-mail: jug-discussion-unsubscr...@tucson-jug.org For additional commands, e-mail: jug-discussion-h...@tucson-jug.org