logo       
Google Custom Search
    AddThis Social Bookmark Button

problem with query from database: msg#00006

Subject: 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/LJnD5RR8eeqUGfbH9hYC@xxxxxxxxxxxxxxxx
http://lists.pingdynasty.com/mailman/listinfo/o-xml

Try Searching:
servers, voip, java, networking, microsoft ...
<Prev in Thread] Current Thread [Next in Thread>