ibatis 调用存储过时出现出现不支持的 SQL92 标记: 9异常求解

一下为ibatis在中配置调用存储过程

<parameterMap  id="getInstProgressIdParaMap" class="java.util.HashMap">
    <parameter property="p_callFlag" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN"/>
    <parameter property="P_accNbr" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN"/>
    <parameter property="P_Type" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN"/>
    <parameter property="P_areaId" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN"/>
    <parameter property="P_Id" javaType="java.lang.Integer" jdbcType="INTEGER" mode="OUT"/>
</parameterMap>

<procedure id="getInstProgressId" parameterMap="getInstProgressIdParaMap">
    <![CDATA[{ods_intf.NetWork_10000_Pkg.Web_Exec_Proc(?,?,?,?,?)}]]>
</procedure>

以下是:java调用ibatis

public String getInstProgressId(String callFlag, String accNbr,
String type, String areaId) {

    Map<String, Object> map = new HashMap<String, Object>();

    map.put("p_callFlag", callFlag);
    map.put("P_accNbr", accNbr);
    map.put("P_Type", type);
    map.put("P_areaId", areaId);

    this.getSqlMapClientTemplate().queryForObject("getInstProgressId",map);

    return map.get("P_Id").toString();
}

调用后就出现:Caused by: java.sql.SQLException: 出现不支持的 SQL92 标记: 9: ods_intf

求解啊!!!!!

3个回答

试试这个:
{call NetWork_10000_Pkg.Web_Exec_Proc(?,?,?,?,?)}

存储过程本身能跑吗,ods_intf 是什么东西



