krunal prajapati

Hello,
I want to make left join using hibernate,
I can make left join using native query in hibernate like
List<Object[]> langList = session.createSQLQuery("select me.me_Dsidioma,u4.u4_Dstexto from Me_Idiomas me left join U4_Textosussds u4 on u4.u4_Me_nuidioma= me.me_Nuidioma").list();

but while I am using HQL I getting error,

Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: Path expected for join! [select me.meDsidioma,u4.u4Dstexto from tid.cip.bd.prepago120000.impl.MeIdiomas me left join U4Textosussds u4 WHERE me.meNuidoma=u4.u4Menuidioma] at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31) at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24) at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59) at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:235) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112) at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623) at tid.cip.planes.Plans.main(Plans.java:127)

and my hbm.xml and java files are shown below

MeIdiomas.hbm.xml
<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="tid.cip.bd.prepago120000.impl.MeIdiomas" table="ME_IDIOMAS"> <id name="meNuidoma" type="long"> <column name="ME_NUIDIOMA" length="2"/> <generator class="assigned" /> </id> <property name="meDsidioma" type="string"> <column name="ME_DSIDIOMA"/> </property> <property name="mecdcaracterdecimal" type="string"> <column name="ME_CDCARACTERDECIMAL"/> </property> </class> </hibernate-mapping>


U4Textosussds.hbm.xml
<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="tid.cip.bd.prepago120000.impl.U4Textosussds" table="U4_TEXTOSUSSDS"> <id name="u4u3Nuidussd" type="long"> <column name="U4_U3_NUIDUSSD" length="2"/> <generator class="assigned" /> </id> <!-- <many-to-one name="u4Menuidioma" class="tid.cip.bd.prepago120000.impl.MeIdiomas"> --> <!-- <column name="U4_ME_NUIDIOMA"/> --> <!-- </many-to-one> --> <property name="u4Menuidioma" type="long"> <column name="U4_ME_NUIDIOMA"/> </property> <property name="u4Dstexto" type="string"> <column name="U4_DSTEXTO"/> </property> </class> </hibernate-mapping>


MeIdiomas.java
package tid.cip.bd.prepago120000.impl; public class MeIdiomas { private long meNuidioma; private String meDsidioma; private String mecdcaracterdecimal; /** * @return the meNuidoma */ public long getMeNuidoma() { return meNuidioma; } /** * @param meNuidoma the meNuidoma to set */ public void setMeNuidoma(long meNuidioma) { this.meNuidioma = meNuidioma; } /** * @return the meDsidioma */ public String getMeDsidioma() { return meDsidioma; } /** * @param meDsidioma the meDsidioma to set */ public void setMeDsidioma(String meDsidioma) { this.meDsidioma = meDsidioma; } /** * @return the mecdcaracterdecimal */ public String getMecdcaracterdecimal() { return mecdcaracterdecimal; } /** * @param mecdcaracterdecimal the mecdcaracterdecimal to set */ public void setMecdcaracterdecimal(String mecdcaracterdecimal) { this.mecdcaracterdecimal = mecdcaracterdecimal; } }

U4Textosussds.java
package tid.cip.bd.prepago120000.impl; public class U4Textosussds { private long u4u3Nuidussd; private long u4Menuidioma; private String u4Dstexto; /** * @return the u4u3Nuidussd */ public long getU4u3Nuidussd() { return u4u3Nuidussd; } /** * @param u4u3Nuidussd the u4u3Nuidussd to set */ public void setU4u3Nuidussd(long u4u3Nuidussd) { this.u4u3Nuidussd = u4u3Nuidussd; } /** * @return the u4Menuidioma */ public long getU4Menuidioma() { return u4Menuidioma; } /** * @param u4Menuidioma the u4Menuidioma to set */ public void setU4Menuidioma(long u4Menuidioma) { this.u4Menuidioma = u4Menuidioma; } /** * @return the u4Dstexto */ public String getU4Dstexto() { return u4Dstexto; } /** * @param u4Dstexto the u4Dstexto to set */ public void setU4Dstexto(String u4Dstexto) { this.u4Dstexto = u4Dstexto; } }

