There is a problem with Hebernate result type conversion

1. When using hibernate"s sql query, the result of the database query is 1, and when it is returned to the backend, the result is transformed to 0.

2. The code is as follows:
database query code:

eclipse:

3.:

4. Tried method:
1 when using a sql query, add |""to convert the result of count (1) to a string type.
2 when using a sql query, add |""to convert the result of to_chat () to a string type.
3 when eclipse accepts the results of the query, use the toString () method to convert the results to a string type.
4 when eclipse accepts the results of the query, use the (String) method to convert the results to a string type.

5. Needed help:
how to use hibernate to return integer results of queries in the database to chat, or convert results of type int to type String.

Hibernate

Dec.14,2021

Is the type queried by

count (*) bigdecimal? Then find out how to convert bigdecimal to string.

remove to_char from sql:

String danjuTotalSql = "count(*) from JS5_S12_SALES_....";
BigDecimal danjuTotal = (BigDecimal) em.createNativeQuery(danjuTotalSql).getSingleResult();
String danjuTotalStr = danjuTotal.toString();
Logger.info("danjuTotal=" + danjuTotalStr);

(BigDecimal) can be omitted depending on the situation.

database problem. Resolved.

Previous: Node concurrent request

Next: Path problem after Packaging with vue-cli3.0 in cordova

How does hibernate implement wrapper query?
examples of using wrapper classes on the hibernate official website, public class PersonWrapper { private final Long id; private final String nickName; public PersonWrapper(Long id, String nickName) { this.id = id; this.n...

Hibernate java

Feb.28,2021
Can I use hibernate instead of a database?
1. Recently, when I was learning hibernate, a question suddenly occurred to me: can I use hibernate instead of a database to store data? Can it cooperate with hibernate with simple file access? 2. In order to answer this question, I think we should fi...

Hibernate spring java

Feb.28,2021
Springjpa and thymeleaf work together, the two classes cascade reference each other, HTML pages use objects, error report, is the bug of thymeleaf?
https: github.com thymeleaf . I use jpa, to cascade the two classes through annotations. in the html page, when you get the object of any class through the thymeleaf tag, it will appear . java.lang.StackOverflowError: null at sun.reflect.misc.Refl...

Thymeleaf hibernate spring-data-jpa jpa springboot

Feb.28,2021
Cascade deletion of Java: comments such as @ OneToMany, etc., how to do my pseudo deletion
cascading deletions are actually performed but in practice, it is this kind of pseudo deletion that creates flag and assigns 0,1 . is there a callback method that can handle the logic of deletion? Only in this way can we write custom delete logic h...

Hibernate java

Mar.01,2021
Use springdatajpa,hibernate to cascade two classes. Why do the two tables share the primary key?
one class @Entity public class Shuo{ @Id @GeneratedValue private int id; private String title; private Date date; String content; @ManyToOne(cascade = CascadeType.REFRESH) @JoinColumn(name = "user_id") private User user; : @OneT...

Springboot spring spring-data-jpa hibernate java

Mar.01,2021
Return null when limit is greater than the remaining data when Hibernate is paged?
< H2 > description: < H2 > there are 19 pieces of data in total. When using PageRequest.of (page, limit) for paging query, as long as the limit parameter is greater than 19, it is found to be empty. less than 19:00, function is normal. < H2 > Test C...

Java hibernate jpa

Mar.01,2021
Hibernate data relational mapping Id is of Long type, and the name attribute reports an error. What's wrong?
...

Hibernate java

Mar.02,2021
How can the class generated by javaassist get the original class name in the case of reflect?
Hibernate lazily loads the acquired entity class, which has been handled by javaassit. Now there is no time to study javaassit, wants to know how to get the original Class, of the entity class and the original attribute of the entity class and the Class ...

Hibernate spring java

Mar.04,2021
Session.save () method in hibernate
session.save (c) converts instantaneous objects into persistent objects, but the c object does not have a primary key. A primary key generation strategy is configured in the configuration file. When native, executes session.save (c), an insert statement...

Hibernate java

Mar.04,2021
How does SpringJPA's Sort sort underlined fields?
seniors, use SpringJPA for the first time. Now the entity class has a field that looks like this: private String movie_id; and I want to sort through this field. After inheriting PagingAndSortingRepository, the code is: Sort sort = new Sort(...

Spring jpa hibernate

Mar.05,2021
Spring Hibernate test transaction cannot be rolled back
the test case cannot roll back the data and is inserted directly into the database? applicationContext.xml <context:annotation-config>< context:annotation-config>  <bean id="dataSource" class="org...

Java hibernate spring

Mar.06,2021
How to solve the error in the loading path of Spring MVC configuration validationMessageSource?
xml file related configuration and error prompt Cannot resolve symbol classpath:. : properties: the runtime environment is dependent on tomcat7, data validation: <dependency> <groupId>javax.validation< groupId> ...

Spring-mvc validator hibernate

Mar.12,2021
Hibernate can't save blob when saving it?
mysql database Save the code as follows: : ...

Hibernate mysql java

Mar.12,2021
What is the type of marriage identified by Hibernate jpa? Why is my throwing type conversion exception?
the data found is a collection of the corresponding types of tables, which can be received. But when traversing, you will run out of ClassCaseException . ...

Java hibernate

Mar.14,2021
Hibernate generation sql syntax is not compatible with mysql
the original title was "springdata jpa uses @ ElementCollection to report an error " Table doesn t exists ". Later, I patiently read all the error messages and found that the source of the error was that the sql syntax generated by hibernate was inco...

Java spring mysql hibernate

Mar.16,2021
In hibernate, how does the array field of postgresql map a list < Object > through @ OneToMany?
I have an entity, for address and an entity, for Person, and he has an attribute address_ids; in it, which is an int [] type, which contains an array of address s id. how to map this address_ids field directly to an object of List < Address >. or i...

Jpa hibernate java

Mar.16,2021
SpringBoot + hibernate-validator validation problem
public class ScanRegisterBean implements Serializable{ @Min(value = 1) @Max(value = Long.MAX_VALUE) private long id; @NotBlank(groups = {ScanRegister.class, Register.class}) @Length(min = 2, max = 20,groups = {ScanRegister.class, Re...

Spring hibernate java

Mar.19,2021
How does hibernate implement the set status status when saving, do you have to get the object first?
I want to invert a value every time I update. Do I have to get this object through java, instead of writing sql ?...

Hibernate java

Mar.29,2021
When I was asked in the interview how hibernate does one-to-many mapping, what did I want to ask?
in the interview the day before yesterday, the interviewer asked me how to do one-to-many mapping in hibernate, so I said how to configure it in the hbm file and add collection classes to entity classes as extended objects. In short, I answered the speci...

Interview hibernate java

Mar.31,2021
Why is rollback () used in JDBC transactions?
try { connection.setAutoCommit(false); bankDao.transferMoney(+2000, 1, connection); 1 2000 if(true){ throw new RuntimeException(); } bankDao.transferMoney(-2000, 2, connection); 2 2000 ...

Jdbc hibernate sql mysql java

Apr.07,2021