Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
    Bookmark Topic Watch Topic
  • New Topic

Create SQLServer datasources with jython script

 
jeetu panwar
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
 
jeetu panwar
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Report post to moderator
jeetu panwar wrote: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
.I am following link to generate command http://www.ibm.com/developerworks/websphere/library/techarticles/0812_rhodes/0812_rhodes.html
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Report post to moderator
Welcome to the Ranch, Jeetu!

Please don't create more than one thread per question. Let the discussion continue in your other thread.
 
    Bookmark Topic Watch Topic
  • New Topic