API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 10th, 2016
96
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.89 KB | None | 0 0
raw download clone embed print report
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <!DOCTYPE hibernate-configuration SYSTEM
  3. "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
  4.  
  5.  
  6. <hibernate-configuration>
  7. <session-factory>
  8.  
  9. <property name="hibernate.dialect">
  10. org.hibernate.dialect.OracleDialect
  11. </property>
  12. <property name="hibernate.connection.driver_class">
  13. oracle.jdbc.driver.OracleDriver
  14. </property>
  15.  
  16. <property name="hibernate.connection.url">
  17. jdbc:oracle:thin:***
  18. </property>
  19. <property name="hibernate.connection.username">
  20. ***
  21. </property>
  22. <property name="hibernate.connection.password">
  23. ***
  24. </property>
  25.  
  26. <mapping resource="tutorialspoint/example/Pojo_Stock.hbm.xml" />
  27.  
  28. </session-factory>
  29. </hibernate-configuration>
  30.  
  31. package tutorialspoint.example;
  32.  
  33. public class Pojo_S {
  34.  
  35. int SId;
  36. String SCode;
  37. String SName;
  38.  
  39. public int getSId() {
  40. return SId;
  41. }
  42. public void setSId(int SId) {
  43. SId = SId;
  44. }
  45. public String getSCode() {
  46. return SCode;
  47. }
  48. public void setSCode(String SCode) {
  49. SCode = SCode;
  50. }
  51. public String getSName() {
  52. return SName;
  53. }
  54. public void setSName(String SName) {
  55. SName = SName;
  56. }
  57.  
  58. }
  59.  
  60. <?xml version="1.0" encoding="utf-8"?>
  61. <!DOCTYPE hibernate-mapping PUBLIC
  62. "-//Hibernate/Hibernate Mapping DTD//EN"
  63. "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
  64.  
  65.  
  66. <hibernate-mapping>
  67. <class name="tutorialspoint.example.Pojo_S" table="S">
  68.  
  69. <id name="SId" type="int" column="S_ID">
  70. <generator class="native" />
  71. </id>
  72. <property name="SCode" column="S_CODE" type="string" />
  73. <property name="SName" column="S_NAME" type="string" />
  74.  
  75. </class>
  76. </hibernate-mapping>
  77.  
  78. package tutorialspoint.example;
  79.  
  80. import java.util.Iterator;
  81. import java.util.List;
  82.  
  83. import org.hibernate.HibernateException;
  84. import org.hibernate.Session;
  85. import org.hibernate.SessionFactory;
  86. import org.hibernate.Transaction;
  87. import org.hibernate.cfg.Configuration;
  88.  
  89. public class MainApp {
  90.  
  91. private static SessionFactory factory;
  92. public static void main(String[] args) {
  93. try{
  94. System.out.println("In Main method of MainApp...");
  95.  
  96. Configuration configure=new Configuration();
  97. configure.configure("hibernate.cfg.xml");
  98. factory = configure.buildSessionFactory();
  99.  
  100. MainApp mainApp = new MainApp();
  101. mainApp.listDetails_S();
  102. }
  103. catch(Throwable ex){
  104.  
  105. System.err.println("Failed to create sessionFactory object." + ex);
  106. throw new ExceptionInInitializerError(ex);
  107.  
  108. }
  109. }
  110.  
  111. public void listDetails_S(){
  112. System.out.println("In listDetails_S method of MainApp...");
  113.  
  114. Session session = factory.openSession();
  115. Transaction tx = null;
  116.  
  117. try{
  118.  
  119. List details = session.createQuery("FROM S").list();
  120. for (Iterator iterator = details.iterator(); iterator.hasNext();){
  121. Pojo_S detail = (Pojo_S) iterator.next();
  122. System.out.print("nSId: " + detail.getSId());
  123. System.out.print("nSCode: " + detail.getSCode());
  124. System.out.print("nSName: " + detail.getSName());
  125. }
  126. tx.commit();
  127. }
  128.  
  129.  
  130. catch (HibernateException e) {
  131. if (tx!=null) tx.rollback();
  132. e.printStackTrace();
  133. }finally {
  134. session.close();
  135. }
  136.  
  137. In Main method of MainApp...
  138. Mar 10, 2016 12:06:11 PM org.hibernate.cfg.Environment <clinit>
  139. INFO: Hibernate 3.2 cr4
  140. Mar 10, 2016 12:06:11 PM org.hibernate.cfg.Environment <clinit>
  141. INFO: hibernate.properties not found
  142. Mar 10, 2016 12:06:11 PM org.hibernate.cfg.Environment buildBytecodeProvider
  143. INFO: Bytecode provider name : cglib
  144. Mar 10, 2016 12:06:11 PM org.hibernate.cfg.Environment <clinit>
  145. INFO: using JDK 1.4 java.sql.Timestamp handling
  146. Mar 10, 2016 12:06:11 PM org.hibernate.cfg.Configuration configure
  147. INFO: configuring from resource: hibernate.cfg.xml
  148. Mar 10, 2016 12:06:11 PM org.hibernate.cfg.Configuration getConfigurationInputStream
  149. INFO: Configuration resource: hibernate.cfg.xml
  150. Mar 10, 2016 12:06:11 PM org.hibernate.cfg.Configuration addResource
  151. INFO: Reading mappings from resource: tutorialspoint/example/Pojo_S.hbm.xml
  152. Mar 10, 2016 12:06:11 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
  153. INFO: Mapping class: tutorialspoint.example.Pojo_S -> S
  154. Mar 10, 2016 12:06:11 PM org.hibernate.cfg.Configuration doConfigure
  155. INFO: Configured SessionFactory: null
  156. Mar 10, 2016 12:06:12 PM org.hibernate.connection.DriverManagerConnectionProvider configure
  157. INFO: Using Hibernate built-in connection pool (not for production use!)
  158. Mar 10, 2016 12:06:12 PM org.hibernate.connection.DriverManagerConnectionProvider configure
  159. INFO: Hibernate connection pool size: 20
  160. Mar 10, 2016 12:06:12 PM org.hibernate.connection.DriverManagerConnectionProvider configure
  161. INFO: autocommit mode: false
  162. Mar 10, 2016 12:06:12 PM org.hibernate.connection.DriverManagerConnectionProvider configure
  163. INFO: using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:****
  164. Mar 10, 2016 12:06:12 PM org.hibernate.connection.DriverManagerConnectionProvider configure
  165. INFO: connection properties: {user=***, password=****}
  166. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  167. INFO: RDBMS: Oracle, version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  168. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
  169. Data Mining and Real Application Testing options
  170. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  171. INFO: JDBC driver: Oracle JDBC driver, version: 11.2.0.2.0
  172. Mar 10, 2016 12:06:41 PM org.hibernate.dialect.Dialect <init>
  173. INFO: Using dialect: org.hibernate.dialect.OracleDialect
  174. Mar 10, 2016 12:06:41 PM org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
  175. INFO: Using default transaction strategy (direct JDBC transactions)
  176. Mar 10, 2016 12:06:41 PM org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
  177. INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
  178. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  179. INFO: Automatic flush during beforeCompletion(): disabled
  180. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  181. INFO: Automatic session close at end of transaction: disabled
  182. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  183. INFO: JDBC batch size: 15
  184. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  185. INFO: JDBC batch updates for versioned data: disabled
  186. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  187. INFO: Scrollable result sets: enabled
  188. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  189. INFO: JDBC3 getGeneratedKeys(): disabled
  190. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  191. INFO: Connection release mode: auto
  192. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  193. INFO: Default batch fetch size: 1
  194. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  195. INFO: Generate SQL with comments: disabled
  196. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  197. INFO: Order SQL updates by primary key: disabled
  198. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
  199. INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
  200. Mar 10, 2016 12:06:41 PM org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
  201. INFO: Using ASTQueryTranslatorFactory
  202. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  203. INFO: Query language substitutions: {}
  204. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  205. INFO: JPA-QL strict compliance: disabled
  206. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  207. INFO: Second-level cache: enabled
  208. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  209. INFO: Query cache: disabled
  210. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory createCacheProvider
  211. INFO: Cache provider: org.hibernate.cache.NoCacheProvider
  212. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  213. INFO: Optimize cache for minimal puts: disabled
  214. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  215. INFO: Structured second-level cache entries: disabled
  216. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  217. INFO: Statistics: disabled
  218. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  219. INFO: Deleted entity synthetic identifier rollback: disabled
  220. Mar 10, 2016 12:06:41 PM org.hibernate.cfg.SettingsFactory buildSettings
  221. INFO: Default entity-mode: pojo
  222. Mar 10, 2016 12:06:41 PM org.hibernate.impl.SessionFactoryImpl <init>
  223. INFO: building session factory
  224. In listDetails_S method of MainApp...
  225. Mar 10, 2016 12:06:41 PM org.hibernate.impl.SessionFactoryObjectFactory addInstance
  226. INFO: Not binding factory to JNDI, no JNDI name configured
  227. org.hibernate.hql.ast.QuerySyntaxException: S is not mapped [FROM S]
  228. at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:158)
  229. at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:87)
  230. at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:70)
  231. at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:265)
  232. at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3056)
  233. at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945)
  234. at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
  235. at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544)
  236. at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
  237. at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
  238. at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228)
  239. at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160)
  240. at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
  241. at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
  242. at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
  243. at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
  244. at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
  245. at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
  246. at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
  247. at tutorialspoint.example.MainApp.listDetails_S(MainApp.java:42)
  248. at tutorialspoint.example.MainApp.main(MainApp.java:24)
  249. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!