Hey guys,
This would be my first time using
JDBC within an application. The problem i am having now is the exception that is in the subject line.
Don't get me wrong now, I understand what it means, but i'm not sure what i am doing wrong.
So the database im querying is a little bit strange(at least i think i have yet to see any other database than this one).
Essentially i start off with one value, and must match that to a value in another table, to which i must take another value(being text or date) and compare that to another table. So, in this giant mess of connections and statements i get this error. I ended up creating a new connection for each separate query, but im concerned because i call another query(with a different Connection) before i finish my first query if that is screwing things up.
I am sorry if this does not make the most amount of sense, i am trying my hardest to make it clear.
I could post some code, but I would be a little embarrassed as i am sure that the JDBC handling seems infantile because this is not something that they teach us in school. I have a slight google-education in the matter right now.
I appreciate your help and suggestions in advance, if there is anything that i can clear up, please just let me know.