db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristian Waagan (JIRA)" <j...@apache.org>
Subject [jira] Closed: (DERBY-4541) precompile statement with result offset and fetch first clauses
Date Mon, 08 Feb 2010 15:37:27 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4541?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kristian Waagan closed DERBY-4541.
----------------------------------

       Resolution: Duplicate
    Fix Version/s: 10.6.0.0

Closed and marked as duplicate of DERBY-4208.

> precompile statement with result offset and fetch first clauses
> ---------------------------------------------------------------
>
>                 Key: DERBY-4541
>                 URL: https://issues.apache.org/jira/browse/DERBY-4541
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.3.0
>         Environment: ------------------ Java Information ------------------
> Java Version:    1.6.0_17
> Java Vendor:     Sun Microsystems Inc.
> Java home:       C:\Archivos de programa\Java\jdk1.6.0_17\jre
> Java classpath:  D:\Programming\apache-tomcat-6.0.18\lib\servlet-api.jar;D:\Programming\apache-tomcat-6.0.18\lib\jasper.jar;D:\Programming\apache-tomcat-6.0.18\lib\jsp-api.jar;D:\Programming\apache-tomcat-6.0.18\lib\el-api.jar;D:\Programming\apache-tomcat-6.0.18\lib\annotations-api.jar;D:\Programming\workspace_eclipse\prototype_24\work;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\classes;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\activation.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\commons-fileupload-1.2.1.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\freemarker-2.3.8.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\jakarta-oro-2.0.8.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\mime-util.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\postgresql-8.3-603.jdbc3.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\standard.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\derby.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\log4j-1.2.15.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\commons-io-1.4.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\jim-lib.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\commons-lang-2.4.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\json-lib-2.3-jdk15.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\jstl.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\web4j.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\derbytools.jar;D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\derbyrun.jar
> OS name:         Windows XP
> OS architecture: x86
> OS version:      5.1
> java.specification.name: Java Platform API Specification
> java.specification.version: 1.6
> --------- Derby Information --------
> JRE - JDBC: Java SE 6 - JDBC 4.0
> [D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\derby.jar] 10.5.3.0 - (802917)
> [D:\Programming\workspace_eclipse\prototype_24\WEB-INF\lib\derbytools.jar] 10.5.3.0 -
(802917)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
>            Reporter: burk mayer
>             Fix For: 10.6.0.0
>
>
> hi,
> i'm getting an error while precompiling a prepared statement with offset and fetch first
clauses.
> the documentation (http://db.apache.org/derby/docs/dev/ref/rrefsqljoffsetfetch.html#rrefsqljoffsetfetch),
provides following example:
> SELECT * FROM T ORDER BY I OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY
> the prepared statement looks like: 
> Connection con = datasource.getConnection();
> PreparedStatement p = con.prepareStatement("SELECT * FROM T ORDER BY I OFFSET ? ROWS
FETCH NEXT ? ROWS ONLY");
> but an SQLException is thrown: Syntax error: Encountered "?" at line 1, column 60.
> i'm using following version of derby:
> Bundle-Name: Apache Derby 10.5
> Bundle-Version: 10.5.3000000.802917
> the connection is created from a container-managed connection-pool datasource:
>      <Resource
>        name="jdbc/prototype"
>        auth="Container"
>        type="javax.sql.DataSource"
>        driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
>        url="jdbc:derby:memory:prototype;create=true"
>        username=""
>        password=""
>        maxActive="10"
>        maxIdle="5"
>        maxWait="10000"
>      />
> thank you for your support,
> burk

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message