Java to exchange info between databases

[ciglesias]

Hello,

I'm developing a program that connects to a mysql database and retrieves some queries. After this it has to enter this information into a postgresql database.

I know how to make the queries in the first place, but don't know the best way to store the information in the program and then make the inserts into the other database.

I suppose there is a standard way of doing this.

Thanks!

[doWhile]

If I understand what you are asking...query one database, get the data, depending upon the needs map the data to an object, then insert said data into a table in the other database. Trail: JDBC(TM) Database Access (The Java™ Tutorials)

[ciglesias]

That's exactly what i was talking about.

Going to look at that documentation.

Thank you!.