Error while inserting UUID array with PostgreSQL











up vote
1
down vote

favorite












I have an attribute in one of my entity class as below



@Column(name = "idc_reviewer", columnDefinition="_uuid")

private UUID reviewer;


While saving the entity, I am getting below error.



ERROR: column "idc_reviewer" is of type uuid but expression is of type bytea

  Hint: You will need to rewrite or cast the expression.


I tried replacing columnDefinition with pg-uuid but that too didn't work.



Software Version:
Hibernate: 5.2.17
SpringBoot: 2.0.3






java postgresql hibernate spring-boot postgresql-10







share|improve this question
























  • How do you expect that postgres will store an array in a table column?
    – M. Deinum
    21 hours ago






  • 4




    @M.Deinum: because Postgres supports it (but apparently Hibernate does not)
    – a_horse_with_no_name
    21 hours ago












  • Hmm... Learned something new :). You probably need a custom type for this then. And of course Vlad has you already covered (see vladmihalcea.com/…).
    – M. Deinum
    20 hours ago












  • @M.Deinum If there is no other approach, Thats a last option for me :)
    – CuriousMind
    19 hours ago















up vote
1
down vote

favorite












I have an attribute in one of my entity class as below



@Column(name = "idc_reviewer", columnDefinition="_uuid")

private UUID reviewer;


While saving the entity, I am getting below error.



ERROR: column "idc_reviewer" is of type uuid but expression is of type bytea

  Hint: You will need to rewrite or cast the expression.


I tried replacing columnDefinition with pg-uuid but that too didn't work.



Software Version:
Hibernate: 5.2.17
SpringBoot: 2.0.3






java postgresql hibernate spring-boot postgresql-10







share|improve this question
























  • How do you expect that postgres will store an array in a table column?
    – M. Deinum
    21 hours ago






  • 4




    @M.Deinum: because Postgres supports it (but apparently Hibernate does not)
    – a_horse_with_no_name
    21 hours ago












  • Hmm... Learned something new :). You probably need a custom type for this then. And of course Vlad has you already covered (see vladmihalcea.com/…).
    – M. Deinum
    20 hours ago












  • @M.Deinum If there is no other approach, Thats a last option for me :)
    – CuriousMind
    19 hours ago













up vote
1
down vote

favorite









up vote
1
down vote

favorite











I have an attribute in one of my entity class as below



@Column(name = "idc_reviewer", columnDefinition="_uuid")

private UUID reviewer;


While saving the entity, I am getting below error.



ERROR: column "idc_reviewer" is of type uuid but expression is of type bytea

  Hint: You will need to rewrite or cast the expression.


I tried replacing columnDefinition with pg-uuid but that too didn't work.



Software Version:
Hibernate: 5.2.17
SpringBoot: 2.0.3






java postgresql hibernate spring-boot postgresql-10







share|improve this question















I have an attribute in one of my entity class as below



@Column(name = "idc_reviewer", columnDefinition="_uuid")

private UUID reviewer;


While saving the entity, I am getting below error.



ERROR: column "idc_reviewer" is of type uuid but expression is of type bytea

  Hint: You will need to rewrite or cast the expression.


I tried replacing columnDefinition with pg-uuid but that too didn't work.



Software Version:
Hibernate: 5.2.17
SpringBoot: 2.0.3






java postgresql hibernate spring-boot postgresql-10




java postgresql hibernate spring-boot postgresql-10






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 21 hours ago

























asked 21 hours ago









CuriousMind

2,12422135




