Want to get the data in the B local database in A, write it into a local database, and the database type of B is Access. There are two probably:
1. Write a server program in B Write the data in Access into the MySQL database server, and then access this remote database server
2. Write an EJB in B to access the EJB by calling JNDI in A to communicate the corresponding operation
Development environment JBuilder JBoss mysql
I would like to ask the feasibility of the two methods and the advantages and disadvantages of these two methods, thank you!