[SQL Server] 建立連接至 SQL Server 時，發生網路相關或執行個體特定的錯誤。...error: 40 - 無法開啟至 SQL Server 的連接)

錯誤訊息: 建立連接至 SQL Server 時，發生網路相關或執行個體特定的錯誤。找不到或無法存取伺服器。確認執行個名稱是否正確，以及 SQL Server 是否設定為允許遠端連線。 (provider: 具名的管線提供者, error: 40 - 無法開啟至 SQL Server 的連接)

當SQL Browser服務又沒開時

其中一種處理方式:
1. 至SQL Configuration Manager->SQL Server Network Configuration
2. 找到此SQL Server instance的服務-> TCP/IP, 右鍵內容
3. Protocol tab改為enabled, IP Address中的IPAll設定為 1433
4. 這是因為安裝完SQL server後, 並未啟動1433為default port, 故得手動啟動

[MySQL]取得insert那筆資料的serial

"...(insert sql);SELECT @@IDENTITY"
或 last_insert_id()

[MySQL]乾淨移除MySQL的步驟

1. ‘Uninstall’ mysql from the Control panel.
2. remove the “C:\Program Files\MySQL” folder.
3. Delete the mysql service my using command in command prompt “Sc delete mysql”
4. remove the “C:\Users\pc\AppData\RoaminMySql” folder.
5. Again Reinstall a fresh copy

[DOS] netstat指令

Displays protocol statistics and current TCP/IP network connections.

NETSTAT [-a] [-b] [-e] [-n] [-o] [-p proto] [-r] [-s] [-v] [interval]

  -a            Displays all connections and listening ports.
  -b            Displays the executable involved in creating each connection or
                listening port. In some cases well-known executables host
                multiple independent components, and in these cases the
                sequence of components involved in creating the connection
                or listening port is displayed. In this case the executable
                name is in [] at the bottom, on top is the component it called,
                and so forth until TCP/IP was reached. Note that this option
                can be time-consuming and will fail unless you have sufficient
                permissions.
  -e            Displays Ethernet statistics. This may be combined with the -s
                option.
  -n            Displays addresses and port numbers in numerical form.
  -o            Displays the owning process ID associated with each connection.
  -p proto      Shows connections for the protocol specified by proto; proto
                may be any of: TCP, UDP, TCPv6, or UDPv6.  If used with the -s
                option to display per-protocol statistics, proto may be any of:
                IP, IPv6, ICMP, ICMPv6, TCP, TCPv6, UDP, or UDPv6.
  -r            Displays the routing table.
  -s            Displays per-protocol statistics.  By default, statistics are
                shown for IP, IPv6, ICMP, ICMPv6, TCP, TCPv6, UDP, and UDPv6;
                the -p option may be used to specify a subset of the default.
  -v            When used in conjunction with -b, will display sequence of
                components involved in creating the connection or listening
                port for all executables.
  interval      Redisplays selected statistics, pausing interval seconds
                between each display.  Press CTRL+C to stop redisplaying
                statistics.  If omitted, netstat will print the current
                configuration information once.

[Maven]missing artifact com.sun:tools:jar:1.5.0

解決方式: 在pom.xml增加dependency
在local repository依照錯誤建立資料夾, 並將tools.jar置於其中
        <dependency>
            <groupId>com.sun</groupId>
            <artifactId>tools</artifactId>
            <version>1.5.0</version>
        </dependency>
或
        <dependency>
            <groupId>com.sun</groupId>
            <artifactId>tools</artifactId>
            <version>1.5.0</version>
            <scope>system</scope>
            <systemPath>%jdk path%/lib/tools.jar</systemPath>
        </dependency>

[JForum]JForum Project Home

http://code.google.com/p/jforum2/

[Hibernate]自訂many to one column mapping

改many to one tag 中的 property-ref