I have tried to go through all the files that have the old sql instance name and change that but no working application. I just do not know how to make the apache tomcat/java web server application communicate with the database. TO 'USERNAME''' identified by 'PASSWORD' After modifying the MySQL grant tables, execute. I have restored the databases to the new sql instance. Create a test table to be replicated, in the default database test: mysql> use test. TO 'USERNAME''' If your stack ships an older version of MySQL: mysql> grant all privileges on DATABASENAME. Server two: Tomcat 4.1.30 MySQL 4.1.17 (IP address 192.168.1.93). Include the content of your persistence.xml, context.xml (remove the passwords) and specially the stacktrace produced, you can find the trace in the Console tab of OpenXava Studio. If your stack ships MySQL v8.x: mysql> create user 'USERNAME''' identified by 'PASSWORD' mysql> grant all privileges on DATABASENAME. If it still fails ask us in the OpenXava Help forum. You must create a database for Onyx in MySQL, and you must also set up a. Also verify that the user has rights to create databases and tables (if you want to use the automatic schema generation of OpenXava, not needed if the tables already exist). On most default Tomcat installations, the memory allocated to the service is. If it fails, verify that your database server is up, that the user and password in context.xml are correct, that the server IP is correct. Run your application, it should work nicely against your MySQL database. You can run mvn war:exploded from OpenXava Studio with Run As > Maven build. Optimization note: Instead of a mvn install, that do a complete Maven build, you can use mvn war:exploded, enough to apply the above changes for development. Or if you have Maven installed in your computer and you prefer to use command line: $ cd myapp In OpenXava Studio click with right mouse button on your project an choose Run As > Maven install, thus: After the changes you have to rebuild your project.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |