Ask Your Question

Revision history [back]

How make JDBC multitable origin fetch all the records of each table at once and in order?

Suppose I want to fetch records from table1,tabl2,table3. table1:

          name       id
          a              10
          b              20

table2:

         company    employee
            x                  xname
            y                  yname

table3:

            place           regionid
            xxx                  100
            yyy                  200

I used JDBC multitable orgin and specified these tables.Now i want to dump this data as:

    {name:a,id:10}
    {name:b,id:20}
    {company:x,employee:xname}
    {company:y,yname}
    {place:xxx,regionid:100}
    {place:yyy,regionid:200}

How make JDBC multitable origin fetch all the records of each table at once and in order?

Suppose I want to fetch records from table1,tabl2,table3. table1:

          name       id
          a              10
          b              20

table2:

         company    employee
            x                  xname
            y                  yname

table3:

            place           regionid
            xxx                  100
            yyy                  200

I used JDBC multitable orgin and specified these tables.Now i want to dump this data as:

    {name:a,id:10}
    {name:b,id:20}
    {company:x,employee:xname}
    {company:y,yname}
    {place:xxx,regionid:100}
    {place:yyy,regionid:200}

How make JDBC multitable origin fetch all the records of each table at once and in order?

Suppose I want to fetch records from table1,tabl2,table3. table1:

          name       id
          a              10
          b              20

table2:

         company    employee
            x                  xname
            y                  yname

table3:

            place           regionid
            xxx                  100
            yyy                  200

I used JDBC multitable orgin and specified these tables.Now i want to dump this data as:

    {name:a,id:10}
    {name:b,id:20}
    {company:x,employee:xname}
    {company:y,yname}
    {place:xxx,regionid:100}
    {place:yyy,regionid:200}

How to make JDBC multitable origin fetch all the records of each table at once and in order?

Suppose I want to fetch records from table1,tabl2,table3. table1:

          name       id
          a              10
          b              20

table2:

         company    employee
            x                  xname
            y                  yname

table3:

            place           regionid
            xxx                  100
            yyy                  200

I used JDBC multitable orgin and specified these tables.Now i ,I want to dump this data as:

    {name:a,id:10}
    {name:b,id:20}
    {company:x,employee:xname}
    {company:y,yname}
    {place:xxx,regionid:100}
    {place:yyy,regionid:200}

How to make JDBC multitable origin fetch all the records of each table at once and in order?

Suppose I want to fetch records from table1,tabl2,table3. table1:

          name       id
          a              10
          b              20

table2:

         company    employee
            x                  xname
            y                  yname

table3:

            place           regionid
            xxx                  100
            yyy                  200

I used JDBC multitable orgin and specified these tables.Now ,I want to dump this data as:

    {name:a,id:10}
    {name:b,id:20}
    {company:x,employee:xname}
    {company:y,yname}
    {place:xxx,regionid:100}
    {place:yyy,regionid:200}