0

I am unable to set up a WebLogic 11g data source to our SQL Server database. Can you please help diagnose the error

weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: [FMWGEN][SQLServer JDBC Driver][SQLServer]Login failed for user 'carynt\posapp'

The value carynt\posapp is the value I specify for the user. I have attempted various different "AuthenticationMethod" settings as prescribed in the docs.

My unit tests (from within the Eclipse IDE) run successfully. However those use integratedSecurity settings. Is it possible to somehow use similar settings for the WebLogic datasource?

Improve this question
2
  • Can you please provide the entire jdbc connection pool string ? Commented Jun 30, 2012 at 5:18
  • @yabmob Thanks for offering to help. However I have found a solution. See my post below. Commented Jun 30, 2012 at 20:11

1 Answer 1

Reset to default
1

Answering my own question...

We noticed an error in the WebLogic console logs about an unrelated class not being found. Our WebLogic administrator correctly diagnosed it as owing to the tweaked java.library.path (as suggested for using integratedSecurity).

We could not determine which of the myriad WebLogic's startup scripts was initializing the java.library.path value. Obviously my setting of this variable was clobbering the original value. By undoing my changes we noticed that the default java.library.path was the same as the Windows PATH system variable value. Therefore we

  1. Customized the java.library.path by tweaking the Windows PATH value in the startWebLogic.cmd file
  2. Removed userid and password settings in the WebLogic data source definition
  3. Added the integratedSecurity=true setting in the data source definition.
  4. Restarted the server

Paydirt!

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.