aspose file tools*
The moose likes Websphere and the fly likes Create SQLServer datasources with jython script Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Reply locked New topic
Author

Create SQLServer datasources with jython script

jeetu panwar
Greenhorn

Joined: Oct 22, 2013
Posts: 9
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

Joined: Oct 22, 2013
Posts: 9
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

Joined: Aug 22, 2010
Posts: 3611
    
  60

Welcome to the Ranch, Jeetu!

Please don't create more than one thread per question. Let the discussion continue in your other thread.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Create SQLServer datasources with jython script