asked on

java.lang.NullPointerException

Can someone give me some idea of what this exception is, it seems to be causing our web app to break...

java.lang.NullPointerException
at psdi.server.AppService.freeDBConnection(AppService.java:431)
at psdi.mbo.MboSet.getUserWhere(MboSet.java:956)
at psdi.mbo.MboSet.buildWhere(MboSet.java:5940)
at psdi.mbo.MboSet.buildWhere(MboSet.java:5915)
at psdi.mbo.MboSet.buildSelectStatement(MboSet.java:1538)
at psdi.mbo.MboSet.getNextRowData(MboSet.java:1723)
at psdi.mbo.MboSet.fetchMbos(MboSet.java:1613)
at psdi.mbo.MboSet.getMbo(MboSet.java:1363)
at psdi.mbo.MboSet.isEmpty(MboSet.java:2907)
at psdi.security.SecurityService.authenticateUser(SecurityService.java:280)
at psdi.security.SecurityService.authenticateUser(SecurityService.java:180)
at psdi.server.MXServer.getSystemUserInfo(MXServer.java:1376)
at psdi.app.inventory.ReorderService.init(ReorderService.java:2038)
at psdi.server.ServiceCoordinator$ServiceStartThread.run(ServiceCoordinator.java:304)

SOLUTION

geekprog

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

rama_krishna580

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Siva Prasanna Kumar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Tommy Braas

Assuming that you don't have access to the source code, and that no code has changed, it seems to me that a connection to the db was never established in your case. Look through log files or the cause of the problem.

If you do have acces to the code, I would suggest verifying that a connection to a db has been established before you try to free it.

whitersx

ASKER

I can confirm the connection to the db via the dsn as well as the application pulling fields in other components, we are just experiencing this error in one module that requires a lot of writing the database.

Tommy Braas

Are you using a connection pool?

How long does the processing for the write take? Is the timeout value for the connection above the processing time?

whitersx

ASKER

The writing process takes several minutes, I am unsure if there is a timeout value defined, I will investigate.

Tommy Braas

The default timeout on Oracle is usually less than a minute.

Tommy Braas

That means that the connection will time out, and the connection pool is probably going to release it and null out the reference.

whitersx

ASKER

The database is SQL, here are the connection pool properties.

// Number of database connections needed to be kept open as soon as MXServer
// is started. Default value is 15.
mxe.db.initialConnections=15
// Maximum number of free database connections available in the connection
// pool. Default value is 30.
mxe.db.maxFreeConnections=30
// Minimum number of free database connections available in the connection
// pool for more connections to be allocated. Default value is 10.
mxe.db.minFreeConnections=10
// Number of new connections to be created when the minimum number of free connections
// are available in the connection pool. Default value is 5.
mxe.db.newConnectionCount=5

Is it possible there is a restriction on the amount of connections on the SQL server?

ASKER CERTIFIED SOLUTION

Tommy Braas

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION