# "\_source" is being sent as false. when .where(f -\> f.matchAll()).fetchAll(); gets executed

**URL:** <https://discourse.hibernate.org/t/source-is-being-sent-as-false-when-where-f-f-matchall-fetchall-gets-executed/4837>\
**Category:** Hibernate Search\
**Created:** [December 3, 2020, 7:42am UTC](https://discourse.hibernate.org/t/source-is-being-sent-as-false-when-where-f-f-matchall-fetchall-gets-executed/4837 "2020-12-03T07:42:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![schoppara](https://avatars.discourse-cdn.com/v4/letter/s/3be4f8/32.png) [@schoppara](https://discourse.hibernate.org/u/schoppara)\
**Post date:** [December 3, 2020, 7:42am UTC](https://discourse.hibernate.org/t/source-is-being-sent-as-false-when-where-f-f-matchall-fetchall-gets-executed/4837/1 "2020-12-03T07:42:10Z")

</div>

Hello,

I have two questions. Kindly answer

Question 1)  
When the following line gets executed  
SearchResult activeEventResultSet = searchSession.search(DbActiveLearns.class)  
.where(f → f.matchAll()).fetchAll();

The request is sent is  
2020-11-24 09:30:17.335 TRACE 6216 — [port thread - 2] o.h.search.elasticsearch.request : HSEARCH400093: Executed Elasticsearch HTTP POST request to path ‘/learnings-read/\_search’ with query parameters {size=10000, track\_total\_hits=true} and 1 objects in payload in 27ms. Response had status 200 ‘OK’. Request body: \<  
{  
“query”: {  
“match\_all”: POST  
},  
“\_source”: false  
}

Where \_source is set to false. Due to which the response does not have any sources in hits.

> . Response body: \<  
> {  
> “took”: 20,  
> “timed\_out”: false,  
> “\_shards”: {  
> “total”: 1,  
> “successful”: 1,  
> “skipped”: 0,  
> “failed”: 0  
> },  
> “hits”: {  
> “total”: {  
> “value”: 1,  
> “relation”: “eq”  
> },  
> “max\_score”: 1.0,  
> “hits”: [  
> {  
> “\_index”: “learnings”,  
> “\_type”: “\_doc”,  
> “\_id”: “XxZB0nUBmfRN3DNwXCtc”,  
> “\_score”: 1.0  
> }  
> ]  
> }  
> }

How to make send request without setting \_source to false.

Question 2)  
If I have inserted documents ti index through kibana using this  
POST /learnings/\_doc  
{  
…  
}

then \_id is set to some random string “Nim9HHYB9AI0nENFUPob” and i am seeing a Number format exception when the following line is executed.

SearchResult activeEventResultSet = searchSession.search(DbActiveLearns.class)  
.where(f → f.matchAll()).fetchAll();

Response: 200 ‘OK’ with body  
{  
“took”: 0,  
“timed\_out”: false,  
“\_shards”: {  
“total”: 1,  
“successful”: 1,  
“skipped”: 0,  
“failed”: 0  
},  
“hits”: {  
“total”: {  
“value”: 1,  
“relation”: “eq”  
},  
“max\_score”: 1.0,  
“hits”: [  
{  
“\_index”: “learnings”,  
“\_type”: “\_doc”,  
“\_id”: “Nim9HHYB9AI0nENFUPob”,  
“\_score”: 1.0  
}  
]  
}  
}  
] with root cause

