I'm new to BlackBerry app development (and somewhat novice with Java, but I think I can manage it OK). I'm looking to write an app for our employees to use here. Our employees have BlackBerries connected to a BES. The idea is that the app would have connectivity through the BES (rather than out through the Internet) to the MSSQL server here, as the app will need to run some queries for them.
I'm not sure what the best approach to do this is. I have the BlackBerry Application Development/Eclipse environment set up and I've played around with some very basic "hello world" style apps, but I'd like to start playing with SQL queries. Is this done through JDBC, and if so, is there anything in particular that I have to do to install/enable it for use with BlackBerry development? I tried to import java.sql but the IDE says that it can't be resolved.
I tried to search for help with this but unfortunately most of the results I got back were dealing with the BES' MSSQL database itself, not app integration with MSSQL.