I use Hibernate 3.5.3, and Oracle 10g database
I have bean with following relation
@OneToMany
@JoinTable(name="dispenser_accounts",
joinColumns=@JoinColumn(name="terminal_id"),
inverseJoinColumns=@JoinColumn(name="dispenser_section_id"))
@MapKey(name="dispenserNumber")
private Map<Integer, DispenserAccount> activeDispensers = new HashMap<Integer, DispenserAccount>();
When I trying to fetch data from activeDispensers hibernate generate sql with wrong syntax
SQL Error: 907, SQLState: 42000
ORA-00907: missing right parenthesis
How to workaround this bug?
Thanks!