hibernateÉèÖÃsqlserverÖ÷¼üµÄÎÊÌâ
ÎÒÏÖÔÚµÄÔ±¹¤±íÀïÃæµÄÖ÷¼üÊÇÊÖ¶¯ÊäÈëµÄ£¬ËùÒÔûÓÐ×Ô¶¯Ôö³¤£¬ÇëÎÊÏÂÃæµÄhibernateÓ³ÉäÎļþµÄ´úÂ뻹Ҫ²»£¿
<id name="empId" type="java.lang.String">
<column name="emp_id" length="10" />
<generator class="identity" />
</id>
ºìÉ«²¿·Ö»¹Òª²»£¿¶øÇÒ£¬ÎÒµÄÕâ¸öÖ÷¼üÒòÐèÒªÉèÖÃΪStringÀàÐ͵ģ¬ÇëÎÊÕâ»áÓ°ÏìÎÒµ÷ÓÃhibernateµÄ²éѯ·½·¨£¬´«ÈëÒ»¸öIDÖ÷¼ü²éѯÂð£¿
ÎÒÏÖÔÚÕâÑùÉèÖú󣬳ÌÐò±¨´íÁË£¬
Provided id of the wrong type. Expected: class java.lang.String, got class java.lang.Integer
ÎÒ²»ÖªµÀÊÇÎÒÓ³ÉäÎļþ³öÎÊÌâÁË »¹ÊÇÎÒдµÄ²éѯ·½·¨²»ÐУ¬´ó¼Ò°ïæ½â¾ö¹þ£¬¸ÐлÁË£¡£¡£¡
<generator class="identity" /> µ¼Ö Provided id of the wrong type£¨String£©
È¥µô°É
ÊÖ¶¯ÊäÈ룬¾ÍÊÇʹÓà <generator class="assigned" /> °¡
»¹ÓÐ
<generator class="identity" />
µÄÖ»Ö§³Öint ,short ,longµÄÊý¾Ý¿âÀàÐÍ
Java code:
<generator class="assigned" />
3Â¥
up
stringÀàÐÍû°ì·¨×ÔÔö³¤
ÆäËüÅäÖö¼ÊÇÕýÈ·µÄ£¬Ö»ÐèÒª°Ñ
<generator class="identity" /> ¸Ä³É <generator class="assigned" /&
Ïà¹ØÎÊ´ð£º
´úÂ룺
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......
ÐèҪʹÓÃSQL Server2000»ò2005
ÐèÒªÉè¼ÆÊý¾ÝÓÐЧÑéÖ¤,·Àֹ¼Èë²»ºÏ·¨Êý¾Ý
ÐèÒªÉè¼Æ´æ´¢¹ý³Ì»ò×Ô¶¨Ò庯ÊýÍê³ÉÊý¾ÝµÄ¼Èë\ÐÞ¸Ä\ɾ³ý\ͳ¼Æ\²éѯ
Êý¾Ý¿â´ó²¿·Ö±íÎÒÒѾ½¨Á¢,Ö»ÊǸ¨ÖúÐÔµÄС±í½¨Á¢µÄ»¹²»È«
......
ÎÒ¿´Á˺ܶàÎÄÕ£¬Ð´µÄ̫רҵ£¬Äܲ»ÄÜÓôó°×»°½²½²£¬¾ÍÊÇÔõô¹¹½¨Ë÷ÒýµÄ£¬²éµÄʱºòÊÇÔõôÑùµÄ²½Ö裬Ϊʲô±Èlike¿ì£¬ÊDz»ÊÇÖ»ÒªÓÃcontect£¬¾ÍÒ»¶¨»áÈ¥²é£¬±ÈÈç
select * from table where contect('sdfsd',sdf) and ......
ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë
Ôõô»ØÊ¡£
´úÂëÒѾдÁ˹ýÂË×Ö·û´®
Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË
Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË
»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
Ôõôà ......
Êý¾Ý¿âÏà¹Ø http://www.windbi.com/showtopic-2733.aspx
ÔÆ¼ÆËãÏà¹Ø http://www.windbi.com/showtopic-2734.aspx
ÉÌÎñÖÇÄÜÏà¹Ø http://www.windbi.com/showtopic-2747.aspx
..
thank you.
......