Recent content by mackey333

Assuming that socket is Socket which may or may not be closed or connected and inputStream = socket.getInputStream(). if (socket.isClosed() || !socket.isConnected()) { return null; } try { i = inputStream.read(); } catch (Exception e) { System.out.println(e.printStackTrace())...

Just updating this - The query which is building the zip code distance table (I limited it to 25 miles for testing), is still running. I'll report back when I have results. -Greg :-Q

@jaxtell Sorry, I miss read what you were saying the first time around but your solution seems to make sense. I'll give it a try and see what I come up with. @thargtheslayer Thanks for the info, unfortunately I don't have the budget available to add that component to our Oracle license...

That sounds like a good idea for a static location, however in my situation the input zip is variable and could be anywhere in the country. -Greg :-Q

Thanks for the quick answer, however it is impossible for me to have the candidate zip codes in their own table because the list is generated on demand in PHP. For example: -The user enters a radius of 50 miles from zip code 19130 -PHP selects the zip codes within 50 miles based on lat/lon...

Here is the execution plan: Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=ALL_ROWS (Cost=21 Card=6 Bytes=144) 1 0 NESTED LOOPS (Cost=21 Card=6 Bytes=144) 2 1 TABLE ACCESS (BY INDEX ROWID) OF 'PROVIDERS' (TABLE) (Cost=9...

I have two tables with about 2.5 million rows each. One has address information and the other has name information. I've indexed the LOWER() value of the last name column and also the zip code column: CREATE INDEX last_name_idx ON providers(LOWER(Last_Name)); CREATE INDEX zip_idx ON...

Thanks for the advice, there should be enough info there to get me going in the right direction. I'll report back if I run into any problems. -Greg :-Q

So maybe a "relational table" was not the word I was looking for but I think everyone got the point I was trying to make. I am attempting to update an old table structure which someone created directly from a flat file at some point in the past. Keeping the current setup is out of the question...

Hello - I am trying to get some data into a relational form and I have run into a little problem. I have a table in the database with columns foo_1, bar_1, foobar_1, foo_2, bar_2, foobar_2 etc.. all the way out to 150. In PL/SQL, I would like to do something like: for i in 1..150 loop...

I am trying to convert my asp page to use the command.execute function instead of resultset.open to interface with a database. I am totally lost as to why this works: For Each issue In issues value = trim(issue) addIssue =...

Hey all thanks for the suggestions. I ended up just copying and pasting the method code into a run() method and starting a new thread. Then I used: Thread myThread... myThread.start(); Thread.sleep(5); myThread.stop(); Its a little messy but it is working for my purposes, hopefully it...

Well I just need to use something one time for testing purposes. I am turning a C program which is currently being called by creating a new process and grabbing its output into a Java class which is built into the program. The problem is sometimes the C program craps out. I am trying to test...

Is there an easy way to code the following: "If this method does not finish executing within 5 seconds, then throw an exception and move on"? -Greg :-Q

Make sure that your CD drive is ahead of the hard drive in the boot order in the bios. As it is booting you may get a prompt that says something to the effect of "press any key to boot from CD..." you will only have a couple of seconds to press a key though. If you still can't get into the...