How to avoid cross join from hibernate generated sql

[Robo Fazak]

Hi,


I am trying to execute a HQL query

SELECT COUNT(V.id) FROM Vendor as V LEFT JOIN V.vendorType as VT WHERE V.activeInd='Y'

Hibernate generates the following query

select count(vendor0_.ID) as col_0_0_ from OPDS.VENDOR vendor0_, OPDS.VENDOR_TYPE vendortype1_ cross join OPDS.VENDOR_LU vendor2_ where vendor0_.VENDOR_TYPE_ID=vendortype1_.ID(+) and vendor0_.VENDOR_ID=vendor2_.ID and vendor0_.ACTIVE_IND='Y'

that causes the error in oracle : ORA-25156: old style outer join (+) cannot be used with ANSI joins

Please suggest a solution for this. I don't know why hibernate generates a cross join automatically.

class Vendor{
	@ManyToOne(fetch = FetchType.LAZY)
	@JoinColumn(name = "VENDOR_TYPE_ID")
	public VendorType getVendorType() {
		return this.vendorType;
	}

	public void setVendorType(VendorType vendorType) {
		this.vendorType = vendorType;
	}

        @ManyToOne(fetch = FetchType.LAZY)
	@JoinColumn(name = "VENDOR_ID", nullable = false)
	@NotNull
	public VendorLu getVendorLu() {
		return this.vendorLu;
	}

	public void setVendorLu(VendorLu vendorLu) {
		this.vendorLu = vendorLu;
	}
}

class VendorType{
    @OneToMany(fetch = FetchType.LAZY, mappedBy = "vendorType")
	public Set<Vendor> getVendors() {
		return this.vendors;
	}

	public void setVendors(Set<Vendor> vendors) {
		this.vendors = vendors;
	}
}

class VendorLu{
    @OneToMany(fetch = FetchType.LAZY, mappedBy = "vendorLu")
	public Set<Vendor> getVendors() {
		return this.vendors;
	}

	public void setVendors(Set<Vendor> vendors) {
		this.vendors = vendors;
	}
}

[Bill Gorder]

There is more than one Oracle Dialect are you using the correct one?
http://docs.jboss.org/hibernate/orm/3.5/api/org/hibernate/dialect/package-summary.html

Are you using the correct JDBC driver for Oracle? What version of Oracle and Hibernate are you using?