eduveks
/
loja
1
0
Fork 0
Code Issues 0 Pull Requests 0 Projects 0 Releases 0 Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2 Commits
1 Branch
1.2 MiB
 
Branch: master
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
loja/dbs/loja.trace.db

147 lines
9.5 KiB
Raw Permalink Blame History

2023-03-30 20:59:01 jdbc[3]: exception
org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "produto.price" not found; SQL statement:
SELECT
cliente.nome AS cliente,
encomenda.numero AS encomenda,
produto.nome AS produto,
produto.price,
pagamento.nome AS pagamento
FROM cliente
INNER JOIN encomenda ON cliente.id = encomenda.cliente_id
INNER JOIN pagamento ON encomenda.pagamento_id = pagamento.id
INNER JOIN encomenda_produto ON encomenda.id = encomenda_produto.encomenda_id
INNER JOIN produto ON encomenda_produto.produto_id = produto.id [42122-214]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at org.h2.message.DbException.get(DbException.java:223)
at org.h2.message.DbException.get(DbException.java:199)
at org.h2.expression.ExpressionColumn.getColumnException(ExpressionColumn.java:244)
at org.h2.expression.ExpressionColumn.optimizeOther(ExpressionColumn.java:226)
at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:213)
at org.h2.command.query.Select.optimizeExpressionsAndPreserveAliases(Select.java:1285)
at org.h2.command.query.Select.prepareExpressions(Select.java:1167)
at org.h2.command.query.Query.prepare(Query.java:218)
at org.h2.command.Parser.prepareCommand(Parser.java:575)
at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631)
at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:92)
at org.netuno.tritao.dev.Query._main(SourceFile:58)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.netuno.proteu.Run.execute(SourceFile:119)
at org.netuno.proteu.DynamicURL.build(SourceFile:169)
at org.netuno.proteu.Enterprise.processRequest(SourceFile:417)
at org.netuno.proteu.Enterprise.service(SourceFile:489)
at javax.servlet.http.HttpServlet.service(SourceFile:750)
at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(SourceFile:1450)
at org.eclipse.jetty.servlet.ServletHolder.handle(SourceFile:799)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(SourceFile:554)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(SourceFile:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SourceFile:600)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(SourceFile:127)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(SourceFile:235)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SourceFile:1624)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(SourceFile:233)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(SourceFile:1440)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(SourceFile:188)
at org.eclipse.jetty.servlet.ServletHandler.doScope(SourceFile:505)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SourceFile:1594)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(SourceFile:186)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(SourceFile:1355)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(SourceFile:141)
at org.eclipse.jetty.server.handler.HandlerList.handle(SourceFile:59)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(SourceFile:127)
at org.eclipse.jetty.server.Server.handle(SourceFile:516)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(SourceFile:487)
at org.eclipse.jetty.server.HttpChannel.dispatch(SourceFile:732)
at org.eclipse.jetty.server.HttpChannel.handle(SourceFile:479)
at org.eclipse.jetty.server.HttpConnection.onFillable(SourceFile:277)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(SourceFile:311)
at org.eclipse.jetty.io.FillInterest.fillable(SourceFile:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(SourceFile:104)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(SourceFile:338)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(SourceFile:315)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(SourceFile:173)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(SourceFile:131)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(SourceFile:409)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(SourceFile:883)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(SourceFile:1034)
at java.base/java.lang.Thread.run(Thread.java:833)
2023-03-30 21:00:05 jdbc[3]: exception
org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "tipo.nome" not found; SQL statement:
SELECT
cliente.nome AS cliente,
encomenda.numero AS encomenda,
produto.nome AS produto,
tipo.nome AS tipo,
produto.preco,
pagamento.nome AS pagamento
FROM cliente
INNER JOIN encomenda ON cliente.id = encomenda.cliente_id
INNER JOIN pagamento ON encomenda.pagamento_id = pagamento.id
INNER JOIN encomenda_produto ON encomenda.id = encomenda_produto.encomenda_id
INNER JOIN produto ON encomenda_produto.produto_id = produto.id
INNER JOIN produto_tipo ON produto.tipo_id = produto_tipo.id [42122-214]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at org.h2.message.DbException.get(DbException.java:223)
at org.h2.message.DbException.get(DbException.java:199)
at org.h2.expression.ExpressionColumn.getColumnException(ExpressionColumn.java:244)
at org.h2.expression.ExpressionColumn.optimizeOther(ExpressionColumn.java:226)
at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:213)
at org.h2.expression.Alias.optimize(Alias.java:52)
at org.h2.command.query.Select.optimizeExpressionsAndPreserveAliases(Select.java:1285)
at org.h2.command.query.Select.prepareExpressions(Select.java:1167)
at org.h2.command.query.Query.prepare(Query.java:218)
at org.h2.command.Parser.prepareCommand(Parser.java:575)
at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631)
at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:92)
at org.netuno.tritao.dev.Query._main(SourceFile:58)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.netuno.proteu.Run.execute(SourceFile:119)
at org.netuno.proteu.DynamicURL.build(SourceFile:169)
at org.netuno.proteu.Enterprise.processRequest(SourceFile:417)
at org.netuno.proteu.Enterprise.service(SourceFile:489)
at javax.servlet.http.HttpServlet.service(SourceFile:750)
at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(SourceFile:1450)
at org.eclipse.jetty.servlet.ServletHolder.handle(SourceFile:799)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(SourceFile:554)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(SourceFile:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SourceFile:600)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(SourceFile:127)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(SourceFile:235)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SourceFile:1624)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(SourceFile:233)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(SourceFile:1440)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(SourceFile:188)
at org.eclipse.jetty.servlet.ServletHandler.doScope(SourceFile:505)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SourceFile:1594)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(SourceFile:186)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(SourceFile:1355)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(SourceFile:141)
at org.eclipse.jetty.server.handler.HandlerList.handle(SourceFile:59)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(SourceFile:127)
at org.eclipse.jetty.server.Server.handle(SourceFile:516)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(SourceFile:487)
at org.eclipse.jetty.server.HttpChannel.dispatch(SourceFile:732)
at org.eclipse.jetty.server.HttpChannel.handle(SourceFile:479)
at org.eclipse.jetty.server.HttpConnection.onFillable(SourceFile:277)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(SourceFile:311)
at org.eclipse.jetty.io.FillInterest.fillable(SourceFile:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(SourceFile:104)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(SourceFile:338)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(SourceFile:315)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(SourceFile:173)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(SourceFile:131)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(SourceFile:409)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(SourceFile:883)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(SourceFile:1034)
at java.base/java.lang.Thread.run(Thread.java:833)