kumar shiva

am new to Hibernate Criteria, please help me

am creating a Member pojo class, in this class this Member class is having two foreign ke ys businessunitid(Many to one relation), role_id(one to one relation) of classes BusinessUnit, Role respectively.(role,businessunit are references of Role,BusinessUnit respectively)



crit = hibsession.createCriteria(Member.class)
.createCriteria("role")
.add(Restrictions.eq("role_id",role_id));
this statement working fine but

Below statement giving Hibernate Exception:
crit = hibsession.createCriteria(Member.class)
.createCriteria("businessunit ")
.add(Restrictions.eq("businessunitid",businessunitid));

Prasad Krishnegowda wrote:where is this attribute set?

It might be the case that, on login failure userToken is set in session, since its not null, authorized becomes true, now, since authorized its true, path variable is not set properly..

Thanks Prasad.
It's working fine when i set the
session.setAttribute("path",null);
in login.java after line number 75

Thanks Javaranch

Prasad Krishnegowda wrote:Your code needs lot of refactoring, first accessing database from Servlets, a strict no no..
It would help if you learn Spring Security, take a look at it once..

However, is the session attribute path set properly? Did you try printing it, what's the result you got.?

Thanks for the advice,
But i'm new to Servlets.

Session attribute path is fine

Prasad Krishnegowda wrote:When login is successful, you create a new session or get an existing session? If you get an existing session, on login failure what are you setting in session, is this variable cleared on successful login?

Hi Prasad,


this is my code.
AuthenticationFilter.java

