Hi Adriano
I just tried your application code with a tomcat application connecting
to MySQL and didn't have any problems... I was using latest DAS from
trunk... and after applyChanges i can see the new row on the MySQL table...
Also, DAS builds runs some junit testcases around applyChanges and you
might take a look if it's building ok in your environment...
Let me know if you find anything else, or have more info so I can
help....
Thanks
--
Luciano Resende
http://people.apache.org/~lresende
On 11/19/06, Adriano Crestani <[EMAIL PROTECTED]> wrote:
I'm trying to run a test code, but I got a problem in the method void
newItem(String description, int units) using the mysql 5.1:
ShoppingCart.java
public class ShoppingCart {
public void newItem(String description, int units) {
DAS das = DAS.FACTORY.createDAS
(getClass().getClassLoader().getResourceAsStream("ShoppingCartConfig.xml
"),
getConnection());
Command command = das.getCommand("all items");
DataObject allItems = command.executeQuery();
DataObject newItem = allItems.createDataObject("ITEM");
newItem.setString("DESCR", description);
newItem.setInt("UNITS", units);
allItems.getList("ITEM").add(newItem);
das.applyChanges(allItems);
}
}
ShoppingCartConfig.xml
<?xml version="1.0" encoding="ASCII"?>
<Config xsi:noNamespaceSchemaLocation="
http:///org.apache.tuscany.das.rdb/config.xsd"; xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance";>
<Command name="all items" SQL="select * FROM ITEM" kind="Select"/>
</Config>
Table
CREATE TABLE ITEM (
ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
DESCR CHAR(30),
UNITS INTEGER
);
I used a debugger and found out that the das.applyChanges(allItems) - last
line of method void newItem(String description, int units) - is never
returning, may it be a DAS internal error?
