[EJB 3.0] - @Column Annotation doesn't seem to work...
by EricChile
It seems the @Column annotation doesn't work for some reason?
using
jboss-4.0.5.GA
EJB 3.0
|
| @Entity
| @NamedQueries({
| @NamedQuery(name = "SdsDataLoadPat.findAll", query = "select o from SdsDataLoadPat o"),
| @NamedQuery(name = "SdsDataLoadPat.findAllbyId", query = "select o from SdsDataLoadPat as o WHERE o.loadSeqNo = :loadSeqNo AND o.setId = :setId")
| })
| @Table(name = "SDS_DATA_LOAD_PAT")
| @IdClass(SdsDataLoadPatPK.class)
| public class SdsDataLoadPat implements Serializable {
| @Column(name="ADDRESS_CITY")
| private String addressCity;
|
| .....
|
| @Id
| @Column(name="LOAD_SEQ_NO", nullable = false)
| private Long loadSeqNo;
|
| @Id
| @Column(name="SET_ID", nullable = false)
| private Long setId;
|
| private String ssn;
| @Column(name="STATUS_CODE")
| private String statusCode;
| private String suffix;
|
| }
|
|
|
This is the sql shown from the DEBUG
|
| 2007-03-26 08:16:05,643 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select sdsdataloa0_.loadSeqNo as loadSeqNo24_,
| .............
| sdsdataloa0_.USIIS_ID as USIIS67_24_ from SDS_DATA_LOAD_PAT sdsdataloa0_ where sdsdataloa0_.loadSeqNo=? and sdsdataloa0_.setId=?]
|
|
The sql is being translated using the field name, not the @column name. (sdsdataloa0_.loadSeqNo=? and sdsdataloa0_.setId=?)
Anyone have a clue why?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4031605#4031605
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4031605
19Â years
[Security & JAAS/JBoss] - <web-resource-name> in web.xml
by karstenausberlin
Hello,
let me take as example the JAAS-config of web-console. In the file web.xml there's a block of code:
| <security-constraint>
| <web-resource-collection>
| <web-resource-name>HtmlAdaptor</web-resource-name>
| <description>An example security config that only allows users with the role JBossAdmin to access the HTML JMX console web application</descript
| ion>
| <url-pattern>/*</url-pattern>
| <http-method>GET</http-method>
| <http-method>POST</http-method>
| </web-resource-collection>
| <auth-constraint>
| <role-name>JBossAdmin</role-name>
| </auth-constraint>
| </security-constraint>
|
My question: What is the <web-resource-name>, in this case above HtmlAdaptor? Can I insert here whatever I want or is it a reference to a setting in an other config?
Regards from Berlin
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4031602#4031602
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4031602
19Â years
[JBoss jBPM] - Re: jBPM : Couldn't be that complicated...
by viniciuscarvalho
Hello kukeltje, the error is that the TASKINSTANCE table is missing the version column. After running the scripts from mysql it throws a lot of errors (did not see the first time, had verbose off). I don't know if it is a mysql issue (found a lot of references about errors when dropping FKs on mysql.)
For instance the following SQL throws an error:
alter table JBPM_ACTION drop foreign key FK_ACTION_EVENT
| Error: java.sql.SQLException: Error on rename of '.\jbpmdb\jbpm_action' to '.\jbpmdb\#sql2-7e0-10' (errno: 152), SQL State: HY000, Error Code: 1025
|
I'll try something different this time, I'll try to replace the new modified tables inside the build script of the starters kit.
I'm also trying a new approach (switching to oralce ;P)
Regards
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4031601#4031601
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4031601
19Â years