[ https://issues.apache.org/jira/browse/TUSCANY-1929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kristina updated TUSCANY-1929: ------------------------------- Description: hi all, not sure if this is a bug or is just me... bottom line i need help :) when trying to generate the xml from dataobject , i get an empty one eventhough the dataobject is filled I am using: String generatedXml = XMLHelper.INSTANCE.save(root, "http://helloworld2", "MaterialListForTest"); where root is my dataobject what am i doing wrong? thanks, kristina was: hi all, not sure if this is a bug or is just me... bottom line i need help :) i am trying to use das to read data from an access mdb into an dataobject (sdo) DAS das = DAS.FACTORY.createDAS(con); String sql = "select * from [" + tablename+ "] ; Command readTableData = das.createCommand(sql); DataObject root = readTableData.executeQuery(); when trying to run the code above, i get Table WD Peripheral HD Controller in query does not include Primary Key column or has null value in it, can not proceed! same error if i set the pk using ConfigHelper.addprimarykey(pk) same error if the sql string contains all fields from the table, pk included ******************** error message ************************** java.lang.RuntimeException: Table WD Peripheral HD Controller in query does not include Primary Key column or has null value in it, can not proceed! at org.apache.tuscany.das.rdb.graphbuilder.impl.ResultSetProcessor.addRowToGraph(ResultSetProcessor.java:117) at org.apache.tuscany.das.rdb.graphbuilder.impl.ResultSetProcessor.processResultSet(ResultSetProcessor.java:91) at org.apache.tuscany.das.rdb.graphbuilder.impl.ResultSetProcessor.processResults(ResultSetProcessor.java:77) at org.apache.tuscany.das.rdb.impl.ReadCommandImpl.buildGraph(ReadCommandImpl.java:309) at org.apache.tuscany.das.rdb.impl.ReadCommandImpl.executeQuery(ReadCommandImpl.java:277) ******************* end error message ******************* if the sql string looks like this: String sql = "select " + pk + " from [" + tablename+ "] "; i get no error message but when trying to generate the xml from dataobject root, i get an empty one. String generatedXml = XMLHelper.INSTANCE.save(root, "http://helloworld2", "MaterialListForTest"); what am i doing wrong? thanks, kristina Summary: generate xml from dataobject (was: when query does not include only pk , java.lang.RuntimeException is returned) > generate xml from dataobject > ---------------------------- > > Key: TUSCANY-1929 > URL: https://issues.apache.org/jira/browse/TUSCANY-1929 > Project: Tuscany > Issue Type: Bug > Components: Java DAS RDB > Affects Versions: Java-DAS-M2 > Environment: java ee 1.5, eclipse 3.3.1.1. , windows xp, das 1.0 beta > 2, access mdb - no access installed, sca 1.0 > Reporter: Kristina > > hi all, > not sure if this is a bug or is just me... bottom line i need help :) > when trying to generate the xml from dataobject , i get an empty one > eventhough the dataobject is filled > I am using: String generatedXml = XMLHelper.INSTANCE.save(root, > "http://helloworld2", "MaterialListForTest"); where root is my dataobject > what am i doing wrong? > thanks, > kristina -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]