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


Win a copy of Spring in Action this week in the Spring forum!
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: 3610
    
  60

Welcome to the Ranch, Jeetu!

Please don't create more than one thread per question. Let the discussion continue in your other thread.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Create SQLServer datasources with jython script