FORUM PLAN UPDATE
Date revision: This forum will remain open to new posts and responses until December 1, 2018. (After that date, you will still be able to view and search the forum.) Also, we're taking a second look at the best place to host future conversation. For now, keep using this forum, and stay tuned for more news.



Sep 12, 2014, 9:40 AM
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.

Sep 12, 2014, 12:24 PM
589 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

Sep 15, 2014, 8:52 AM
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.

Sep 15, 2014, 10:04 AM
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.

Sep 15, 2014, 10:31 AM
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.

Sep 15, 2014, 11:53 AM
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.

Sep 15, 2014, 3: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?

 

Sep 15, 2014, 5: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.

 

Sep 16, 2014, 8:28 AM
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.

Sep 16, 2014, 9:42 AM
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.

Sep 17, 2014, 9:49 AM
9 Posts
Thanks

Ok, I will asking to DBA. 

Thanks a lot!

 

Sep 17, 2014, 1: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.


FORUM PLAN UPDATE
Date revision: This forum will remain open to new posts and responses until December 1, 2018. (After that date, you will still be able to view and search the forum.) Also, we're taking a second look at the best place to host future conversation. For now, keep using this forum, and stay tuned for more news.