I am new to OBJ too. Where did you find OQL reference? I could not find
anything other than the tutorial2. I even bought the ODMG book. Instead
of using select *, I used "select del" as in tutorial2. I could not even
found any reference of del in the ODMG book. Another thing I did was turn
on the logger to info level so that I can see the SQL statement generated.
Hope this helps. Please let me know where to find OQL reference.
Thank you,
Jane
Neil Blue
<Neil.Blue@denovop To: "'[EMAIL PROTECTED]'"
harma.com> <[EMAIL PROTECTED]>
cc:
11/18/2002 08:48 Subject: simple OQL where syntax
AM
Please respond to
"OJB Users List"
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]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
