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)
whitersxAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

geekprogCommented:
one of the object in your code is being assigned NULL

rama_krishna580Commented:
Hi,

it seems like some thing wrong at line number >>>> psdi.server.AppService.freeDBConnection(AppService.java:431)

i.e AppService.java:431

Some checking is being done at this level which is causing Nullpointer.

R.K
Siva Prasanna KumarPrincipal Solutions ArchitectCommented:
Just put forward AppService.java file or check line number : 431. Som object you are trying to process is null.
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tommy BraasCommented:
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.
whitersxAuthor Commented:
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 BraasCommented:
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?
whitersxAuthor Commented:
The writing process takes several minutes, I am unsure if there is a timeout value defined, I will investigate.
Tommy BraasCommented:
The default timeout on Oracle is usually less than a minute.
Tommy BraasCommented:
That means that the connection  will time out, and the connection pool is probably going to release it and null out the reference.
whitersxAuthor Commented:
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?
Tommy BraasCommented:
>> Is it possible there is a restriction on the amount of connections on the SQL server?
Certainly there would be.

The question is what the JDBC driver connection timeout is set to.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mayank SAssociate Director - Product EngineeringCommented:
>> ServiceCoordinator.java:304

What does this line have?
whitersxAuthor Commented:
>> ServiceCoordinator.java:304

that file is not available, i assume because the application is compiled.
Mayank SAssociate Director - Product EngineeringCommented:
Is it not your class?
whitersxAuthor Commented:
everyone gets points, we decided to use a different web server and no longer receive the error. thanks!
Tommy BraasCommented:
;-D
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java

From novice to tech pro — start learning today.