java.sql.SQLException: This operation is not supported.DSRA0010E: SQL State = null, Error Code = 0

Google Groups | Scott Herter | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Method cleanup failed while trying to execute method cleanup on ManagedConnection

    Google Groups | 1 decade ago | Scott Herter
    java.sql.SQLException: This operation is not supported.DSRA0010E: SQL State = null, Error Code = 0
  2. 0

    Re: Method cleanup failed while trying to execute method cleanup on ManagedConnection

    tech-archive.net | 1 year ago
    java.sql.SQLException: This operation is not supported.DSRA0010E: SQL State = null, Error Code = 0 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
  3. 0

    java.sql.SQLException: No value specified for parameter 1解决办法_IT知识问答_希赛网

    educity.cn | 2 years ago
    java.sql.SQLException: No value specified for parameter 1 代码如下 public boolean login(UserInfo user)throws Exception{ //用户登录 boolean flag=false; int userNo=Integer.parseInt(user.getUserNo()); String password=user.getPassword(); //测试是否从现在的user对象中取到了值 System.out.println(userNo+"我是USER对象的userNo"); System.out.println(password+"我是USER对象的password"); DatabaseConnection dbc=new DatabaseConnection();//取得数据库连接和关闭对象; try{ String sql="SELECT userNo FROM userInfo where userNo= and password= "; this.conn=dbc.getConnection(); this.pst=conn.prepareStatement(sql); //this.pst.setInt(1, userNo);//给sql中参数赋值 this.pst.setLong(1, userNo); this.pst.setString(2, password); ResultSet rs=pst.executeQuery(); if(rs.next()){//传入用户账号和对应的密码都存在时为真 flag=true; System.out.println(rs.getString(userNo)+"我是从数据库里取出来的"); System.out.print(flag+"测试flag");//测试flag,看是否进入了if里面,true则进入了 rs.close(); } }catch(Exception e){ e.printStackTrace(); }finally{ if(this.pst!=null){ this.pst.close(); } this.conn.close(); } return flag; } 报的错误信息如:
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: No suitable driver - Toolbox for IT Groups

    ittoolbox.com | 9 months ago
    java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager .java:545) at java.sql.DriverManager.getConnection(DriverManager .java:171) at com.stc.sql.framework.jdbc.DBConnectionFactory.cre ateConnection(DBConnectionFactory.java:372) at com.stc.sql.framework.jdbc.DBConnectionFactory.get Connection(DBConnectionFactory.java:281) at com.stc.etl.engine.impl.SimpleTask.getConnection(S impleTask.java:254) at com.stc.etl.engine.impl.Extractor.getSelectData(Ex tractor.java:376) at com.stc.etl.engine.impl.Extractor.process(Extracto r.java:190) at com.stc.etl.engine.impl.ETLTaskThread.run(ETLTaskT hread.java:147)
  6. 0

    1 more error - Java Programming Help - KnowCoding.com

    knowcoding.com | 2 years ago
    java.sql.SQLException: Protocol violation at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:179) at oracle.jdbc.dbaccess.DBError.check_error(DBError.j ava:1160) at oracle.jdbc.ttc7.Ocommoncall.receive(Ocommoncall.j ava:149) at oracle.jdbc.ttc7.TTC7Protocol.rollback(TTC7Protoco l.java:488) at oracle.jdbc.driver.OracleConnection.rollback(Oracl eConnection.java:1412) at net.sf.hibernate.transaction.JDBCTransaction.rollb ack(JDBCTransaction.java:86) at com.azure.spark.database.hibernate.util.HibernateU til.doSessionWork(HibernateUtil.java:90) at com.azure.spark.database.hibernate.util.HibernateU til.doSessionWork(HibernateUtil.java:59) at com.azure.spark.database.hibernate.util.HibernateU til.get(HibernateUtil.java:569) at com.azure.spark.database.hibernate.util.HibernateS ession.get(HibernateSession.java:340) at com.azure.spark.taskcontroller.TaskControllerCompo nent.taskCompleted(TaskControllerComponent.java:11 54) at com.azure.spark.taskcontroller.TaskControllerCompo nent.onTaskEvent(TaskControllerComponent.java:1111 ) at com.azure.spark.taskcontroller.tasks.AbstractTaskC omponent.run(AbstractTaskComponent.java:354)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      This operation is not supported.DSRA0010E: SQL State = null, Error Code = 0

      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError()
    2. com.microsoft.sqlserver
      SQLServerConnection.setTypeMap
      1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
      2. com.microsoft.sqlserver.jdbc.SQLServerConnection.NotImplemented(Unknown Source)
      3. com.microsoft.sqlserver.jdbc.SQLServerConnection.setTypeMap(Unknown Source)
      3 frames
    3. com.ibm.ws
      WSRdbManagedConnectionImpl.cleanup
      1. com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.setTypeMap(WSRdbManagedConnectionImpl.java:3373)
      2. com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupStates(WSRdbManagedConnectionImpl.java:2528)
      3. com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanup(WSRdbManagedConnectionImpl.java:2396)
      3 frames
    4. com.ibm.ejs
      LocalTransactionWrapper.afterCompletion
      1. com.ibm.ejs.j2c.MCWrapper.cleanup(MCWrapper.java:1195)
      2. com.ibm.ejs.j2c.poolmanager.FreePool.returnToFreePool(FreePool.java:329)
      3. com.ibm.ejs.j2c.poolmanager.PoolManager.release(PoolManager.java:1311)
      4. com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:1777)
      5. com.ibm.ejs.j2c.LocalTransactionWrapper.afterCompletionCode(LocalTransactionWrapper.java:1092)
      6. com.ibm.ejs.j2c.LocalTransactionWrapper.afterCompletion(LocalTransactionWrapper.java:1026)
      6 frames
    5. com.ibm.ws
      LocalTranCoordImpl.cleanup
      1. com.ibm.ws.LocalTransaction.LocalTranCoordImpl.informSynchronizations(LocalTranCoordImpl.java:1313)
      2. com.ibm.ws.LocalTransaction.LocalTranCoordImpl.cleanup(LocalTranCoordImpl.java:1038)
      2 frames
    6. WebSphere
      WebApp.init
      1. com.ibm.ws.webcontainer.webapp.WebAppTransactionCollaborator.postInvoke(WebAppTransactionCollaborator.java:249)
      2. com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServletManager.java:891)
      3. com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServletManager.java:224)
      4. com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadAutoLoadServlets(WebAppServletManager.java:542)
      5. com.ibm.ws.webcontainer.webapp.WebApp.loadServletManager(WebApp.java:1379)
      6. com.ibm.ws.webcontainer.webapp.WebApp.init(WebApp.java:292)
      6 frames
    7. com.ibm.ws
      WebGroup.init
      1. com.ibm.ws.webcontainer.srt.WebGroup.loadWebApp(WebGroup.java:408)
      2. com.ibm.ws.webcontainer.srt.WebGroup.init(WebGroup.java:212)
      2 frames
    8. WebSphere
      ServerImpl.start
      1. com.ibm.ws.webcontainer.WebContainer.addWebApplication(WebContainer.java:1012)
      2. com.ibm.ws.runtime.component.WebContainerImpl.install(WebContainerImpl.java:136)
      3. com.ibm.ws.runtime.component.WebContainerImpl.start(WebContainerImpl.java:356)
      4. com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:517)
      5. com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:808)
      6. com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:354)
      7. com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:578)
      8. com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:311)
      9. com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:268)
      10. com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:536)
      11. com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:413)
      12. com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerImpl.java:152)
      13. com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:536)
      14. com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:413)
      15. com.ibm.ws.runtime.component.ServerImpl.start(ServerImpl.java:246)
      15 frames
    9. com.ibm.ws
      WsServer.main
      1. com.ibm.ws.runtime.WsServer.start(WsServer.java:128)
      2. com.ibm.ws.runtime.WsServer.main(WsServer.java:225)
      2 frames
    10. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
      3. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
      4. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
      5. java.lang.reflect.Method.invoke(Method.java:391)
      5 frames
    11. com.ibm.ws
      WSLauncher.run
      1. com.ibm.ws.bootstrap.WSLauncher.run(WSLauncher.java:222)
      1 frame
    12. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:567)
      1 frame