Hi
I have written (or am writing) a program to do the following.
Using a JDBC:ODBC bridge
1) Bring down data from three tables (t1,t2,t3)
from two different databases (db1,db2). the tables should contain the same data ie db1.t1=db2.t1
but t1 != t2 in data or format.
2) The data between db1 and db2 tables are compared. The differences are tabulated and presented on separate tabbed panes labled t1,t2,t3.
3) The tables are updatable.
I want the user to be able to update these tables as he views them
This all seems to work just great until I try to update.
I tried creating a different statement for each DB/Table combination. The first DB/Table combination is updated.
Everything after that fails. I've read that the ODBC:JDBC bridge does not support multiple statements on one connection. Could this be my trouble? If so, why does this not manifest until I try and update. (All data is presented and tabulated without incident. I have try:catch artound everything)
I tried to then use ONE statement but as soon as you get another recordset the previous rs is closed.
Is there any way to do what I;d like? Will a different driver work? Any thoughts would be appreciated.
thanks a lot
I have written (or am writing) a program to do the following.
Using a JDBC:ODBC bridge
1) Bring down data from three tables (t1,t2,t3)
from two different databases (db1,db2). the tables should contain the same data ie db1.t1=db2.t1
but t1 != t2 in data or format.
2) The data between db1 and db2 tables are compared. The differences are tabulated and presented on separate tabbed panes labled t1,t2,t3.
3) The tables are updatable.
I want the user to be able to update these tables as he views them
This all seems to work just great until I try to update.
I tried creating a different statement for each DB/Table combination. The first DB/Table combination is updated.
Everything after that fails. I've read that the ODBC:JDBC bridge does not support multiple statements on one connection. Could this be my trouble? If so, why does this not manifest until I try and update. (All data is presented and tabulated without incident. I have try:catch artound everything)
I tried to then use ONE statement but as soon as you get another recordset the previous rs is closed.
Is there any way to do what I;d like? Will a different driver work? Any thoughts would be appreciated.
thanks a lot