Configuring Your Environment to Use a JDBC Driver

Download the appropriate JDBC driver and configure your environment to connect to Oracle, DB2, and Microsoft SQL Server 2005 and 2008 databases.

1. Download the driver.

   JDBC driver for:	URL
   Oracle	http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
   DB2	http://www-306.ibm.com/software/data/db2/express/download.html
   SQL Server JDBC driver 4.0	Go to http://msdn.microsoft.com/en-us/data/aa937724.aspx and select Download the Microsoft JDBC Driver 4.0 for SQL Server.

2. Shut down SAP Mobile WorkSpace and SAP Mobile Platform Services.
3. For SAP Mobile WorkSpace, put the driver in the correct location.

   JDBC driver for:	Action
   Oracle	Place the JDBC driver, for example ojdbc14.jar, in: SMP_HOME\MobileSDK<Version>\MobileWorkSpace\mobile\eclipse\plugins\com.sybase.uep.com.oracle_<version>.<plugin version number>\lib
   DB2	Unzip the db2JdbcJars.zip file and copy the JAR files to: SMP_HOME\MobileSDK<Version>\MobileWorkSpace\mobile\eclipse\plugins\com.sybase.uep.com.db2_<version>.<plugin version number>\lib
   SQL Server JDBC driver 3.0	Copy sqljdbc4.jar to: SMP_HOME\MobileSDK<Version>\MobileWorkSpace\mobile\eclipse\plugins\com.sybase.uep.com.sqlserver_<version>.<plugin version number>\lib

4. Copy the appropriate JAR file to the specified SAP Mobile Server location.

   JAR file for:	Action
   Oracle	Copy ojdbc14.jar to the server location: SMP_HOME \Servers\UnwiredServer\lib\3rdparty
   DB2	Copy the JAR files, for example db2jcc.jar and db2jcc_license_cu.jar, to the server location: SMP_HOME \Servers\UnwiredServer\lib\3rdparty
   SQL Server JDBC driver 3.0	Copy sqljdbc4.jar to the server location: SMP_HOME \Servers\UnwiredServer\lib\3rdparty

   Note: If you do not copy the JAR files to the server location, you will encounter runtime errors due to the missing JDBC driver.
5. Restart SAP Mobile WorkSpace and SAP Mobile Platform Services.