JSTLExamples NetBean Sample Project

2011-10-27 Thread Tim Puchala
I’m trying to run explore SQL Tags section of the sample project provided by NetBeans called JSTLExamples I changed the database url to use sample rather than the default jstl-sample because that is the databes in the Services pane under Databases. The schema is APP and the user is app. I used a

Re: JSTLExamples NetBean Sample Project

2011-10-27 Thread Stani Ryabenkiy
Hi Tim, 1) using SQL tags in a JSP is a bad design choice, I recommend against it. SQL belongs in the model layer, not the presentation layer. 2) I am not familiar with how NetBeans does things nor have I tried Derby but to me this sounds like a typical Tomcat class loader problem. The SQL tags (o

Re: JSTLExamples NetBean Sample Project

2011-10-27 Thread Stuart Thiel
Hi Tim/Stani, I'd go so far as to say SQL doesn't even belong in the model layer as per Fowler/Larmen/whomever 3-layer approaches. My recommendation is to use some form of Controller servlet that takes care of much of what is needed, like setting up connections and setting attributes (not di