simplest way to achieve this

HI all ,

I'm new to hibernate , i wanna to make a program with java using hibernate to read some data from specific table in db then do some processing on this data then insert it in another Db , what is the simplest design to achieve this ?
PS : this is a console based program ...

Are the database schemas the same across both DBs? Are the objects/mappings the same across both DBs? If everything is the same, and you're just copying, then you could use two different session factories on top of the same objects/mappings. That being said, you might find it easier to do this sort of copying using database utilities if both databases are the same.

If the schemas are different, then you'll need different objects/mappings. You'll still need two different session factories, one pointing to each set of objects/mapping.

Javid Jamae wrote:Are the database schemas the same across both DBs? Are the objects/mappings the same across both DBs? If everything is the same, and you're just copying, then you could use two different session factories on top of the same objects/mappings. That being said, you might find it easier to do this sort of copying using database utilities if both databases are the same.

If the schemas are different, then you'll need different objects/mappings. You'll still need two different session factories, one pointing to each set of objects/mapping.

ya the db schemas are the same . what Db utilities do you recommend to do this ?

All databases come with bulk loading tools designed to move data from one schema to another, possibly performing some processing along the way. These tend to be capable of using database features not available to a normal JDBC applciation to speed up performance and also don't require the configuring of a third party product such as Hibernate. Check your database documentation for the topic "bulk loading" or "import/export".