0 Replies Latest reply on Jan 22, 2002 6:16 AM by Rajarshi

    Problem with ConnectJDBC2.2 from Datadirect

    Rajarshi Newbie

      Hello,
      I have downloaded the evaluation version of ConnectJDBC2.2 type 4 driver from http://www.datadirect-technologies.com/
      and using with JBoss-2.4.3_tomcat-3.2.3.
      In my EntityEJB I have one finder method apart from findByPrimaryKey.
      My Session Bean first call that finder method ..in EntityBean I am using PreparedStatement.Now in the finder method the PreparedStatement created and executed successfully.But after calling the EntityBeanPrimaryKey Calss when it is coming to ejbLoad() it is giving the following Exception though it got the pk successfully:

      java.sql.SQLException: Unable to create PreparedStatement!
      at org.jboss.pool.jdbc.xa.wrapper.XAClientConnection.prepareStatement(XAClientConnection.java:169)

      at lmate.EJB.Entity.StudentAcademicEJB.ejbLoad(StudentAcademicEJB.java:102)

      at java.lang.reflect.Method.invoke(Native Method)

      at org.jboss.ejb.plugins.BMPPersistenceManager.loadEntity(BMPPersistenceManager.java:315)

      The Exac Line where it is throwing the Exception is:
      ps=conn.prepareStatement("select * from studentacademic where schoolchainid=? and schoolid=? and admissionnumber=? and batchId=?");

      Please help me as I am in a very crucial position and have to run the Application as soon as possible.

      Regards
      Rajarshi Ghosh