I have created a CMP Entity bean whose primaryKey is Integer. Below is the
deployment descriptor section for my ejipt.createSQL section
<env-entry>
<env-entry-name>ejipt.createSQL</env-entry-name>
<env-entry-type>java.lang.String</env-entry-type>
<env-entry-value>INSERT INTO viPkgLog (zId) VALUES
(?)</env-entry-value>
</env-entry>
<env-entry>
<env-entry-name>ejipt.createSQL.source</env-entry-name>
<env-entry-type>java.lang.String</env-entry-type>
<env-entry-value>ejdbc</env-entry-value>
</env-entry>
<env-entry>
<env-entry-name>ejipt.createSQL.params</env-entry-name>
<env-entry-type>java.lang.String</env-entry-type>
<env-entry-value>zid</env-entry-value>
</env-entry>
<env-entry>
<env-entry-name>ejipt.createSQL.paramTypes</env-entry-name>
<env-entry-type>java.lang.String</env-entry-type>
<env-entry-value>INTEGER</env-entry-value>
</env-entry>
I have specified the paramType as INTEGER. However when I call the create
method I get the following exception
java.rmi.RemoteException: System exception/error caught by container; nested
exception is:
java.sql.SQLException: setObject not supported.
My JDBC driver does not support setObject(). However, this should not be any
big deal since my paramType is specified as INTEGER so the container should
be calling setInteger() but it looks like once again allaire opted to take
the easy way out and ignore paramType declarations and simply use all
setObjects. (See stack Trace below)
java.sql.SQLException: setObject not supported.
at
com.gaexpress.jdbc.GAXPreparedStatement.setObject(GAXPreparedStatement.java)
at
com.gaexpress.jdbc.GAXPreparedStatement.setObject(GAXPreparedStatement.java)
at
allaire.ejipt._ejb._PersistenceAgent._setParameters(allaire/ejipt/_ejb/_Pers
istenceAgent.java:456)
at
allaire.ejipt._ejb._PersistenceAgent._execute(allaire/ejipt/_ejb/_Persistenc
eAgent.java:142)
at
allaire.ejipt._PersistenceManager._create(allaire/ejipt/_PersistenceManager.
java:70)
at
allaire.ejipt._EntityHomeObject._create(allaire/ejipt/_EntityHomeObject.java
:206)
at
allaire.ejipt._CallableObject.call(allaire/ejipt/_CallableObject.java:103)
at
allaire.ejipt._CallableStub._call(allaire/ejipt/_CallableStub.java:199)
at
venlogbeans.viPkgLogHomeObject_Stub.create(d:/JRun/servers/default/deploy/sr
c/venlogbeans/viPkgLogHomeObject_Stub.java:232)
at viTest.doPost(viTest.java:48)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1414)
at
allaire.jrun.session.JRunSessionService.service(../session/JRunSessionServic
e.java:1082)
at
allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:1268)
at
allaire.jrun.servlet.JRunNamedDispatcher.forward(../servlet/JRunNamedDispatc
her.java:39)
at allaire.jrun.servlet.Invoker.service(../servlet/Invoker.java:84)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1414)
at
allaire.jrun.session.JRunSessionService.service(../session/JRunSessionServic
e.java:1082)
at
allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:1268)
at
allaire.jrun.servlet.JRunRequestDispatcher.forward(../servlet/JRunRequestDis
patcher.java:89)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1534)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1524)
at
allaire.jrun.servlet.JvmContext.dispatch(../servlet/JvmContext.java:364)
at allaire.jrun.http.WebEndpoint.run(../http/WebEndpoint.java:115)
at allaire.jrun.ThreadPool.run(../ThreadPool.java:272)
at allaire.jrun.WorkerThread.run(../WorkerThread.java:75)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
