Video: Banco de dados: MySQL, Migração - Curso JEE e JSE – Loja Virtual Completa – Parte 16

Dyego.. Parabéns pelas aulas. Estou começando a fazer elas agora.Cheguei até a esta. e estou com um erro quando faço o deploy para o MySQL. A maioria das tabelas criam normal. Porém a produto me dá erro e não estou conseguindo saber o que é... Ele nao consegue Criar a tabela.

Abaixo o log do Glassfish

INFO: Iniciado servidor desligado
INFO: RAR7094: __xa_jdbc_ra shutdown successful.
INFO: RAR7094: __ds_jdbc_ra shutdown successful.
INFO: JMXStartupService: Stopped JMXConnectorServer: service:jmx:rmi://Bruno-PC:8686/jndi/rmi://Bruno-PC:8686/jmxrmi
25/02/2011 15:18:34 com.sun.enterprise.glassfish.bootstrap.ASMain main
INFO: Launching GlassFish on Felix platform
Welcome to Felix
================
INFO: Perform lazy SSL initialization for the listener 'http-listener-2'
INFO: Starting Grizzly Framework 1.9.18-o - Fri Feb 25 15:18:38 BRT 2011
INFO: Starting Grizzly Framework 1.9.18-o - Fri Feb 25 15:18:38 BRT 2011
INFO: Grizzly Framework 1.9.18-o started in: 99ms listening on port 8080
INFO: Grizzly Framework 1.9.18-o started in: 63ms listening on port 8181
INFO: Grizzly Framework 1.9.18-o started in: 19ms listening on port 7676
INFO: Grizzly Framework 1.9.18-o started in: 45ms listening on port 3700
INFO: Grizzly Framework 1.9.18-o started in: 57ms listening on port 4848
INFO: GlassFish Server Open Source Edition 3.0.1 (22) startup time : Felix(2714ms) startup services(1142ms) total(3856ms)
INFO: Hibernate Validator bean-validator-3.0-JBoss-4.0.2
INFO: Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.
INFO: Binding RMI port to *:8686
INFO: Grizzly Framework 1.9.18-o started in: 5ms listening on port 8080
INFO: JMXStartupService: Started JMXConnector, JMXService URL = service:jmx:rmi://Bruno-PC:8686/jndi/rmi://Bruno-PC:8686/jmxrmi
INFO: Using com.sun.enterprise.transaction.jts.JavaEETransactionManagerJTSDelegate as the delegate
INFO: [Thread[GlassFish Kernel Main Thread,5,main]] started
INFO: {felix.fileinstall.poll (ms) = 5000, felix.fileinstall.dir = C:\Program Files\glassfish-3.0.1\glassfish\modules\autostart, felix.fileinstall.debug = 1, felix.fileinstall.bundles.new.start = true, felix.fileinstall.tmpdir = C:\Users\Bruno\AppData\Local\Temp\fileinstall-5258275085186790726, felix.fileinstall.filter = null}
INFO: {felix.fileinstall.poll (ms) = 5000, felix.fileinstall.dir = C:\Users\Bruno\.netbeans\6.9\config\GF3\domain1\autodeploy\bundles, felix.fileinstall.debug = 1, felix.fileinstall.bundles.new.start = true, felix.fileinstall.tmpdir = C:\Users\Bruno\AppData\Local\Temp\fileinstall-7828999039020585904, felix.fileinstall.filter = null}
INFO: Started bundle: file:/C:/Program%20Files/glassfish-3.0.1/glassfish/modules/autostart/osgi-web-container.jar
INFO: Perform lazy SSL initialization for the listener 'http-listener-2'
INFO: Grizzly Framework 1.9.18-o started in: 22ms listening on port 8181
INFO: Updating configuration from org.apache.felix.fileinstall-autodeploy-bundles.cfg
INFO: Installed C:\Program Files\glassfish-3.0.1\glassfish\modules\autostart\org.apache.felix.fileinstall-autodeploy-bundles.cfg
INFO: {felix.fileinstall.poll (ms) = 5000, felix.fileinstall.dir = C:\Users\Bruno\.netbeans\6.9\config\GF3\domain1\autodeploy\bundles, felix.fileinstall.debug = 1, felix.fileinstall.bundles.new.start = true, felix.fileinstall.tmpdir = C:\Users\Bruno\AppData\Local\Temp\fileinstall--5009583856117007191, felix.fileinstall.filter = null}
INFO: SEC1002: Security Manager is OFF.
INFO: Security startup service called
INFO: SEC1143: Loading policy provider com.sun.enterprise.security.provider.PolicyWrapper.
INFO: Realm admin-realm of classtype com.sun.enterprise.security.auth.realm.file.FileRealm successfully created.
INFO: Realm file of classtype com.sun.enterprise.security.auth.realm.file.FileRealm successfully created.
INFO: Realm certificate of classtype com.sun.enterprise.security.auth.realm.certificate.CertificateRealm successfully created.
INFO: Security service(s) started successfully....
INFO: Created HTTP listener http-listener-1 on port 8080
INFO: Created HTTP listener http-listener-2 on port 8181
INFO: Created HTTP listener admin-listener on port 4848
INFO: Created virtual server server
INFO: Created virtual server __asadmin
INFO: Virtual server server loaded system default web module
INFO: WS00018: Webservice Endpoint deployed
NewWebService listening at address at http://localhost:8080/Loja/NewWebServiceService
INFO: Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.
INFO: Portable JNDI names for EJB VendaSession : [java:global/Loja/VendaSession, java:global/Loja/VendaSession!br.com.loja.session.VendaSession]
INFO: Portable JNDI names for EJB UsuarioSession : [java:global/Loja/UsuarioSession, java:global/Loja/UsuarioSession!br.com.loja.session.UsuarioSession]
INFO: Loading EJBTimerService. Please wait.
INFO: Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.
INFO: [TimerBeanContainer] Created TimerBeanContainer: TimerBean
INFO: Portable JNDI names for EJB TimerBean : [java:global/ejb-timer-service-app/TimerBean, java:global/ejb-timer-service-app/TimerBean!com.sun.ejb.containers.TimerLocal]
INFO: EJB5109:EJB Timer Service started successfully for datasource [jdbc/__TimerPool]
INFO: ==> Restoring Timers ...
INFO: <== ... Timers Restored.
INFO: Loading application ejb-timer-service-app at /ejb-timer-service-app
INFO: Portable JNDI names for EJB ProdutoSession : [java:global/Loja/ProdutoSession!br.com.loja.session.ProdutoSession, java:global/Loja/ProdutoSession]
INFO: Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.
INFO: EclipseLink, version: Eclipse Persistence Services - 2.0.1.v20100213-r6600
INFO: file:/C:/Users/Bruno/Documents/NetBeansProjects/Loja/build/web/WEB-INF/classes/_LojaPU login successful
AVISO: Got SQLException executing statement "CREATE TABLE PRODUTO (ID INTEGER NOT NULL, CUSTO DECIMAL(38) NOT NULL, ESPEC VARCHAR(255) NOT NULL, ESTOQUE INTEGER NOT NULL, NOME VARCHAR(255) NOT NULL UNIQUE, CATEGORIA_ID INTEGER, PRIMARY KEY (ID))": java.sql.SQLException: Can't create table 'loja.produto' (errno: 121)
AVISO: Got SQLException executing statement "": java.sql.SQLException: Can not issue empty query.
AVISO: Got SQLException executing statement "CREATE TABLE CATEGORIA (ID INTEGER NOT NULL, ATIVA TINYINT(1) default 0, NOME VARCHAR(255) NOT NULL UNIQUE, PRIMARY KEY (ID))": java.sql.SQLException: Can't create table 'loja.categoria' (errno: 121)
AVISO: Got SQLException executing statement "": java.sql.SQLException: Can not issue empty query.
AVISO: Got SQLException executing statement "ALTER TABLE PRODUTO ADD CONSTRAINT FK_PRODUTO_CATEGORIA_ID FOREIGN KEY (CATEGORIA_ID) REFERENCES CATEGORIA (ID)": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'loja.produto' doesn't exist
AVISO: Got SQLException executing statement "ALTER TABLE ITENSVENDAS ADD CONSTRAINT FK_ITENSVENDAS_PRODUTO_ID FOREIGN KEY (PRODUTO_ID) REFERENCES PRODUTO (ID)": java.sql.SQLException: Can't create table 'loja.#sql-12f0_c' (errno: 150)
AVISO: Got SQLException executing statement "ALTER TABLE CALLONAVALIABLE ADD CONSTRAINT FK_CALLONAVALIABLE_PRODUTO_ID FOREIGN KEY (PRODUTO_ID) REFERENCES PRODUTO (ID)": java.sql.SQLException: Can't create table 'loja.#sql-12f0_c' (errno: 150)
AVISO: Got SQLException executing statement "CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'sequence' already exists
INFO: WELD-000900 1.0.1 (SP3)
INFO: Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.
INFO: Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.
INFO: EclipseLink, version: Eclipse Persistence Services - 2.0.1.v20100213-r6600
INFO: JTS5014: Recoverable JTS instance, serverId = [100]
INFO: file:/C:/Users/Bruno/.netbeans/6.9/config/GF3/domain1/applications/ejb-timer-service-app/WEB-INF/classes/___EJB__Timer__App login successful
INFO: Inicializando Mojarra 2.0.2 (FCS b10) para o contexto '/Loja'
INFO: Loading application Loja at /Loja
INFO: Loja was successfully deployed in 14.273 milliseconds.



