|
Just a simple question: how can I use MySQL database in WebRatio project? There's really NO information about this in the WebRation Wiki or anywhere else. I'm using Linux version of WR Personal. Thanks in advance for help. |
|
HI! The procedure for configuring a database is the same for all types supported by WebRatio (which are a lot!). Although there is no article explaining this part in detail, there are information/examples around:
How it is doneEvery project containing persistent (DB stored) entities needs to contain at least one Database element specifying all the properties for connecting to a database, including its type. It is so commonplace that the Web Project creation wizard has a step for automatically creating one for you. Otherwise, you just need to right click the Data Model and choose Add Database. Once you have a Database, select it and use the Properties view to choose the DB type, the connection parameters, etc. For MySQL you can choose MySQL or, usually, MySQL (InnoDB). When you are done configuring the Database, right-click it and choose Synchronize. When doing this for the first time you will also have to provide the correct driver, which for MySQL you can download on MySQL site. The Synchronize operation will basically map all your entities and attributes to tables and run SQL statements to create them. |
OK, but where should I put the driver file (or files)? Do I have to rename it or leave the original name? If you run Synchronize without the driver, a message will be shown prompting you to select it. If you click the hyperlink on that message, a dialog will be shown which you can use to point to the JAR file of the driver. WebRatio will then take care of copying it to the correct location (usually the drivers subdirectory of the installation) and renaming it.
(09 Dec '11, 16:48)
LorenzoDV
Great, it works. Thanks a lot for help! :)
(10 Dec '11, 04:00)
dandys997
|