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 ...
|
|
|
|