andree surya

Ok. Thanks for your code and advice, Mike !

Ninad Kulkarni wrote:@ andree
Suppose if we handled SQLException in clearParameters() method is that good idea to handle it there?
Let see what other will say about it.

Thanks for the response Ninad.
I forgot to mention that getByIdStatement is a PreparedStatement object, included in the Java standard library.
I need to call clearParameters() method to the the object because it will be reused later.

Hi there,

I just want to confirm if I've done this the correct way.
I have a code to fetch a record from database, given the ID of the record.

/** * Get the transaction with the specified ID. */ public Transaction getById(int id) throws DataSourceException, DataNotFoundException { try { getByIdStatement.setInt(1, id); ResultSet result = getByIdStatement.executeQuery(); if (! result.next()) throw new DataNotFoundException(); Transaction transaction = new Transaction(); transaction.setId(result.getInt("id")); transaction.setDescription(result.getString("description")); transaction.setAmount(result.getDouble("amount")); transaction.setDate(result.getString("date")); result.close(); return transaction; } catch (SQLException e) { System.err.println(e); throw new DataSourceException(); } finally { getByIdStatement.clearParameters(); } }

The problem is, apparently the clearParameters() call in the finally block throws an SQLException.
I managed to solve this by putting another try catch clause inside the finally block.

try { getByIdStatement.clearParameters(); } catch (SQLException e) { System.err.println(e); throw new DataSourceException(); }

Problem solved, by I hate this. Exception handling is cluttering up my code !
Can someone give an advice, how should I solve this problem? Or this is how it is, and I should just leave it be?

Thanks guys for the help. But honestly, I'm a bit overwhelmed since I'm not yet that much into Java

However, I understand that JSF doesn't go well with JSP, so I decide to remove those JSP scriptlets, and use something like this instead:

<h:dataTable value="#{BookController.categoryCollection}" var="category" style="width: 100%"> <h:column> <li> <f:facet name="Name"></f:facet> <h:form> <h:commandLink action="#{BookController.filterByCategory}"> <f:param name="category_id" value="#{category.id}" /> <h:outputText value="#{category.name}" /> </h:commandLink> </h:form> </li> </h:column> </h:dataTable>

Nevertheless, thanks for your time and effort .. I appreciate that

I have a set of categories and I want to display that as hyperlinks in my JSF page.
If the user clicks in one of them, the category ID is submitted and the action BookController.filterByCategory is called.

This is my code:
<h2>Categories</h2> <ul> <% ArrayList<Category> categories = Category.selectAll(); for (int i = 0; i < categories.size(); i++) { %> <li> <h:form> <h:inputHidden binding="#{BookCategories.bookBean.categoryId}" value="<%= categories.get(i).getId() %>" /> <h:commandLink action="#{BookCategories.filterByCategory}"> <h:outputText value="<%= categories.get(i).getName() %>" /> </h:commandLink> </h:form> </li> <% } %> </ul>
And when I browse the page, apparently it doesn't work:
Problem accessing /book_store_jsf/index.jsf. Reason: PWC6033: Unable to compile class for JSP PWC6197: An error occurred at line: 82 in the jsp file: /sidebar.jsp PWC6199: Generated servlet error: The method setValue(ValueExpression) in the type InputHiddenTag is not applicable for the arguments (int) PWC6197: An error occurred at line: 84 in the jsp file: /sidebar.jsp PWC6199: Generated servlet error: The method setValue(ValueExpression) in the type OutputTextTag is not applicable for the arguments (String)
Can anyone tell me the correct way to do this?

Thanks,
Ang

Ah, it's okay. I just found out about <f:subview> tag.

Hm .. I can't find any relevant information. But it's okay, now I'm using jetty and it works (I'm in hurry).
Thanks for the response, anyway !

Hi there,

I have 4 JSP files: header.jsp, content.jsp, sidebar.jsp, footer.jsp
In content.jsp, all 3 other files are included:
<jsp:include page="header.jsp" /> <!-- Content --> <jsp:include page="sidebar.jsp" /> <jsp:include page="footer.jsp" />
The problem is, I want to put a JSF form on each sidebar.jsp and content.jsp.
I want to achieve this by putting <f:view> tag on each file, but apparently it doesn't work.
Only one form appear (in sidebar.jsp), so I assume that in one page there should be only one <f:view>.

So I took the extreme approach: I put <f:view> opening tag in the top most of header.jsp and </f:view> closing tag in bottom most of footer.jsp.
But it doesn't work either. Jetty compalins that <f:view> tag doesn't have a closing tag in header.jsp.

Can anyone help me here? Basically I just want to have 2 JSF forms in one page, but in separate files.

