ETL kettle传输表数据时报错:无法从套接字读取更多的数据 [问题点数:20分]

Bbs1
本版专家分:0
结帖率 0%
新手请教kettle db链接问题
本地链接正常,连his<em>数据</em>库总是报下面这个 错误,请各大侠指点 错误连接<em>数据</em>库 : org.pentaho.di.core.exception.KettleDatabaseException: Err
java.sql.SQLRecoverableException: 无法套接字读取多的数据
解决方案: 1&amp;gt;在PLSQL执行alter system set &quot;_optim_peek_user_binds&quot;=false, 2&amp;gt;重启一下服务器;
无法套接字读取多的数据
SELECT/* + FIRST_ROWS */ (SELECT NAME FROM LBORGANIZATION M WHERE M.ID = T.YYB) 营业部, KHH 客户号, KHXM 客
无法套接字读取更多数据
操作<em>数据</em>库的语句如下: public void insert(){ init(); String name = db.getName(); String password = db.getPasswo
java.sql.SQLException: 无法套接字读取多的数据出现的原因
今天测试<em>数据</em>库出现 java.sql.SQLException: <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em> java.sql.SQLException: <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>
远程登录oracle数据库时无法套接字读取多的数据
远程登录oracle<em>数据</em>库时总是连接不上,<em>报错</em>:<em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>
oracle 无法套接字读取多的数据
Caused by: org.hibernate.TransactionException: JDBC rollback failed    at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)    at org.springframework.orm.hibernate3.Hiber...
java.sql.SQLException: 无法套接字读取多的数据
java.sql.SQLException: <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>
oracle 无法套接字读取多的数据
http://blog.sina.com.cn/s/blog_53a844e50100wls9.html   自己遇到的问题   sql语句: select * from (select t2.jgdm as jgdm,t2.jgmc as jgmc,t2.org_type as orgType,t2.org_symbol as orgSymbol from t_xt_jg_bizrel
Kettle执行transform时报错:错误打开转换
使用<em>kettle</em>进行<em>数据</em>库表记录迁移
kettle案例九-----linux使用kettle
我们之前学习的<em>kettle</em>操作都是在windows中进行可视化的操作,但是在使用过程中发现一些问题。 比如我们的<em>数据</em>文件是放在linux服务器中的,如果要清洗则需要把它们下载到本地,这样需要耗费一些时间,尤其是<em>数据</em>文件比较大时。 解决方案就是 我们直接在linux服务器中运行<em>kettle</em>进行抽取。 Kettle可以在Window、Linux、Unix上运行,绿色无需安装,<em>数据</em>抽取高效稳定,不...
java.sql.SQLRecoverableExceptino:无法套接字读取多的数据
程序属于多线程应用场景。rn用一个dmcp连接池单利作<em>数据</em>源。rn连接池初始化:rndataSource = new BasicDataSource();rn dataSource.setInitialSize(initialSize);rn dataSource.setMaxActive(maxActive);rn dataSource.setMaxIdle(maxIdle);rn dataSource.setMinIdle(minIdle);rn dataSource.setDriverClassName(ORACLE_CONNECTION_DRIVE);rn dataSource.setUsername(user);rn dataSource.setPassword(password);rn dataSource.setUrl(url);rn dataSource.setMaxWait(3000);rn dataSource.setRemoveAbandoned(true);rn dataSource.setRemoveAbandonedTimeout(60);rnrn<em>数据</em>源封装代码如下:rnpublic static ConnectDB getInstance(String dbname) rn if (null == databaseMap.get(dbname)) rn databaseMap.put(dbname, new ConnectDB(dbname));rn _log_task.info("init dbname : " + dbname + "; databaseMap.size():" + databaseMap.size());rn rn return databaseMap.get(dbname);rn rn rn public Connection getConnection() rn Connection conn = null;rn try rn conn = dataSource.getConnection();rn catch (SQLException e) rn // TODO Auto-generated catch blockrn e.printStackTrace();rn rn return conn;rn rn rn public boolean executeUpdate(String sql) rn Connection connect = null;rn Statement stmt = null;rn try rn connect = dataSource.getConnection();rn stmt = connect.createStatement();rn stmt.executeUpdate(sql);rn return true;rn catch (SQLException e) rn e.printStackTrace();rn return false;rn finally rn if (null != stmt) rn try rn stmt.close();rn stmt = null;rn catch (SQLException e) rn // TODO Auto-generated catch blockrn e.printStackTrace();rn rn rn rn if (null != connect) rn try rn connect.close();rn catch (SQLException e) rn // TODO Auto-generated catch blockrn e.printStackTrace();rn rn connect = null;rn rn rn rnrn public Statement createStatement(Connection conn) rn Statement stmt = null;rn try rn stmt = conn.createStatement();rn catch (SQLException e) rn e.printStackTrace();rn rn return stmt;rn rnrn public boolean execCall(String procedureSql,String[] params) rn boolean rlt = false;rn CallableStatement cbst = null;rn Connection conn = null;rn try rn conn = dataSource.getConnection();rn conn.setAutoCommit(false);rn cbst = conn.prepareCall(procedureSql);rn if (null != params && params.length != 0) rn for (int i=1;i<=params.length;i++)rn cbst.setString(i, params[i-1]);rn rnrn cbst.execute();rn conn.commit();rn conn.setAutoCommit(true);rn rlt = true;rn catch (SQLException e) rn e.printStackTrace();rn rlt = false;rn finally rn rn if (null != cbst) rn try rn cbst.close();rn catch (SQLException e) rn e.printStackTrace();rn rn cbst = null;rn rn if (null != conn) rn try rn conn.close();rn catch (SQLException e) rn // TODO Auto-generated catch blockrn e.printStackTrace();rn rn conn = null;rn rn rn return rlt;rn rn rn rn public void close(Statement stmt,ResultSet rs,Connection conn) rn if (null != stmt) rn try rn stmt.close();rn catch (SQLException e) rn // TODO Auto-generated catch blockrn e.printStackTrace();rn rn stmt = null;rn rn if (null != rs) rn try rn rs.close();rn catch (SQLException e) rn // TODO Auto-generated catch blockrn e.printStackTrace();rn rn rs = null;rn rn if (null != conn) rn try rn conn.close();rn catch (SQLException e) rn // TODO Auto-generated catch blockrn e.printStackTrace();rn rn conn = null;rn rn rnrn程序属于同步进程,为了提高同步效率,采用多线程处理。<em>数据</em>库操作频繁。rn每次<em>数据</em>库查询操作,都会调用public void close(Statement stmt,ResultSet rs,Connection conn) rn其它的也都调用了close。rn开始运行正常,运行一段时间后,会出现很多下面的异常:rnjava.sql.SQLRecoverableExceptino:<em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>rnrn请大侠们指点下。
为什么出现:无法套接字读取多的数据
部分代码如下:rn Connection cn=DB.getConnection() ;rn Statement st=cn.createStatement();rn ResultSet rs = null;rn int intFirstRow = 21;rn int intLastRow = intFirstRow + 20;rnrn String strSQL = "select * from DIC where rownum + intFirstRow;rnrn rs = st.executeQuery(strSQL);rn代码执行到rs=st.executeQuery(strSQL)时出错:rnjava.sql.SQLException: <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>rn如果把intFirstRow设为1就不出错,真是太奇怪了
jdbc:无法套接字读取多的数据是什么错误
oracle9i,jdbc执行一个insert出现以上错误
java.sql.SQLRecoverableException: 无法套接字读取多的数据------急求
java.lang.reflect.UndeclaredThrowableExceptionrn at $Proxy48.rollback(Unknown Source)rn at com.sx.support.dba.dbCore.rollback(dbCore.java:546)rn at com.sx.support.dba.dbAPI.dbRollback(dbAPI.java:96)rn at com.sx.db.Db.dbRollback(Db.java:142)rn at com.sx.db.DbCommon.execSql(DbCommon.java:142)rn at com.sx.bjslg.fwzgfgl.xqtz.dao.impl.xqtzDAOImpl.updteXqtz(xqtzDAOImpl.java:211)rn at com.sx.bjslg.fwzgfgl.xqtz.service.impl.xqtzServiceImpl.updateXqtz(xqtzServiceImpl.java:20)rn at com.sx.bjslg.fwzgfgl.xqtz.action.xqtzAction.xqtz(xqtzAction.java:50)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)rn at java.lang.reflect.Method.invoke(Method.java:597)rn at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)rn at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)rn at com.sx.action.AbsDispatchAction.execute(AbsDispatchAction.java:32)rn at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)rn at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)rn at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)rn at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)rn at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)rn at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)rn at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)rn at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)rn at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)rn at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)rn at com.sx.bjslg.common.CommonFilter.doFilter(CommonFilter.java:61)rn at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)rn at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3496)rn at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)rn at weblogic.security.service.SecurityManager.runAs(Unknown Source)rn at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)rn at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)rn at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)rn at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)rn at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)rnCaused by: java.lang.reflect.InvocationTargetExceptionrn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)rn at java.lang.reflect.Method.invoke(Method.java:597)rn at com.sx.support.dbcp._Connection.invoke(_Connection.java:701)rn ... 37 morernCaused by: java.sql.SQLRecoverableException: <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>rn at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:101)rn at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)rn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)rn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)rn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)rn at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1042)rn at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:999)rn at oracle.jdbc.driver.T4C7Ocommoncall.receive(T4C7Ocommoncall.java:97)rn at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:613)rn at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3389)rn ... 42 morern这是什么原因造成的怎么解决,急求。
无法套接字读取多的数据是什么错误
oracle9i,jdbc执行一个insert出现以上错误
nested exception is java.sql.SQLException: 无法套接字读取多的数据
这个异常我查了下 rn1 有的说是<em>数据</em>库版本问题, 我用的是oracle9i,我现在不会升级到10G的,所以如果是这个原因肯定不行的,rn2 sql效率问题,这个也不好解决,我用的是select * from table 必须要这样写,所以这个原因也不应该rn3 <em>数据</em>库回滚段问题,目前希望是这个原因,这个可以解决rn 目前就知道这几个原因,有没有人经历过这些问题,并且是如何解决的,麻烦各位..... rn
spring hibernate clob的无法套接字读取多的数据
两者都需要的JAR包为ojdbc14.jar,或ojdbc15.jar,如果使用class12.jar则不可以 spring 中的配置9i与10g是相同的,都可以用以下程序  &amp;lt;bean id=&quot;nativeJdbcExtractor&quot;  class=&quot;org.springframework.jdbc.support.nativejdbc.CommonsDbcpNativeJdbcExt...
很鬼马的 无法套接字读取多的数据
环境描述:rnwin2003 sp2 +oracle 10.2.0.1.0+tomcat (版本不知)rn后台有公司已经写好的java 类,前台JSPrn错误:rntomcat <em>报错</em>如下:rnjava.lang.reflect.UndeclaredThrowableExceptionrn at $Proxy0.rollback(Unknown Source)rn at com.szkingdom.kdcrm.delegate.TranditionalDelegate.query(TranditionalDrnelegate.java:45)rn at com.szkingdom.kdcrm.web.actions.QueryAction.go(QueryAction.java:69)rn at com.szkingdom.kdf.support.DefaultRequestProcessor.process(DefaultRequrnestProcessor.java:259)rn at com.szkingdom.kdf.FrontController.processRequest(FrontController.javarn:261)rn at com.szkingdom.kdf.FrontController.doGet(FrontController.java:91)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)rn at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisprnatcher.java:684)rn at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDrnispatcher.java:575)rn at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDisrnpatcher.java:498)rn at org.apache.taglibs.standard.tag.common.core.ImportSupport.acquireStrirnng(ImportSupport.java:314)rn at org.apache.taglibs.standard.tag.common.core.ImportSupport.doEndTag(ImrnportSupport.java:179)rn at org.apache.jsp.XMLDATA_jsp._jspService(XMLDATA_jsp.java:92)rn at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)rn at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapperrn.java:210)rn at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2rn95)rn at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplrnicationFilterChain.java:247)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFrnilterChain.java:193)rn at com.szkingdom.kdf.filter.ResponseHeaderFilter.doFilter(ResponseHeaderrnFilter.java:95)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplrnicationFilterChain.java:213)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFrnilterChain.java:193)rn at com.szkingdom.kdf.filter.CharsetFilter.doFilter(CharsetFilter.java:20rn1)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplrnicationFilterChain.java:213)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFrnilterChain.java:193)rn at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVrnalve.java:256)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContexrnt.invokeNext(StandardPipeline.java:643)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.javrna:480)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)rnrn at org.apache.catalina.core.StandardContextValve.invoke(StandardContextVrnalve.java:191)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContexrnt.invokeNext(StandardPipeline.java:643)rn at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValvern.java:246)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContexrnt.invokeNext(StandardPipeline.java:641)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.javrna:480)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)rnrn at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:rn2422)rn at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jrnava:180)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContexrnt.invokeNext(StandardPipeline.java:643)rn at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatchernrValve.java:171)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContexrnt.invokeNext(StandardPipeline.java:641)rn at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jrnava:163)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContexrnt.invokeNext(StandardPipeline.java:641)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.javrna:480)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)rnrn at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValrnve.java:174)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContexrnt.invokeNext(StandardPipeline.java:643)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.javrna:480)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)rnrn at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:19rn9)rn at org.apache.coyote.http11.Http11Processor.process(Http11Processor.javarn:828)rn at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.procernssConnection(Http11Protocol.java:700)rn at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.javarn:584)rn at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPrnool.java:683)rn at java.lang.Thread.run(Thread.java:534)rnCaused by: java.lang.reflect.InvocationTargetExceptionrn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.rnjava:39)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesrnsorImpl.java:25)rn at java.lang.reflect.Method.invoke(Method.java:324)rn at com.szkingdom.kdcrm.dao.support.ResourceLocator$ContextConnectionProxrny.invoke(ResourceLocator.java:169)rn ... 57 morernCaused by: java.lang.reflect.UndeclaredThrowableExceptionrn at $Proxy0.rollback(Unknown Source)rn ... 62 morernCaused by: java.lang.reflect.InvocationTargetExceptionrn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.rnjava:39)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesrnsorImpl.java:25)rn at java.lang.reflect.Method.invoke(Method.java:324)rn at com.szkingdom.kdcrm.dao.support.ConnectionProxy.invoke(ConnectionProxrny.java:77)rn ... 63 morernCaused by: java.sql.SQLException: <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>rn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)rn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)rn at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)rn at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:963)rn at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893)rn at oracle.jdbc.ttc7.Ocommoncall.receive(Ocommoncall.java:104)rn at oracle.jdbc.ttc7.TTC7Protocol.rollback(TTC7Protocol.java:487)rn at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:13rn76)rn at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnernction.java:265)rn at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rnrollback(PoolingDataSource.java:333)rn ... 68 morern2008-4-23 15:14:36 com.szkingdom.kdf.support.DefaultRequestProcessor process
ORACLE 无法套接字读取多的数据 错误
[INFO] query sql: SELECT OID ,BOOKMARKID ,FEATUREID ,SORTID ,SORTTYPE ,TYPE ,TITLE ,BRIEF ,ICONPATH ,LINEWIDTH ,LINECOLOR ,FILLCOLOR ,OPACITY ,STATUS ,HEIGHT ,PITCHING ,CURLAYER ,MINLAYER ,MAXLAYER ,IMAGEPATH ,VIDEOPATH ,REGUSER ,REGTIME ,EDITUSER ,EDITTIME,GEOMETRY FROM WFS.TEST_POINT A WHERE 1=1 and bookmarkid in (select p.bookmarkid from ( select us.*,rownum rn from ( select TEST_POINT.BOOKMARKID,TEST_POINT.FEATUREID,TEST_POINT.SORTID,TEST_POINT.SORTTYPE,TEST_POINT.TYPE,TEST_POINT.TITLE,TEST_POINT.BRIEF,TEST_POINT.ICONPATH,TEST_POINT.LINEWIDTH,TEST_POINT.LINECOLOR,TEST_POINT.FILLCOLOR,TEST_POINT.OPACITY,TEST_POINT.STATUS,TEST_POINT.HEIGHT,TEST_POINT.PITCHING,TEST_POINT.CURLAYER,TEST_POINT.MINLAYER,TEST_POINT.MAXLAYER,TEST_POINT.IMAGEPATH,TEST_POINT.VIDEOPATH,TEST_POINT.REGUSER,TEST_POINT.REGTIME,TEST_POINT.EDITUSER,TEST_POINT.EDITTIME from TEST_POINT where 1=1 and ( TEST_POINT.reguser='562' or TEST_POINT.edituser = '562')) us where rownum = 1)rn[ERROR] java.sql.SQLException: <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>rnjava.sql.SQLException: <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>rn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)rn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)rn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)rn at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1123)rn at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1075)rn at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:480)rn at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)rn at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)rn at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1072)rn at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845)rn at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)rn at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1313)rn at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)rn at com.geostar.server.dp.vector.oracle.OracleDataProvider.searchBySQL(OracleDataProvider.java:1662)rn at com.geostar.common.spatialmodel.geobase.GeoSurfFeatureLayer.searchBySQL(GeoSurfFeatureLayer.java:1042)rn at com.geostar.mapplotservice.wtfs.MapPlotServiceSkeleton.QueryFeatures(MapPlotServiceSkeleton.java:720)rn at com.geostar.mapplotservice.wtfs.MapPlotServiceMessageReceiverInOut.invokeBusinessLogic(MapPlotServiceMessageReceiverInOut.java:87)rn at org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40)rn at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100)rn at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)rn at org.apache.axis2.transport.http.util.RESTUtil.invokeAxisEngine(RESTUtil.java:136)rn at org.apache.axis2.transport.http.util.RESTUtil.processURLRequest(RESTUtil.java:130)rn at org.apache.axis2.transport.http.AxisServlet$RestRequestProcessor.processURLRequest(AxisServlet.java:829)rn at org.apache.axis2.transport.http.AxisServlet.doGet(AxisServlet.java:255)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)rn at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)rn at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)rn at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)rn at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)rn at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)rn at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)rn at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)rn at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)rn at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)rn at java.lang.Thread.run(Unknown Source)
测试失败,无法套接字读取多的数据
[img=https://img-bbs.csdn.net/upload/201509/18/1442556248_564523.png][/img][img=https://img-bbs.csdn.net/upload/201509/18/1442556296_569986.png][/img] 本人是菜鸟一枚,从没用过这玩意,从安装开始学的
数据库 java.sql.SQLRecoverableException没法从套接字读取多的数据
具体执行语句如下:rnSELECT *rn FROM B_T1 Brn LEFT JOIN P_T1 P ON P.CODE = B.TYPErn AND P.ID = '123'rn WHERE 1 = 1rn AND B.ID IN (SELECT T.ID FROM T_T1 T WHERE T.id LIKE '123%')rn执行以上语句会提示<em>数据</em>库未连接,pl/sql 提交按钮变绿,显示未提交。。rnrn其中单独执行rnSELECT T.IDFROM T_T1 T WHERE T.id LIKE '123%' ;rn和rnSELECT *rn FROM B_T1 Brn LEFT JOIN P_T1 P ON P.CODE = B.TYPErn AND P.ID = '123'rn WHERE 1 = 1rn AND B.ID IN (12301,123010001,123010002)rn
JDBC报错:“无法套接字读取多的数据!” 请高人指点!
Oracle<em>数据</em>库版本:rn Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit ProductionrnrnJDBC驱动版本:rn 从9.2.0.4到10.2.0.2都试过了!rnrnrn<em>报错</em>:“OALL8 处于不一致状态”,“ <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>”rnrnsql比较复杂,最后有24个返回字段,在PL/SQL下可以正常取得<em>数据</em>,但是通过jdbc最多只能取得一行<em>数据</em>,提示“<em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>!”rnrn本以为是驱动版本的问题,但是所有版本都试过了,其中9.2.*.*只提示rn“<em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>!”,一条<em>数据</em>也选不出来;10.*.*.*还有一条提示:OALL8 is in an inconsistent state,但是可以选出一条<em>数据</em>来。rnrn请问高手们该如何解决???rnrn
Kettle学习_传输数据
一,作(JOB)和转换(transformation) 可以把  transformation 理解为工厂的生产流水线,transformation的组件就是生产线的每个员工,员工各司其职 那么JOB 就是相当于工厂的管理,分配调度执行每个transformation(单个的作业也可以执行) 二,学习转换组件 1,新建转换,2,搜索步骤,3,双击或者拖动,4建立<em>数据</em>源
oracle:无法套接字读取更多数据
package com.wubin; rnrnimport java.sql.*; rnimport java.sql.Connection; rnrnpublic class TestOracle rnpublic static void main(String args[]) rnString username = "system "; rnString password = "sdo "; rnString driver = "oracle.jdbc.driver.OracleDriver "; rnString url = "jdbc:oracle:thin:@localhost:1521:PLSExtProc "; rntry rnClass.forName(driver).newInstance(); rnConnection conn = DriverManager.getConnection(url, username, rnpassword);//此行出错,<em>无法</em>从<em>套接字</em><em>读取</em>更多<em>数据</em> rnStatement stmt = conn.createStatement(); rnString sql = "select * from wubin "; rnResultSet rs = stmt.executeQuery(sql); rnwhile (rs.next()) rnSystem.out.println( "success "); rn rn catch (Exception e) rn// TODO Auto-generated catch block rne.printStackTrace(); rnSystem.out.println( "sql exception! "); rn rn rn rn错误:java.sql.SQLException: <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em> rnat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) rnat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) rnat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) rnat oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1118) rnat oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1070) rnat oracle.jdbc.driver.T4C8TTIpro.receive(T4C8TTIpro.java:131) rnat oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:867) rnat oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:268) rnat oracle.jdbc.driver.PhysicalConnection. (PhysicalConnection.java:414) rnat oracle.jdbc.driver.T4CConnection. (T4CConnection.java:165) rnat oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35) rnat oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801) rnat java.sql.DriverManager.getConnection(DriverManager.java:525) rnat java.sql.DriverManager.getConnection(DriverManager.java:171) rnat com.wubin.TestOracle.main(TestOracle.java:15) rnsql exception! rn代码有点长,但是简单,在Connection conn=DriverManager.getConnection(url,username,password);出现上面的错误,我的是10g 10.0.1的版本,用的是它自带的jdbc,用户名和密码是我登陆sqlplus的用户名和密码,能够正常登陆,<em>数据</em>库也能访问,可是用jdbc访问就是老上面的错误,大侠们帮忙
Struts+Hibernate+Spring读写Oracle的Clob出错:无法套接字读取多的数据,高分等待......
急用一个新闻发布系统的后台,找了个Jaoso新闻发布系统0.9.1final,学习一下,网站建立起来了,但是在添加文章的时候出现了错误:rnjava.sql.SQLException: <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>rn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)rn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)rn at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)rn at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:963)rn at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893)rn at oracle.jdbc.ttc7.Ocommoncall.receive(Ocommoncall.java:104)rn at oracle.jdbc.ttc7.TTC7Protocol.rollback(TTC7Protocol.java:487)rn at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1376)rn at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)rn at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288)rn at net.sf.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:86)rn at org.springframework.orm.hibernate.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:487)rn at org.springframework.transaction.support.AbstractPlatformTransactionManager.doRollbackOnCommitException(AbstractPlatformTransactionManager.java:476)rn at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:398)rn at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionAfterReturning(TransactionAspectSupport.java:242)rn at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:66)rn at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)rn at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)rn at $Proxy3.createArticle(Unknown Source)rn at jaoso.news.web.action.ArticleAction.create(ArticleAction.java:277)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)rn at java.lang.reflect.Method.invoke(Method.java:585)rn at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)rn at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)rn at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)rn at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)rn at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)rn at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:154)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:92)rn at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)rn at jaoso.framework.web.filter.compression.CompressionFilter.doFilter(CompressionFilter.java:256)rn at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)rn at jaoso.framework.web.filter.EncodingFilter.doFilter(EncodingFilter.java:164)rn at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)rn at jaoso.framework.web.filter.AclFilter.doFilter(AclFilter.java:100)rn at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)rn at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:178)rn at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)rn at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:259)rn at com.caucho.server.port.TcpConnection.run(TcpConnection.java:386)rn at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:490)rn at com.caucho.util.ThreadPool.run(ThreadPool.java:423)rn at java.lang.Thread.run(Thread.java:595)rnrnrn对这个框架结构不是很熟悉,请教各位高手不吝赐教!!! 等待...rn
oracle语句出错,提示“无法套接字读取多的数据
代码语句如下:rnrnSelect Count(*) From "plus_progress" P rnLEFT JOIN "plus_progress_version" V ON P."ProgressId"=V."ProgressId" -- LEFT JOIN PT_yhmc AS yhmc ON V.InputUser=yhmc.v_yhdm rn Inner Join "plus_progress_privilege" Pr On rn P."ProgressId" = Pr."ProgressId" rn Where P."FlowState"=1 AND "PrjId"=:prjId AND PR."UserCode"=:userCode And V."ProgressVersionId" In( rn Select "ProgressVersionId" From rn (rn Select Rownum AS R,AA.* From rn (Select rn "ProgressVersionId" rn From "plus_progress_version" V rn WHERE V."ProgressId" = P."ProgressId" ORDER BY V."InputDate" DESC) AA ) BB where BB.r<=1 ) rnrn加了引号的是因为在<em>数据</em>库中表名和列名都有小写的,此语句实在不知道错在哪里,求大神指点
Oracle 9i R920 :无法套接字读取多的数据 9.2版与9.0版差别
请教高手,rn我原来用的Oracle9i R9.0.1.1.1,在JSP中通过ORacleJDBC连接正常rnrn但自从我用了9i,9.2.0.0.0后,访问速度奇慢,并且关了网页后,再次打开页面就会出现错误:<em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>,或者是Error chanel of TNL rnrn为什么????rn
十万火急!关于oracle jdbc “无法套接字读取多的数据”的问题
我在运行一段使用sql语句访问oracle9.2的java程序的时候,遇到了如下的异常:rnjava.sql.SQLException: <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>rn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)rn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)rn at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)rn at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:963)rn at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893)rn at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:369)rn at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)rn at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1198)rn at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2400)rn at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)rn at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:572)rnrn这句话的形式是这样的:rnselect * from (SELECT * FROM c_mplate WHERE 1=1 ) where rownum<=30rnjava又可以正确执行,似乎是10-30之间有某些<em>数据</em>造成了上述错误,但是我设定步长为5,然后扫遍整个10-30区间,又看不到上述异常,后来我把这张表的<em>数据</em>删除,然后重新导入,这个问题就不见了。rn实验发现minus的区间设置得越大,异常的概率越高,反之越低.rnrn软件环境:rn<em>数据</em>库 oracle9.2rnjdk 1.3rnclass12是oracle9.2安装目录下的oracle/odbc/lib/class12.jar(换用其他的较为新的jar也是如此)rn请教各位高手,如何解决这个问题?rn十万火急!万分感谢!
请教jdbcException:无法套接字读取多的数据 怎样解决
本程序是通过hibernate进行的分页 rnrn代码如下: rnrn[code=Java]query.setFirstResult(getStartOfPage(start, pageSize)); rnquery.setMaxResults(pageSize); rnlist = (List) query.list(); [/code]rnrn断点进行到query.list()时报以下异常: rnrn[color=#3366FF]================select u.ID,u.userCode,u.userName,d.departmentname from SysLedgerprivilege l,SysUser u,SysDepartment d where u.userDepartmentid= d.ID and l.userid=u.ID and l.ledgerid=2 and u.userState= 0 order by u.ID rnHibernate: select * from ( select sysuser1_.ID as col_0_0_, sysuser1_.USERCODE as col_1_0_, sysuser1_.USERNAME as col_2_0_, sysdepartm2_.DEPARTMENTNAME as col_3_0_ from SYSLEDGERPRIVILEGE sysledgerp0_, SYSUSER sysuser1_, SYSDEPARTMENT sysdepartm2_ where sysuser1_.USERDEPARTMENTID=sysdepartm2_.ID and sysledgerp0_.USERID=sysuser1_.ID and sysledgerp0_.LEDGERID=2 and sysuser1_.USERSTATE=0 order by sysuser1_.ID ) where rownum <= ? rn2009-03-03 12:46:07,984 WARN JDBCExceptionReporter - rn2009-03-03 12:46:07,984 ERROR JDBCExceptionReporter - [/color]rnrn请高手赐教,谢谢。 rnrnps:“================”后为我个人打印的本地sql,然后通过程序转换为“hibernate:”后的hql。rn但是这条语句在plsql中查询<em>报错</em>:ora-03113:end-of-file on communication channel。rn请问这段hql在哪块出了问题,如何修改,万分感谢。
uncategorized SQLException for SQL []; SQL state [null]; error code [17410]; 无法套接字读取多的数据
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation; uncategorized SQLException for SQL []; SQL state [null]; error code [17410]; <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>; nested exception is java.sql.SQLException: <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>rnrnrnsql语句是没问题的用pl/sql执行是没问题的,用代码执行就不行,但是同样的sql在其他库里用代码执行就是没问题的,是不是两个库有什么区别,这两个库都是在同一个SID下(库是oracel)(跟游标也没问题 都尝试过).
JSP页面调用JAVABEAN出错:“无法套接字读取多的数据
JSP页面调用JAVABEAN出错:“<em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>“rn通常是什么原因引起的呢?rn谢谢
Software caused connection、OALL8 处于不一致状态、无法套接字读取多的数据
近期发现web系统部署会有以下错误:rn 1、 Caused by: java.sql.SQLException: Io 异常: Software caused connection abort: recv failedrn 2、Caused by: java.sql.SQLException: OALL8 处于不一致状态rn 3、[2014-08-01 11:02:46 ERROR] org.hibernate.util.JDBCExceptionReporter:78-<em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>rn 当时遇到该问题时,情况如下,登录该系统,会产生3个连接,开始时第一个连接即会产生以上3个问题,后来发现前2个连接通过,第三个连接产生“OALL8 处于不一致状态”问题;rn 此过程中,监控<em>数据</em>库一直处于正常状态;rn <em>数据</em>库驱动ojdbc6.jar,<em>数据</em>库oracle10Grn hibernate配置的<em>数据</em>类型与<em>数据</em>库一致,<em>数据</em>库类型均是varchar与char类型;(如果不一致是不是每次都应该出错啊?)rn 请求大师帮助解决问题,分析一下原因,谢谢rn
在关联查询视图表和本地表的时候报无法套接字读取多的数据
#### <> <> $beginRow$ rn分暂时不多了,以后奉送!谢谢各位了。
无法套接字读取多的数据 ORACLE JDBC CLOB问题
用平台的功能写入大字段CLOB,结果只能写4000字,就不行了   SQLException说 <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em> 日志说  Software caused connection abort: socket write error 查了一下,最后发现是classes12.jar的问题,这个太老了,是java1.2用的 下载了ojdbc14.jar,问题解决,特记录。...
Kettle ETL
ETL中增量更新是一个比较依赖与工具和设计方法的过程,Kettle中主要提供Insert / Update 步骤,Delete 步骤和Database Lookup 步骤来支持增量更新,增量更新的设计方法也是根据应用场景来选取的,虽然本文讨论的是Kettle的实现方式,但也许对其他工具也有一些帮助。本文不可能涵盖所有的情况,欢迎大家讨论。
kettle 读取数据设置成变量
1.需求: 就是想把一些需要动态配置的参数放到<em>数据</em>库表里,然后运行job时加载这些参数,进一步做<em>数据</em>过滤什么的 2.处理逻辑: 3.设计细节 4.结束语 这种设置方式可行,但不足的是要对每个参数都单独设置,如果使用java代码来设置肯定更简单灵活。
kettle etl
<em>kettle</em>使用,用来各个<em>数据</em>库之间ETL<em>数据</em>抽取,功能比较全面。
使用minus方法有时会报出无法套接字读取多的数据错误(解决后加贴再给100分)
java.sql.SQLException: <em>无法</em>从<em>套接字</em><em>读取</em>更<em>多的</em><em>数据</em>rn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)rn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)rn at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)rn at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:963)rn at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893)rn at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:369)rn at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)rn at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1198)rn at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.javrna:2400)rn at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatemernnt.java:2672)rn at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:rn572)rn at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:345)
ETL:Kettle求助帖!
小弟近日需要在应用程序中集成<em>kettle</em>来导<em>数据</em>库,需要把SQL Server中的表导入到Oracle中,我是这样做的,在Kettle中定义好转换.ktr文件,然后根据sql和表名来重新生成转换,但是现在的问题是我必须在执行转换之前就把目标表在Oracle中建好,如何才能在<em>kettle</em>中自动执行建表?(不要打开<em>kettle</em>点击sql execute,而是全部在ktr中定义好语句)
ETL与kettle介绍
ETl介绍,<em>数据</em>仓库清洗<em>数据</em>工具,以及<em>kettle</em>介绍
ETL kettle 工具使用例子
说明:阻塞<em>数据</em>是将前一步的<em>数据</em>挤压到一个临时文件.知道没有<em>数据</em>或步骤执行完成之后,才执行下一个步骤。
ETL工具Kettle用户手册
密码丢了,多要点分. kattle水壶是个好东西,建议大家多多使用
ETL工具 KETTLE介绍
Kettle是业界比较认可的开源Etl工具
ETL工具KETTLE简介
1、ETL简介: ETL是将业务系统的<em>数据</em>经过抽取、清洗转换之后加载到<em>数据</em>仓库的过程,目的是将企业中的分散、零乱、标准不统一的<em>数据</em>整合到一起,为企业的决策提供分析依据。 ETL的实现有多种方法,常用的有三种: 第一种:是借助ETL工具(如Oracle的OWB、SQL Server 2000的DTS、SQL Server2005的SSIS服务、Informatic、Kettle等)实现; 第...
ETL工具kettle数据迁移
一个可以在相同或者不同<em>数据</em>库间做<em>数据</em>迁移的工具。ETL工具评价http://blog.csdn.net/baodi_z/article/details/45023439几种 ETL 工具的比较(Kettle,Talend,Informatica,Inaplex Inaport) http://blog.csdn.net/renminzdb/article/details/42422149kettl...
ETL工具使用--kettle
NULL 博文链接:https://aigo-h.iteye.com/blog/1943371
ETL之KETTLE实践
1.下载<em>kettle</em>软件包     我是在pentaho的社区网站下载:http://community.pentaho.com/projects/data-integration/     603M 10月 15 09:39 pdi-ce-5.4.0.1-130.zip 2.解压      unzip  pdi-ce-5.4.0.1-130.zip 3.解压之后
ETL之kettle数据同步
一.同步思路 Mysql<em>数据</em>导入oracle中思路:首先在oracle中建一张和mysql中表中字段一样的表(oracle中的表字段要包含mysql中表的字段),然后再在oracle中建一张只存id的表,当使用<em>kettle</em>的job时,首先执行一个sql查询oracle中的id表的id的最大值(因为mysql中的id设置是自增长的),然后表输入的时候执行sql查询mysql中要导入的表的<em>数据</em>,这里
kettle etl工具
详细介绍<em>kettle</em>中的各个组件。介绍实战中一些问题的处理。
ETL kettle 自学总结
1.下载安装包 <em>kettle</em> 5.3 2.配置<em>kettle</em>内存(不然运行缓慢,报内存溢出) Spoon.bat     if "%PENTAHO_DI_JAVA_OPTIONS%"=="" set PENTAHO_DI_JAVA_OPTIONS="-    Xmx1024m" "-XX:MaxPermSize=256m" 3.定时调度      3.1资源库调度 trans 执
ETL工具-kettle安装部署
ETL
ETL 以及 KETTLE 简介
1. 什么是ETL 2. KETTLE简介 2.1. Chef——工作(job)设计器 2.1.1. Chef中的作业项包括: 2.1.2. 工作流 2.1.3. 存储方式 2.1.4. LogView: 2.2. Kitchen——作业执行器 2.3. Spoon——转换过程设计器 2.3.1. Input-Steps:输入步骤 2.3.2. Output-Steps: 输出步聚 2.3.3. Look-up:查找操作 2.3.4. Transform 转换 (嗯,重点) 2.3.5. 除了上述基本节点类型外还定义了扩展节点类型 2.3.6. 其它 2.4. Pan——转换的执行工具 2.5. 其它 2.6. 个人感觉:(本人不成熟的看法) 3. ETL 小结 4. ETL本质 4.1. ETL 特点 4.2. ETL 类型 4.3. ETL 中的转换-Transication 4.3.1. 宏观输入输出方面 4.3.2. 微观规则 4.4. ETL中<em>数据</em>质量 4.5. ETL<em>数据</em>质量保证 4.6. 关于元<em>数据</em>
ETL工具Kettle手册
Kettle是一款国外开源的ETL工具,纯java编写,可以在Window、Linux、Unix上运行,<em>数据</em>抽取高效稳定。
etl工具Kettle大全
包含本人收集到的所有<em>kettle</em>资料,出《Kettle使用培训文档.ppt》之外,因为Kettle使用培训文档.ppt刚刚在这上传完
ETL工具Kettle用户手册(下)
开源<em>etl</em>工具<em>kettle</em>用户手册下半部分
Kettle ETL 工具
ETL 工具 SOA BI 分析 JAVA
etl自动化工具之kettle下载
由于工作需要下载<em>kettle</em>最新版本 网址:https://community.hitachivantara.com/docs/DOC-1009855 打开之后页面如下图所示: 向下滑动 点击8.2Stable下载最新版本。 未完待续。。 ...
数据仓库ETL之Kettle的应用
<em>数据</em>仓库ETL之Kettle的应用
ETL开发 Kettle案例
Kettle <em>数据</em>抽取, CDC快照更新 ,清洗和校验 ,处理维度表,<em>数据</em>分流,去重加载,调度
ETL工具kettle用户手册
开源ETL工具实用手册
ETL学习之Kettle实用教程
Kettle是开源的ETL工具,如果您在学习或使用ETL开发,请先从Kettle着手,当然也要从Kettle使用着手,希望本资料给你提供帮助。
ETL KETTLE资料
ETL KETTLE的相关培训资料,便于初步上手
kettle ETL 帮助文档&开发手册
<em>kettle</em> 开发手册 ETL 开发参考手册
ETL开源工具Kettle培训
Kettle 是一款开源的、元<em>数据</em>驱动的ETL工具集,是开源 ETL 工具里功能比较强大的一个。 Kettle 是”Kettle E.T.T.L. Envirnonment”只取首字母的缩写,这意味着它被设计 用来帮助你实现你的ETTL 需要:抽取、转换、装入和加载<em>数据</em>;翻译成中文名称应该叫水壶,名字的起源正如该项目的主程序员MATT 在一个论坛里说的哪样:希望把各种<em>数据</em>放到一个壶里然后以一种指定的格式流出。
kettle ETL 实战
<em>kettle</em> ETL 实战,大<em>数据</em>的时代,<em>kettle</em>做ETL过程
ETL工具Kettle的使用
之前因为公司项目的报表以及旧项目<em>数据</em>导入新项目涉及到的<em>数据</em>清洗, 所以用到了<em>kettle</em>这个工具, 刚开始用的时候踩了无数坑, 现在闲下来就打算写一篇博客, 希望多多少少能给读者有点帮助.我用这个工具的主要目的就是写报表和<em>数据</em>清洗,迁移.百科:ETL 是Extract-Transform-Load三个单词的简称,即抽取、转换、加载。ETL工具常用于建立<em>数据</em>仓库,但不仅限于这一领域。换句话话说,使用...
ETL工具 kettle
ETL工具 <em>kettle</em>
kettle帮助文档\ETL数据抽取说明
开源工具<em>kettle</em>的相关资料,压缩的文件,包括用户手册、工具介绍、培训手册、中文电子书和<em>数据</em>抽取例子。很珍贵的资料,整理了好久,所以10分,请谅解。 --ETL工具说明 培训手册 <em>数据</em>抽取 <em>kettle</em>中文资料 用户手册API
ETL资料-Kettle关于平面数据的导入
该文档里面有了关于如何进行 csv,xml等文件格式的导入导出步骤
ETL(kettle)实战三:数据抽取规范
写在前面:上一篇谈到的规则及这一篇谈到的规范都是本人的经验总结,不代表一定正确。 <em>kettle</em>开发规范: 1. 对于会发生变化的因素要用变量替换,不能写死。根据需求严格区分在未来哪些有可能变化的,哪些一定会变化的及哪些是不变的,如做增量<em>数据</em>抽取时,增量的时间范围未来就是有可能会发生变化的。通常情况下<em>数据</em>库是一定会变化的(开发环境和测试环境及生产环境通常都是不一样的),变量要控制作用域,即合理的...
ETL工具Kettle基本用法——Kettle的安装
转载请注明出处:http://blog.csdn.net/dongdong9223/article/details/80878477 本文出自【我是干勾鱼的博客】 Kettle是一款非常优秀的ETL工具,做<em>数据</em>抽取、同步、清洗都很方便,而且是开源的。由于使用Java做的,所以在各个平台上应用都很方便,今天就来讲讲<em>kettle</em>的使用。 Kettle在官网其实是被称谓“Data In...
ETL(kettle)实战一:kettle安装
抽<em>数据</em>快半年了,总结下这半年来的工作。 ETL安装,安装依赖jdk8(自行安装,jdk需要配置环境变量) 下载ETL工具.<em>kettle</em>稳定版 (windows,linux通用) 下载后的文件是压缩包,解压到文件,配置下环境变量就可已使用了。linux安装同理,需要先安装jdk,然后解压文件,然后配置/etc/profile,配置完记得执行下source /etc/profile使配置文件生效。...
Kettle学习, 更新数据
说明,接下来我会写一系列关于 Kettle使用的博客,希望能够帮到各位。 环境: Oracle<em>数据</em>库,建立test_student02表。 test_student02表结构及测试<em>数据</em>如下所示: -- 创建 test_student02表 create table TEST_STUDENT02 ( ST_ID VARCHAR2(64), ST_...
易语言做的音乐播放器下载
易语言做的播放器. 含源码 . 相关下载链接:[url=//download.csdn.net/download/wsx7547/2587884?utm_source=bbsseo]//download.csdn.net/download/wsx7547/2587884?utm_source=bbsseo[/url]
桌面软件日历软件,压缩后上传 桌面软件日历软件 桌面软件日历软件下载
桌面软件日历桌面软件日历桌面软件日历,压缩后上传 桌面软件日历软件 桌面软件日历软件 相关下载链接:[url=//download.csdn.net/download/huwf008/2626172?utm_source=bbsseo]//download.csdn.net/download/huwf008/2626172?utm_source=bbsseo[/url]
潮汐预报数据配合CNTideGets使用下载
把YS释放到DATA文件夹里面。这个的内容是中国海的潮汐模型。是俄勒冈大学共享的资料。 相关下载链接:[url=//download.csdn.net/download/qq435322119/5501727?utm_source=bbsseo]//download.csdn.net/download/qq435322119/5501727?utm_source=bbsseo[/url]
相关热词 c# 线程顺序 c#昨天当前时间 c# 多进程 锁 c#mysql图片存取 c# ocx 委托事件 c# 读取类的属性和值 c# out 使用限制 c#获取url的id c#怎么进行分页查询 c# update 集合
我们是很有底线的