Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problem z PreparedStatements i driverem mssql

0 views
Skip to first unread message

misiek

unread,
Apr 20, 2004, 7:40:13 AM4/20/04
to
Witam

Kiedy probuje zrobić najprostszego inserta z jednym parametrem przy
wykorzystaniu PreparedStatement wywala mi następujący błąd :
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid
parameter binding(s).
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.validateParameters(Unknown
Source)
at com.microsoft.jdbc.base.BasePreparedStatement.validateParameters(Unknown
Source)
at com.microsoft.jdbc.base.BasePreparedStatement.preImplExecute(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown
Source)
at com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(Unknown
Source)

Kod
String sql = "INSERT INTO CDN_Demo.CDN.TraNag (TrN_DDfId) VALUES (?)";
ps = connData.prepareStatement(sql);
ps.setInt(1,23);
ps.execute();

Co robie nie tak ?
Aha i jeszcze jedno zmiana drivera nie chodzi raczej w rachube.

--
Pozdrawiam

Marcin Misiewicz
ICsolutions S.C.
ul. Lea 114, 30-133 Kraków
tel/fax : (+48 12) 637 35 41
email : marcin.m...@icsolutions.com.pl
www : http://www.icsolutions.com.pl


0 new messages