hibernate3 : help find out the error

[Brendon Woodford]

hi all

I am getting the following error for one-to-one relation mapping.Help debug.

  Hibernate: select employee0_.empno as empno0_1_, employee0_.userName as userName0_1_, personalde1_.empno as empno1_0_, personalde1_.firstName as firstName1_0_, personalde1_.lastName as lastName1_0_ from empl121 employee0_ left outer join personaldetails5 personalde1_ on employee0_.empno=personalde1_.empno where employee0_.empno=?
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not load an entity: [com.bhas.Employee#101]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.loader.Loader.loadEntity(Loader.java:1799)
	at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:47)
	at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:41)
	at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2730)
	at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:365)
	at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:346)
	at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:123)
	at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:82)
	at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:862)
	at org.hibernate.impl.SessionImpl.immediateLoad(SessionImpl.java:820)
	at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:62)
	at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:98)
	at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:158)
	at com.bhas.Employee$$EnhancerByCGLIB$$1f5eab7a.getUserName(<generated>)
	at com.bhas.Main.main(Main.java:26)
Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
	at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
	at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
	at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
	at org.hibernate.loader.Loader.doQuery(Loader.java:662)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
	at org.hibernate.loader.Loader.loadEntity(Loader.java:1785)
	... 14 more
  

The program is as follows:-

  

//Employee.java
package com.bhas;

public class Employee {
	private int empno;
	private String userName;
	private PersonalDetails personalDetails;
	public int getEmpno() {
		return empno;
	}
	public void setEmpno(int empno) {
		this.empno = empno;
	}
	public PersonalDetails getPersonalDetails() {
		return personalDetails;
	}
	public void setPersonalDetails(PersonalDetails personalDetails) {
		this.personalDetails = personalDetails;
	}
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	
	

}


//PersonalDetails.java
package com.bhas;

public class PersonalDetails {

	private int empno;
private String firstName,lastName;
public int getEmpno() {
	return empno;
}
public void setEmpno(int empno) {
	this.empno = empno;
}
public String getFirstName() {
	return firstName;
}
public void setFirstName(String firstName) {
	this.firstName = firstName;
}
public String getLastName() {
	return lastName;
}
public void setLastName(String lastName) {
	this.lastName = lastName;
}

}


//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 package="com.bhas">
<class name="Employee" table="empl121">
<id name="empno" type="int">
<column name="empno"></column>
<generator class="increment"></generator>
</id>
<property name="userName"></property>
<one-to-one name="personalDetails" class="PersonalDetails"></one-to-one>
 </class>

</hibernate-mapping>


//PersonalDetails.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 package="com.bhas">
<class name="PersonalDetails" table="personaldetails5" >
<id name="empno" type="int">
<column name="empno"/>
<generator class="increment"></generator>
</id>
<property name="firstName"></property>
<property name="lastName"></property>
</class>
</hibernate-mapping>

//hibernate.cfg.xml
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

    <session-factory>
        <property name="connection.username">scott</property>
        <property name="connection.url">jdbc:oracle:thin:@localhost:1521:mydb</property>
        <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
        <property name="connection.password">tiger</property>
        <property name="connection.driver_class">oracle.jdbc.OracleDriver</property>
    	<property name="show_sql">true</property>
    </session-factory>

</hibernate-configuration>



//Main class
package com.bhas;

import org.apache.log4j.Level;
import org.apache.log4j.Logger;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class Main {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		Logger.getRootLogger().setLevel(Level.OFF);
		Configuration cfg=new Configuration().configure();
	
		cfg.addResource("Employee.hbm.xml");
		cfg.addResource("PersonalDetails.hbm.xml");
		
		SessionFactory factory=cfg.buildSessionFactory();
		Session session=factory.openSession();
		Employee employee=(Employee)session.load(Employee.class, new Integer(101));
		
		System.out.println("Username  : "+employee.getUserName());
		session.close();
		
		

	}

}

//sql script:

SQL> create table empl121(empno number,userName varchar2(20),deptno number);

Table created.

SQL> create table personaldetails5(empno number,firstname varchar2(20),lastname
varchar2(20));

Table created.

SQL> insert into empl121 values(101,'Tom26',10);

1 row created.

SQL> insert into personaldetails5 values(101,'Tom','cat');

1 row created.

SQL> commit;

Commit complete.


  

I appreciate the help put forward
Thanks
brendon

[Cameron Wallace McKenzie]

As a very quick response, I'd say that most grammar problems come back to some mis-matched mapping from the xml/annotations to the database. Maybe name problem? Incompatible mapping?

Just a hint, but be more descriptive in the old subject like. Most questions in here are about hibernate3. Be more descriptive, and someone that knows the answer might pipe up, as opposed to just passing it by because they are not experts on hibernate3 specifically. Help us help you!