Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
ID | |||||||||||
0038136 | |||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
design defect | [Openbravo ERP] Z. Others | minor | have not tried | 2018-03-14 13:00 | 2022-02-01 08:07 | ||||||
Reporter | shuehner | View Status | public | ||||||||
Assigned To | Triage Platform Base | ||||||||||
Priority | normal | Resolution | open | Fixed in Version | |||||||
Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
Projection | none | ETA | none | Target Version | |||||||
OS | Any | Database | Any | Java version | |||||||
OS Version | Database version | Ant version | |||||||||
Product Version | SCM revision | ||||||||||
Review Assigned To | |||||||||||
Web browser | |||||||||||
Modules | Core | ||||||||||
Regression level | |||||||||||
Regression date | |||||||||||
Regression introduced in release | |||||||||||
Regression introduced by commit | |||||||||||
Triggers an Emergency Pack | No | ||||||||||
Summary | 0038136: Tracking issue: Find & Fix queries not using bind-params but embedding values into query string | ||||||||||
Description | Queries should separate query text from data values which is done using bind-parameters. That is important to 3 reasons: a.) Avoid SQL/HQL injections b.) Not have 'different SQL text' for same query but different values b.1) To efficient utilize hibernate cache b.2) Inefficient use of oracle query cache as not using bind variables make 'same query' show up with many times with different query cache. This issue is to link the various individual issues to fix the concrete cases found. | ||||||||||
Steps To Reproduce | - | ||||||||||
Tags | Performance | ||||||||||
Attached Files | |||||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Issue History | |||
Date Modified | Username | Field | Change |
2018-03-14 13:00 | shuehner | New Issue | |
2018-03-14 13:00 | shuehner | Assigned To | => platform |
2018-03-14 13:00 | shuehner | Modules | => Core |
2018-03-14 13:00 | shuehner | Triggers an Emergency Pack | => No |
2018-03-14 13:03 | shuehner | Relationship added | depends on 0038133 |
2018-03-14 13:04 | shuehner | Relationship added | depends on 0038135 |
2018-03-14 13:13 | shuehner | Relationship added | depends on 0038137 |
2018-03-14 13:24 | shuehner | Relationship added | depends on 0038138 |
2018-03-14 13:36 | shuehner | Relationship added | depends on 0038139 |
2018-03-14 13:49 | shuehner | Relationship added | depends on 0038140 |
2018-03-14 15:09 | shuehner | Relationship added | depends on 0038141 |
2018-03-14 15:24 | shuehner | Relationship added | depends on 0038142 |
2018-03-14 16:15 | shuehner | Relationship added | depends on 0038145 |
2018-03-14 16:26 | shuehner | Description Updated | View Revisions |
2018-03-14 17:22 | shuehner | Relationship added | depends on 0038146 |
2018-03-16 08:59 | alostale | Status | new => acknowledged |
2018-03-16 08:59 | alostale | Tag Attached: Performance | |
2018-03-16 10:01 | alostale | Relationship added | related to 0037641 |
2018-03-22 15:41 | shuehner | Relationship added | depends on 0038199 |
2018-03-22 15:44 | shuehner | Relationship added | depends on 0038200 |
2018-06-15 11:38 | alostale | Type | defect => design defect |
2018-07-12 14:49 | shuehner | Relationship added | depends on 0038941 |
2018-07-13 11:56 | alostale | Relationship added | depends on 0038948 |
2018-07-13 12:15 | alostale | Relationship added | depends on 0038950 |
2019-03-12 11:45 | alostale | Relationship added | depends on 0040358 |
2019-04-04 13:27 | alostale | Relationship added | depends on 0040522 |
2019-04-09 20:30 | shuehner | Relationship added | depends on 0040559 |
2019-04-09 20:32 | shuehner | Relationship added | depends on 0040560 |
2019-04-09 20:56 | shuehner | Relationship added | depends on 0040523 |
2019-04-09 21:01 | shuehner | Relationship added | depends on 0040562 |
2019-04-09 21:05 | shuehner | Relationship added | depends on 0040564 |
2019-04-09 21:08 | shuehner | Relationship added | depends on 0040565 |
2019-04-10 11:13 | shuehner | Relationship added | depends on 0040568 |
2019-04-10 11:17 | shuehner | Relationship added | depends on 0040569 |
2019-04-10 11:23 | shuehner | Relationship added | depends on 0040570 |
2019-04-10 11:25 | shuehner | Relationship added | depends on 0040571 |
2019-04-10 11:28 | shuehner | Relationship added | depends on 0040572 |
2019-04-10 11:30 | shuehner | Relationship added | depends on 0040573 |
2019-04-10 11:41 | shuehner | Relationship added | depends on 0040574 |
2019-04-10 12:32 | shuehner | Relationship added | depends on 0040578 |
2019-04-10 12:36 | shuehner | Relationship added | depends on 0040579 |
2019-04-10 12:38 | shuehner | Relationship added | depends on 0040580 |
2019-04-10 12:42 | shuehner | Relationship added | depends on 0040581 |
2019-04-10 12:47 | shuehner | Relationship added | depends on 0040583 |
2019-04-10 12:53 | shuehner | Relationship added | depends on 0040584 |
2019-04-10 12:56 | shuehner | Relationship added | depends on 0040585 |
2019-04-10 17:36 | shuehner | Relationship added | depends on 0040588 |
2019-04-10 17:57 | shuehner | Relationship added | depends on 0040589 |
2019-04-10 19:25 | shuehner | Relationship added | depends on 0040590 |
2019-04-11 09:45 | alostale | Relationship added | depends on 0040591 |
2019-06-11 09:09 | alostale | Relationship added | depends on 0036239 |
2019-06-27 18:06 | shuehner | Relationship added | depends on 0041198 |
2019-07-02 15:39 | shuehner | Relationship added | depends on 0041199 |
2019-07-02 15:41 | shuehner | Relationship added | depends on 0041231 |
2019-07-02 15:43 | shuehner | Relationship added | depends on 0041232 |
2019-07-02 15:46 | shuehner | Relationship added | depends on 0041233 |
2019-07-02 15:47 | shuehner | Relationship added | depends on 0041234 |
2019-07-02 15:49 | shuehner | Relationship added | depends on 0041235 |
2019-07-02 15:51 | shuehner | Relationship added | depends on 0041236 |
2019-07-02 15:54 | shuehner | Relationship added | depends on 0041237 |
2019-07-02 15:58 | shuehner | Relationship added | depends on 0041238 |
2019-07-02 16:02 | shuehner | Relationship added | depends on 0041239 |
2019-07-02 16:20 | shuehner | Relationship added | depends on 0041240 |
2019-07-02 16:23 | shuehner | Relationship added | depends on 0041242 |
2019-07-02 16:25 | shuehner | Relationship added | depends on 0041243 |
2019-07-02 16:26 | shuehner | Relationship added | depends on 0041244 |
2019-07-02 16:28 | shuehner | Relationship added | depends on 0041245 |
2019-07-03 16:46 | shuehner | Relationship added | depends on 0041251 |
2019-07-03 16:49 | shuehner | Relationship added | depends on 0041252 |
2019-07-03 16:52 | shuehner | Relationship added | depends on 0041253 |
2019-07-03 16:57 | shuehner | Relationship added | depends on 0041257 |
2019-07-04 12:18 | shuehner | Relationship added | depends on 0041273 |
2019-07-04 12:27 | shuehner | Relationship added | depends on 0041274 |
2019-07-04 12:38 | shuehner | Relationship added | depends on 0041278 |
2019-07-04 12:57 | shuehner | Relationship added | depends on 0041280 |
2019-07-04 13:36 | shuehner | Relationship added | depends on 0041281 |
2019-07-04 14:03 | shuehner | Relationship added | depends on 0041284 |
2019-07-04 18:25 | shuehner | Relationship added | depends on 0041289 |
2019-07-09 09:53 | alostale | Relationship added | related to 0041287 |
2019-08-28 13:35 | Sandrahuguet | Relationship added | related to 0041711 |
2020-11-11 14:22 | cberner | Relationship added | related to 0045425 |
2020-11-12 13:54 | cberner | Relationship added | related to 0045435 |
2020-11-12 15:29 | cberner | Relationship added | related to 0045436 |
2020-11-12 16:01 | cberner | Relationship added | related to 0045437 |
2020-11-25 18:17 | cberner | Relationship added | related to 0045513 |
2022-02-01 08:07 | alostale | Assigned To | platform => Triage Platform Base |
2023-02-14 12:27 | shuehner | Relationship added | depends on 0051591 |
2023-02-14 12:46 | shuehner | Relationship added | depends on 0051592 |
2023-02-14 13:10 | shuehner | Relationship added | depends on 0051593 |
2023-02-14 13:31 | shuehner | Relationship added | depends on 0051594 |
2023-02-14 13:53 | shuehner | Relationship added | depends on 0051596 |
2023-02-15 16:45 | shuehner | Relationship added | depends on 0051618 |
2023-02-20 14:35 | shuehner | Relationship added | depends on 0051647 |
2023-02-22 15:30 | shuehner | Relationship added | depends on 0051676 |
Copyright © 2000 - 2009 MantisBT Group |