Anyway, it simplified a lot the ap ; )
On 2/8/07, Adriano Crestani <[EMAIL PROTECTED]> wrote:
Thanks a lot kevin ; ). But I think it look likes the first code I posted,
except by the assert you added.
Adriano Crestani
On 2/8/07, Kevin Williams <[EMAIL PROTECTED]> wrote:
>
> 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]
>
>
