Recent content by javoine

Ya, posted in the wrong area...sorry.

thank you for all your help. I ended up performing the following select d1.* from rows d1, rows d2 where d1.row_key = d2.row_key and d1.row_key in (select d2.row_key from rows d2 start with d2.row_key in (&&enternum) connect by prior d2.parent = d2.row_key) and d1.row_key < &&enternum you...

I'm not sure I can use any of that...I was kind of looking for an example. This is what I'm hoping to do: At first glance it looks like the most efficient way would be to build a cursor that would loop through the records selecting the "row_key" for the "parent" of a submitted row_key and loop...

I have a table that looks like this: create table rows ( row_key integer primary key, name varchar(40), parent integer references rows(row_key) ); It stores a tree structure, so that this data: row_key | name | parent ------------------------------------ 1 | Level 1...

i am absolutely positive that i close all my objects. i dont really have that many, but i do close each one. the driver i am using is: jdbc:postgresql jdbc uses connection pooling, but does not kill the connections after a time limit, so they remain open to the server database, i am taking...

sedj, faithful hero, glad to see you here. yes, although i do not have control over this database (postgres), I was told that we are using a connection pool. In other products that I have used, the connection pool will kill the connection after some said timeout period, in this case...

Greets, I don't know if this should be in this(Tomcat) section or the JSP area, but here goes... I have a simple web application using 2 java classes to access connection information. I call the classes from a JSP page and establish my connection. Then, I close my connections and any...

Sedj, you were right...classpath was not set on the unix box. it was set where i compile my class files,but not where i copy them too. i thought about your remarks for a bit and checked to be sure, saw that it was not set and smacked my forehead. thank you again! everything works like a...

Sedj, ok. I copy them over to the same folders that presently exist. the jsp files are sitting in a directory named after the Application. in that same directory is web-inf. in web-inf is a classes folder and thats where i have 2 packages containing 1 class each. we're running tomcat 4 on...

ok, I use CE to create and compile my java class files and jsp pages. when I'm done, I copy my pages and classes over to a Unix box where tomcat and apache are running. The JSP pages that don't use the classes work fine after I copy them, but the ones that use the class files dont. The...

Ah! I must forget my old ways...Thank you sedj i really appreciate it.

Greets, I am trying to retrieve a date value stored on another page and compare the value retrieved with another value. the date is coming from a listbox on page A and being retreived like this: String eDate = request.getParameter(&quot;Dt&quot;)...

You were looking for Sun One &quot;Standard Edition&quot; you needed &quot;Community Edition&quot; that is the completely free one that they give. This should link to the Community Edition downloads. Good Luck! http://java.sun.com/j2se/1.4.1/download.html#j2sdk-s1studio_ce

sedj, thanx...you're a life saver. now that i see it, it completely makes sense...so thanks for the helping hand and showing me the error in my ways... -prec'

I use CE (Sun One) as well. It's really pretty good and has some cool debug features. It allows you to manage all your database drivers and any servers that you are using. let us know how you like it!