MariaDB and JDBC implementation
Description:
JDBC //java solution to connect app with server https://docs.oracle.com/javase/tutorial/jdbc/basics/connecting.html
mariaDB // type of database hosted on stargate server https://mariadb.com/kb/en/about-mariadb-connector-j/
in app/build.gradle
implementation 'mysql:mysql-connector-java:5.1.49'
Connection connection = DriverManager.getConnection "jdbc:mysql://stargate.ncc.edu/GuestRegistry?user=guestAdmin&password=******************"
to do:
- Implement the connection object in the apps GuestRegistrySource and GuestRegistryHelper classes. these are the primary work-horse classes that we will need to use our db instructions on/with.
License and Copyright Notice
By submitting this issue or commenting on this issue, or contributing any content to this issue, you certify under the Developer Certificate of Origin that the content you post may be licensed under GPLv3 (for code) or CC-BY-SA 4.0 International (for non-code content).
Summary
Guest registration migration to remote db. Connect to MariaDB on Stargate server. Test queries using JDBC and Connection object.
Current Behavior
Registration record is added to the SQLite db on the device used for registration. Remote database and application are NOT communicating.
Benefits (Why is it necessary?)
Guest information accessible remotely.
Relevant Screenshots
Relevant Logs
connection failed using "jdbc:mariadb://local_ip_on_network.edu/GuestRegistry?user=guestAdmin&password=*************"