Barry Van

Greenhorn
+ Follow
since Oct 23, 2008
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Barry Van

Hi All,

Any one help me createCriteria using Joins ...
Please find the given below joins query :

public List getJobseekerWorkExperience(Integer id) {

StringBuffer selectClause = new StringBuffer(
" select jswe.employerName, jswe.employerAddress, jswe.startFrom, jswe.endTo, jswe.visible, jswe.sortOrder, ");
selectClause
.append(" jswel.businessSector, jswel.occupationTitle, jswel.mainActivities, jswe.id ");
StringBuffer fromClause = new StringBuffer(
" from CvoJsWorkExperience as jswe, ");
fromClause.append(" CvoJsWorkExperienceLingual as jswel ");
StringBuffer whereClause = new StringBuffer(
" where jswe.id=jswel.cvoJsWorkExperience and jswe.cvoJobseeker= ");
whereClause.append(id);
StringBuffer orderbyClause = new StringBuffer(
" order by jswe.sortOrder ");

Query q = session.createQuery(selectClause.toString()
+ fromClause.toString() + whereClause.toString()
+ orderbyClause.toString());
List results = q.list();
return results;

}
Hi All

Please tell me any one given below doubt:-
Which is the give good Performance between this two, when we use for find the results :-
1) Hashtable equals = new Hashtable();
equals.put("WorkExperience", workExperience);
equals.put("JsLinguisticVersion", lingVersion);
List results = commonDAO.doQuery(className, equals, null, null);
if (results.size() > 0) {
-----------------
------------------
}

2) Query q = session.createQuery(selectClause.toString()
+ fromClause.toString() + whereClause.toString()
+ orderbyClause.toString());
List results = q.list();


Hi,
I am getting this error 'hibernate undefined alias : 1 error' when i write in hql .... and run the application

private void handleOccupationSearchCategory(StringBuffer fromClause,
StringBuffer whereClause, OccupationSearchCategory category) {
if (category != null && category.isEnabled()) {
logger.debug("Adding search criteria for occupation: " + category);
// fromClause.append(" inner join js.cvoJsOccugroups jsg ");
whereClause.append(" and js.id IN (").append(
"select 1 from CvoJsOccugroup as jsog ").append(
" where jsog.cvoOccugroup.id=").append(
category.getOccupationGroupId()).append(
" and jsog.cvoJobseeker.id=js.id");

// whereClause.append(" and
// jsg.cvoOccugroup.id=").append(category.getOccupationGroupId());
if (category.getExperienceLevelId() != null) {
whereClause.append(" and jsog.cvoExperienceLevel.id >=")
.append(category.getExperienceLevelId());
}
whereClause.append(")");
}
}
HI

Criteria having where clause? if have give me example hibernate query using criteria where clause?
Hi

any one help on this issues QueryException: could not resolve property


StringBuffer selectClause = new StringBuffer(
" select jswe.employerName, jswe.employerAddress, jswe.startFrom, jswe.endTo, jswe.visible, jswe.sortOrder ");
selectClause.append(" jswel.businessSector, jswel.occupationTitle, jswel.mainActivities ");
StringBuffer fromClause = new StringBuffer(" from CvoJsWorkExperience as jswe ");
fromClause.append(" left join jswe.CvoJsWorkExperienceLingual as jswel ");
StringBuffer whereClause = new StringBuffer(" where jswe.id=jswel.cvoJsWorkExperience and jswe.cvoJobseeker= ");
whereClause.append(id);


