permaculture playing cards*
The moose likes JDBC and the fly likes GENERAL ERROR Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "GENERAL ERROR" Watch "GENERAL ERROR" New topic
Author

GENERAL ERROR

prabhu kandanur
Greenhorn

Joined: Dec 24, 2003
Posts: 14
HI
CAN ANYONE TELL WHY OCCASSIONALLY I GET 'GENERAL ERROR' EXCEPTION IS COMING.
JDK VERSION : JDK117
SQL SERVER VERSION : SQL SERVER 2000
SQL SERVER DRIVER USED
SOME TIMES WHEN I INSERT VALUES INTO DATABASE (NOT EVERY TIME) 'GENERAL ERROR' IS DISPLAYING IN THE EXCEPTION AND THE ROW IS NOT INSERTED
PRABHU :roll:
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Originally posted by prabhu kandanur:
HI
CAN ANYONE TELL WHY OCCASSIONALLY I GET 'GENERAL ERROR' EXCEPTION IS COMING.
JDK VERSION : JDK117
SQL SERVER VERSION : SQL SERVER 2000
SQL SERVER DRIVER USED
SOME TIMES WHEN I INSERT VALUES INTO DATABASE (NOT EVERY TIME) 'GENERAL ERROR' IS DISPLAYING IN THE EXCEPTION AND THE ROW IS NOT INSERTED
PRABHU :roll:

some things that might help us are:
1. what type of exception is it ( SQLException? )
2. what is the code that is causing the exception ( small snippet that identifies which line is causing the problem, as well as the SQL text )
3. SQL SERVER DRIVER USED -- does this mean Microsoft's driver? is it a type 4 driver?
4. can you chain through to find any other Exception messages in your exception block. Sometimes the first exception masks any other exceptions that are happening at the database( see the SQLException method getNextException() to chain down for any other exception messages ).
Jamie
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: GENERAL ERROR
 
Similar Threads
Problem in output
SQL server Error and Exception Handling in java
SQL server connection problem
The TDS prelogin response is incomplete
Works with JDBC/ODBC but not Direct JDBC