I have a GetConnection type function in an include file and a function that
loads a Hashtable from a resultset using a connection created with the above
mentioned function and it is in the same "util" include file. The hashtable
is in a <%! so the rest of the page can use it and it basically stores
config values. The problem I am seeing is with the following SQL query
"SELECT * FROM Configuration" I get different results in the hashtable then
if I do "SELECT * FROM Configuration ORDER BY con_Name" and should I do
"SELECT * FROM Configuration ORDER BY con_ID" I get no results. A "SELECT
Count(*) FROM Configuration" also yields no results... The thing that makes
me think it's caching is the first query I offered up yields what would have
been all the results last week, I added a few new rows to the table and it
returns me what look like the "old" results whereas the second query is only
missing 1 row...
BUT, I also have a test.jsp page which in a single page has the same create
a database connection block and the code to "SELECT * FROM Configuration"
and have it print me out a table with all the fields in the query complete
with Column Names from the resultset meta data and it shows me everything.
Would it be helpful if I attached/quoted me 2 jsp pages? I am a bit new to
java and jsp so I am not certain what the common "gotchas" are yet.
Thanks for your time and help!
--
John Minadeo
[EMAIL PROTECTED]
> -----Original Message-----
> From: Pat Quinn [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 10, 2000 7:24 PM
> To: JRun-Talk
> Subject: RE: Caching...
>
>
> How are you accessing the database? Are you using an included
> file, or do
> you access the db directly from a single jsp? That could make
> a difference.
>
> It's possible that this is a database/driver issue. For
> example, I tested
> your problem using the jdbc-odbc bridge to a Microsoft Access
> database, and
> the jsp did not need to be re-saved. It picked up any new
> data, EXCEPT when
> the table was left open (but saved). Thus, my hunch that it could be
> database-related.
>
> But, send along some more info, and we'll get to the bottom of it.
>
> Best,
> Patrick Quinn
> Allaire Consulting
>
> -----Original Message-----
> From: John Minadeo [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 10, 2000 5:18 PM
> To: JRun-Talk
> Subject: Caching...
>
>
> Hey all,
> I was wondering if someone could tell me what is going on in
> a situation I'm
> having...
>
> Basically, I have a .JSP page set up to run under a Jrun
> server. The page
> grabs some front end layout info from a SQL server 7 database
> (accessed via
> the i-net software SPRINTA JDBC driver). Now, when I change
> data in the
> database, I need to re-save my .jsp page to get jrun to
> interepret it and
> access the new data.
>
> Is there someway around this? I think I am having a few other
> data caching
> oddities which may be due to that as well.
>
> Can anyone shed any light on this? Thank you all ever so much!
>
> --
> John Minadeo
> [EMAIL PROTECTED]
> --------------------------------------------------------------
> --------------
> --
> Archives: http://www.egroups.com/group/jrun-interest/
> Unsubscribe:
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.
----------------------------------------------------------------------------
--
Archives: http://www.egroups.com/group/jrun-interest/
Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.
------------------------------------------------------------------------------
Archives: http://www.egroups.com/group/jrun-interest/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
