chets patel

Maintain index of current question being displayed. If currentQuestion index == 1 then do not display Previous button. If currentquestion index == last, then do not display Next button. As Bear Bibeault explained, use JSTL to maintain if condition.

Can you try adding "menuModel" in render attribute of ajax event like below.

<f:ajax event="click" render="grpMenuModel menuModel" listener="#{calibrationsBacking.tunerSelectionListener}" />

Use upper function of sql which convert into upper case. And while passing parameter to query, convert all variables into upper case.

@Override public List<LAHSGroupStudyMstr> getLikeSearchRecordsForGroup(BigDecimal siteId, BigDecimal customerId, String search)throws DAOException{ List<LAHSGroupStudyMstr> likeSearchList = null; try{ likeSearchList = session.createQuery("select id.groupSeqId, groupName, groupDesc, status from LAHSGroupStudyMstr where id.siteId=:siteId and customerId=:customerId and UPPER(groupName) LIKE :groupName" + " OR UPPER(groupDesc) Like :groupDesc ") .setBigDecimal("customerId", customerId) .setBigDecimal("siteId", siteId) .setString("groupName", "%"+search.toUpperCase()+"%") .setString("groupDesc", "%"+search.toUpperCase()+"%").list(); } catch(DAOException e){ throw e; } return likeSearchList; }

For more reading on hibernate, read my blogpost http://morejava4u.blogspot.com/p/hibernate.html

