• Anonymous
  • Login
  • Register



XPages Extension Library - Response: Sample MSSQL plugin

Created on Sep 6, 2011
Created by Andrejus Chaliapinas

    Hi Jack,
    Could you try this attached OSGI plugin, which actually wraps sqljdbc4.jar file with MS SQL JDBC driver and see if it works for you?

    Corresponding mssql_test.jdbc file could have such content:

    <jdbc>
     <driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver>
     <url>jdbc:sqlserver://testvm:1097;databaseName=pubs</url>
     <user>sa</user>
     <password>test</password>
    </jdbc>








    Documents
         
    Creation Date
    Author
    Subject
    Sep 4, 2011 Jack Wilson Changing XPagesJDBC demo from Derby to MS SQL
    Oct 12, 2011 Marcis Berzinskis     Response: Could you provide Oracle driver too
    Feb 21, 2012 Markus W         Response: Oracle plugin already availible ?
    Feb 22, 2012 Andrejus Chaliapinas             Response: You'll need to prepare that plugin
    Feb 23, 2012 Markus W                 Response: Okay can we solve this ?
    Feb 23, 2012 Andrejus Chaliapinas                     Response: See sceleton attached
    Feb 24, 2012 Markus W                         Response: problem occured: oracle.jdbc.diagnostics not found
    Feb 24, 2012 Andrejus Chaliapinas                             Response: It's safe to remove then
    Mar 1, 2012 Markus W                                 Response: Description - Its works
    Mar 1, 2012 Andrejus Chaliapinas                                     Response: In general - you would need few additional steps
    Sep 6, 2011 Andrejus Chaliapinas     Response: Sample MSSQL plugin
    Nov 1, 2011 Nicolas Sacuta         Response: Can you please attach source files and project of Sample MSSQL OSGi plugin?
    Nov 3, 2011 Andrejus Chaliapinas             Response: Source code is included inside sample jar file
    Jul 5, 2012 Sridevi Kumaravel                 Response: how to create the plug-in in general
    Jul 6, 2012 Jack Wilson                     Response: I used this link to create a plugin:
    Jul 9, 2012 Sridevi Kumaravel                         Response: derby connection fails
    Jul 9, 2012 Sridevi Kumaravel                         Response: Using jar file how to create a plugin
    Jul 10, 2012 Jack Wilson                             Response: Unable to post due to licensing issues
    Jul 12, 2012 Sridevi Kumaravel                                 Response: how to refer a column value in jdbc?
    Sep 21, 2011 Leif Lagebrand         Response: Could we have a sample mySQL plugin?
    Sep 21, 2011 Andrejus Chaliapinas             Response: Sample MySQL plugin
    Sep 23, 2011 Leif Lagebrand                 Response: mySQL works!
    Sep 25, 2011 Andrejus Chaliapinas                     Response: In regards to mySQL version
    Jan 20, 2012 K Kapp         Response: How to attach MSSQL OSGI plugin
    Jan 20, 2012 Andrejus Chaliapinas             Response: Some steps
    Sep 28, 2011 Steve Smillie         Response: How to install on Designer Client?
    Sep 28, 2011 Andrejus Chaliapinas             Response: You need to install ExtLib first
    Sep 29, 2011 Steve Smillie                 Response: Thanks,Response: I do have the ext lib installed
    Sep 29, 2011 Andrejus Chaliapinas                     Response: You should see it then
    Sep 30, 2011 Steve Smillie                         Response: I know the ext lib is installed
    Oct 19, 2011 Jack Wilson                             Response: Cannot see any plugins in Notes 8.5.3 Gold
    Oct 20, 2011 Andrejus Chaliapinas                                 Response: Sample DB2 driver update site
    Oct 20, 2011 Jack Wilson                                     Response: update site zip worked for me for db2
    Oct 20, 2011 Andrejus Chaliapinas                                 Response: Sample MS SQL driver update site
    Oct 20, 2011 Jack Wilson                                     Response: installed ok and confirmed it is hitting mssql--thanks!
    Oct 20, 2011 Andrejus Chaliapinas                                 Response: Sample mySQL driver update site
    Sep 23, 2011 Leif Lagebrand         Response: OK,Response: here's another one,Response: plugin for DB2?
    Sep 29, 2011 Andrejus Chaliapinas             Response: Sample DB2 plugin
    Apr 20, 2012 Martin Vereecken                 Response: DB2 Sample plugin
    Apr 21, 2012 Jack Wilson                     Response: db2/mssql/mysql updates sites reattachments
    Apr 21, 2012 Jack Wilson                         Response: dates reattached were 2012-04-21,Response: not 2012-04-12
    Apr 21, 2012 Andrejus Chaliapinas                         Response: We need to remove them
    Apr 22, 2012 Jack Wilson                             Response: Oops--sorry
    Sep 6, 2011 Jack Wilson         Response: re: Sample MSSQL plugin
    Sep 6, 2011 Jack Wilson             Response: Works fine on server too
    Sep 7, 2011 Andrejus Chaliapinas                 Response: Good,Response: please report about all bugs found
    Sep 19, 2011 Johan k Carlsson                     Response: Got a bug for you..
    Sep 19, 2011 Andrejus Chaliapinas                         Response: Those classes belong to a plugin
    Sep 19, 2011 Johan k Carlsson                             Response: Problem solved.. questions..
    Sep 19, 2011 Johan k Carlsson                                 Response: update,Response: questions
    Sep 19, 2011 Andrejus Chaliapinas                                     Response: Could you send more information?
         
    In this field you can enter the actual content.

    You can use the rich text editor for rich text formating. You can also enter HTML to embed objects, e.g. to embed a YouTube video or a screenshot of the project. In this case use '[' and ']' to mark the passthrough HTML as such.

    Please note that the first time you use the new UI your description is converted from rich text to MIME. You might want to copy and paste the raw plain text from the old UI in the new UI so that you don't loose information.