majinju / kettle-manager Goto Github PK
View Code? Open in Web Editor NEW专门为kettle这款优秀的ETL工具开发的web端管理工具。
License: GNU General Public License v2.0
专门为kettle这款优秀的ETL工具开发的web端管理工具。
License: GNU General Public License v2.0
你好,majinju
使用中出现以下错误
登录时跳转到 kettle/toLogin,页面显示为
原因已找到,只要nginx 转发设置了 IP白名单,就会报错,原因未知
server {
listen 80;
server_name kettle;
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
location / {
#IP acl fail,unset
proxy_pass http://10.0.0.1:82;
}
}
<dependency>
<groupId>cn.benma666</groupId>
<artifactId>myutils</artifactId>
<version>0.0.1</version>
</dependency>
如题
Sql: select count(*) from v_job_params where id_job = ?
Sql: select * from v_job_params where id_job = ? limit 0, 15
Sql: select j.id_job, j.name, j.description from kettle.r_job where 1=1 and id_
job in('1')
2017-01-08 15:40:36 ERROR [qtp26173282-35 - ActionHandler.java:128] /grid/query/
V_JOB_PARAMS-list_job_params
com.jfinal.plugin.activerecord.ActiveRecordException: com.mysql.jdbc.exceptions.
jdbc4.MySQLSyntaxErrorException: Unknown column 'j.id_job' in 'field list'
at com.jfinal.plugin.activerecord.DbPro.find(DbPro.java:320)
at com.jfinal.plugin.activerecord.DbPro.find(DbPro.java:331)
at com.eova.widget.WidgetManager.convertValueByExp(WidgetManager.java:30
4)
at com.eova.widget.grid.GridController.query(GridController.java:148)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at com.jfinal.aop.Invocation.invoke(Invocation.java:73)
at com.eova.interceptor.LoginInterceptor.intercept(LoginInterceptor.java
:108)
at com.jfinal.aop.Invocation.invoke(Invocation.java:67)
at com.jfinal.core.ActionHandler.handle(ActionHandler.java:74)
at com.jfinal.plugin.druid.DruidStatViewHandler.handle(DruidStatViewHand
ler.java:75)
at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:72)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1307)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java
:453)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
ava:137)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.jav
a:560)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandl
er.java:231)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandl
er.java:1072)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:
382)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandle
r.java:193)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandle
r.java:1006)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
ava:135)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper
.java:116)
at org.eclipse.jetty.server.Server.handle(Server.java:365)
at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(Abstrac
tHttpConnection.java:485)
at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpC
onnection.java:937)
at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.conten
t(AbstractHttpConnection.java:998)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnecti
on.java:82)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEn
dPoint.java:628)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEnd
Point.java:52)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPoo
l.java:608)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool
.java:543)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown co
lumn 'j.id_job' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2144)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2310)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQue
ry(FilterChainImpl.java:2714)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute
Query(FilterEventAdapter.java:465)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQue
这个依赖包无法下载,要到哪里去获取这个依赖包呢?
能否提供0.4.0集成版的源码呢? 目前GITHUB上的源码跟集成版的程式有差异
能否提供源码呢? 谢谢
项目中没有找到这个类。
1:km.sh你应该是在windows下编辑的吧,windows的/r/n和linux的/n的问题,这个我自己已经解决
2:我执行km.sh start启动的时候,总是报82端口已经占用,但是事实上我的82端口并没有占用,不知道什么原因,麻烦给个指导
web端可以获取Job,选择job启动时报错部分作业启动失败”, kettle版本:6.1
按照0.2.0配置,启动一切正常。
登录成功后页面只有
关闭
关闭其他
关闭所有
这几个文本信息
控制台输出如下
`
Sql: select * from eova_menu where parent_id = 0 order by order_num
Sql: select DISTINCT(b.menu_code) from eova_role_btn rf LEFT JOIN eova_button b on rf.bid = b.id where b.ui = 'query' and rf.rid = ?
Sql: select * from eova_menu where is_del = 0 order by parent_id,order_num
Sql: select DISTINCT(b.menu_code) from eova_role_btn rf LEFT JOIN eova_button b on rf.bid = b.id where b.ui = 'query' and rf.rid = ?
Sql: select DISTINCT(b.menu_code) from eova_role_btn rf LEFT JOIN eova_button b on rf.bid = b.id where b.ui = 'query' and rf.rid = ?
JFinal action report -------- 2018-01-29 14:29:31 ------------------------------
Controller : com.eova.core.IndexController.(IndexController.java:1)
Method : index
Interceptor : com.eova.interceptor.LoginInterceptor.(LoginInterceptor.java:1)
`
2017-11-04 08:07:31 ERROR [qtp1161667116-55 - ActionHandler.java:128] /meta/doImports
java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
at com.jfinal.aop.Invocation.invoke(Invocation.java:87)
at com.jfinal.plugin.activerecord.tx.Tx.intercept(Tx.java:77)
at com.jfinal.aop.Invocation.invoke(Invocation.java:67)
at com.eova.interceptor.LoginInterceptor.intercept(LoginInterceptor.java:109)
at com.jfinal.aop.Invocation.invoke(Invocation.java:67)
at com.jfinal.core.ActionHandler.handle(ActionHandler.java:74)
at com.jfinal.plugin.druid.DruidStatViewHandler.handle(DruidStatViewHandler.java:75)
at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:72)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:560)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1072)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
at org.eclipse.jetty.server.Server.handle(Server.java:365)
at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:937)
at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:998)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.jfinal.aop.Invocation.invoke(Invocation.java:73)
... 30 more
Caused by: java.lang.AbstractMethodError: oracle.jdbc.driver.T4CConnection.setClientInfo(Ljava/util/Properties;)V
at com.alibaba.druid.filter.FilterChainImpl.connection_setClientInfo(FilterChainImpl.java:574)
at com.alibaba.druid.filter.FilterAdapter.connection_setClientInfo(FilterAdapter.java:996)
at com.alibaba.druid.filter.FilterChainImpl.connection_setClientInfo(FilterChainImpl.java:570)
at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.setClientInfo(ConnectionProxyImpl.java:444)
at com.alibaba.druid.pool.DruidPooledConnection.setClientInfo(DruidPooledConnection.java:1029)
at com.eova.common.utils.db.DsUtil.getDatabaseMetaData(DsUtil.java:48)
at com.eova.common.utils.db.DsUtil.getColumnInfoByConfigName(DsUtil.java:182)
at com.eova.common.utils.db.DsUtil.getColumnInfoByConfigName(DsUtil.java:162)
at com.eova.core.meta.MetaController.doImports(MetaController.java:212)
... 35 more
Hello,
I want to integrate PDI into my web project, and now I can integrate the functionality under the kettle-engine package. But there is something wrong with integrating big-data-plugin.
Example:
I need a HBaseInput and HBaseOutput, so I initialized it like this:
KettleEnvironment.init();
PluginRegistry registry = PluginRegistry.getInstance();
PluginInterface pluginInterface= registry.findPluginWithId(StepPluginType.class, "HBaseInput");
HBaseInputMeta meta = (HBaseInputMeta)registry.loadClass(pluginInterface);
But the line 4 causes [ClassCastException]
I looked at the source and found that they are different classloaders.
So I don't know how to integrate this into my project now, I am not familiar with OSGI. : (
Could you help me ?
Many thanks in advance. : )
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.