Hi,
I have looked through the OJB junit source code for the odmg and broker
test cases, and I still can't get this to work. If anyone cares to take
a look at the following code and suggest what I'm doing wrong, I'd be
indebted to you...
Searches in the list archive are not very fruitful using the error
messages I'm getting like...
[org.apache.ojb.odmg.TransactionImpl] INFO: Abort transaction was called
on tx [EMAIL PROTECTED], associated PB was
[EMAIL PROTECTED]
org.odmg.LockNotGrantedException: Can not lock
[EMAIL PROTECTED] for WRITE
Here is java code for simple test case:
//note I dropped all the import statements for brevity
public class ClassM implements Serializable {
protected int id;
protected Collection mton;
public void setId(int in) {
this.id = in;
}
public int getId() {
return id;
}
public void setMton(Collection in) {
this.mton = in;
}
public Collection getMton() {
return mton;
}
}
public class ClassN implements Serializable {
protected int id;
protected Collection mton;
public void setId(int in) {
this.id = in;
}
public int getId() {
return id;
}
public void setMton(Collection in) {
this.mton = in;
}
public Collection getMton() {
return mton;
}
}
public class ClassMtoN implements Serializable {
protected int m_id;
protected int n_id;
protected ClassM m;
protected ClassN n;
protected String description;
public void setM_id(int in) {
this.m_id = in;
}
public int getM_id() {
return m_id;
}
public void setN_id(int in) {
this.n_id = in;
}
public int getN_id() {
return n_id;
}
public void setM(ClassM in) {
this.m = in;
}
public ClassM getM() {
return m;
}
public void setN(ClassN in) {
this.n = in;
}
public ClassN getN() {
return n;
}
public void setDescription(String in) {
this.description = in;
}
public String getDescription() {
return description;
}
}
public class TestingMtoN {
Implementation odmg = null;
Database db = null;
protected boolean test;
protected String queryString;
public void setQueryString(String s) {
queryString = s;
}
//I just have this setTest method so that I can use this in a bean
//and test via jsp page.
public void setTest(boolean b) {
// get odmg facade instance
odmg = OJB.getInstance();
db = odmg.newDatabase();
//open database
try{
//this is not the problem :)
db.open(IConstants.REPOSITORY_KEY, Database.OPEN_READ_WRITE);
// Start a transaction
Transaction tx = null;
ClassM m = new ClassM();
try {
tx = odmg.newTransaction();
tx.begin();
tx.lock(m,Transaction.WRITE);
tx.commit();
}catch( Exception ex ){
// Rollback the transaction
tx.abort();
throw ex;
}
ClassN n = new ClassN();
try {
tx = odmg.newTransaction();
tx.begin();
tx.lock(n,Transaction.WRITE);
tx.commit();
}catch( Exception ex ){
// Rollback the transaction
tx.abort();
throw ex;
}
ClassMtoN mton = new ClassMtoN();
try {
tx = odmg.newTransaction();
tx.begin();
tx.lock(mton,Transaction.WRITE);
mton.setM(m);
mton.setN(n);
tx.commit();
}catch( Exception ex ){
// Rollback the transaction
tx.abort();
throw ex;
}
}catch( Exception ex ){
StringWriter s = new StringWriter();
ex.printStackTrace(new PrintWriter(s));
System.out.println(s.toString());
} finally {
try {
db.close();
} catch (Exception ignored) {
//do nothing
}
}
}
}
Here is from repository_user.xml:
<class-descriptor
class="com.worldcycling.web.quickfill.ClassM"
table="class_m"
>
<field-descriptor
name="id"
column="id"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<collection-descriptor
name="mton"
element-class-ref="com.worldcycling.web.quickfill.ClassMtoN"
>
<inverse-foreignkey field-ref="m_id" />
</collection-descriptor>
</class-descriptor>
<class-descriptor
class="com.worldcycling.web.quickfill.ClassN"
table="class_n"
>
<field-descriptor
name="id"
column="id"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<collection-descriptor
name="mton"
element-class-ref="com.worldcycling.web.quickfill.ClassMtoN"
>
<inverse-foreignkey field-ref="n_id" />
</collection-descriptor>
</class-descriptor>
<class-descriptor
class="com.worldcycling.web.quickfill.ClassMtoN"
table="class_mton"
>
<field-descriptor
name="m_id"
column="m_id"
jdbc-type="INTEGER"
primarykey="true"
locking="true"
/>
<field-descriptor
name="n_id"
column="n_id"
jdbc-type="INTEGER"
primarykey="true"
locking="true"
/>
<field-descriptor
name="description"
column="description"
jdbc-type="varchar"
/>
<reference-descriptor
name="m"
class-ref="com.worldcycling.web.quickfill.ClassM"
>
<foreignkey field-ref="m_id" />
</reference-descriptor>
<reference-descriptor
name="n"
class-ref="com.worldcycling.web.quickfill.ClassN"
>
<foreignkey field-ref="n_id" />
</reference-descriptor>
</class-descriptor>
and here is the sql:
create table class_m (
id integer);
create table class_n (
id integer);
create table class_mton (
m_id integer,
n_id integer,
description text
);
--
Steve Linabery, sysadmin/developer
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