java.lang.NumberFormatException: For input string: “Nim9HHYB9AI0nENFUPob”  
at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) ~[na:na]  
at java.base/java.lang.Long.parseLong(Long.java:692) ~[na:na]  
at java.base/java.lang.Long.parseLong(Long.java:817) ~[na:na]  
at org.hibernate.search.mapper.pojo.bridge.builtin.impl.DefaultLongIdentifierBridge.fromDocumentIdentifier(DefaultLongIdentifierBridge.java:23) ~[hibernate-search-mapper-pojo-base-6.0.0.Beta8.jar:6.0.0.Beta8]  
at org.hibernate.search.mapper.pojo.bridge.builtin.impl.DefaultLongIdentifierBridge.fromDocumentIdentifier(DefaultLongIdentifierBridge.java:13) ~[hibernate-search-mapper-pojo-base-6.0.0.Beta8.jar:6.0.0.Beta8]  
at org.hibernate.search.mapper.pojo.bridge.runtime.impl.PropertyIdentifierMapping.fromDocumentIdentifier(PropertyIdentifierMapping.java:70) ~[hibernate-search-mapper-pojo-base-6.0.0.Beta8.jar:6.0.0.Beta8]  
at org.hibernate.search.mapper.orm.session.impl.HibernateOrmSearchSession.fromDocumentReference(HibernateOrmSearchSession.java:226) ~[hibernate-search-mapper-orm-6.0.0.Beta8.jar:6.0.0.Beta8]  
at org.hibernate.search.mapper.orm.session.impl.HibernateOrmSearchSession.fromDocumentReference(HibernateOrmSearchSession.java:58) ~[hibernate-search-mapper-orm-6.0.0.Beta8.jar:6.0.0.Beta8]  
at org.hibernate.search.engine.search.loading.spi.DefaultProjectionHitMapper.planLoading(DefaultProjectionHitMapper.java:36) ~[hibernate-search-engine-6.0.0.Beta8.jar:6.0.0.Beta8]  
at org.hibernate.search.backend.elasticsearch.search.projection.impl.ElasticsearchEntityProjection.extract(ElasticsearchEntityProjection.java:34) ~[hibernate-search-backend-elasticsearch-6.0.0.Beta8.jar:6.0.0.Beta8]  
at org.hibernate.search.backend.elasticsearch.search.query.impl.Elasticsearch7SearchResultExtractor.extractHits(Elasticsearch7SearchResultExtractor.java:104) ~[hibernate-search-backend-elasticsearch-6.0.0.Beta8.jar:6.0.0.Beta8]  
at org.hibernate.search.backend.elasticsearch.search.query.impl.Elasticsearch7SearchResultExtractor.extract(Elasticsearch7SearchResultExtractor.java:71) ~[hibernate-search-backend-elasticsearch-6.0.0.Beta8.jar:6.0.0.Beta8]  
at org.hibernate.search.backend.elasticsearch.search.query.impl.Elasticsearch7SearchResultExtractor.extract(Elasticsearch7SearchResultExtractor.java:28) ~[hibernate-search-backend-elasticsearch-6.0.0.Beta8.jar:6.0.0.Beta8]  
at org.hibernate.search.backend.elasticsearch.work.impl.SearchWork.generateResult(SearchWork.java:51) ~[hibernate-search-backend-elasticsearch-6.0.0.Beta8.jar:6.0.0.Beta8]  
at org.hibernate.search.backend.elasticsearch.work.impl.AbstractNonBulkableWork.handleResult(AbstractNonBulkableWork.java:82) ~[hibernate-search-backend-elasticsearch-6.0.0.Beta8.jar:6.0.0.Beta8]  
at org.hibernate.search.backend.elasticsearch.work.impl.AbstractNonBulkableWork.lambda$execute$3(AbstractNonBulkableWork.java:67) ~[hibernate-search-backend-elasticsearch-6.0.0.Beta8.jar:6.0.0.Beta8]  
at java.base/java.util.concurrent.CompletableFuture$UniApply.tryFire(CompletableFuture.java:642) ~[na:na]  
at java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506) ~[na:na]  
at java.base/java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:2073) ~[na:na]  
at org.hibernate.search.backend.elasticsearch.client.impl.ElasticsearchClientImpl$1.onSuccess(ElasticsearchClientImpl.java:114) ~[hibernate-search-backend-elasticsearch-6.0.0.Beta8.jar:6.0.0.Beta8]  
at org.elasticsearch.client.RestClient$FailureTrackingResponseListener.onSuccess(RestClient.java:590) ~[elasticsearch-rest-client-7.6.2.jar:7.6.2]  
at org.elasticsearch.client.RestClient$1.completed(RestClient.java:333) ~[elasticsearch-rest-client-7.6.2.jar:7.6.2]  
at org.elasticsearch.client.RestClient$1.completed(RestClient.java:327) ~[elasticsearch-rest-client-7.6.2.jar:7.6.2]  
at org.apache.http.concurrent.BasicFuture.completed(BasicFuture.java:122) ~[httpcore-4.4.13.jar:4.4.13]  
at org.apache.http.impl.nio.client.DefaultClientExchangeHandlerImpl.responseCompleted(DefaultClientExchangeHandlerImpl.java:181) ~[httpasyncclient-4.1.4.jar:4.1.4]  
at org.apache.http.nio.protocol.HttpAsyncRequestExecutor.processResponse(HttpAsyncRequestExecutor.java:448) ~[httpcore-nio-4.4.13.jar:4.4.13]  
at org.apache.http.nio.protocol.HttpAsyncRequestExecutor.inputReady(HttpAsyncRequestExecutor.java:338) ~[httpcore-nio-4.4.13.jar:4.4.13]  
at org.apache.http.impl.nio.DefaultNHttpClientConnection.consumeInput(DefaultNHttpClientConnection.java:265) ~[httpcore-nio-4.4.13.jar:4.4.13]  
at org.apache.http.impl.nio.client.InternalIODispatch.onInputReady(InternalIODispatch.java:81) ~[httpasyncclient-4.1.4.jar:4.1.4]  
at org.apache.http.impl.nio.client.InternalIODispatch.onInputReady(InternalIODispatch.java:39) ~[httpasyncclient-4.1.4.jar:4.1.4]  
at org.apache.http.impl.nio.reactor.AbstractIODispatch.inputReady(AbstractIODispatch.java:114) ~[httpcore-nio-4.4.13.jar:4.4.13]  
at org.apache.http.impl.nio.reactor.BaseIOReactor.readable(BaseIOReactor.java:162) ~[httpcore-nio-4.4.13.jar:4.4.13]  
at org.apache.http.impl.nio.reactor.AbstractIOReactor.processEvent(AbstractIOReactor.java:337) ~[httpcore-nio-4.4.13.jar:4.4.13]  
at org.apache.http.impl.nio.reactor.AbstractIOReactor.processEvents(AbstractIOReactor.java:315) ~[httpcore-nio-4.4.13.jar:4.4.13]  
at org.apache.http.impl.nio.reactor.AbstractIOReactor.execute(AbstractIOReactor.java:276) ~[httpcore-nio-4.4.13.jar:4.4.13]  
at org.apache.http.impl.nio.reactor.BaseIOReactor.execute(BaseIOReactor.java:104) ~[httpcore-nio-4.4.13.jar:4.4.13]  
at org.apache.http.impl.nio.reactor.AbstractMultiworkerIOReactor$Worker.run(AbstractMultiworkerIOReactor.java:591) ~[httpcore-nio-4.4.13.jar:4.4.13]  
at java.base/java.lang.Thread.run(Thread.java:834) ~[na:na]

