Jozo Stan

Hi,

I have an application developed in ggts with grails/groovy and there are users with different roles. I want to test if a user can access some parts of the application by directly inserting link into address bar. So, where is my problem? When I test my application on localhost, everything is OK. But when I want to test through http://myapp then it isn't OK. The application is the same.

Here is my code:

LoginSpec.groovy

import geb.spock.GebReportingSpec import spock.lang.* import pages.* @Stepwise class LoginSpec extends GebReportingSpec { def "opage"() { when: to LoginPage loginUser() acceptButton.click() then: to ProductPage } }


ProductPage.groovy

package pages import geb.Browser import grails.util.Holders class ProductPage extends ScaffoldPage { def config = org.codehaus.groovy.grails.commons.ConfigurationHolder.config static url = {config.grails.serverURL + "/shop/catalog/show/123"} static at = { waitFor { title ==~ /Products/ } title ==~ /Products/ } static content = { } }

config.grails.serverURL should be http://myapp.


When I start the test, it opens http://myapp/login, the user logs in and the home page opens. But then it stays on home page. It should go to http://myapp/shop/catalog/show/123 because I want to test if a user can access a product by directly inserting a link into address bar.

Please help, I don't have any more ideas.
Thanks.

Hello everyone!


I have a database table with sport matches. In my application users can choose which matches they want to follow by clicking on add in a data-tables table. I fetch matches from database with this method:

