Giter Site home page Giter Site logo

kettle-manager's Introduction

kettle管理工具

专门为kettle这款优秀的ETL工具开发的web端管理工具。

介绍文章

kettle-manager's People

Contributors

majinju avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

kettle-manager's Issues

两个问题

1:km.sh你应该是在windows下编辑的吧,windows的/r/n和linux的/n的问题,这个我自己已经解决
2:我执行km.sh start启动的时候,总是报82端口已经占用,但是事实上我的82端口并没有占用,不知道什么原因,麻烦给个指导

部分作业启动失败

web端可以获取Job,选择job启动时报错部分作业启动失败”, kettle版本:6.1

无法登录Web端

你好,majinju
使用中出现以下错误
登录时跳转到 kettle/toLogin,页面显示为

1
配置文件
2
请问是哪里的配置出现问题?

原因已找到,只要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

allow ;

deny all;

    proxy_pass http://10.0.0.1:82;
}

}

程序正常运行,但是登录成功后页面无内容

按照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)


`

从Oracle数据库导入元数据时会报ava.lang.AbstractMethodError: oracle.jdbc.driver.T4CConnection.setClientInfo(Ljava/util/Properties;)V错误

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

How can I integrate big-data-plugin into a web project?

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. : )

点击作业参数设置的时候报错

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

can not find dependency jar

    <dependency>
		<groupId>cn.benma666</groupId>
		<artifactId>myutils</artifactId>
		<version>0.0.1</version>
    </dependency>

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.