I would like to know How inheritance will be used in real world project.
E.g. Consider an example of Bank Account
Approach 1:
Account { String name; double balance; operation1() { } } SavingAccount extends Account { // some extra fields and methods related to saving account operation1() { } } CurrentAccount extends Account { // Some extra fields and methods related to current account. operation1() { } }
When I map these classes with database, using Hibernate using one of the inheritance strategy, e.g. table per sub class, I will end up with three tables. Account, Saving_account and Current_account.
Advantage: I can call operation1() depending on the type of object using polymorphism.
Disadvantage: more tables and classes.

Approach 2:
Account { string name; double balance; string type; operation1() { } }
I need only 1 table for this approach called Account. And "type" field will identify the type of the account.

Advantage: Only 1 table and class.
Disadvantage: I will lose Object oriented world and every place I have to put the condition as below.

if (type == saving) { // do this; } else if (type == current) { // do that; }
As per theory, approach 1 is correct and best. But currently in my project, approach 2 is used. My project is not banking. I took it as an example for the simplicity. Also approach 1 is good for maintaining large complex projects.

Thanks in advance for your inputs.

I know there is big debate going over the net about REST against SOAP. I would like to ask few questions on the top of that.

I am using JAX-WS (SOAP) for quiet few years and It took me no time to learn and it becomes difficult to fit REST on top of SOAP because I could not find a single reason that will convince me that REST is better than SOAP.

People say that REST is easier than SOAP. But according to me, I don't see any learning curve difference between the two.
Suppose I add 1 field in say 10 domain object which is not null, how will I notify my webservice clients if I am using REST. In SOAP generally we publish WSDL. But there is no WSDL here.
How to publish URIs to the client. Let me explain this point in detail.
Say I want to expose cancel order service in REST. My URI is http://mydomain.com/orders/{orderId}. How will my client know that they have to use DELETE and not GET as I have only cancelOrder method and not getOrder method. Also how to publish these different URIs. In SOAP, we publish WSDL. I agree that client need to be recompiled. But publishing the changes to the client is easier in the SOAP. 4. Also people say REST is architecture style. What does this mean?

I am neither against REST nor favouring SOAP. But I am not getting convinced to the extent at which people favour REST. So I think I must be missing some good points of SOAP.

I hope this is not a duplicate question. I tried to search about these specific questions and didn't find answer.

I am trying to learn State design pattern. I took example of Order being placed and having different state. I have implemented it. But I am not sure it is correct way or not. Please check below code and help in that case.
public interface OrderState { void performAction(Context context); void setNextState(Context context); } public class InitialOrderState implements OrderState{ @Override public void performAction(Context context) { System.out.println("Perform initial state operations."); setNextState(context); } @Override public void setNextState(Context context) { context.setCurrentState(Context.STATE_DELIVERED); } } public class DeliveredOrderState implements OrderState { @Override public void performAction(Context context) { System.out.println("Perform delivered state operations"); setNextState(context); } @Override public void setNextState(Context context) { context.setCurrentState(Context.STATE_CLOSED); } } public class Context { public static final OrderState STATE_INITIAL = new InitialOrderState(); public static final OrderState STATE_DELIVERED = new DeliveredOrderState(); public static final OrderState STATE_CLOSED = new ClosedOrderState(); private OrderState currentState; public Context(OrderState orderState) { this.currentState = orderState; } public OrderState getCurrentState() { return currentState; } public void setCurrentState(OrderState currentState) { this.currentState = currentState; } public OrderState getInitialState() { return STATE_INITIAL; } public OrderState getDeliveredState() { return STATE_DELIVERED; } public static Context getOrderStateFromState(String state) { if ("Initial".equalsIgnoreCase(state)) { return new Context(STATE_INITIAL); } else { return new Context(STATE_DELIVERED); } } }

From my client code I will get the context object depending on state.
public void createOrder() { Context context = Context.getOrderStateFromState("Initial"); OrderState initialState = new InitialOrderState(); initialState.performAction(context); saveOrderInDatabase(); } public void deliverOrder() { Order order = retrieveOrderFromDB(); Context context = Context.getOrderStateFromState(order.getState()); DeliveredOrderState deState = new DeliveredOrderState(); deState.performAction(context); saveOrderInDatabase(); }

Please let me know if above implementation is correct?
Thanks in advance.

Hi Jeanne
Thanks for your reply.
I tried catching dataIntegrityViolationException. But issue is, it gives me message that "can not execute JDBCBatchUpdate". If I have unique constraint on more than two columns and I want to display explanatory message to user then it is very difficult for me to do this.
Can you please let me know how can I handle this situation.

Thanks in advance.

I am using spring with JPA (Hibernate Implementation). I want to do mapping of vendor specific SQL error code to my user defined messages. Spring throws DataAccessException. I am not able to retrieve SQL error code from DataAccessException.
I tried somethink like this:
try { Client order = createClient(client); clientDAO.submitclient(client); } catch (DataAccessException e) { e.getCause() // returning org.hibernate.PropertyValueException in case I am inserting null to not-null column. // How to get sql error code from object of property value exception. }

Spring is providing some SQLErrorCodeTranslator using sql-error-code.xml. but it is working with jdbcTemplate. I want to use jpaTemplate.

Thanks in advance.

Hi All,
I am trying to develop new website in spring/hibernate/tomcat/JTOM.
I am just using those jars and not modifying their source code.
Do I need to make my website also open source?
what are the things I have to take care in terms of licensing.
please help

Get result.listIterator() outside while loop both in while condition and in first statement of while loop.
ListIterator iterator = results.listIterator(); while(iterator.hasNext()){ User friend =em.find(User.class,iterator.next().getFriendEmail()); friends.add(friend); }

Hi Bill Gorder
Thanks for the quick response.
I have not null check in database for one of the field. If I set for that field as null, then in this scenario, I should get DataAccessException. But still I am getting UnexpectedRollbackException.
But I want to check this as constraint violation exception which is coming under DataAccessException(Checked this in JUNIT using JPATransactionManager).
Can you please let me know how should I handle this.

Thanks in advance.

Hi All,
I am using spring with jboss application server. As per my knowledge spring throws DataAccessException. But when I use it in JBoss, it gives me UnexpectedRollbackException.
I am using JTATransactionmanager for transaction management.

It works fine for JUNIT.

Does any one know the reason?

Hi I want to change the Soap prefix. By default it is taking "env". But I want to change it to soap. I tried below code but it is not working.
envelope.addNamespaceDeclaration("soap", "http://www.w3.org/2003/05/soap-envelope"); envelope.setPrefix("soap");

It is just adding namespace declaration. but not changing the prefix.
I searched a lot and tried all possible solutions available on net. But not a single solution worked for me.

Thanks in advance.
Please help me. I am stuck.

I have two POJOs as below.
Company{ String companyName; Set<MasterCompany> masterCompany; } MasterCompany { String masterCompanyName; }
Assuming ID and all other hbm xml mapping works fine as I am able to save and update the objects perfectly fine.
I want to search those companies having particular master comapnies associated with it.
I write below code for searching the company:
Session session = sessionFactory.openSession(); Query query = session.createQuery("select c from Company c left join c.masterCompanySet mc where mc.masterCompanyName in (:masterCompanyList)"); List<String> masterCompanyNames = new ArrayList<String>(); masterCompanyNames.add("Master Company Name"); query.setParameterList("masterCompanyList", masterCompanyNames); query.list();
When I see the query generated by hibernate, it is as below.

select company0_.COMPANY_ID as COMPANY1_0_, company0_.COMPANY_NAME as COMPANY2_0_, company0_.ADDRESS as ADDRESS0_, company0_.CITY as CITY0_, company0_.DISTRICT as DISTRICT0_, company0_.STATE as STATE0_, company0_.PHONE as PHONE0_, company0_.MOBILE as MOBILE0_, company0_.EMAIL as EMAIL0_, company0_.URL as URL0_, company0_.COUNTRY as COUNTRY0_ from COMPANY company0_ inner join MASTER_CLIENT mastercomp1_ on company0_.COMPANY_ID=mastercomp1_.COMPANY_ID inner join MASTER_COMPANY mastercomp2_ on mastercomp1_.MASTER_COMPANY_ID=mastercomp2_.MASTER_COMPANY_ID where mastercomp2_.MASTER_COMPANY_NAME in (?)

Above query seems ok to me but I get following error.

Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'company0_.COMPANY_ID=mastercomp1_.COMPANY_ID inner join MASTER_COMPANY mastercomp2_ on mastercomp1_.MASTER_COMPANY_ID=mastercomp2_.MASTER_COMPANY_ID'.

I googled all the examples and they are giving the same query as above.

Can any one please help what is wrong with it.
I wasted whole day but didnt get solution.

No body is there to answer my question
Please help if any one knows the ans