Running OBA v2 without mySQL

[brodyFlannigan]

After unsuccessfully attempting to solve #254, I would like to deploy OBA v2 in order to be able to customize the interface and change some of the different aspects of it. According to the documentation, mySQL is used to store API keys. However, in my usage, the API feature would not be used. Is there a way to deploy v2 without MySQL? If so, how would I go about doing this?

Thanks ahead of time!

[barbeau]

@dudebrains01 It's been a while since I've set up an OBA server (going back to v1), but IIRC the relational database is used to cache transit data too, so it's not easy to run OBA without it (at least without modification). Here's a dated config wiki for databases for V1:
https://github.com/OneBusAway/onebusaway-application-modules/wiki/Database-Guide

Note that many different relational databases can be used, not just MySQL.

[sheldonabrown]

Let me redirect Sean's response a little bit. A database is certainly necessary, but it need to be mysql. It can easily be an in-memory version of hsql. That's just a matter of configuration in data-sources.xml.

[barbeau]

@sheldonabrown Thanks for the info! So in v2 can you still use Postgres, MS SQL Server, or another SQL-based database? As long as a JDBC driver exists for it?

[sheldonabrown]

V2 It hasn't been explicitly tested with it, but to my knowledge nothing has changed that would prevent this from happening.

I took a pass at running OBA out of the box on HSQL in the absence of a quick start. It looks like I didn't finish, but here is an example of how easy it is:

onebusaway-application-modules/onebusaway-enterprise-webapp/src/main/resources/data-sources.xml

Line 61 in 8691cb1

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

[brodyFlannigan]

I am currently running OBA v. 1.1.19 with the combined webapp without an external database, so it works.
However, I tried running a basic instance of V2 following the instructions outlined here but was having issues. If they are db related I will put them here or open another issue if not...