Plans.java main method here
public static void main(String args[]){ HibernateConnectionManager manager = new HibernateConnectionManager(); SessionFactory sessionFactory = new Configuration().configure("/prepago.cfg.xml").buildSessionFactory(); Session session = sessionFactory.openSession(); Transaction tx = null; tx = session.beginTransaction(); // List<Object[]> langList = session.createSQLQuery("select me.meDsidioma,u4.u4Dstexto from MeIdiomas me left join U4Textosussds u4 on me.meNuidoma=u4.u4Menuidioma").list(); List<Object[]> langList = session.createSQLQuery("select me.me_Dsidioma,u4.u4_Dstexto from Me_Idiomas me left join U4_Textosussds u4 on u4.u4_Me_nuidioma= me.me_Nuidioma").list(); for(Object[] obj : langList) { System.out.println(">>>>>>>"+obj[0]); System.out.println(">>>>>>>"+obj[1]); } // "select d.name,p.name,sum(p.price) as totalprice from Product p join p.dealer d group by p.name"; // List langList = session.createQuery("select u4Dstexto from U4Textosussds").list(); // List langList = session.createQuery("select meDsidioma from MeIdiomas").list(); manager.closeSession(session); System.out.println("success"); }

Now what I have to do to use HQL?
Thank you in advance,
Krunal

hello,

I want to make insert-update-delete application with integration of jsf+spring+hibernate.
In this application I am able to insert and delete record from datatable in jsf.

But I can't update value in datatable,

so I request you, please post sample application with insert-update-delete in jsf+spring+hibernate framework.

Hope you will do this,


Thank you,
Krunal Prajapati

thank you for suggestion,
I had problem with bean id naming and now it has been solved....


thank you again to both of you sir.

but I have problem in creating bean with name 'employeeDao'.

please refer error in bold.



run:
Jul 9, 2011 10:29:08 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from file [D:\Documents and Settings\KRUNAL\My Documents\NetBeansProjects\SpringHibernate\src\resources\spring-hibernate.xml]
file [D:\Documents and Settings\KRUNAL\My Documents\NetBeansProjects\SpringHibernate\src\resources\spring-hibernate.xml]
Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'employeeDao' defined in file [D:\Documents and Settings\KRUNAL\My Documents\NetBeansProjects\SpringHibernate\src\resources\spring-hibernate.xml]: Cannot resolve reference to bean 'hibernateTemplate' while setting bean property 'hibernateTemplate'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'hibernateTemplate' is defined
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1317)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1076)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at com.spring.hibernate.SpringHibernateTest.main(SpringHibernateTest.java:26)
Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'hibernateTemplate' is defined
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:510)
at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1056)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:274)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 10 more
Java Result: 1
BUILD SUCCESSFUL (total time: 5 seconds)

hello,

I have integrate spring with hibernate but i got error and i cant sovle it,


my file structure is following,




and my xml files are following,

employee.hbm.xml <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="com.spring.hibernate.Employee" table="Employee"> <id column="Id" name="id"> <generator class="assigned"/> </id> <property name="name"> <column name="Name"/> </property> <property name="age"> <column name="Age"/> </property> <property name="salary"> <column name="Salary"/> </property> </class> </hibernate-mapping>

2. spring-hibernate.xml
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd"> <bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource" > <property name="driverClassName" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost/samples"/> <property name="username" value="root"/> <property name="password" value="root"/> </bean> <bean id="SessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="dataSource" ref="myDataSource"/> <property name="mappingResources"> <list> <value>src/resources/employee.hbm.xml</value> </list> </property> <property name="hibernateProperties"> <value>hibernate.dialect=org.hibernate.dialect.HSQLDialect</value> </property> </bean> <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate"> <property name="sessionFactory"> <ref bean="mySessionFactory"/> </property> </bean> <bean id="employeeDao" class="com.spring.hibernate.EmployeeDao"> <property name="hibernateTemplate"> <ref bean="hibernateTemplate"/> </property> </bean> </beans>

my java file is
1. springhibernatetest.java
/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package com.spring.hibernate; import org.springframework.beans.factory.BeanFactory; import org.springframework.beans.factory.xml.XmlBeanFactory; import org.springframework.core.io.FileSystemResource; import org.springframework.core.io.Resource; import org.springframework.orm.hibernate3.LocalSessionFactoryBean; public class SpringHibernateTest { public static void main(String[] args) { Resource resource = new FileSystemResource("src/resources/spring-hibernate.xml"); BeanFactory factory = new XmlBeanFactory(resource); System.out.println(resource); Employee employee = new Employee(); employee.setId("123"); employee.setName("ABC"); employee.setAge(20); employee.setSalary(15000.00d); EmployeeDao employeeDao = (EmployeeDao) factory.getBean("employeeDao"); System.out.println(employeeDao); employeeDao.saveOrUpdate(employee); Employee empResult = employeeDao.getEmployee("123"); System.out.println(empResult); } }

2. employeedao.java

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package com.spring.hibernate; import java.sql.SQLException; import org.hibernate.HibernateException; import org.hibernate.Session; import org.springframework.orm.hibernate3.HibernateCallback; import org.springframework.orm.hibernate3.HibernateTemplate; public class EmployeeDao { private HibernateTemplate hibernateTemplate; public void setHibernateTemplate(HibernateTemplate hibernateTemplate) { this.hibernateTemplate = hibernateTemplate; } public HibernateTemplate getHibernateTemplate() { return hibernateTemplate; } public Employee getEmployee(final String id) { HibernateCallback callback = new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { return session.load(Employee.class, id); } }; return (Employee) hibernateTemplate.execute(callback); } public void saveOrUpdate(final Employee employee) { HibernateCallback callback = new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { session.saveOrUpdate(employee); return null; } }; hibernateTemplate.execute(callback); } }

