Error in the CallableStatement of JDBC-ODBC Bridge
Kwon Kee Lim
I'm using the JDBC-ODBC Bridge on Netscape Exterprise Server 3.0 for
connecting MS-SQL
The bridge says "setDate of CallableStatement is unimplemented feature"
belows are source code.
I wanna big hand..
thanks...
--------------------------------
import java.io.*;
import java.sql.*;
import java.util.*;
public class TestProcedure{
public static void main(String[] args){
Connection conn = null;
CallableStatement cstmt = null;
ResultSet rs = null;
File fLog = null;
FileOutputStream fosLog = null;
PrintStream psLog = null;
try{
Properties pBridge = new Properties();
pBridge.put("user", "test");
pBridge.put("password", "test");
pBridge.put("server", "");
Properties pSystem = System.getProperties();
String szVendor= (String)pSystem.getProperty("java.vendor");
System.out.println(szVendor);
if(szVendor.equalsIgnoreCase("Microsoft Corp.")){
System.out.println("com.ms.jdbc.odbc.JdbcOdbcDriver");
Class.forName ("com.ms.jdbc.odbc.JdbcOdbcDriver");
}else{
System.out.println("sun.jdbc.odbc.JdbcOdbcDriver");
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
}
conn= java.sql.DriverManager.getConnection("JDBC:ODBC:test",
pBridge);
fLog = new File("DriverManager.log");
fosLog = new FileOutputStream(fLog);
psLog = new PrintStream((OutputStream)fosLog);
java.sql.DriverManager.setLogStream(psLog);
//conn.setAutoCommit(false);
cstmt = conn.prepareCall("{call insert_bheader(?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ? ,?, ?, ?)}");
cstmt.setString(1, "1hl6^^^^^");
cstmt.setString(2, "b1^^^^^^^");
cstmt.setString(3, "11a6^^^^^");
cstmt.setString(4, "146^^^^^^");
cstmt.setString(5, "/bbs/1998/3/4/1hl6^^^^^");
cstmt.setString(6, "");
cstmt.setInt(7, 0);
cstmt.setString(8, "0");
cstmt.setString(9, "0");
cstmt.setString(10, "0");
cstmt.setString(11, "0");
cstmt.setString(12, "0");
cstmt.setInt(13, 0);
cstmt.setString(14, new String(new
String("XXX").getBytes("8859_1"),"KSC5601"));// XXX in Korean
cstmt.setString(15, new String(new
String("XXX").getBytes("8859_1"),"KSC5601"));
cstmt.setTimestamp(16,new java.sql.Timestamp(98, 1, 1, 1, 1, 0, 0));
cstmt.setDate(17, new java.sql.Date(98,1,1));// <<<<<<< Error occured
line
cstmt.setString(18, "0");
cstmt.setInt(19, 0);
cstmt.execute();
}catch(SQLException se){
System.out.println("SQLState:"+se.getSQLState());
System.out.println("Message:"+se.getMessage());
System.out.println("Vendor:"+se.getErrorCode());
}catch(Exception e){
e.printStackTrace();
}finally{
System.out.println("done Connection");
}
}
}
-----------------------------
belows are error message
----------------------------
*Connection.prepareCall ({call insert_bheader(?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ? ,?, ?, ?)})
Allocating Statement Handle (SQLAllocStmt), hDbc=9964864
hStmt=31885480
Preparing (SQLPrepare), hStmt=31885480, szSqlStr={call insert_bheader(?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ,?, ?, ?)}
Number of parameter markers (SQLNumParams), hStmt=31885480
value=19
Registering Statement sun.jdbc.odbc.JdbcOdbcCallableStatement@20cb3d
Binding IN string parameter (SQLBindParameter), hStmt=31885480, ipar=1,
SQLtype=1, precision=255, scale=0, rgbValue=1hl6^^^^^
Binding IN string parameter (SQLBindParameter), hStmt=31885480, ipar=2,
SQLtype=1, precision=255, scale=0, rgbValue=b1^^^^^^^
Binding IN string parameter (SQLBindParameter), hStmt=31885480, ipar=3,
SQLtype=1, precision=255, scale=0, rgbValue=11a6^^^^^
Binding IN string parameter (SQLBindParameter), hStmt=31885480, ipar=4,
SQLtype=1, precision=255, scale=0, rgbValue=146^^^^^^
Binding IN string parameter (SQLBindParameter), hStmt=31885480, ipar=5,
SQLtype=1, precision=255, scale=0, rgbValue=/bbs/1998/3/4/1hl6^^^^^
Binding IN string parameter (SQLBindParameter), hStmt=31885480, ipar=6,
SQLtype=1, precision=255, scale=0, rgbValue=
Binding IN parameter integer (SQLBindParameter), hStmt=31885480,
ipar=7SQLtype=4, rgbValue=0
Binding IN string parameter (SQLBindParameter), hStmt=31885480, ipar=8,
SQLtype=1, precision=255, scale=0, rgbValue=0
Binding IN string parameter (SQLBindParameter), hStmt=31885480, ipar=9,
SQLtype=1, precision=255, scale=0, rgbValue=0
Binding IN string parameter (SQLBindParameter), hStmt=31885480, ipar=10,
SQLtype=1, precision=255, scale=0, rgbValue=0
Binding IN string parameter (SQLBindParameter), hStmt=31885480, ipar=11,
SQLtype=1, precision=255, scale=0, rgbValue=0
Binding IN string parameter (SQLBindParameter), hStmt=31885480, ipar=12,
SQLtype=1, precision=255, scale=0, rgbValue=0
Binding IN parameter integer (SQLBindParameter), hStmt=31885480,
ipar=13SQLtype=4, rgbValue=0
Binding IN string parameter (SQLBindParameter), hStmt=31885480, ipar=14,
SQLtype=1, precision=255, scale=0, rgbValue=XXX
Binding IN string parameter (SQLBindParameter), hStmt=31885480, ipar=15,
SQLtype=1, precision=255, scale=0, rgbValue=XXX
Binding IN parameter timestamp (SQLBindParameter), hStmt=31885480,
ipar=16, rgbValue=1998-02-01 01:01:00.0
Binding IN parameter date (SQLBindParameter), hStmt=31885480, ipar=17,
rgbValue=1998-02-01
RETCODE = -1
ERROR - Generating SQLException...
SQLException: SQLState(S1C00) vendor code(0)
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Optional
feature not implemented
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:3669)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:3822)
at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterDate(JdbcOdbc.java:313)
at
sun.jdbc.odbc.JdbcOdbcPreparedStatement.setDate(JdbcOdbcPreparedStatement.java:537)
at TestProcedure.main(TestProcedure.java:53)
-----------------
Thanks...
--
===================================================
Kwon-Kee Lim
Dept. Inter/Intranet Developement , Handysoft corp.
kk...@handysoft.co.kr
===================================================
Bob Doppel
Try using the getObject() and setObject() instead of getXXX and setXXX
Kwon Kee Lim wrote in message <34FD4B52...@handysoft.com>...