P2
The following query does not set the query type to TYPE_READONLY when creating the statement in the EoD RI
@Select(sql="select firstName, lastName, teamname from players " +
>> "join teamroster on teamroster.playerid= players.id " +
>> "join teams on teamroster.teamid= teams.id " +
>> "where teamid = 1 order by teamname", readOnly=true)
@Select(sql="select firstName, lastName, teamname from players " +
>> "join teamroster on teamroster.playerid= players.id " +
>> "join teams on teamroster.teamid= teams.id " +
>> "where teamid = 1 order by teamname", readOnly=true)