problem with query from database

Hi,

I was experimenting with the program listed below.
I try to run a query from a M$ Access datasource.
I don't get error messages, nor a result. 
Any clue what to do?

<o:program xmlns:o="http://www.o-xml.org/lang/" xmlns:io="http://www.o-xml.org/lib/io/" xmlns:db="http://www.o-xml.com/db">
    <o:log msg="Begin."/>
    <db:connection>
        <db:url>jdbc:odbc:my_db_data_source</db:url>
        <db:driver>sun.jdbc.odbc.JdbcOdbcDriver</db:driver>
        <db:username>my_db</db:username>
        <db:password>my_db</db:password>
    </db:connection>
    <db:query name="getProducts">
        <db:sql>select Name  from Products</db:sql>
        <db:result>
            <product>
                <name>[name]</name>
            </product>
        </db:result>
    </db:query>
    <db:call query="getProducts"/>
    <o:log msg="End."/>
</o:program>

Result:
H:\experiments\oxml_db_query>java -jar objectbox-1.0.2.jar -e 
org.oXML.extras.db.DatabaseExtensions program.oml
Fri Aug 27 12:20:12 CEST 2004   info: Begin.
Fri Aug 27 12:20:12 CEST 2004   info: End.
<?xml version="1.0"?>
<ns1:connection 
xmlns:ns1="http://www.o-xml.com/db"><ns1:url>jdbc:odbc:my_db_data_source</ns1:url><ns1:driver>sun.jdbc.o
dbc.JdbcOdbcDriver</ns1:driver><ns1:username>my_db</ns1:username><ns1:password>my_db</ns1:password></ns1:connection><ns1
:query name="getProducts"><ns1:sql>select Name  from 
Products</ns1:sql><ns1:result><product><name>[name]</name></product
></ns1:result></ns1:query><ns1:call query="getProducts"/>





With kind regards,
          Mark 


++++++++++++++++++++++++++++++++++++++++
Ir. Mark Venbrux 
Multimedia Systems Software Group
Philips Digital Systems Laboratory - Eindhoven
Building SFJ 458 - B2, tel: +31 40 27 38378

_______________________________________________
o-xml mailing list
o-xml-zRfLyl9bSvv/[email protected]
http://lists.pingdynasty.com/mailman/listinfo/o-xml