Se puder me ajudar.. agradeço muito .. quero muito continuar com as aulas.

Abraços

No meu caso ele esta criando as tabelas com a egine MyISAM, que não da suporte a Fk, como configurar o dialeto para innodb

Olá Dyego, primeiramente gostaria de te dar os parabéns, estou ainda na aula 16 mas até agora está otimo o curso!!

Diego, estou acompanhando as aulas, porém estou ainda na Parte 16 e quando clico na oção Inplantar, ocorre este erro na aba (run-deploy):


init:
deps-module-jar:
deps-ear-jar:
deps-jar:
library-inclusion-in-archive:
library-inclusion-in-manifest:
compile:
compile-jsps:
Iniciando GlassFish Server 3.1
GlassFish Server 3.1 está em execução.
Deployment localizado em C:\NetBeans\Ecommer\EcommerceDevmedia\build\web
Initializing...
deploy?DEFAULT=C:\NetBeans\Ecommer\EcommerceDevmedia\build\web&name=EcommerceDevmedia&force=true falhou em GlassFish Server 3.1
Erro durante a implementação: Exceção ao implementar o aplicativo [EcommerceDevmedia] : org.xml.sax.SAXParseException: cvc-complex-type.2.3: Element 'persistence' cannot have character [children], because the type's content type is element-only.. Consulte o server.log para obter mais detalhes
C:\NetBeans\Ecommer\EcommerceDevmedia\nbproject\build-impl.xml:717:
O módulo não foi implementado.
at org.netbeans.modules.j2ee.deployment.devmodules.api.Deployment.deploy(Deployment.java:187)
at org.netbeans.modules.j2ee.ant.Deploy.execute(Deploy.java:106)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:390)
at org.apache.tools.ant.Target.performTasks(Target.java:411)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
at org.apache.tools.ant.module.bridge.impl.BridgeImpl.run(BridgeImpl.java:284)
at org.apache.tools.ant.module.run.TargetExecutor.run(TargetExecutor.java:539)
at org.netbeans.core.execution.RunClassThread.run(RunClassThread.java:154)
FALHA NA CONSTRUÇÃO (tempo total: 24 segundos)

