{"id":2360,"date":"2017-06-02T08:27:46","date_gmt":"2017-06-02T08:27:46","guid":{"rendered":"http:\/\/codethataint.com\/blog\/?p=2360"},"modified":"2017-06-27T16:26:42","modified_gmt":"2017-06-27T16:26:42","slug":"getting-count-in-jpa","status":"publish","type":"post","link":"https:\/\/codethataint.com\/blog\/getting-count-in-jpa\/","title":{"rendered":"Getting Count in JPA"},"content":{"rendered":"

JPA COUNT returns a Long<\/strong>
\nWhen extracting the count from the table JPA returns long based on the type of query used.<\/p>\n

JPQL<\/strong><\/p>\n

\r\nQuery query = em.createQuery("SELECT COUNT(p) FROM PersonEntity p " );\r\nquery.getSingleResult().getClass().getCanonicalName() --> java.lang.Long\r\n<\/pre>\n
Native Query<\/strong><\/p>\n
\r\nQuery query = em.createNativeQuery("SELECT COUNT(*) FROM PERSON");\r\nquery.getSingleResult().getClass().getCanonicalName() --> java.math.BigInteger\r\n<\/pre>\n
If it is Native Query big Integer is returned or if it is JPQL then Long is returned.<\/p>\n
So before assigning to Integer the value should be typecasted.<\/p>\n
\r\n int count = ((Number)arrCount.get[0]).intValue();\r\n System.out.println(count);\r\n<\/pre>\n
Needs to be Removed<\/em><\/p>\n
\r\n<beans xmlns="http:\/\/www.springframework.org\/schema\/beans"\r\n\txmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance" xmlns:context="http:\/\/www.springframework.org\/schema\/context"\r\n\txmlns:tx="http:\/\/www.springframework.org\/schema\/tx" xmlns:jpa="http:\/\/www.springframework.org\/schema\/data\/jpa"\r\n\txsi:schemaLocation="http:\/\/www.springframework.org\/schema\/beans\r\n   http:\/\/www.springframework.org\/schema\/beans\/spring-beans-3.0.xsd\r\n   http:\/\/www.springframework.org\/schema\/context\r\n   http:\/\/www.springframework.org\/schema\/tx\r\n   http:\/\/www.springframework.org\/schema\/data\/jpa http:\/\/www.springframework.org\/schema\/data\/jpa\/spring-jpa.xsd">\r\n\r\n\t<context:annotation-config \/>\r\n\t<context:component-scan base-package="" \/>\r\n\t<tx:annotation-driven transaction-manager="transactionManager"\/>\r\n\t\r\n\t\r\n\t<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">\r\n\t\t<property name="entityManagerFactory" ref="entityManagerFactory" \/>\r\n\t<\/bean>\r\n\t\r\n\t\r\n\t<!-- Configure the entity manager factory bean -->\r\n\t<bean id="entityManagerFactory"\r\n\t\tclass="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">\r\n\t\t<property name="dataSource" ref="dataSource" \/>\r\n\t\t<property name="jpaVendorAdapter" ref="hibernateJpaVendorAdapter" \/>\r\n\t\t<!-- Set JPA properties -->\r\n\t\t<property name="jpaProperties">\r\n\t\t\t<props>\r\n\t\t\t\t<prop key="hibernate.dialect">org.hibernate.dialect.Oracle10g<\/prop>\r\n\t\t\t<\/props>\r\n\t\t<\/property>\r\n\t\t<!-- Set base package of your entities -->\r\n\t\t<property name="packagesToScan" value="com.mugil.org.model" \/>\r\n\t<\/bean>\r\n\t\r\n\t\r\n\t<beans:bean id="dbDataSource" class="org.springframework.jndi.JndiObjectFactoryBean" scope="singleton" lazy-init="true">\r\n    \t<beans:property name="jndiName" value="java:jboss\/datasources\/TurboDS"\/>\r\n\t<\/beans:bean>\t\r\n<\/beans>\r\n<\/pre>\n
SpringMVC<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
JPA COUNT returns a Long When extracting the count from the table JPA returns long based on the type of query used. JPQL Query query = em.createQuery("SELECT COUNT(p) FROM PersonEntity p " ); query.getSingleResult().getClass().getCanonicalName() –> java.lang.Long Native Query Query query = em.createNativeQuery("SELECT COUNT(*) FROM PERSON"); query.getSingleResult().getClass().getCanonicalName() –> java.math.BigInteger If it is Native Query big Integer… Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[235],"tags":[],"class_list":["post-2360","post","type-post","status-publish","format-standard","hentry","category-jpa"],"_links":{"self":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/2360","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/comments?post=2360"}],"version-history":[{"count":3,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/2360\/revisions"}],"predecessor-version":[{"id":2384,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/2360\/revisions\/2384"}],"wp:attachment":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/media?parent=2360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/categories?post=2360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/tags?post=2360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}