Your focus should probably be on the APIs your DAS will provide the user
whether that is from a servlet or some other caller. Here are the Java
DAS apis from the simplest possible read in the test suite:
/**
* Read a specific customer
*/
public void testReadSingle() throws Exception {
// Create and initialize command to read customers
DAS das = DAS.FACTORY.createDAS(getConnection());
Command readCustomers = das.createCommand("select * from
CUSTOMER where ID = 1");
// Read
DataObject root = readCustomers.executeQuery();
// Verify
assertEquals(1, root.getInt("CUSTOMER[1]/ID"));
}
Notice that this example also does not allow parameterized queries. I
would make this simplifying assumption to get something up and running.
I cannot help with the C++ equivalent of JDBC Connection but I am sure
there is something similar available.
--
Kevin
Adriano Crestani wrote:
Good idea kelvin, but I'm begginer in servlet and I don't know what
would be
the best way for the user to provide the connection and sql. Though I
tried
this:
import java.io.IOException;
import java.sql.DriverManager;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest ;
import javax.servlet.http.HttpServletResponse;
import org.apache.tuscany.das.rdb.Command;
import org.apache.tuscany.das.rdb.DAS;
import commonj.sdo.DataObject;
public class CommandServlet extends HttpServlet {
private static final long serialVersionUID = 1922159305255311505L;
public CommandServlet() {}
protected void doGet(HttpServletRequest arg0, HttpServletResponse
arg1)
throws ServletException, IOException {
DataObject items = test(getConnection(), "SELECT id FROM item
WHERE
id = 1;");
System.out.println("id = " + items.getInt("ITEM[1]/ID"));
}
public DataObject test(java.sql.Connection conn, String readSql) {
DAS das = DAS.FACTORY.createDAS(conn);
Command command = das.createCommand();
DataObject allItems = command.executeQuery();
return allItems;
}
}
}
Adriano Crestani
On 2/8/07, Kevin Williams <[EMAIL PROTECTED]> wrote:
You could actually start significantly simpler by making the following
assumptions:
1. Read of a single table
2. User provides SQL programatically
3. User provides Connection programatically
With these restrictions you can get something useful working without the
classes required for config-file support.
--
Kevin
Adriano Crestani wrote:
> Luciano suggested to implement at first, the necessary classes to
> create a
> simple app that only reads from a database using the das c++. I was
> checking
> on the das java that these classes below are essential to create this
> app.
>
> DAS
> DASFactory
> DASImpl
> ConfigFactory
> ConfigFactoryImpl
> Config
> MappingWrapper
> config.Command
> ReadCommandImpl
> Command
> CommandImpl
> ConnectionInfo
>
>
> All these classes may be found in das java. I'm needing some
> volunteers to
> help implement these classes in c++. Actually, these classes are
> implemented, but are not compiling yet. So we need these classes
> compiling
> and implement a simple read app with these classes.
>
> Any suggestion will be appreciated.
>
> Adriano Crestani
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
