Betsy Camel

Hi All,

We have a functionality in our application in which the record added by 1 user has to be approved by another user. Recently we found that the record added by 1 user is being stamped with another user details though the second user had not logged into the application on that day. When i checked the queries i find the userid to be passed as empty values ( in the logs ) but the data stamped at the back end is of some other user... Could this be because of toplink stale sessions. Please provide your suggestions and inputs on resolving this problem(assuming that its because of stale sessions )

regards
betsy

Hmm, Actually these DTO's are the model classes for toplink tables. So i cannot create an interface. Could you please suggest some other method so that i can set the values dynamically and return the object please

Hi all,

I have 10 DTO's with similar methods. I have to load each class and set these DTO's dynamically. I donot want to create 10 different objects and return 10 objects. Can someone give me a simpler approach to dynamically set the DTO methods and return 1 object to the main method. Hope i am clear.

Thanks

Could you please give me some good links on that. I am unable to get hold of any good links that gives information on how a sql injection can be prevented in toplink.

Hi

We have a web application that uses Toplink. Recently we found sql injection issues in the application. When i searched the web i found that there is no details on how this can be avoided in toplink. Can anyone help me in solving this issue. I basically want to avoid this and would like to know if there are any configurations that need to be done. Else what are the other ways to prevent this.
Thanks

Hi
I want the java code to detect new instances of Internet explorer that is opened. I am capturing the count of IE opened in a system. Please help
Regards

//package addressbook.HQL;
import java.util.Iterator; import java.util.List; import javax.sql.RowSet; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; import org.hibernate.criterion.Restrictions; import org.hibernate.FetchMode; public class Criteria { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub Session session = null; try { // This step will read hibernate.cfg.xml and prepare hibernate for use SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory(); session = sessionFactory.openSession(); /*org.hibernate.Criteria criteria = session.createCriteria(Honeys.class); criteria.add(Restrictions.eq("mgrid", "manju")); //setFetchMode("last", FetchMode.JOIN). System.out.println("criteria "+criteria); List list = criteria.list();*/ String hql = "from Honey p inner join p.last"; List query = session.createQuery(hql).list(); Honey obj = (Honey)query.get(0); System.out.println(obj.getLast()); }catch(Exception e){ e.printStackTrace(); } } }

I have already posted the mapping files. Please help!
[ November 04, 2008: Message edited by: Paul Sturrock ]

Hi all,

I have two tables with the following columns :

Table name : employee
empid | int(11) | YES | | NULL
ename | varchar(20) | YES | | NULL
mgrid | varchar(20) | YES | | NULL

Table name : link
empid | int(11) | YES | | NULL
mgrid | varchar(20) | YES | | NULL

I would like to use the a criteria and mapping for the following condition in sql :
select * from employee a, link b where a.mgrid=b.mgrid
the mapping i have created looks like the below:
<?xml version='1.0'?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="Honey" table="employee"> <id name="id" column="empid" type="java.lang.Integer"> <generator class="native"/> </id> <property name="first" column="ename" type="java.lang.String" /> <!--<property name="last" column="mgrid" type="java.lang.String" /> --> <one-to-one name="last" class="Honey"/> </class> </hibernate-mapping>
and

NewFile.hbm
<?xml version='1.0'?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="Honeys" table="link"> <id name="id" column="empid" type="java.lang.String"> <generator class="native"/> </id> <!--<property name="mgrid" column="mgrid" type="java.lang.String" /> --> <one-to-one name="mgrid" class="Honeys"/> </class> </hibernate-mapping>

I am however getting errors like
org.hibernate.PropertyAccessException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of Honey.setLast

Please help me asap.
[ November 03, 2008: Message edited by: Paul Sturrock ]

hi

please tell me how to compile and deploy and run rni example in weblogic. Please it is very very urgent..
help as soon as possible

YEs i am getting a connectException. what does this mean ?

Hi all,

I have a requirement to send heartbeats to servers in a cluster whenever a particular event occurs. is there a api to implement the same.

hi
i am getting the following error while testing database connections.

junit.framework.AssertionFailedError: Exception in constructor: testhasOAVRole (java.lang.NullPointerException
at com.gm.bpd.common.transaction.Session.connect(Session.java:69)
at com.gm.bpd.common.transaction.Session.<init>(Session.java:35)
at com.gm.bpd.admin.dao.testACLCUDDAO.<init>(testACLCUDDAO.java:15)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at junit.framework.TestSuite.createTest(TestSuite.java:131)
at junit.framework.TestSuite.addTestMethod(TestSuite.java:114)
at junit.framework.TestSuite.<init>(TestSuite.java:75)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.getTest(RemoteTestRunner.java:399)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:445)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
)
at junit.framework.Assert.fail(Assert.java:47)
at junit.framework.TestSuite$1.runTest(TestSuite.java:263)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)


please find the class below.

