Executing an @Select with parameterized sql annotation elements and a sqlserver databse will fail with syntax errors. The @Select annotation is below:

@Select(sql="SELECT * from query005 where firstName=?1")

Unknown if this is a driver error.

JDK : 1.6.0 PIT
   java version "1.6.0-internal"
   Java(TM) 2 Runtime Environment, Standard Edition (build 1.6.0-internal-sk149173_19_Oct_2005_00_43-b00)
   Java HotSpot(TM) Server VM (build 1.6.0-ea-b56, mixed mode)
DB : SQLSERVER
DRIVER : inet/Merlia.jar
VM :
switch/Mode :
Platform[s] : Sol 10 sparc

Failing Tests:
==============
java_sql_eod/query/Query005_001 compile_and_execute
java_sql_eod/query/Query005_002 compile_and_execute
java_sql_eod/query/Query005_003 compile_and_execute
java_sql_eod/query/Query005_004 compile_and_execute
java_sql_eod/query/Query005_005 compile_and_execute
java_sql_eod/query/Query005_006 compile_and_execute
java_sql_eod/query/Query005_007 compile_and_execute
java_sql_eod/query/Query005_008 compile_and_execute
java_sql_eod/query/Query005_009 compile_and_execute
java_sql_eod/query/Query005_013 compile_and_execute
java_sql_eod/query/Query005_015 compile_and_execute
java_sql_eod/query/Query005_017 compile_and_execute
java_sql_eod/query/Query005_018 compile_and_execute
java_sql_eod/query/Query006_001 compile_and_execute
java_sql_eod/query/Query006_002 compile_and_execute
java_sql_eod/query/Query006_003 compile_and_execute
java_sql_eod/query/Query006_004 compile_and_execute
java_sql_eod/query/Query006_005 compile_and_execute
java_sql_eod/query/Query006_007 compile_and_execute


TestBase Location:
==================
    /net/cady.sfbay/export/sqa/tcheung/jdbc/SQE/6.0_child

tlog file location:
==================
    /net/cady/export/sqa/js159705/jdbc/bugs/6341105/js159705.SunOS.sparc/Query005_001

How to reproduce:
====================
   $ cd /net/cady/export/sqa/js159705/jdbc/bugs/6341105/js159705.SunOS.sparc/Query005_001
   $ ksh Query005_001.tlog

(Simplified) Error causing code:
================================
I_Query005 query = null;
DataSet<Player> rows = null;
query = QueryObjectFactory.createQueryObject(I_Query005.class, con);
String arg = "Jason";
rows = query.getPlayer(arg);


interface I_Query005 extends BaseQuery {
    @Select(sql="SELECT * from query005 where firstName=?1")
    DataSet<Player> getPlayer(String fName);
}

Test output:
=============
Query005_001.doTest() : Exception caught when executing @Select : com.inet.tds.SQLException: Msg 170, Level 15, State 1, Line 1, Sqlstate 01000
[JIGGLE]Line 1: Incorrect syntax near '1'.
TEST FAILED : Query005_001.doTest() :Un-Expected Exception when getting DataSet by executing @Select. [Message=com.inet.tds.SQLException: Msg 170, Level 15, State 1, Line 1, Sqlstate 01000
[JIGGLE]Line 1: Incorrect syntax near '1'.]
com.sun.j2se_sqe.jdbc.utils.TestFailureException: Un-Expected Exception when getting DataSet by executing @Select. [Message=com.inet.tds.SQLException: Msg 170, Level 15, State 1, Line 1, Sqlstate 01000
[JIGGLE]Line 1: Incorrect syntax near '1'.]
        at Query005_001.doTest(Query005_001.java:69)
        at Query005_001.main(Query005_001.java:163)
Caused by: com.inet.tds.SQLException: Msg 170, Level 15, State 1, Line 1, Sqlstate 01000
[JIGGLE]Line 1: Incorrect syntax near '1'.
        at com.inet.tds.a.a(Unknown Source)
        at com.inet.tds.a.a(Unknown Source)
        at com.inet.tds.p.a(Unknown Source)
        at com.inet.tds.b.executeQuery(Unknown Source)
        at com.sun.sql.QueryObjectGeneratorImpl.getQueryImpl(Unknown Source)
        at com.sun.sql.QueryObjectGeneratorImpl.invoke(Unknown Source)
        at $Proxy0.getPlayer(Unknown Source)
        at Query005_001.doTest(Query005_001.java:66)
        ... 1 more