Announcement Announcement Module
Collapse
No announcement yet.
Urgent help required ......on DAOimpl Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Urgent help required ......on DAOimpl

    Hi Folks,

    I need urgent help on DAOimpl persistence in binding Sequences(oracle) to my
    parent table.

    Here is the code:

    addCompany(Company company){


    JdbcTemplate.update(insert into tb_Address(aid,houseNo,.......)Values(Address_seq. nextVal,?,?,?,)
    new Object[]{company.getAddress().getHouseNo().........});

    JdbcTemplate.update(insert into tb_Name(nid,title,.......)Values(Name_seq.nextVal, ?,?,?,)
    new Object[]{company.getName().getTitle().........});

    JdbcTemplate.update(insert into tb_Company(cid,aid,nid,.......)Values(Company_seq. nextVal,?,?,?,)
    new Object[]{company.getCompanyName().........});

    I can capture Address table table details as well as Name. When it comes to
    bind the tables together using sequences(Oracle) i get stuck....
    Could anybody help me on this as soon as you could since i am really stressed.


    Your help is greatly received.

    Regards,
    Vinny
Working...
X