java.sql.SQLException: Use of the executeQuery(String) method is not supported on this type of statement.

Stack Overflow | AndreaNobili | 5 months ago
  1. 0

    Why I obtain this exception performing a query using PreparedStatment? executeQuery(String) method is not supported on this type of statement

    Stack Overflow | 5 months ago | AndreaNobili
    java.sql.SQLException: Use of the executeQuery(String) method is not supported on this type of statement.
  2. 0

    Database connection unexpectedly closed with Glassfish, jTDS and SQL Server 2008

    Stack Overflow | 5 years ago | fernacolo
    java.sql.SQLException: I/O Error: Connection reset by peer: socket write error
  3. 0

    Sybase ASE: Implicit conversion from TEXT to VARCHAR doesn't work

    GitHub | 4 years ago | lukaseder
    java.sql.SQLException: Implicit conversion from datatype 'TEXT' to 'VARCHAR' is not allowed. Use the CONVERT function to run this query.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Inner join issue for on() clause

    GitHub | 4 years ago | googol4u
    com.mysema.query.QueryException: java.sql.SQLException: 在关键字 'where' 附近有语法错误。
  6. 0

    Error creating bean with name 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0'

    Stack Overflow | 4 years ago | Swapnil
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' defined in ServletContext resource [/WEB-INF/hmpn-mvc-dispatcher-servlet.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR. [See nested exception: java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.]]

  1. ruifung 1 times, last 3 months ago
12 unregistered visitors
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

    Use of the executeQuery(String) method is not supported on this type of statement.

    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.notSupported()
  2. jTDS
    JtdsPreparedStatement.executeQuery
    1. net.sourceforge.jtds.jdbc.JtdsPreparedStatement.notSupported(JtdsPreparedStatement.java:201)
    2. net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:920)
    2 frames
  3. com.fideuram.manager
    PucManager.getDataFinePivot
    1. com.fideuram.manager.PucManager.getDataFinePivot(PucManager.java:2163)
    1 frame
  4. com.fideuram.main
    AppTest.testGetDataFinePivot
    1. com.fideuram.main.AppTest.testGetDataFinePivot(AppTest.java:344)
    1 frame
  5. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  6. JUnit
    TestCase.run
    1. junit.framework.TestCase.runTest(TestCase.java:154)
    2. junit.framework.TestCase.runBare(TestCase.java:127)
    3. junit.framework.TestResult$1.protect(TestResult.java:106)
    4. junit.framework.TestResult.runProtected(TestResult.java:124)
    5. junit.framework.TestResult.run(TestResult.java:109)
    6. junit.framework.TestCase.run(TestCase.java:118)
    6 frames
  7. JUnit3 Runner
    RemoteTestRunner.main
    1. org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:131)
    2. org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
    3. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)
    4. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675)
    5. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)
    6. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)
    6 frames