Miscellaneous

Documentation / Web Edition / User Guide / Appendix / Miscellaneous
 

Database URL notation

In MyARM a database is normally configured using MyARM configuration properties. If a database configuration should be specified for example on the command line these properties does not work. For this purpose MyARM provides an URL like notation for each supported database type. The type of the database is defined by the scheme (or normally known as protocol prefix) of the URL. Currently the following MyARM database URL types are supported:

sqlite3:///<sqlite_db_file>
defines a SQLite database where <sqlite_db_file> is the file name of the sqlite database file. The name can be an absolute or a relative file name.
xml:///<xml_file>
defines a XML file where <xml_file> is the file name of the XML file. The name can be an absolute or a relative file name.
myarm:///<myarm_file>
defines a MyARM data file where <myarm_file> is the file name of the MyARM data file. The name can be an absolute or a relative file name (e.g. ../myapp.myarm or /opt/data/myapp.myarm).
mysql://<password>:<user>@<host>/<tranDB>/<appDB>/<defDB>
defines a MySQL database where <password> and <user> is the password and user name to log into the MySQL database. The <host> specifies the host name where the MySQL database is running on and the <tranDB>, <appDB> and <defDB> specifies the MyARM databases within the MySQL database server.
oracle://<password>:<user>@<server>/<SID>/<tablespace>
defines an Oracle database where <password> and <user> is the password and user name to log into the Oracle database server. The <server> specifies the host name where the Oracle database server is running on and the <SID> specifies the oracle system ID which should be used. <tablespace> defines the tablespace name to create or use.