For help, SQL statements to the database less half,
The original statement is as follows:
The select SPS. *,
The sum (SPS) upl_insu_day_count) over (partition by SPS. Canal order by SPS, create_time) as upl_insu_day_total
The from SMS_PUSH_STATISTICS SPS
Where 1=1
The order by SPS, create_time desc
When using hibernate to perform behind will be truncated:
Org. Springframework. JDBC. BadSqlGrammarException: StatementCallback; Bad SQL grammar [select count (*) from (select SPS. The id, the sum (SPS) upl_insu_day_count) over (partition by SPS. Canal)]; Nested exception is Java. SQL. SQLSyntaxErrorException: ORA - 00923: to find the FROM the keyword

CodePudding user response:

Statements directly in the database no problem, in the program will be truncated

CodePudding user response:

Every time the sum over there truncation

CodePudding user response:

Had deleted over the statements will not be truncated, but now I want to use this ah, who help see

CodePudding user response:

Don't understand hibernate, helpless

I think you send the wrong section, it's not a question of oracle

CodePudding user response:

Looks like the problem of automatic paging, but you don't code, can't judge,

This should be sent to a Java plates

CodePudding user response:

When using hibernate to perform behind will be truncated

Seems to be the problem, a Java program

CodePudding user response:

Ok, go to Java