I'm using Play 2.2.1, which includes ebeanorm-3.2.2 which I tested against and found (what I believe) this bug.

I am getting PersistenceExceptions thrown when creating a large set (hundreds) of similar queries in a row. It seems to depend on the data I'm passing in, which unfortunately, I cannot disclose. The queries look very similar, but have varying numbers of parameters in each section. I traced this through the ebean source code (which I repackaged and replaced the jar in my Play repo), and it lead me to believe that the hashes were colliding. I printed the computed hashes of each query, and they did indeed match. It seems that because they hash the same, the same QueryPlan object it being used for both, even though they have differing numbers of bound parameters.

Both below errors hash to the value: 1336939366

Before I knew all of this, I attempted to explain what I was seeing over on stackoverflow if you'd like to take a look at that as well. http://stackoverflow.com/questions/20501591/ebean-dynamic-query-prepared-statements-mismatched-parameter-count-error

Here are the two stack traces:

play.api.Application$$anon$1: Execution exception[[PersistenceException: Query threw SQLException:No value specified for parameter 19 
Bind values:[SENT,1290,8988,13032,13052,1290,96,99,100,101,102,103,104,105,106,107,108,222] 
Query was:
select distinct t0.contact_id c0, t0.contact_uuid c1, t0.bounce c2 from contact t0 join email_record u1 on u1.contact_id = t0.contact_id  join contact_tag u2z_ on u2z_.contact_id = t0.contact_id  join tag u2 on u2.tag_id = u2z_.tag_id  where u1.status = ?  and t0.unit_id = ?  and u2.tag_id in (?,?)  and t0.unit_id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )  and t0.campaign_id in (?,?,?,?,?,?,?,?,?,?,?,?)  

]]
    at play.api.Application$class.handleError(Application.scala:293) ~[play_2.10.jar:2.2.1]
    at play.api.DefaultApplication.handleError(Application.scala:399) [play_2.10.jar:2.2.1]
    at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$2$$anonfun$applyOrElse$3.apply(PlayDefaultUpstreamHandler.scala:261) [play_2.10.jar:2.2.1]
    at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$2$$anonfun$applyOrElse$3.apply(PlayDefaultUpstreamHandler.scala:261) [play_2.10.jar:2.2.1]
    at scala.Option.map(Option.scala:145) [scala-library.jar:na]
    at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$2.applyOrElse(PlayDefaultUpstreamHandler.scala:261) [play_2.10.jar:2.2.1]
Caused by: javax.persistence.PersistenceException: Query threw SQLException:No value specified for parameter 19 
Bind values:[SENT,1290,8988,13032,13052,1290,96,99,100,101,102,103,104,105,106,107,108,222] 
Query was:
select distinct t0.contact_id c0, t0.contact_uuid c1, t0.bounce c2 from contact t0 join email_record u1 on u1.contact_id = t0.contact_id  join contact_tag u2z_ on u2z_.contact_id = t0.contact_id  join tag u2 on u2.tag_id = u2z_.tag_id  where u1.status = ?  and t0.unit_id = ?  and u2.tag_id in (?,?)  and t0.unit_id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )  and t0.campaign_id in (?,?,?,?,?,?,?,?,?,?,?,?)  


    at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:798) ~[avaje-ebeanorm.jar:na]
    at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:775) ~[avaje-ebeanorm.jar:na]
    at com.avaje.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:205) ~[avaje-ebeanorm.jar:na]
    at com.avaje.ebeaninternal.server.query.DefaultOrmQueryEngine.findMany(DefaultOrmQueryEngine.java:81) ~[avaje-ebeanorm.jar:na]
    at com.avaje.ebeaninternal.server.core.OrmQueryRequest.findList(OrmQueryRequest.java:265) ~[avaje-ebeanorm.jar:na]
    at com.avaje.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1469) ~[avaje-ebeanorm.jar:na]
Caused by: java.sql.SQLException: No value specified for parameter 19
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) ~[mysql-connector-java-5.1.27.jar:na]
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) ~[mysql-connector-java-5.1.27.jar:na]
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975) ~[mysql-connector-java-5.1.27.jar:na]
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920) ~[mysql-connector-java-5.1.27.jar:na]
    at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2612) ~[mysql-connector-java-5.1.27.jar:na]
    at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2587) ~[mysql-connector-java-5.1.27.jar:na]

And the second:

play.api.Application$$anon$1: Execution exception[[PersistenceException: Error with property[19] dt[4]data[1464][java.lang.Integer]]]
    at play.api.Application$class.handleError(Application.scala:293) ~[play_2.10.jar:2.2.1]
    at play.api.DefaultApplication.handleError(Application.scala:399) [play_2.10.jar:2.2.1]
    at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$2$$anonfun$applyOrElse$3.apply(PlayDefaultUpstreamHandler.scala:261) [play_2.10.jar:2.2.1]
    at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$2$$anonfun$applyOrElse$3.apply(PlayDefaultUpstreamHandler.scala:261) [play_2.10.jar:2.2.1]
    at scala.Option.map(Option.scala:145) [scala-library.jar:na]
    at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$2.applyOrElse(PlayDefaultUpstreamHandler.scala:261) [play_2.10.jar:2.2.1]
