Notes/Domino XPages Development Forum

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

~Emile Frolutexikle

Sep 12, 2014, 1:40 PM

9 Posts

JDBC problem

Category: Extension Library
Platform: Windows
Release: 8.5.3
Role: Developer
Tags: JDBC
Replies: 11

HI! I´m testing the access to RDBMS through extension library, but i´m not sucess. I installed the plugin and the extension library extended, but when I tested a xpage with combobox that the values are the relational table by the @JdbcDbColumn, the error below display. I´m testing in local in designer not a server.

Error while executing JavaScript computed expression
Script interpreter error, line=2, col=8: Error while executing function '@JdbcDbColumn'
comp/env/jdbc/db2

Best regards,

Marcus.

~Isaac Fezboosiakoi

Sep 12, 2014, 4:24 PM

586 Posts

Video

I'm not sure how relevant this is as I've not yet tried this myself, but I have a video on using JDBC from XPages that was done a good while ago from John Jardin. Maybe that will help

http://www.notesin9.com/2012/02/27/notesin9-047-intro-to-xpages-and-relational-data/

Note that in the latest version of the Ext. Library thats out for Domino 9.0.1 IBM moved the jdbc stuff from "experimental" to the main section of the Ext. Library I think. So if you're able to use that I would think there's been updates and buig fixes recently.

Good Luck!'

Dave

~Emile Frolutexikle

Sep 15, 2014, 12:52 PM

9 Posts

8.5.3 version

Hi David! I saw the video. This is great! But I using Lotus Notes 8.5.3 version wtih UP 1 and extended library components of relational databases connectivity of open NTF. Is JDBC only works in 9 version?

Thanks a lot!

Marcus.

~Cheryl Elhipigenlen

Sep 15, 2014, 2:04 PM

366 Posts

JDBC is not available until 9.0.1

The JDBC in the ExtLib for 8.5.3 is not really ready for prime time production. I would recommend using the native JDBC driver and Java code to read your RDBMS data.

~Emile Frolutexikle

Sep 15, 2014, 2:31 PM

9 Posts

Doubt

Ok Paul, but in version 8.5.3 with extended components of extension library of Open NTS doesn´t work? My intencion for a while it is only test.

~Cheryl Elhipigenlen

Sep 15, 2014, 3:53 PM

366 Posts

If the limitation is 8.5.3

then I would by pass the ExtLib all together and just write native Java code to access the RDBMS components.

If you just need to "read" RDMBS data you should also look at DECS and LEI.

~Dan Bubgerosteroni

Sep 15, 2014, 7:34 PM

6 Posts

DECS and LEI not an option for all

@Paul Calhoun: I am not a Java developer (yet) and DEC and LEI is not an option in my environment (zlinux). How good is the JDBC driver in 9.01?

~Cheryl Elhipigenlen

Sep 15, 2014, 9:41 PM

366 Posts

9.0.1 is better...

but still not ready for production in my opinion unless you are doing read only operation to display data.

As soon as you start to implement a CRUD model it starts to fall down pretty fast.

~Emile Frolutexikle

Sep 16, 2014, 12:28 PM

9 Posts

Connection document

The problem was the connection document was in wrong folder. Now it is in correct folder WebContent/WEB-INF/jdbc, but the error below was displayed in log:

09/15/2014 16:59:12 HTTP JVM: com.ibm.db2.jcc.c.SqlException: [ibm] [db2] [jcc] [10109] [10354] The version of the IBM Universal JDBC driver in use is not is licensed for connectivity to banks QDB2 data.

09/15/2014 16:59:12 HTTP JVM: To connect to this DB2 server, get a licensed version of IBM DB2 Universal Driver for JDBC and SQLJ copy.

09/15/2014 16:59:12 HTTP JVM:. An appropriate license file db2jcc_license _ * jar for this target platform must be installed in the classpath of the application.

09/15/2014 16:59:12 HTTP JVM: Connectivity banks QDB2 data is activated by one of the following license files: [db2jcc_license_cisuz.jar].

Where can I download the correct driver? The DB2 version is 9.1.7.755.822.

~Cheryl Elhipigenlen

Sep 16, 2014, 1:42 PM

366 Posts

Ask you DBA

you best bet is to get the drivers and license files from your DBA. If that is not an option then you can get them by downloading DB2.

~Emile Frolutexikle

Sep 17, 2014, 1:49 PM

9 Posts

Thanks

Ok, I will asking to DBA.

Thanks a lot!

~Emile Frolutexikle

Sep 17, 2014, 5:06 PM

9 Posts

Great! Works!

Great! Its working! I included the license file db2jcc_license_cisuz.jar in the jar Notes directory. The integration with DB2 works in values of a combobos, but when I try to use in a view panel the error "HTTP Web Server: Command Not Handled Exception" occurs. What´s wrong? I configured view panel following the instructions of NotesIn9 047 Intro to XPages and Relational Data.