ResultSetMappingBuilder and name conflict in mapper











up vote
1
down vote

favorite












I've got entity A with two ManyToOne relations. And both join columns with same name. When I am creating query based on entity A with ResultSetMappingBuilder and setting this entity to method addRootEntityFromClassMetada it results in InvalidArgumentException The column 'created_by' conflicts with another column in the mapper..



Here is quick sample for entity A



/**
* @var B
* @ManyToOne(targetEntity="B")
* @JoinColumn(name="created_by", referencedColumnName="id")
*/
private $a;

/**
* @var C
* @ManyToOne(targetEntity="C")
* @JoinColumn(name="created_by", referencedColumnName="id")
*/
private $b;


How can I avoid to conflict? I tried almost everything that I found on stack. But there are not many problems with this.



Doctrine 2.6.1



Thanks for you answers,
Michal












share|improve this question






















  • Sadly I no longer have access to code where I've faced the issue but I think I worked this around aliasing conflicting columns. There's also a chance I had to manually map RSM due to this.
    – malarzm
    yesterday















up vote
1
down vote

favorite












I've got entity A with two ManyToOne relations. And both join columns with same name. When I am creating query based on entity A with ResultSetMappingBuilder and setting this entity to method addRootEntityFromClassMetada it results in InvalidArgumentException The column 'created_by' conflicts with another column in the mapper..



Here is quick sample for entity A



/**
* @var B
* @ManyToOne(targetEntity="B")
* @JoinColumn(name="created_by", referencedColumnName="id")
*/
private $a;

/**
* @var C
* @ManyToOne(targetEntity="C")
* @JoinColumn(name="created_by", referencedColumnName="id")
*/
private $b;


How can I avoid to conflict? I tried almost everything that I found on stack. But there are not many problems with this.



Doctrine 2.6.1



Thanks for you answers,
Michal












share|improve this question






















  • Sadly I no longer have access to code where I've faced the issue but I think I worked this around aliasing conflicting columns. There's also a chance I had to manually map RSM due to this.
    – malarzm
    yesterday













up vote
1
down vote

favorite









up vote
1
down vote

favorite











I've got entity A with two ManyToOne relations. And both join columns with same name. When I am creating query based on entity A with ResultSetMappingBuilder and setting this entity to method addRootEntityFromClassMetada it results in InvalidArgumentException The column 'created_by' conflicts with another column in the mapper..



Here is quick sample for entity A



/**
* @var B
* @ManyToOne(targetEntity="B")
* @JoinColumn(name="created_by", referencedColumnName="id")
*/
private $a;

/**
* @var C
* @ManyToOne(targetEntity="C")
* @JoinColumn(name="created_by", referencedColumnName="id")
*/
private $b;


How can I avoid to conflict? I tried almost everything that I found on stack. But there are not many problems with this.



Doctrine 2.6.1



Thanks for you answers,
Michal












share|improve this question













I've got entity A with two ManyToOne relations. And both join columns with same name. When I am creating query based on entity A with ResultSetMappingBuilder and setting this entity to method addRootEntityFromClassMetada it results in InvalidArgumentException The column 'created_by' conflicts with another column in the mapper..



Here is quick sample for entity A



/**
* @var B
* @ManyToOne(targetEntity="B")
* @JoinColumn(name="created_by", referencedColumnName="id")
*/
private $a;

/**
* @var C
* @ManyToOne(targetEntity="C")
* @JoinColumn(name="created_by", referencedColumnName="id")
*/
private $b;


How can I avoid to conflict? I tried almost everything that I found on stack. But there are not many problems with this.



Doctrine 2.6.1



Thanks for you answers,
Michal









php doctrine2 doctrine






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked yesterday









Michal Hlávka

463




463












  • Sadly I no longer have access to code where I've faced the issue but I think I worked this around aliasing conflicting columns. There's also a chance I had to manually map RSM due to this.
    – malarzm
    yesterday


















  • Sadly I no longer have access to code where I've faced the issue but I think I worked this around aliasing conflicting columns. There's also a chance I had to manually map RSM due to this.
    – malarzm
    yesterday
















Sadly I no longer have access to code where I've faced the issue but I think I worked this around aliasing conflicting columns. There's also a chance I had to manually map RSM due to this.
– malarzm
yesterday




Sadly I no longer have access to code where I've faced the issue but I think I worked this around aliasing conflicting columns. There's also a chance I had to manually map RSM due to this.
– malarzm
yesterday

















active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














 

draft saved


draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53371302%2fresultsetmappingbuilder-and-name-conflict-in-mapper%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown






























active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes
















 

draft saved


draft discarded



















































 


draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53371302%2fresultsetmappingbuilder-and-name-conflict-in-mapper%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

404 Error Contact Form 7 ajax form submitting

How to know if a Active Directory user can login interactively

Refactoring coordinates for Minecraft Pi buildings written in Python