spring data question ``` interface InserterPacket1...

# spring

[xenoterracide]

spring data question

interface InserterPacket100hz {
    fun myInsertAll(list: Collection<Packet100hz> )
}
interface Packet100hzRepo: CrudRepository<Packet100hz, RFID>, InserterPacket100hz

@Repository
internal class Packet100HzInsertImpl(private val jdbc: JdbcTemplate): InserterPacket100hz {

    override fun myInsertAll(list: Collection<Packet100hz>) {
        var sql = "INSERT INTO packet_100hz_secure (rfid, pressure_signal, uo_pressure, chamber_pressure, ultrasonic_signal, \"timestamp\") VALUES "
        for (packet100hz in list) {
            // 6 cols
            sql += "(?, ?, ?, ?, ?, ?)\n" // maybe should use string builder
        }
        val inserts = list.flatMap {
            listOf(
                it.rfid.rfid,
                it.pressureSignal,
                it.uoPressure,
                it.chamberPressure,
                it.ultrasonicSignal,
                it.rfid.timestamp
            )
        }.toTypedArray()
        jdbc.update( sql, inserts )
    }
}

Caused by: org.springframework.data.mapping.PropertyReferenceException: No property myInsertAll found for type Packet100hz!

… well no duh spring… trying to do a custom repository implementation, anyone know what I’m doing wrong?

[tjb]

@xenoterracide interface Packet100hzRepo: CrudRepository<Packet100hz, RFID>, InserterPacket100hz shouldnt this have the @Repository annotation?

[tjb]

also i do not think you need the @Component annotation 🤔

[xenoterracide]

tried that same error 😕

[tjb]

and removed the component annotation?

[tjb]

oh no no

[tjb]

sec

[tjb]

interface InserterPacket100hz {
    fun myInsertAll(list: Collection<Packet100hz> )
}

@Repository
interface Packet100hzRepo: CrudRepository<Packet100hz, RFID>, InserterPacket100hz

internal class Packet100HzInsertImpl(private val jdbc: JdbcTemplate): InserterPacket100hz {

    override fun myInsertAll(list: Collection<Packet100hz>) {
        var sql = "INSERT INTO packet_100hz_secure (rfid, pressure_signal, uo_pressure, chamber_pressure, ultrasonic_signal, \"timestamp\") VALUES "
        for (packet100hz in list) {
            // 6 cols
            sql += "(?, ?, ?, ?, ?, ?)\n" // maybe should use string builder
        }
        val inserts = list.flatMap {
            listOf(
                it.rfid.rfid,
                it.pressureSignal,
                it.uoPressure,
                it.chamberPressure,
                it.ultrasonicSignal,
                it.rfid.timestamp
            )
        }.toTypedArray()
        jdbc.update( sql, inserts )
    }
}

[tjb]

try this @xenoterracide

[tjb]

also you can try removing the internal keyword…but i am not 100% sure on that one

[xenoterracide]

tried both of those things 😕

[xenoterracide]

and splitting the file

[xenoterracide]

looks like it has to be InterfaceNameImpl exactly

[xenoterracide]

and not a bean

[corneil]

Have a look at https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/jdbc/core/JdbcTemplate.html#batchUpdate-java.lang.String-java.util.List-

[xenoterracide]

@corneil yeah I saw that, do you know if it does the multi-value insert like I’m doing? or is it just doing like 100 inserts in a cleaner way?

[corneil]

batchUpdate can be used to insert many rows in a batch. It is very efficient and doesn't rely on concatenating a statement and ending up with 100s or 1000s of parameters.