WebRatio and MySQL

09 Dec '11, 09:18 PM
12,403 Views
No Forum Badges

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.

 
x 0
Follow
Answer Answer at this question and get points!
No Forum Badges

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:

  • inside WebRatio itself, Help > Web Modeling Tutorials > Add a Database describes the steps in detail for the Derby database;
  • this wiki article briefly mentions database configuration in the Synchronization paragraph.

How it is done

Every 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.

   
x 1
No Forum Badges

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.

OK, but where should I put the driver file (or files)? Do I have to rename it or leave the original name?

 
x 1
Answer at this question and get points!

Related questions

Access wsdl in https Can not get generate and run option for DataService Project Cannot invoke method selectSingleNode() on null object Can't generate and run database or start tomcat server! CelsiusToFahrenheit Example com.webratio.rtx.RTXException: An error occurred dispatching the SOAP message Could not create service Custom Unit and AJAX / SOAP Description: Unknown tag 'wr:LinkResource' Exception REST Post request Exposing SOAP Web SERVICE on port different from 80 Generation options problem Getting started with Web Services How can I invoke a Rest Web Service having dynamic parameters? How to change smtp port invoking a webservice using REST java.lang.NullPointerException No cloud accounts available No database on my cloud account Parameters order in a webservice request Problema generando la logica de un proyecto Problemas al invocar webservice Properties of the XSD Resource (File) Publish a web service publish web service for storing information in PostgreSQL DB following XSD Resource Sync DataService Project with Mobile Project usuarios y grupos WebRatio Mobile Platform Community edition - Restful request WebService DateTime value is not parsed to Date. Web service provider newline problem web service request using XSD Web service - Synchronize XSD When stars web ratio between dofollow and nofollow backlink has affected? When using web services, what kind authentication is used? which of these three models is closer to webratio/ifml way of creating web applications XML Out Unit and Soap Request Response Unit XML Schema Definition Support XML Schema Definition Support