Problems with JDBC and Referential Integrity


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Problems with JDBC and Referential Integrity

Hybrid View

  1. #1
    Claire Guest

    Problems with JDBC and Referential Integrity


    Wandering if anyone can advise me, I am a bit stuck. I have been working on
    a project using JDBC
    to connect to an access Database. This is all fine except when I enforce
    referential Integrity! It will
    not allow me to enter data into one table at a time as all the primary keys
    need to be updated at
    the same time. I thought that the Commit and Rollback methods would do the
    job but this is also
    sequential. Does anyone know how to get around this.

  2. #2
    alberto Guest

    Re: Problems with JDBC and Referential Integrity


    whe retreiving or updating remember to not use the

    select * from table1
    and when updating the fields update them as field1, field 2 etc..

    if you are updating in a batch pre-select the batch first.--ae

    "Claire" <rvzec_claire@yahoo.co.uk> wrote:
    >
    >Wandering if anyone can advise me, I am a bit stuck. I have been working

    on
    >a project using JDBC
    >to connect to an access Database. This is all fine except when I enforce
    >referential Integrity! It will
    >not allow me to enter data into one table at a time as all the primary keys
    >need to be updated at
    >the same time. I thought that the Commit and Rollback methods would do the
    >job but this is also
    >sequential. Does anyone know how to get around this.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center