Re: Problems with OQLQuery

[Jakob Braeuchi]

hi rolf,

do you have antl.jar or antlr.debug.jar in your classpath ?

jakob

Rolf Pfister wrote:
Hi all,

Each time when create a OQL Query with
	OQLQuery query = odmg.newOQLQuery(); 
I get the following error message:
java.lang.NoClassDefFoundError: antlr/TokenStreamException
	at org.apache.ojb.odmg.OJB.newOQLQuery(Unknown Source)
	at
ch.lcu.mycoach.data.MemberFactory.getMemberDO(MemberFactory.java:56)
...

Whats wrong? The same query is working when I use the PersistenceBroker
implementation. Can anybody help me?
I'm working with ojb-1.0.rc4.
Thanks for your help!

Rolf

NB:This is the code of the MemberFactory class:

package ch.lcu.mycoach.data;

import org.apache.ojb.odmg.OJB;
import org.odmg.*
import ch.lcu.mycoach.entities.Member;
public class MemberFactory {

        Implementation odmg = null;
        Database db = null;
        Member member = new Member();
        public MemberFactory() {
                // get odmg facade instance
                odmg = OJB.getInstance();
                db = odmg.newDatabase();
                //open database
                try {
                        db.open("mycoach", Database.OPEN_READ_WRITE);
                } catch (ODMGException ex) {
                        ex.printStackTrace();
                }
	}

        public Member getMemberDO(String username, String password) {
                Transaction tx = odmg.newTransaction();
                try {
                        // 1. open a transaction
                        tx.begin();
                        // 2. get an OQLQuery object from the ODMG
facade
                        OQLQuery query = odmg.newOQLQuery();
                        // 3. set the OQL select statement
                        String queryStr = "select members from " +
Member.class.getName();
                        queryStr += " where username = $1 adn password =
$2";
                        
                        
                        query.create(queryStr);
                        query.bind(username);
                        query.bind(password);
                        // 4. perform the query and store the result
                        // in a persistent Collection
                        DList members = (DList) query.execute();
                        member = (Member) members.get(0);
                        tx.commit();
                } catch (Throwable t) {
                        // rollback in case of errors
                        tx.abort();
                        t.printStackTrace();
                }
                return member;
        }
}




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]