thanks again, the credits are on the way :-)
these are my files, maybe you can figure it out
Operation.hbm.xml:
Code:
<?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="de.soft_nrg.www.xDMS.Operation" table="tkp.joboperationsview">
<id name="keyJob" column="njobkey">
<generator class="native"/>
</id>
</class>
</hibernate-mapping>
hibernate.cfg.xml:
Code:
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- <property name="connection.datasource">java:comp/env/jdbc/quickstart</property> -->
<property name="connection.driver_class">sun.jdbc.odbc.JdbcOdbcDriver</property>
<property name="connection.url">jdbc:odbc:tkp_pgs</property>
<property name="connection.user">tkp</property>
<property name="connection.password">tkp</property>
<property name="hibernate.cglib.use_reflection_optimizer">false</property>
<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<property name="show_sql">false</property>
<!-- Mapping files -->
<mapping resource="Operation.hbm.xml"/>
</session-factory>
</hibernate-configuration>
java test class:
Code:
package de.soft_nrg.www.xDMS;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import de.soft_nrg.www.xDMS.Operation;
/**
* Hibernate helper class
*
* @author chris
*/
class HibernateUtil {
public static final SessionFactory sessionFactory;
static {
try {
sessionFactory = new Configuration()
.configure()
//.addResource("Operation.hbm.xml")
//.addClass(de.soft_nrg.www.xDMS.Operation.class)
.buildSessionFactory();
} catch (Throwable ex) {
System.err.println("Initial SessionFactory creation failed. " + ex);
throw new ExceptionInInitializerError(ex);
}
}
public static final ThreadLocal session = new ThreadLocal();
public static Session currentSession() throws HibernateException {
Session s = (Session) session.get();
if (s == null) {
s = sessionFactory.openSession();
session.set(s);
}
return s;
}
public static void closeSession() throws HibernateException {
Session s = (Session) session.get();
if (s != null)
s.close();
session.set(null);
}
}
/**
* Hibernate test class
*
* @author chris
*/
public class HibernateTest {
public Operation testOperationLoadThroughHibernate(String jobKey, String opKey) {
Session session = HibernateUtil.currentSession();
Transaction tx = session.beginTransaction();
Operation op = (Operation) session.load(Operation.class, jobKey);
// List result = session.createQuery("from Event").list();
tx.commit();
session.close();
return op;
}
public static void main(String[] args) {
HibernateTest test = new HibernateTest();
Operation op = test.testOperationLoadThroughHibernate("AA00000002", "1");
System.out.println(op);
}
}
thanks
Login
FAQ
Search
