how does SpringDataJpa call a stored procedure without an OUT parameter through Repository?
this is how my stored procedure is defined
@Entity
@NamedStoredProcedureQuery(
name = "Markets.nearById",
procedureName = "nearbyMarketId",
resultClasses = [AccountMarketsEntity::class],
parameters = [
StoredProcedureParameter(name = "latitude", mode = ParameterMode.IN, type = BigDecimal::class),
StoredProcedureParameter(name = "longitude", mode = ParameterMode.IN, type = BigDecimal::class)
]
)
@Table(name = "account_markets")
@DynamicInsert
@DynamicUpdate
class AccountMarketsEntity()
-sharp Repository
@Procedure(name = "Markets.nearBy")
fun retrieveNearbyMarketByLocation(@Param("latitude") latitude: BigDecimal, @Param("longitude") longitude: BigDecimal): AccountMarketsEntity?
when executing the program, the retrieveNearbyMarketByLocation method is queried as a method, indicating that AccountMarketsEntity does not have the attribute retrieveNearbyMarketByLocation