OpenXava / Discussion / Ayuda (Español): Error al crear Nueva organizacion

Gaston Garcia - 2017-04-12

Buenas Tardes

Tengo un error al intentar crear una nueva organizacion

Ha sido imposible ejecutar la acción Crear nueva organización: Imposible crear el esquema FAT en la base de datos

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Nelson Florez - 2017-04-12
  
  Hola Gaston, para ayudarte mejor es bueno que coloques la traza de errores, de esta forma se tiene una visión mas clara de lo que puede estar sucediendo.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gaston Garcia - 2017-04-19

Ahi va

GRAVE: Error obteniendo conexión
java.lang.ClassCastException: org.apache.naming.NamingContext cannot be cast to javax.sql.DataSource
at org.openxava.util.DataSourceConnectionProvider.getDataSource(DataSourceConnectionProvider.java:136)
at org.openxava.util.DataSourceConnectionProvider.getConnection(DataSourceConnectionProvider.java:165)
at com.openxava.naviox.util.Organizations.createSchema(Organizations.java:110)
at com.openxava.naviox.util.Organizations.create(Organizations.java:99)
at com.openxava.naviox.util.Organizations.create(Organizations.java:93)
at com.openxava.naviox.actions.CreateNewOrganizationAction.execute(CreateNewOrganizationAction.java:29)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:535)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:443)
at org.openxava.controller.ModuleManager.execute(ModuleManager.java:404)
at org.apache.jsp.xava.execute_jsp._jspService(execute_jsp.java:195)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
at org.openxava.web.servlets.Servlets.getURIAsStream(Servlets.java:72)
at org.openxava.web.dwr.Module.getURIAsStream(Module.java:214)
at org.openxava.web.dwr.Module.request(Module.java:62)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)
at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)
at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)
at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)
at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)
at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)
at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:409)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1044)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

abr 19, 2017 12:20:37 PM com.openxava.naviox.util.Organizations createSchema
GRAVE: Imposible crear el esquema NUEVA en la base de datos

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Javier Paniza - 2017-04-20

Hola Gaston:

Pon aquí el contenido de tu persistence.xml

Ayuda a otros en este foro como yo te ayudo a ti.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Ahi va
<?xml version="1.0" encoding="UTF-8"?>

<persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence <a href=" http:="" java.sun.com="" xml="" ns="" persistence="" persistence_1_0.xsd"="">http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" version="1.0">

    <persistence-unit name="default">
    <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>                 
    <properties>
        <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
        <property name="hibernate.connection.datasource" value="java://comp/env/jdbc/rankDS"/>
        <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>    
        <property name="hibernate.current_session_context_class" value="thread"/>
        <property name="hibernate.show_sql" value="true"/>    
        <property name="hibernate.hbm2ddl.auto" value="update"/>

    <!--
         <property name="hibernate.show_sql" value="true" />
        <property name="hibernate.hbm2ddl.auto" value="update"/>
        <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"
        />
        <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/rankmyse_rank"/>
        <property name="hibernate.connection.username" value="root" />
        <property name="hibernate.connection.password" value="" />          
        <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect"/> --> 
    </properties>
    </persistence-unit>

<!-- Tomcat + Hypersonic -->
<!-- <persistence-unit name="default">
    <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
    <non-jta-data-source>java://comp/env/jdbc/MySchoolDS</non-jta-data-source>
    <class>org.openxava.session.GalleryImage</class>
    <properties>
        <property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect"/>
    </properties>
</persistence-unit>    -->

<!-- JBoss + Hypersonic 
<persistence-unit name="default">
    <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
    <non-jta-data-source>java:/MiEscuelaDS</non-jta-data-source>
    <class>org.openxava.session.GalleryImage</class>
    <properties>
        <property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect"/>
    </properties>
</persistence-unit>    
-->

<!-- WebSphere + AS/400 
<persistence-unit name="default">
    <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
    <non-jta-data-source>jdbc/MiEscuelaDS</non-jta-data-source>
    <class>org.openxava.session.GalleryImage</class>
    <properties>
        <property name="hibernate.dialect" value="org.hibernate.dialect.DB2400Dialect"/>
        <property name="hibernate.show_sql" value="false"/>
    </properties>
</persistence-unit>
-->

<persistence-unit name="junit">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<properties>
<property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
<property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/rankmyse_rank"/>
<property name="hibernate.connection.username" value="root"/>
<property name="hibernate.connection.password" value=""/>
</properties>
</persistence-unit>

<!-- JUnit Hypersonic

<persistence-unit name="junit">
<provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
<properties>
<property name="hibernate.hbm2ddl.auto" value="create"/>
<property name="hibernate.show_sql" value="true"/>
<property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect"/>
<property name="hibernate.connection.release_mode" value="after_transaction"/>
<property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/rankmyse_rank"/>
<property name="hibernate.connection.username" value="root"/>
<property name="hibernate.connection.password" value=""/>
</properties>
</persistence-unit>
-->

</persistence>

Javier Paniza - 2017-04-25

Hola Gaston:

Elimina esta linea de tu persistence.xml:

<property name="hibernate.hbm2ddl.auto" value="update"/>

Y vuelvelo a probar. Dime que como te va.

----------
Ayuda a otros en este foro como yo te ayudo a ti.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gaston Garcia - 2017-04-25

Hola Javier..

No aun sigo con el mismo problema..

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Hola Gaston:

No me había fijado, tu unidad de persistencia no está bien definida. Prueba definirla así:

<persistence-unit name="default">
    <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
    <non-jta-data-source>java://comp/env/jdbc/rankDS</non-jta-data-source>
    <class>org.openxava.session.GalleryImage</class>
    <class>org.openxava.web.editors.AttachedFile</class>
    <class>org.openxava.web.editors.DiscussionComment</class>
    <properties>
        <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
        <property name="hibernate.show_sql" value="false"/>  
        <property name="hibernate.connection.release_mode" value="after_transaction"/> 
    </properties>
</persistence-unit>

----------
Ayuda a otros en este foro como yo te ayudo a ti.

Gaston Garcia - 2017-04-27

Hola Javier.. AHora si.. muchas pero muchas Gracias

Saludos

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Error al crear Nueva organizacion

Java platform for fast time-to-market of business applications

Forums

Help

Error al crear Nueva organizacion

Error al crear Nueva organizacion

Java platform for fast time-to-market of business applications

Forums

Help

Error al crear Nueva organizacion document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

Error al crear Nueva organizacion