Мобильная версияКод: Выделить всё
EclipseLink, version: Eclipse Persistence Services - 4.0.2.v202306161219|#]
Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.2.v202306161219): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Error de sintaxis: Encountered "USER" at line 1, column 14.
Error Code: 30000
Call: CREATE TABLE USER (IDUSER BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL, ADDRESS VARCHAR(255), EMAIL VARCHAR(255), NAME VARCHAR(255), PASSWORD VARCHAR(255), PHONE INTEGER, ROL VARCHAR(255), USERNAME VARCHAR(255), PRIMARY KEY (IDUSER))
Query: DataModifyQuery(sql="CREATE TABLE USER (IDUSER BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL, ADDRESS VARCHAR(255), EMAIL VARCHAR(255), NAME VARCHAR(255), PASSWORD VARCHAR(255), PHONE INTEGER, ROL VARCHAR(255), USERNAME VARCHAR(255), P R I M A R Y K E Y ( I D U S E R ) ) " ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . e x c e p t i o n s . D a t a b a s e E x c e p t i o n . s q l E x c e p t i o n ( D a t a b a s e E x c e p t i o n . j a v a : 3 4 3 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . d a t a b a s e a c c e s s . D a t a b a s e A c c e s s o r . b a s i c E x e c u t e C a l l ( D a t a b a s e A c c e s s o r . j a v a : 7 0 2 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . d a t a b a s e a c c e s s . D a t a b a s e A c c e s s o r . e x e c u t e C a l l ( D a t a b a s e A c c e s s o r . j a v a : 5 6 9 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . s e s s i o n s . A b s t r a c t S e s s i o n . b a s i c E x e c u t e C a l l ( A b s t r a c t S e s s i o n . j a v a : 2 0 4 8 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . s e s s i o n s . s e r v e r . S e r v e r S e s s i o n . e x e c u t e C a l l ( S e r v e r S e s s i o n . j a v a : 6 1 1 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . q u e r i e s . D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . e x e c u t e C a l l ( D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . j a v a : 2 8 0 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . q u e r i e s . D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . e x e c u t e C a l l ( D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . j a v a : 2 6 6 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . q u e r i e s . D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . e x e c u t e N o S e l e c t C a l l ( D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . j a v a : 3 2 3 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . q u e r i e s . D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . e x e c u t e N o S e l e c t ( D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . j a v a : 2 9 4 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . q u e r i e s . D a t a M o d i f y Q u e r y . e x e c u t e D a t a b a s e Q u e r y ( D a t a M o d i f y Q u e r y . j a v a : 8 8 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . q u e r i e s . D a t a b a s e Q u e r y . e x e c u t e ( D a t a b a s e Q u e r y . j a v a : 9 1 3 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . s e s s i o n s . A b s t r a c t S e s s i o n . i n t e r n a l E x e c u t e Q u e r y ( A b s t r a c t S e s s i o n . j a v a : 3 3 0 8 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . s e s s i o n s . A b s t r a c t S e s s i o n . e x e c u t e Q u e r y ( A b s t r a c t S e s s i o n . j a v a : 1 8 4 1 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . s e s s i o n s . A b s t r a c t S e s s i o n . e x e c u t e Q u e r y ( A b s t r a c t S e s s i o n . j a v a : 1 8 2 3 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . s e s s i o n s . A b s t r a c t S e s s i o n . e x e c u t e Q u e r y ( A b s t r a c t S e s s i o n . j a v a : 1 7 7 3 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . s e s s i o n s . A b s t r a c t S e s s i o n . p r i v i l e d g e d E x e c u t e N o n S e l e c t i n g C a l l ( A b s t r a c t S e s s i o n . j a v a : 5 0 5 5 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . t o o l s . s c h e m a f r a m e w o r k . D a t a b a s e O b j e c t D e f i n i t i o n . c r e a t e O n D a t a b a s e ( D a t a b a s e O b j e c t D e f i n i t i o n . j a v a : 2 0 5 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . t o o l s . s c h e m a f r a m e w o r k . S c h e m a M a n a g e r . c r e a t e O b j e c t ( S c h e m a M a n a g e r . j a v a : 2 2 4 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . t o o l s . s c h e m a f r a m e w o r k . T a b l e C r e a t o r . c r e a t e T a b l e s ( T a b l e C r e a t o r . j a v a : 1 8 9 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . t o o l s . s c h e m a f r a m e w o r k . T a b l e C r e a t o r . c r e a t e T a b l e s ( T a b l e C r e a t o r . j a v a : 1 5 9 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . t o o l s . s c h e m a f r a m e w o r k . T a b l e C r e a t o r . c r e a t e T a b l e s ( T a b l e C r e a t o r . j a v a : 1 5 1 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . t o o l s . s c h e m a f r a m e w o r k . S c h e m a M a n a g e r . c r e a t e D e f a u l t T a b l e s ( S c h e m a M a n a g e r . j a v a : 1 0 3 4 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . j p a . E n t i t y M a n a g e r F a c t o r y P r o v i d e r . g e n e r a t e D e f a u l t T a b l e s ( E n t i t y M a n a g e r F a c t o r y P r o v i d e r . j a v a : 1 1 6 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . j p a . E n t i t y M a n a g e r S e t u p I m p l . w r i t e D D L T o D a t a b a s e ( E n t i t y M a n a g e r S e t u p I m p l . j a v a : 4 7 3 1 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . j p a . E n t i t y M a n a g e r S e t u p I m p l . w r i t e M e t a d a t a D D L T o D a t a b a s e ( E n t i t y M a n a g e r S e t u p I m p l . j a v a : 4 7 9 8 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . j p a . E n t i t y M a n a g e r S e t u p I m p l . w r i t e D D L ( E n t i t y M a n a g e r S e t u p I m p l . j a v a : 4 6 9 7 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . j p a . E n t i t y M a n a g e r S e t u p I m p l . w r i t e D D L ( E n t i t y M a n a g e r S e t u p I m p l . j a v a : 4 5 7 0 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . j p a . E n t i t y M a n a g e r S e t u p I m p l . d e p l o y ( E n t i t y M a n agerSetupImpl.java:816)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:221)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:199)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.getDatabaseSession(EntityManagerFactoryImpl.java:534)
at org.eclipse.persistence.jpa.PersistenceProvider.createContainerEntityManagerFactoryImpl(PersistenceProvider.java:385)
at org.eclipse.persistence.jpa.PersistenceProvider.createContainerEntityManagerFactory(PersistenceProvider.java:313)
at org.glassfish.persistence.jpa.PersistenceUnitLoader.loadPU(PersistenceUnitLoader.java:222)
at org.glassfish.persistence.jpa.PersistenceUnitLoader.(PersistenceUnitLoader.java:126)
at org.glassfish.persistence.jpa.JPADeployer$1.visitPUD(JPADeployer.java:318)
at org.glassfish.persistence.jpa.JPADeployer$PersistenceUnitDescriptorIterator.iteratePUDs(JPADeployer.java:545)
at org.glassfish.persistence.jpa.JPADeployer.createEMFs(JPADeployer.java:325)
at org.glassfish.persistence.jpa.JPADeployer.prepare(JPADeployer.java:168)
at com.sun.enterprise.v3.server.ApplicationLifecycle.prepareModule(ApplicationLifecycle.java:984)
at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:467)
at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:257)
at org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:471)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$2$1.run(CommandRunnerImpl.java:569)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$2$1.run(CommandRunnerImpl.java:565)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
at java.base/javax.security.auth.Subject.doAs(Subject.java:453)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$2.execute(CommandRunnerImpl.java:564)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$3.run(CommandRunnerImpl.java:595)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$3.run(CommandRunnerImpl.java:587)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
at java.base/javax.security.auth.Subject.doAs(Subject.java:453)
at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:586)
at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1477)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1846)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1722)
at com.sun.enterprise.v3.admin.AdminAdapter.doCommand(AdminAdapter.java:536)
at com.sun.enterprise.v3.admin.AdminAdapter.onMissingResource(AdminAdapter.java:223)
at org.glassfish.grizzly.http.server.StaticHttpHandlerBase.service(StaticHttpHandlerBase.java:150)
at com.sun.enterprise.v3.services.impl.ContainerMapper$HttpHandlerCallable.call(ContainerMapper.java:425)
at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:144)
at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:174)
at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:153)
at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:196)
at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:88)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:246)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:178)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:118)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:96)
at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:51)
at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:510)
at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:82)
at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:83)
at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:101)
at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:535)
at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:515)
at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: java.sql.SQLSyntaxErrorException: Error de sintaxis: Encountered "USER" at line 1, column 14.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:94)
at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:325)
at org.apache.derby.client.am.ClientConnection.prepareStatement(ClientConnection.java:448)
at com.sun.gjc.spi.base.ConnectionHolder.prepareStatement(ConnectionHolder.java:497)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1750)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1697)
at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:770)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:630)
... 75 more
Caused by: ERROR 42X01: Error de sintaxis: Encountered "USER" at line 1, column 14.
at org.apache.derby.client.am.ClientStatement.completeSqlca(ClientStatement.java:2116)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(NetStatementReply.java:579)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(NetStatementReply.java:145)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(NetStatementReply.java:54)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(StatementReply.java:41)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(NetStatement.java:156)
at org.apache.derby.client.am.ClientStatement.readPrepareDescribeOutput(ClientStatement.java:1702)
at org.apache.derby.client.am.ClientPreparedStatement.readPrepareDescribeInputOutput(ClientPreparedStatement.java:1914)
at org.apache.derby.client.am.ClientPreparedStatement.flowPrepareDescribeInputOutput(ClientPreparedStatement.java:1977)
at org.apache.derby.client.am.ClientPreparedStatement.prepare(ClientPreparedStatement.java:315)
at org.apache.derby.client.am.ClientConnection.prepareStatementX(ClientConnection.java:1956)
at org.apache.derby.client.am.ClientConnection.prepareStatement(ClientConnection.java:435)
... 80 more
|#]
Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.2.v202306161219): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Error de sintaxis: Encountered "ORDER" at line 1, column 14.
Error Code: 30000
Call: CREATE TABLE ORDER (IDORDER BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL, DATE TIMESTAMP, STATE VARCHAR(255), TOTAL FLOAT, idUser BIGINT, PRIMARY KEY (IDORDER))
Query: DataModifyQuery(sql="CREATE TABLE ORDER (IDORDER BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL, DATE TIMESTAMP, STATE VARCHAR(255), TOTAL FLOAT, idUser BIGINT, P R I M A R Y K E Y ( I D O R D E R ) ) " ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . e x c e p t i o n s . D a t a b a s e E x c e p t i o n . s q l E x c e p t i o n ( D a t a b a s e E x c e p t i o n . j a v a : 3 4 3 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . d a t a b a s e a c c e s s . D a t a b a s e A c c e s s o r . b a s i c E x e c u t e C a l l ( D a t a b a s e A c c e s s o r . j a v a : 7 0 2 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . d a t a b a s e a c c e s s . D a t a b a s e A c c e s s o r . e x e c u t e C a l l ( D a t a b a s e A c c e s s o r . j a v a : 5 6 9 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . s e s s i o n s . A b s t r a c t S e s s i o n . b a s i c E x e c u t e C a l l ( A b s t r a c t S e s s i o n . j a v a : 2 0 4 8 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . s e s s i o n s . s e r v e r . S e r v e r S e s s i o n . e x e c u t e C a l l ( S e r v e r S e s s i o n . j a v a : 6 1 1 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . q u e r i e s . D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . e x e c u t e C a l l ( D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . j a v a : 2 8 0 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . q u e r i e s . D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . e x e c u t e C a l l ( D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . j a v a : 2 6 6 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . q u e r i e s . D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . e x e c u t e N o S e l e c t C a l l ( D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . j a v a : 3 2 3 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . q u e r i e s . D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . e x e c u t e N o S e l e c t ( D a t a s o u r c e C a l l Q u e r y M e c h a n i s m . j a v a : 2 9 4 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . q u e r i e s . D a t a M o d i f y Q u e r y . e x e c u t e D a t a b a s e Q u e r y ( D a t a M o d i f y Q u e r y . j a v a : 8 8 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . q u e r i e s . D a t a b a s e Q u e r y . e x e c u t e ( D a t a b a s e Q u e r y . j a v a : 9 1 3 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . s e s s i o n s . A b s t r a c t S e s s i o n . i n t e r n a l E x e c u t e Q u e r y ( A b s t r a c t S e s s i o n . j a v a : 3 3 0 8 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . s e s s i o n s . A b s t r a c t S e s s i o n . e x e c u t e Q u e r y ( A b s t r a c t S e s s i o n . j a v a : 1 8 4 1 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . s e s s i o n s . A b s t r a c t S e s s i o n . e x e c u t e Q u e r y ( A b s t r a c t S e s s i o n . j a v a : 1 8 2 3 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . s e s s i o n s . A b s t r a c t S e s s i o n . e x e c u t e Q u e r y ( A b s t r a c t S e s s i o n . j a v a : 1 7 7 3 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . s e s s i o n s . A b s t r a c t S e s s i o n . p r i v i l e d g e d E x e c u t e N o n S e l e c t i n g C a l l ( A b s t r a c t S e s s i o n . j a v a : 5 0 5 5 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . t o o l s . s c h e m a f r a m e w o r k . D a t a b a s e O b j e c t D e f i n i t i o n . c r e a t e O n D a t a b a s e ( D a t a b a s e O b j e c t D e f i n i t i o n . j a v a : 2 0 5 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . t o o l s . s c h e m a f r a m e w o r k . S c h e m a M a n a g e r . c r e a t e O b j e c t ( S c h e m a M a n a g e r . j a v a : 2 2 4 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . t o o l s . s c h e m a f r a m e w o r k . T a b l e C r e a t o r . c r e a t e T a b l e s ( T a b l e C r e a t o r . j a v a : 1 8 9 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . t o o l s . s c h e m a f r a m e w o r k . T a b l e C r e a t o r . c r e a t e T a b l e s ( T a b l e C r e a t o r . j a v a : 1 5 9 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . t o o l s . s c h e m a f r a m e w o r k . T a b l e C r e a t o r . c r e a t e T a b l e s ( T a b l e C r e a t o r . j a v a : 1 5 1 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . t o o l s . s c h e m a f r a m e w o r k . S c h e m a M a n a g e r . c r e a t e D e f a u l t T a b l e s ( S c h e m a M a n a g e r . j a v a : 1 0 3 4 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . j p a . E n t i t y M a n a g e r F a c t o r y P r o v i d e r . g e n e r a t e D e f a u l t T a b l e s ( E n t i t y M a n a g e r F a c t o r y P r o v i d e r . j a v a : 1 1 6 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . j p a . E n t i t y M a n a g e r S e t u p I m p l . w r i t e D D L T o D a t a b a s e ( E n t i t y M a n a g e r S e t u p I m p l . j a v a : 4 7 3 1 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . j p a . E n t i t y M a n a g e r S e t u p I m p l . w r i t e M e t a d a t a D D L T o D a t a b a s e ( E n t i t y M a n a g e r S e t u p I m p l . j a v a : 4 7 9 8 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . j p a . E n t i t y M a n a g e r S e t u p I m p l . w r i t e D D L ( E n t i t y M a n a g e r S e t u p I m p l . j a v a : 4 6 9 7 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . j p a . E n t i t y M a n a g e r S e t u p I m p l . w r i t e D D L ( E n t i t y M a n a g e r S e t u p I m p l . j a v a : 4 5 7 0 ) < b r / > a t o r g . e c l i p s e . p e r s i s t e n c e . i n t e r n a l . j p a . E n t i t y M a n a g e r S e t u p I m p l . d e p l o y ( E n t i t y M a n agerSetupImpl.java:816)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:221)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:199)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.getDatabaseSession(EntityManagerFactoryImpl.java:534)
at org.eclipse.persistence.jpa.PersistenceProvider.createContainerEntityManagerFactoryImpl(PersistenceProvider.java:385)
at org.eclipse.persistence.jpa.PersistenceProvider.createContainerEntityManagerFactory(PersistenceProvider.java:313)
at org.glassfish.persistence.jpa.PersistenceUnitLoader.loadPU(PersistenceUnitLoader.java:222)
at org.glassfish.persistence.jpa.PersistenceUnitLoader.(PersistenceUnitLoader.java:126)
at org.glassfish.persistence.jpa.JPADeployer$1.visitPUD(JPADeployer.java:318)
at org.glassfish.persistence.jpa.JPADeployer$PersistenceUnitDescriptorIterator.iteratePUDs(JPADeployer.java:545)
at org.glassfish.persistence.jpa.JPADeployer.createEMFs(JPADeployer.java:325)
at org.glassfish.persistence.jpa.JPADeployer.prepare(JPADeployer.java:168)
at com.sun.enterprise.v3.server.ApplicationLifecycle.prepareModule(ApplicationLifecycle.java:984)
at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:467)
at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:257)
at org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:471)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$2$1.run(CommandRunnerImpl.java:569)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$2$1.run(CommandRunnerImpl.java:565)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
at java.base/javax.security.auth.Subject.doAs(Subject.java:453)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$2.execute(CommandRunnerImpl.java:564)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$3.run(CommandRunnerImpl.java:595)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$3.run(CommandRunnerImpl.java:587)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
at java.base/javax.security.auth.Subject.doAs(Subject.java:453)
at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:586)
at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1477)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1846)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1722)
at com.sun.enterprise.v3.admin.AdminAdapter.doCommand(AdminAdapter.java:536)
at com.sun.enterprise.v3.admin.AdminAdapter.onMissingResource(AdminAdapter.java:223)
at org.glassfish.grizzly.http.server.StaticHttpHandlerBase.service(StaticHttpHandlerBase.java:150)
at com.sun.enterprise.v3.services.impl.ContainerMapper$HttpHandlerCallable.call(ContainerMapper.java:425)
at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:144)
at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:174)
at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:153)
at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:196)
at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:88)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:246)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:178)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:118)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:96)
at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:51)
at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:510)
at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:82)
at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:83)
at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:101)
at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:535)
at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:515)
at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: java.sql.SQLSyntaxErrorException: Error de sintaxis: Encountered "ORDER" at line 1, column 14.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:94)
at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:325)
at org.apache.derby.client.am.ClientConnection.prepareStatement(ClientConnection.java:448)
at com.sun.gjc.spi.base.ConnectionHolder.prepareStatement(ConnectionHolder.java:497)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1750)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1697)
at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:770)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:630)
... 75 more
Caused by: ERROR 42X01: Error de sintaxis: Encountered "ORDER" at line 1, column 14.
at org.apache.derby.client.am.ClientStatement.completeSqlca(ClientStatement.java:2116)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(NetStatementReply.java:579)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(NetStatementReply.java:145)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(NetStatementReply.java:54)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(StatementReply.java:41)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(NetStatement.java:156)
at org.apache.derby.client.am.ClientStatement.readPrepareDescribeOutput(ClientStatement.java:1702)
at org.apache.derby.client.am.ClientPreparedStatement.readPrepareDescribeInputOutput(ClientPreparedStatement.java:1914)
at org.apache.derby.client.am.ClientPreparedStatement.flowPrepareDescribeInputOutput(ClientPreparedStatement.java:1977)
at org.apache.derby.client.am.ClientPreparedStatement.prepare(ClientPreparedStatement.java:315)
at org.apache.derby.client.am.ClientConnection.prepareStatementX(ClientConnection.java:1956)
at org.apache.derby.client.am.ClientConnection.prepareStatement(ClientConnection.java:435)
... 80 more
|#]
Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.2.v202306161219): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Error de sintaxis: Encountered "ORDER" at line 1, column 13.
Error Code: 30000
Call: ALTER TABLE ORDER ADD CONSTRAINT FK_ORDER_idUser FOREIGN KEY (idUser) REFERENCES USER (IDUSER)
Query: DataModifyQuery(sql="ALTER TABLE ORDER ADD CONSTRAINT FK_ORDER_idUser FOREIGN KEY (idUser) REFERENCES USER (IDUSER)")
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:343)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:702)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:569)
at А затем
Код: Выделить всё
Exception while invoking class com.sun.enterprise.web.WebApplication start method
java.lang.Exception: java.lang.IllegalStateException: ContainerBase.addChild: start: org.apache.catalina.LifecycleException: java.lang.IllegalStateException: CDI is not available
at com.sun.enterprise.web.WebApplication.start(WebApplication.java:116)
at org.glassfish.internal.data.EngineRef.start(EngineRef.java:97)
at org.glassfish.internal.data.ModuleInfo.start(ModuleInfo.java:262)
at org.glassfish.internal.data.ApplicationInfo.start(ApplicationInfo.java:353)
at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:533)
at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:257)
at org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:471)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$2$1.run(CommandRunnerImpl.java:569)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$2$1.run(CommandRunnerImpl.java:565)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
at java.base/javax.security.auth.Subject.doAs(Subject.java:453)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$2.execute(CommandRunnerImpl.java:564)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$3.run(CommandRunnerImpl.java:595)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$3.run(CommandRunnerImpl.java:587)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
at java.base/javax.security.auth.Subject.doAs(Subject.java:453)
at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:586)
at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1477)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1846)
at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1722)
at com.sun.enterprise.v3.admin.AdminAdapter.doCommand(AdminAdapter.java:536)
at com.sun.enterprise.v3.admin.AdminAdapter.onMissingResource(AdminAdapter.java:223)
at org.glassfish.grizzly.http.server.StaticHttpHandlerBase.service(StaticHttpHandlerBase.java:150)
at com.sun.enterprise.v3.services.impl.ContainerMapper$HttpHandlerCallable.call(ContainerMapper.java:425)
at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:144)
at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:174)
at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:153)
at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:196)
at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:88)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:246)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:178)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:118)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:96)
at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:51)
at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:510)
at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:82)
at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:83)
at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:101)
at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:535)Имейте в виду, что я студент первого курса колледжа, поэтому я совсем не опытен. Спасибо!
Подробнее здесь: https://stackoverflow.com/questions/791 ... e-addchild
