WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  Create SQLServer datasources with jython script

    Posted 10/23/13 07:05 AM
    html_removed
    I am creating following thing using jython script
    1)Jdbc provide
    2)Data source
    3)J2C authentication data
    4) variables for sql server 2008
    but when i am testing the connectivity it give me following error "Login for user ''. ClientConnectionId:a433489c-e9be-4891-b584-c87b79004661 DSRA0010E: SQL State = S0001, Error Code = 18,456" [b].
    Solution of that which i found is that i have to open websphere console screen and in that i have to modify J2C authentication data(e.g if i just modify any value in Description section) and save the data & then if i datasource connectivity it works.So can any please tell me what i am missing in my jython script


  • 2.  Create SQLServer datasources with jython script

    Posted 10/25/13 04:21 PM
    Hi jsp_05,

      I suggest to create first J2C authentication data and then JDBC provider and Datasource.
     
      Save configuration in each step.
     
      Try and tell us.
     
    regards


  • 3.  Create SQLServer datasources with jython script

    Posted 11/06/13 02:36 AM
    html_removed
    HI,
    Thanks for reply yor are correct but there is problem in my script which i correct.