2,12422135












  • How do you expect that postgres will store an array in a table column?
    – M. Deinum
    21 hours ago






  • 4




    @M.Deinum: because Postgres supports it (but apparently Hibernate does not)
    – a_horse_with_no_name
    21 hours ago












  • Hmm... Learned something new :). You probably need a custom type for this then. And of course Vlad has you already covered (see vladmihalcea.com/…).
    – M. Deinum
    20 hours ago












  • @M.Deinum If there is no other approach, Thats a last option for me :)
    – CuriousMind
    19 hours ago


















  • How do you expect that postgres will store an array in a table column?
    – M. Deinum
    21 hours ago






  • 4




    @M.Deinum: because Postgres supports it (but apparently Hibernate does not)
    – a_horse_with_no_name
    21 hours ago












  • Hmm... Learned something new :). You probably need a custom type for this then. And of course Vlad has you already covered (see vladmihalcea.com/…).
    – M. Deinum
    20 hours ago












  • @M.Deinum If there is no other approach, Thats a last option for me :)
    – CuriousMind
    19 hours ago
















How do you expect that postgres will store an array in a table column?
– M. Deinum
21 hours ago




How do you expect that postgres will store an array in a table column?
– M. Deinum
21 hours ago




4




4




@M.Deinum: because Postgres supports it (but apparently Hibernate does not)
– a_horse_with_no_name
21 hours ago






@M.Deinum: because Postgres supports it (but apparently Hibernate does not)
– a_horse_with_no_name
21 hours ago














Hmm... Learned something new :). You probably need a custom type for this then. And of course Vlad has you already covered (see vladmihalcea.com/…).
– M. Deinum
20 hours ago






Hmm... Learned something new :). You probably need a custom type for this then. And of course Vlad has you already covered (see vladmihalcea.com/…).
– M. Deinum
20 hours ago














@M.Deinum If there is no other approach, Thats a last option for me :)
– CuriousMind
19 hours ago




@M.Deinum If there is no other approach, Thats a last option for me :)
– CuriousMind
19 hours ago

















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%2f53370908%2ferror-while-inserting-uuid-array-with-postgresql%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%2f53370908%2ferror-while-inserting-uuid-array-with-postgresql%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

Image
0 The contact form does not work, and affects loading after one try. The chrome console shows the error message: POST http://example.com/wp-json/contact-form-7/v1/contact-forms/50/feedback 404 (Not Found) send @ jquery.js?ver=1.12.4:4 ajax @ jquery.js?ver=1.12.4:4 wpcf7.submit @ scripts.js?ver=5.0.3:346 (anonymous) @ scripts.js?ver=5.0.3:53 dispatch @ jquery.js?ver=1.12.4:3 r.handle @ jquery.js?ver=1.12.4:3 How to solve this issue? thanks in advance javascript wordpress contact-form-7 share | improve this question edited Jul 17 '18 at 5:39 Kiran Shahi 4,745 3 16 43 ...
Read more

How to know if a Active Directory user can login interactively

Image
1 I would like to know if and how is it possible to know if a AD user can login interactively (on a server) in a domain. I need to know if I can find it out using a LDAP search. Thanks. windows active-directory login user-permissions user-profile share | improve this question edited 1 hour ago yagmoth555 ♦ 11.6k 3 17 42 asked 1 hour ago Luigi Luigi 6 1 New contributor ...
Read more

Refactoring coordinates for Minecraft Pi buildings written in Python

Image
0 $begingroup$ I'm fairly new to coding and I wrote this script in Python for a house with a roof in Minecraft Pi. I've found different ways to write the coordinates to make the code base shorter, but I'm wondering if it is possible for me to refactor it any further so I don't have to list each coordinate line by line. import mcpi.minecraft as minecraft import mcpi.block as block mc = minecraft.Minecraft.create() p = mc.player.getTilePos() mc.setBlocks(p.x+1, p.y, p.z+1, #Main structure starting coordinates (DO NOT ALTER) p.x+19, p.y+4, p.z+6, #Structure size/coordinates (Alters cube size) block.STONE_BRICK) mc.setBlocks(p.x+2, p.y+1, p.z+2, #Hollowing out main structure interior p.x+18, p.y+3, p.z+5, block.AIR) mc.setBlocks(p.x, p.y...
Read more