Instead if the document is inserted with the following command, we are getting a different response.

POST /learnings/\_doc/1

then \_id is set as  
“\_index” : “fm\_active\_events”,  
“\_type” : “\_doc”,  
**“\_id” : “1”,**  
“\_score” : 1.0,

And we get a different error when the following line is executed  
SearchResult activeEventResultSet = searchSession.search(DbActiveLearns.class)  
.where(f → f.matchAll()).fetchAll();

The annotations on the Entity class are as follows.  
@Entity  
//@Document(indexName=“fm.active\_events”)  
@Indexed (index=“learnings”)  
@Table(name = “learnings”)  
@Component

The tablename is in small letters but the query passed is having the table name as “LEARNINGS”

What naming strategy needs to be used for this.

Error is:

2020-12-03 12:48:08.758 TRACE 43740 — [port thread - 2] o.h.search.elasticsearch.request : HSEARCH400093: Executed Elasticsearch HTTP POST request to path ‘/learnings-read/\_search’ with query parameters {size=10000, track\_total\_hits=true} and 1 objects in payload in 6ms. Response had status 200 ‘OK’. Request body: \<  
{  
“query”: {  
“match\_all”: POST  
},  
“\_source”: false  
}

> . Response body: \<  
> {  
> “took”: 2,  
> “timed\_out”: false,  
> “\_shards”: {  
> “total”: 1,  
> “successful”: 1,  
> “skipped”: 0,  
> “failed”: 0  
> },  
> “hits”: {  
> “total”: {  
> “value”: 1,  
> “relation”: “eq”  
> },  
> “max\_score”: 1.0,  
> “hits”: [  
> {  
> “\_index”: “learnings”,  
> “\_type”: “\_doc”,  
> “\_id”: “1”,  
> “\_score”: 1.0  
> }  
> ]  
> }  
> }