Still the same error, without complain about servlet.jar.
31 Okt 09 2:43:21 org.apache.coyote.http11.Http11BaseProtocol init INFO: Initializing Coyote HTTP/1.1 on http-8080 31 Okt 09 2:43:21 org.apache.catalina.startup.Catalina load INFO: Initialization processed in 461 ms 31 Okt 09 2:43:21 org.apache.catalina.core.StandardService start INFO: Starting service Catalina 31 Okt 09 2:43:21 org.apache.catalina.core.StandardEngine start INFO: Starting Servlet Engine: Apache Tomcat/5.5.28 31 Okt 09 2:43:21 org.apache.catalina.core.StandardHost start INFO: XML validation disabled 31 Okt 09 2:43:21 org.apache.catalina.core.StandardContext start SEVERE: Error listenerStart 31 Okt 09 2:43:21 org.apache.catalina.core.StandardContext start SEVERE: Context [/book_store_jsf] startup failed due to previous errors 31 Okt 09 2:43:21 org.apache.coyote.http11.Http11BaseProtocol start INFO: Starting Coyote HTTP/1.1 on http-8080 31 Okt 09 2:43:21 org.apache.jk.common.ChannelSocket init INFO: JK: ajp13 listening on /0.0.0.0:8009 31 Okt 09 2:43:21 org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=0/24 config=null 31 Okt 09 2:43:21 org.apache.catalina.storeconfig.StoreLoader load INFO: Find registry server-registry.xml at classpath resource 31 Okt 09 2:43:21 org.apache.catalina.startup.Catalina start INFO: Server startup in 838 ms

Thanks Tim, but .. Still, it doesn't work. More clue?

Hi guys, please help me with my problem here.
I have two similiar web application, one can be started by tomcat, and another doesn't

One is under webapps/book_store folder, which is working correctly.
Another is under webapps/book_store_jsf, which is almost exactly the same application (except the project name in build.xml), which can't be started by tomcat.

This is the console log when I start the tomcat server:
30 Okt 09 9:27:02 org.apache.coyote.http11.Http11BaseProtocol init INFO: Initializing Coyote HTTP/1.1 on http-8080 30 Okt 09 9:27:02 org.apache.catalina.startup.Catalina load INFO: Initialization processed in 463 ms 30 Okt 09 9:27:02 org.apache.catalina.core.StandardService start INFO: Starting service Catalina 30 Okt 09 9:27:02 org.apache.catalina.core.StandardEngine start INFO: Starting Servlet Engine: Apache Tomcat/5.5.28 30 Okt 09 9:27:02 org.apache.catalina.core.StandardHost start INFO: XML validation disabled 30 Okt 09 9:27:03 org.apache.catalina.loader.WebappClassLoader validateJarFile INFO: validateJarFile(E:\programs\Apache Software Foundation\Tomcat 5.5\webapps\ book_store\WEB-INF\lib\servlet-2.3.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class 30 Okt 09 9:27:03 org.apache.catalina.loader.WebappClassLoader validateJarFile INFO: validateJarFile(E:\programs\Apache Software Foundation\Tomcat 5.5\webapps\ book_store_jsf\WEB-INF\lib\servlet-2.3.jar) - jar not loaded. See Servlet Spec 2 .3, section 9.7.2. Offending class: javax/servlet/Servlet.class 30 Okt 09 9:27:03 org.apache.catalina.core.StandardContext start SEVERE: Error listenerStart 30 Okt 09 9:27:03 org.apache.catalina.core.StandardContext start SEVERE: Context [/book_store_jsf] startup failed due to previous errors 30 Okt 09 9:27:03 org.apache.coyote.http11.Http11BaseProtocol start INFO: Starting Coyote HTTP/1.1 on http-8080 30 Okt 09 9:27:03 org.apache.jk.common.ChannelSocket init INFO: JK: ajp13 listening on /0.0.0.0:8009 30 Okt 09 9:27:03 org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=0/22 config=null 30 Okt 09 9:27:03 org.apache.catalina.storeconfig.StoreLoader load INFO: Find registry server-registry.xml at classpath resource 30 Okt 09 9:27:03 org.apache.catalina.startup.Catalina start INFO: Server startup in 844 ms
book_store can be accessed, but book_store_jsf doesn't. Can anyone find out what am I doing wrong here?
I'm aware that in line 16, the log tells me that tomcat doesn't like my servlet-2.3.jar. I've deleted the file, but still it doesn't work.

Okay, I think I'll go with the /lib. Thanks for the input !

Currently I'm working without IDE, and I configure the classpath manually inside the ant build file.
I set my compile classpath by including every jar files inside /web/WEB-INF/lib. So it's okay and common to do this? I don't need to create a separate /lib directory?

Hi there,

I've been learning java web for several weeks and I always use "/web/WEB-INF/lib" as my compile classpath. Well, I don't feel right doing this, because I think that's not how "/web" directory supposed to be used. Recently, I see an example on the Internet that uses "/lib" (directly under root) as its compile classpath. However, if I do put my library (e.g. JDBC driver) under "/lib", still I have to put that library under "/web/WEB-INF/lib" for runtime usage, so the file will be redundant.

So basically my question is, where should I put external libraries?

Thanks,
Ang

Hey, it's working now but I'm not sure what do I did to fix this. Maybe because I'm restarting the tomcat server.