Here is my mapping file:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="com.ditech.signingappt.db.WebAppUserDbBean" table="web_app_users">
<id name="username" type="string" column="username" >
<generator class="assigned" />
</id>
<property name="fname" column="fname" type="string" />
<property name="lname" column="lname" type="string" />
<property name="role_cd" column="role_cd" type="string" />
<property name="status" column="status" type="string" />
<property name="notes" column="notes" type="string" />
<property name="insert_date" column="insert_date" type="timestamp" />
<property name="password" column="usr_pswd" type="string" />
<set name="vendors" table="WEB_APP_USER_VENDOR_MAP" >
<key column="username" />
<many-to-many class="com.ditech.signingappt.db.VendorDbBean" column="comp_cd" />
</set>
</class>
</hibernate-mapping>
My persistent class:
public class WebAppUserDbBean implements Serializable {
private String username;
private String fname;
private String lname;
private String role_cd;
private String status;
private String notes;
private Timestamp insert_date;
private String password;
private Set vendors;
public WebAppUserDbBean() {
}
public WebAppUserDbBean(String username, String fname, String lname,
String role_cd, String status, String notes,
Timestamp insert_date, String password,
Set vendors) {
this.username = (username != null) ? username.trim().toUpperCase() : username;
this.fname = fname;
this.lname = lname;
this.role_cd = role_cd;
this.status = (status != null) ? status.trim().toUpperCase() : status;
this.notes = notes;
this.insert_date = insert_date;
this.password = password;
this.vendors = vendors;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = (username != null) ? username.trim().toUpperCase() : username;
}
public String getFname() {
return fname;
}
public void setFname(String fname) {
this.fname = fname;
}
public String getLname() {
return lname;
}
public void setLname(String lname) {
this.lname = lname;
}
public String getRole_cd() {
return role_cd;
}
public void setRole_cd(String role_cd) {
this.role_cd = role_cd;
}
public String getStatus() {
return status;
}
public void setStatus(String status) {
this.status = (status != null) ? status.trim().toUpperCase() : status;
}
public String getNotes() {
return notes;
}
public void setNotes(String notes) {
this.notes = notes;
}
public Timestamp getInsert_date() {
return insert_date;
}
public void setInsert_date(Timestamp insert_date) {
this.insert_date = insert_date;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public Set getVendors() {
return vendors;
}
public void setVendors(Set vendors) {
this.vendors = vendors;
}
/**
* debug method.
* @return
*/
public String toString() {
String str = "\nWebAppUser - \n"
+ "\tUsername: " + this.username
+ "\n\tFname: " + this.fname
+ "\n\tLname: " + this.lname
+ "\n\tRole_cd: " + this.role_cd
+ "\n\tStatus: " + this.status
+ "\n\tInsert_date: " + this.insert_date
+ "\n\tVendors: " + this.vendors
+ "\n\tNotes: " + this.notes
;
if (vendors != null) {
str += "\n\tNum vendors: " + vendors.size();
}
return str;
}
}
My call to Hibernate:
public static void update(Object instance) throws DataAccessObjectException {
Session session;
if (log.isTraceEnabled()) {
log.trace("update: begin");
}
session = openSession();
try {
session.update(instance);
if (log.isDebugEnabled()) {
log.debug("update: called session.update()");
}
} catch (Exception e) {
log.error("update: update() failed", e);
throw new DataAccessObjectException("update() failed", e);
} finally {
try {
closeWithCommit(session);
} finally {
if (log.isTraceEnabled()) {
log.trace("update: end");
}
}
}
}
There's some wrapper classes and all, but they are basically pass throughs to Hibernate methods.
We're also using the Transport Object pattern, but those are just serializable JavaBeans.
No matter what I try, the first string column that is updated by Hibernate gets corrupted.
Is it possible that this is a character set mismatch between my Weblogic server and the Oracle Database?
Everything works fine through a JUnit test class running with net.sf.hibernate.transaction.JDBCTransactionFactory
Weblogic is using net.sf.hibernate.transaction.JTATransactionFactory
Both are using net.sf.hibernate.dialect.OracleDialect
-bnl
Login
FAQ
Search