Caused by: javax.persistence.PersistenceException: Error with property[19] dt[4]data[1464][java.lang.Integer]
    at com.avaje.ebeaninternal.server.persist.Binder.bindSimpleData(Binder.java:327) ~[avaje-ebeanorm.jar:na]
    at com.avaje.ebeaninternal.server.persist.Binder.bindObject(Binder.java:216) ~[avaje-ebeanorm.jar:na]
    at com.avaje.ebeaninternal.server.persist.Binder.bindObject(Binder.java:173) ~[avaje-ebeanorm.jar:na]
    at com.avaje.ebeaninternal.server.query.CQueryPredicates.bind(CQueryPredicates.java:152) ~[avaje-ebeanorm.jar:na]
    at com.avaje.ebeaninternal.server.query.CQuery.prepareBindExecuteQuery(CQuery.java:382) ~[avaje-ebeanorm.jar:na]
    at com.avaje.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:165) ~[avaje-ebeanorm.jar:na]
Caused by: java.sql.SQLException: Parameter index out of range (19 > number of parameters, which is 18).
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) ~[mysql-connector-java-5.1.27.jar:na]
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) ~[mysql-connector-java-5.1.27.jar:na]
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975) ~[mysql-connector-java-5.1.27.jar:na]
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920) ~[mysql-connector-java-5.1.27.jar:na]
    at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3814) ~[mysql-connector-java-5.1.27.jar:na]
    at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3796) ~[mysql-connector-java-5.1.27.jar:na]

This is affecting our production environment so we need a fix ASAP, so I'm going to attempt to fix this in the ebean source, and if I can, I'll try to submit a patch to this ticket. However, I am very unfamiliar with this code, so if someone has the time I'd really appreciate the help.

I can provide more data on request. Additionally, I submitted this bug on what I assume to be the old bug system before seeing the dates on the issues there, http://www.avaje.org/bug.html.

class Model {
String a;
@Transient
List<ModelB> list;
}
Model model = findById(1);
model.list = find(ModelB.class).select("oneField").findList();
//path -> (a,list(oneField))
jsonContext.toJson(o, generator, path)
//-> {"a":"a",list:[{"oneField":1,"twoField":null}]} should not show `twoField`

Ebean version: 7.3.1 Ebean datasource version: 1.1.1

Reproduce steps:

1. create an ebean server and use it, all good so far
2. shutdown the ebean server with shutdownDatasource set to true
3. create an new ebean server. You get the error stack:

javax.persistence.PersistenceException: java.sql.SQLException: Interrupted getting connection from pool java.lang.InterruptedException
    at com.avaje.ebeaninternal.server.core.DefaultContainer.checkDataSource(DefaultContainer.java:361)
    at com.avaje.ebeaninternal.server.core.DefaultContainer.createServer(DefaultContainer.java:102)
    at com.avaje.ebeaninternal.server.core.DefaultContainer.createServer(DefaultContainer.java:41)
    at com.avaje.ebean.EbeanServerFactory.createInternal(EbeanServerFactory.java:108)
    at com.avaje.ebean.EbeanServerFactory.create(EbeanServerFactory.java:67)
    at act.db.ebean.EbeanService$2.on(EbeanService.java:61)
    at act.event.EventBus.callOn(EventBus.java:134)
    at act.event.EventBus.callOn(EventBus.java:155)
    at act.event.EventBus.callOn(EventBus.java:171)
    at act.event.EventBus.emit(EventBus.java:189)
    at act.event.EventBus.emit(EventBus.java:180)
    at act.app.App.emit(App.java:504)
    at act.app.App.refresh(App.java:273)
    at act.app.CliSession.run(CliSession.java:90)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Interrupted getting connection from pool java.lang.InterruptedException
    at org.avaje.datasource.pool.PooledConnectionQueue.getPooledConnection(PooledConnectionQueue.java:277)
    at org.avaje.datasource.pool.ConnectionPool.getPooledConnection(ConnectionPool.java:712)
    at org.avaje.datasource.pool.ConnectionPool.getConnection(ConnectionPool.java:700)
    at com.avaje.ebeaninternal.server.core.DefaultContainer.checkDataSource(DefaultContainer.java:351)
    ... 20 more

如果有一张订单表, 需要将状态由已创建变更为已支付, 对应的 sql 语句是:

update t_order set status = 'Pay' where id = xxx and status = 'Create'

然后根据返回的结果是否为 1 来判断更新有没有成功, 从而决定是否将事务进行回滚.

不想使用 version 的原因在于: 如果有其他的地方在做跟 status 无关的更新操作, 这里的更新将会失败, 还是想基于这一个属性做这种颗粒度的更新, 而且从性能的角度来说, 也多了一次 load version 的查询

v = select version from t_order where id = xxx

update t_order set status = 'Pay', version = v + 1
where id = xxx and version = v

虽然也能用 createQuery 的方式完成这个实现

public void pay(Long id) {
    String delete = "update t_order set status = :new and id = :id and status = :old";
    SqlUpdate update = ebeanServer.createSqlUpdate(delete);
    update.setParameter("id", id);
    update.setParameter("old", "Create");
    update.setParameter("new", "Pay");

    if (update.execute() != 1) {
        // rollback...
        return;
    }
}

但是, 在代码中嵌入 SQL, 多少还是挺难受的, 一旦表名或字段名发生变更(尽管这种情况并不多见)就难受了, 虽然可以挪到 xml, 但是在我看来那样更难受.

我的意思是, 能不能在 ebeanServer 中添加一个像下面这样的方法:

public interface EbeanServer {
    ...
    int update(Object newBean, Object oldBean) throws OptimisticLockException;
    ...
}

