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&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ɾ³ý£¬»òÕß
Ïà¹ØÎĵµ£º
ת×Ô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 »ñµÃµ±Ç°ÈÕÆÚʱ¼ä º¯Êý
1.1 »ñµÃµ±Ç°ÈÕÆÚ+ʱ¼ä£¨date + time£©º¯Êý£ºnow()
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2008-08-08 22:20:46 |
+---------------------+
³ýÁË now() º¯ÊýÄÜ»ñµÃµ±Ç°µÄÈÕÆÚʱ¼äÍ⣬MySQL Öл¹ÓÐÏÂÃæµÄº¯Êý£º ......
http://blog.163.com/mysqldba@126/blog/static/1315356342009931103834396/
×î½ü¿´ÁË¿´mysqlµÄ״̬±äÁ¿£¬¸Ð¾õºÃ¶à¸úÒÔǰ×Ô¼ºÏëÏóµÄ²»Ò»Ñù¡£ÎªÁËÒÔºóÄܼ°Ê±·¢ÏÖ×Ô¼ºµÄ´íÎó,¾ÍÏȼÇÏÂÀ´;
http://dev.mysql.com/doc/refman/5.1/en/server-status-variables.html
mysql> show status;
Com_xxx
Óï¾ä¼ÆÊý±äÁ¿±íʾÿ¸öxxx ......
ÓÃÔÚSELECTºÍWHERE×Ó¾äµÄº¯Êý
--------------------------------------------------------------
1 ·Ö×麯Êý
( ... ) À¨ºÅ¡£Ê¹ÓÃËüÃÇÀ´Ç¿ÖÆÔÚÒ»¸ö±í´ïʽµÄ¼ÆËã˳Ðò¡£
--------------------------------------------------------------
2 ³£ÓõÄËãÊõÔËËã
£¨+ - * /£©
Ò»°ãµÄË ......