`
文章列表
ISSUE 1: Incorrect syntax near 'GO'.   replace GO with ;    1) GO is a keyword for Query Analyzer, not belongs to T-SQL. So, if you don't use Query Analyzer, GO is not recoganized.   2) GO instructs Query Analyzer to interpret and run the preceding T-SQL statments.     ISSUE 2: Incorrect syn ...
The reason why you should not use CREATE TABLE to create the default constraint is, system will generate a random constraint name for you. And when you drop it, your sql will be only workable in either dev/uat/prod db, but not all 3 dbs.   http://msdn.microsoft.com/en-us/library/aa175912(SQL.80).as ...
I met this issue on Oct 21st, 2009.   The Sql Server conplains       db.update:      [sql] Failed to execute:  ALTER TABLE Green ALTER COLUMN Enabled nChar(1) not null DEFAULT 'Y' BUILD FAILEDcom.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'DEFAULT'.   The r ...
Summary:   Step 1) Know your current shell. echo $SHELL   Step 2) Set env if csh or tcsh vi ~/.schrc setenv PATH “/bin:/usr/bin:/usr/sbin:/usr/ucb/bin”
<?xml version="1.0" ?> <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd"> <log4j:configuration xmlns:log4j='http://jakarta.apache.org/log4j/'>   <!-- ==application log file====================================== -->      
Unix env setup jflags="-ms1536M -mx1536M -Xnoclassgc" gcVerbose="-verbose:gc" jconsole="-Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=8003 -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.ssl=false" remoteDebug=&qu ...
    [Solution 1] java –version command after jdk1.6 can give you 32 bit or 64 bit info. Before jdk1.5, doesn’t contain this info.   [Solution 2] In linux env, run this command to check .   file  /usr/java/jre1.5.0_09/bin/java   [Solution 3] 32 bit jvm has a limitation of memory usage of l ...
/proc/meminfo contain all your memory usage information:-type: cat /proc/meminfo and you will get:- vmstat display memory usage in summary mode:-type: vmstat and you will getClick on the image to see bigger image free command:-type: free or free -mClick on the image to see bigger image   free - ...
client side java_home/bin/jconsole.exe   service:jmx:rmi:///jndi/rmi://192.168.***.***:8003/jmxrmi Server side   add this parameter   -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=8003 -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote ...
The most important thing is:   The jdk of server side and client side must be exactly the same.   then in start command:   remoteDebug="-Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=1861"
com.citigroup.get.quantum.messaging.MessagingException: javax.jms.InvalidDestinationException: Not allowed to create destination         at com.citigroup.get.quantum.messaging.transport.JMSTransportSender.send(JMSTransportSender.java:220)         at com.citigroup.get.quantum.messaging.internal.Sender ...
A sample shell script   #!/bin/sh viperooe_home=`dirname $0` source $viperooe_home/env-viperooe.sh instancename=$1 cd $viperooe_home/persistence/$1 currentDate=`date '+%Y%m%d'` echo $currentDate currentTime=`date '+%H%M%S'` echo $currentTime logName=orderStoreRatio-$currentDate-$currentTim ...
How to view stored procedure spec?   sp_help ${stored_procedure_name}   How to view the source of stored procedure?   sp_helptext ${stored_procedure_name}     Super simple procedure example     DECLARE @ricCode VARCHAR(20)  
1)    You don’t need to set variable – basedir. You can simply use it ${basedir}. And it will be the folder where build.xml resides.   2)    To run some target, you can pass in a variable. Like, a variable only existed and mentioned in target run, you can call it like this -- ant run -Daction=sto ...
  1)    POJO classes and hbm.xml files must be in the same folder. 2)    Hibernate.cfg.xml must be in the root of src folder.  
Global site tag (gtag.js) - Google Analytics