Advertisement
Guest User

Untitled

a guest
Nov 18th, 2017
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.04 KB | None | 0 0
  1. @Entity
  2. @Table(name = "deportistas")
  3. public class Deportistas implements Serializable {
  4.  
  5. private static final long serialVersionUID = 1L;
  6.  
  7. @Id
  8. @GeneratedValue(strategy = GenerationType.IDENTITY)
  9. @Column(name = "codDeportista")
  10. private int codDeportista;
  11.  
  12. @Column(name = "nombreDeportista", columnDefinition = "VARCHAR(60)")
  13. private String nombreDeportista;
  14.  
  15. @Column(name = "dniDeportista", columnDefinition = "CHAR(12)")
  16. private String dniDeportista;
  17.  
  18. @Column(name = "pais", columnDefinition = "CHAR(4)")
  19. private String pais;
  20.  
  21. public int getCodDeportista() {
  22. return codDeportista;
  23. }
  24.  
  25. public void setCodDeportista(int codDeportista) {
  26. this.codDeportista = codDeportista;
  27. }
  28.  
  29. public String getNombreDeportista() {
  30. return nombreDeportista;
  31. }
  32.  
  33. public void setNombreDeportista(String nombreDeportista) {
  34. this.nombreDeportista = nombreDeportista;
  35. }
  36.  
  37. public String getDniDeportista() {
  38. return dniDeportista;
  39. }
  40.  
  41. public void setDniDeportista(String dniDeportista) {
  42. this.dniDeportista = dniDeportista;
  43. }
  44.  
  45. public String getPais() {
  46. return pais;
  47. }
  48.  
  49. public void setPais(String pais) {
  50. this.pais = pais;
  51. }
  52.  
  53. }
  54.  
  55. public class HibernateUtil {
  56.  
  57. private final SessionFactory sessionFactory = buildSessionFactory();
  58.  
  59. private SessionFactory buildSessionFactory() {
  60.  
  61. try {
  62. // Create the SessionFactory from hibernate.cfg.xml
  63. StandardServiceRegistry standardRegistry = new StandardServiceRegistryBuilder()
  64. .configure("hibernate.cfg.xml").build();
  65. Metadata metadata = new MetadataSources(standardRegistry).getMetadataBuilder().build();
  66. return metadata.getSessionFactoryBuilder().build();
  67.  
  68. } catch (Throwable ex) {
  69.  
  70. // Make sure you log the exception, as it might be swallowed
  71. System.err.println("Initial SessionFactory creation failed." + ex);
  72. throw new ExceptionInInitializerError(ex);
  73. }
  74. }
  75.  
  76. public SessionFactory getSessionFactory() {
  77. return sessionFactory;
  78. }
  79. }
  80.  
  81. <?xml version='1.0' encoding='utf-8'?>
  82. <!DOCTYPE hibernate-configuration PUBLIC
  83. "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
  84. "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
  85. <hibernate-configuration>
  86. <session-factory>
  87. <!-- Configuración de conexión a la base de datos -->
  88. <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
  89. <property name="connection.url">jdbc:mysql://localhost:3306/hibernateolimpiadas</property>
  90. <property name="connection.username">root</property>
  91. <property name="connection.password"></property>
  92. <!-- Pool de conexiones JDBC (se usa la que viene por defecto) -->
  93. <property name="connection.pool_size">1</property>
  94. <!-- Dialecto SQL -->
  95. <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
  96. <!-- Muestra en la consola todas las consultas SQL ejecutadas -->
  97. <property name="show_sql">true</property>
  98. <!-- Elimina y vuelve a crear el esquema de la base de datos al iniciar
  99. si siempre esta sin comentar cada vez que lo ejecuto crea las tablas para
  100. ello poner create-drop, si no quiero que vuelva a crear las tablas pondré
  101. update -->
  102. <property name="hbm2ddl.auto">create</property>
  103.  
  104. <!-- Mapea las siguientes clases anotadas si trabajásemos con mapeo XML
  105. en lugar de class pondríamos resource -->
  106. <mapping class="proyecto.Deportistas" />
  107.  
  108. </session-factory>
  109. </hibernate-configuration>
  110.  
  111. public class DataLoader {
  112.  
  113. private static HibernateUtil hibernate ;
  114. private static Session sesion ;
  115.  
  116. public static void main(String[] args) {
  117.  
  118. hibernate = new HibernateUtil();
  119. sesion = hibernate.getSessionFactory().openSession();
  120.  
  121. sesion.beginTransaction();
  122.  
  123. Deportistas d1 = new Deportistas();
  124. d1.setNombreDeportista("n1");
  125. d1.setDniDeportista("33.698.123-H");
  126. d1.setPais("HJKl");
  127.  
  128. sesion.save(d1);
  129.  
  130. sesion.getTransaction().commit();
  131. }
  132.  
  133. WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
  134. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
  135. at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
  136. at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlString(SchemaCreatorImpl.java:440)
  137. at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlStrings(SchemaCreatorImpl.java:424)
  138. at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:315)
  139. at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:166)
  140. at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:135)
  141. at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:121)
  142. at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:155)
  143. at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
  144. at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:313)
  145. at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:452)
  146. at main.HibernateUtil.buildSessionFactory(HibernateUtil.java:20)
  147. at main.HibernateUtil.<init>(HibernateUtil.java:11)
  148. at main.DataLoader.main(DataLoader.java:16)
  149. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'type=MyISAM' at line 1
  150. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  151. at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
  152. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
  153. at java.lang.reflect.Constructor.newInstance(Unknown Source)
  154. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  155. at com.mysql.jdbc.Util.getInstance(Util.java:408)
  156. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
  157. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
  158. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
  159. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
  160. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
  161. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2483)
  162. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2441)
  163. at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
  164. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
  165. at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
  166. ... 13 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement