Database successes and fails, java

[BrownZeus]

Hey guys,

 

I'm having a case of "I don't know how to query my google search to find the answers I want"

 

So if I can be pointed in the right direction that would be great.

 

I have a java app that I'm writing that reads and writes to a MariaDB database.

How do I go about detecting the different exeptions that are thrown? For example, if the connection to the DB fails, obviously an SQLException is thrown, but a specific type, also obvious. So how do I read the exception so I can provide the proper handling for it?

 

TIA

[espurritado]

I'm not sure I understand exactly the problem you are having.

 

If your problem is that there might come more than one type of exception from within a try statement, just add several catch clauses

try{
 <whatever comes in> 
}
catch (ExceptionTypeOne e){
  <handle exception>
}
catch (ExceptionTypeTwo e){
 <handle exception> 
}

If your problem is that you want to differenciate according to the content of the exception, you should look into the 'e' object so you can try and find whatever you are looking for

[BrownZeus]

9 minutes ago, espurritado said:

I'm not sure I understand exactly the problem you are having.

 

If your problem is that there might come more than one type of exception from within a try statement, just add several catch clauses

try{
 <whatever comes in> 
}
catch (ExceptionTypeOne e){
  <handle exception>
}
catch (ExceptionTypeTwo e){
 <handle exception> 
}

If your problem is that you want to differenciate according to the content of the exception, you should look into the 'e' object so you can try and find whatever you are looking for

Yes, basically I wanna read into what the content of exception is and handle according to the different errors. 

 

So how do I look into the e object and get the content of the exception?

[reniat]

46 minutes ago, BrownZeus said:

Yes, basically I wanna read into what the content of exception is and handle according to the different errors. 

 

So how do I look into the e object and get the content of the exception?

 

find the oracle documentation for the base Exception object https://docs.oracle.com/javase/8/docs/api/index.html?java/lang/Exception.html
and see what the doc says about it, what fields it has, expected usage, etc.

 

Another way is just see for yourself. Make a small dummy project, throw an exception while debugging, and use a breakpoint to pause execution in your catch block so you can analyze the exception object you caught.