Topic
6 replies Latest Post - ‏2010-12-09T16:32:56Z by SystemAdmin
SystemAdmin
SystemAdmin
1479 Posts
ACCEPTED ANSWER

Pinned topic [IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications.

‏2004-10-06T15:21:06Z |
Hi everybody!

I just updated to Wdsc v 5.1.2 and I started playing with the JSF wizards.
When I try to run a page that has a Relational Record or a Relational Record List I get this darn error :

IBMSQLServer JDBC DriverThis driver is locked for use with embedded applications.

The help files warn about this error and advice to select the right helper file for the driver. ( MS-SQL SERVER + websphere Connect JDBC DRIVER)
BUT, there is no way to select that in the JSF wizard!!!
Any suggestions??

Thanks,

PS: The stored procedures dont show up either for the db connection. How can I can I see them too?
Updated on 2010-12-09T16:32:56Z at 2010-12-09T16:32:56Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1479 Posts
    ACCEPTED ANSWER

    Re: [IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications.

    ‏2004-10-28T13:46:55Z  in response to SystemAdmin
    This may or may not help you.

    If you use the WebSphere Embedded Connect JDBC driver for Microsoft SQL Server, you must use the proper DataStoreHelper class. If you use an incorrect DataStoreHelper class, either of the following exceptions might occur:

    java.sql.SQLException: IBMSQLServer JDBC DriverThis driver is locked for use with embedded applications.
    at com.ibm.websphere.jdbc.base.BaseExceptions.createException(Unknown Source)
    at com.ibm.websphere.jdbc.base.BaseExceptions.getException(Unknown Source)
    at com.ibm.websphere.jdbc.base.BaseConnection.validatedUnlocked(Unknown Source)

    java.sql.SQLException: IBMSQLServer JDBC Driver?}???h???C?o???A?????????A?v???P?[?V?????????g?p?????b?N???????E?B
    at com.ibm.websphere.jdbc.base.BaseExceptions.createException(Unknown Source)
    at com.ibm.websphere.jdbc.base.BaseExceptions.getException(Unknown Source)
    at com.ibm.websphere.jdbc.base.BaseConnection.validatedUnlocked(Unknown Source)

    The correct DataStoreHelper class for the WebSphere Embedded Connect JDBC driver for Microsoft SQL Server and WebSphere Embedded Connect JDBC driver for Microsoft SQL Server (XA) providers is com.ibm.websphere.rsadapter.WSConnectJDBCDataStoreHelper.

    Try using this JDBC driver and see if that helps.

    Amy
    • SystemAdmin
      SystemAdmin
      1479 Posts
      ACCEPTED ANSWER

      Re: [IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications.

      ‏2004-11-05T14:53:48Z  in response to SystemAdmin

      Thanks for the reply.
      The problem is that there is not place in the JSF wizard where you can change the DataStoreHelper.
      Could it be changed manually in some xml file? If yes, which one ?

      m
      • SystemAdmin
        SystemAdmin
        1479 Posts
        ACCEPTED ANSWER

        Re: [IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications.

        ‏2004-11-09T16:41:01Z  in response to SystemAdmin
        The workaround suggested is only when connecting to the database using a datasource.

        On version 5.1.* when using the SQL Server, the default way of connecting to the database is not datasource but driver manager, and you cannot specify the datastore helper there.
        Try creating the datasource on the server, then create a resource ref in web.xml that maps to the data source, then configure the Record/List go to Runtime properties and change it to Datasource, provide the resource ref name.
        • SystemAdmin
          SystemAdmin
          1479 Posts
          ACCEPTED ANSWER

          Re: [IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications.

          ‏2005-02-09T17:29:46Z  in response to SystemAdmin
          I am using sql server 2000, websphere version 5.0
          websphere connect JDBC driver.
          In data perspective i am able to retrieve and send the data to the data perspective,but in a web perspective i created a jsp page
          (<db:driverManagerSpec id='Con1'
          driver="com.ibm.websphere.jdbc.sqlserver.SQLServerDriver"
          url="jdbc:ibm:sqlserver://localhost:1433;SelectMethod=cursor;DatabaseName=samp"
          userid="adh" password="adh"/>)

          trying to link data to a form i get the following error:

          IBMSQLServer JDBC DriverThis driver is locked for use
          with embedded applications.

          about a datasource helper file,
          com.ibm.websphere.rsadapter.WSConnectJDBCDataStoreHelper
          where do I get this and what do i do with it??
          I am new to websphere pl. advise.
          Thanks,
          • SystemAdmin
            SystemAdmin
            1479 Posts
            ACCEPTED ANSWER

            Re: [IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications.

            ‏2005-10-17T07:08:04Z  in response to SystemAdmin
            hello there
            have you got the solution?
            where exactly shoud be this redefinition of class wrtiten
            and what else needs the man do to make it work
            thank for your reply
            ig
            • SystemAdmin
              SystemAdmin
              1479 Posts
              ACCEPTED ANSWER

              Re: [IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications.

              ‏2010-12-09T16:32:56Z  in response to SystemAdmin
              ***

              NOTICE:

              IT IS A VIOLATION OF THE LICENSE AGREEMENT TO USE THE DRIVER OUTSIDE OF IBM WEBSPHERE APPLICATION SERVER.

              THE ORIGINAL MESSAGE HAS BEEN REMOVED AND REPLACED WITH THIS NOTICE BY THE FORUM ADMINISTRATOR.

              ***

              Edited by: admin on Dec 9, 2010 9:05 AM

              Edited by: admin on Dec 9, 2010 11:32 AM
              Updated on 2010-12-09T16:32:56Z at 2010-12-09T16:32:56Z by SystemAdmin