Kumaresh Vidhyasagar

Welcome Mario...we have been using Pentaho for last one year...very useful book...nice to have a beginner's guide.

Eventhough PreparedStatement has this advantage of avoiding compilation of query in DB, if you close the connection once you are done with executing the query then both Statement and PreparedStatement are same.

I think you understand what I mean to say!

No you can't have

Your answer is correct!

The problem is with this below code I guess:
rendered="#{gfmCoverageABean.constructionType eq 'Remodeling'}"

When you select a option from that menu, it does not return this value. It may be returning 'key' value of the SelectItems

typeOfConstructionProjectList

Please tell me how you are populating the List above.

Sorry...I want to have a look at the code where the mappings of the values are happening in the projectDetails.jsp

1. Create the link (String) with the parameter added and bind the String variable to the onclick attribute.
2. In the popup (.jsp) file, retrieve the passed parameter and use it.

Please share your backend bean code.

Remove the attribute immediate=true and try it.

" How do you avoid making duplicate entries while loading the data from text file? Because if I upload the same text file, it does and is populating database with duplicate entries! How to avoid that? "



For that, you need to have to have to have your database design proper with primary key constraint set.

Set the path and classpath of the java directory as shown below.

1. Right Click My Computer and select properties.
2. click on Advanced tab and then click on Environmental variables button
3. click on New button of the system variables section and type the variable path as 'path' and variable value as 'java installed directory' + bin
(For eg: C:\Program Files\Java\jdk1.6.0_05\bin)

You can have an stored procedure in your db with this command 'LOAD DATA INFILE'. Then you can execute the stored procedure from java by passing the filename and path.

Why are you posting problems related to Core Java in JSF? Please use the proper forum topics.

Can you tell me how you are associating the values to the dataTable?

Are you using arraylist?

Can you share your code where you have problem with? So that I can quickly review and help you on this.