2013年1月31日 星期四

MySQL Workbench 5.2 CE


執行MySQL Workbench 5.2 CE update or delete 時出現以下訊息
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor -> Query Editor and reconnect.
到工能表的Edit>Preferences>SQL Queries> General > 取消 "Safe Updates".Forbid UPDATEs and DELETEs whih no key in WHERE clause or no LIMIT clause. Requires a reconnection.
再重連接DB 就可以。

2013年1月25日 星期五

JBOSS Enable/disable hot-deployment


JBOSS 4.2.2.GA
In common with all application servers (I believe) redeployments chew up your jvm until you get memory allocation errors. You might get away with a few but a restart after hot-deployment is generally a good idea. If you want you can disable hot-deployment by setting the value below to false.
In server/prod/conf/jboss-service.xml
 <!-- A flag to disable the scans -->
      <attribute name="ScanEnabled">true</attribute>



2013年1月24日 星期四

HeapDumpOnOutOfMemoryError


JBOSS 4.2.2.GA
/usr/local/jBoss/Base/bin/run.conf
找到 JAVA_OPTS="-showversion -Xms256m -Xmx1024m .....
在jvm的 启动参数中追加 下列信息,可以在发生 OutOfMemoryError的时候生成 oom.hprof文件
-XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=C:/temp/oom.hprof