Ritchie Warsi

Hi George thanks for replying.
The common steps like you laid them out to me I understand and already did some matter.

Hibernate configuration, SessionFactory, and a business layer for my Hibernate DAO stuff.
It's like you said, Hibernate is the complex one.

See in my case I use a JDBC realm to log in. As you might know, the logindata is taken out of the database for authentication. Now that would mean I have the username in my session right, cause a succesful login takes the user to it's own page (tested).
Now I want to take the username from the session and use it in a query to get all Customer data that belongs to that username. So my Action should get or set this username and pass it on to the method in my business DAO. No ActionForms thus.

So is there a simple / practical way for this? I don;t have much experience with Java..(yet)

This might be very basic, but I'm still struggling with this.
I got a struts webapp with MySQL and JDBC Realm.

So the user logs in with his customerId and password.
How do I (in my action) get this customerId (login looks it up in UserAccount table) and compare it with customerId from the Customer table.
I use Hibernate for database persistance.

Is something like request.getParameter gonna work, or should I just "set" and "get" customerId?

So my action has to get this customerId that logged in and use it for the following fuction in my Service (Business) class:

List result = null;
Query query =
session.createQuery(
"select Mortgage.mortgageid from Mortgage in class com.test.hibernate.Mortgage where Mortgage.customer=:customerid");
query.setParameter("customerid", customerid);
result = query.list();
return result;

How do I do this and is my approach correct?

Yeah I know it's pretty strange. They said something about the Oracle DB not being connected to the internet by any means, because of other data in it. User priviliges would indeed be the right way, but hell, I'll have to ask again what good reasons they have.

Tnx for your advice and the advice on the approach to take. We'll look into it immediately.
Other advice is always still welcome.

edit: Oracle exp makes a dump right? As far as I know MySQL can't read/import Oracle dumps...or has this changed recently?

edit2: Nevermind, Oracle's CSV export can be read by MySQL it seems.
[ January 06, 2005: Message edited by: Ritchie Warsi ]

The use of 2 databases is not an issue we, as programmers of the webapp, can give advise on. It's something they want to keep like it is.
They've used the oracle database for local purposes, inserting data in it from clients and such and other company related data that is only used locally.
The MySQL DB came along with the implementation of the webapp we have to build and is only necessary to have SOME (not all) info from the Oracle DB, for access with the webapp (only selects mostly).

The data needs to be transfered every day, on schedule or demand is not certain yet. We're talking about 8 tables here, not really large data, but not small either.
The data changes every day, that's why the transfer needs to be on a daily basis.

Hey there,
We are building a Struts webapp for a client that will use a MySQL database.
The webapp will only do getMethods (selects).
The main database were all the info is, is an Oracle DB and so somehow the necessary data will have to go from the Oracle to the MySQL DB.
As the budget is rather limited, I would like to ask you guys with experience what the best way is to do this?
We were thinking of the following:
- Some kind of scheduling, being done via the commandline
- Do a dump of the oracle db to csv or xml and upload it to MySQL
- Some kind of transfer application that will do this locally (as Oracle is NOT connected to the internet and MySQL is)

I hope you understand above points.
Does anyone of you have experience with this? Commercial applications will be our last thing to do, so please advise me other methods.
I was thinking something like, since Tomcat can handle multiple datasources, even the struts webapp can handle multiple datasources, would it be possible to define 2 datasources for the app or Tomcat and somehow do a transfer from time to time?

Allright, I have no other way but to handle it like it was.
My boss makes the datamodel and the database (MySQL) and I let hibernate map the tables and generate the pojo classes.
So it's not up to me unfortunately to think about the structure.

So for instance I got following tables
______________ _____________ ___________
|User_Account| |User_Customer| |Customer |
-------------- ------------- ------------
|Username | |Username | |CustomerID|
|Password | |CustomerID | |Etc etc |
|Role | --------------- ------------
--------------

CustomerID and Username being "foreign" in User_Customer table, Hibernate generates a UserCustomer.java file with id: /** * Constructor of UserCustomer instances given a composite primary key. * @param id */ public UserCustomer(UserCustomerKey id) { super(id); }
So there is another class called UserCustomerKey that consists of /** The value of the CUSTOMERID component of this composite id. */ private Customer customer; /** The value of the USERNAME component of this composite id. */ private UserAccount userAccount;