2020-12-03 12:48:17.937 DEBUG 43740 — [nio-9090-exec-2] org.hibernate.SQL :  
select  
dbbasedcor0\_.sequence\_id as sequence1\_0\_,  
dbbasedcor0\_.ack as ack2\_0\_,  
dbbasedcor0\_.ack\_timestamp as ack\_time3\_0\_,  
dbbasedcor0\_.acked\_by as acked\_by4\_0\_,  
dbbasedcor0\_.additional\_info as addition5\_0\_,  
dbbasedcor0\_.cancelled\_by as cancelle6\_0\_,  
dbbasedcor0\_.cancelled\_timestamp as cancelle7\_0\_,  
dbbasedcor0\_.count as count8\_0\_,  
dbbasedcor0\_.learn\_id as learn\_i9\_0\_,  
dbbasedcor0\_.learn\_name as learn\_10\_0\_,  
dbbasedcor0\_.learn\_type as learn\_11\_0\_,  
dbbasedcor0\_.member\_class as member\_c12\_0\_,  
dbbasedcor0\_.member\_group as member\_g13\_0\_,  
dbbasedcor0\_.member\_id as member\_i14\_0\_,  
dbbasedcor0\_.member\_key as member\_k15\_0\_,  
dbbasedcor0\_.member\_name as member\_n16\_0\_,  
dbbasedcor0\_.member\_source\_ip as member\_s17\_0\_,  
dbbasedcor0\_.member\_time as member\_t18\_0\_,  
dbbasedcor0\_.first\_occurrence as first\_o19\_0\_,  
dbbasedcor0\_.learn\_entries as learn20\_0\_,  
dbbasedcor0\_.last\_occurrence as last\_oc21\_0\_,  
dbbasedcor0\_.owner as owner22\_0\_,  
dbbasedcor0\_.primary\_ip as primary23\_0\_,  
dbbasedcor0\_.protocol as protoco24\_0\_,  
dbbasedcor0\_.severity as severit25\_0\_,  
dbbasedcor0\_.spec as spec26\_0\_,  
dbbasedcor0\_.summary as summary27\_0\_,  
dbbasedcor0\_.time\_to\_cancel as time\_to28\_0\_,  
dbbasedcor0\_.type as type29\_0\_,  
dbbasedcor0\_.course\_list as course30\_0\_,  
dbbasedcor0\_.version as version31\_0\_  
from  
learnings dbbasedcor0\_  
where  
dbbasedcor0\_.sequence\_id in (  
?  
)  
Hibernate:  
select  
dbbasedcor0\_.sequence\_id as sequence1\_0\_,  
dbbasedcor0\_.ack as ack2\_0\_,  
dbbasedcor0\_.ack\_timestamp as ack\_time3\_0\_,  
dbbasedcor0\_.acked\_by as acked\_by4\_0\_,  
dbbasedcor0\_.additional\_info as addition5\_0\_,  
dbbasedcor0\_.cancelled\_by as cancelle6\_0\_,  
dbbasedcor0\_.cancelled\_timestamp as cancelle7\_0\_,  
dbbasedcor0\_.count as count8\_0\_,  
dbbasedcor0\_.learn\_id as learn\_i9\_0\_,  
dbbasedcor0\_.learn\_name as learn\_10\_0\_,  
dbbasedcor0\_.learn\_type as learn\_11\_0\_,  
dbbasedcor0\_.member\_class as member\_c12\_0\_,  
dbbasedcor0\_.member\_group as member\_g13\_0\_,  
dbbasedcor0\_.member\_id as member\_i14\_0\_,  
dbbasedcor0\_.member\_key as member\_k15\_0\_,  
dbbasedcor0\_.member\_name as member\_n16\_0\_,  
dbbasedcor0\_.member\_source\_ip as member\_s17\_0\_,  
dbbasedcor0\_.member\_time as member\_t18\_0\_,  
dbbasedcor0\_.first\_occurrence as first\_o19\_0\_,  
dbbasedcor0\_.learn\_entries as learn20\_0\_,  
dbbasedcor0\_.last\_occurrence as last\_oc21\_0\_,  
dbbasedcor0\_.owner as owner22\_0\_,  
dbbasedcor0\_.primary\_ip as primary23\_0\_,  
dbbasedcor0\_.protocol as protoco24\_0\_,  
dbbasedcor0\_.severity as severit25\_0\_,  
dbbasedcor0\_.spec as spec26\_0\_,  
dbbasedcor0\_.summary as summary27\_0\_,  
dbbasedcor0\_.time\_to\_cancel as time\_to28\_0\_,  
dbbasedcor0\_.type as type29\_0\_,  
dbbasedcor0\_.course\_list as course30\_0\_,  
dbbasedcor0\_.version as version31\_0\_  
from  
learnings dbbasedcor0\_  
where  
dbbasedcor0\_.sequence\_id in (  
?  
)  
2020-12-03 12:48:17.951 WARN 43740 — [nio-9090-exec-2] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 42102, SQLState: 42S02  
2020-12-03 12:48:17.952 ERROR 43740 — [nio-9090-exec-2] o.h.engine.jdbc.spi.SqlExceptionHelper : Table “learnings” not found; SQL statement:  
select dbbasedcor0\_.sequence\_id as sequence1\_0\_, dbbasedcor0\_.ack as ack2\_0\_, dbbasedcor0\_.ack\_timestamp as ack\_time3\_0\_, dbbasedcor0\_.acked\_by as acked\_by4\_0\_, dbbasedcor0\_.additional\_info as addition5\_0\_, dbbasedcor0\_.cancelled\_by as cancelle6\_0\_, dbbasedcor0\_.cancelled\_timestamp as cancelle7\_0\_, dbbasedcor0\_.count as count8\_0\_, dbbasedcor0\_.learn\_id as learn\_i9\_0\_, dbbasedcor0\_.learn\_name as learn\_10\_0\_, dbbasedcor0\_.learn\_type as learn\_11\_0\_, dbbasedcor0\_.member\_class as member\_c12\_0\_, dbbasedcor0\_.member\_group as member\_g13\_0\_, dbbasedcor0\_.member\_id as member\_i14\_0\_, dbbasedcor0\_.member\_key as member\_k15\_0\_, dbbasedcor0\_.member\_name as member\_n16\_0\_, dbbasedcor0\_.member\_source\_ip as member\_s17\_0\_, dbbasedcor0\_.member\_time as member\_t18\_0\_, dbbasedcor0\_.first\_occurrence as first\_o19\_0\_, dbbasedcor0\_.learn\_entries as learn20\_0\_, dbbasedcor0\_.last\_occurrence as last\_oc21\_0\_, dbbasedcor0\_.owner as owner22\_0\_, dbbasedcor0\_.primary\_ip as primary23\_0\_, dbbasedcor0\_.protocol as protoco24\_0\_, dbbasedcor0\_.severity as severit25\_0\_, dbbasedcor0\_.spec as spec26\_0\_, dbbasedcor0\_.summary as summary27\_0\_, dbbasedcor0\_.time\_to\_cancel as time\_to28\_0\_, dbbasedcor0\_.type as type29\_0\_, dbbasedcor0\_.course\_list as course30\_0\_, dbbasedcor0\_.version as version31\_0\_ from learnings dbbasedcor0\_ where dbbasedcor0\_.sequence\_id in (?) [42102-200]  
2020-12-03 12:48:22.763 ERROR 43740 — [nio-9090-exec-2] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path threw exception [Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not prepare statement; SQL [select dbbasedcor0\_.sequence\_id as sequence1\_0\_, dbbasedcor0\_.ack as ack2\_0\_, dbbasedcor0\_.ack\_timestamp as ack\_time3\_0\_, dbbasedcor0\_.acked\_by as acked\_by4\_0\_, dbbasedcor0\_.additional\_info as addition5\_0\_, dbbasedcor0\_.cancelled\_by as cancelle6\_0\_, dbbasedcor0\_.cancelled\_timestamp as cancelle7\_0\_, dbbasedcor0\_.count as count8\_0\_, dbbasedcor0\_.learn\_id as learn\_i9\_0\_, dbbasedcor0\_.learn\_name as learn\_10\_0\_, dbbasedcor0\_.learn\_type as learn\_11\_0\_, dbbasedcor0\_.member\_class as member\_c12\_0\_, dbbasedcor0\_.member\_group as member\_g13\_0\_, dbbasedcor0\_.member\_id as member\_i14\_0\_, dbbasedcor0\_.member\_key as member\_k15\_0\_, dbbasedcor0\_.member\_name as member\_n16\_0\_, dbbasedcor0\_.member\_source\_ip as member\_s17\_0\_, dbbasedcor0\_.member\_time as member\_t18\_0\_, dbbasedcor0\_.first\_occurrence as first\_o19\_0\_, dbbasedcor0\_.learn\_entries as learn20\_0\_, dbbasedcor0\_.last\_occurrence as last\_oc21\_0\_, dbbasedcor0\_.owner as owner22\_0\_, dbbasedcor0\_.primary\_ip as primary23\_0\_, dbbasedcor0\_.protocol as protoco24\_0\_, dbbasedcor0\_.severity as severit25\_0\_, dbbasedcor0\_.spec as spec26\_0\_, dbbasedcor0\_.summary as summary27\_0\_, dbbasedcor0\_.time\_to\_cancel as time\_to28\_0\_, dbbasedcor0\_.type as type29\_0\_, dbbasedcor0\_.course\_list as course30\_0\_, dbbasedcor0\_.version as version31\_0\_ from learnings dbbasedcor0\_ where dbbasedcor0\_.sequence\_id in (?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not prepare statement] with root cause

org.h2.jdbc.JdbcSQLSyntaxErrorException: Table “learnings” not found; SQL statement:  
select dbbasedcor0\_.sequence\_id as sequence1\_0\_, dbbasedcor0\_.ack as ack2\_0\_, dbbasedcor0\_.ack\_timestamp as ack\_time3\_0\_, dbbasedcor0\_.acked\_by as acked\_by4\_0\_, dbbasedcor0\_.additional\_info as addition5\_0\_, dbbasedcor0\_.cancelled\_by as cancelle6\_0\_, dbbasedcor0\_.cancelled\_timestamp as cancelle7\_0\_, dbbasedcor0\_.count as count8\_0\_, dbbasedcor0\_.learn\_id as learn\_i9\_0\_, dbbasedcor0\_.learn\_name as learn\_10\_0\_, dbbasedcor0\_.learn\_type as learn\_11\_0\_, dbbasedcor0\_.member\_class as member\_c12\_0\_, dbbasedcor0\_.member\_group as member\_g13\_0\_, dbbasedcor0\_.member\_id as member\_i14\_0\_, dbbasedcor0\_.member\_key as member\_k15\_0\_, dbbasedcor0\_.member\_name as member\_n16\_0\_, dbbasedcor0\_.member\_source\_ip as member\_s17\_0\_, dbbasedcor0\_.member\_time as member\_t18\_0\_, dbbasedcor0\_.first\_occurrence as first\_o19\_0\_, dbbasedcor0\_.learn\_entries as learn20\_0\_, dbbasedcor0\_.last\_occurrence as last\_oc21\_0\_, dbbasedcor0\_.owner as owner22\_0\_, dbbasedcor0\_.primary\_ip as primary23\_0\_, dbbasedcor0\_.protocol as protoco24\_0\_, dbbasedcor0\_.severity as severit25\_0\_, dbbasedcor0\_.spec as spec26\_0\_, dbbasedcor0\_.summary as summary27\_0\_, dbbasedcor0\_.time\_to\_cancel as time\_to28\_0\_, dbbasedcor0\_.type as type29\_0\_, dbbasedcor0\_.course\_list as course30\_0\_, dbbasedcor0\_.version as version31\_0\_ from learnings dbbasedcor0\_ where dbbasedcor0\_.sequence\_id in (?) [42102-200]  
at org.h2.message.DbException.getJdbcSQLException(DbException.java:453) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.message.DbException.get(DbException.java:205) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.message.DbException.get(DbException.java:181) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.command.Parser.readTableOrView(Parser.java:7628) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.command.Parser.readTableFilter(Parser.java:1970) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.command.Parser.parseSelectFromPart(Parser.java:2827) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.command.Parser.parseSelect(Parser.java:2959) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.command.Parser.parseQuerySub(Parser.java:2817) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.command.Parser.parseSelectUnion(Parser.java:2649) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.command.Parser.parseQuery(Parser.java:2620) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.command.Parser.parsePrepared(Parser.java:868) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.command.Parser.parse(Parser.java:843) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.command.Parser.parse(Parser.java:815) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.command.Parser.prepareCommand(Parser.java:738) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.engine.Session.prepareLocal(Session.java:657) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.engine.Session.prepareCommand(Session.java:595) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.jdbc.JdbcPreparedStatement.(JdbcPreparedStatement.java:76) ~[h2-1.4.200.jar:1.4.200]  
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:352) ~[h2-1.4.200.jar:1.4.200]  
at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:337) ~[HikariCP-3.4.5.jar:na]  
at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java) ~[HikariCP-3.4.5.jar:na]  
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:149) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:176) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:151) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:2085) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2022) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2000) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]  
at org.hibernate.loader.Loader.doQuery(Loader.java:951) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]

