Mixing
Java getting data from a database with an SQL statement
1
so I have data in a table that's initialized on startup in my configbean.
The format is: String id, String name, Double rate
example: "1", "Alabama", .02
In my request bean, I have a function to get ONLY the names.
public List<String> getStateNames() {
List<String> results = em.createNamedQuery("getStateNames").getResultList();
results.sort(null);
return results;
}
Here's the base file StateTax
@Entity
@Table(name = "STATE_TAXES")
@NamedQueries({
/*@NamedQuery(
name = "getTaxRate",
query = "SELECT t FROM StateTax t WHERE t.stateName = :stateName"),*/
@NamedQuery(
name = "getStateNames",
query = "SELECT t FROM StateTax t ORDER BY t.stateID")
})
public class StateTax implements Serializable {
@Id
private String stateID;
private String stateName;
private double taxRate;
//supposed to lok like book.java
public StateTax() {
}
public StateTax(String id, String st, double tax) {
this.stateID = id;
this.stateName = st;
this.taxRate = tax;
}
public String getStateID() {
return stateID;
}
public void setStateID(String stateID) {
this.stateID = stateID;
}
public String getStateName() {
return stateName;
}
public void setStateName(String stateName) {
this.stateName = stateName;
}
public double getTaxRate() {
return taxRate;
}
public void setTaxRate(double taxRate) {
this.taxRate = taxRate;
}
public String getState() {
return stateName;
}
public void setState(String state) {
this.stateName = state;
}
@Override
public int hashCode() {
int hash = 0;
hash += (stateID != null ? stateID.hashCode() : 0);
return hash;
}
@Override
public boolean equals(Object object) {
if (!(object instanceof StateTax)) {
return false;
}
StateTax other = (StateTax) object;
return this.stateID != null || this.stateID == null
&& other.stateID == null || this.stateID.equals(other.stateID);
}
@Override
public String toString() {
return "bookstore.entities.StateTax[ stateId=" + stateID + " ]";
}
}
The end product is supposed to be a drop down box that allows you to select one option in xhtml.
My xhtml portion (which is commented out for now):
<h:outputLabel for="stateOption" value="#{bundle.StateName}"/>
<h:selectOneMenu id="stateName"
required="true"
valueChangeListener="#{cashierBean.setTax}">
<f:selectItems value="#{cashierBean.stateNames}"
var="stateName">
</f:selectItems>
</h:selectOneMenu>
<h:message styleClass="error-message" for="stateOption"/>
So here's a part of the error I get on the SQL statement in my statetax file:
Exception Description: Problem compiling [SELECT t FROM StateTax t ORDER BY t.stateId].
My question: How do I properly get a list of names from a table?
java sql
asked Nov 19 '18 at 22:51
gatorade2131gatorade2131
105
add a comment |
1
so I have data in a table that's initialized on startup in my configbean.
The format is: String id, String name, Double rate
example: "1", "Alabama", .02
In my request bean, I have a function to get ONLY the names.
public List<String> getStateNames() {
List<String> results = em.createNamedQuery("getStateNames").getResultList();
results.sort(null);
return results;
}
Here's the base file StateTax
@Entity
@Table(name = "STATE_TAXES")
@NamedQueries({
/*@NamedQuery(
name = "getTaxRate",
query = "SELECT t FROM StateTax t WHERE t.stateName = :stateName"),*/
@NamedQuery(
name = "getStateNames",
query = "SELECT t FROM StateTax t ORDER BY t.stateID")
})
public class StateTax implements Serializable {
@Id
private String stateID;
private String stateName;
private double taxRate;
//supposed to lok like book.java
public StateTax() {
}
public StateTax(String id, String st, double tax) {
this.stateID = id;
this.stateName = st;
this.taxRate = tax;
}
public String getStateID() {
return stateID;
}
public void setStateID(String stateID) {
this.stateID = stateID;
}
public String getStateName() {
return stateName;
}
public void setStateName(String stateName) {
this.stateName = stateName;
}
public double getTaxRate() {
return taxRate;
}
public void setTaxRate(double taxRate) {
this.taxRate = taxRate;
}
public String getState() {
return stateName;
}
public void setState(String state) {
this.stateName = state;
}
@Override
public int hashCode() {
int hash = 0;
hash += (stateID != null ? stateID.hashCode() : 0);
return hash;
}
@Override
public boolean equals(Object object) {
if (!(object instanceof StateTax)) {
return false;
}
StateTax other = (StateTax) object;
return this.stateID != null || this.stateID == null
&& other.stateID == null || this.stateID.equals(other.stateID);
}
@Override
public String toString() {
return "bookstore.entities.StateTax[ stateId=" + stateID + " ]";
}
}
The end product is supposed to be a drop down box that allows you to select one option in xhtml.
My xhtml portion (which is commented out for now):
<h:outputLabel for="stateOption" value="#{bundle.StateName}"/>
<h:selectOneMenu id="stateName"
required="true"
valueChangeListener="#{cashierBean.setTax}">
<f:selectItems value="#{cashierBean.stateNames}"
var="stateName">
</f:selectItems>
</h:selectOneMenu>
<h:message styleClass="error-message" for="stateOption"/>
So here's a part of the error I get on the SQL statement in my statetax file:
Exception Description: Problem compiling [SELECT t FROM StateTax t ORDER BY t.stateId].
My question: How do I properly get a list of names from a table?
java sql
asked Nov 19 '18 at 22:51
gatorade2131gatorade2131
105
Could you share all code for StateTax class
– Mykhailo Moskura
Nov 19 '18 at 23:13
@MykhailoMoskura I added it in.
– gatorade2131
Nov 19 '18 at 23:31
Exception Description: Problem compiling [SELECT t FROM StateTax t ORDER BY t.stateId Your exception says problem compiling because of field name which you are invoking in JPQL Actually as i see now it is stateID but was stateId
– Mykhailo Moskura
Nov 19 '18 at 23:37
It is now working fine or you are having different error?
– Mykhailo Moskura
Nov 19 '18 at 23:44
Possible duplicate of Nice way to select a tuple using JPA
– K.Nicholas
Nov 20 '18 at 1:21
add a comment |
1
1
1
so I have data in a table that's initialized on startup in my configbean.
The format is: String id, String name, Double rate
example: "1", "Alabama", .02
In my request bean, I have a function to get ONLY the names.
public List<String> getStateNames() {
List<String> results = em.createNamedQuery("getStateNames").getResultList();
results.sort(null);
return results;
}
Here's the base file StateTax
@Entity
@Table(name = "STATE_TAXES")
@NamedQueries({
/*@NamedQuery(
name = "getTaxRate",
query = "SELECT t FROM StateTax t WHERE t.stateName = :stateName"),*/
@NamedQuery(
name = "getStateNames",
query = "SELECT t FROM StateTax t ORDER BY t.stateID")
})
public class StateTax implements Serializable {
@Id
private String stateID;
private String stateName;
private double taxRate;
//supposed to lok like book.java
public StateTax() {
}
public StateTax(String id, String st, double tax) {
this.stateID = id;
this.stateName = st;
this.taxRate = tax;
}
public String getStateID() {
return stateID;
}
public void setStateID(String stateID) {
this.stateID = stateID;
}
public String getStateName() {
return stateName;
}
public void setStateName(String stateName) {
this.stateName = stateName;
}
public double getTaxRate() {
return taxRate;
}
public void setTaxRate(double taxRate) {
this.taxRate = taxRate;
}
public String getState() {
return stateName;
}
public void setState(String state) {
this.stateName = state;
}
@Override
public int hashCode() {
int hash = 0;
hash += (stateID != null ? stateID.hashCode() : 0);
return hash;
}
@Override
public boolean equals(Object object) {
if (!(object instanceof StateTax)) {
return false;
}
StateTax other = (StateTax) object;
return this.stateID != null || this.stateID == null
&& other.stateID == null || this.stateID.equals(other.stateID);
}
@Override
public String toString() {
return "bookstore.entities.StateTax[ stateId=" + stateID + " ]";
}
}
The end product is supposed to be a drop down box that allows you to select one option in xhtml.
My xhtml portion (which is commented out for now):
<h:outputLabel for="stateOption" value="#{bundle.StateName}"/>
<h:selectOneMenu id="stateName"
required="true"
valueChangeListener="#{cashierBean.setTax}">
<f:selectItems value="#{cashierBean.stateNames}"
var="stateName">
</f:selectItems>
</h:selectOneMenu>
<h:message styleClass="error-message" for="stateOption"/>
So here's a part of the error I get on the SQL statement in my statetax file:
Exception Description: Problem compiling [SELECT t FROM StateTax t ORDER BY t.stateId].
My question: How do I properly get a list of names from a table?
java sql
asked Nov 19 '18 at 22:51
gatorade2131gatorade2131
105
so I have data in a table that's initialized on startup in my configbean.
The format is: String id, String name, Double rate
example: "1", "Alabama", .02
In my request bean, I have a function to get ONLY the names.
public List<String> getStateNames() {
List<String> results = em.createNamedQuery("getStateNames").getResultList();
results.sort(null);
return results;
}
Here's the base file StateTax
@Entity
@Table(name = "STATE_TAXES")
@NamedQueries({
/*@NamedQuery(
name = "getTaxRate",
query = "SELECT t FROM StateTax t WHERE t.stateName = :stateName"),*/
@NamedQuery(
name = "getStateNames",
query = "SELECT t FROM StateTax t ORDER BY t.stateID")
})
public class StateTax implements Serializable {
@Id
private String stateID;
private String stateName;
private double taxRate;
//supposed to lok like book.java
public StateTax() {
}
public StateTax(String id, String st, double tax) {
this.stateID = id;
this.stateName = st;
this.taxRate = tax;
}
public String getStateID() {
return stateID;
}
public void setStateID(String stateID) {
this.stateID = stateID;
}
public String getStateName() {
return stateName;
}
public void setStateName(String stateName) {
this.stateName = stateName;
}
public double getTaxRate() {
return taxRate;
}
public void setTaxRate(double taxRate) {
this.taxRate = taxRate;
}
public String getState() {
return stateName;
}
public void setState(String state) {
this.stateName = state;
}
@Override
public int hashCode() {
int hash = 0;
hash += (stateID != null ? stateID.hashCode() : 0);
return hash;
}
@Override
public boolean equals(Object object) {
if (!(object instanceof StateTax)) {
return false;
}
StateTax other = (StateTax) object;
return this.stateID != null || this.stateID == null
&& other.stateID == null || this.stateID.equals(other.stateID);
}
@Override
public String toString() {
return "bookstore.entities.StateTax[ stateId=" + stateID + " ]";
}
}
The end product is supposed to be a drop down box that allows you to select one option in xhtml.
My xhtml portion (which is commented out for now):
<h:outputLabel for="stateOption" value="#{bundle.StateName}"/>
<h:selectOneMenu id="stateName"
required="true"
valueChangeListener="#{cashierBean.setTax}">
<f:selectItems value="#{cashierBean.stateNames}"
var="stateName">
</f:selectItems>
</h:selectOneMenu>
<h:message styleClass="error-message" for="stateOption"/>
So here's a part of the error I get on the SQL statement in my statetax file:
Exception Description: Problem compiling [SELECT t FROM StateTax t ORDER BY t.stateId].
My question: How do I properly get a list of names from a table?
java sql
java sql
asked Nov 19 '18 at 22:51
gatorade2131gatorade2131
105
asked Nov 19 '18 at 22:51
gatorade2131gatorade2131
105
edited Nov 19 '18 at 23:30
gatorade2131
asked Nov 19 '18 at 22:51
gatorade2131gatorade2131
105
asked Nov 19 '18 at 22:51
gatorade2131gatorade2131
105
asked Nov 19 '18 at 22:51
gatorade2131gatorade2131
105
105
Could you share all code for StateTax class
– Mykhailo Moskura
Nov 19 '18 at 23:13
@MykhailoMoskura I added it in.
– gatorade2131
Nov 19 '18 at 23:31
Exception Description: Problem compiling [SELECT t FROM StateTax t ORDER BY t.stateId Your exception says problem compiling because of field name which you are invoking in JPQL Actually as i see now it is stateID but was stateId
– Mykhailo Moskura
Nov 19 '18 at 23:37
It is now working fine or you are having different error?
– Mykhailo Moskura
Nov 19 '18 at 23:44
Possible duplicate of Nice way to select a tuple using JPA
– K.Nicholas
Nov 20 '18 at 1:21
add a comment |
Could you share all code for StateTax class
– Mykhailo Moskura
Nov 19 '18 at 23:13
@MykhailoMoskura I added it in.
– gatorade2131
Nov 19 '18 at 23:31
Exception Description: Problem compiling [SELECT t FROM StateTax t ORDER BY t.stateId Your exception says problem compiling because of field name which you are invoking in JPQL Actually as i see now it is stateID but was stateId
– Mykhailo Moskura
Nov 19 '18 at 23:37
It is now working fine or you are having different error?
– Mykhailo Moskura
Nov 19 '18 at 23:44
Possible duplicate of Nice way to select a tuple using JPA
– K.Nicholas
Nov 20 '18 at 1:21
Could you share all code for StateTax class
– Mykhailo Moskura
Nov 19 '18 at 23:13
Could you share all code for StateTax class
– Mykhailo Moskura
Nov 19 '18 at 23:13
@MykhailoMoskura I added it in.
– gatorade2131
Nov 19 '18 at 23:31
@MykhailoMoskura I added it in.
– gatorade2131
Nov 19 '18 at 23:31
Exception Description: Problem compiling [SELECT t FROM StateTax t ORDER BY t.stateId Your exception says problem compiling because of field name which you are invoking in JPQL Actually as i see now it is stateID but was stateId
– Mykhailo Moskura
Nov 19 '18 at 23:37
Exception Description: Problem compiling [SELECT t FROM StateTax t ORDER BY t.stateId Your exception says problem compiling because of field name which you are invoking in JPQL Actually as i see now it is stateID but was stateId
– Mykhailo Moskura
Nov 19 '18 at 23:37
It is now working fine or you are having different error?
– Mykhailo Moskura
Nov 19 '18 at 23:44
It is now working fine or you are having different error?
– Mykhailo Moskura
Nov 19 '18 at 23:44
Possible duplicate of Nice way to select a tuple using JPA
– K.Nicholas
Nov 20 '18 at 1:21
Possible duplicate of Nice way to select a tuple using JPA
– K.Nicholas
Nov 20 '18 at 1:21
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
});
}
});
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%2f53383795%2fjava-getting-data-from-a-database-with-an-sql-statement%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.
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%2f53383795%2fjava-getting-data-from-a-database-with-an-sql-statement%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
Could you share all code for StateTax class
– Mykhailo Moskura
Nov 19 '18 at 23:13
@MykhailoMoskura I added it in.
– gatorade2131
Nov 19 '18 at 23:31
Exception Description: Problem compiling [SELECT t FROM StateTax t ORDER BY t.stateId Your exception says problem compiling because of field name which you are invoking in JPQL Actually as i see now it is stateID but was stateId
– Mykhailo Moskura
Nov 19 '18 at 23:37
It is now working fine or you are having different error?
– Mykhailo Moskura
Nov 19 '18 at 23:44
Possible duplicate of Nice way to select a tuple using JPA
– K.Nicholas
Nov 20 '18 at 1:21