package com.gm.bpd.admin.dao; import com.gm.bpd.common.exception.BPDDBException; import com.gm.bpd.common.transaction.Session; import junit.framework.TestCase; import junit.framework.TestSuite; public class testACLCUDDAO extends TestCase { ACLCUDDAO object = new ACLCUDDAO(); public testACLCUDDAO() throws BPDDBException{ super(); System.out.println("i am inside "); Session session = new Session(); session.connect(); } public static void main(String[] args) { new TestSuite(testACLCUDDAO.class); } public void testhasOAVRole(){ try { assertEquals(true,object.hasOAVRole("1446")); System.out.println("out"); } catch (BPDDBException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } ACLCUDDAO public boolean hasOAVRole(String uid) throws BPDDBException { PreparedStatement ps; ResultSet rs; /* 77*/ ps = null; /* 78*/ rs = null; Session session = ThreadLocalSessionManager.getSession(); try { /* 80*/ /* 81*/ Connection con = session.connection(); /* 82*/ ps = con.prepareStatement("Select user_ID from user_priv where role_id=10 and user_id=?"); /* 83*/ ps.setString(1, uid); /* 84*/ rs = ps.executeQuery(); /* 85*/ if (rs.next()) /* 86*/ return true; /* 88*/ return false; } catch (SQLException e) { BPDDBException dbe = handleException(e); throw dbe; } finally { /* 94*/ closeStatement(ps); } } Session public Session() throws BPDDBException { System.out.println("in session"); /* 53*/ connect(); } public void connect() throws BPDDBException { /* 63*/ try { /*Context ctx = new InitialContext(); DataSource ds = (DataSource)ctx.lookup(SystemInfo.getDataSource()); connection = ds.getConnection(); connection.setAutoCommit(false);*/ try { try { System.out.println("jdbc"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); } catch (InstantiationException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IllegalAccessException e) { // TODO Auto-generated catch block e.printStackTrace(); } ; } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } connection = DriverManager.getConnection("jdbc :-o racle :-o ci8:@16.167.20.61:1521:GMGPM", "gpm_bpd2", "gpm_bpd2"); } /* 68*/ catch (SQLException e) { /* 69*/ logger.warn(0x2e8a1d, null, e); /* 70*/ throw new BPDDBException(e.getErrorCode(), e); } /* 71*/ // catch (NamingException en) // { /* 72*/ // logger.warn(0x2e8a1d, null, en); /* 73*/ // throw new BPDDBException(0x2e8a1d, en); // } } and threadlocalclass public class ThreadLocalSessionManager { private static BPDLogger logger; private static SessionFactory factory = new SessionFactory(); private static final ThreadLocal SESSIONCONTEXT = new ThreadLocal(); private static final ThreadLocal TXCONTEXT = new ThreadLocal(); private static final ThreadLocal INTERNALSESSIONCONTEXT = new ThreadLocal(); public ThreadLocalSessionManager() { } private static void init() { } public static Session openSession() throws BPDDBException { /* 61*/ Session session = (Session)SESSIONCONTEXT.get(); /* 64*/ try { /* 64*/ if (session == null) { /* 65*/ session = factory.openConnection(); /* 66*/ SESSIONCONTEXT.set(session); } /* 69*/ if (!session.isConnected()) /* 70*/ session.reconnect(); } /* 72*/ catch (Exception he) { /* 73*/ logger.debug(he.getMessage()); /* 74*/ logger.error(0x2e8a15, null); /* 75*/ throw new BPDDBException("Error occurred when open session", he); } /* 78*/ return session; } public static void closeSession() throws BPDDBException { /* 87*/ Session session = (Session)SESSIONCONTEXT.get(); /* 90*/ try { /* 90*/ if (session != null) { /* 92*/ Transaction tx = (Transaction)TXCONTEXT.get(); /* 93*/ if (tx != null) { /* 94*/ logger.error(0x2e8a26, null); /* 97*/ TXCONTEXT.set(null); /* 99*/ try { /* 99*/ tx.rollback(); } /* 100*/ catch (Exception he) { /* 101*/ logger.error(0x2e8a1a, null, he); } } /* 106*/ SESSIONCONTEXT.set(null); /* 107*/ session.close(); } } /* 109*/ catch (Exception he) { /* 110*/ logger.debug(he.getMessage()); /* 111*/ logger.error(0x2e8a16, null); /* 112*/ throw new BPDDBException("Error occurred when close session", he); } } public static Transaction beginTransaction() throws BPDDBException { /* 124*/ Transaction tx = (Transaction)TXCONTEXT.get(); /* 125*/ Session session = (Session)SESSIONCONTEXT.get(); /* 128*/ try { /* 128*/ if (session == null) { /* 129*/ session = factory.openConnection(); /* 130*/ SESSIONCONTEXT.set(session); } /* 133*/ if (tx == null) { /* 134*/ tx = session.beginTransaction(); /* 135*/ TXCONTEXT.set(tx); } } /* 137*/ catch (Exception he) { /* 138*/ logger.debug(he.getMessage()); /* 139*/ logger.error(0x2e8a17, null); /* 140*/ throw new BPDDBException("Error occurred when begin transaction", he); } /* 144*/ return tx; } public static Session getSession() { System.out.println("thread class"); /* 153*/ Session session = (Session)SESSIONCONTEXT.get(); System.out.println("thread class"+ session); /* 155*/ if (session != null) /* 156*/ return session; /* 159*/ else /* 159*/ return null; }



Please help me resolve ASAP

[edited to add code tags]
[ April 16, 2008: Message edited by: Jeanne Boyarsky ]

Hi jeanne,

your first point - test the dao's via pure junit requires clarification as the dao class has a lot of session objects which require servletcontext. can this scenario be tested via pure junit? i have tried still i get the same error. can you please help me in understanding how to test this scenario.

Hi all,

I have a application with struts framework which has a DAO class, a bussiness object class. i am using strutstestcase for testing the struts app. but when it gets connected to the DAO(which has lots of session objects getting connected to the DB), the tests donot run. It gives a nullpointerexception. i guess this should be a in-container testing. can anyone give me an idea of which would be the best tool for testing this type of application. Please reply soon.