SQL SeverºÍMySql - MS-SQL Server / »ù´¡Àà
sql serverµÄmdfÎļþÈçºÎÄܵ¼Èëµ½mysqlÖУ¬ÎÒÏëÁ˽âһϣ¬Ï£ÍûÅóÓÑÃǰïæ
·þÎñÆ÷Á¬½Ó,Ö±½Óµ¼ÈëÊý¾Ý
ÄÜ˵¾ßÌåµãÂ𣿱¾È˸սӴ¥£¬²»ÔõôÃ÷°×£¬Ð»Ð»ÁË
Ïȸ½¼ÓÔÚSQLºó£¬È»ºóÔٲο¼ÒÔÏÂ×ÊÁÏ£º
¡¡¡¡´Ósqlµ¼³öµ½mysqlµÄ·½·¨ºÜ¶à£¬ÏÖ½éÉÜÒ»ÖÖÎÞÐè±à³Ì£¬Ö±½ÓÀûÓÃsqlºÍmysqlÀïµÄͼÐνçÃæ½øÐе¼Èëµ¼³öµÄ¼òµ¥·½·¨¡£
¡¡¡¡¡¡¡¡
¡¡¡¡Ç°ÌáÊÇÒѾ°²×°ÁËsqlserver¿Í»§¶ËºÍmysqlµÄͼÐνçÃæ¹ÜÀí¹¤¾ßphpmyadmin¡£
¡¡¡¡¡¡¡¡
¡¡¡¡ÔÚ¿ØÖÆÌ¨¸ùĿ¼Ï´ò¿ªsqlserverÆóÒµ¹ÜÀíÆ÷£¬Ð½¨sqlserver×飬¸ù¾Ý×Ô¼ºµÄÇé¿ö½øÐÐÑ¡Ôñ£»È»ºóн¨sqlserver ×¢²á£¬½øÐжÔsqlserverµÄÁ¬½Ó¡£×¼±¸Í×µ±ºó£¬ÏÂÃæ¾Í¿ªÊ¼ÁË£º
¡¡¡¡¡¡¡¡
¡¡¡¡Ê×ÏÈ´ò¿ªÊý¾Ýת»»·þÎñ£¬Ð½¨°ü£¬´ò¿ªDTS½çÃæ£¬ÔÚÁ¬½ÓÖÐÑ¡ÔñÊý¾ÝÔ´½øÐÐÅäÖá£ÔÙÑ¡Ôñ½«Òª×ª»»µ½µÄÄ¿µÄÎļþ£¬ÕâÀïÎÒÑ¡µÄ Textfile(destination)£¬Ñ¡ÔñºÃÎļþµÄ´æ·ÅλÖÃÖ®ºó£¬ÎÒÃÇÀ´Ð½¨Ò»¸öÈÎÎñ¡£ÕâÀïÎÒÃÇֻѡÔñת»»Êý¾ÝÈÎÎñ£¬½«´øÓС°Ñ¡ÔñÔ´Á¬½Ó¡±¡°Ñ¡ÔñÄ¿µÄÁ¬½Ó¡±µÄÊó±ê·Ö±ðÑ¡ÖÐÊý¾ÝÔ´ºÍÄ¿µÄÖ®ºó£¬ÎÒÃǶÔÐÂÉú³ÉµÄÁ¬½Ó½øÐж¨Ò壬ÔÚÆäÊôÐÔÖн«Ô´£¬Ä¿µÄ£¬×ª»»ÒÀ´Î¶¨Òå¡£
¡¡¡¡
¡¡¡¡Ö´ÐÐÈÎÎñ£¬Ìáʾ³É¹¦¡£±£´æÈÎÎñ¡£È»ºóÔÚн¨µÄÈÎÎñÉϵ¼³öÊý¾Ý£¬ÓÐÏòµ¼Ìáʾ£¬ÆäÖÐÒ»ÏîÑ¡Ôñ¡°´ÓÔ´Êý¾Ý¿â¸´ÖƱíºÍÊÓͼ¡±¡£
¡¡¡¡
¡¡¡¡ÕâÒ»²½ÒѾ°ÑÊý¾Ýµ¼³öµ½Ä¿µÄÎļþÖС£
¡¡¡¡¡¡¡¡
¡¡¡¡ÏÂÒ»²½ÔÚmysqlÖÐн¨±í£¬Ó뽫Ҫµ¼ÈëµÄ½á¹¹±£³ÖÒ»ÖÂʱ£¬Ö±½Óѡȡ¡°´ÓÎı¾ÎļþÖÐÌáÈ¡Êý¾Ý£¬²åÈëµ½Êý¾Ý±í£º¡±£¬½«Ñ¡ÏîÌíºÃºó£¬¡°·¢ËÍ¡±¾Í¿ÉÒÔÁË£¬ä¯ÀÀһϣ¬Êý¾ÝÒѵ¼ÈëÁË¡£ÈôÒªµ¼ÈëµÄ±íÒѾ´æÔÚ£¬ÇÒÊôÐÔÃûÒ²²»Í¬£¬Õâʱ¾ÍÏȽ¨Ò»¸öÓëÒªµ¼ÈëµÄÊý¾ÝÏàͬ½á¹¹µÄ±í²¢µ¼ÈëÊý¾Ý£¨°´¸Õ²ÅµÄ½øÐоͿÉÒÔÁË£©£¬È»ºóÔÚmysqlÖе¼³ö¡°Êý¾ÝºÍ½á¹¹¡±£¬µÃµ½sqlÓï¾
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......