这样一来, 调用时, 我只需要

Order order = new Order();
order.setStatus("pay");

Order old = new Order();
old.setId(id);
old.setStatus("Create");

if (ebeanServer.update(order, old) != 1) {
    log...

    // trigger transaction rollback or do anything with business-related operations
    throw new ServiceException("change status fail. please check! order_id: {}", id);
}

当然, 可能带 where 的条件规则会很多, 不仅仅只是这么简单了. 比如

update t_order set status = 'Pay'
where id = xxx and (status = 'Create' or status = 'Confirm')

delete t_system_log where is_delete = 1 and create_time <= '3 month ago'

会有这种需求, 是因为之前我用的 mybatis, 可以用 example 轻松组装出上面的 sql 出来

Ebean-elasticsearch defaults to paging from+size.

However, in the case of deep paging, the efficiency of this method is very low. For example, from=5000,size=10, ES needs to match and sort on each fragment and get 5000*10 valid data, and then return the last 10 data in the result set. In addition to efficiency problems, there is also an unsolvable problem that ES currently supports the maximum skip value of max_result_window, which defaults to 10000, that is, when from+size > When max_result_window, es returns an error.

So when I was in use Ebean, directly use the text () through the es query, is unable to satisfy my business scenario, because after more than 10000, access to the pager maximum page number is not correct, as far as I know the solution, when paging to hundreds of pages, es can't return data, at this time in order to restore the normal use, We can take an emergency dodge by setting max_result_window to 50000, but this solution is only a temporary fix.

So how do I properly page through Ebean using scroll, or something else I'm doing wrong, or is there a better solution

Looking forward to your reply

@Entity
@Table(name = "sys_user")
open class SysUser {
    var name: String? = null

    @ManyToMany
    var roles: Set<SysRole>? = null

    @OneToOne
    @JoinColumn(name = "job_id")
    var job: SysJob? = null
}

@Generated("io.ebean.querybean.kotlin-generator")
@TypeQueryBean
class QSysUser : TQRootBean<SysUser, QSysUser> {

  companion object {
    /**
     * shared 'Alias' instance used to provide
     * properties to select and fetch clauses
     */
    val _alias = QSysUser(true)
  }

  lateinit var name: PString<QSysUser>
  lateinit var job: QAssocSysJob<QSysUser>

  /**
   * Construct with a given EbeanServer.
   */
  constructor(server: EbeanServer) : super(SysUser::class.java, server)

  /**
   * Construct using the default EbeanServer.
   */
  constructor() : super(SysUser::class.java)

  /**
   * Construct for Alias.
   */
  private constructor(dummy: Boolean) : super(dummy)
}

lost roles in query bean

If I replace

var roles: Set < SysRole >? = null 

for

val roles: Set < SysRole >? = null

It generates

lateinit var roles: QAssocSysRole<QSysUser>

Hi, unfortunately ebean-agent probably doing somthing which it should not.

given

abstract class SimpleIdentity<T : Serializable>: Identity<T>() {
    final override fun equals(other: Any?) = super.equals(other)
    final override fun hashCode() = super.hashCode()
}

when

fun main() {
    println(Employee(1, "2", "2")==(Employee(1, "2", "2")))
}

we get

Exception in thread "main" java.lang.VerifyError: class com.example.Employee overrides final method equals.(Ljava/lang/Object;)Z
	at java.lang.ClassLoader.defineClass1(Native Method)
	at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
	at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
	at java.net.URLClassLoader.defineClass(URLClassLoader.java:468)
	at java.net.URLClassLoader.access$100(URLClassLoader.java:74)
	at java.net.URLClassLoader$1.run(URLClassLoader.java:369)
	at java.net.URLClassLoader$1.run(URLClassLoader.java:363)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:362)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
	at com.example.MainKt.main(main.kt:5)
	at com.example.MainKt.main(main.kt)

code attached.

ebean-agent-issue.zip

Run it inside Intellij IDEA

If we remove Entity annotation so ebean does not modify class - it's ok. tried with several gradle and jvm versions. Java 1.8 does not work for sure.

support java.io.File and java.nio.file.Path save to db.

db data type use Blob, can configure save file bytes or file path.

add plan column can use for witch read file bytes or file path, both plan use

and more info last modified, size, filename and more

I got a strange issue that I'm pretty sure is a bug; let's say I got a column called LocID in the database, which is mapped to property locationId of an entity mapped using @Column like @Column(name = "LocID") private Long locationId;

The problem is when I try to make a query using RawSqlBuilder.parse(sql).create() I get an issue of exception related to a property name (Property [locId] not found on) or column name (Invalid column name 'locationId'.). if I tried to select either of LocID or loactionId, other properties are fine, which make me believe it is a bug, that I renamed locationId to locId and worked!

I tried to rename another field like zipCode to postalCode with @Column(name = "ZipCode") got the same issue on this column too, in short, no issues at all if the property name MATCH the column name.

I tried columnMapping approach got the same issues, same exceptions.

Expected behavior

Selecting a property name in a query should be working fine.

Actual behavior

The property name MUST match column name, and can't be selected in any way if they are different.

Steps to reproduce

@Entity
@Sql
public class LocationExtractedData extends Model {

    @Id
    @Column(name = "Id")
    private Integer id;

    @Column(name = "ZipCode")
    private String zipCode;

    @Column(name = "LocID")
    private Long locationId;

    @Column(name = "CompanyName")
    private String companyName;

