databasereferencecheatsheet
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| databasereferencecheatsheet [2025/04/21 16:21] – [SQL Server Express] amyw | databasereferencecheatsheet [2025/04/22 16:19] (current) – [SQLite] wikiadmin | ||
|---|---|---|---|
| Line 75: | Line 75: | ||
| SQLite is a file based database, so the format of the URL will not include the " | SQLite is a file based database, so the format of the URL will not include the " | ||
| - | get the latest JDBC driver: https://www.sqlite.org/download.html (the driver is included in the distribution, | + | get the latest JDBC driver |
| + | https://sourceforge.net/ | ||
| **Database Driver Class**: org.sqlite.JDBC | **Database Driver Class**: org.sqlite.JDBC | ||
| **Database URL**: < | **Database URL**: < | ||
| + | |||
| + | Example: jdbc: | ||
| + | |||
| + | This will create a file called testdb.sqlite in the directory where the application is running. When testing in MIStudio this will be the MIStudio main directory. If you are testing in TransSECS (Builder) this file will appear in the TransSECS/ | ||
| Note: usually add .sqlite to the file name for SQLite databases, so for example, db_name.sqlite | Note: usually add .sqlite to the file name for SQLite databases, so for example, db_name.sqlite | ||
databasereferencecheatsheet.1745266912.txt.gz · Last modified: by amyw