I've change the file hbm.xml llike this:
provider.hbm.xml:
<hibernate-mapping>
<class name="providerproducts.Provider" table="PROVIDER">
<id name="id" column="PROVIDER_ID">
<generator class="increment"/>
</id>
<property name="furnizor"/>
<property name="agent"/>
<property name="fix"/>
<property name="mobil"/>
<property name="web"/>
<set name="products">
<key column="PROVIDER_ID"
not-null="true"/>
<one-to-many class="providerproducts.Product"/>
</set>
</class>
</hibernate-mapping>
product.hbm.xml:
<hibernate-mapping>
<class name="providerproducts.Product" table="PRODUCTS">
<id name="id" column="PRODUCT_ID">
<generator class="increment"/>
</id>
<property name="produs"/>
<property name="pret" type="float"/>
<property name="cantitate" type="float"/>
<property name="data" type="timestamp" column="PRODUCT_DATE"/>
</class>
</hibernate-mapping>
and ProviderManager looks like this:
import java.util.Calendar;
import org.hibernate.*;
import providerproducts.Product;
import providerproducts.Provider;
public class ProviderManager {
private Calendar currentDate = Calendar.getInstance();
public static void main(String[] args) {
ProviderManager mgr = new ProviderManager();
// Long d = new Long(1);
try
{
mgr.createAndStoreProvider("Sanda","cucu","0256321425","0740253652","www.sanda.ro");
mgr.createAndStoreProduct("lapte",12,12);
mgr.createAndStoreProvider("Panda","cucu","0256321425","0740253652","www.sanda.ro");
mgr.createAndStoreProduct("lapte",42,13);
HibernateUtil.sessionFactory.close();
}
catch(Exception e)
{
System.out.print(e);
}
}
private void createAndStoreProvider(String furnizor, String agent, String fix, String mobil, String web) throws HibernateException{
Session session = HibernateUtil.currentSession();
Transaction tx = session.beginTransaction();
Provider theProvider = new Provider();
theProvider.setFurnizor(furnizor);
theProvider.setAgent(agent);
theProvider.setFix(fix);
theProvider.setMobil(mobil);
theProvider.setWeb(web);
session.save(theProvider);
tx.commit();
System.out.println("The provider ID: " + theProvider.getId());
HibernateUtil.closeSession();
}
private void createAndStoreProduct(String produs, float pret, float cantitate) throws HibernateException{
Session session = HibernateUtil.currentSession();
//System.out.println("*********************** BINE BINE *************************");
Transaction tx = session.beginTransaction();
Product theProduct = new Product();
// Provider tryProvider = new Provider();
//Provider aProvider = (Provider) session.load(Provider.class, tryProvider.getId());
theProduct.setProdus(produs);
theProduct.setPret(pret);
theProduct.setCantitate(cantitate);
theProduct.setData(currentDate.getTime());
//System.out.println("++++++++++++++++++++++++ BINE BINE +++++++++++++++++++++++++");
//aProvider.getProducts().add(theProduct);
//System.out.println("------------------------ BINE BINE --------------------------");
session.save(theProduct);
tx.commit();
//System.out.println("*********************** BINE BINE *************************");
HibernateUtil.closeSession();
}
}
Here is what is happening:
[javac] Compiling 5 source files to D:\wrk\ssta\workspace\ProviderHybernate\bin
run:
[java] 11:51:40,875 WARN Configurator:126 - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/D:/wrk/ssta/workspace/ProviderHybernate/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
[java] 11:51:41,640 ERROR SchemaExport:167 - Unsuccessful: create table PRODUCTS (PRODUCT_ID bigint not null, produs varchar(255), pret float, cantitate float, PRODUCT_DATE timestamp, PROVIDER_ID bigint not null, primary key (PRODUCT_ID))
[java] 11:51:41,640 ERROR SchemaExport:168 - Table 'products' already exists
[java] 11:51:41,640 ERROR SchemaExport:167 - Unsuccessful: create table PROVIDER (PROVIDER_ID bigint not null, furnizor varchar(255), agent varchar(255), fix varchar(255), mobil varchar(255), web varchar(255), primary key (PROVIDER_ID))
[java] 11:51:41,640 ERROR SchemaExport:168 - Table 'provider' already exists
[java] 11:51:41,765 ERROR SchemaExport:167 - Unsuccessful: alter table PRODUCTS add constraint FKF2D1C16494B72FB3 foreign key (PROVIDER_ID) references PROVIDER
[java] 11:51:41,765 ERROR SchemaExport:168 - Can't create table '.\provider_products\#sql-2f0_2c.frm' (errno: 150)
[java] Hibernate: insert into PROVIDER (furnizor, agent, fix, mobil, web, PROVIDER_ID) values (?, ?, ?, ?, ?, ?)
[java] The provider ID: 11
[java] org.hibernate.PropertyValueException: not-null property references a null or transient value: providerproducts.Product._productsBackref
So, I can't understand why in table PRODUCTS the field PROVIDER_ID how it is populate.... I have to make something in ProviderManager?
Thanks!
Login
FAQ
Search