    @Column(name = "Latitude")
    private String latitude;

    @Column(name = "Longitude")
    private String longitude;

}

And query part for RawSql

public CompletionStage<Stream<LocationExtractedData>> list(String[] keys) {
        final String sql = "SELECT id, zipCode, locationId, companyName, latitude, longitude" +
                " FROM fnGetLocationsSummaryForCompanies(:keys)";

        return supplyAsync(() -> {
                    final RawSql rawSql = RawSqlBuilder.parse(sql).create();
                    return Ebean.find(LocationExtractedData.class)
                            .setRawSql(rawSql)
                            .setParameter("keys", String.join(",", keys))
                            .findList()
                            .stream();
                }
                , ec);

    }

Using SQL Server as you may note in exceptions.

First attempt (it does not make sense):

 java.util.concurrent.CompletionException: javax.persistence.PersistenceException: Query threw SQLException:Invalid column name 'locationId'. Bind values:[....] Query was:select id, zipCode, locationId, companyName, latitude, longitude FROM fnGetLocationsSummaryForCompanies(?)
	at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:314)
	at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:319)
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run$$$capture(CompletableFuture.java:1773)
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java)
	at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:835)
Caused by: javax.persistence.PersistenceException: Query threw SQLException:Invalid column name 'locationId'. Bind values:[....] Query was:select id, zipCode, locationId, companyName, latitude, longitude FROM fnGetLocationsSummaryForCompanies(?)
	at io.ebean.config.dbplatform.SqlCodeTranslator.translate(SqlCodeTranslator.java:52)
	at io.ebean.config.dbplatform.DatabasePlatform.translate(DatabasePlatform.java:223)
	at io.ebeaninternal.server.query.CQueryEngine.translate(CQueryEngine.java:149)
	at io.ebeaninternal.server.query.DefaultOrmQueryEngine.translate(DefaultOrmQueryEngine.java:43)
	at io.ebeaninternal.server.core.OrmQueryRequest.translate(OrmQueryRequest.java:103)
	at io.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:701)
	at io.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:411)
	at io.ebeaninternal.server.query.DefaultOrmQueryEngine.findMany(DefaultOrmQueryEngine.java:133)
	at io.ebeaninternal.server.core.OrmQueryRequest.findList(OrmQueryRequest.java:451)
	at io.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1552)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'locationId'.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:592)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2935)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:444)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
[error] h.ExceptionHandlingUtil - @null: Query threw SQLException:Invalid column name 'locationId'. Bind values:[....] Query was:select id, zipCode, locationId, companyName, latitude, longitude FROM fnGetLocationsSummaryForCompanies(?)
	at actions.RemoteDBAction.lambda$doCall$2(RemoteDBAction.java:81)
	at java.base/java.util.concurrent.CompletableFuture.uniHandle(CompletableFuture.java:930)
	at java.base/java.util.concurrent.CompletableFuture$UniHandle.tryFire(CompletableFuture.java:907)
	at java.base/java.util.concurrent.CompletableFuture$Completion.run(CompletableFuture.java:478)
	at play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:79)
	at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41)
	at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(ForkJoinExecutorConfigurator.scala:49)
	at akka.dispatch.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
	at akka.dispatch.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
	at akka.dispatch.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
	at akka.dispatch.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
Caused by: javax.persistence.PersistenceException: Query threw SQLException:Invalid column name 'locationId'. Bind values:[....] Query was:select id, zipCode, locationId, companyName, latitude, longitude FROM fnGetLocationsSummaryForCompanies(?)
	at io.ebean.config.dbplatform.SqlCodeTranslator.translate(SqlCodeTranslator.java:52)
	at io.ebean.config.dbplatform.DatabasePlatform.translate(DatabasePlatform.java:223)
	at io.ebeaninternal.server.query.CQueryEngine.translate(CQueryEngine.java:149)
	at io.ebeaninternal.server.query.DefaultOrmQueryEngine.translate(DefaultOrmQueryEngine.java:43)
	at io.ebeaninternal.server.core.OrmQueryRequest.translate(OrmQueryRequest.java:103)
	at io.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:701)
	at io.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:411)
	at io.ebeaninternal.server.query.DefaultOrmQueryEngine.findMany(DefaultOrmQueryEngine.java:133)
	at io.ebeaninternal.server.core.OrmQueryRequest.findList(OrmQueryRequest.java:451)
	at io.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1552)
	at io.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1528)
	at io.ebeaninternal.server.querydefn.DefaultOrmQuery.findList(DefaultOrmQuery.java:1526)
...
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:835)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'locationId'.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:592)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2935)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:444)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
	at io.ebeaninternal.server.query.CQuery.prepareResultSet(CQuery.java:377)
	at io.ebeaninternal.server.query.CQuery.prepareBindExecuteQueryWithOption(CQuery.java:325)
	at io.ebeaninternal.server.query.CQuery.prepareBindExecuteQuery(CQuery.java:320)
	at io.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:384)
	... 12 more

A second attempt (it does make sense):

[error] a.PostAction - Direct exception javax.persistence.PersistenceException: Property [locId] not found on models.LocationExtractedData
java.util.concurrent.CompletionException: javax.persistence.PersistenceException: Property [locId] not found on models.LocationExtractedData
	at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:314)
	at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:319)
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run$$$capture(CompletableFuture.java:1773)
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java)
	at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:835)