So as you can see, me being a struts n00b, this is very confusing. The Hibernate docs is, in my opinion not really clear on how to actually use this with CRUD operations for instance. (In other words, the doc isn't really n00b friendly i think).

So does anyone know how to do an Insert for instance in this kind of situation? I'm doing all my CRUD related operatotions in a business class and let the action class call those. But yet I have no idea how it should look like (Simple inserts and such I can do).

Allright I still got this same problem. I restarted the whole project, but the problem remains.
The linenumbers in de stacktrace in the first lines all point out (in the end) to either a get or create session method in my HibernateUtil (see my previous post also). So I'm almost beginning to think that that's the problem.
BUT, I use that same HibernateUtil on a different project, developed under the same circumstances and same tools and showing the data list there works fine!

So pleeeeaasssee someone help me out here!

So It's working now?
Maybe a bit offtopic, but can someone post their good working HibernateUtil or SessionFactory here? I'm having trouble with mine (see other topci of mine).
Pascal, the code you posted, is that a custom class or in the HUtil or SessFactory or something?

What does your HibernateUtil look like? I had this problem once begonce i didn't do a commit for the transaction.

I have some other questions regarding Hibernate and Struts. The Hibernate documention has some examples but I cannot find any good examples of use with a struts webapplication, so I hope someone here knows.

I've got 2 tables, say Customer with PK Customer ID and other table UserAccount with composite PK for Username, Password & FK Customer ID.
I have to create a new User Account, filling in a form on a jsp page with 3 fields, username, password & the customer id which the login will belong to.
How do I set up my business and action for this?

I know how to insert into one table (simple insertion), but this is a little bit different.
My businness class should have something like a public void addUserAccount(String username, String password, Customer customerid) thing I reckon?
But what further? Action class etc etc.

If someone can post an example I'd appreciate it!

Hi Mark, by Business Object what file do you mean/should I look for. You see, I don't know all the terms yet
If you mean my CustomerDAO, it's in my webapps/msl2/WEB-INF/classes/*package name directory structure*

I'm building my first Struts/Tiles/Hibernate application and ran into some problems.

I have a Businessclass that has a method for a List, I call on that method straight in my jsp. This same approach did work on another tutorial I was working on, but in my project now it isn't.

Here is the method in CustomerDAO.java:
public List getCustomerList() { /* * Use the ConnectionFactory to retrieve an open * Hibernate Session. * */ Session session = null; try { session = HibernateUtil.getSession(); /* * Build HQL (Hibernate Query Language) query to retrieve a list * of all the items currently stored by Hibernate. */ Query query = session.createQuery("select Customer from com.frontier.hibernate.Customer Customer order by Customer.customerid"); return query.list(); } catch (HibernateException e) { System.err.println("Session not getted!" + e.getMessage()); throw new RuntimeException(e); } /* * Regardless of whether the above processing resulted in an Exception * or proceeded normally, we want to close the Hibernate session. When * closing the session, we must allow for the possibility of a Hibernate * Exception. * */ finally { if (session != null) { try { session.close(); } catch (HibernateException e) { System.err.println("Hibernate Exception" + e.getMessage()); throw new RuntimeException(e); } } } }

This is my accOptions.jsp:
<%@ page import="com.frontier.hibernate.CustomerDAO" %> <%@ page import="java.util.List" %> <% /* * This code will generate a list of objects from the * database and place a reference to this list in the * request object. * */ List customerList = CustomerDAO.getInstance().getCustomerList(); request.setAttribute("customers", customerList); %> <logic:iterate id="element" name="customers" scope="request" type="com.frontier.hibernate.Customer" indexId="toggle"> <table> <tr><td>Name:</td><td><bean:write name="element" property="name" scope="request" /></td></tr> <tr><td>Address:</td><td><bean:write name="element" property="address" scope="request" /></td></tr> <tr><td>City:</td><td><bean:write name="element" property="city" scope="request" /></td></tr> <tr><td>Number of Mortgages:</td><td><bean:write name="element" property="noofmortgages" scope="request" /></td></tr> </table> </logic:iterate>

And this is my rather long (sorry for that) HibernateUtil.java:
/** * Basic Hibernate helper class, handles SessionFactory, Session and Transaction. * <p> * Uses a static initializer for the initial SessionFactory creation * and holds Session and Transactions in thread local variables. All * exceptions are wrapped in an unchecked InfrastructureException. * * @author christian@hibernate.org */ public class HibernateUtil { private static Log log = LogFactory.getLog(SessionFactory.class); private static Configuration configuration; private static SessionFactory sessionFactory; private static final ThreadLocal threadSession = new ThreadLocal(); private static final ThreadLocal threadTransaction = new ThreadLocal(); private static final ThreadLocal threadInterceptor = new ThreadLocal(); // Create the initial SessionFactory from the default configuration files static { try { //configuration = new Configuration(); sessionFactory = new Configuration().configure().buildSessionFactory(); // We could also let Hibernate bind it to JNDI: // configuration.configure().buildSessionFactory() } catch (Throwable ex) { // We have to catch Throwable, otherwise we will miss // NoClassDefFoundError and other subclasses of Error log.error("Building SessionFactory failed.", ex); throw new ExceptionInInitializerError(ex); } } /** * Returns the SessionFactory used for this static class. * * @return SessionFactory */ public static SessionFactory getSessionFactory() { /* Instead of a static variable, use JNDI: SessionFactory sessions = null; try { Context ctx = new InitialContext(); String jndiName = "java:hibernate/HibernateFactory"; sessions = (SessionFactory)ctx.lookup(jndiName); } catch (NamingException ex) { throw new InfrastructureException(ex); } return sessions; */ return sessionFactory; } /** * Returns the original Hibernate configuration. * * @return Configuration */ public static Configuration getConfiguration() { return configuration; } /** * Rebuild the SessionFactory with the static Configuration. * */ public static void rebuildSessionFactory() throws InfrastructureException { synchronized(sessionFactory) { try { sessionFactory = getConfiguration().buildSessionFactory(); } catch (Exception ex) { throw new InfrastructureException(ex); } } } /** * Rebuild the SessionFactory with the given Hibernate Configuration. * * @param cfg */ public static void rebuildSessionFactory(Configuration cfg) throws InfrastructureException { synchronized(sessionFactory) { try { sessionFactory = cfg.buildSessionFactory(); configuration = cfg; } catch (Exception ex) { throw new InfrastructureException(ex); } } } /** * Retrieves the current Session local to the thread. * <p/> * If no Session is open, opens a new Session for the running thread. * * @return Session */ public static Session getSession() throws InfrastructureException { Session s = (Session) threadSession.get(); try { if (s == null || s.isOpen() == false) { log.debug("Opening new Session for this thread."); if (getInterceptor() != null) { log.debug("Using interceptor: " + getInterceptor().getClass()); s = getSessionFactory().openSession(getInterceptor()); } else { s = getSessionFactory().openSession(); } threadSession.set(s); } } catch (HibernateException ex) { throw new InfrastructureException(ex); } return s; } /** * Closes the Session local to the thread. */ public static void closeSession() throws InfrastructureException { try { Session s = (Session) threadSession.get(); threadSession.set(null); if (s != null && s.isOpen()) { log.debug("Closing Session of this thread."); s.close(); } } catch (HibernateException ex) { throw new InfrastructureException(ex); } } /** * Start a new database transaction. */ public static void beginTransaction() throws InfrastructureException { Transaction tx = (Transaction) threadTransaction.get(); try { if (tx == null) { log.debug("Starting new database transaction in this thread."); tx = getSession().beginTransaction(); threadTransaction.set(tx); } } catch (HibernateException ex) { throw new InfrastructureException(ex); } } /** * Commit the database transaction. */ public static void commitTransaction() throws InfrastructureException { Transaction tx = (Transaction) threadTransaction.get(); try { if ( tx != null && !tx.wasCommitted() && !tx.wasRolledBack() ) { log.debug("Committing database transaction of this thread."); tx.commit(); } threadTransaction.set(null); } catch (HibernateException ex) { rollbackTransaction(); throw new InfrastructureException(ex); } } /** * Commit the database transaction. */ public static void rollbackTransaction() throws InfrastructureException { Transaction tx = (Transaction) threadTransaction.get(); try { threadTransaction.set(null); if ( tx != null && !tx.wasCommitted() && !tx.wasRolledBack() ) { log.debug("Tyring to rollback database transaction of this thread."); tx.rollback(); } } catch (HibernateException ex) { throw new InfrastructureException(ex); } finally { closeSession(); } } /** * Reconnects a Hibernate Session to the current Thread. * * @param session The Hibernate Session to be reconnected. */ public static void reconnect(Session session) throws InfrastructureException { try { session.reconnect(); threadSession.set(session); } catch (HibernateException ex) { throw new InfrastructureException(ex); } } /** * Disconnect and return Session from current Thread. * * @return Session the disconnected Session */ public static Session disconnectSession() throws InfrastructureException { Session session = getSession(); try { threadSession.set(null); if (session.isConnected() && session.isOpen()) session.disconnect(); } catch (HibernateException ex) { throw new InfrastructureException(ex); } return session; } /** * Register a Hibernate interceptor with the current thread. * <p> * Every Session opened is opened with this interceptor after * registration. Has no effect if the current Session of the * thread is already open, effective on next close()/getSession(). */ public static void registerInterceptor(Interceptor interceptor) { threadInterceptor.set(interceptor); } private static Interceptor getInterceptor() { Interceptor interceptor = (Interceptor) threadInterceptor.get(); return interceptor; } }

Now when I call on the jsp page the first time I get:
exception javax.servlet.ServletException org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778) org.apache.jsp.jsp.accOptions_jsp._jspService(org.apache.jsp.jsp.accOptions_jsp:146) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) root cause java.lang.ExceptionInInitializerError com.frontier.hibernate.HibernateUtil.<clinit>(HibernateUtil.java:39) com.frontier.hibernate.CustomerDAO.getCustomerList(CustomerDAO.java:195) org.apache.jsp.jsp.accOptions_jsp._jspService(org.apache.jsp.jsp.accOptions_jsp:80) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