3. employee.java

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package com.spring.hibernate; public class Employee { private String id; private String name; private int age; private double salary; public Employee() { } public String getId() { return id; } public void setId(String id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public double getSalary() { return salary; } public void setSalary(double salary) { this.salary = salary; } public String toString() { return "Id = " + id + ", Name = " + name + ", Age = " + age + ", Salary = " + salary; } }
and i got following error,

run:
Jul 8, 2011 3:56:50 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from file [C:\Documents and Settings\Administrator\My Documents\NetBeansProjects\SpringHibernate\src\resources\spring-hibernate.xml]
file [C:\Documents and Settings\Administrator\My Documents\NetBeansProjects\SpringHibernate\src\resources\spring-hibernate.xml]
Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'employeeDao' defined in file [C:\Documents and Settings\Administrator\My Documents\NetBeansProjects\SpringHibernate\src\resources\spring-hibernate.xml]: Cannot resolve reference to bean 'hibernateTemplate' while setting bean property 'hibernateTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateTemplate' defined in file [C:\Documents and Settings\Administrator\My Documents\NetBeansProjects\SpringHibernate\src\resources\spring-hibernate.xml]: Cannot resolve reference to bean 'mySessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'mySessionFactory' is defined
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1317)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1076)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at com.spring.hibernate.SpringHibernateTest.main(SpringHibernateTest.java:26)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateTemplate' defined in file [C:\Documents and Settings\Administrator\My Documents\NetBeansProjects\SpringHibernate\src\resources\spring-hibernate.xml]: Cannot resolve reference to bean 'mySessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'mySessionFactory' is defined
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1317)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1076)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 10 more
Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'mySessionFactory' is defined
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:510)
at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1056)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:274)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 20 more
Java Result: 1
BUILD SUCCESSFUL (total time: 0 seconds)


thanks in advance,

Hello all friends,

I have done it upto two level with use of jsp,servlet and javascript (Not ajax),
like,

when you will select country, then its corresponding state will come, and when you will choose state then district name will come, but it become very complex, because of when page will reload ,previous value (country, state)also should be maintained,

Thank you sagar,
It helped me a lot.

First we create object of class like,

A a = new A();

when this line of code will execute,

constructor of class A will call. ok

Now class A's constructor is like this,

A(){
super();
}

when this constructor will call,

A's superclass constructor will also called,

And If I don't write super(); in constructor, then also call to super class constructor,

so my question is How Long the super class' constructor will call ?

because in java every class create default constructor automatically(if not initialized).

hello,

I want to call servlet from javascript and my index.jsp is

<html> <head> <script type="text/javascript"> function callservlet(){ document.location.href="servlet/mainDAO"; //document.getElementById().src="mainDAO"; } </script> </head> <body> <a onclick="javascript callservlet();"></a> </body> </html>

I tried both javascript method
and my servlet class is mainDAO.java is

in doGet method
PrintWriter out = rwsponse.getWriter(); out.println("hello world");


then how can I call servlet without using form ans submit button


thanks,

thanks for help,


in last I tried with html form, that's working well...

thanks again..

my first module's jsp is,
page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" HttpSession sessionid = request.getSession(); String userId = request.getParameter("userId"); sessionid.setAttribute("userId", userId); System.out.println("SESSION IS :" + sessionid.getAttribute("userId")); response.sendRedirect("http://localhost:8080/OtherModule");



and my other OtherModule's index.jsp page is,

protected void doGet(HttpServletRequest request, HttpServletResponse response){ HttpSession session = request.getSession(); if(session.getAttribute("userId") != null){ System.out.println("SESSION ID @ GET: " + session.getAttribute("userId")); } else { System.out.println("No Session for userId"); } } //I also tried this with post but still I can't get the session


but i can not pass session in other application..

how can i solve that...


thanks,
Krunal

ya i have checked it but no one error is shown in error consol.

I think that, It can be possible b'cos of java plugin.

b'cos In my linux- firefox no java plugin installed.

Am i right....?

hi,

I have problem in applet with linux firefox,

I want to open .exe file on client machine with applet in browser.

I have signed jar too.

It works fine in windows in all browsers,

But applet is not displayed in Linux firefox,

thanks,
Krunal

hi
I am beginner for session in servlet.

can I set multiple session attribute in my servlet class
for Example.
session.setAttribute("username",firstname); session.setAttribute("loginID",loginID); session.setAttribute("recID", recID);

I am maintain session with the use of loginID.

and username is for showing welcome + "username" while you login.

and rec_id is pk - for my main table.

then, am I right with this code.

Thank You so much Javin and Clapham.
With the help of you I understood it very practically.