Caused by: javax.persistence.PersistenceException: Property [locId] not found on models.LocationExtractedData
	at io.ebeaninternal.server.query.CQueryBuilder.createRawSqlSqlTree(CQueryBuilder.java:488)
	at io.ebeaninternal.server.query.CQueryBuilder.createSqlTree(CQueryBuilder.java:408)
	at io.ebeaninternal.server.query.CQueryBuilder.buildQuery(CQueryBuilder.java:361)
	at io.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:377)
	at io.ebeaninternal.server.query.DefaultOrmQueryEngine.findMany(DefaultOrmQueryEngine.java:133)
	at io.ebeaninternal.server.core.OrmQueryRequest.findList(OrmQueryRequest.java:451)
	at io.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1552)
	at io.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1528)
	at io.ebeaninternal.server.querydefn.DefaultOrmQuery.findList(DefaultOrmQuery.java:1526)
	at ....LocationExtractedRepository.lambda$list$0(LocationExtractedRepository.java:41)
[error] h.ExceptionHandlingUtil - @null: Property [locId] not found on models.LocationExtractedData
	at actions.RemoteDBAction.lambda$doCall$2(RemoteDBAction.java:81)
	at java.base/java.util.concurrent.CompletableFuture.uniHandle(CompletableFuture.java:930)
	at java.base/java.util.concurrent.CompletableFuture$UniHandle.tryFire(CompletableFuture.java:907)
	at java.base/java.util.concurrent.CompletableFuture$Completion.run(CompletableFuture.java:478)
	at play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:79)
	at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41)
	at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(ForkJoinExecutorConfigurator.scala:49)
	at akka.dispatch.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
	at akka.dispatch.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
	at akka.dispatch.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
	at akka.dispatch.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
Caused by: javax.persistence.PersistenceException: Property [locId] not found on models.LocationExtractedData
	at io.ebeaninternal.server.query.CQueryBuilder.createRawSqlSqlTree(CQueryBuilder.java:488)
	at io.ebeaninternal.server.query.CQueryBuilder.createSqlTree(CQueryBuilder.java:408)
	at io.ebeaninternal.server.query.CQueryBuilder.buildQuery(CQueryBuilder.java:361)
	at io.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:377)
	at io.ebeaninternal.server.query.DefaultOrmQueryEngine.findMany(DefaultOrmQueryEngine.java:133)
	at io.ebeaninternal.server.core.OrmQueryRequest.findList(OrmQueryRequest.java:451)
	at io.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1552)
	at io.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1528)
	at io.ebeaninternal.server.querydefn.DefaultOrmQuery.findList(DefaultOrmQuery.java:1526)
	at ...LocationExtractedRepository.lambda$list$0(LocationExtractedRepository.java:41)
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run$$$capture(CompletableFuture.java:1771)
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java)
	at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:835)

import com.avaje.ebean.EbeanServer;
import com.avaje.ebean.EbeanServerFactory;
import com.avaje.ebean.config.DataSourceConfig;
import com.avaje.ebean.config.ServerConfig;
import com.google.common.collect.Lists;
import org.avaje.agentloader.AgentLoader;
import org.h2.Driver;
import org.junit.Before;
import org.junit.Test;

import javax.persistence.*;
import java.io.IOException;
import java.lang.instrument.IllegalClassFormatException;

/**
 * @author icode
 */
public class EbeanTest {
    EbeanServer server;

    @Before
    public void init() {
        AgentLoader.loadAgentFromClasspath("avaje-ebeanorm-agent", "debug=5");
        final ServerConfig config = new ServerConfig();
        config.setClasses(Lists.<Class<?>>newArrayList(RoadShowMsg.class, Company.class));
        DataSourceConfig dataSourceConfig = new DataSourceConfig();
        dataSourceConfig.setUrl("jdbc:h2:file:./db");
        dataSourceConfig.setDriver(Driver.class.getName());
        dataSourceConfig.setUsername("sa");
        dataSourceConfig.setPassword("");
        config.setDataSourceConfig(dataSourceConfig);
        config.setName("default");
        config.setDdlGenerate(true);
        config.setDdlRun(true);
        config.setDefaultServer(true);
        server = EbeanServerFactory.create(config);
    }

    @Test
    public void JsonTest() throws IOException, IllegalClassFormatException, ClassNotFoundException {
        RoadShowMsg msg = new RoadShowMsg();
        Company company = new Company();
        company.setCorpId("corp_id_1000000");
        msg.setCompany(company);
        server.save(msg);
        server.find(RoadShowMsg.class, 1);
    }

    @MappedSuperclass
    public static abstract class Model {
        @Id
        @GeneratedValue
        public Long id;

        public Long getId() {
            return id;
        }

        public void setId(Long id) {
            this.id = id;
        }
    }

    @Entity
    public static class RoadShowMsg extends Model {
        @OneToOne(cascade = CascadeType.ALL, optional = false)
        @JoinColumn(name = "corp_id", nullable = false, referencedColumnName = "corp_id")
        public Company company;

        public Company getCompany() {
            return company;
        }

        public void setCompany(Company company) {
            this.company = company;
        }
    }

    @Entity
    public static class Company extends Model {
        @Column(length = 50, unique = true)
        public String corpId;

        public String getCorpId() {
            return corpId;
        }

        public void setCorpId(String corpId) {
            this.corpId = corpId;
        }
    }
}

console:

javax.persistence.PersistenceException: Error loading on EbeanTest$RoadShowMsg.company

    at com.avaje.ebeaninternal.server.query.SqlBeanLoad.load(SqlBeanLoad.java:85)
    at com.avaje.ebeaninternal.server.deploy.BeanPropertyAssocOne.load(BeanPropertyAssocOne.java:615)
    at com.avaje.ebeaninternal.server.query.SqlTreeNodeBean.load(SqlTreeNodeBean.java:268)
    at com.avaje.ebeaninternal.server.query.CQuery.readNextBean(CQuery.java:431)
    at com.avaje.ebeaninternal.server.query.CQuery.hasNext(CQuery.java:512)
    at com.avaje.ebeaninternal.server.query.CQuery.readBean(CQuery.java:494)
    at com.avaje.ebeaninternal.server.query.CQueryEngine.find(CQueryEngine.java:356)
    at com.avaje.ebeaninternal.server.query.DefaultOrmQueryEngine.findId(DefaultOrmQueryEngine.java:129)
    at com.avaje.ebeaninternal.server.core.OrmQueryRequest.findId(OrmQueryRequest.java:251)
    at com.avaje.ebeaninternal.server.core.DefaultServer.findId(DefaultServer.java:1190)
    at com.avaje.ebeaninternal.server.core.DefaultServer.find(DefaultServer.java:1048)
    at com.avaje.ebeaninternal.server.core.DefaultServer.find(DefaultServer.java:1035)
    at EbeanTest.JsonTest(EbeanTest.java:48)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
    at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
    at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
    at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:234)
    at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:74)
Caused by: org.h2.jdbc.JdbcSQLException: Data conversion error converting "corp_id_1000000" [22018-187]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:168)
    at org.h2.value.Value.convertTo(Value.java:902)
    at org.h2.value.Value.getLong(Value.java:443)
    at org.h2.jdbc.JdbcResultSet.getLong(JdbcResultSet.java:650)
    at com.avaje.ebeaninternal.server.type.RsetDataReader.getLong(RsetDataReader.java:121)
    at com.avaje.ebeaninternal.server.type.ScalarTypeLong.read(ScalarTypeLong.java:34)
    at com.avaje.ebeaninternal.server.type.ScalarTypeLong.read(ScalarTypeLong.java:17)
    at com.avaje.ebeaninternal.server.deploy.BeanProperty.read(BeanProperty.java:581)
    at com.avaje.ebeaninternal.server.deploy.id.IdBinderSimple.read(IdBinderSimple.java:177)
    at com.avaje.ebeaninternal.server.deploy.BeanPropertyAssocOne$Reference.read(BeanPropertyAssocOne.java:749)
    at com.avaje.ebeaninternal.server.deploy.BeanPropertyAssocOne.read(BeanPropertyAssocOne.java:574)
    at com.avaje.ebeaninternal.server.query.SqlBeanLoad.load(SqlBeanLoad.java:74)
    ... 34 more
Caused by: java.lang.NumberFormatException: For input string: "corp_id_1000000"
    at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    at java.lang.Long.parseLong(Long.java:589)
    at java.lang.Long.parseLong(Long.java:631)
    at org.h2.value.Value.convertTo(Value.java:854)
    ... 44 more

com.avaje.ebeaninternal.server.deploy.BeanDescriptorJsonHelp event != JsonToken.START_ARRAY is error

public <T> List<T> toList(Class<T> cls, JsonParser src) throws JsonIOException {
        try {
            BeanDescriptor e = this.getDescriptor(cls);
            ArrayList list = new ArrayList();
            JsonToken event = src.nextToken();
            // this is a START_OBJECT
            if(event != JsonToken.START_ARRAY) {
                throw new JsonParseException("Expecting start_array event but got " + event, src.getCurrentLocation());
            } else {
                while(true) {
                    Object bean = e.jsonRead(src, (String)null);
                    if(bean == null) {
                        return list;
                    }

                    list.add(bean);
                }
            }
        } catch (IOException var7) {
            throw new JsonIOException(var7);
        }
    }

Expected behavior

Ebean should use same strategy when generating DDL for DbEnumValue i.e. either use Integer or VarChar, or should honour storage = DbEnumType.VARCHARwhen defined

Actual behavior

In my project it is using Integer for some table and VarChar for others even though I have defined storage = DbEnumType.VARCHAR on all enums.

Steps to reproduce

For below enum, ebean uses VarChar

 import io.ebean.annotation.DbEnumType;
import io.ebean.annotation.DbEnumValue;


public enum DeviceOTPTypeEnum {
VALID("VALID"),
VERIFIED("VERIFIED"),
EXPIRED("EXPIRED");

String value;

DeviceOTPTypeEnum(String pValue){
value=pValue;
}


@DbEnumValue(storage = DbEnumType.VARCHAR)
public String getValue() {
return value;
}
}

DDL generated create table device_otp ( id uuid not null, otp integer not null, verified boolean default false not null, last_sent timestamptz, retry_count integer not null, device_id uuid not null, verified_at timestamptz, version bigint not null, when_created timestamptz not null, last_modified timestamptz not null, deleted boolean default false not null, generated_at timestamptz not null, otp_status varchar(8), constraint ck_device_otp_otp_status check ( otp_status in ('VALID','VERIFIED','EXPIRED')), constraint pk_device_otp primary key (id) );

For below ENUM ebean uses Integer

 import io.ebean.annotation.DbEnumType;
import io.ebean.annotation.DbEnumValue;

