Damon Getsman wrote:
> Not exactly JavaBeans, but pretty close... If anybody knows a better
> resource on usenet for just JSP, please feel free to let me know.
comp.lang.java.programmer might be more appropriate for pure JSP issues,
but this is really about mySql
>
> Another day, another stupid question proving how little I know about
> this language that I'm supposed to be coding in right now...
>
> I have a 'subroutine' in the jsp that I'm currently working on that
> works with about 20-30 different variables; general manipulation,
> tossing them in to various database tables, etc... Anyway, there's a
> whole load of SQL queries, inserts, and updates going on in this piece
> of code, too. One of them (at least) is broken. Judging by the error
> that I'm getting from the tomcat logfiles, it's in one of the queries,
> and it seems that one of my variables is being interpolated as a table
> column... So I need to find a way to view the SQL interactions as
> they're happening or an easy way to dump all of my variables somewhere
> so that I can take a peek at them in order to locate what is going on.
>
> Commenting out all of the SQL and adding debugging output is an
> option, but one that is going to be a real pain in the buttocks. I'd
> much rather find an easier way.
>
> Any ideas?
I use Derby so I'm just guessing here, but seems like the first thing
would be to enable and check the mysql logs
http://dev.mysql.com/doc/refman/5.0/en/query-log.html
>
> TIA
>
> -Damon Getsman
> -=-=-=-
> ITRx http://www.itrx-nd.com/
> Programmer/Systems Administrator
> -=-=-=-
|
