OpenNTF.org - XPages Extension Library
XPages Extension LibraryOpenDocument[/Projects/pmt.nsf/ProjectView?ReadForm&Query=]

My Links (Not logged in)
User Name Password
Hosted by Prominic.NET

   Project: XPages Extension Library (Managed by Philippe Riand, Niklas Heidloff, Dave Delay, Akihiro Kosugi, Maire Kehoe, Tony McGuckin, John Piermarini, Martin Donnelly, James Quill, Darin Egan, Padraic Edwards, Andrejus Chaliapinas, Lorcan McDonald, Simon McLoughlin, Paul Hannan)
Actions:


Subject
 Changing XPagesJDBC demo from Derby to MS SQL
Categories
 
Posted by
 Jack Wilson on 09/04/2011 at 01:58 PM
Details

What would be the best practice to convert the XPagesJDBC demo (2011-08-30 release) which uses Derby to another db backend (say MS SQL)? The "XPages Goes Relational" slide presentation "Highly Recommends" creating an OSGi plugin--should we expect that OSGi plugins for the major DBMS drivers would be available in 8.5.3 gold?

What I'm after is the functionality of the demo database hitting MS SQL instead of Derby. Maybe someone has already written an OSGi plugin for the MS SQL sqljdbc4.jar driver?

Thanks...jack

Modification history
Entered 04-Sep-2011 13:58 by Jack Wilson. Last Modified <none> by Niklas Heidloff.
Feedback

