If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

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.

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.