[Middlegen-user] Strange Hibernate Behaviour

Discussion:

Neo Gigs

2004-05-05 07:47:28 UTC

Hello,

I had the following codes with does not show me any error at all and there is no updates/insert
into the database:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import com.theta.code.Addrtyp;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.MappingException;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;

public class InsertACodeTest {

private static Configuration cfg = null;
private static SessionFactory sf = null;
private static Connection conn = null;
private static Session se = null;
private static Addrtyp at = null;

public static void main(String[] args) {
try {
loadDBConnection();
loadConfiguration();
loadFactorySession();
loadSession();
testInsert();
} catch (Exception e) {
e.printStackTrace();
} finally {
System.gc();
}
}

private static void loadConfiguration() throws MappingException {
cfg = new Configuration().addFile("Addrtyp.hbm.xml");
}

private static void loadFactorySession() throws HibernateException {
sf = cfg.buildSessionFactory();
}

private static void loadDBConnection()
throws
ClassNotFoundException,
IllegalAccessException,
InstantiationException,
SQLException {
String sJDBCdriver = "COM.ibm.db2.jdbc.app.DB2Driver";
String sDBurl = "jdbc:db2:LOS_DB";
String sUserID = "db2admin";
String sPassword = "db2admin";
Class.forName(sJDBCdriver).newInstance();
conn = DriverManager.getConnection(sDBurl, sUserID, sPassword);
}

private static void loadSession() {
se = sf.openSession(conn);
}

private static void testInsert() throws HibernateException {
at = new Addrtyp();
at.setCode("999");
at.setDesc("test 999");
at.setStatus("A");
at.setDescEnglish("bla");
se.saveOrUpdate(at);
}
}
and the XML file is like this:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

<hibernate-mapping>


<class
name="com.theta.code.Addrtyp"
table="CODE.ADDRTYP"
<id
name="code"
type="java.lang.String"
column="CODE"
<generator class="assigned" />
</id>

<property
name="desc"
type="java.lang.String"
column="DESC"
length="50"
/>
<property
name="status"
type="java.lang.String"
column="STATUS"
length="1"
/>
<property
name="descEnglish"
type="java.lang.String"
column="DESC_ENGLISH"
length="100"
/>



</class>
</hibernate-mapping>

Can anyone tell me whats wrong? All I could get is these 2 lines:

log4j:WARN No appenders could be found for logger (net.sf.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.

Does these warning won't update/insert anything into the database?

Thanks

Neo

__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover

Eivind Waaler

2004-05-05 08:16:03 UTC

Permalink

Hi,

Could it be that there is some exception/error occuring but not being
logged because log4j isen't configured? Make sure you have a
log4j.properties in the classpath when you run your testprogram.

.eivind

Post by Neo Gigs
Hello,
I had the following codes with does not show me any error at all and there is no updates/insert
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.theta.code.Addrtyp;
import net.sf.hibernate.HibernateException;
import net.sf.hibernate.MappingException;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;
public class InsertACodeTest {
private static Configuration cfg = null;
private static SessionFactory sf = null;
private static Connection conn = null;
private static Session se = null;
private static Addrtyp at = null;
public static void main(String[] args) {
try {
loadDBConnection();
loadConfiguration();
loadFactorySession();
loadSession();
testInsert();
} catch (Exception e) {
e.printStackTrace();
} finally {
System.gc();
}
}
private static void loadConfiguration() throws MappingException {
cfg = new Configuration().addFile("Addrtyp.hbm.xml");
}
private static void loadFactorySession() throws HibernateException {
sf = cfg.buildSessionFactory();
}
private static void loadDBConnection()
throws
ClassNotFoundException,
IllegalAccessException,
InstantiationException,
SQLException {
String sJDBCdriver = "COM.ibm.db2.jdbc.app.DB2Driver";
String sDBurl = "jdbc:db2:LOS_DB";
String sUserID = "db2admin";
String sPassword = "db2admin";
Class.forName(sJDBCdriver).newInstance();
conn = DriverManager.getConnection(sDBurl, sUserID, sPassword);
}
private static void loadSession() {
se = sf.openSession(conn);
}
private static void testInsert() throws HibernateException {
at = new Addrtyp();
at.setCode("999");
at.setDesc("test 999");
at.setStatus("A");
at.setDescEnglish("bla");
se.saveOrUpdate(at);
}
}
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
<hibernate-mapping>

<class
name="com.theta.code.Addrtyp"
table="CODE.ADDRTYP"
<id
name="code"
type="java.lang.String"
column="CODE"
<generator class="assigned" />
</id>
<property
name="desc"
type="java.lang.String"
column="DESC"
length="50"
/>
<property
name="status"
type="java.lang.String"
column="STATUS"
length="1"
/>
<property
name="descEnglish"
type="java.lang.String"
column="DESC_ENGLISH"
length="100"
/>

</class>
</hibernate-mapping>
log4j:WARN No appenders could be found for logger (net.sf.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Does these warning won't update/insert anything into the database?
Thanks
Neo
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user

Ben Litchfield

2004-05-05 12:43:09 UTC

Permalink

You need to flush/commit the transaction for it to work! Otherwise
nothing will be added to the database and no error will be thrown.

Ben