ERROR com.eurodyn.cvo.facade.FacadeException: org.hibernate.QueryException: could not resolve property: CvoJsWorkExperienceLingual of: com.eurodyn.euresportal.pojos.CvoJsWorkExperience [ select jswe.employerName, jswe.employerAddress, jswe.startFrom, jswe.endTo, jswe.visible, jswe.sortOrder jswel.businessSector, jswel.occupationTitle, jswel.mainActivities from com.eurodyn.euresportal.pojos.CvoJsWorkExperience as jswe left join jswe.CvoJsWorkExperienceLingual as jswel where jswe.id=jswel.cvoJsWorkExperience and jswe.cvoJobseeker= 477841]
org.hibernate.QueryException: could not resolve property: CvoJsWorkExperienceLingual of: com.eurodyn.euresportal.pojos.CvoJsWorkExperience [ select jswe.employerName, jswe.employerAddress, jswe.startFrom, jswe.endTo, jswe.visible, jswe.sortOrder jswel.businessSector, jswel.occupationTitle, jswel.mainActivities from com.eurodyn.euresportal.pojos.CvoJsWorkExperience as jswe left join jswe.CvoJsWorkExperienceLingual as jswel where jswe.id=jswel.cvoJsWorkExperience and jswe.cvoJobseeker= 477841]
at org.hibernate.persister.entity.AbstractPropertyMapping.throwPropertyException(Ljava.lang.String;)V(AbstractPropertyMapping.java:43)
at org.hibernate.persister.entity.AbstractPropertyMapping.toType(Ljava.lang.String;)Lorg.hibernate.type.Type;(AbstractPropertyMapping.java:37)
at org.hibernate.persister.entity.BasicEntityPersister.toType(Ljava.lang.String;)Lorg.hibernate.type.Type;(BasicEntityPersister.java:1094)
at org.hibernate.hql.classic.PathExpressionParser.getPropertyType()Lorg.hibernate.type.Type;(PathExpressionParser.java:268)
at org.hibernate.hql.classic.FromPathExpressionParser.end(Lorg.hibernate.hql.classic.QueryTranslatorImpl;)V(FromPathExpressionParser.java:12)
at org.hibernate.hql.classic.ParserHelper.parse(Lorg.hibernate.hql.classic.Parser;Ljava.lang.String;Ljava.lang.String;Lorg.hibernate.hql.classic.QueryTranslatorImpl;)V(ParserHelper.java:29)
at org.hibernate.hql.classic.FromParser.token(Ljava.lang.String;Lorg.hibernate.hql.classic.QueryTranslatorImpl;)V(FromParser.java:197)
at org.hibernate.hql.classic.ClauseParser.token(Ljava.lang.String;Lorg.hibernate.hql.classic.QueryTranslatorImpl;)V(ClauseParser.java:86)
at org.hibernate.hql.classic.PreprocessingParser.token(Ljava.lang.String;Lorg.hibernate.hql.classic.QueryTranslatorImpl;)V(PreprocessingParser.java:108)
at org.hibernate.hql.classic.ParserHelper.parse(Lorg.hibernate.hql.classic.Parser;Ljava.lang.String;Ljava.lang.String;Lorg.hibernate.hql.classic.QueryTranslatorImpl;)V(ParserHelper.java:28)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile()V(QueryTranslatorImpl.java:176)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile(Ljava.util.Map;Z)V(QueryTranslatorImpl.java:152)
at org.hibernate.impl.SessionFactoryImpl.getQuery(Ljava.lang.String;ZLjava.util.Map;)[Lorg.hibernate.hql.QueryTranslator;(SessionFactoryImpl.java:427)
at org.hibernate.impl.SessionImpl.getQueries(Ljava.lang.String;Z)[Lorg.hibernate.hql.QueryTranslator;(SessionImpl.java:884)
at org.hibernate.impl.SessionImpl.list(Ljava.lang.String;Lorg.hibernate.engine.QueryParameters;)Ljava.util.List;(SessionImpl.java:834)
at org.hibernate.impl.QueryImpl.list()Ljava.util.List;(QueryImpl.java:74)
at com.eurodyn.cvo.dao.hibernate.HibernateJobseekerDataDAO.getJobseekerWorkExp(Ljava.lang.Long;)Ljava.util.List;(HibernateJobseekerDataDAO.java:949)
at com.eurodyn.cvo.facade.JobseekerDataFacade.getWorkExperience(Ljava.lang.Integer;Ljava.lang.String;)Ljava.util.List;(JobseekerDataFacade.java:5396)
at com.eurodyn.cvo.delegates.JobseekerDataDelegate.getWorkExperience(Ljava.lang.Integer;Ljava.lang.String;)Lcom.eurodyn.cvo.medusa.dto.DTO;(JobseekerDataDelegate.java:289)
at com.eurodyn.cvo.web.actions.WorkExperienceAction.getWorkExperience(Lorg.apache.struts.action.ActionMapping;Lorg.apache.struts.action.ActionForm;Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)Lorg.apache.struts.action.ActionForward;(WorkExperienceAction.java:42)
at jrockit.reflect.NativeMethodInvoker.invoke0(Ljava.lang.Object;ILjava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)
at jrockit.reflect.NativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)
at jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Optimized Method)
at java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Optimized Method)
at org.apache.struts.actions.DispatchAction.dispatchMethod(Lorg.apache.struts.action.ActionMapping;Lorg.apache.struts.action.ActionForm;Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Ljava.lang.String;)Lorg.apache.struts.action.ActionForward;(DispatchAction.java:274)
at org.apache.struts.actions.DispatchAction.execute(Lorg.apache.struts.action.ActionMapping;Lorg.apache.struts.action.ActionForm;Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)Lorg.apache.struts.action.ActionForward;(DispatchAction.java:194)
at org.apache.struts.action.RequestProcessor.processActionPerform(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Lorg.apache.struts.action.Action;Lorg.apache.struts.action.ActionForm;Lorg.apache.struts.action.ActionMapping;)Lorg.apache.struts.action.ActionForward;(RequestProcessor.java:419)
at com.eurodyn.cvo.web.CVORequestProcessor.processActionPerform(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Lorg.apache.struts.action.Action;Lorg.apache.struts.action.ActionForm;Lorg.apache.struts.action.ActionMapping;)Lorg.apache.struts.action.ActionForward;(CVORequestProcessor.java:55)
at org.apache.struts.action.RequestProcessor.process(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(RequestProcessor.java:224)
at com.eurodyn.cvo.web.CVORequestProcessor.process(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(CVORequestProcessor.java:49)
at org.apache.struts.action.ActionServlet.process(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doGet(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(ActionServlet.java:414)
Hi

i am using this query but getting error.

StringBuffer selectClause = new StringBuffer(
" select jswe.employerName, jswe.employerAddress, jswe.startFrom, jswe.endTo, jswe.visible, jswe.sortOrder, ");
selectClause.append(" jswel.businessSector, jswel.occupationTitle, jswel.mainActivities ");
StringBuffer fromClause = new StringBuffer("from CvoJsWorkExperience as jswe ");
fromClause.append(" left join jswe.CvoJsWorkExperienceLingual as jswel ");
StringBuffer onClause = new StringBuffer(" on jswe.id=jswel.cvoJsWorkExperience ");
StringBuffer whereClause = new StringBuffer(" where cvoJobseeker= ");
whereClause.append(id);

please any one modify the query which is work properly.

error messege :
ERROR com.eurodyn.cvo.facade.FacadeException: org.hibernate.QueryException: outer or full join must be followed by path expression [select jswe.employerName, jswe.employerAddress, jswe.startFrom, jswe.endTo, jswe.visible, jswe.sortOrder, jswel.businessSector, jswel.occupationTitle, jswel.mainActivities from com.eurodyn.euresportal.pojos.CvoJsWorkExperience as jswe inner join fetch CvoJsWorkExperienceLingual as jswel on jswe.id=jswel.cvoJsWorkExperience where cvoJobseeker= 477841]
org.hibernate.QueryException: outer or full join must be followed by path expression [select jswe.employerName, jswe.employerAddress, jswe.startFrom, jswe.endTo, jswe.visible, jswe.sortOrder, jswel.businessSector, jswel.occupationTitle, jswel.mainActivities from com.eurodyn.euresportal.pojos.CvoJsWorkExperience as jswe inner join fetch CvoJsWorkExperienceLingual as jswel on jswe.id=jswel.cvoJsWorkExperience where cvoJobseeker= 477841]
this is from property file:

cvo.button.jobseeker.personalData.save=Save
15 years ago
yes, its a Save method only.
please any one give me answer.

my Code :

jsp page :

<html:submit styleClass="CVO_btn" property="dispatch">
<bean:message key="cvo.button.jobseeker.personalData.save"/>
</html:submit>

ActionClass :

public Map getKeyMethodMap() {
Map map = new HashMap();
map.put("cvo.button.jobseeker.personalData.save","savePersonalData");
map.put("action.viewPersonalData", "viewPersonalData");
logger.info("map\t"+map.get("cvo.button.jobseeker.personalData.save"));
return map;
}

Struts-config.xml :

<action name="jobseekerPersonalDataForm"
path="/managePersonalData"
scope="request"
parameter="dispatch"
validate="false"
roles="jobseeker"
type="com.eurodyn.cvo.web.actions.PersonalDataAction">
<forward name="viewPersonalData" path="/managePersonalData.do?dispatch=viewPersonalData"/>
</action>

Note : working in all languages but except spanish language is not working in that screen only. And working(save method) other screens in spanish language.
15 years ago
Hi all,
Anybody solve this issue please.

Error 500--Internal Server Error
javax.servlet.ServletException: Action[/managePersonalData] missing resource 'Save' in key method map
at org.apache.struts.actions.LookupDispatchAction.getLookupMapName(Ljavax.servlet.http.HttpServletRequest;Ljava.lang.String;Lorg.apache.struts.action.ActionMapping;)Ljava.lang.String;(LookupDispatchAction.java:240)
at org.apache.struts.actions.LookupDispatchAction.getMethodName(Lorg.apache.struts.action.ActionMapping;Lorg.apache.struts.action.ActionForm;Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Ljava.lang.String;)Ljava.lang.String;(LookupDispatchAction.java:281)
at org.apache.struts.actions.LookupDispatchAction.execute(Lorg.apache.struts.action.ActionMapping;Lorg.apache.struts.action.ActionForm;Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)Lorg.apache.struts.action.ActionForward;(LookupDispatchAction.java:158)
at org.apache.struts.action.RequestProcessor.processActionPerform(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Lorg.apache.struts.action.Action;Lorg.apache.struts.action.ActionForm;Lorg.apache.struts.action.ActionMapping;)Lorg.apache.struts.action.ActionForward;(RequestProcessor.java:419)
at com.eurodyn.cvo.web.CVORequestProcessor.processActionPerform(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Lorg.apache.struts.action.Action;Lorg.apache.struts.action.ActionForm;Lorg.apache.struts.action.ActionMapping;)Lorg.apache.struts.action.ActionForward;(CVORequestProcessor.java:55)
at org.apache.struts.action.RequestProcessor.process(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(RequestProcessor.java:224)
at com.eurodyn.cvo.web.CVORequestProcessor.process(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(CVORequestProcessor.java:49)
at org.apache.struts.action.ActionServlet.process(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run()Ljava.lang.Object;(Optimized Method)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Lweblogic.servlet.internal.FilterChainImpl;)V(Optimized Method)
at weblogic.servlet.internal.TailFilter.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Ljavax.servlet.FilterChain;)V(TailFilter.java:28)
at weblogic.servlet.internal.FilterChainImpl.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(FilterChainImpl.java:27)
at com.eurodyn.euresportal.web.filter.HibernateSessionFilter.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Ljavax.servlet.FilterChain;)V(HibernateSessionFilter.java:41)
at weblogic.servlet.internal.FilterChainImpl.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(FilterChainImpl.java:27)
at org.ajaxanywhere.AAFilter.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Ljavax.servlet.FilterChain;)V(AAFilter.java:41)
at weblogic.servlet.internal.FilterChainImpl.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(FilterChainImpl.java:27)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run()Ljava.lang.Object;(WebAppServletContext.java:6724)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Lweblogic.security.subject.AbstractSubject;Ljava.security.PrivilegedAction;)Ljava.lang.Object;(Optimized Method)
at weblogic.security.service.SecurityManager.runAs(Lweblogic.security.acl.internal.AuthenticatedSubject;Lweblogic.security.acl.internal.AuthenticatedSubject;Ljava.security.PrivilegedAction;)Ljava.lang.Object;(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(Lweblogic.servlet.internal.ServletRequestImpl;Lweblogic.servlet.internal.ServletResponseImpl;)V(WebAppServletContext.java:3764)
at weblogic.servlet.internal.ServletRequestImpl.execute(Lweblogic.kernel.ExecuteThread;)V(ServletRequestImpl.java:2644)
at weblogic.kernel.ExecuteThread.execute(Lweblogic.kernel.ExecuteRequest;)V(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run()V(ExecuteThread.java:178)
at java.lang.Thread.startThreadFromVM(Ljava.lang.Thread;)V(Unknown Source)

15 years ago
HI All,

Please any one give me example code - How to get the DataSourceName in java?

Hi,

Please tell to -- How to get the No.of Active ConnectionPools in Connection Pooling?
HI All

Please any one give me example of code using SharedPoolDataSource : getMaxActive(),getMaxIdle.
15 years ago
Hi All,

Actually Requirement is that, want to check that how many connectionPooling Connections are used/using.. through check the code.. not on serverConsole. Please any one tell the code how can we check the through code?
requirement like this one for insert and other for retrieved
can you tell me the code? please?
Hi All,

I have 2 tables 'A'table, 'B'table, having both same columns.
My question is.. can i use one java file "setter/getter" for both tables like writing 2 hbm files for one java file? is it possible , or ?