It's not a secret anymore!*
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 Murach's Java Servlets and JSP this week in the Servlets 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: 3606
    
  60

Welcome to the Ranch, Jeetu!

Please don't create more than one thread per question. Let the discussion continue in your other thread.
 
Don't get me started about those stupid light bulbs.
 
subject: Create SQLServer datasources with jython script
 
Similar Threads
SQL Server Connection problem
Create SQLServer datasources with jython script
Java 2 Connector authentication data entry settings with a jython script
Datasource Test Connection is successful but the application is not able to connect to the Database