Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

EJB3+JBOSS4+mySQL²¿Êð·½Ê½

1¡¢Ð½¨Êý¾ÝÔ´Îļþmysql-ds.xml,ÎļþÄÚÈÝÈçÏ£º
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>MySqlDS</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/mydatabase?useUnicode=true&amp;characterEncoding=GBK</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>root</user-name>
    <password>123</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>
ÆäÖГmydatabase”ÊÇÊý¾Ý¿âÃû³Æ£¬¸ÄÒ»ÏÂÓû§Ãû¡¢ÃÜÂëºÍÊý¾Ý¿âÃû³Æ£¬´ËÅäÖÃÎļþ¾Í¿ÉÒÔÓÃÁË¡£½«´ËÎļþ·ÅÔÚjboss°²×°Ä¿Â¼Ïµē\server\default\deploy”Ŀ¼Ï¼´¿É¡£
2¡¢È»ºóн¨Ò»¸öEJB¹¤³Ì£¬ÔÚMETA-INFÎļþ¼ÐÏÂÌí¼ÓÎļþpersistence.xml¡£
<?xml version="1.0" encoding="UTF-8"?>
<persistence>
 <persistence-unit name="mydatabase">
  <jta-data-source>java:/MySqlDS</jta-data-source>
  <properties>
   <property name="hibernate.hbm2ddl.auto" value="update" />
  </properties>
 </persistence-unit>
</persistence>
ºìÉ«²¿·ÖµÄÃû³ÆÒª¶ÔÓ¦ÆðÀ´¡£
3¡¢½«ejb¹¤³ÌÓëpersistence.xmlÎļþ´ò°ü·¢²¼¼´¿É¡£
Èç¹ûÓõÄÊÇJBUILDER±àÒë»·¾³£¬Ð轫ÔÚbuildÊÇʱºöÂÔxmlÀàÐÍÎļþµÄÑ¡ÏîÈ¥µô£¬²»È»µÄ»°·¢²¼»á³öÏÖ
“Incomplete Deployment listing:
--- MBeans waiting for other MBeans --- ……”ÀàËÆµÄ´íÎ󡣸ü¸ÄJbulider±àÒëÑ¡ÏîµÄ·½Ê½Îª“window->preferences->java->compiler->building”,È»ºó½«Filetered resourcesÖеÄ*.xmlɾ³ý£¬»òÕß


Ïà¹ØÎĵµ£º

mysqlÊý¾Ý¿â×Ô¶¯¶¨ÆÚ±¸·ÝµÄ½Å±¾

˵Ã÷£º
±£ÁôÿÌ챸·ÝµÄÊý¾ÝÊǼþ²»Ì«ÏÖʵµÄÊ£¬×öºÃµÄ×ö·¨ÊDZ£ÁôǰÈýÌìµÄ
±¸·ÝÊý¾Ý¡£°Ñ±¸·ÝµÄÊý¾Ý´ò°ü²¢Ñ¹Ëõ£¬ÎļþÃûÒÔϵͳʱ¼äÃüÃû£¬´ò°üºóµÄ
±¸·ÝÎļþ·ÅÔÚÒ»¸öÌØ¶¨µÄÎļþ¼ÐÏÂÃæ£¬Êµ¼ÊÉÏ£¬Ö»ÒªÊÇÒÔʱ¼äÃüÃû±¸·ÝÎļþ£¬
ls ÃüÁîºó£¬Îļþ½«×Ô¶¯°´Ê±¼äÅÅÐòµÄ£¬ÕâÑù¾Í¿ÉÒÔ·½±ãµÄɾ³ýÈýÌìÒÔǰµÄ±¸·ÝÎļþ£¬ÓÚÊÇ ......

Amoeba for mysql 1.0.2 beta°æ±¾·¢²¼

ת×Ôhttp://amoeba.meidusa.com/wordpress/?p=24£¬Ò»¸öºÜºÃµÄ¹¤¾ß¡£¡£¡£¡£ÆÚ´ýÑо¿
ÐÞ¸´bugÁбí:
1¡¢ÐÞ¸´ÎÞ·¨½âÎöÅ׳öunknown statement£¨1.0.0ÐÂbug£©¡£½«ÎÞ·¨½âÎöµÃsqlĬÈÏÔÚdefaultPoolÖÐÖ´ÐÐ
2¡¢ÐÞ¸´union¹Ø¼ü×ÖÎÞ·¨½âÎöÎÊÌâ
3¡¢ÐÞ¸´º¯ÊýÇ°Ãæ! ÎÞ·¨½âÎöÎÊÌâ
4¡¢ÐÞ¸´order by ¡¢group by ºóÃæ´ø±í´ïʽµÃsql
ÏÂÔØµØ ......

mysql Ïà¹ØÅäÖÃ

mysqlÖв»Çø·Ö´óСд£º
LinuxÖÐMySQLµÄÅäÖÃÎļþÖÐ(/etc/my.cnf)£¬ÊÇûÓÐlower_case_table_names=1ÕâÐеġ£
ÔÚWindows°²×°µÄMySQLµÄÅäÖÃÎļþÖÐ(my.ini)£¬ÊÇÓÐlower_case_table_names=1ÕâÐеġ£
lower_case_table_names=1µÄÓÃ;ÊÇÈÃMySQLʵÏÖ²»Çø·Ö´óСд
mysqlÖÐÔÊÐíÆäËû»úÆ÷·ÃÎÊ£º
mysql> use mysql;
Õâ¾ä»°µÄÒâ˼ ......

mysqlº¯Êý


ÓÃÔÚSELECTºÍWHERE×Ó¾äµÄº¯Êý
--------------------------------------------------------------
1 ·Ö×麯Êý
( ... ) À¨ºÅ¡£Ê¹ÓÃËüÃÇÀ´Ç¿ÖÆÔÚÒ»¸ö±í´ïʽµÄ¼ÆËã˳Ðò¡£
--------------------------------------------------------------
2 ³£ÓõÄËãÊõÔËËã
£¨+ - * /£©
Ò»°ãµÄË ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