configuração do JDBC
Estou tentando fazer uma conexão com o Banco SQL Server, é aparece essa msg de erro:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can´t start a cloned connection while in manual transaction mode.
Causa:
This error occurs when you try to execute multiple statements against a SQL Server database with the JDBC driver while in manual transaction mode (AutoCommit=false) and while using the direct (SelectMethod=direct) mode. Direct mode is the default mode for the driver.
Resolução:
When you use manual transaction mode, you must set the SelectMethod property of the driver to Cursor, or make sure that you use only one active statement on each connection as specified in the ´More Information´ section of this article.
Em que local do SQL Server eu tenho que ir para mudar essa opção?
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can´t start a cloned connection while in manual transaction mode.
Causa:
This error occurs when you try to execute multiple statements against a SQL Server database with the JDBC driver while in manual transaction mode (AutoCommit=false) and while using the direct (SelectMethod=direct) mode. Direct mode is the default mode for the driver.
Resolução:
When you use manual transaction mode, you must set the SelectMethod property of the driver to Cursor, or make sure that you use only one active statement on each connection as specified in the ´More Information´ section of this article.
Em que local do SQL Server eu tenho que ir para mudar essa opção?
Debora2m
Curtidas 0
Respostas
Tommahawk
23/05/2006
Pelo texto dá a impressão que o problema não é no banco... posta o código da tua conexão, quem sabe analisando o pessoal enxerga algo melhor.
GOSTEI 0