* Àå¾ÖÇö»ó
- Çö»ó : mssql¿¡¼ Äõ¸® ½ÇÇà½Ã "Can't start a cloned connection while in manual transaction mode." ¿¡·¯ ¹ß»ý - ¼¹ö ¿¡·¯ ¸Þ½ÃÁö :
14533735 [Handler 131] ERROR oz40.dm.DataModule - [Error Code :10102005] [Component Name : µ¥ÀÌÅͼ¸í] Fail to get statement. java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.setupImplConnection(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.<init>(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.createStatement(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.createStatement(Unknown Source) at oz.dm.meta.OZDBQuerySet.b(DashoA12957:219) at oz.dm.meta.OZDBQuerySet.init(DashoA12957:61) at oz.dm.meta.OZDataModuleImpl.getBCDataModule(DashoA12957:512) at oz.dm.meta.OZDataModuleImpl.getBCDataModule(DashoA12957:446) at oz.framework.cp.message.FrameworkRequestDataModule.a(DashoA12957:655) at oz.framework.cp.message.FrameworkRequestDataModule.fetchMessage(DashoA12957:1265) at oz.server.cozc4.a(DashoA12957:207) at oz.server.cozc4.a(DashoA12957:113) at oz.server.cozc3.run(DashoA12957:63) at java.lang.Thread.run(Thread.java:479) |
* Àå¾Ö¿øÀÎ
MSSQL¿¡¼´Â Default·Î AutoCommitÀÌ trueÀÔ´Ï´Ù. ¿©±â¼ AutoCommit¸¦ false·Î ÇÏ°Ô µÇ¸é MSSQL¿¡¼ Á¦¾à»çÇ×ÀÌ ÇϳªÀÇ Connection¿¡¼ multiple Statement¸¦ »ç¿ëÇÒ ¼ö°¡ ¾ø½À´Ï´Ù. Áï, 2°³ÀÌ»óÀÇ Statement¸¦ »ç¿ëÇÒ ¼ö°¡ ¾ø´Â °ÍÀÔ´Ï´Ù. ±×·¡¼ ¿ÀÁî¼¹ö¿¡¼ ¹ö±×°¡ ¹ß»ýÇÏ¿´½À´Ï´Ù. ÀÌ¿¡ ÇϳªÀÇ Connection¿¡¼ multiple Statement¸¦ »ç¿ëÇÒ ¼ö ÀÖ´Â ¿É¼ÇÀÌ ¹Ù·Î SelectMethod=Cursor·Î ÇÒ °æ¿ì »ç¿ëÀ» ÇÒ ¼ö ÀÖ½À´Ï´Ù.
ÂüÁ¶ URL : http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B313181
¿øÀÎÀº mssql 2000¿¡¼´Â µðÆúÆ®·Î ÇϳªÀÇ conn¿¡¼ ¿©·¯°³ÀÇ statements¸¦ »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù.
* ÇØ°á¹æ¹ý
ÇØ°á¹æ¹ýÀº selectMethod=cursor ¹æ½ÄÀ¸·Î º¯°æÀ» ÇØ¾ß ÇÕ´Ï´Ù. ÀÌ ¼³Á¤Àº url¼³Á¤¿¡ ÇÒ ¼ö ÀÖ½À´Ï´Ù. dbconfig.xml ÆÄÀÏÀ» ÃÖ½ÅÀ¸·Î ÆÐÄ¡Çϰųª ¶Ç´Â db.properites ¿¡ mssql.serverName=master;SelectMethod=Cursor ó·³ ;SelectMethod=Cursor¸¦ Ãß°¡Çϼŵµ µË´Ï´Ù.
(db.properties ¿¹ - mssql2000) mssql_conn.vendor=mssql mssql_conn.serverAddress=10.10.1.1 mssql_conn.portNo=1433 mssql_conn.dbName=testdb;SelectMethod=Cursor mssql_conn.user=sa mssql_conn.password=sa mssql_conn.maxconns=20 mssql_conn.initconns=5 mssql_conn.timeout=5 mssql_conn.doConnectionCheck=true mssql_conn.testQueryString=select 1
|