public List<Utakmica> fetchSveUtakmiceList(Date termin) { return getHibernateTemplate().find("FROM Utakmica WHERE DATE(termin) >= DATE(CURRENT_DATE)");


With that method I achieve that only new matches are shown to the user. Finished matches remain in database. For example, if there are 10 matches. 4 are finished. Number of matches is still 10 but I fetch in my list only 6. When user wants to add a match with ID >=6, application crashes and the java.lang.IndexOutOfBoundsException appears. If I remove the WHERE part of query, then I don't receive this exception.


Here is my code:

Controller index.java

@Controller public class Index { @ModelAttribute("listaUtakmica") public List<Utakmica> getListaUtakmica() { return new ArrayList<Utakmica>(); } @ModelAttribute("listaOdabranihUtakmica") //choosen matches public List<Utakmica> getListaOdabranihUtakmica() { return new ArrayList<Utakmica>(); } @Autowired private SportService sportService; private String username; private Integer userID; private Date termin; @RequestMapping(value="/index.html", method=RequestMethod.GET) public String dohvatiUtakmicu(Model model, Principal principal) { List<Utakmica> listaOdabranihUtakmica=new ArrayList<Utakmica>(); username = principal.getName(); userID = sportService.getUserID(username); model.addAttribute("korisnik",username); List<Utakmica> tmpLista=new ArrayList<Utakmica>(); tmpLista= sportService.fetchSveUtakmiceList(termin); model.addAttribute("listaUtakmica", tmpLista); List<OdabraneUtakmice> bazaLista=new ArrayList<>(); bazaLista= sportService.fetchSveOdabraneUtakmice(userID); for(OdabraneUtakmice odabraneUtakmice: bazaLista){ for(Utakmica utakmica: tmpLista){ if((odabraneUtakmice.getUtakmica().getUtakmica_id() == utakmica.getUtakmica_id())){ listaOdabranihUtakmica.add(utakmica); } } } model.addAttribute("listaOdabranihUtakmica",listaOdabranihUtakmica); return "index"; } @RequestMapping(value="/index.html", method=RequestMethod.POST) public String izbor(Model model,@ModelAttribute("listaOdabranihUtakmica") List<Utakmica> listaOdabranihUtakmica, @ModelAttribute("listaUtakmica") List<Utakmica> tmpLista,@RequestParam("idOdabirUtakmice") String idOdabraneUtakmiceString) { //idOdabirUtakmice = id of the choosen match Long idOdabraneUtakmice=Long.parseLong(idOdabraneUtakmiceString); if (listaOdabranihUtakmica.contains(tmpLista.get((int) (idOdabraneUtakmice-1)))){ listaOdabranihUtakmica.remove(tmpLista.get((int) (idOdabraneUtakmice-1))); } else { listaOdabranihUtakmica.add(tmpLista.get((int) (idOdabraneUtakmice-1))); } model.addAttribute("listaOdabranihUtakmica",listaOdabranihUtakmica); return "index"; }


How could I solve this exception?

Thanks.
Jozo

I have finally solved this. Thank you all!

Here is my code:

Method from HibernateDAO

public List<Utakmica> dohvatiUtakmicuPremaID(String utakmica_id) { return getHibernateTemplate().findByNamedParam( "from Utakmica where utakmica_id = :trazenId", "trazenId", Long.parseLong(utakmica_id)); }



Controller

@Controller public class DohUtakmica { @ModelAttribute("mojaUtList") public List<Utakmica> getUtakmicaList() { return new ArrayList<Utakmica>(); } @Autowired public SportService sportService; @RequestMapping(value = "/dohUtakmica.html", method = RequestMethod.GET) public String redirect(@RequestParam("id") String broj, Model model){ List<Utakmica> tempLista=new ArrayList<Utakmica>(); tempLista=sportService.dohvatiUtakmicuPremaID(broj); model.addAttribute("mojaUtList", tempLista); model.addAttribute("utakmica", new Utakmica()); return "dohUtakmica"; } @RequestMapping(value="/dohUtakmica.html", method=RequestMethod.POST) public String redi(Model model){ return "dohUtakmica"; } }



Part of jsp

<table cellpadding="5" cellspacing="0" border="3" class="display" id="coolTablica" width="100%" style="border-color: blue;"> <thead> <tr> <th> <fmt:message key="odabirSport.domacin"/> </th> <th> <fmt:message key="odabirSport.gost"/> </th> <th> <fmt:message key="odabirSport.rez"/> </th> </tr> </thead> <tbody> <c:forEach var="utakmica" items="${mojaUtList}"> <tr> <td><c:out value="${utakmica.domacin.nazivTeama}"/></td> <td><c:out value="${utakmica.gost.nazivTeama}"/></td> <td><c:out value="${utakmica.rezultat}"/></td> </tr> </c:forEach> </tbody> </table>

I have a sport database with country, sport, team and match tables. I'm developing a web application in Spring where users could discuss about match results, view statistics and so on.
Well, I'm stuck with head2head statistics. I have two dropdown boxes with teams. User selects host and guest. When he clicks on show, controller should fetch all the matches where the selected teams have played against each other. The results should display on the same page. Unfortunately, this isn't happening.

Here is my code.

Fetch method in HibernateDAO domacin = host, gost = guest

@SuppressWarnings("unchecked") @Override public List<Utakmica> fetchH2H(String domacin, String gost) { return getHibernateTemplate().find("from Utakmica WHERE ((domacin =?) and (gost =?))", domacin, gost); }



H2Hstat.java

@Controller public class H2Hstat { @ModelAttribute("teamList") public List<Team> getTeamList() { return new ArrayList<Team>(); } @ModelAttribute("listaUniqUtakmica") public List<Utakmica> getListaUniqUtakmica() { return new ArrayList<Utakmica>(); } @Autowired public SportService sportService; private String domacin; private String gost; @RequestMapping(value = "/h2Hstat.html", method = RequestMethod.GET) public String redirect(Model model){ List<Team> tmLista=new ArrayList<Team>(); tmLista=sportService.fetchSveTeamList(); model.addAttribute("teamList", tmLista); List<Utakmica> uLista=new ArrayList<Utakmica>(); uLista=sportService.fetchH2H(domacin, gost); model.addAttribute("listaUniqUtakmica", uLista); model.addAttribute("utakmica", new Utakmica()); return "h2Hstat"; } @RequestMapping(value="/h2Hstat.html", method=RequestMethod.POST) public String izbor(@ModelAttribute Team team, @ModelAttribute Utakmica utakmica, @ModelAttribute("listaUniqUtakmica") List<Utakmica> uLista, @ModelAttribute("teamList") List<Team> tmLista, BindingResult results, Model model) { if(results.hasErrors()) { return "h2Hstat"; } sportService.fetchH2H(domacin, gost); return "h2Hstat"; } }


h2Hstat.jsp

<table cellpadding="5" cellspacing="0" border="3" class="display" id="coolTablica" width="100%"> <thead> <tr> <th>ID</th> <th> <fmt:message key="odabirSport.naziv"/> </th> <th> <fmt:message key="odabirSport.drzava"/> </th> <th> <fmt:message key="odabirSport.domacin"/> </th> <th> <fmt:message key="odabirSport.gost"/> </th> <th> <fmt:message key="odabirSport.termin"/> </th> <th> <fmt:message key="odabirSport.rez"/> </th> </tr> </thead> <tbody> <c:forEach var="utakmica" items="${listaUniqUtakmica}"> <tr> <td> <a href='dohUtakmica.html?id=${utakmica.utakmica_id}'><fmt:message key="tablica.detalji"/><c:out value="${utakmica.utakmica_id}"/></a> </td> <td> <c:out value="${utakmica.sport.nazivSporta}"/> </td> <td> <c:out value="${utakmica.drzava.imeDrzave}"/> </td> <td> <c:out value="${utakmica.domacin.nazivTeama}"/> </td> <td> <c:out value="${utakmica.gost.nazivTeama}"/> </td> <td><fmt:formatDate pattern="dd.MM.yyyy HH:mm" value="${utakmica.termin}"/></td> <td> <c:out value="${utakmica.rezultat}"/> </td> </tr> </c:forEach> </tbody> </table> <form:form action="h2Hstat.html?locale=${param.locale}" method="POST" modelAttribute="utakmica" > <table cellpadding="5" border="3" width="20%" style="border-color: blue;"> <thead> <tr> <th> <font style="font-family: Arial; color: blue;"><fmt:message key="novaUt.dom" /></font> </th> <td> <form:select path=""> <form:option value="-" label="--" /> <form:options items="${teamList}" itemValue="team_id" itemLabel="nazivTeama" /> </form:select> </td> </tr> <tr> <th> <font style="font-family: Arial; color: blue;"><fmt:message key="novaUt.gost" /></font> </th> <td> <form:select path=""> <form:option value="-" label="--" /> <form:options items="${teamList}" itemValue="team_id" itemLabel="nazivTeama" /> </form:select> </td> </tr> </thead> </table> <br/> <input type="submit" name="submit" value="<fmt:message key="noviSp.pokazi" />"> </form:form>


Is this actually possible to achieve on the same page? When I submit the form I get empty table.

Please help.

Thank you very much! I solved that issue. I couldn't post before because I still have other problems with my application.

This is part of my HibernateDAO

@Override public List<Utakmica> dohvatiUniq(String utakmica_id) { return getHibernateTemplate().find("from Utakmica WHERE utakmica_id =?", utakmica_id); }


Controller DohUtakmica.java

@Controller

public class DohUtakmica { @ModelAttribute("mojaUtList") public List<Utakmica> getUtakmicaList() { return new ArrayList<Utakmica>(); } @Autowired public SportService sportService; String utakmica_id; @RequestMapping(value = "/dohUtakmica.html", method = RequestMethod.GET) public String redirect(Model model){ List<Utakmica> tempLista=new ArrayList<Utakmica>(); tempLista=sportService.dohvatiUniq(utakmica_id); model.addAttribute("mojaUtList", tempLista); model.addAttribute("utakmica", new Utakmica()); return "dohUtakmica"; } @RequestMapping(value="/dohUtakmica.html", method=RequestMethod.POST) public String redi(@ModelAttribute Utakmica utakmica, @ModelAttribute("mojaUtList") List<Utakmica> tempLista, @RequestParam("id") String idOdabraneUtakmiceString, BindingResult results, Model model){ Integer idOdabraneUtakmice=Integer.parseInt(idOdabraneUtakmiceString); if (results.hasErrors()) { return "index"; } sportService.dohvatiUtakmicuPremaID("idOdabraneUtakmice"); model.addAttribute("utakmica", utakmica); return "dohUtakmica"; } }

I think that my code in POST method isn't correct...

This is a part of my dohUtakmica.jsp


<table cellpadding="5" cellspacing="0" border="3" class="display" id="coolTablica" width="100%" style="border-color: blue;"> <thead> <tr> <th> <fmt:message key="odabirSport.domacin"/> </th> <th> <fmt:message key="odabirSport.gost"/> </th> <th> <fmt:message key="odabirSport.rez"/> </th> </tr> </thead> <tbody> <c:forEach var="utakmica" items="${listaUtakmica}"> <tr> <td><c:out value="${utakmica.domacin.nazivTeama}"/></td> <td><c:out value="${utakmica.gost.nazivTeama}"/></td> <td><c:out value="${utakmica.rezultat}"/></td> </tr> </c:forEach> </tbody> </table>

In listaUtakmica I fetch all the matches from database.

With this code i receive:



Uploaded with ImageShack.us

and the url was http://localhost:8909/SportInfo/dohUtakmica.html?id=9

In database the match between Federer and Nadal has id 9. I know that with this code I won't achieve what I want. The problem is that I don't know how to fetch only this particular match.

I hope that the answer isn't fetching from database directly from jsp file because that is against the MVC rules.

Any help is appreciate.
Thank you.

jatan bhavsar wrote:Hi Jojo,

I receive all matches from database on the new page

Have you try to fetch the data which matches with the id only? You are passing the id in the method so you can retrieve records based on that id and then display on the page.

Regards
Jatan

Exactly that is what I want to achieve. I want to fetch only the match whose ID I have in the url.

Hello everybody!


I have a table with sport events. Table is populated from database.



Uploaded with ImageShack.us



When I click on detalji (details) it should open a new page with details about the match. Result prediction, users comments and so on.

I send the ID of the match through GET method http://localhost:8909/SportInfo/dohUtakmica.html?id=1.

The problem is that I receive all matches from database on the new page, but I only want the match that has the ID I sent through GET method.

I hope You understand what I want.

With the next code I receive empty table.

Here is my code:

Controller DohUtakmica.java

@Controller public class DohUtakmica { @Autowired public SportService sportService; @RequestMapping(value = "/dohUtakmica.html", method = RequestMethod.GET) public String redirect(Model model){ model.addAttribute("utakmica", new Utakmica()); return "dohUtakmica"; } @RequestMapping(value="/dohUtakmica.html", method=RequestMethod.POST) public String redi(@ModelAttribute() Utakmica utakmica, BindingResult results, Model model){ if (results.hasErrors()) { return "index"; } sportService.dohvatiUtakmicuPremaID("utakmica_id"); model.addAttribute("utakmica", utakmica); return "dohUtakmica"; }



Method for fetching ID from DAOimpl

@Override public Utakmica dohvatiUtakmicuPremaID(String utakmica_id) { Utakmica odabrana = (Utakmica) getHibernateTemplate().findByNamedParam( "from Utakmica where utakmica_id = :trazenId", "trazenId", Integer.parseInt(utakmica_id)).get(0); return odabrana; }



dohUtakmica.jsp

<table cellpadding="5" cellspacing="0" border="3" class="display" id="coolTablica" width="100%" style="border-color: blue;">
<thead>
<tr>


<th> <fmt:message key="odabirSport.domacin"/> </th>
<th> <fmt:message key="odabirSport.gost"/> </th>
<th> <fmt:message key="odabirSport.rez"/> </th>
</tr>

</thead>

<tbody>

<%
String utakmica_id = request.getParameter("id");
%>
<c:if test = "${param.name != null}">

<c:if test="${listaUtakmica.contains(utakmica.utakmica_id) == true}">

<tr>
<td><c:out value="${utakmica.domacin.nazivTeama}"/></td>
<td><c:out value="${utakmica.gost.nazivTeama}"/></td>
<td><c:out value="${utakmica.rezultat}"/></td>
</tr>


</tbody>

</table>


I hope that someone could give me an advice.

Thanks in advance!

Hello everybody!

I have a form in which I select sport and country with dropdown list and there is also a text box where i write a name for the new team. When I click on save I receive this exception:

SEVERE: Servlet.service() for servlet [springDispatcher] in context with path [/SportInfo] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not insert: [hr.tvz.java.web.aplikacije.spring.info.Team]; SQL [insert into sportBazaPodataka.TEAM (BODOVI, DRZAVA_ID, TEAM_NAME, ODIGSUSRETI, SPORT_ID) values (?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [hr.tvz.java.web.aplikacije.spring.info.Team]] with root cause com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'drzava_id' cannot be null

Here is my code:

Team.java
Entity @Table(name="sportBazaPodataka.TEAM") public class Team implements Serializable{ /** * */ private static final long serialVersionUID = -2115704043446819823L; public Team() {} @Id @Column(name = "TEAM_ID") @GeneratedValue private int team_id; @Column(name = "TEAM_NAME") private String nazivTeama; @ManyToOne @JoinColumn(name = "SPORT_ID") private Sport sport; @ManyToOne @JoinColumn(name = "DRZAVA_ID") private Drzava drzava; @Column(name = "BODOVI") private int bodovi; @Column(name = "ODIGSUSRETI") private int odigSus; public int getTeam_id() { return team_id; } public void setTeam_id(int team_id) { this.team_id = team_id; } public String getNazivTeama() { return nazivTeama; } public void setNazivTeama(String nazivTeama) { this.nazivTeama = nazivTeama; } public Sport getSport() { return sport; } public void setSport(Sport sport) { this.sport = sport; } public Drzava getDrzava() { return drzava; } public void setDrzava(Drzava drzava) { this.drzava = drzava; } public int getBodovi() { return bodovi; } public void setBodovi(int bodovi) { this.bodovi = bodovi; } public int getOdigSus() { return odigSus; } public void setOdigSus(int odigSus) { this.odigSus = odigSus; } }

NewTeam controller

@Controller public class NoviTeam { @Autowired public SportService sportService; @ModelAttribute("sportList") public List<Sport> getSportList() { return new ArrayList<Sport>(); } @ModelAttribute("drzavaList") public List<Drzava> getDrzavaList() { return new ArrayList<Drzava>(); } @RequestMapping(value = "/noviTeam.html", method = RequestMethod.GET) public String redirect (Model model){ List<Sport> spLista=new ArrayList<Sport>(); spLista=sportService.fetchSveSportoveList(); model.addAttribute("sportList", spLista); List<Drzava> drLista=new ArrayList<Drzava>(); drLista=sportService.fetchSveDrzaveList(); model.addAttribute("drzavaList", drLista); model.addAttribute("team", new Team()); return "noviTeam"; } @RequestMapping(value="/noviTeam.html", method=RequestMethod.POST) public String adminInsert(@Valid @ModelAttribute Team team, @ModelAttribute("sportList") List<Sport> spLista, @ModelAttribute("drzavaList") List<Drzava> drLista, BindingResult results, Model model) { if(results.hasErrors()) { return "noviTeam"; } sportService.insertNewTeam(team); model.addAttribute("team", new Team()); model.addAttribute("uneseno", "Podaci su uspješno uneseni."); return "index"; } }


Part of NewTeam.jsp
<form:form action="noviTeam.html?locale=${param.locale}" method="POST" commandName="team" > <table cellpadding="5" border="3" width="20%" style="border-color: blue;"> <thead> <tr> <th> <font style="font-family: Arial; color: blue;">Sport</font> </th> <td> <form:select path="sport.nazivSporta"> <form:options items="${sportList}" itemLabel="nazivSporta" itemValue="sport_id" /> </form:select> </td> </tr> <tr> <th> <font style="font-family: Arial; color: blue;"><fmt:message key="odabirSport.drzava"/></font> </th> <td> <spring:bind path="drzava.imeDrzave"> <select name="drzava.imeDrzave"> <c:forEach items='${drzavaList}' var='drzava'> <option value="${drzava.drzava_id}">${drzava.imeDrzave}</option> </c:forEach> </select> </spring:bind> </td> </tr> <tr> <th><font style="font-family: Arial; color: blue;"><fmt:message key="team.nova"/> </font></th> <td> <form:input path="nazivTeama" type="text" SIZE="20" maxlength="30" /> <br /> <form:errors path="nazivTeama" style="color:red" /> </td> </tr> </thead> </table> <br/> <input type="submit" name="submit" value="<fmt:message key="noviSp.spremi" />"> </form:form>


I tried to find the cause of the error in debug mode and here is what I received.



Sport_id is 0 and drzava_id is 0 and I don't understand why. I'm out of ideas, please help.

Thanks for your advices .

This are parts of my code files:

SportRepositoryDAO.java

public interface SportRepositoryDAO { public void insertNewSport(Sport sport); public void insertNewDrzava(Drzava drzava); }


SportRepositoryDAOHibernate.java

public class SportRepositoryDAOHibernate extends HibernateDaoSupport implements SportRepositoryDAO{ @Override public void insertNewSport(Sport sport) { getHibernateTemplate().save(sport); } @Override public void insertNewDrzava(Drzava drzava) { getHibernateTemplate().save(drzava); } }


SportService.java

public interface SportService { @Secured(value = "ROLE_ADMIN") public void insertNewSport(Sport sport); @Secured(value = "ROLE_ADMIN") public void insertNewDrzava(Drzava drzava); }


SportServiceImpl.java


@Service public class SportServiceImpl implements SportService{ @Override public void insertNewSport(Sport sport) { sportRepositoryDAO.insertNewSport(sport); } @Override public void insertNewDrzava(Drzava drzava) { sportRepositoryDAO.insertNewDrzava(drzava); } }


About the persistence/DB stuff in my JSP. Unfortunately, I didn't know if there exists another way to populate my drop down box. I found this on the web.

Hello everybody!

I have a problem with hibernate exception when i want to insert data to db. This is a part of STS trace.

SEVERE: Servlet.service() for servlet [springDispatcher] in context with path [/SportInfo] threw exception [Request processing failed; nested exception is org.springframework.orm.hibernate3.HibernateSystemException: could not set a field value by reflection setter of hr.tvz.java.web.aplikacije.spring.info.Sport.sport_id; nested exception is org.hibernate.PropertyAccessException: could not set a field value by reflection setter of hr.tvz.java.web.aplikacije.spring.info.Sport.sport_id] with root cause java.lang.IllegalArgumentException: Can not set int field hr.tvz.java.web.aplikacije.spring.info.Sport.sport_id to org.hibernate.id.IdentifierGeneratorHelper$2 at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(Unknown Source) at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(Unknown Source) at sun.reflect.UnsafeIntegerFieldAccessorImpl.set(Unknown Source) at java.lang.reflect.Field.set(Unknown Source) at org.hibernate.property.DirectPropertyAccessor$DirectSetter.set(DirectPropertyAccessor.java:139) at org.hibernate.mapping.Component$ValueGenerationPlan.execute(Component.java:439) at org.hibernate.id.CompositeNestedGeneratedValueGenerator.generate(CompositeNestedGeneratedValueGenerator.java:122) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:121) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210) at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195) at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93) at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713) at org.hibernate.impl.SessionImpl.save(SessionImpl.java:701) at org.hibernate.impl.SessionImpl.save(SessionImpl.java:697) at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:686) at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:1) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:683) at hr.tvz.java.web.aplikacije.spring.dao.SportRepositoryDAOHibernate.insertNewSport(SportRepositoryDAOHibernate.java:48) at hr.tvz.java.web.aplikacije.spring.service.SportServiceImpl.insertNewSport(SportServiceImpl.java:36) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) . . .