Poderia me auxiliar?

Oi, minha migração esta com seguinte erro:
Erro de implementação:
1
Verifique o registro do servidor para maiores detalhes. at org.netbeans.modules.j2ee.deployment.devmodules.api.Deployment.deploy(Deployment.java:207)
at org.netbeans.modules.j2ee.ant.Deploy.execute(Deploy.java:106)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
at sun.reflect.GeneratedMethodAccessor110.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:390)
at org.apache.tools.ant.Target.performTasks(Target.java:411)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1397)
at org.apache.tools.ant.Project.executeTarget(Project.java:1366)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1249)
at org.apache.tools.ant.module.bridge.impl.BridgeImpl.run(BridgeImpl.java:281)
at org.apache.tools.ant.module.run.TargetExecutor.run(TargetExecutor.java:539)
at org.netbeans.core.execution.RunClassThread.run(RunClassThread.java:154)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 1
at org.netbeans.modules.glassfish.javaee.ResourceRegistrationHelper.getChangedData(ResourceRegistrationHelper.java:208)
at org.netbeans.modules.glassfish.javaee.ResourceRegistrationHelper.checkResources(ResourceRegistrationHelper.java:194)
at org.netbeans.modules.glassfish.javaee.ResourceRegistrationHelper.checkUpdateServerResources(ResourceRegistrationHelper.java:168)
at org.netbeans.modules.glassfish.javaee.ResourceRegistrationHelper.registerResourceDir(ResourceRegistrationHelper.java:123)
at org.netbeans.modules.glassfish.javaee.ResourceRegistrationHelper.deployResources(ResourceRegistrationHelper.java:94)
at org.netbeans.modules.glassfish.javaee.ResourceRegistrationHelper.deployResources(ResourceRegistrationHelper.java:88)
at org.netbeans.modules.glassfish.javaee.ide.FastDeploy.initialDeploy(FastDeploy.java:124)
at org.netbeans.modules.j2ee.deployment.impl.TargetServer.deploy(TargetServer.java:626)
at org.netbeans.modules.j2ee.deployment.devmodules.api.Deployment.deploy(Deployment.java:172)
... 16 more

Pode me ajudar?

Dyego estou fazendo meu TCC da faculdade seguindo suas Videos aulas Muito Boas. Mas nesta aula não consegui Criar as tabelas Tbem!

Dyego boa noite,

Estou gostando bastante das video aulas...

Mas estou com problemas na Migração para o mysql..

-----------------------------------------------------------
compile-jsps:
Implantando o driver: C:\Users\leo\.netbeans\7.1.2\config\GF3\domain1\lib\derbyclient.jar
Deployment localizado em C:\AcaiExpress\AcaiExpressEcommerce\build\web
Initializing...
deploy?DEFAULT=C:\AcaiExpress\AcaiExpressEcommerce\build\web&name=AcaiExpressEcommerce&contextroot=/AcaiExpressEcommerce&force=true falhou em GlassFish Server 3.1.2
Erro durante a implantação: Exception while preparing the app : Invalid resource : jdbc/ecommerce_mysql__pm. Consulte o server.log para obter informações detalhadas.
C:\AcaiExpress\AcaiExpressEcommerce\nbproject\build-impl.xml:725: O módulo não foi implementado.
Verifique o registro do servidor para mais detalhes.
FALHA NA CONSTRUÇÃO (tempo total: 29 segundos)

-----------------------------------------------------------

conseguiria me dizer o q ocorre... percebo que tb n consigo criar o driver do mysql.. n aparece na listagem... comparei classes.. fiz d tudo..

Aguardando ajuda..

abçs.