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



Feb 1, 2012, 2:17 PM
10 Posts

Setting up JDBC connection to Oracle in 8.5.3

  • Category: Extension Library
  • Platform: Windows
  • Release: 8.5.3
  • Role:
  • Tags: JDBC,Extension Library,Connection String
  • Replies: 7
 

I'm trying to get setup to use jdbc to access our oracle databases and can't seem to get it to work. 

 

I've put the ojdbc14.jar file in the IBM\Lotus\Domino\data\domino\workspace\applications\eclipse\plugins folder on our Development server and did a full reboot.

 

I created a JDBC Folder in package explorer in the WebContent Folder of my application and put in the following:

 

<jdbc>

<driver>oracle.jdbc.Driver.OracleDriver</driver>

<url>jdbc:oracle:thin://HostName:1600:SID</url>

<user>UserName</user>

<password>Password</password>

</jdbc>

 
Note: I did not use the actual hostname, sid username and password in this example.
 
 
 After I did this, I created a new XPage and dragged in a view then went to the Data section of All Properties and clicked the + button to add a  datasource and here is what I get:
 

xe:ObjectData
xp:DominoDocument
xp:DominoView

 

What am I doing wrong?

 

MJ

Feb 1, 2012, 3:15 PM
4 Posts
Re: Setting up JDBC connection to Oracle in 8.5.3
Hi,
    Just go to the application properties, and under XPage Libraries, check com.ibm.xsp.extlibx.com. Restart Domino Designer and you should be able to choose JDBCQuery as a datasource.
 
  
Feb 1, 2012, 5:51 PM
10 Posts
Re: Setting up JDBC connection to Oracle in 8.5.3
Hooray!!!!
 
That did it. 
 
Thanks,
 
MJ  
Jan 30, 2014, 4:06 PM
22 Posts
JDBC Datasource not available

Hi,

I'm using client 8.5.3. On the Advanced application property the lib com.ibm.xsp.extlibx.com is checked. I've restarted client but jdbc datasource doesn't appear !

 

 

 

Jan 30, 2014, 11:08 PM
298 Posts
You also have to install the plugins into the Notes client
I assume you are using this on another Notes client other than your dev. machine.  The plugins (Ext Lib and the JDBC driver) have to be installed on each Notes client.

Check out the widget catalog for a way to do this easily to all client computers.

Howard
Jan 31, 2014, 7:33 AM
22 Posts
Banging head

Ok, sorry my fault. There is a small difference in the com.ibm.xsp.extlibx.com and com.ibm.xsp.extlib.com libs.

And of course I didn't install the Openntf Lib, because our clients don't want to use it. It's not supported by IBM so don't use it.

I'm curious when a new upgrade pack will become available for Xpages.

Jan 31, 2014, 5:56 PM
298 Posts
*IBM has no plans at the moment to include the relational controls in Domino 9
Jan 31, 2014, 11:06 AM
9 Posts
details on extlibx

Reference: XPages Extension Library book: 

The second and latest plugin to the XPages Extension Library is ExtLibx. It contains all new controls and features and is an incubation phase for the latest library developments. The features from the ExtLibx may at some point become part of the core product like ExtLib.  


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