Java code:

@Controller public class NoviSport { @Autowired public SportService sportService; @RequestMapping(value = "/noviSport.html", method = RequestMethod.GET) public String redirect (Model model){ model.addAttribute("sport", new Sport()); return "noviSport"; } @RequestMapping(value="/noviSport.html", method=RequestMethod.POST) public String adminInsert(@Valid @ModelAttribute Sport sport, BindingResult results, Model model) { /*if(results.hasErrors()) { return "noviSport"; }*/ sportService.insertNewSport(sport); model.addAttribute("sport", new Sport()); model.addAttribute("uneseno", "Podaci su uspješno uneseni."); return "index"; } }


Sport.java

@Entity @Table(name="sportBazaPodataka.SPORT") public class Sport implements Serializable{ /** * */ private static final long serialVersionUID = 7753003120604201087L; public Sport() {} @Id @Column(name = "SPORT_ID") @GeneratedValue private int sport_id; @Column(name = "SPORT_NAZIV") @NotNull @Size(min=3, max=30, message="Duljina teksta mora biti između 3 i 20.") private String nazivSporta; public int getSport_id() { return sport_id; } public void setSport_id(int sport_id) { this.sport_id = sport_id; } public String getNazivSporta() { return nazivSporta; } public void setNazivSporta(String nazivSporta) { this.nazivSporta = nazivSporta; } @Id @ManyToOne @JoinColumn(name = "DRZAVA_ID") private Drzava drzava; public Drzava getDrzava() { return drzava; } public void setDrzava(Drzava drzava) { this.drzava = drzava; }

Drzava means Country.


And the part of jsp

<form:form id="sport" action="noviSport.html?locale=${param.locale}" method="POST" commandName="sport" > <table cellpadding="5" border="3" width="20%" style="border-color: blue;"> <thead> <tr> <th> <font style="font-family: Arial; color: blue;"><fmt:message key="odabirSport.drzava"/></font> </th> <td><% Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/sportBazaPodataka","root","admin"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from Drzava");%> <form:select path="drzava"> <%while(rs.next()){%> <form:option value='<%=rs.getInt("drzava_id")%>' label='<%=rs.getString("drzava")%>'/> <%} %> </form:select> </td> </tr> <tr> <th><font style="font-family: Arial; color: blue;"><fmt:message key="noviSp.naziv"/> </font></th> <td> <form:input path="nazivSporta" type="text" SIZE="20" maxlength="30" /> <br /> <form:errors path="nazivSporta" style="color:red" /> </td> </tr> </thead> </table> <br/> <input type="submit" name="submit" value="<fmt:message key="noviSp.spremi" />"> </form:form>


When I start the web application and open the page for inserting new Sport for a country, I choose a country and then i write for example basketball. Then I press submit and the exception is there. In db the sport ID is not NULL and I don't know where is the mistake. I've also found this http://blogs.warwick.ac.uk/colinyates/entry/i_hate_hibernate/ but I don't have such a mistake.

Please help.
Thanks in advance!
Jozo

Edited line length on the stack trace to prevent horizontal scroll bars. - Bill