SQLÓïÑԵIJ¼¾ÖºÍIllegalArgumentException
ºÍjava.lang.IllegalArgumentException: org.hibernate.QueryException: JPA-style positional param was not an integral ordinalÕ½¶·Á˰ëÌ죬º¹°¡£¡
ʹÓÃjpa + strut+ hibernate ¾Í±¨org.hibernate.QueryException: JPA-style positional param was not an integral ordinal
Ò»°ã°ÑhqlÓï¾äдÔÚÒ»ÐУ¬»áºÜ³¤£¬ÔÚideÖÐÐèÒªÍ϶¯¹ö¶¯Ìõ²ÅÄܲ鿴¡£ÎªÁË·½±ãÔĶÁ£¬¹Ê¸Ä³É¼¸ÐУº
public List<Resource> getResourceByTag(Tag tag,int start) {
Query query = entityManager.createQuery(
"SELECT r from Resource r WHERE ?1" +
"IN (SELECT t from r.res_tags t)" +
"ORDER BY r.res_update_date DESC");
query.setParameter(1, tag);
query.setFirstResult(start);
query.setMaxResults(Constants.ITEMS_PER_PAGE);
return query.getResultList();
}
È»ºó¾Í±¨´íava.lang.IllegalArgumentException: org.hibernate.QueryException: JPA-style positional param was not an integral ordinal¡£
°¡°¡°¡°¡°¡°¡£¬sqlÖÐÉÙÁ˺ü¸¸ö¿Õ¸ñ£¬¾ÍÔÚ»»Ðеĵط½
ÕýÈ·£º
"from Resource r WHERE ?1 " +
"IN (from r.res_tags) " +
"ORDER BY r.res_update_date DESC");
ÎÞÄεĽÌѵ£¡
Ïà¹ØÎĵµ£º
ÕªÒª£º±¾ÎĽ«½éÉÜSQL Server 2005 Analysis ServicesÖÐÊý¾ÝÍÚ¾òËã·¨À©Õ¹·½·¨£¬ÔÚÆ½Ê±¿ª·¢ÖÐÎÒÃÇÐèÒª¸ù¾ÝÒªÇóÀ´À©Õ¹SSASµÄÍÚ¾òËã·¨¡£
±êÇ©£ºSQL Server 2005 Êý¾ÝÍÚ¾ò Ëã·¨
SSASΪÎÒÃÇÌṩÁ˾ÅÖÖÊý¾ÝÍÚ¾òËã·¨£¬µ«ÊÇÔÚÓ¦ÓÃÖÐÎÒÃÇÐèÒª¸ù¾Ýʵ¼ÊÎÊÌâÉè¼ÆÊʵ±µÄËã·¨£¬Õâ¸öʱºò¾ÍÐèÒªÀ©Õ¹SSA ......
----start
ÎÊÌ⣺²é¿´DB2 °æ±¾---SELECT * from SYSIBM.SYSVERSIONS
ÎÊÌ⣺²é¿´ÏµÍ³ÖÐÓÐÄÄЩ±íÒÔ¼°ÕâЩ±íµÄ¸ÅÒªÐÅÏ¢£ºSELECT * from SYSCAT.TABLES
ÎÊÌ⣺²é¿´Ä³¸ö±íÓÐÄÄЩÁÐÒÔ¼°ÕâЩÁеĸÅÒªÐÅÏ¢£ºSELECT * from SYSCAT.COLUMNS WHERE TABNAME=<YOUR_TABLE_NAME>
---´ýÐøÎ´Íê
---¸ü¶à²Î¼û£ºDB2 SQL ¾«Ò ......
CareGroup Ò½ÁÆ×éÖ¯¸ºÔð±£»¤2TB µÄ²¡ÈËÐÅÏ¢ºÍÏà¹ØÊý¾ÝµÄÒþ˽¼°ÍêÕûÐÔ¡£¸Ã×é֯λÓÚ²¨Ê¿¶Ù£¬ÊÇBeth Israel Deaconess ҽѧÖÐÐÄ£¨¹þ·ðҽѧԺµÄ½ÌѧҽԺ£©ÒÔ¼°ÁíÍâÈý¼ÒµØÇøÒ½ÔºµÄĸ¹«Ë¾¡£CareGroup ²ÉÓÃMicrosoft® SQL Server™ 2005£¬½«ÆäÊý¾Ý´æ´¢ÓÚ30¸öʵÀýµÄ390¸öÊý¾Ý¿âÖС£¸Ã×é֯ϣÍû½«Êý¾Ý¿âÉý¼¶µ½SQL Server 200 ......
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“”¿Î³Ì±È“”¿Î³Ì³É¼¨¸ßµÄËùÓÐѧÉúµÄѧºÅ£»
SELECT a.S# from (SELECT s#,score from SC WHERE C#='001') a,
(SELECT s#,score fr ......