import java.io.IOException; import javax.servlet.Filter; import javax.servlet.FilterChain; import javax.servlet.FilterConfig; import javax.servlet.ServletContext; import javax.servlet.ServletException; import javax.servlet.ServletRequest; import javax.servlet.ServletResponse; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpSession public class AuthenticationFilter implements Filter { FilterConfig mfilterConfig; public void init(FilterConfig filterConfig) throws ServletException { mfilterConfig = filterConfig; } public void doFilter(ServletRequest request, ServletResponse response,FilterChain chain) { //System.out.println("Authentication: Request received ..."); try { HttpSession session = ((HttpServletRequest) request).getSession(); //boolean sessionExist = false; boolean authorized = false; if (request instanceof HttpServletRequest) { if (session != null) { //sessionExist = true; String token = (String) session.getAttribute("userToken"); //System.out.println("Authentication: in session ..."); String uri = ((HttpServletRequest) request).getRequestURI(); //System.out.println(uri); if ( uri.contains("/images/") || uri.contains("/auth/")|| uri.contains("/js/")) // ALLOW IMAGES AND CSS TO { authorized = true; } else if (token != null) { authorized = true; } } else { ((HttpServletRequest) request).getSession().invalidate(); } } if (authorized) { chain.doFilter(request, response); } else if (mfilterConfig != null) { ServletContext context = mfilterConfig.getServletContext(); String uri = ((HttpServletRequest) request).getRequestURI(); String qstring = ((HttpServletRequest) request).getQueryString(); if(qstring==null){ session.setAttribute("path", uri); }else{ String uriquery = uri+"?"+qstring ; session.setAttribute("path", uriquery); System.out.println(session.getAttribute("path")); } //String Server_URL=context.getInitParameter("Server_URL"); context.getRequestDispatcher("/auth/login.jsp").forward(request,response); } else { throw new ServletException( "Unauthorized access, unable to forward to login page"); } } catch (IOException io) { System.out.println("IOException raised in AuthenticationFilter"); } catch (ServletException se) { se.printStackTrace(); System.out.println("ServletException raised in AuthenticationFilter"); } //System.out.print("Authentication: Response dispatched ..."); } public void destroy() { } }

and Login.java


import java.io.IOException; import java.io.PrintWriter; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.ServletContext; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import com.mysql.jdbc.Connection; import com.mysql.jdbc.Statement; /** * Servlet implementation class Login */ @WebServlet("/Login") public class Login extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public Login() { super(); } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String userName = request.getParameter("uname"); String password = request.getParameter("pword"); ServletContext sc = getServletContext(); String Server_URL=sc.getInitParameter("Server_URL"); HttpSession session = request.getSession(); String drivername = "com.mysql.jdbc.Driver"; Connection connection = null; Statement statement=null; String CONNECTION_URL="jdbc:mysql://"+"localhost"+":"+3306+"/antdb"; try{ Class.forName(drivername); connection = (Connection) DriverManager.getConnection(CONNECTION_URL,"shiva","kumar"); statement = (Statement) connection.createStatement(); // sql query String query = "select id from login WHERE username = '"+userName+"' and password = '"+password+"'"; ResultSet result = statement.executeQuery(query); if(!result.next()){ session.setAttribute("msg", "Login failed"); response.sendRedirect(Server_URL+"/login.jsp"); }else{ session.setAttribute("msg", "LoginSuccessful,welcome "+userName); session.setAttribute("userToken", userName); String path = (String)session.getAttribute("path"); if(path!=null){ response.sendRedirect(path); } else{ response.sendRedirect(Server_URL+"/school.jsp"); } } }//end of try block catch (Exception e) { e.printStackTrace(); } finally { try{ connection.close(); statement.close(); } catch(Exception e) { e.printStackTrace(); } } } }



please help me.

Thanks.

Hi,
can any one could help me!!!

I am developing a login web project using servlets, filters and am using sesseions for login and logout.
my problem is when enter correct username and poss word works fine, but when user enters wrong credentials giving login failed , next if he enters correct credentials also giving Login failed.
if clears the Browser history again login with correct credentilas worksfine.

Thanks

nitss bhavsar wrote:hello Jeanne,
First of all thanks for your immediate reply..
1.what i want it to do-
a.first student should enter his/her details(like name,age,address,city,state..etc)
b.scores of previous years(like 10th,12th,CET,diploma(second year direct admission)).
c.should have three branches(engineering IT,Comps,Electronics)
d.cut off for each branch.
e.should have all the required documents for admission.
f.it should be offline.
g.if student satisfy all the criteria then he is valid candidate for admit.

2.what i want to have in database
a.i need to use jdbc (Oracle db)
b.database should have details of the valid candidate who is eligible to admit.
c.his/her name,branch selected,scores,all documents are there.etc

3.Screens should be like (not exactly like this but somewhat..but it should be offline and need to use swing for UI)

https://www.elbowspace.com/FRHformexample18.htm


thanks,

Hello Bhavsar,

I think you better to use Swing concept JFrame for frame,for text field(name,age,address,city,state,scores of previous years) JTextfields, JTextarea
after all this in a frame create a Submit button to to store the details in DB.
create radio buttons for Branches in another frame.

Create a table, student details in DB, and connect it with JDBC code.


Shiva.

Hi,

In my project i need to add a JScrollPane to the JTable.

1st process:
In this process am adding JTable to the panel and Jpanel to the frame, i am getting the the table as like setting Boumds.
my requirement is when large data displays i need scrollpane.

so i am using 2nd process

2nd process
In this process am using JScrollpane, am adding JTable to the JscrollPane, JscrollPane to thr Jpanel and Jpanel to the frame.
In this one am getting the result but Table is very less compare to the table in 1st process.

3rd process:
In this one am adding table to the panel, panel to the JScrollpane and JScrollpane to the frame.
by using this process am not getting table on frame.

Any one could you help me.

Thanks,
Shiva

Hello,

Could any one please tell me how to set the Size of the JTable.(to increase the size of the Table).

Thanks,
Shiva

Thank you very much Mr.Jain

Why compile error occurs at a1 object creation(2nd line)

public class Example {
Example a1= new Example();
public static void main(String args[]){
Example a2 =new Example();
}
}

Thank you very much Mr.Bear Bibeault.

Please can anyone help me?

I created application folder app1 inthat WEB-INF -->Classes and web.xml
In Classes Servlet1.java as below

package pack1; import javax.servlet.*; import java.io.*; public class Servlet1 extends GenericServlet{ public void service(ServletRequest request,ServletResponse response) throws IOException{ response.setContentType("text/HTML"); PrintWriter pw= response.getWriter(); pw.println("<HTML>"); pw.println("<BODY>"); pw.println("<h1> Hi "); pw.println("</BODY >"); pw.println("</HTML>"); pw.flush(); pw.close(); } }
web.xml script like below

<web-app> <servlet> <servlet-name>serv1</servlet-name> <servlet-class>pack1.Servlet1</servlet-class> </servlet> <servlet-mapping> <servlet-name>serv1</servlet-name> <url-pattern>/s1</url-pattern> </servlet-mapping> </web-app>
Compiled sucessfully but when i entered address(http://localhost:8081/app1/s1) in address bar it is giving below message


type Exception report

message Error instantiating servlet class pack1.Servlet1

description The server encountered an internal error (Error instantiating servlet class pack1.Servlet1) that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Error instantiating servlet class pack1.Servlet1..
...........................................................................................................