Rules for detecting open database resource(connection/stream/resultsetetc) - java

[somnat...@gmail.com]

Hello Techies,

             I am trying to test the rule which checks for DB resource not being closed . However I don't see the rule getting triggered .  When I browse the rules, I see the below 2 rules deprecated. 

Bad practice - Method may fail to close database resource on exception

DEPRECATED     Java

Bad practice - Method may fail to close database resource

DEPRECATED     Java

It says to use S2095. How to use this rule ? Wouldn't this rule be automatically invoked  when the database connection is not being closed in the java code ? 

I am using sonar way as quality profile. Sonarqube version 5.1.2 and java plugin version "sonar-java-plugin-3.0". Please let me know 

Regards

Somnath

[G. Ann Campbell]

Both the Java Plugin version of the rule and the FindBugs version require bytecode to work properly, so make sure you're providing that to the analysis. If you're not getting issues when you should, that's likely the cause.

BTW, neither version of the rule will monitor your running code. Instead, they each examine the logic in the program to make sure that when they see a resource opened, they can also see (in the appropriate execution path) that resource get closed.

HTH,

Ann

[somnat...@gmail.com]

Thanks a lot Ann  for your reply. .. it seems I didnot provide the .class file with the .java file. Do I need to provide the .class file along with the .java file as well ? should the .java and .class file be present in the same folder ? 

Regards

Somnath

[G. Ann Campbell]

Take a look here: http://docs.sonarqube.org/display/PLUG/Java+Plugin+and+Bytecode

---

G. Ann CAMPBELL | SonarSource

Product Owner

http://sonarsource.com

--
You received this message because you are subscribed to a topic in the Google Groups "SonarQube" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/sonarqube/n-rJfzKG_-A/unsubscribe.
To unsubscribe from this group and all its topics, send an email to sonarqube+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sonarqube/30d7b853-cac2-4282-b09b-c89614f0c92b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.