Notes/Domino XPages Development Forum - JDBC connection working on web but not in notes client

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

~Sigmund Umluzenjip

Apr 17, 2012, 10:17 AM

11 Posts

Resolved

JDBC connection working on web but not in notes client

Category: Server Side JavaScript
Platform: Windows
Release: 8.5.3
Role:
Tags:
Replies: 2

Hi. I'm new to XPages and have a question.

I managed to get a JDBC connection working with XPages partly.

I copied sqljdbc4.jar to /jvm/lib/ext folder. Restarted server.

It works fine in webbrowser, but not in notes client.

Can someone help me out ? Is there a need to install the JDBC driver on the notes client as well ? It's called via SS Javascript so ...

Thanks !

~Karl Kigerosterikle

Apr 17, 2012, 10:59 AM

122 Posts

Re: JDBC connection working on web but not in notes client

Yes, you need to install the driver on the Notes Client as well. For XPages in Notes Client, even Server-Side JavaScript runs on the local PC. The database may be on the server, but all your processing is local. It's the same concept with the Extension Library, where you need to install on the PC if you want to use it in XPages in Notes Client.

~Sigmund Umluzenjip

Apr 17, 2012, 11:07 AM

11 Posts

Re: JDBC connection working on web but not in notes client

Thanks you so much for the answer. There is so much info on the internet and in books, it's not easy to get started ...

Thanks !