Hello,
I have a small database with six tables and connect to it via the JDBC-Driver. Everything
worked fine since yesterday after I had installed the Visual Studio .NET 2003. To describe
my
problem here the small test program which causes the error:
public class SapDBTest {
public static void main(String[] args) {
// com.sap.dbtech.jdbc.DriverSapDB -database
try {
Class.forName("com.sap.dbtech.jdbc.DriverSapDB");
Tracer.setLog(System.out);
Tracer.setVerbosity(Tracer.fullTrace_C);
Connection conn =
DriverManager.getConnection("jdbc:sapdb://localhost/TESTDB2", "dba", "dba");
Statement stmt = conn.createStatement();
stmt.execute("drop table Comment");
conn.close();
} catch(ClassNotFoundException e) {
e.printStackTrace();
} catch(SQLException e) {
Tracer.flush();
e.printStackTrace();
}
}
}
When I execute this on my system, I get the following trace:
---- Thread 3ee284 main Timestamp: 2003-04-13 16:05:32.749
REQUEST:
0018 00 01 00 00 37 30 34 30 '....7040'
0020 30 4f 44 42 00 00 7e 40 00 00 00 70 00 00 00 01 '0ODB..~@...p....'
0030 00 00 00 00 00 00 00 00 00 00 00 70 00 00 00 00 '...........p....'
0040 00 02 00 01 01 02 01 01 01 00 00 01 00 00 00 00 '................'
0050 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 '................'
0060 03 00 00 01 00 00 00 00 00 00 00 12 00 00 7d f8 '..............}ø'
0070 64 72 6f 70 20 74 61 62 6c 65 20 43 6f 6d 6d 65 'drop table Comme'
0080 6e 74 66 69 65 64 20 62 0d 00 00 01 00 00 00 00 'ntfied b........'
0090 00 00 00 0d 00 00 7d d0 4a 44 42 43 5f 43 55 52 '......}ÐJDBC_CUR'
00a0 53 4f 52 5f 31 00 00 00 00 00 00 2c 00 00 7d b8 'SOR_1......,..}¸'
00b0 00 3b 09 ef a0 59 53 c8 b4 3d 37 4f 60 c2 36 27 '.;.ï
YSÈ´=7O`Â6''
00c0 c9 b4 17 a3 07 56 ed 27 2c 20 20 20 20 20 20 20
'É´.£.Ví', '
00d0 20 20 20 20 20 20 20 20 6a 61 76 61 00 00 00 00 ' java....'
00e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 '................'
00f0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 '................'
0100 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 '................'
0110 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 '................'
0120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 '................'
0130 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 '................'
0140 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 '................'
0150 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 '................'
0160 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 '................'
0170 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 '................'
0180 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 '................'
0190 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 '................'
01a0 00 00 00 00 00 00 00 00 '........'
REPLY:
0000 00 01 00 00 37 30 34 30 30 4f 44 42 00 00 8d 90 '....70400ODB..??'
0010 00 00 00 90 00 00 00 01 00 00 00 00 00 00 00 00 '...?............'
0020 00 00 00 90 00 00 00 00 00 01 00 01 02 49 37 35 '...?.........I75'
0030 30 30 e2 b4 00 00 00 00 00 00 00 00 00 08 00 00 '00â´............'
0040 00 00 00 00 00 00 00 00 06 00 00 01 00 00 00 00 '................'
0050 00 00 00 56 00 00 8d 58 44 43 4f 4d 20 48 52 45 '...V..?XDCOM HRE'
0060 53 55 4c 54 3a d3 07 04 00 40 87 db 3e 05 00 20 'SULT:Ó...@?Û>..
'
0070 00 23 84 e9 77 a0 bb 0d 00 d4 55 df ae 00 00 00 '.#?éw
»..ÔUß®...'
0080 00 56 df 2e 4f 5f 41 77 5f fb 00 00 00 48 36 88 '.Vß.O_Aw_û...H6?'
0090 00 c4 57 da 00 dc db 14 05 00 a1 61 3e f7 3c 84
'.ÄWÚ.ÜÛ...¡a>÷<?'
00a0 74 20 02 00 00 2c 30 30 30 30 30 30 30 32 ff ff 't ...,00000002ÿÿ'
<PACKECT
messcode="0"
mess swap="1"
application="70400ODB" >
<! (used 144 of 36240)>
<SEGMENT
type="REPLY"
index="1"
offset="0"
length="144"
number_of_parts="1"
<! I7500 (-7500) Pos: 0 Warnings (0, 0) Function: 8 >
<PART
partkind="Errortext_C"
arg_count="1"
buflen="86"
bufsize="36184"
partpos="72"
</PART>
</SEGMENT>
</PACKECT> <!=================End of packet >
com.sap.dbtech.jdbc.exceptions.DatabaseException: [-7500]: DCOM HRESULT:Ó
at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:758)
at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:424)
at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:318)
at com.sap.dbtech.jdbc.StatementSapDB.sendCommand(StatementSapDB.java:680)
at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)
at com.sap.dbtech.jdbc.StatementSapDB.execute(StatementSapDB.java:219)
at com.sap.dbtech.jdbc.StatementSapDB.execute(StatementSapDB.java:186)
After that I tried to execute "drop table Comment" in the SQL Studio and the same
error happens. Because it doesn't work anymore since the installation of VS.NET 2003
I assume that the problem lies in updated system libraries etc.
Any help ?
Bye,
Michael
Attachment: [text/html]
Attachment: [text/html]
