Crystalreports ERROR JRCCommunicationAdapter - detected an exception: java.lang.NullPointerException

The Crystal report displays this popped up the message first.

It then shows this popped up message.

In the console, it prints:

ERROR JRCCommunicationAdapter -  detected an exception: Unexpected database connector error
at com.crystaldecisions.reports.datafoundation.DFQuery.for(SourceFile:632)
at com.crystaldecisions.reports.datalayer.a.do(SourceFile:1621)

. . . . . .

Unexpected database connector error
ERROR JRCCommunicationAdapter -  detected an exception: java.lang.NullPointerException
at com.crystaldecisions.reports.dataengine.DataContext.try(SourceFile:734)
at com.crystaldecisions.reports.dataengine.DataProcessor2.u(SourceFile:1257)

. . . . . .

java.lang.NullPointerException

One of the causes of this error is that the SQL does not have all the tables needed in the FROM clause or the JOIN clauses. For example, the following situation will incur such an error.

The SQL of the reprot:

SELECT employee.name, sales.quantity
FROM employee
INNER JOIN sales on employee.id = sales.empid
where sales.quantity > 100 and {?whereClause}

The whereClause is set to:

product.name='Organic Avacado'

Since the product table is not present in the SQL FROM clause or the JOIN clause, it will throw the exceptions described above.


To fix the problem, change the SQL to:

SELECT employee.name, sales.quantity
FROM employee
INNER JOIN sales on employee.id = sales.empid
INNER JOIN product on sales.productid=product.id
where sales.quantity > 100 and {?whereClause}

-----------------------------------------------------------------------------------------------------------------

Watch the blessing and loving online channel: SupremeMasterTV live

If you have ever asked yourself these questions, this is the book for you. What is the meaning of life? Why do people suffer? What is in control of my life? Why is life the way it is? How can I stop suffering and be happy? How can I have a successful life? How can I have a life I like to have? How can I be the person I like to be? How can I be wiser and smarter? How can I have good and harmonious relations with others? Why do people meditate to achieve enlightenment? What is the true meaning of spiritual practice? Why all beings are one? Read the book for free here.