public enum UserConsentType {

SMS("SMS"),
EMAIL("EMAIL"),
WHATSAPP("WHATSAPP"),
TERMS_AND_CONDITIONS("TERMS_AND_CONDITIONS"),
CREDIT_REPORT("CREDIT_REPORT");

String value;

UserConsentType(String pValue){
value=pValue;
}

@DbEnumValue(storage = DbEnumType.VARCHAR)
String getValue(){
return value;
}
}

DDL generated create table device_consents ( id uuid not null, consent_type integer not null, device_id uuid not null, provided boolean default false not null, version bigint not null, when_created timestamptz not null, last_modified timestamptz not null, deleted boolean default false not null, constraint ck_device_consents_consent_type check ( consent_type in (0,1,2,3,4)), constraint pk_device_consents primary key (id) );

I create a gradle project with SpringBoot 3.x, I find ebean only scan javax.persistence.Entity，not scan jakarta.persistence.Entity. When I use jakarta.persistence.Entity, DbMigration will say no changes detected, and querybean will not generate this QXXXEntity. source code: https://github.com/luoxiaopeng/test_ebean.git

Is this right?

Expected behavior

query some object by annotation-driven mapping, have result object with properties populated.

Actual behavior

The result is like:

leadsWebActionDataCountAggregates: [{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{}]

Steps to reproduce

we are using ebean to mapped result from clickhouse:

the sql is like:

select
  effective_action_type,
  CAST(min_action_time2 AS DATE) as effective_action_time,
  count(*) as action_count
from
  (
    select
      effective_action_type,
      sign_id,
      min(action_time2) as min_action_time2
    from
      (
        select
          sign_id,
          action_time2,
          CASE
            WHEN final_action_type = 'wx_1166' THEN '405'
            ELSE final_action_type
          END AS effective_action_type
        from
          leads_web_action_data
        where
          action_time2 between '2022-12-13 00:00:00' and '2022-12-27 23:59:59'
        order by
          action_time2 desc
      )
    group by
      effective_action_type,
      sign_id
  )
group by
  effective_action_type,
  CAST(min_action_time2 AS DATE)

and the java bean is like:

@Entity
@Data
public class LeadsWebActionDataCountAggregate {

    @Column(name = "effective_action_time")
    private Date effectiveActionTime;

    @Column(name = "effective_action_type")
    private Long effectiveActionType;

    @Column(name = "action_count")
    private Integer count;
}

the api invocation is like:

        Query<LeadsWebActionDataCountAggregate> basicQuery =
                getServer().findNative(LeadsWebActionDataCountAggregate.class,
                                nativeSql)
                        .setParameter("actionTimeBegin", condition.getActionTimeBegin())
                        .setParameter("actionTimeEnd", condition.getActionTimeEnd());
        return basicQuery.findList();

leadsWebActionDataCountAggregates: [{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{}]

Expected behavior

Query::findStream() and Query::findEach() are supposed to not cache any items in the persistence context.

Actual behavior

Items are being cached in the persistence context causing OutOfMemoryError after some time. I've done simple tests:

//...
myQuery.findStream().forEach(System.out::println);

//...
myQuery.findEach(System.out::println);

Here is a memory snapshot from the profiler after about 20 sec of execution:

P.S. I use Postgresql DB.

Actual behavior

It seems that certain combinations with findMaps and findOnes are not properly handled by the bean cache. (findList seems to work) See the minimal example:

Steps to reproduce

  public void idsInFindMap() {
    List<OCachedBean> beans = createBeans(Arrays.asList("m0", "m1", "m2", "m3", "m4", "m5", "m6"));
    List<Long> ids = beans.stream().map(OCachedBean::getId).collect(Collectors.toList());
    beanCache.clear();
    beanCache.statistics(true);
    Query<OCachedBean> query = DB.find(OCachedBean.class).setUseCache(true);
    query.copy()
      .where().idIn(ids.subList(0, 1))
      .findMap(); // or findOne - it is important, that one entry is returned here

    query.copy()
      .where().idIn(ids.subList(0, 3))
      .findMap();

    query.copy()
      .where().idIn(ids.subList(2, 7))
      .findMap();
  }

javax.persistence.PersistenceException: Error with property:3 dt:-5 data:6 java.lang.Long

	at io.ebeaninternal.server.persist.Binder.bindSimpleData(Binder.java:341)
	at io.ebeaninternal.server.persist.Binder.bindObject(Binder.java:234)
	at io.ebeaninternal.server.persist.Binder.lambda$bindObject$0(Binder.java:179)
	at io.ebeaninternal.server.persist.platform.MultiValueBind.bindMultiValues(MultiValueBind.java:50)
	at io.ebeaninternal.server.persist.Binder.bindObject(Binder.java:179)
	at io.ebeaninternal.server.expression.DefaultExpressionRequest.bind(DefaultExpressionRequest.java:62)
	at io.ebeaninternal.server.query.CQueryPredicates.bind(CQueryPredicates.java:139)
	at io.ebeaninternal.server.query.CQuery.prepareResultSet(CQuery.java:329)
	at io.ebeaninternal.server.query.CQuery.prepareBindExecuteQueryWithOption(CQuery.java:290)
	at io.ebeaninternal.server.query.CQuery.prepareBindExecuteQuery(CQuery.java:286)
	at io.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:344)
	at io.ebeaninternal.server.query.DefaultOrmQueryEngine.findMany(DefaultOrmQueryEngine.java:123)
	at io.ebeaninternal.server.core.OrmQueryRequest.findMap(OrmQueryRequest.java:432)
	at io.ebeaninternal.server.core.DefaultServer.findMap(DefaultServer.java:1130)
	at io.ebeaninternal.server.querydefn.DefaultOrmQuery.findMap(DefaultOrmQuery.java:1495)
	at io.ebeaninternal.server.expression.DefaultExpressionList.findMap(DefaultExpressionList.java:457)
	at org.tests.cache.TestBeanCache.idsInFindMap(TestBeanCache.java:76)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:725)
	at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)
	at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)
	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140)
	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:84)
	at org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:214)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:210)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:135)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:66)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:41)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:155)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:41)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:155)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:35)
	at org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)
	at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:54)
	at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:107)
	at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:88)
	at org.junit.platform.launcher.core.EngineExecutionOrchestrator.lambda$execute$0(EngineExecutionOrchestrator.java:54)
	at org.junit.platform.launcher.core.EngineExecutionOrchestrator.withInterceptedStreams(EngineExecutionOrchestrator.java:67)
	at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:52)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:114)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:86)
	at org.junit.platform.launcher.core.DefaultLauncherSession$DelegatingLauncher.execute(DefaultLauncherSession.java:86)
	at org.junit.platform.launcher.core.SessionPerRequestLauncher.execute(SessionPerRequestLauncher.java:53)
	at com.intellij.junit5.JUnit5IdeaTestRunner.startRunnerWithArgs(JUnit5IdeaTestRunner.java:57)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)
	at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)
	at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235)
	at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)
