Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlferns
Starting Member
8 Posts |
 Posted - 2008-09-02 : 12:32:45
|
| The database is in SQL SERVER 2005 and the application is in JAVA. When I run the application for the first time it gave me the FOLLOWING ERROR, BUT when I run it second time, it did NOT GIVE any errors but runned successfully. Could any one guide me. ***********************************************************The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 2 (""): The supplied value is not a valid instance of data type datetime. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision.: SQL= DB_COMM_DETAIL ( DB_COMM_DETAIL.N_DCDT_OID , DB_COMM_DETAIL.D_DCDT_PROC , DB_COMM_DETAIL.N_BTRN_OID , DB_COMM_DETAIL.N_DCST_OID , DB_COMM_DETAIL.N_DBPI_OID ) Values ( ? , ? , ? , ? , ? ) [:1=74320, :2=2008-08-29 14:42:40.027, :3=null, :4=78801, :5=53402] |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2008-09-03 : 00:08:07
|
| You're error is likely a java error, and not sql related (i.e. assigning a null value to a java variable which is not nullable.) You will probably have better luck posting on a Java Forum. |
 |
|
|
sqlferns
Starting Member
8 Posts |
Posted - 2008-09-03 : 16:47:46
|
| can you recommend some site where i can post my error |
|
|
|
|
|
|
|
|
Value is not valid instance of data type datetime