all,
am getting followring exceptions.
init:
deps-module-jar:
deps-ear-jar:
deps-jar:
compile-single:
Jul 17, 2009 5:05:37 PM org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.2.5
Jul 17, 2009 5:05:38 PM org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
Jul 17, 2009 5:05:38 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : cglib
Jul 17, 2009 5:05:38 PM org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
Jul 17, 2009 5:05:38 PM org.hibernate.cfg.Configuration configure
INFO: configuring from resource: /hibernate.cfg.xml
Jul 17, 2009 5:05:38 PM org.hibernate.cfg.Configuration
getConfigurationInputStream
INFO: Configuration resource: /hibernate.cfg.xml
Jul 17, 2009 5:05:38 PM org.hibernate.cfg.Configuration addResource
INFO: Reading mappings from resource : Supplier.hbm.xml
Jul 17, 2009 5:05:38 PM org.hibernate.cfg.HbmBinder
bindRootPersistentClassCommonValues
INFO: Mapping class: com.myapp.struts.Supplier -> supplier
Jul 17, 2009 5:05:38 PM org.hibernate.cfg.Configuration addResource
INFO: Reading mappings from resource : Product.hbm.xml
Jul 17, 2009 5:05:38 PM org.hibernate.cfg.HbmBinder
bindRootPersistentClassCommonValues
INFO: Mapping class: com.myapp.struts.Product -> Product
Jul 17, 2009 5:05:38 PM org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
Jul 17, 2009 5:05:38 PM org.hibernate.cfg.HbmBinder bindCollectionSecondPass
INFO: Mapping collection: com.myapp.struts.Supplier.products -> Product
Jul 17, 2009 5:05:38 PM
org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
Jul 17, 2009 5:05:38 PM
org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 20
Jul 17, 2009 5:05:38 PM
org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
Jul 17, 2009 5:05:38 PM
org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.mysql.jdbc.Driver at URL:
jdbc:mysql://localhost:3306/hibernate
Jul 17, 2009 5:05:38 PM
org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=root, password=****}
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: MySQL, version: 5.0.27-community-nt
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.6
( Revision: ${svn.Revision} )
Jul 17, 2009 5:05:39 PM org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.MySQLDialect
Jul 17, 2009 5:05:39 PM org.hibernate.transaction.TransactionFactoryFactory
buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
Jul 17, 2009 5:05:39 PM
org.hibernate.transaction.TransactionManagerLookupFactory
getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of
read-write or transactional second-level cache is not recommended)
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): enabled
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 2
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory
createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
Jul 17, 2009 5:05:39 PM org.hibernate.hql.ast.ASTQueryTranslatorFactory
<init>
INFO: Using ASTQueryTranslatorFactory
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory
createCacheProvider
INFO: Cache provider: org.hibernate.cache.NoCacheProvider
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
Jul 17, 2009 5:05:39 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
Jul 17, 2009 5:05:39 PM org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
Jul 17, 2009 5:05:40 PM org.hibernate.impl.SessionFactoryObjectFactory
addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
---Using criteria with no restriction...
Jul 17, 2009 5:05:40 PM org.hibernate.util.JDBCExceptionReporter
logExceptions
WARNING: SQL Error: 1054, SQLState: 42S22
Jul 17, 2009 5:05:40 PM org.hibernate.util.JDBCExceptionReporter
logExceptions
SEVERE: Unknown column 'supplier0_.ID' in 'field list'
Jul 17, 2009 5:05:40 PM org.hibernate.event.def.DefaultLoadEventListener
onLoad
INFO: Error performing load command
org.hibernate.exception.SQLGrammarException: could not load an entity:
[com.myapp.struts.Supplier#1]
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1874)
at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
at
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3044)
at
org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
at
org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:98)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at
org.hibernate.impl.SessionImpl.immediateLoad(SessionImpl.java:836)
at
org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:66)
at
org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:111)
at
org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:150)
at
com.myapp.struts.Supplier$$EnhancerByCGLIB$$c12c84cb.getSupName(<generated>)
at Main.displayProductList(Main.java:34)
at Main.main(Main.java:24)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Unknown column 'supplier0_.ID' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)
... 15 more
Exception in thread "main" org.hibernate.exception.SQLGrammarException:
could not load an entity: [com.myapp.struts.Supplier#1]
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1874)
at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
at
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3044)
at
org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
at
org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:98)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at
org.hibernate.impl.SessionImpl.immediateLoad(SessionImpl.java:836)
at
org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:66)
at
org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:111)
at
org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:150)
at
com.myapp.struts.Supplier$$EnhancerByCGLIB$$c12c84cb.getSupName(<generated>)
at Main.displayProductList(Main.java:34)
at Main.main(Main.java:24)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Unknown column 'supplier0_.ID' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)
... 15 more
Java Result: 1
debug-single-main:
BUILD SUCCESSFUL (total time: 9 seconds)
Product.hbm.xml
<hibernate-mapping>
<class name="com.myapp.struts.Product">
<id name="id" type="int" column="ID">
<generator class="increment"/>
</id>
<property name="proName" type="string" column="P_NAME"/>
<property name="description" type="string" column="DESCRIPTION"/>
<property name="price" type="double" column="PRICE"/>
<many-to-one name="supplier" class="com.myapp.struts.Supplier"
column="SUPPLIERID"/>
</class>
</hibernate-mapping>
Supplier.hbm.xml
<hibernate-mapping>
<class name="com.myapp.struts.Supplier" table="supplier" >
<id name="id" type="int" column="ID">
<generator class="increment"/>
</id>
<property name="supName" column="S_NAME" type="java.lang.String"/>
<bag name="products" inverse="true" cascade="all,delete-orphan">
<key column="SUPPLIERID"/>
<one-to-many class="com.myapp.struts.Product"/>
</bag>
</class>
</hibernate-mapping>
MAIN.CLASS is
public static void main(String ar[]){
Session session = HibernateUtil.currentSession();
{
System.out.println("\n---Using criteria with no
restriction...");
Criteria cri = session.createCriteria(Product.class);
List resultList=cri.list();
displayProductList(resultList);
}
}
public static void displayProductList(List list){
Iterator itr = list.iterator();
if(!itr.hasNext()){
System.out.println("#### no product list ");
}
while(itr.hasNext()){
Product pro =(Product)itr.next();
String msg= pro.getSupplier().getSupName()+" \t"; //error at this line
msg=msg+pro.getProName()+" \t";
msg += pro.getPrice() + "\t";
msg += pro.getDescription();
System.out.println(msg);
}
}
i get above exception at String msg= pro.getSupplier().getSupName()+" \t";
please help
--
Thanks,
Shabarish.V
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Java EE (J2EE) Programming with Passion!" group.
To post to this group, send email to
java-ee-j2ee-programming-with-passion@googlegroups.com
To unsubscribe from this group, send email to
java-ee-j2ee-programming-with-passion-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en
-~----------~----~----~----~------~----~------~--~---
