simple OQL where syntax

[Neil Blue]

Hello,

I have now got OJB up and running with the ODMG interface, from within
JBoss.

Now I am starting to look into OQL, but I have a few questions after reading
an OQL doc and trying it out on ODJ

1) when I try using a table name alias like:

select * from com.novobase.jaxbjdo.Minimol m where m.name='MyName#2'

I get the error:

unexpected token: m

2) when I try without:

select * from com.novobase.jaxbjdo.Minimol where name='MyName#2'

I get the error:

ClassCastException: java.lang.Character

3) when I try:

select * from com.novobase.jaxbjdo.Minimol where name="MyName#2"

I get the error:

Invalid column name (this is an oracle error)

4) If i try bind:

select * from com.novobase.jaxbjdo.Minimol where name=?

then use:
query.bind("MyName#2");

I get the error:

unexpected char: ?

here is an extract from my repository.xml file

         <class-descriptor
          class="com.novobase.jaxbjdo.Minimol"
          table="minimol">
          
      <field-descriptor id="1"
         name="id"
         column="ID"
         jdbc-type="INTEGER"
         primarykey="true"
         autoincrement="true"/>
          
      <field-descriptor id="2"
         name="name"
         column="NAME"
         jdbc-type="VARCHAR"/>
...       
   </class-descriptor>


What format should I use for such a simple OQL query?

Thanks
Neil






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