Hide details for  (Jack Wilson on 09/04/2011 01:58:20 PM ) (Jack Wilson on 09/04/2011 01:58:20 PM )
Hide details for Could you provide Oracle drive... (Marcis Berzinsk... on 10/12/2011 07:28:15 AM )Could you provide Oracle drive... (Marcis Berzinsk... on 10/12/2011 07:28:15 AM )
Hide details for Oracle plugin already availible ?  (Markus W on 02/21/2012 02:45:58 AM )Oracle plugin already availible ? (Markus W on 02/21/2012 02:45:58 AM )
Hide details for You'll need to prepare that plugin (Andrejus Chalia... on 02/22/2012 02:54:53 AM )You'll need to prepare that plugin (Andrejus Chalia... on 02/22/2012 02:54:53 AM )
Hide details for Okay can we solve this ? (Markus W on 02/23/2012 02:32:07 AM )Okay can we solve this ? (Markus W on 02/23/2012 02:32:07 AM )
Hide details for See sceleton attached (Andrejus Chalia... on 02/23/2012 03:12:09 AM )See sceleton attached (Andrejus Chalia... on 02/23/2012 03:12:09 AM )
Hide details for problem occured: oracle.jdbc.d... (Markus W on 02/24/2012 09:33:42 AM )problem occured: oracle.jdbc.d... (Markus W on 02/24/2012 09:33:42 AM )
Hide details for It's safe to remove then (Andrejus Chalia... on 02/24/2012 10:12:39 AM )It's safe to remove then (Andrejus Chalia... on 02/24/2012 10:12:39 AM )
Hide details for Description - Its works (Markus W on 03/01/2012 01:51:28 AM )Description - Its works (Markus W on 03/01/2012 01:51:28 AM )
In general - you would need fe... (Andrejus Chalia... on 03/01/2012 02:37:10 AM )
Hide details for . . Sample MSSQL plugin (Andrejus Chalia... on 09/06/2011 08:09:08 AM ). . Sample MSSQL plugin (Andrejus Chalia... on 09/06/2011 08:09:08 AM )
Hide details for re: Sample MSSQL plugin (Jack Wilson on 09/06/2011 11:27:44 AM )re: Sample MSSQL plugin (Jack Wilson on 09/06/2011 11:27:44 AM )
Hide details for Works fine on server too (Jack Wilson on 09/06/2011 04:29:52 PM )Works fine on server too (Jack Wilson on 09/06/2011 04:29:52 PM )
Hide details for Good (Andrejus Chalia... on 09/07/2011 03:33:54 AM ),please report about all bugs found (Andrejus Chalia... onGood (Andrejus Chalia... on 09/07/2011 03:33:54 AM ),please report about all bugs found (Andrejus Chalia... on 09/07/2011 03:33:54 AM )
Hide details for Got a bug for you.. (Johan k Carlsso... on 09/19/2011 02:42:51 AM )Got a bug for you.. (Johan k Carlsso... on 09/19/2011 02:42:51 AM )
Hide details for Those classes belong to a plugin (Andrejus Chalia... on 09/19/2011 03:34:10 AM )Those classes belong to a plugin (Andrejus Chalia... on 09/19/2011 03:34:10 AM )
Hide details for Problem solved.. questions.. (Johan k Carlsso... on 09/19/2011 07:35:05 AM )Problem solved.. questions.. (Johan k Carlsso... on 09/19/2011 07:35:05 AM )
Hide details for update (Johan k Carlsso... on 09/19/2011 09:51:59 AM ),questions (Johan k Carlsso... on 09/19/2011 09:51:59 AMupdate (Johan k Carlsso... on 09/19/2011 09:51:59 AM ),questions (Johan k Carlsso... on 09/19/2011 09:51:59 AM )
Could you send more information? (Andrejus Chalia... on 09/19/2011 11:05:30 AM )
Hide details for Could we have a sample mySQL p... (Leif Lagebrand on 09/21/2011 02:52:07 AM )Could we have a sample mySQL p... (Leif Lagebrand on 09/21/2011 02:52:07 AM )
Hide details for . . Sample MySQL plugin (Andrejus Chalia... on 09/21/2011 03:12:27 PM ). . Sample MySQL plugin (Andrejus Chalia... on 09/21/2011 03:12:27 PM )
Hide details for mySQL works! (Leif Lagebrand on 09/23/2011 12:52:15 PM )mySQL works! (Leif Lagebrand on 09/23/2011 12:52:15 PM )
In regards to mySQL version (Andrejus Chalia... on 09/25/2011 12:49:22 PM )
Hide details for OK (Leif Lagebrand on 09/23/2011 12:53:58 PM ),here's another one (Leif Lagebrand on 09/23/2011 12:53:58 PM ),OK (Leif Lagebrand on 09/23/2011 12:53:58 PM ),here's another one (Leif Lagebrand on 09/23/2011 12:53:58 PM ),plugin for DB2? (Leif Lagebrand on 09/23/2011 12:53:58 PM )
Hide details for . . Sample DB2 plugin (Andrejus Chalia... on 09/29/2011 03:58:31 PM ). . Sample DB2 plugin (Andrejus Chalia... on 09/29/2011 03:58:31 PM )
Hide details for DB2 Sample plugin (Martin Vereecke... on 04/20/2012 05:24:41 AM )DB2 Sample plugin (Martin Vereecke... on 04/20/2012 05:24:41 AM )
Hide details for db2/mssql/mysql updates sites ... (Jack Wilson on 04/21/2012 09:12:01 AM )db2/mssql/mysql updates sites ... (Jack Wilson on 04/21/2012 09:12:01 AM )
dates reattached were 2012-04-21 (Jack Wilson on 04/21/2012 09:17:15 AM ),not 2012-04-12 <eom> (Jack Wilson on 04/21/2012 09:17:15 AM )
Hide details for We need to remove them (Andrejus Chalia... on 04/21/2012 12:29:55 PM )We need to remove them (Andrejus Chalia... on 04/21/2012 12:29:55 PM )
Oops--sorry (Jack Wilson on 04/22/2012 06:58:05 AM )
Hide details for How to install on Designer Client? (Steve Smillie on 09/28/2011 10:57:14 AM )How to install on Designer Client? (Steve Smillie on 09/28/2011 10:57:14 AM )
Hide details for You need to install ExtLib first (Andrejus Chalia... on 09/28/2011 03:38:33 PM )You need to install ExtLib first (Andrejus Chalia... on 09/28/2011 03:38:33 PM )
Hide details for Thanks (Steve Smillie on 09/29/2011 12:35:27 PM ),I do have the ext lib installed (Steve Smillie on 09/29/2011Thanks (Steve Smillie on 09/29/2011 12:35:27 PM ),I do have the ext lib installed (Steve Smillie on 09/29/2011 12:35:27 PM )
Hide details for You should see it then (Andrejus Chalia... on 09/29/2011 03:01:10 PM )You should see it then (Andrejus Chalia... on 09/29/2011 03:01:10 PM )
Hide details for I know the ext lib is installed (Steve Smillie on 09/30/2011 12:57:53 PM )I know the ext lib is installed (Steve Smillie on 09/30/2011 12:57:53 PM )
Hide details for Cannot see any plugins in Note... (Jack Wilson on 10/19/2011 06:14:03 PM )Cannot see any plugins in Note... (Jack Wilson on 10/19/2011 06:14:03 PM )
Hide details for . . Sample MS SQL driver update si... (Andrejus Chalia... on 10/20/2011 09:13:39 AM ). . Sample MS SQL driver update si... (Andrejus Chalia... on 10/20/2011 09:13:39 AM )
installed ok and confirmed it ... (Jack Wilson on 10/20/2011 11:22:08 AM )
Hide details for . . Sample DB2 driver update site (Andrejus Chalia... on 10/20/2011 04:51:27 AM ). . Sample DB2 driver update site (Andrejus Chalia... on 10/20/2011 04:51:27 AM )
update site zip worked for me ... (Jack Wilson on 10/20/2011 07:56:28 AM )
. . Sample mySQL driver update sit... (Andrejus Chalia... on 10/20/2011 03:29:10 PM )
Hide details for Can you please attach source f... (Nicolas Sacuta on 11/01/2011 07:42:13 AM )Can you please attach source f... (Nicolas Sacuta on 11/01/2011 07:42:13 AM )
Hide details for Source code is included inside... (Andrejus Chalia... on 11/03/2011 10:46:52 AM )Source code is included inside... (Andrejus Chalia... on 11/03/2011 10:46:52 AM )
Hide details for how to create the plug-in in g... (Sridevi Kumarav... on 07/05/2012 07:19:12 AM )how to create the plug-in in g... (Sridevi Kumarav... on 07/05/2012 07:19:12 AM )
Hide details for I used this link to create a p... (Jack Wilson on 07/06/2012 08:56:22 AM )I used this link to create a p... (Jack Wilson on 07/06/2012 08:56:22 AM )
derby connection fails (Sridevi Kumarav... on 07/09/2012 08:29:35 AM )
Hide details for . . Using jar file how to create a... (Sridevi Kumarav... on 07/09/2012 11:20:57 AM ). . Using jar file how to create a... (Sridevi Kumarav... on 07/09/2012 11:20:57 AM )
Hide details for Unable to post due to licensin... (Jack Wilson on 07/10/2012 07:38:20 AM )Unable to post due to licensin... (Jack Wilson on 07/10/2012 07:38:20 AM )
. . how to refer a column value in... (Sridevi Kumarav... on 07/12/2012 11:29:20 AM )
Hide details for How to attach MSSQL OSGI plugin (K Kapp on 01/20/2012 09:53:30 AM )How to attach MSSQL OSGI plugin (K Kapp on 01/20/2012 09:53:30 AM )
Some steps (Andrejus Chalia... on 01/20/2012 02:50:52 PM )
Check out other projects


Anonymous