Error while opening JDBC connection from Weblogic server 10.3.5

Salman5

I developed an ADF application in Jdeveloper11.1.1.7 and deployed it in Weblogic server 10.3.5. From Jdeveloper every thing working perfectly But from weblogic server I can see in the server stack the error (Error while opening JDBC connection, Caused by null password given; logon denied)  here is part of exception thrown

Exception inside -------.jbo.DMLException: JBO-26061: Error while opening JDBC connection.

oracle.jbo.DMLException: JBO-26061: Error while opening JDBC connection.

        at oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:207)

        at oracle.jbo.server.ConnectionPool.instantiateResource(ConnectionPool.java:166)

        at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:583)

        at oracle.jbo.pool.ResourcePool.useResource(ResourcePool.java:316)

        at oracle.jbo.server.ConnectionPool.getConnectionInternal(ConnectionPool.java:102)

        at oracle.jbo.server.ConnectionPool.getConnection(ConnectionPool.java:67)

        .......................................

        .......................................

        at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer$2.run(DeploymentReceiverCallbackDeliverer.java:69)

        at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)

        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)

        at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

Caused by: java.sql.SQLException: ORA-01005: null password given; logon denied

I did what is suggested in the following links:

My Learning's @ Work - by Lakshmipathi Kakarla: ORA-01005: null password given

Extending WebLogic Server for ADF Applications - RADalcove  Step 23

I added Djps.app.credential.overwrite.allowed=true to the JAVA_PROPERTIES and EXTRA_JAVA_PROPERTIES and restart the server bu the issue is not resolved. Any idea what goes wrong. Please note that the file (setDomainEnv) in the bin folder for the weblogic domain contains more that setting tot he previous variables, the  change I did is always rise in the first set of the variables

Arunkumar Ramamoorthy-Oracle

Can you try changing it to JDBC Data Source instead of JDBC URL and see if it works fine after that?

-Arun

User_Sep

Salman,

Please refer the link, and make sure that you followed the same.

How-To: ADF Deployment Guide

Regards.

Filip Huysmans

Hi,

In your application, you have under application resources - connections - database - a database connection definition.

Verify that you can open the connection in JDeveloper and see the objects in the schema and afterwards make sure you have checked the "Save Password" checkbox in the definition.

HTH

Filip

dvohra21

Refer similar post.

ORA-01005: null password given; logon denied

Salman5

I actually I did not setup the weblogic server and I can not confirm that all steps has been followed correctly. But, I can confirm the deployment way. I checked the application resources it is connecting to DB form Jdeveloper and I am sure it has the same name as the Data source in the Server.

One more thing here. there is some warring in the server stack :

<Warning> <oracle.adf.share.jndi.ReferenceStoreHelper> <BEA-000000> <Incomplete connection reference object for connection: [Data Source name goes here]>

Salman5

Already Checked it and the still not resolved as described in the question

Arunkumar Ramamoorthy-Oracle

Hi,

If you have access to the WLS console (http://hostname:port/console), check out the Data Source mentioned and see if the test configuration gives positive result.

-Arun

Salman5

Hi Arun,

Yes, I test the data source from weblogic console it is running ( Services -> DataSource -> select the data source -> Monitoring tab -> Testing Sub tab -> select the target server -> press Test Data Source button). I also tried to change the data source used to make sure that the problem is not caused by specific data source. Still facing the same issue.

Salman5

This is where I am inserting the Djps.app.credential.overwrite.allowed=true in the JAVA_PROPERTIES is this the right place?

Arunkumar Ramamoorthy-Oracle

Hi,

How about checking your AppModule configuration to see if you are using DS / JDBC URL? If it is URL, check out the connection to make sure if the password is blank?

-Arun

Salman5

Arunkumar Ramamoorthy wrote:

Hi,

How about checking your AppModule configuration to see if you are using DS / JDBC URL? If it is URL, check out the connection to make sure if the password is blank?

-Arun

Thanks for your response Arun,

I am using JDBC URL in application model configuration. What do you mean by ( check out the connection to make sure if the password is blank? ) I run the application model and it is working I also run the whole application and project working perfectly but not when deploying to weblogic server