Wrong column type encountered with Objects
I have a little Problem with my column types. I have two sites wo communicate over REST. My problem is that I have a database behind wo expects a specific type and I can not get it to work.
@Entity
@Table(name = "inventory")
public class Inventory implements java.io.Serializable {
private static final long serialVersionUID = 1L;
private int inventoryId;
private Film film;
@Column(name = "film_id", nullable = false)
public Film getFilm() {
return film;
}
public void setFilm(Film film) {
this.film = film;
}
//everything else
Film Class
public class Film implements java.io.Serializable {
private int filmId;
//everything else
Error Log:
{"WFLYCTL0080: Failed services" => {"jboss.persistenceunit."sprint-3-gruppe-1-store.war#default"" => "javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory
Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: wrong column type encountered in column [film_id] in table [inventory]; found [int4 (Types#INTEGER)], but expecting [byte (Types#VARBINARY)]"}}
Does somebody know how to fix this problem? I have this in my persistence.xml, but when I delete it I ran into some other issues. So the best way would be to define a columntype, but I don't know what he expects.
<property name="hibernate.hbm2ddl.auto" value="validate" />
hibernate rest java-ee
asked Nov 24 '18 at 13:57
FelixFelix
317
add a comment |
I have a little Problem with my column types. I have two sites wo communicate over REST. My problem is that I have a database behind wo expects a specific type and I can not get it to work.
@Entity
@Table(name = "inventory")
public class Inventory implements java.io.Serializable {
private static final long serialVersionUID = 1L;
private int inventoryId;
private Film film;
@Column(name = "film_id", nullable = false)
public Film getFilm() {
return film;
}
public void setFilm(Film film) {
this.film = film;
}
//everything else
Film Class
public class Film implements java.io.Serializable {
private int filmId;
//everything else
Error Log:
{"WFLYCTL0080: Failed services" => {"jboss.persistenceunit."sprint-3-gruppe-1-store.war#default"" => "javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory
Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: wrong column type encountered in column [film_id] in table [inventory]; found [int4 (Types#INTEGER)], but expecting [byte (Types#VARBINARY)]"}}
Does somebody know how to fix this problem? I have this in my persistence.xml, but when I delete it I ran into some other issues. So the best way would be to define a columntype, but I don't know what he expects.
<property name="hibernate.hbm2ddl.auto" value="validate" />
hibernate rest java-ee
asked Nov 24 '18 at 13:57
FelixFelix
317
1
Your film is not entity. Consider using @ElementCollection
– kret
Nov 25 '18 at 20:35
add a comment |
I have a little Problem with my column types. I have two sites wo communicate over REST. My problem is that I have a database behind wo expects a specific type and I can not get it to work.
@Entity
@Table(name = "inventory")
public class Inventory implements java.io.Serializable {
private static final long serialVersionUID = 1L;
private int inventoryId;
private Film film;
@Column(name = "film_id", nullable = false)
public Film getFilm() {
return film;
}
public void setFilm(Film film) {
this.film = film;
}
//everything else
Film Class
public class Film implements java.io.Serializable {
private int filmId;
//everything else
Error Log:
{"WFLYCTL0080: Failed services" => {"jboss.persistenceunit."sprint-3-gruppe-1-store.war#default"" => "javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory
Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: wrong column type encountered in column [film_id] in table [inventory]; found [int4 (Types#INTEGER)], but expecting [byte (Types#VARBINARY)]"}}
Does somebody know how to fix this problem? I have this in my persistence.xml, but when I delete it I ran into some other issues. So the best way would be to define a columntype, but I don't know what he expects.
<property name="hibernate.hbm2ddl.auto" value="validate" />
hibernate rest java-ee
asked Nov 24 '18 at 13:57
FelixFelix
317
I have a little Problem with my column types. I have two sites wo communicate over REST. My problem is that I have a database behind wo expects a specific type and I can not get it to work.
@Entity
@Table(name = "inventory")
public class Inventory implements java.io.Serializable {
private static final long serialVersionUID = 1L;
private int inventoryId;
private Film film;
@Column(name = "film_id", nullable = false)
public Film getFilm() {
return film;
}
public void setFilm(Film film) {
this.film = film;
}
//everything else
Film Class
public class Film implements java.io.Serializable {
private int filmId;
//everything else
Error Log:
{"WFLYCTL0080: Failed services" => {"jboss.persistenceunit."sprint-3-gruppe-1-store.war#default"" => "javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory
Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: wrong column type encountered in column [film_id] in table [inventory]; found [int4 (Types#INTEGER)], but expecting [byte (Types#VARBINARY)]"}}
Does somebody know how to fix this problem? I have this in my persistence.xml, but when I delete it I ran into some other issues. So the best way would be to define a columntype, but I don't know what he expects.
<property name="hibernate.hbm2ddl.auto" value="validate" />
hibernate rest java-ee
hibernate rest java-ee
asked Nov 24 '18 at 13:57
FelixFelix
317
asked Nov 24 '18 at 13:57
FelixFelix
317
asked Nov 24 '18 at 13:57
FelixFelix
317
asked Nov 24 '18 at 13:57
FelixFelix
317
asked Nov 24 '18 at 13:57
FelixFelix
317
317
1
Your film is not entity. Consider using @ElementCollection
– kret
Nov 25 '18 at 20:35
add a comment |
1
Your film is not entity. Consider using @ElementCollection
– kret
Nov 25 '18 at 20:35
1
1
Your film is not entity. Consider using @ElementCollection
– kret
Nov 25 '18 at 20:35
Your film is not entity. Consider using @ElementCollection
– kret
Nov 25 '18 at 20:35
add a comment |
0
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',
autoActivateHeartbeat: false,
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53458873%2fwrong-column-type-encountered-with-objects%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53458873%2fwrong-column-type-encountered-with-objects%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
1
Your film is not entity. Consider using @ElementCollection
– kret
Nov 25 '18 at 20:35