Video: Busca - Sistema de Localização - Curso JEE e JSE – Loja Virtual Completa – Parte 73

Dyego, fiz um backup do código e restaurei em outra máquina porem agora estou com um erro de sql, poderia me ajudar?


-------------------
init:
deps-module-jar:
deps-ear-jar:
deps-jar:
check-rest-config-props:
generate-rest-config:
library-inclusion-in-archive:
library-inclusion-in-manifest:
compile:
compile-jsps:
Starting GlassFish Server 3.1
GlassFish Server 3.1 is running.
In-place deployment at C:\Users\Documents\NetBeansProjects\Ecommerce\build\web
Initializing...
deploy?DEFAULT=C:\Users\Documents\NetBeansProjects\Ecommerce\build\web&name=TUDOONLINE&force=true failed on GlassFish Server 3.1
Erro durante a implementação: Exception while loading the app : WELD-001408 Unsatisfied dependencies for type [UserFace] with qualifiers [@Default] at injection point [[field] @Inject private br.com.face.ProductFace.user]. Consulte o server.log para obter mais detalhes
PER01003: Deployment encountered SQL Exceptions:
PER01000: Got SQLException executing statement "CREATE TABLE CATEGORY (id INTEGER NOT NULL, ACTIVE TINYINT(1) default 0, NAME VARCHAR(255) NOT NULL UNIQUE, PRIMARY KEY (id))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'category' already exists
PER01000: Got SQLException executing statement "CREATE TABLE CREDITCARD (id INTEGER NOT NULL, DATEOFVALIDATION DATE NOT NULL, FLAG VARCHAR(255) NOT NULL, NAMEOFCARDOWNER VARCHAR(255) NOT NULL, NUMBER VARCHAR(255) NOT NULL, TIMES INTEGER NOT NULL, USEROF_id INTEGER, PRIMARY KEY (id))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'creditcard' already exists
PER01000: Got SQLException executing statement "CREATE TABLE ADDRESS (id INTEGER NOT NULL, ADDRESS VARCHAR(255) NOT NULL, COUNTRY VARCHAR(255) NOT NULL, NICKNAME VARCHAR(255) NOT NULL, NUMBER INTEGER NOT NULL, POSTALCODE VARCHAR(255) NOT NULL, STATEOFADDRESS VARCHAR(100) NOT NULL, userOf INTEGER, PRIMARY KEY (id))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'address' already exists
PER01000: Got SQLException executing statement "CREATE TABLE user (id INTEGER NOT NULL, EMAIL VARCHAR(255) NOT NULL, NAME VARCHAR(255) NOT NULL, PASSWORD VARCHAR(32) NOT NULL, USERNAME VARCHAR(255) NOT NULL, PRIMARY KEY (id))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'user' already exists
PER01000: Got SQLException executing statement "CREATE TABLE PRODUCT (id INTEGER NOT NULL, COST DECIMAL(38) NOT NULL, NAME VARCHAR(255) NOT NULL UNIQUE, PHOTOURL VARCHAR(255), SPEC VARCHAR(255) NOT NULL, STOCK INTEGER NOT NULL, CATEGORY_id INTEGER, PRIMARY KEY (id))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'product' already exists
PER01000: Got SQLException executing statement "CREATE TABLE SELL (id INTEGER NOT NULL, CLOSED TINYINT(1) default 0, DATEOFSELL DATE NOT NULL, STATUS VARCHAR(255) NOT NULL, TOTAL DECIMAL(38) NOT NULL, ADDRESSTOSEND_id INTEGER, CREDITCARD_id INTEGER, USEROF_id INTEGER, PRIMARY KEY (id))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'sell' already exists
PER01000: Got SQLException executing statement "CREATE TABLE SELLITEM (id INTEGER NOT NULL, QNT INTEGER NOT NULL, PRODUCT_id INTEGER, SELL_id INTEGER, PRIMARY KEY (id))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'sellitem' already exists
PER01000: Got SQLException executing statement "CREATE TABLE CALLONAVALIABLE (id INTEGER NOT NULL, CALLED TINYINT(1) default 0, EMAIL VARCHAR(255), PRODUCT_id INTEGER, PRIMARY KEY (id))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'callonavaliable' already exists
PER01000: Got SQLException executing statement "ALTER TABLE CREDITCARD ADD CONSTRAINT FK_CREDITCARD_USEROF_id FOREIGN KEY (USEROF_id) REFERENCES user (id)": java.sql.SQLException: Can't create table 'banco_tudoonline.#sql-718_395' (errno: 121)
PER01000: Got SQLException executing statement "ALTER TABLE ADDRESS ADD CONSTRAINT FK_ADDRESS_userOf FOREIGN KEY (userOf) REFERENCES user (id)": java.sql.SQLException: Can't create table 'banco_tudoonline.#sql-718_395' (errno: 121)
PER01000: Got SQLException executing statement "ALTER TABLE PRODUCT ADD CONSTRAINT FK_PRODUCT_CATEGORY_id FOREIGN KEY (CATEGORY_id) REFERENCES CATEGORY (id)": java.sql.SQLException: Can't create table 'banco_tudoonline.#sql-718_395' (errno: 121)
PER01000: Got SQLException executing statement "ALTER TABLE SELL ADD CONSTRAINT FK_SELL_ADDRESSTOSEND_id FOREIGN KEY (ADDRESSTOSEND_id) REFERENCES ADDRESS (id)": java.sql.SQLException: Can't create table 'banco_tudoonline.#sql-718_395' (errno: 121)
PER01000: Got SQLException executing statement "ALTER TABLE SELL ADD CONSTRAINT FK_SELL_CREDITCARD_id FOREIGN KEY (CREDITCARD_id) REFERENCES CREDITCARD (id)": java.sql.SQLException: Can't create table 'banco_tudoonline.#sql-718_395' (errno: 121)
PER01000: Got SQLException executing statement "ALTER TABLE SELL ADD CONSTRAINT FK_SELL_USEROF_id FOREIGN KEY (USEROF_id) REFERENCES user (id)": java.sql.SQLException: Can't create table 'banco_tudoonline.#sql-718_395' (errno: 121)
PER01000: Got SQLException executing statement "ALTER TABLE SELLITEM ADD CONSTRAINT FK_SELLITEM_PRODUCT_id FOREIGN KEY (PRODUCT_id) REFERENCES PRODUCT (id)": java.sql.SQLException: Can't create table 'banco_tudoonline.#sql-718_395' (errno: 121)
PER01000: Got SQLException executing statement "ALTER TABLE SELLITEM ADD CONSTRAINT FK_SELLITEM_SELL_id FOREIGN KEY (SELL_id) REFERENCES SELL (id)": java.sql.SQLException: Can't create table 'banco_tudoonline.#sql-718_395' (errno: 121)
PER01000: Got SQLException executing statement "ALTER TABLE CALLONAVALIABLE ADD CONSTRAINT FK_CALLONAVALIABLE_PRODUCT_id FOREIGN KEY (PRODUCT_id) REFERENCES PRODUCT (id)": java.sql.SQLException: Can't create table 'banco_tudoonline.#sql-718_395' (errno: 121)
PER01000: 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
PER01000: Got SQLException executing statement "INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values ('SEQ_GEN', 0)": com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'SEQ_GEN' for key 'PRIMARY'
C:\Users\Manoela\Documents\NetBeansProjects\TUDOONLINE\nbproject\build-impl.xml:730:
The module has not been deployed.
at org.netbeans.modules.j2ee.deployment.devmodules.api.Deployment.deploy(Deployment.java:210)
at org.netbeans.modules.j2ee.ant.Deploy.execute(Deploy.java:106)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
at sun.reflect.GeneratedMethodAccessor92.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:153)
BUILD FAILED (total time: 53 seconds)

[há +1 mês] - Responder