Thanks & Regards,  
Srikanth C

---

<div class="post-metadata">

**Author:** ![yrodiere](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/yrodiere/32/1760_2.png) [@yrodiere](https://discourse.hibernate.org/u/yrodiere)\
**Post date:** [December 3, 2020, 8:02am UTC](https://discourse.hibernate.org/t/source-is-being-sent-as-false-when-where-f-f-matchall-fetchall-gets-executed/4837/2 "2020-12-03T08:02:07Z")

</div>

> [@schoppara](#):
>
> How to make send request without setting \_source to false.

Use a [projection](https://docs.jboss.org/hibernate/search/6.0/reference/en-US/html_single/#search-dsl-projection) to retrieve a particular field. In particular, the [source](https://docs.jboss.org/hibernate/search/6.0/reference/en-US/html_single/#search-dsl-projection-extensions-elasticsearch-source) projection will return a JSON object containing the full source. But if you’re only after one or two fields, I’d suggest the [field](https://docs.jboss.org/hibernate/search/6.0/reference/en-US/html_single/#search-dsl-projection-field) projection instead.

Alternatively, you can [manipulate the JSON of the request and response directly](https://docs.jboss.org/hibernate/search/6.0/reference/en-US/html_single/#search-dsl-query-elasticsearch-json).

> [@schoppara](#):
>
> then \_id is set to some random string “Nim9HHYB9AI0nENFUPob” and i am seeing a Number format exception when the following line is executed.

If you intend to populate documents yourself, you must provide data consistent with your Hibernate Search mapping. In your `DbActiveLearns` class, the identifier is a `Long`. So you must provide the identifier when you create a document, and it must be parsable to a `Long`.

I hope you were only doing this for debugging, because Hibernate Search is fully able to populate your index for you. You’re not supposed to do it by hand.

> [@schoppara](#):
>
> The tablename is in small letters but the query passed is having the table name as “LEARNINGS”

I’m not sure what you’re referring to. The table name is in lowercase in the query:  
`[...] from learnings dbbasedcor0_ where [...[]`. See below. And that’s exactly what you configured: `@Table(name = “learnings”)`.

Are you sure the table “learnings” exists in the database? Because your database doesn’t seem to agree, judging from the error message “Table “learnings” not found”.

> [@schoppara](#):
>
> select dbbasedcor0\_.sequence\_id as sequence1\_0\_, dbbasedcor0\_.ack as ack2\_0\_, dbbasedcor0\_.ack\_timestamp as ack\_time3\_0\_, dbbasedcor0\_.acked\_by as acked\_by4\_0\_, dbbasedcor0\_.additional\_info as addition5\_0\_, dbbasedcor0\_.cancelled\_by as cancelle6\_0\_, dbbasedcor0\_.cancelled\_timestamp as cancelle7\_0\_, dbbasedcor0\_.count as count8\_0\_, dbbasedcor0\_.learn\_id as learn\_i9\_0\_, dbbasedcor0\_.learn\_name as learn\_10\_0\_, dbbasedcor0\_.learn\_type as learn\_11\_0\_, dbbasedcor0\_.member\_class as member\_c12\_0\_, dbbasedcor0\_.member\_group as member\_g13\_0\_, dbbasedcor0\_.member\_id as member\_i14\_0\_, dbbasedcor0\_.member\_key as member\_k15\_0\_, dbbasedcor0\_.member\_name as member\_n16\_0\_, dbbasedcor0\_.member\_source\_ip as member\_s17\_0\_, dbbasedcor0\_.member\_time as member\_t18\_0\_, dbbasedcor0\_.first\_occurrence as first\_o19\_0\_, dbbasedcor0\_.learn\_entries as learn20\_0\_, dbbasedcor0\_.last\_occurrence as last\_oc21\_0\_, dbbasedcor0\_.owner as owner22\_0\_, dbbasedcor0\_.primary\_ip as primary23\_0\_, dbbasedcor0\_.protocol as protoco24\_0\_, dbbasedcor0\_.severity as severit25\_0\_, dbbasedcor0\_.spec as spec26\_0\_, dbbasedcor0\_.summary as summary27\_0\_, dbbasedcor0\_.time\_to\_cancel as time\_to28\_0\_, dbbasedcor0\_.type as type29\_0\_, dbbasedcor0\_.course\_list as course30\_0\_, dbbasedcor0\_.version as version31\_0\_ from learnings dbbasedcor0\_ where dbbasedcor0\_.sequence\_id