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 2.0	Go to http://msdn.microsoft.com/en-us/data/aa937724.aspx and select Download SQL Server JDBC Driver 2.0.

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

   JDBC driver for:	Action
   Oracle	Place the JDBC driver, for example ojdbc14.jar, in: <SUP installation root>\Unwired_WorkSpace\Eclipse\sybase_workspace\mobile\eclipse\plugins\com.sybase.uep.com.oracle_1.5.2.<plugin version number>\lib
   DB2	Unzip the db2JdbcJars.zip file and copy the JAR files to: <SUP installation root>\Unwired_WorkSpace\Eclipse\sybase_workspace\mobile\eclipse\plugins\com.sybase.uep.com.db2_1.5.2.<plugin version number>\lib
   SQL Server JDBC driver 2.0	Copy sqljdbc4.jar to: <SUP installation root>\Unwired_WorkSpace\Eclipse\sybase_workspace\mobile\eclipse\plugins\com.sybase.uep.com.sqlserver_1.5.2.<plugin version number>\lib

4. Copy the appropriate JAR file to the specified Unwired Server location.

   JAR file for:	Action
   Oracle	Copy ojdbc14.jar to the server location: <SUP Installation root>\Servers\UnwiredServer\lib\3rdparty
   DB2	Copy the JAR files, for example db2jcc.jar and db2jcc_license_cu.jar, to the server location: <SUP Installation root>\Servers\UnwiredServer\lib\3rdparty
   SQL Server JDBC driver 2.0	Copy sqljdbc4.jar to the server location: <SUP Installation root>\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 Unwired WorkSpace and Unwired Platform Services.