When I refresh that same page i get same exception but different root cause:
root cause java.lang.NoClassDefFoundError com.frontier.hibernate.CustomerDAO.getCustomerList(CustomerDAO.java:195) org.apache.jsp.jsp.accOptions_jsp._jspService(org.apache.jsp.jsp.accOptions_jsp:80) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

I've googled around, found things about classpaths, libraries and such but as far as I can see all is well.
I've got hibernate2.jar AND cglib-full-2.0.1.jar in my WEB-INF/lib.
In my java files I'm referering to the right classes (otherwise Eclipse would warn me about it), so I'm frustrated out of idea's!

Can anyone help me?
O yeah, using JDK 1.5, Tomcat 5.5.4 and Eclipse/MyEclipse.

Another thing. The first rootcause with line 39 is from the throw/catch at wanting to build a SessionFactory and the second one at CustomerDAO:195 is at the List method at trying to get the HibernateUtil.getSession
[ December 22, 2004: Message edited by: Ritchie Warsi ]

Allright, my tomcat error logging isn't configured well, so I'll give you what I get on screen. I'm rather unsure as to what action to call first (getAccountAction or accOptions - the first forwards to the second that calls on a jsp, this is where my data should be - sounds complicated but it's for Tiles).

When calling on getAccountAction i get:
root cause java.lang.ExceptionInInitializerError com.frontier.hibernate.HibernateUtil.<clinit>(HibernateUtil.java:39) com.frontier.hibernate.service.CustomerDAO.getCustomerList(CustomerDAO.java:195) com.frontier.action.getAccountAction.execute(getAccountAction.java:46) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

