Database connection from weblogic

Question

Locally everything works fine, but on a remote Weblogic not really. The next code runs without any exception.

  try
    {
     ods = new OracleDataSource();
     connectionString = XmlReader.getConnectionString();
     ods.setURL(connectionString);
     }
    catch (SQLException ex)
    {
        ex.printStackTrace();
    }
    catch (Exception e) {
        e.printStackTrace();
    }

When i call getConnection() on the previous ods object, it doesnt raise any exception

 try
    {
        if (connection == null || connection.isClosed()) {
            connection = ods.getConnection();
        }
    }
    catch(Exception e) {
        e.printStackTrace();
    }

But finally the connection object is null for example after calling this

CallableStatement cstmt = connection.prepareCall( jobquery );

On a database it looks like the application created the connection, but then it doesnt call the procedure specified in "jobquery". What could be wrong?

Simply my question is: Is there a way to create an OracleDataSource without an exception, and then get a null from it?

Have you considered printing out the value of "connection" just after you obtain it, and again just before your connection.prepareCall(...) statement? This would help in seeing whether you get a real connection at all, and whether it is in place when you try to prepare the call. — Juha Laiho
– Juha Laiho, Commented Sep 20, 2012 at 14:08

Community · Accepted Answer · 2017-05-23 10:25:08Z

1

Nambaris answer will probably solve your immediate issue. Other points to consider:

On weblogic you really should be using built-in datasources and look those up by JNDI name
Are you sure it doesn't throw an exception, or are you just not seeing it due to printing it out on stderr? You should be using logging mechanism and exception propagation, not printing to outputs.

These are not directly related to your problem, just things you should be doing in the long run.

edited May 23, 2017 at 10:25

CommunityBot

11 silver badge

answered Sep 20, 2012 at 12:55

eis

53.7k14 gold badges159 silver badges206 bronze badges

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

2 Comments

user1660008 Over a year ago

sorry but Nambaris answer is not related to my problem, i call executeQuery in my code. 1. Thanks for your advise, i will try it 2. I have a logging mechanism this was only an example

user1660008 Over a year ago

i created a datasource on weblogic and it works now. Thanks for your answer

kosa · Accepted Answer · 2012-09-20 12:50:25Z

1

Unless you miss some code in original question, it seems you didn't perform execute().

Example:

callableStatement.executeQuery();

Read this CallableStatement tutorial

answered Sep 20, 2012 at 12:50

kosa

66.7k15 gold badges134 silver badges170 bronze badges

3 Comments

user1660008 Over a year ago

Its not important, because the connection object is null, and the program fails at conn.prepareCall()

kosa Over a year ago

Ok, You are getting connection = ods.getConnection(); but you are using conn.prepareCall. Change it to connection .prepareCall and see

user1660008 Over a year ago

In my program its correct, I made a mistake only in this example

Collectives™ on Stack Overflow

Database connection from weblogic

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related