In introducing Websphere Liberty Profile (WLP), Dr. Ian Robinson, IBM Distinguished Engineer asks these three questions when choosing a tool for any kind of job:
The answers for WLP were all yes; and you should ask these same questions when choosing your JDBC driver for connectivity. Here are my answers after following the WLP tutorial and these apply to Websphere Application Server, as well as Tomcat or JBoss. Note: If you're looking for the Websphere Upgrade to SQL Server tutorial, check here.
The DataDirect SQL Server JDBC driver will get your job done without any road blocks thanks to:
We've heard from developers that they are 2x as productive with DataDirect; and can save many dev months with advanced features such as:
1 . Install Progress DataDirect SQL Server Connect for JDBC driver using the instructions in the Progress DataDirect Connect for JDBC installation Guide. You can download a free, 15-day trial of the Progress DataDirect SQL Server JDBC driver (including DB2, Oracle, Sybase, MySQL and Salesforce).
2. Install JTA support using DataDirect's patented sqljdbc.dll library that Websphere shops have been using for years for reliable transaction processing.
3. Follow tutorial for getting started with WAS Liberty Profile from IBM. Note: I used SQL Server Express 2012 and noted the exceptions for each module below to configure the DataDirect Connect for JDBC SQL Server driver.
4. Create table for ReportServer$SQLEXPRESS database in SQL Server instead of DB2 per module Module 1.2 : Create the database and Liberty server.
CREATE TABLE [dbo].[ACCOUNTS](
[C_NUM] [smallint] NOT NULL,
[C_NAME] [varchar](50) NULL,
[C_MONEY] [bigint] NOT NULL,
CONSTRAINT [PK_ACCOUNT] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
5. Configure DataDirect SQL Server JDBC driver instead of DB2 in, Module 2.2 : Configure the ser`ver for DB2
Base directory is the DataDirect JDBC installation folder. In this case, I installed to C:\jdbc\Connect_for_JDBC_51.
id is ddsqlserverconnection and JNDI name*: jdbc/SQLServerConnection
Database name is ReportServer$SQLEXPRESS; Server name is locahost\SQLEXPRESS nad URL is jdbc:datadirect:sqlserver://localhost\SQLEXPRESS;AuthenticationMethod=ntlm
6. After creating new JPA Entities from Tables and select Generic JDBC for DataDirect.
Enter URL as jdbc:datadirect:sqlserver://localhost\SQLEXPRESS;AuthenticationMethod=ntlm;DatabaseName=ReportServer$SQLEXPRESS
Note: If using Windows Authentication from Unix/Linux (for example AMERICAS\SUMITS), enter your Windows Authentication user "SUMITS" without the domain and password; and then add the following properties to your deployment profile to Linux, AIX, Solaris or HP-UX:
7. Modify DBInteractions.java with the the following line for SQL Server instead of DB2:
@Resource(name = "jdbc/SQLServerConnection", type = javax.sql.DataSource.class, shareable =
8. Run the index.html per Module 6.2 : Complete and test the JPA application with DB2
Finally, if you run into any issues, here is a link to generate WLP tracing.
I had a good time! Call us at N. America: (800)876-3101 | World: +44 (0) 1-344-386-367 to learn more about DataDirect SQL Server JDBC drivers for use in the world of Websphere.
Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others.
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.