And when calling on accOptions.do i get:
[ServletException in:/jsp/accOptions.jsp] Cannot find bean customerList in scope request' javax.servlet.jsp.JspException: Cannot find bean customers in scope request at org.apache.struts.util.RequestUtils.lookup (RequestUtils.java:940) at org.apache.struts.taglib.logic.IterateTag.doStartTag(IterateTag.java:277) at org.apache.jsp.jsp.accOptions_jsp._jspService (org.apache.jsp.jsp.accOptions_jsp:76) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service (JspServletWrapper.java:325) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:157) at org.apache.catalina.core.ApplicationDispatcher.invoke (ApplicationDispatcher.java:674) at org.apache.catalina.core.ApplicationDispatcher.doInclude (ApplicationDispatcher.java:576) at org.apache.catalina.core.ApplicationDispatcher.include (ApplicationDispatcher.java:501) at org.apache.jasper.runtime.JspRuntimeLibrary.include (JspRuntimeLibrary.java:966) at org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:601) at org.apache.struts.tiles.TilesUtilImpl.doInclude(TilesUtilImpl.java:137) at org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:177) at org.apache.struts.taglib.tiles.InsertTag.doInclude(InsertTag.java:756) at org.apache.struts.taglib.tiles.InsertTag$InsertHandler.doEndTag (InsertTag.java:881) at org.apache.struts.taglib.tiles.InsertTag.doEndTag (InsertTag.java:473) at org.apache.jsp.layouts.mslDefaultLayout_jsp._jspx_meth_tiles_insert_2 (org.apache.jsp.layouts.mslDefaultLayout_jsp:198) at org.apache.jsp.layouts.mslDefaultLayout_jsp._jspService (org.apache.jsp.layouts.mslDefaultLayout_jsp:105) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service (JspServletWrapper.java:325) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:157) at org.apache.catalina.core.ApplicationDispatcher.invoke (ApplicationDispatcher.java:674) at org.apache.catalina.core.ApplicationDispatcher.processRequest (ApplicationDispatcher.java:465) at org.apache.catalina.core.ApplicationDispatcher.doForward (ApplicationDispatcher.java:400) at org.apache.catalina.core.ApplicationDispatcher.forward (ApplicationDispatcher.java:303) at org.apache.struts.action.RequestProcessor.doForward (RequestProcessor.java:1069) at org.apache.struts.tiles.TilesRequestProcessor.doForward (TilesRequestProcessor.java:274) at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition (TilesRequestProcessor.java:254) at etc etc

