Hi,
I am using the following mapping file, but is giving me exception .Could
anybody please help me in this issue.

<?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 = "com.Login" table="LOGIN">

<id name="id" type="long" column="ID" >
<generator class="assigned"/>
</id>

<property name="name">
<column name="NAME"/>
</property>

<property name="age">
<column name="AGE"/>
</property>

<property name="email">
<column name="EMAIL"/>
</property>
</class>
<sql-query name="selectAllEmployees_SP">
<return alias="emp" class="com.Login">
<return-property name="id" column="id"/>
<return-property name="name" column="name"/>
<return-property name="age" column="age"/>
<return-property name="email" column="email"/>
</return>
{ ? = call selectEvents() }
</sql-query>



</hibernate-mapping>

The Exception is

Caused by: org.xml.sax.SAXParseException: Element type "return-property" must be declared.
at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
at org.apache.xerces.util.ErrorHandlerWrapper.error(Unknown Source)
at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
at org.apache.xerces.impl.dtd.XMLDTDValidator.handleStartElement(Unknown Source)
at org.apache.xerces.impl.dtd.XMLDTDValidator.emptyElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.dom4j.io.SAXReader.read(SAXReader.java:334)
at org.hibernate.cfg.Configuration.addInputStream(Configuration.java:393)

Hi

I didn't get error . can you tell me which stage exception raised. at mapping stage or querying stage.


Amila

at mapping stage

Hi

tell me your hibernate version ,java version and database

Amila

java- jdk1.5
oracle 9i
hibernate 3.0

I'm not sure if its causing your specific problem, but your property elements do not denote the type of the column/member. Try something like..

And so forth for the other properties.

The exception you are getting seems to indicate that the XML parser does not recognize the return-property tag. I've never built SQL into my mappings, so I'm unfamiliar with the process, but it looks like the tag is undefined. If you are simply trying to read all the elements of the table and are not required to build this into the mapping file for some reason, you can easily use HQL for that... "from Login"

John