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?
 
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.
0
 
geekprogCommented:
one of the object in your code is being assigned NULL

0
 
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
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
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.
0
 
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.
0
 
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.
0
 
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?
0
 
whitersxAuthor Commented:
The writing process takes several minutes, I am unsure if there is a timeout value defined, I will investigate.
0
 
Tommy BraasCommented:
The default timeout on Oracle is usually less than a minute.
0
 
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.
0
 
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?
0
 
Mayank SAssociate Director - Product EngineeringCommented:
>> ServiceCoordinator.java:304

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

that file is not available, i assume because the application is compiled.
0
 
Mayank SAssociate Director - Product EngineeringCommented:
Is it not your class?
0
 
whitersxAuthor Commented:
everyone gets points, we decided to use a different web server and no longer receive the error. thanks!
0
 
Tommy BraasCommented:
;-D
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.