<![CDATA[
{call MATE_LOCAL_ACTION (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
]]>

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
出现不支持的 SQL92 标记: 12:
各位社友:rn 你们好,编译jsp代码出现如上错误,这是执行这个bean的代码,我不知道哪里错了,请各位帮帮忙,谢谢!rn=========================================================================rnrnpublic ArrayList getAera_cash(String bdate,String pdate,String area,String custid,rn String itemid,String salep) //区域业绩查询rn rn ArrayList list=new ArrayList();rn String str=null;rn tryrn OracleDBConnection dbc=new OracleDBConnection();rn //DBConnectionPool conn=new DBConnectionPool();rn Connection conn=dbc.getConnection();//创建一个连接rn rn rn CallableStatement stmt=conn.prepareCall("add_cust_oe(to_date(bdate,'YYYY-MM-DD'),to_date(pdate,'YYYY-MM-DD'))");rn //CallableStatement stmt=dbc.prepareCall("add_cust_oe");rn stmt.execute();rnrn str="SELECT nvl(b.ATTRIBUTE1,'未划分区域') as area,a.ACCOUNT_NUMBER,b.PARTY_NAME,sum(qty) as qty_m,sum(a.PRICE) as price_m";rn str= str + " FROM nbadd.add_cust_oe_price A,TT_WMS_CUST_A b";rn str= str + " where a.ACCOUNT_NUMBER = b.ACCOUNT_NUMBER";rn str= str + " and b.ORG_ID = 42";rn str=str +"and (nvl(b.ATTRIBUTE1,'未划分区域') ='"+area +"' Or '"+area+"' is null)";rn str= str + " AND (A.ACCOUNT_NUMBER = '"+custid +"' OR '"+ custid +"' IS NULL)";rn str= str + " AND (A.CROSS_REFERENCE = '"+itemid +"' OR '"+itemid +"' IS NULL)";rn str= str + " AND (A.NAME = '"+salep +"' OR '"+salep +"' IS NULL)";rn str= str + " GROUP BY nvl(b.ATTRIBUTE1,'未划分区域') ,A.ACCOUNT_NUMBER,b.PARTY_NAME";rn str= str + " order by nvl(b.ATTRIBUTE1,'未划分区域'),a.ACCOUNT_NUMBER";rn ResultSet rs =dbc.executeQuery(str);rn while(rs.next())rn rn Achievement form=new Achievement();rn form.setArea(rs.getString(1));rn form.setPro_id(rs.getString(2));rn form.setAch_name(rs.getString(3));rn form.setCash(rs.getFloat(4));rn form.setCash1(rs.getFloat(5));rn list.add(form);rn rn conn.close();rn rs.close();rn dbc.close();rn stmt.close();rn rn catch(Exception ex)rn rn System.out.println(ex.getMessage()+"区域业绩查询");rn rn return list;rn
SQL错误:出现了不支持SQL92|137标记
电商项目— 查询所有订单 问题: 出现了不支持SQL92|137标记,insert … values… 解决方案:持久层语句尽量不要出现空格和 \n
“出现不支持的 SQL92 标记”这是什么原因?
在通过jdbc创建表时,用:rnStatement statement = conn.createStatement();rn String exesql = "create table " + Namern + "\n" + ""rn + "\n" + " " + "t_name " + "VARCHAR2(30);"rn + "\n" + " " + "t_date " + "VARCHAR2(30);"rn + "\n" + " " + "t_id " + "VARCHAR2(30);"rn + "\n" + "";rn sm.execute(sql);rn其中Name是作为参数传入,执行时会出现“出现不支持的 SQL92 标记”,是什么原因?
一个关于Spring整合iBATIS出现的异常 高分求解
我用的Spring MVC框架 Spring搭建好 在整合iBATIS,写好了代码和一系列配置文件 启动jboss 报错如下所示:rnrnorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'accountServiceImpl': Autowiring of fields failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private org.zlex.spring.dao.AccountDao org.zlex.spring.service.impl.AccountServiceImpl.accountDao; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'accountDaoImpl' defined in file [E:\jboss-4\server\default\tmp\deploy\tmp6025173491162088314spring-exp.war\WEB-INF\classes\org\zlex\spring\dao\impl\AccountDaoImpl.class]: Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Property 'sqlMapClient' is requiredrn at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessAfterInstantiation(AutowiredAnnotationBeanPostProcessor.java:243)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:959)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)rn at java.security.AccessController.doPrivileged(Native Method)。。。。。。rn。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。rnrnrn我的代码与配置文件如下所示rn领域模型Account,个人账户rn[code=Java]rnpublic class Account implements Serializablern private static final long serialVersionUID = -533698031946372178L;rn rn private int id;rn private String username; rn private String password; rn rn private Date birthday;rn private String email;rn //getter setter省略rn[/code]rnrn控制器省略 rnrn业务层及其实现:AccountService.java和AccountServiceImpl.javarn[code=Java]rn/**rn * 账户业务接口rn */rnrnpublic interface AccountService rnrn /**rn * 验证用户rn * @param usernamern * @param passwordrn * @returnrn */rn Account validUser(String username, String password);rnrnrn/**rn * rn * @author 梁栋rn * @version 1.0rn * @since 1.0rn */rn@Servicernpublic class AccountServiceImpl implements AccountService rnrn @Autowiredrn private AccountDao accountDao;rnrn @Overridern public Account validUser(String username, String password) rn // TODO Auto-generated method stubrn return accountDao.searchAccount(username, password);rn rnrn[/code]rnrn数据持久层 AccountDao及其AccountDaoImplrn[code=Java]rnrnpublic interface AccountDao rn rn public Account searchAccount(String username,String password);rnrnrn/**rn * 账户数据库实现rn * rn */rn@Repositoryrnpublic class AccountDaoImpl extends SqlMapClientDaoSupport implements AccountDao rnrn @Overridern public Account validAccount(String username, String password) rn rn return (Account) getSqlMapClientTemplate().queryForObject("MS-ACCOUNT-QUERY", username,password);rn rnrn[/code]rnrnSpring的配置文件applicationContext.xmlrn[code=XML]rnrnrn rn rn rn rn rnrn[/code]rndao.xml:rn[code=XML]rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn[/code]rnrnService.xmlrn[code=XML]rn rn rn rn rn rn [/code]rnrnrnIbatis的配置文件如下所示:rnibatis-sqlmap-mapping.xml文件:rn[code=XML]rnrnrnrn rn rnrn [/code]rnrnAccount-Sqlmap-Mapping.xml文件rn[code=XML]rnrnrnrn rn rn rn rn rn rn rnrn rn select * from account where username= 'snow' and password='wolf'rn rn rnrn [/code]rnrnrnrn
在学习ibatis的时候出现一个异常com.ibatis.common.jdbc.exception.NestedSQLException
我是一个初学者希望哪个高手指点下rncom.ibatis.common.jdbc.exception.NestedSQLException: rn--- The error occurred in com/mydomain/data/Account.xml. rn--- The error occurred while applying a result map. rn--- Check the Account.AccountResult. rn--- The error happened while setting a property on the result object. rn--- Cause: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.rnrnxml文件rnrnrnrnrnrnrn rn rnrn rn rn rn rn rn rn rnrn rn rn select * from ACCOUNTrn rnrn rn rn selectrn ACC_ID as id,rn ACC_FIRST_NAME as firstName,rn ACC_LAST_NAME as lastName,rn ACC_EMAIL as emailAddressrn from ACCOUNTrn where ACC_ID = #id#rn rn rn rn rn insert into ACCOUNT (rn ACC_ID,rn ACC_FIRST_NAME,rn ACC_LAST_NAME,rn ACC_EMAILrn values (rn #id#, #firstName#, #lastName#, #emailAddress#rn )rn rnrn rn rn update ACCOUNT setrn ACC_FIRST_NAME = #firstName#,rn ACC_LAST_NAME = #lastName#,rn ACC_EMAIL = #emailAddress#rn wherern ACC_ID = #id#rn rnrn rn rn delete from ACCOUNT where ACC_ID = #id#rn rnrnrnrn操作类rnimport com.ibatis.sqlmap.client.SqlMapClient;rnimport com.ibatis.sqlmap.client.SqlMapClientBuilder;rnimport com.ibatis.common.resources.Resources;rnimport com.mydomain.domain.Account;rnrnimport java.io.Reader;rnimport java.io.IOException;rnimport java.util.List;rnimport java.sql.SQLException;rnimport java.util.ArrayList;rnrn/**rn * This is not a best practices class. It's just an examplern * to give you an idea of how iBATIS works. For a more completern * example, see JPetStore 5.0 at http://www.ibatis.com.rn */rnpublic class SimpleExample rnrn /**rn * SqlMapClient instances are thread safe, so you only need one.rn * In this case, we'll use a static singleton. So sue me. ;-)rn */rn private static SqlMapClient sqlMapper;rnrn /**rn * It's not a good idea to put code that can fail in a class initializer,rn * but for sake of argument, here's how you configure an SQL Map.rn */rn static rn try rn Reader reader = Resources.getResourceAsReader("com/mydomain/data/SqlMapConfig.xml");rn sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);rn reader.close(); rn catch (IOException e) rn // Fail fast.rn throw new RuntimeException("Something bad happened while building the SqlMapClient instance." + e, e);rn rn rnrn public static List selectAllAccounts () throws SQLException rn // sqlMapper.startTransaction();rn List list = sqlMapper.queryForList("selectAllAccounts");rn //sqlMapper.commitTransaction();rnrn return list;rn rnrn public static Account selectAccountById (int id) throws SQLException rn return (Account) sqlMapper.queryForObject("selectAccountById", Integer.valueOf(id));rn rnrn public static void insertAccount (Account account) throws SQLException rn sqlMapper.insert("insertAccount", account);rn rnrn public static void updateAccount (Account account) throws SQLException rn sqlMapper.update("updateAccount", account);rn rnrn public static void deleteAccount (int id) throws SQLException rn sqlMapper.delete("deleteAccount", Integer.valueOf(id));rn rn rn public static void main(String[] args)rn rn SimpleExample simple = new SimpleExample();rn List list = new ArrayList();rn try rn list = simple.selectAllAccounts();rn catch (SQLException ex) rn ex.printStackTrace();rn rn System.out.println(list);rn rnrnrnsqlMapConfig.xmlrnrnrnrnrnrnrn rn rn rn rn rn rn rn rn rnrn rn rn rnrnrnrnrnAccount.javarnpublic class Account rnrn private int id;rn private String firstName;rn private String lastName;rn private String emailAddress;rnrn public int getId() rn return id;rn rnrn public void setId(int id) rn this.id = id;rn rnrn public String getFirstName() rn return firstName;rn rnrn public void setFirstName(String firstName) rn this.firstName = firstName;rn rnrn public String getLastName() rn return lastName;rn rnrn public void setLastName(String lastName) rn this.lastName = lastName;rn rnrn public String getEmailAddress() rn return emailAddress;rn rnrn public void setEmailAddress(String emailAddress) rn this.emailAddress = emailAddress;rn rnrnrn
Ctrl+C怎么会出现“标记没有引用存储”
同上
调用RMI 方法出现的异常...
rnrn启动TOMCAT 调用RIM 方法 时出现rn............rn............rnrn01:52:19,218 INFO :: SessionFactoryImpl > closingrn01:52:19,218 ERROR :: ContextLoader > Context initialization failedrnorg.springframework.beans.factory.BeanCreationException: Error creating bean witrnh name 'org.springframework.remoting.rmi.RmiServiceExporter#1' defined in ServlerntContext resource [/WEB-INF/classes/applicationContext-service.xml]: Invocationrnof init method failed; nested exception is java.rmi.ServerException: RemoteExceprntion occurred in server thread; nested exception is:rn java.rmi.UnmarshalException: error unmarshalling arguments; nested exceprntion is:rn java.net.MalformedURLException: no protocol: Files/Tomcat5.5.9/webapps/frnimsserver/WEB-INF/classes/rnCaused by:rnjava.rmi.ServerException: RemoteException occurred in server thread; nested excernption is:rn java.rmi.UnmarshalException: error unmarshalling arguments; nested exceprntion is:rn java.net.MalformedURLException: no protocol: Files/Tomcat5.5.9/webapps/frnimsserver/WEB-INF/classes/rn at sun.rmi.server.UnicastServerRef.oldDispatch(UnicastServerRef.java:385rn)rn at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:240)rn at sun.rmi.transport.Transport$1.run(Transport.java:153)rn at java.security.AccessController.doPrivileged(Native Method)rn at sun.rmi.transport.Transport.serviceCall(Transport.java:149)rn at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:4rn66)rn at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransportrn.java:707)rn at java.lang.Thread.run(Thread.java:595)rn at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamrnRemoteCall.java:247)rn at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:rn223)rn at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:343)rn at sun.rmi.registry.RegistryImpl_Stub.rebind(Unknown Source)rn at org.springframework.remoting.rmi.RmiServiceExporter.prepare(RmiServicrneExporter.java:256)rn at org.springframework.remoting.rmi.RmiServiceExporter.afterPropertiesSernt(RmiServiceExporter.java:197)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanrnFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1062)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanrnFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1029)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanrnFactory.createBean(AbstractAutowireCapableBeanFactory.java:420)rn at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObrnject(AbstractBeanFactory.java:245)rn at org.springframework.beans.factory.support.DefaultSingletonBeanRegistrrny.getSingleton(DefaultSingletonBeanRegistry.java:141)rn at org.springframework.beans.factory.support.AbstractBeanFactory.getBeanrn(AbstractBeanFactory.java:242)rn at org.springframework.beans.factory.support.AbstractBeanFactory.getBeanrn(AbstractBeanFactory.java:156)rn at org.springframework.beans.factory.support.DefaultListableBeanFactory.rnpreInstantiateSingletons(DefaultListableBeanFactory.java:290)rn at org.springframework.context.support.AbstractApplicationContext.refresrnh(AbstractApplicationContext.java:348)rn at org.springframework.web.context.support.AbstractRefreshableWebApplicarntionContext.refresh(AbstractRefreshableWebApplicationContext.java:156)rn at org.springframework.web.context.ContextLoader.createWebApplicationConrntext(ContextLoader.java:246)rn at org.springframework.web.context.ContextLoader.initWebApplicationConternxt(ContextLoader.java:184)rn at org.springframework.web.context.ContextLoaderListener.contextInitialirnzed(ContextLoaderListener.java:49)rn at org.apache.catalina.core.StandardContext.listenerStart(StandardContexrnt.java:3669)rn at org.apache.catalina.core.StandardContext.start(StandardContext.java:4rn104)rn at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBasern.java:759)rn at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:73rn9)rn at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)rnrn at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.javrna:894)rn at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.jrnava:857)rn at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:475rn)rn at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)rn at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.javarn:311)rn at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecyclrneSupport.java:119)rn at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)rnrn at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)rn at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)rnrn at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442rn)rn at org.apache.catalina.core.StandardService.start(StandardService.java:4rn50)rn at org.apache.catalina.core.StandardServer.start(StandardServer.java:683rn)rn at org.apache.catalina.startup.Catalina.start(Catalina.java:537)rn 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............rn...........rn2007-10-2 1:52:19 org.apache.catalina.startup.Catalina startrn信息: Server startup in 19953 msrn
请教:调用Node.Release出现的异常
代码如下:rnrn XMLDOMDocument2Ptr pXMLDom; rn IXMLDOMNodeListPtr pIDOMNodeList = NULL; rn IXMLDOMNodePtr pIDOMNODE = NULL;rn IXMLDOMNodePtr pIDOMParentNode = NULL;rn IXMLDOMNodePtr pNode = NULL;rn IXMLDOMNamedNodeMapPtr attr = NULL;rn // 初始化rn pIDOMNodeList = pXMLDom->getElementsByTagName( (TCHAR*)strFindText.data());rn for(int i=0; iitem[i]; rn AfxMessageBox((LPCSTR)pIDOMNODE->text);rn // 获取父节点 rn pIDOMParentNode = pIDOMNODE->parentNode; rn AfxMessageBox((LPCSTR)pIDOMParentNode->text);rn // 获取节点属性--后者是获取结点信息rn attr = pIDOMNODE->attributes;rn int count = attr->length;rn rn for(int i=0;iitem[i];rn AfxMessageBox((LPCSTR)pNode->nodeName);rn // pNode->Release(); //此地方不知道为啥不能释放!!!rn // pNode = NULL; rn rn // pNode->Release(); //此地方不知道为啥不能释放!!!rn // pNode = NULL;rn attr.Release();rn attr = NULL;rn pIDOMParentNode.Release();rn pIDOMParentNode = NULL;rn pIDOMNODE.Release();rn pIDOMNODE = NULL;rn rn 问题:上面关于pNode->Release()执行会出现异常,放在第二个循环中或者放在第二个循环外面都会出现。放在第二个for循环里面的话,第一次执行没问题,执行了release,在循环的时候就出异常了,屏蔽掉就没问题,不知道啥原因,多谢指教~rn
调用存储过程中出现的问题
我写了一个存储过程在数据库中,其中两参数传入,一个参数传出,返回记录集装入datagrid,但datagrid总也装不进数据,存储过程应该没问题,在SQL查询分析器中执行正常,请各位给看一下:rnrn存储过程参数定义:@sfid varchar(18),@year int,@fhbz int outputrnrnVB中调用代码如下:rnDim SQL As StringrnDim Rs As New ADODB.RecordsetrnDim rst As ADODB.RecordsetrnDim con As ADODB.ConnectionrnDim RsCmd As New ADODB.CommandrnDim dwID As StringrnDim SfCode As StringrnDim ghj As IntegerrnDim MsgString As StringrnrnrnPrivate Sub Command1_Click()rnrnSet Rs = CreateObject("ADODB.RECORDSET")rnSet RsCmd = CreateObject("ADODB.COMMAND")rnrnSet con = New ADODB.Connectionrncon.Open GetConnStrrncon.CursorLocation = adUseClientrnrnSet rst = New ADODB.RecordsetrnSQL = "select z_ylbxh,z_xm,tbsj=convert(char(10),z_tbsj,120),xb=case z_xbbm when 0 then '女' else '男' end,z_grxh,csrq=convert(char(10),z_csrq,120),z_tbdw_id,z_gzze,z_jfjs,rylb=case z_rylb when 0 then '在职' when 1 then '退休' else '其它' end,z_sfid from grzhxx00 where z_ylbxh='" & Trim(Text1.Text) & "'"rnSet rst = SelectSQL(SQL, MsgString)rnIf rst.EOF Thenrn MsgBox "您所查询的信息不存在,请加以确定!", 0 + 16 + 0, "注意!"rn Text1.Text = ""rn Text1.SetFocusrn Exit SubrnElsern dwID = Trim(rst.Fields(6))rn For i = 0 To 6rn Label4(i).Caption = Trim(rst.Fields(i))rn Next irn Label4(8).Caption = rst.Fields(7)rn Label4(9).Caption = rst.Fields(8)rn Label4(10).Caption = rst.Fields(9)rn SfCode = Trim(rst.Fields(10))rn SQL = "Select z_dwmc from tbdwxx00 where z_dwid='" & dwID & "'"rn Set rst = SelectSQL(SQL, MsgString)rn If rst.EOF Thenrn Label4(7).Caption = ""rn Elsern Label4(7).Caption = Trim(rst.Fields(0))rn End IfrnEnd IfrnrnrnRsCmd.ActiveConnection = conrnRsCmd.Parameters.Append RsCmd.CreateParameter("@sfid", adChar, adParamInput, 18)rnRsCmd.Parameters.Append RsCmd.CreateParameter("@year", adInteger, adParamInput)rnRsCmd.Parameters.Append RsCmd.CreateParameter("@fhbz", adInteger, adParamOutput)rnrnRsCmd.CommandText = "TaiYuan_grdzdjs"rnRsCmd.CommandType = adCmdStoredProcrnrnRsCmd.Parameters.RefreshrnrnRsCmd.Parameters("@sfid").Value = SfCodernRsCmd.Parameters("@year").Value = Combo1.TextrnSet Rs = RsCmd.Executern Set DataGrid1.DataSource = Rsrn DataGrid1.Refreshrn Label5.Caption = SfCodern Label6.Caption = Combo1.Text - 1rnrnEnd Subrnrnrnrn其中的基本信息导入也没问题,就是最后的存储过程装不进,为何,还请各位指教!
调用webservice,出现了java.net.NoRouteToHostException异常
http://ip地址:8000/xfire_service_zongzhan/services/intendance?wsdlrnrn已经把webservice放到了外网上的服务器了。上面这个路径我是可以直接访问到的,浏览器可以看到xml文件的。rnrnrn然后我根据这个url生成了客户端类,用来调用webservice的。如下:rnrnD:\generateAxisClient>Java -Djava.ext.dirs=lib org.apache.axis.wsdl.WSDL2Java rnhttp://211.147.247.85:8000/xfire_service_zongzhan/services/intendance?wsdlrnrn我是在cmd上执行的,使用了[color=#FF0000]axis[/color]的WSDL2Java来生成webservice的客户端的。rnrn现在我用生成的客户端去调用webservice,但是报错了。rnrn如下:rnrnjava.net.NoRouteToHostException: No route to host: connectrnrn这样的话,就无法把数据从本地传到服务器上了。rnrn出现了这种情况后,我首先是ping一下放有webservice的服务器,是ping不通的,原因是rn公司是通过代理的方式上网的,所以我直接ping不通了。rn而之前的uri可以访问是因为浏览器使用了代理,所以可以访问到服务器。rnrnrn想要问的问题是:rn 生成webservice的客户端有几种方式,我目前这种使用命令形式的生成的客户端中有rnXfireServiceHttpBindingStub这样一个类。似乎是静态的方式调用webservice。rn是不是应该换成动态代理方式或者其他方式呢?rnrn 要是客户那边是使用代理的方式上网的,应该如何写客户端,才可以把数据传到服务器上呢?rn请指导一下。
.net 调用webservice出现的异常
  不知道什么原因,new webserivce的时候出现的异常,而且只是个别XP系统抛这个异常,其他都正常rn  创建 system.serviceModel/bindings 的配置节处理程序时出错。。。  请高手解答。rnrn[code=html]************** 异常文本 **************rnSystem.TypeInitializationException: “DMain.manage”的类型初始值设定项引发异常。 ---> System.Configuration.ConfigurationErrorsException: 创建 system.serviceModel/bindings 的配置节处理程序时出错: 未能从程序集“System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089”中加载类型“System.Security.Authentication.ExtendedProtection.Configuration.ExtendedProtectionPolicyElement”。 (D:\Program Files\DD\DMain.exe.Config line 4) ---> System.TypeLoadException: 未能从程序集“System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089”中加载类型“System.Security.Authentication.ExtendedProtection.Configuration.ExtendedProtectionPolicyElement”。rn 在 System.ServiceModel.Configuration.HttpTransportSecurityElement.get_Properties()rn 在 System.Configuration.ConfigurationElement.DeserializeElement(XmlReader reader, Boolean serializeCollectionKey)rn 在 System.Configuration.ConfigurationElement.DeserializeElement(XmlReader reader, Boolean serializeCollectionKey)rn 在 System.Configuration.ConfigurationElement.DeserializeElement(XmlReader reader, Boolean serializeCollectionKey)rn 在 System.Configuration.ConfigurationElementCollection.OnDeserializeUnrecognizedElement(String elementName, XmlReader reader)rn 在 System.Configuration.ConfigurationElement.DeserializeElement(XmlReader reader, Boolean serializeCollectionKey)rn 在 System.Configuration.ConfigurationElement.DeserializeElement(XmlReader reader, Boolean serializeCollectionKey)rn 在 System.Configuration.ConfigurationSection.DeserializeSection(XmlReader reader)rn 在 System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.CreateSectionImpl(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentConfig, ConfigXmlReader reader)rn 在 System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.CreateSectionWithRestrictedPermissions(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentConfig, ConfigXmlReader reader)rn 在 System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.CreateSection(Boolean inputIsTrusted, RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentConfig, ConfigXmlReader reader)rn 在 System.Configuration.RuntimeConfigurationRecord.CreateSection(Boolean inputIsTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentConfig, ConfigXmlReader reader)rn 在 System.Configuration.BaseConfigurationRecord.CallCreateSection(Boolean inputIsTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentConfig, ConfigXmlReader reader, String filename, Int32 line)rn --- 内部异常堆栈跟踪的结尾 ---rn 在 System.Configuration.BaseConfigurationRecord.EvaluateOne(String[] keys, SectionInput input, Boolean isTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult)rn 在 System.Configuration.BaseConfigurationRecord.Evaluate(FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult, Boolean getLkg, Boolean getRuntimeObject, Object& result, Object& resultRuntimeObject)rn 在 System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)rn 在 System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)rn 在 System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)rn 在 System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)rn 在 System.Configuration.BaseConfigurationRecord.GetSection(String configKey)rn 在 System.Configuration.ClientConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String sectionName)rn 在 System.Configuration.ConfigurationManager.GetSection(String sectionName)rn 在 System.ServiceModel.Configuration.ConfigurationHelpers.UnsafeGetSectionFromConfigurationManager(String sectionPath)rn 在 System.ServiceModel.Configuration.ConfigurationHelpers.UnsafeGetAssociatedSection(ContextInformation evalContext, String sectionPath)rn 在 System.ServiceModel.Configuration.ClientSection.UnsafeGetSection()rn 在 System.ServiceModel.Description.ConfigLoader.LookupChannel(String configurationName, String contractName, Boolean wildcard)rn 在 System.ServiceModel.Description.ConfigLoader.LoadChannelBehaviors(ServiceEndpoint serviceEndpoint, String configurationName)rn 在 System.ServiceModel.ChannelFactory.ApplyConfiguration(String configurationName)rn 在 System.ServiceModel.ChannelFactory.InitializeEndpoint(String configurationName, EndpointAddress address)rn 在 System.ServiceModel.ChannelFactory`1..ctor(String endpointConfigurationName, EndpointAddress remoteAddress)rn 在 System.ServiceModel.EndpointTrait`1.CreateSimplexFactory()rn 在 System.ServiceModel.EndpointTrait`1.CreateChannelFactory()rn 在 System.ServiceModel.ClientBase`1.CreateChannelFactoryRef(EndpointTrait`1 endpointTrait)rn 在 System.ServiceModel.ClientBase`1.InitializeChannelFactoryRef()rn 在 System.ServiceModel.ClientBase`1..ctor()rn 在 Commons.DWebService.DWebSoapClient..ctor()rn 在 DMain.manage..cctor()rn --- 内部异常堆栈跟踪的结尾 ---rn 在 DMain.manage..ctor()rn 在 DMain.manage.btnSMS_Click(Object sender, EventArgs e)rn 在 System.Windows.Forms.Control.OnClick(EventArgs e)rn 在 System.Windows.Forms.Button.OnClick(EventArgs e)rn 在 System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)rn 在 System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)rn 在 System.Windows.Forms.Control.WndProc(Message& m)rn 在 System.Windows.Forms.ButtonBase.WndProc(Message& m)rn 在 System.Windows.Forms.Button.WndProc(Message& m)rn 在 System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)rn 在 System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)rn 在 System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)[/code]
WebService调用出现 java.net.UnknownHostException异常?
我采用Axis技术访问另外一个服务商提供的webService,调用时出现了java.net.UnknownHostException异常rnrn访问方法如下:rn String endpointURL = "http://172.16.0.65/PowerInfo/WebServiceReportWar/ReportParser";rn rn invoker = DynamicInvoker.getInstance(endpointURL.toString());rn rn if(invoker == null)rn rn System.out.println("invoker is null");rnrn rnrn String xml = (String)invoker.invokeMethod("getXMLDocument",new String[]"41311036320101000","1114","2006","09","10");rn if(ObjectUtil.isNullOrEmpty(xml))rn rn System.out.println("return xml is null");rn rnrnrnrn在invoke方式时报错,
JSP连接oracle出现这种异常 求解?
java.sql.SQLException: Io 异常: Got minus one from a read callrn 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:255)rn at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)rn at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:414)rn at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)rn at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)rn at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)rn at java.sql.DriverManager.getConnection(DriverManager.java:582)rn at java.sql.DriverManager.getConnection(DriverManager.java:185)rn at oracle.SQLHelper.executeQuery(SQLHelper.java:106)rn at oracle.Test.main(Test.java:13)rnException in thread "main" java.lang.RuntimeException: Io 异常: Got minus one from a read callrn at oracle.SQLHelper.executeQuery(SQLHelper.java:118)rn at oracle.Test.main(Test.java:13)rnrn需要贴出代码么?
jboss的实体类过时出现错误
修改:可以从新打包实体,从新发布
hibernate4+spring3+oracle11g出现不支持的特性
项目原先用的是mysql,后来因为需要切换到oracle,但是切换过来后,hql语句执行就出错,原生的sql语句就没有问题,rn数据库配置如下rn[code=java]jdbc.dbType=oraclernvalidationQuery=SELECT 1 FROM DUAL rnjdbc.driverClassName=oracle.jdbc.OracleDriverrnhibernate.dialect=org.hibernate.dialect.Oracle10gDialectrnjdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:ORCLrnjdbc.username=backrnjdbc.password=bacrninitialSize=100rnmaxActive=100rnmaxIdle=20rnmaxWait=60000rnhibernate.hbm2ddl.auto=none[/code]rn[code=java][broa] [WARN] 2016-12-29 10:13:57 [http-8083-1] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] SQL Error: 17023, SQLState: 99999 rn[broa] [ERROR] 2016-12-29 10:13:57 [http-8083-1] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] 不支持的特性 rn[broa] [ERROR] 2016-12-29 10:13:57 [http-8083-1] [org.jeecgframework.core.common.exception.MyExceptionHandler] org.hibernate.exception.GenericJDBCException: 不支持的特性rn at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)rn at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)rn at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)rn at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:108)rn at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)rn at com.sun.proxy.$Proxy206.getBytes(Unknown Source)rn at org.hibernate.type.descriptor.sql.VarbinaryTypeDescriptor$2.doExtract(VarbinaryTypeDescriptor.java:66)rn at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:65)rn at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:269)rn at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:265)rn at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:238)rn at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:357)rn at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2701)rn at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1541)rn at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1473)rn at org.hibernate.loader.Loader.getRow(Loader.java:1373)rn at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:640)rn at org.hibernate.loader.Loader.doQuery(Loader.java:850)rn at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289)rn at org.hibernate.loader.Loader.doList(Loader.java:2447)rn at org.hibernate.loader.Loader.doList(Loader.java:2433)rn at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2263)rn at org.hibernate.loader.Loader.list(Loader.java:2258)rn at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:470)rn at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)rn at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:196)rn at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1161)rn at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)rn at org.jeecgframework.core.common.dao.impl.CommonDao.getUserByUserIdAndUserNameExits(CommonDao.java:85)rn at jeecg.system.service.impl.UserServiceImpl.checkUserExits(UserServiceImpl.java:50)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)rn at java.lang.reflect.Method.invoke(Method.java:606)rn at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)rn at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)rn at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)rn at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)rn at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)rn at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)rn at com.sun.proxy.$Proxy79.checkUserExits(Unknown Source)rn at jeecg.system.controller.core.LoginController.checkuser(LoginController.java:128)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)rn at java.lang.reflect.Method.invoke(Method.java:606)rn at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)rn at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)rn at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)rn at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)rn at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)rn at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)rn at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)rn at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:140)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)rn at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)rn at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)rn at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)rn at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)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:127)rn at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)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:859)rn at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:610)rn at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:503)rn at java.lang.Thread.run(Thread.java:724)rnCaused by: java.sql.SQLException: 不支持的特性rn at oracle.jdbc.driver.ClobAccessor.getBytes(ClobAccessor.java:519)rn at oracle.jdbc.driver.GeneratedStatement.getBytes(GeneratedStatement.java:151)rn at oracle.jdbc.driver.GeneratedScrollableResultSet.getBytes(GeneratedScrollableResultSet.java:300)rn at oracle.jdbc.driver.GeneratedResultSet.getBytes(GeneratedResultSet.java:1284)rn at com.alibaba.druid.filter.FilterChainImpl.resultSet_getBytes(FilterChainImpl.java:879)rn at com.alibaba.druid.filter.stat.StatFilter.resultSet_getBytes(StatFilter.java:950)rn at com.alibaba.druid.filter.FilterChainImpl.resultSet_getBytes(FilterChainImpl.java:877)rn at com.alibaba.druid.proxy.jdbc.ResultSetProxyImpl.getBytes(ResultSetProxyImpl.java:249)rn at com.alibaba.druid.pool.DruidPooledResultSet.getBytes(DruidPooledResultSet.java:341)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)rn at java.lang.reflect.Method.invoke(Method.java:606)rn at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:104)rn ... 74 morern [/code]
ibatis调用mysql存储过程出错,求解?
错误信息为:rnorg.springframework.jdbc.UncategorizedSQLException:SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1009]; error code [0]; --- The error occurred while applying a parameter map. --- Check the callEmpTreeList-InlineParameterMap. --- Check the statement (update procedure failed). --- Cause: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: rnrnrnjava 代码:rnMap newMap = new HashMap();rn newMap.put("organId", "0");rn getSqlMapClientTemplate().insert(rn "callEmpTreeList", newMap);rnxml配置为:rnrn call Pro_GetEmpTreeList('4028804a274a8bb10128fd56877e4d44')rn rnrn存储过程为:rnCREATE PROCEDURE `Pro_GetEmpTreeList`(in pid varchar(36))rnbegin rn declare lev int;rn set lev=1;rn drop table if exists tmp1; rn CREATE TABLE tmp1(id VARCHAR(40),employee_organname varchar(50),parentid varchar(40) ,levv INT); rn INSERT tmp1 SELECT id,employee_organname,parent_id,1 FROM `hr_employee` WHERE parent_id=pid; rn while row_count()>0 rn do set lev=lev+1; rn INSERT tmp1 SELECT t.id,t.employee_organname,t.parent_id,lev from hr_employee t join tmp1 a on t.parent_id=a.id AND levv=lev-1;rn end while ; rn INSERT tmp1 SELECT id,employee_organname,parent_id,0 FROM hr_employee WHERE id=pid; rnendrn我这里为了测试就没传参数直接写死,直接在mysql中执行call Pro_GetEmpTreeList('4028804a274a8bb10128fd56877e4d44')是没有问题的,rnrnrn求解........rn
iOS 9 出现的问题
今天通知ios提交的版本被拒绝了,看了下 崩溃日志,原来苹果那边用ios9.0进行的测试,果断进行手机操作系统,电脑系统,xcode等一系列升级,在升级过程中 出现了一些问题,现在记录下,供后来复习用。 1. 首先就是编译报错,说bitcode      ld: ‘/Users/**/Framework/SDKs/PolymerPay/Library/mobStat/lib**SDK.a(**
【异常】SptingBoot+RabbitMQ整合出现的异常
c.r.c.impl.ForgivingExceptionHandler : An unexpected connection driver error occured (Exception message: Socket closed) o.s.a.r.listener.BlockingQueueConsumer : Queue declaration failed; retries left=3
调用.bat文件出现main()异常
我的程序实现这样的功能:rnrn[size=12px]首先执行带main()函数的java类->进入登录界面,输入用户名和密码后->进入主界面rn在主界面当点击一个按钮的时候,调用.bat文件,而.bat文件的作用是执行另一个带main()函数的java类(这里假设这个类叫BAT)rn现在问题来了:说是出现一个线程的错误,是关于main()的,错误在BAT这个类中rn当单独执行.bat文件没有任何问题,程序能够正确弹出界面rn请问各位朋友有没有碰到这样的情况,该怎么解决?是不是俩个main()函数执行的时候设计到线程引起的??[/size]
dll调用关闭出现内存访问异常
建立了一个win32dllrnrn[code=C/C++]rn//////EnumProc.h//////rnextern "C" _declspec(dllexport) void GetProc();rn[/code]rnrn[code=C/C++]rnrn////////////EnumProc.cpp////////////////rn#include "EnumProc.h"rnrnrn_ConnectionPtr m_pConnection=NULL;rn_RecordsetPtr m_pRecordSet=NULL;rn/////////////////////////////////////////rnvoid OnInitDB();//初始化m_pConnectionrnrnvoid GetRecordSet(_bstr_t bstrSQL);rnBOOL ExecuteSQL(_bstr_t bstrSQL);rnrnvoid ExitConnect();rnrn///////////////////////////////////////////////////////////////////rnrnrnrnrnBOOL APIENTRY DllMain( HANDLE hModule, rn DWORD ul_reason_for_call, rn LPVOID lpReservedrn )rnrnrn return TRUE;rnrnrnrnrnvoid GetProc()rnrn OnInitDB();rn ExitConnect();rnrnrnrnrnvoid OnInitDB()rnrn rn ::CoInitialize(NULL);rnrn tryrn rn rn HRESULT hResult=m_pConnection.CreateInstance(__uuidof(Connection));rnrn if(!SUCCEEDED(hResult))rn return;rnrn _bstr_t strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Proc.mdb";rn m_pConnection->Open(strConnect,"","",adModeUnknown);rnrn rn rn catch(_com_error e)rn rn rn MessageBox(NULL,e.Description(),"Connection",NULL);rn rnrnrnrnvoid GetRecordSet(_bstr_t bstrSQL)rnrn tryrn rn // 连接数据库,如果Connection对象为空,则重新连接数据库rn if(m_pConnection==NULL)rn OnInitDB();rnrnrn HRESULT hResult=m_pRecordSet.CreateInstance(__uuidof(Recordset));rnrn if(!SUCCEEDED(hResult))rn return;rn m_pRecordSet->Open(bstrSQL,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);rn rn // 捕捉异常rn catch(_com_error e)rn rnrn //MessageBox(NULL,e.Description(),"Recordset",NULL);rn rnrnrnrnBOOL ExecuteSQL(_bstr_t bstrSQL)rnrn tryrn rn // 是否已经连接数据库rn if(m_pConnection == NULL)rn OnInitDB();rnrn m_pConnection->Execute(bstrSQL,NULL,adCmdText);rnrn return true;rn rn catch(_com_error e)rn rn //MessageBox(NULL,e.Description(),"Execute",NULL);rnrn return false;rn rnrnrnvoid ExitConnect()//关闭数据库链接 释放环境rnrn if (m_pRecordSet != NULL)rn m_pRecordSet->Close();rn m_pConnection->Close();rn // 释放环境rn ::CoUninitialize();rnrnrn[/code]rnrn///////////////////////////rn用Test.exe对话框程序调用 dllrn添加了一个 Button 事件rn在TestDlg.cpp 文件里面的代码rn[code=C/C++]rnrn#include "EnumProc.h"rnrnrnrn#pragma comment(lib,"EnumProc.lib")rnextern "C" _declspec(dllimport) void GetProc();rnrnvoid CTestDlg::OnButton1() rnrn rn GetProc();rn rnrnrn[/code]rnrn现在出现的情况是:rn1>rn没有按下Button1,直接点对话框上的 “确定”“取消”或者 右上角的 “X” 关闭对话框都正常rn如果点了Button1,在关闭对话框前以前都是正常的,但是不管是用“确定”“取消”还是右上角的“X” 来关键对话框,都会弹出一个“Test.exe-应用程序错误”rn错误的内容是“0x。。。。。”指令应用的“0x。。。。”内存。该内存不能为“read”。。。。。”rnrn2>如果去掉OnButton1()里面的 GetProc(); 也就是说没用调用dll的导出函数,则程序正常,这个说明Test.exe是没有问题的rnrn3>如果将 dll中 GetProc()函数内的 OnInitDB();和ExitConnect();函数 注释掉,也就是不调用这2个函数,也是正常的。rnrnrn不管在vc6.0 还是vs。net2003 里面 问题都是这样的,请问这个是什么原因造成的,是不是我的dll写错了
C#调用COM接口,出现AccessViolationException异常,求助
COM接口定义:rnHRESULT SendXXXCommands([in] VARIANT v, [out, retval] long* pVal);rn其中,v接受一个byte型数组。rnrnC#调用:rn[code=C#]rnpublic void SendXXXCommand(byte[] cmd)rnrn myCom.SendXXXCommands(cmd);rnrn[/code]rnrn调用的时候出现AccessViolationException异常。rnrn查了一下,有人说是托管代码调用非托管代码时的问题。rn改成了一下的代码:rn[code=C#]rnpublic void SendXXXCommand(byte[] cmd)rnrn int size = Marshal.SizeOf(cmd[0]) * cmd.Length;rn IntPtr pnt = Marshal.AllocHGlobal(size);rn Marshal.Copy(cmd, 0, pnt, cmd.Length);rnrn myCom.SendXXXCommands(pnt);rnrn[/code]rnrn倒是没有出异常,但是死机。执行到myCom.SendXXXCommands(pnt);就不动弹了,程序挂掉。rnrn请有经验的朋友指点指点。
oracle调用webservice出现找不到服务的异常
oracle调用webservice出现找不到服务的异常,代码如下:rncreate or replacernFunction Test(rnXmlstring Varchar2rn)rn RETURN VARCHAR2rn ASrn l_service utl_dbws.SERVICE;rn l_call utl_dbws.call;rn l_result ANYDATA;rn l_wsdl_url VARCHAR2(1024);rn l_service_name VARCHAR2(200);rn L_Operation_Name Varchar2(200);rn l_namespace_name varchar2(200);rn L_Input_Params Utl_Dbws.Anydata_List;rn Beginrn L_Wsdl_Url := 'http://www.usoftchina.com/ws95/services/vendor?wsdl';rn L_Service_Name := 'vendorService';rn L_Operation_Name := 'vendorinfo';rn L_Service := Utl_Dbws.Create_Service(Wsdl_Document_Location=>Urifactory.Geturi(L_Wsdl_Url),Service_Name=>L_Service_Name); rn L_Call := Utl_Dbws.Create_Call(Service_Handle=>L_Service,Port_Name=>'vendor',Operation_Name=>L_Operation_Name); rn L_Input_Params(0) := Anydata.Convertvarchar2(Xmlstring);rn L_Result := Utl_Dbws.Invoke(Call_Handle=>L_Call,Input_Params=>L_Input_Params); rn UTL_DBWS.release_call (call_handle=>l_call);rn Utl_Dbws.Release_Service (Service_Handle=>L_Service);rn RETURN ANYDATA.AccessVarchar2(l_result);rn EXCEPTIONrn When Others Thenrn RETURN SUBSTR(sqlerrm,0,2000000000);rn END test;rnrnrn-----------抛出的异常是rnrnORA-29532: Java 调用被未捕获的 Java 异常错误终止: java.lang.IllegalAccessException: javax.xml.rpc.ServiceException: Error processing WSDL document: rnjavax.xml.rpc.ServiceException: Error processing WSDL document: rnjavax.xml.rpc.ServiceException: Cannot find service: vendorServicernrn请问高手们,怎么解决?
C#调用oracl存储过程 出现的异常 请教 ~~
遇到一个问题,实在解决不了,所以贴到论坛上,请教 ~~rnrn 在c# 程序中调用oracle的存储过程,并且调用的存储过程中 有事务处理的代码 (关键是 savepoint X ,roll back )rn 如果注释掉 savepoint X 这句话,就不会出现异常 ~~rnrn 如下为异常的详细信息 :rnrn栈跟踪: rnrnrn[Exception: ORA-02074: 无法在分布式事务处理中ROLLBACKrnORA-06512: 在"MB_MMS_SCHOOL_777.PK_IMPORT", line 407rnORA-02074: 无法在分布式事务处理中SET SAVEPOINTrnORA-06512: 在line 1rn]rn SendSms.btnSubmitSMS_Click(Object sender, EventArgs e) in e:\source\GaoXiaoTongMIS\SendSms.aspx.cs:127rn System.Web.UI.WebControls.Button.OnClick(EventArgs e) +96rn System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +116rn System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +31rn System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32rn System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +72rn System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3838rnrn rn
QTableWidget中调用setItem出现QtCored4.dll异常
我在一个按钮中调用QTableWidget的setItem 函数出现访问冲突,何解?
调用BeginInvoke方法,出现NotSupportedException异常。
delegate void Call(); rn private void button2_Click(object sender, EventArgs e)rn rn Call call = new Call(threadporc);rn call.BeginInvoke(null, null); rn rnrn private void threadporc()rn rnrn rn运行以上代码会出NotSupportedException异常,但是把这个代码放到winforms下运行就没有问题啊。
为什么我的调用出现访问异常
我采用view->class wizard->new class->from a tpye lib引入一IXIBO_A对象rnIXIBO_A *pXiboA=0;rnHRESULT hr = CoCreateInstance(CLSID_XIBO_A,NULL,CLSCTX_SERVER,IID_IXIBO_A,(void**)&pXiboA);rnif(SUCCEEDED(hr))rn pXiboA->a(); //运行到这里时出现了访问异常rnrn小弟初学,不知道是什么原因造成的
c#调用surfer时出现80080005的异常
“System.Runtime.InteropServices.COMException”类型的异常在 mscorlib.dll 中发生,但未在用户代码中进行处理nn其他信息: 检索 COM 类工厂中 CLSID 为 B2933480-9788-11D2-9780-00104B6D9C80 的组件失败,原因是出现以下错误: 80080005 服务器运行失败 (异常来自 HRESULT:0x80080005 (CO_E_SERVER_EXEC_FAILURE))。nn急等,求解答
android调用系统的安装方法出现ActivityNotFoundException的异常
今天测试下载新版本后自动安装,结果报错了~ 后来查了一下,是DownloadManager的问题~ 从Android 4.2开始,manager.getUriForDownloadedFile(id)将返回的scheme是content,返回uri是content://downloads/my_downloads/15,没有给出路径,这样调用系统的安装方法就会出现ActivityNotFound
delphi出现‘尚未调用CoInitialize’异常
1. 由于使用ado等引起的异常。 2. 若是子线程或某方法操作ado可在该方法开头和结尾分别加上: function myfun begin CoInitialize(nil); // your code; CoUninitialize; end; 3. 在主方法加入该句子有时候不能解决问题,因为默认是初始化主线程的,只有在子线程或方法加入才行。
急!程序调用WebService出现NullReferenceException异常
程序调用WebService出现NullReferenceException异常。rn不是程序的问题,因为开发时程序调用本机(Win7)的就没问题,把WebService发布到Win2008后,就出现这个异常。rn而且网页访问也没问题。rn开发的是WinCE程序,查数据库需要用WebService。rn项目明天(确切的说是今天8个多小时后)就上线了,急啊,这两天把WebService发布到服务器就出现了问题,不知道是不是Win2008设置有问题。
求助:C++builder调用存储出现的问题
我手动在SQL里执行这个存储都是OK的,结果也能显示出来,但用以下代码在C++builder里就出现错误提示“ProcCheckLMacWMac:Field'Measured' not found”,其中ProcCheckLMacWMac是一个ADOStoredProc控件,请大家帮忙看看是什么问题,谢谢了。rn[code=C/C++]rnvoid __fastcall TForm1::Button3Click(TObject *Sender)rnrn ProcCheckLMacWMac->Parameters->Clear();rn ProcCheckLMacWMac->Close();rn ProcCheckLMacWMac->Connection=ADOConnection1;rn ProcCheckLMacWMac->Prepared=true;rn ProcCheckLMacWMac->ProcedureName="SP_TestGetSNData;1";rn ProcCheckLMacWMac->Parameters->CreateParameter("@SN",ftString,pdInput,50,OleVariant(0));rn ProcCheckLMacWMac->Parameters->CreateParameter("@DataType",ftString,pdInput,50,OleVariant(0));rnrn ProcCheckLMacWMac->Parameters->ParamByName("@SN")->Value="ANK1E2H19JW0001";rn ProcCheckLMacWMac->Parameters->ParamByName("@DataType")->Value="PreMac";rnrn ProcCheckLMacWMac->ExecProc();rn //Sleep(5000);rnrn AnsiString s1=ProcCheckLMacWMac->FieldByName("@Measured")->AsString;rnrn Edit1->Text=s1;rnrn[/code]
sap JCO出现多线程调用异常
近来查看我们系统日志,发现一个异常出现了很多次,com.sap.mw.jco.JCO$Exception: (132) JCO_ERROR_CONCURRENT_CALL: Concurrent call. Connection currently used in another thread. 在google老师的帮助之下发现,原来是JCO.Client这个实例同时被两个以上的thread使用...
调用驱动后出现的警告信息求解
我在ARM9开发板上做CAN通信测试,驱动是自己改的,测试时虽然接收数据正确了,但中间伴有警告信息,不知何故?rncan test start rninit mcp2510 over rnstate ok rnOpen device success. rnsend datagram. rnthe data sended is abcd1234. rndata_receive.BufNo = 3 rndata_receive.IdType = 0 rndata_receive.id = 23rnd[color=#FF0000]Trying to free nonexistent resource <0000000059000000-0000000059000037> rnTrying to free nonexistent resource <0000000056000000-0000000056000093> rnTrying to free nonexistent resource <000000004c00000c-000000004c00000f> rn------------[ cut here ]------------ rnWARNING: at kernel/irq/manage.c:735 __free_irq+0x114/0x1c0() rnTrying to free already-free IRQ 20 rnModules linked in: candrv ov9650 zd1211rw rt73usb rt2x00usb rt2x00lib mac80211 vrnBacktrace:rn...rn---[ end trace eaef40f5fe83d0b7 ]---[/color] rnata_receive.DataLen = 8 rndata_receive.data = abcd1234
ibatis执行存储过程出现阻塞
在用ibatis调用mysql存储过程时,出现线程阻塞,但是存储过程中的数据插入却成功了,但是没有返回结果。 我写的存储过程执行了查询、添加、更新操作,并且返回一个int结果。 解决办法: 将dao的执行变成:update即可; 另外,查了有关的网友写的: 如果你的存储过程返回一个结果集,那么使用queryForList()或者queryForObject来调用;  
关于ibatis使用出现的问题
各位大侠,小弟刚接触ibatis遇到了这样的问题:rnrn在sqlMapConfig.xml中 "http://ibatis.apache.org/dtd/sql-map-config-2.dtd" 这一行出现rnThe file cannot be validated as there was a connection problem. 的警告。rn另外,按Alt+/也不会提示sqlMap子标签的信息。rn大家是否也遇到了这样的问题啊?
ibatis 插入语句出现的问题,
SQL语句如下:rnrn insert into tecDemand(cooperationWayID,userTypeID,auditStateID,ofIndustryID,tecDemandTitle,rn tecIntruduction,tecDemandProfit,traPrice,amoInvested,expInvPeriod,expInvRate,regDate,tecDemandCliRate,userID,rn appArea,mailAddress,contacts,postcode,telphone,mobile,fax,email)rn values ( rn #cooperationWayDictionary.dictionaryID#,#user.userTypeDictionary.dictionaryID#,rn #tecDemandAuditStateDictionary.dictionaryID#,#ofIndustryDictionary.dictionaryID#,#tecDemandTitle#,#tecIntruduction#,rn #tecDemandProfit#,#traPrice#,#amoInvested#,#expInvPeriod#,#expInvRate#,#regDate#,#tecDemandCliRate#,#user.userID#,rn #appArea#,#contact.address#,#contact.contacts#,#contact.postcode#,#contact.telephone#,#contact.mobile#,rn #contact.fax#,#contact.email#rn )rnrn报错误如下:rnCaused by: com.ibatis.common.jdbc.exception.NestedSQLException: rn--- The error occurred in cn/tyast/dao/impl/sqlmap/demand/tecDemand.xml. rn--- The error occurred while applying a parameter map. rn--- Check the addTecDemand-InlineParameterMap. rn--- Check the parameter mapping for the 'tecDemandAuditStateDictionary.dictionaryID' property. rn--- Cause: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver.rnCaused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver.rn at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)rn at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:442)rn at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:81)rn at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:58)rn at com.ibatis.dao.client.template.SqlMapDaoTemplate.insert(SqlMapDaoTemplate.java:100)rn ... 29 morernCaused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver.rn at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)rn at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)rn at com.microsoft.jdbc.base.BasePreparedStatement.validateSqlType(Unknown Source)rn at com.microsoft.jdbc.base.BasePreparedStatement.setObjectInternal(Unknown Source)rn at com.microsoft.jdbc.base.BasePreparedStatement.setNull(Unknown Source)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 com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:70)rn at $Proxy3.setNull(Unknown Source)rn at com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameter(BasicParameterMap.java:171)rn at com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameters(BasicParameterMap.java:125)rn at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:80)rn at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)rn at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)rn ... 33 morernrn请问各位大虾,怎么个参数不对了?rn
ibatis 查询数据时出现乱码问题
我用的是mysql数据库,在iBATIS 读取数据时出现乱码问题,怎么解决,麻烦各位同仁!!!!!
spring配置ibatis时出现NoClassDefFoundError
新手,刚学spring rn照着文档和网上的资料做了一篇配置rn[b]applicationContext.xml:[/b]rnrnrnrnrnrnrnrn[b]friend.xml:[/b]rnrnrnrnrnrnrnrnrnrnrnrnrnrnselect friends.name,friends.age,friends.sexrnfrom friendsrnwhere friends.id = #value#rnrnrnrninsert into friends(id,name,age,sex) values (#id#, #name#, #age#, #sex#)rnrnrnrnrn[b]sqlmap-config.xml:[/b]rnrnrnrnrnrnrnrnrnrn[b]SqlMapFriendDAO :[/b]rnpublic class SqlMapFriendDAO extends SqlMapClientDaoSupport implements FriendDAOrnpublic Friend getFriendById(String id) throws DataAccessException rnreturn (Friend) getSqlMapClientTemplate().queryForObject("getFriendById", id);rnrnrnpublic void insertFriend(Friend f) throws DataAccessException rngetSqlMapClientTemplate().update("insertFriend", f);rnrnrnrnrn[b]最后在测试类中:[/b]rnpublic class Test2 rnrn/**rn* @param argsrn*/rnpublic static void main(String[] args) rnApplicationContext context = new ClassPathXmlApplicationContext("classpath/applicationContext.xml");rnSqlMapFriendDAO dao = (SqlMapFriendDAO) context.getBean("SqlMapFriendDAO");rnFriend f = dao.getFriendById("1");rnSystem.out.println(f.getName());rnrnrnrnrnrn[b]结果却出现以下错误:[/b]rnorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in class path resource [classpath/applicationContext.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundErrorrnrn[b]在此申明已加入spring.jar包,可以Tets2.java中导入SqlMapClientFactoryBean类,但依然报这个错误,请问各位高手们要怎么解决。。。。[/b]
调用存储过时 搜索数据 问题
我写了个用户控件 搜索数据 在执行存储过程时有时间返回 但是在业务层好像没数据rnrn怎么都搜不出数据 在表示层没数据rnrn留个Qrnrn要看程序的 加我 谢谢rnrn1615128878
ibatis异常
才学Ibatis,DAO什么的都已经生成好了。如何才能插入数据或查询数据?rn是在pulibc static void main(String args[])里实现吗rn怎么我报Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactoryrn需要配置服务器吗?
相关热词 c# 线程结束时执行 c# kb mb 图片 c# 替换第几位字符 c#项目决定成败 c# 与matlab c# xml缩进 c#传感器基础 c#操作wps c# md5使用方法 c# 引用父窗口的组件