Class 1 newbie, AS/400 programmer learning Java(And I like java)
Does anyone have any examples of using 1 jdbc to build a result set(for example sql server) but write back the result set with another jdbc(for example DB2/400)
Or is there some other way of doing this. Im having to extract data from MSSQL to be processed on the 400.
Any reason not to do a table export (to comma separated value format) and then a table import on the new database?
If you need to do this with JDBC, you need to use two sets of connections/statements/resultsets so you can read a record/write a record (or batches of records) at the same time.
Ty, If you put it in a shell script, it's one step .
There's nothing special about Class.forName or DriverManager. You use the same code with a different driver class name. Then you get two connection, one each. Basically, you have all the JDBC code twice. Note that this solution is much more complicated than the command line export/import. It's also likely to be significantly less efficient.
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
.