UTILIZANDO COMPONENTE TABELA - MAKER 3.6



  • Não consigo utilizar o componente tabela do maker 3.6, mesmo colocando todos os dados ( SQL e Cabeçalho ).

    Alguém pode me ajudar?


  • [quote="leoayres"]Não consigo utilizar o componente tabela do maker 3.6, mesmo colocando todos os dados ( SQL e Cabeçalho ).

    Alguém pode me ajudar?[/quote] Qual é o problema enfrentado? basta apenas inserir uma consulta no componente e definir as propriedades do cabeçalho. Posta aqui a pilha de erro.


  • Somente em um projeto eu não consigo.
    Erro: Table 'ctr pcr.tabela_sql' doesn't exist
    Exceção Gerada:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ctr pcr.tabela_sql' doesn't exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.Util.getInstance(Util.java:408)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2497)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2455)
    at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369)
    at com.mysql.jdbc.Field.getCollation(Field.java:446)
    at com.mysql.jdbc.ResultSetMetaData.isCaseSensitive(ResultSetMetaData.java:552)
    at com.sun.rowset.CachedRowSetImpl2.a(SourceFile:819)
    at com.sun.rowset.CachedRowSetImpl2.populate(SourceFile:743)
    at wfr.database.WFRResultSet.open(SourceFile:128)
    at wfr.database.DBConnection.getResultSet2(SourceFile:1118)
    at wfr.com.systems.system_rec.rules.WebrunFunctions.ebfSQLExecuteScrollQuery(WebrunFunctions.java:12932)
    at wfr.com.systems.system_rec.rules.WebrunFunctions.ebfOpenAdvancedQuery(WebrunFunctions.java:10147)
    at wfr.com.systems.system_rec.rules.TabelaObterRetornoDaConsultaAbrirConsulta.run(TabelaObterRetornoDaConsultaAbrirConsulta.java:70)
    at wfr.rules.WFRRule.start(SourceFile:761)
    at wfr.rules.WFRRule.callRule(SourceFile:681)
    at wfr.com.systems.system_rec.rules.TabelaObterRetornoDaConsulta.run(TabelaObterRetornoDaConsulta.java:191)
    at wfr.rules.WFRRule.start(SourceFile:761)
    at wfr.rules.WFRRule.call(SourceFile:1823)
    at wfr.rules.WFRRule.call(SourceFile:57)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    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)


  • [quote="maxep"]Somente em um projeto eu não consigo.
    Erro: Table 'ctr pcr.tabela_sql' doesn't exist
    Exceção Gerada:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ctr pcr.tabela_sql' doesn't exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.Util.getInstance(Util.java:408)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2497)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2455)
    at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369)
    at com.mysql.jdbc.Field.getCollation(Field.java:446)
    at com.mysql.jdbc.ResultSetMetaData.isCaseSensitive(ResultSetMetaData.java:552)
    at com.sun.rowset.CachedRowSetImpl2.a(SourceFile:819)
    at com.sun.rowset.CachedRowSetImpl2.populate(SourceFile:743)
    at wfr.database.WFRResultSet.open(SourceFile:128)
    at wfr.database.DBConnection.getResultSet2(SourceFile:1118)
    at wfr.com.systems.system_rec.rules.WebrunFunctions.ebfSQLExecuteScrollQuery(WebrunFunctions.java:12932)
    at wfr.com.systems.system_rec.rules.WebrunFunctions.ebfOpenAdvancedQuery(WebrunFunctions.java:10147)
    at wfr.com.systems.system_rec.rules.TabelaObterRetornoDaConsultaAbrirConsulta.run(TabelaObterRetornoDaConsultaAbrirConsulta.java:70)
    at wfr.rules.WFRRule.start(SourceFile:761)
    at wfr.rules.WFRRule.callRule(SourceFile:681)
    at wfr.com.systems.system_rec.rules.TabelaObterRetornoDaConsulta.run(TabelaObterRetornoDaConsulta.java:191)
    at wfr.rules.WFRRule.start(SourceFile:761)
    at wfr.rules.WFRRule.call(SourceFile:1823)
    at wfr.rules.WFRRule.call(SourceFile:57)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    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)[/quote] Observe que erro ocorre devido a inexistência da tabela. Certifique-se se essa tabela existe, ou insira uma como FR_ACAO para teste.

Log in to reply