Mixing
PostgreSQL values of column (type text) are shown as numbers
2
I have a table Campaign_actions which has a column terms with type text.
Today I noticed that all text in the column terms are changed to numbers:
postgresql hibernate
edited Nov 19 '18 at 16:41
Mihai Chelaru
2,14291022
asked Nov 19 '18 at 15:22
Tengo Chilingarashvili
513
|
show 3 more comments
2
I have a table Campaign_actions which has a column terms with type text.
Today I noticed that all text in the column terms are changed to numbers:
postgresql hibernate
edited Nov 19 '18 at 16:41
Mihai Chelaru
2,14291022
asked Nov 19 '18 at 15:22
Tengo Chilingarashvili
513
Looks like OIDs - Hibernate is famous for not being able to properly work withtextcolumns. It always (incorrectly) thinks it needs to treat them as "large objects". How was the data stored in that table?
– a_horse_with_no_name
Nov 19 '18 at 15:26
data is stored through java Api (hibernate).
– Tengo Chilingarashvili
Nov 19 '18 at 15:29
1
Did you tag that column with@Lob? If yes, you should tag with@String
– a_horse_with_no_name
Nov 19 '18 at 15:34
Java Api still works correctly, data is taken as text
– Tengo Chilingarashvili
Nov 19 '18 at 15:37
Hibernate stupidly uses the large objects interface which is a total waste fortextcolumns (and incorrect to begin with). The correct way to work withtextcolumns in JDBC is to usePreparedStatement.setString()andResultSet.getString()
– a_horse_with_no_name
Nov 19 '18 at 15:38
|
show 3 more comments
2
2
2
I have a table Campaign_actions which has a column terms with type text.
Today I noticed that all text in the column terms are changed to numbers:
postgresql hibernate
edited Nov 19 '18 at 16:41
Mihai Chelaru
2,14291022
asked Nov 19 '18 at 15:22
Tengo Chilingarashvili
513
I have a table Campaign_actions which has a column terms with type text.
Today I noticed that all text in the column terms are changed to numbers:
postgresql hibernate
postgresql hibernate
edited Nov 19 '18 at 16:41
Mihai Chelaru
2,14291022
asked Nov 19 '18 at 15:22
Tengo Chilingarashvili
513
edited Nov 19 '18 at 16:41
Mihai Chelaru
2,14291022
asked Nov 19 '18 at 15:22
Tengo Chilingarashvili
513
edited Nov 19 '18 at 16:41
Mihai Chelaru
2,14291022
edited Nov 19 '18 at 16:41
Mihai Chelaru
2,14291022
edited Nov 19 '18 at 16:41
Mihai Chelaru
2,14291022
2,14291022
asked Nov 19 '18 at 15:22
Tengo Chilingarashvili
513
asked Nov 19 '18 at 15:22
Tengo Chilingarashvili
513
asked Nov 19 '18 at 15:22
Tengo Chilingarashvili
513
513
Looks like OIDs - Hibernate is famous for not being able to properly work withtextcolumns. It always (incorrectly) thinks it needs to treat them as "large objects". How was the data stored in that table?
– a_horse_with_no_name
Nov 19 '18 at 15:26
data is stored through java Api (hibernate).
– Tengo Chilingarashvili
Nov 19 '18 at 15:29
1
Did you tag that column with@Lob? If yes, you should tag with@String
– a_horse_with_no_name
Nov 19 '18 at 15:34
Java Api still works correctly, data is taken as text
– Tengo Chilingarashvili
Nov 19 '18 at 15:37
Hibernate stupidly uses the large objects interface which is a total waste fortextcolumns (and incorrect to begin with). The correct way to work withtextcolumns in JDBC is to usePreparedStatement.setString()andResultSet.getString()
– a_horse_with_no_name
Nov 19 '18 at 15:38
|
show 3 more comments
Looks like OIDs - Hibernate is famous for not being able to properly work withtextcolumns. It always (incorrectly) thinks it needs to treat them as "large objects". How was the data stored in that table?
– a_horse_with_no_name
Nov 19 '18 at 15:26
data is stored through java Api (hibernate).
– Tengo Chilingarashvili
Nov 19 '18 at 15:29
1
Did you tag that column with@Lob? If yes, you should tag with@String
– a_horse_with_no_name
Nov 19 '18 at 15:34
Java Api still works correctly, data is taken as text
– Tengo Chilingarashvili
Nov 19 '18 at 15:37
Hibernate stupidly uses the large objects interface which is a total waste fortextcolumns (and incorrect to begin with). The correct way to work withtextcolumns in JDBC is to usePreparedStatement.setString()andResultSet.getString()
– a_horse_with_no_name
Nov 19 '18 at 15:38
Looks like OIDs - Hibernate is famous for not being able to properly work with
text columns. It always (incorrectly) thinks it needs to treat them as "large objects". How was the data stored in that table?– a_horse_with_no_name
Nov 19 '18 at 15:26
Looks like OIDs - Hibernate is famous for not being able to properly work with
text columns. It always (incorrectly) thinks it needs to treat them as "large objects". How was the data stored in that table?– a_horse_with_no_name
Nov 19 '18 at 15:26
data is stored through java Api (hibernate).
– Tengo Chilingarashvili
Nov 19 '18 at 15:29
data is stored through java Api (hibernate).
– Tengo Chilingarashvili
Nov 19 '18 at 15:29
1
1
Did you tag that column with
@Lob? If yes, you should tag with @String– a_horse_with_no_name
Nov 19 '18 at 15:34
Did you tag that column with
@Lob? If yes, you should tag with @String– a_horse_with_no_name
Nov 19 '18 at 15:34
Java Api still works correctly, data is taken as text
– Tengo Chilingarashvili
Nov 19 '18 at 15:37
Java Api still works correctly, data is taken as text
– Tengo Chilingarashvili
Nov 19 '18 at 15:37
Hibernate stupidly uses the large objects interface which is a total waste for
text columns (and incorrect to begin with). The correct way to work with text columns in JDBC is to use PreparedStatement.setString() and ResultSet.getString()– a_horse_with_no_name
Nov 19 '18 at 15:38
Hibernate stupidly uses the large objects interface which is a total waste for
text columns (and incorrect to begin with). The correct way to work with text columns in JDBC is to use PreparedStatement.setString() and ResultSet.getString()– a_horse_with_no_name
Nov 19 '18 at 15:38
|
show 3 more comments
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
});
}
});
draft saved
draft discarded
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%2f53377735%2fpostgresql-values-of-column-type-text-are-shown-as-numbers%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
draft saved
draft discarded
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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.
draft saved
draft discarded
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%2f53377735%2fpostgresql-values-of-column-type-text-are-shown-as-numbers%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
Looks like OIDs - Hibernate is famous for not being able to properly work with
textcolumns. It always (incorrectly) thinks it needs to treat them as "large objects". How was the data stored in that table?– a_horse_with_no_name
Nov 19 '18 at 15:26
data is stored through java Api (hibernate).
– Tengo Chilingarashvili
Nov 19 '18 at 15:29
1
Did you tag that column with
@Lob? If yes, you should tag with@String– a_horse_with_no_name
Nov 19 '18 at 15:34
Java Api still works correctly, data is taken as text
– Tengo Chilingarashvili
Nov 19 '18 at 15:37
Hibernate stupidly uses the large objects interface which is a total waste for
textcolumns (and incorrect to begin with). The correct way to work withtextcolumns in JDBC is to usePreparedStatement.setString()andResultSet.getString()– a_horse_with_no_name
Nov 19 '18 at 15:38