But is my approach correct?

[ December 20, 2004: Message edited by: Ritchie Warsi ]

[ December 20, 2004: Message edited by: Ritchie Warsi ]

[ December 20, 2004: Message edited by: Ritchie Warsi ]

[ December 21, 2004: Message edited by: Jason Menard ]
[ December 21, 2004: Message edited by: Jason Menard ]

I'm a struts newb, so this might be quite easy. All the tutorials I've read or either more complex or they use the jsp itself to generate a list of data.

I want my action class to retrieve my data for me from the db and send in to the jsp page.

So far I've got this (which doesn't work ofcourse):
I wanna use the following method in my CustomerDAO.java:
/** * getItemList() returns list of all <code>Customer</code> objects stored in the database. * * @return <code>List</code> of <code>Customer</code> objects. */ public List getCustomerList() { /* * Use the ConnectionFactory to retrieve an open * Hibernate Session. * */ Session session = null; try { session = HibernateUtil.getSession(); /* * Build HQL (Hibernate Query Language) query to retrieve a list * of all the items currently stored by Hibernate. */ Query query = session.createQuery("select Customer from com.frontier.hibernate.Customer Customer order by Customer.customerid"); return query.list(); } catch (HibernateException e) { System.err.println("Session not getted!" + e.getMessage()); throw new RuntimeException(e); } /* * Regardless of whether the above processing resulted in an Exception * or proceeded normally, we want to close the Hibernate session. When * closing the session, we must allow for the possibility of a Hibernate * Exception. * */ finally { if (session != null) { try { session.close(); } catch (HibernateException e) { System.err.println("Hibernate Exception" + e.getMessage()); throw new RuntimeException(e); } } } }

My getAccountAction.java has:
public ActionForward execute( ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { List customerList = CustomerDAO.getInstance().getCustomerList(); request.setAttribute("customers", customerList); return mapping.findForward("success"); }

And my struts-config has the following action mapping:
<action path="/accOptions" type="com.frontier.action.doTiles"> <forward name="success" path="account" /> </action> <action path="/getAccountAction" type="com.frontier.action.getAccountAction"> <forward name="success" path="/accOptions.do" /> </action>

My simple jsp has:
<logic:iterate name="customers" id="cus"> <table> <tr><td>Name:</td><td><bean:write name="cus" property="name" /></td></tr> <tr><td>Address:</td><td><bean:write name="cus" property="address" /></td></tr> <tr><td>City:</td><td><bean:write name="cus" property="city" /></td></tr> <tr><td>Number of Mortgages:</td><td><bean:write name="cus" property="noofmortgages" /></td></tr> </table> </logic:iterate>

So obviously I'm doing something wrong or forgetting something. Can anyone point me out what?

Tnx for the answer, but...
I'm rather new at all this, so I have no idea how to check out your suggestions...
I guess my XML parser is dat Xerces thing? or I18n?

Edit, ok is Xerces I'll look into it now, yet I have no idea what exactly to look for

Any more help is appreciated!
[ December 14, 2004: Message edited by: Ritchie Warsi ]