Caused by: org.h2.jdbc.JdbcSQLDataException: Unerlaubter Wert "3" für Parameter "parameterIndex"
Invalid value "3" for parameter "parameterIndex" [90008-214]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:646)
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
	at org.h2.message.DbException.get(DbException.java:223)
	at org.h2.message.DbException.getInvalidValueException(DbException.java:298)
	at org.h2.jdbc.JdbcPreparedStatement.setParameter(JdbcPreparedStatement.java:1395)
	at org.h2.jdbc.JdbcPreparedStatement.setLong(JdbcPreparedStatement.java:678)
	at io.ebean.datasource.pool.ExtendedPreparedStatement.setLong(ExtendedPreparedStatement.java:223)
	at io.ebeaninternal.server.bind.DataBind.setLong(DataBind.java:129)
	at io.ebeaninternal.server.persist.Binder.bindSimpleData(Binder.java:271)
	... 85 more

Expected behavior

When strategy = GenerationType.IDENTITY is used, the @SequenceGenerator annotation and the generator parameter of @GeneratedValue annotation is ignored, which is a good thing, because these don't actually make much sense when not using sequences. I think the behavior should be the same if you use strategy = GenerationType.AUTO on a db that chooses IDENTITY as the strategy.

Actual behavior

If you use GenerationType.AUTO on a db that chooses IDENTITY as the strategy (so basically any db except Oracle) the @SequenceGenerator annotation is correctly ignored, but the generator param of @GeneratedValue is not, resulting in the "No custom IdGenerator registered with name <specified generator name>" exception.

Steps to reproduce

Define an entity like this and use it in a db which chooses the IDENTITY strategy for GenerationType.AUTO

@Entity
@DbName("ea")
@Table(name = "T_OBJECT")
class EaObject(
    @Id
    @Column(name = "OBJECT_ID", nullable = false)
    @GeneratedValue(
        strategy = GenerationType.AUTO,
        generator = "t_object_sequence_generator"
    )
    @SequenceGenerator(
        name = "t_object_sequence_generator",
        sequenceName = "OBJECT_ID_SEQ",
    )
    var id: Long = 0,
)

Caused by: java.lang.RuntimeException: Error reading annotations for cz.sentica.qwazar.ea.core.entities.EaObject
	at io.ebeaninternal.server.deploy.parse.ReadAnnotations.readInitial(ReadAnnotations.java:31)
	at io.ebeaninternal.server.deploy.BeanDescriptorManager.createDeployBeanInfo(BeanDescriptorManager.java:1168)
	at io.ebeaninternal.server.deploy.BeanDescriptorManager.readEntityDeploymentInitial(BeanDescriptorManager.java:641)
	at io.ebeaninternal.server.deploy.BeanDescriptorManager.deploy(BeanDescriptorManager.java:290)
	at io.ebeaninternal.server.core.InternalConfiguration.<init>(InternalConfiguration.java:129)
	at io.ebeaninternal.server.core.DefaultContainer.createServer(DefaultContainer.java:104)
	at io.ebeaninternal.server.core.DefaultContainer.createServer(DefaultContainer.java:29)
	at io.ebean.DatabaseFactory.createInternal(DatabaseFactory.java:136)
	at io.ebean.DatabaseFactory.create(DatabaseFactory.java:85)
Caused by: java.lang.IllegalStateException: No custom IdGenerator registered with name t_object_sequence_generator
	at io.ebeaninternal.server.deploy.parse.AnnotationFields.readGenValue(AnnotationFields.java:469)
	at io.ebeaninternal.server.deploy.parse.AnnotationFields.initIdentity(AnnotationFields.java:162)
	at io.ebeaninternal.server.deploy.parse.AnnotationFields.readField(AnnotationFields.java:136)
	at io.ebeaninternal.server.deploy.parse.AnnotationFields.parse(AnnotationFields.java:62)
	at io.ebeaninternal.server.deploy.parse.ReadAnnotations.readInitial(ReadAnnotations.java:29)
	... 126 more