JDBC Plugin - Revision history

Ghenne at 16:09, 10 November 2020

2020-11-10T16:09:39Z

← Older revision		Revision as of 16:09, 10 November 2020
Line 1:		Line 1:
	This plugin allows you to execute simple queries against any database with a JDBC driver using Android. Due to the requirement of adding a driver JAR, you'll need to use [[~~PhoneGap CLI~~\|~~PhoneGap~~ CLI]] instead of ~~PhoneGap Build~~ . Since it is based on Java, it is Android only.		This plugin allows you to execute simple queries against any database with a JDBC driver using Android. Due to the requirement of adding a driver JAR, you'll need to use [[Cordova\|Cordova CLI]] instead of VoltBuilder. Since it is based on Java, it is Android only.

	The plugin provides a generic interface for using JDBC libraries with a ~~PhoneGap~~ plugin. The interface has a hook to a Java driver which does the actual work. [https://en.wikipedia.org/wiki/JDBC_driver JDBC drivers] are available for many databases.		The plugin provides a generic interface for using JDBC libraries with a Cordova plugin. The interface has a hook to a Java driver which does the actual work. [https://en.wikipedia.org/wiki/JDBC_driver JDBC drivers] are available for many databases.

	The main documentation and files for the plugin are here: https://github.com/arsmentis/cordova-plugin-jdbc. In this document, we will discuss how to use the plugin from AppStudio.		The main documentation and files for the plugin are here: https://github.com/arsmentis/cordova-plugin-jdbc. In this document, we will discuss how to use the plugin from AppStudio.

	Begin by making sure the ~~PhoneGap~~ CLI toolchain is installed properly. Documentation for installing it is in the Install Tools section are [[~~PhoneGap CLI~~\|here]].		Begin by making sure the Corodova CLI toolchain is installed properly. Documentation for installing it is in the Install Tools section are [[Cordova\|here]].

	=== Creating your AppStudio Project ===		=== Creating your AppStudio Project ===
Line 18:		Line 18:
	</pre>		</pre>

	2. Go into Preferences/~~PhoneGap~~ and set 'Build Command' to <code>cordova build</code>		2. Go into Preferences/VoltBuilder and set 'Build Command' to <code>cordova build</code>

	3. Save your project.		3. Save your project.

	4. From the run menu, choose Make Native App with ~~PhoneGap~~ CLI.		4. From the run menu, choose Make Native App with Cordova CLI.

	=== ~~PhoneGap~~ ===		=== Cordova ===

	AppStudio should now have created a ~~phonegap~~ folder in your project directory. This will contain all the build files for ~~PhoneGap~~ CLI. Each time you choose Make Native App with ~~PhoneGap~~ CLI, these files will be updated with the latest version of your code.		AppStudio should now have created a cordova folder in your project directory. This will contain all the build files for Cordova CLI. Each time you choose Make Native App with Cordova CLI, these files will be updated with the latest version of your code.

	1. If you get a message in the Build window which says <code>No platforms added to this project</code>, open up a cmd window in the ~~phonegap~~ folder and add Android as a platform:		1. If you get a message in the Build window which says <code>No platforms added to this project</code>, open up a cmd window in the cordova folder and add Android as a platform:
	<pre>		<pre>
	cordova platform add android		cordova platform add android
	</pre>		</pre>

	2. Add the plugin: From a command window in your ~~phonegap~~ folder, enter		2. Add the plugin: From a command window in your cordova folder, enter
	<pre>		<pre>
	cordova plugin add cordova-plugin-jdbc		cordova plugin add cordova-plugin-jdbc
	</pre>		</pre>

	3. Repeat Make Native App with ~~PhoneGap~~ CLI.		3. Repeat Make Native App with Cordova CLI.

	4. Add the following folders to the ~~phonegap~~ directory.		4. Add the following folders to the cordova directory.

	* spash: your splash screens.		* spash: your splash screens.
Line 64:		Line 64:
	</pre>		</pre>

	5. To check if the ~~PhoneGap~~ toolchain is OK, by using the requirements command:		5. To check if the Cordova toolchain is OK, by using the requirements command:
	<pre>		<pre>
	> cordova requirements		> cordova requirements
Line 74:		Line 74:
	</pre>		</pre>

	6. If the build is successful, the apk file will be in <code>~~phonegap~~/platforms/android/build/outputs/apk</code>		6. If the build is successful, the apk file will be in <code>cordova/platforms/android/build/outputs/apk</code>

	== Example ==		== Example ==

Ghenne at 16:14, 24 July 2019

2019-07-24T16:14:13Z

@@ Line 76: / Line 76: @@
 . If the build is successful, the apk file will be in <code>phonegap/platforms/android/build/outputs/apk</code>
-=== Example (BASIC) ===
+== Example ==
-=== Example (JavaScript) ===
+<tabber>
-<pre>
+ JavaScript=
 Button1.onclick = function() {
      jdbc.load("com.ibm.jtopenlite.database.jdbc.JDBCDriver", loadSuccess, loadFail);
@@ Line 104: / Line 92: @@
      console.log("fail", data);
+}
-</pre>
+</syntaxhighlight>
 === Security ===

Ghenne at 22:26, 1 November 2016

2016-11-01T22:26:30Z

← Older revision		Revision as of 22:26, 1 November 2016
Line 1:		Line 1:
	This plugin allows you to execute simple queries against any database with a JDBC driver using Android. Due to the requirement of adding a driver JAR, ~~it's not compatible with PhoneGap Build. You~~'ll need to use [[PhoneGap CLI\|PhoneGap CLI]] . Since it is based on Java, it is Android only.		This plugin allows you to execute simple queries against any database with a JDBC driver using Android. Due to the requirement of adding a driver JAR, you'll need to use [[PhoneGap CLI\|PhoneGap CLI]] instead of PhoneGap Build . Since it is based on Java, it is Android only.

	The plugin provides a generic interface for using JDBC libraries with a PhoneGap plugin. The interface has a hook to a Java driver which does the actual work. [https://en.wikipedia.org/wiki/JDBC_driver JDBC drivers] are available for many databases.		The plugin provides a generic interface for using JDBC libraries with a PhoneGap plugin. The interface has a hook to a Java driver which does the actual work. [https://en.wikipedia.org/wiki/JDBC_driver JDBC drivers] are available for many databases.

Ghenne at 13:14, 14 June 2016

2016-06-14T13:14:57Z

← Older revision		Revision as of 13:14, 14 June 2016
Line 1:		Line 1:
	This plugin allows you to execute simple queries against any database with a JDBC driver using Android. Due to the requirement of adding a driver JAR, it's not compatible with ~~automated build services (like~~ PhoneGap Build). You'll need to use [[PhoneGap CLI\|PhoneGap CLI]]		This plugin allows you to execute simple queries against any database with a JDBC driver using Android. Due to the requirement of adding a driver JAR, it's not compatible with PhoneGap Build. You'll need to use [[PhoneGap CLI\|PhoneGap CLI]] . Since it is based on Java, it is Android only.

	The plugin provides a generic interface for using JDBC libraries with a PhoneGap plugin. The interface has a hook to a Java driver which does the actual work. [https://en.wikipedia.org/wiki/JDBC_driver JDBC drivers] are available for many databases.		The plugin provides a generic interface for using JDBC libraries with a PhoneGap plugin. The interface has a hook to a Java driver which does the actual work. [https://en.wikipedia.org/wiki/JDBC_driver JDBC drivers] are available for many databases.

Ghenne: /* Example (JavaScript) */

2016-06-14T13:05:32Z

Example (JavaScript)

← Older revision		Revision as of 13:05, 14 June 2016
Line 94:		Line 94:
	<pre>		<pre>
	Button1.onclick = function() {		Button1.onclick = function() {
	jdbc.load("com.ibm.~~as400~~.~~access~~.~~AS400JDBCDriver~~", loadSuccess, loadFail);		jdbc.load("com.ibm.jtopenlite.database.jdbc.JDBCDriver", loadSuccess, loadFail);
	};		};

Ghenne: /* Example (BASIC) */

2016-06-14T13:05:13Z

Example (BASIC)

← Older revision		Revision as of 13:05, 14 June 2016
Line 79:		Line 79:
	<pre>		<pre>
	Function Button1_onclick()		Function Button1_onclick()
	jdbc.load("com.ibm.~~as400~~.~~access~~.~~AS400JDBCDriver~~", loadSuccess, loadFail)		jdbc.load("com.ibm.jtopenlite.database.jdbc.JDBCDriver", loadSuccess, loadFail)
	End Function		End Function

Ghenne: /* PhoneGap */

2016-06-13T18:15:14Z

PhoneGap

← Older revision		Revision as of 18:15, 13 June 2016
Line 33:		Line 33:
	</pre>		</pre>

	2. Add the plugin ~~to PhoneGap~~: From a command window in your phonegap folder, enter		2. Add the plugin: From a command window in your phonegap folder, enter
	<pre>		<pre>
	cordova plugin add cordova-plugin-jdbc		cordova plugin add cordova-plugin-jdbc

Ghenne: /* PhoneGap */

2016-06-13T15:19:05Z

PhoneGap

← Older revision		Revision as of 15:19, 13 June 2016
Line 33:		Line 33:
	</pre>		</pre>

	Repeat Make Native App with PhoneGap CLI.		2. Add the plugin to PhoneGap: From a command window in your phonegap folder, enter
			<pre>
			cordova plugin add cordova-plugin-jdbc
			</pre>

			3. Repeat Make Native App with PhoneGap CLI.

	2. Add the following folders to the phonegap directory.		4. Add the following folders to the phonegap directory.

	* spash: your splash screens.		* spash: your splash screens.
Line 59:		Line 64:
	</pre>		</pre>

	3. To check if the PhoneGap toolchain is OK, by using the requirements command:		5. To check if the PhoneGap toolchain is OK, by using the requirements command:
	<pre>		<pre>
	> cordova requirements		> cordova requirements
Line 69:		Line 74:
	</pre>		</pre>

	3. If the build is successful, the apk file will be in <code>phonegap/platforms/android/build/outputs/apk</code>		6. If the build is successful, the apk file will be in <code>phonegap/platforms/android/build/outputs/apk</code>

	=== Example (BASIC) ===		=== Example (BASIC) ===

Ghenne: /* PhoneGap */

2016-06-09T17:26:37Z

PhoneGap

← Older revision		Revision as of 17:26, 9 June 2016
Line 69:		Line 69:
	</pre>		</pre>

	3. If the build is successful, the apk file will be in phonegap/platforms/android/build/outputs/apk.		3. If the build is successful, the apk file will be in <code>phonegap/platforms/android/build/outputs/apk</code>

	=== Example (BASIC) ===		=== Example (BASIC) ===

Ghenne: /* PhoneGap */

2016-06-09T17:25:59Z

PhoneGap

← Older revision		Revision as of 17:25, 9 June 2016
Line 28:		Line 28:
	AppStudio should now have created a phonegap folder in your project directory. This will contain all the build files for PhoneGap CLI. Each time you choose Make Native App with PhoneGap CLI, these files will be updated with the latest version of your code.		AppStudio should now have created a phonegap folder in your project directory. This will contain all the build files for PhoneGap CLI. Each time you choose Make Native App with PhoneGap CLI, these files will be updated with the latest version of your code.

	1. If you get a message in the Build window which says <code>No platforms added to this project<code>, open up a cmd window in the phonegap folder and add Android as a platform:		1. If you get a message in the Build window which says <code>No platforms added to this project</code>, open up a cmd window in the phonegap folder and add Android as a platform:
	<pre>		<pre>
	cordova platform add android		cordova platform add android