I am having problems with a QueryBySql query. When I get to the:
broker.getCollectionByQuery(query);
Line in the code, the App Server crashes. The query is relatively
simple:
select * from AD2STDDE.dexa640t where owner_id = 46 and state_id = 19
and eff_dt <= '2005-08-17' and (exp_dt is null or exp_dt >=
'2005-08-17')
Here is the entire code snippet:
private Collection retrieveIndustryDiscountsByQuery(Date
effectiveDate, State state, String industryCode){
SimpleDateFormat formatter = new SimpleDateFormat
("yyyy-MM-dd");
String formattedDate = formatter.format(effectiveDate);
Industry industry = new Industry();
industry.setCode(industryCode);
industry = (Industry) retrieveObject(industry);
State fullState = State.findByValue(state.getValue());
String sql = "select * from " + owner + ".dexa640t where
owner_id = " + industry.getObjectId() + " and state_id = " +
fullState.getId() + " and eff_dt <= '" + formattedDate + "' and (exp_dt
is null or exp_dt >= '" + formattedDate + "')";
System.err.println(sql);
Query query = new QueryBySQL(IndustryDiscount.class,
sql);
Collection clients = retrieveAll(query);
return clients;
}
private Collection retrieveAll(Query query)
{
Collection all = new ArrayList();
try
{
all = (Collection)
broker.getCollectionByQuery(query);
System.out.println("Collection Size " +
all.size());
} catch (Exception e)
{
throw new SystemException("Error on retrieve all
"+query, e);
}
return all;
}
We are using OJB 1.0.2, and DB2 on the Mainframe. Here is what the App
Server displays before it bombs:
Unhandled exception
Type=GPF vmState=0xffffffff
Target=20030702 (Windows 2000 5.0 build 2195 Service Pack 4 x86)
ExceptionCode=0xc0000005 ExceptionAddress=0x6c3237ce
ContextFlags=0x0001003f
Handler1=0x111016d0 Handler2=0x10019510
Module=C:\Program Files\SQLLIB\BIN\DB2APP.dll
Module_base_address=0x6c290000
Offset_in_DLL=0x000937ce
EDI=0x08e07684 ESI=0x08f7057d EAX=0x000204e2
EBX=0x08ccf8c4 ECX=0x00000000 EDX=0x08f14840
EBP=0x08ccca6c ESP=0x08ccc9a4 EIP=0x6c3237ce
Generating crash dump: C:\Documents and Settings\n0079911\j9.dmp
Thread: Servlet.Engine.Transports : 0 (priority 5) (daemon) (LOCATION OF
ERROR)
NATV COM/ibm/db2/jdbc/app/DB2Statement.SQLGetRowCount(I)I
00f9
COM/ibm/db2/jdbc/app/DB2Statement.getResultSet()Ljava/sql/ResultSet;
0049
COM/ibm/db2/jdbc/app/DB2PreparedStatement.executeQuery()Ljava/sql/Result
Set;
0047
com/ibm/ws/rsadapter/jdbc/WSJdbcPreparedStatement.executeQuery()Ljava/sq
l/ResultSet;
0047
org/apache/ojb/broker/accesslayer/JdbcAccessImpl.executeSQL(Ljava/lang/S
tring;Lorg/apache/ojb/broker/metadata/ClassDescriptor;[Lorg/apache/ojb/b
roker/core/ValueContainer;Z)Lorg/apache/ojb/broker/accesslayer/ResultSet
AndStatement;
0005
org/apache/ojb/broker/accesslayer/JdbcAccessImpl.executeSQL(Ljava/lang/S
tring;Lorg/apache/ojb/broker/metadata/ClassDescriptor;Z)Lorg/apache/ojb/
broker/accesslayer/ResultSetAndStatement;
0017
org/apache/ojb/broker/accesslayer/RsQueryObject.performQuery(Lorg/apache
/ojb/broker/accesslayer/JdbcAccess;)Lorg/apache/ojb/broker/accesslayer/R
esultSetAndStatement;
00a3
org/apache/ojb/broker/accesslayer/RsIterator.<init>(Lorg/apache/ojb/brok
er/accesslayer/RsQueryObject;Lorg/apache/ojb/broker/core/PersistenceBrok
erImpl;)V
0003
org/apache/ojb/broker/accesslayer/SqlBasedRsIterator.<init>(Lorg/apache/
ojb/broker/accesslayer/RsQueryObject;Lorg/apache/ojb/broker/core/Persist
enceBrokerImpl;)V
000a
org/apache/ojb/broker/core/RsIteratorFactoryImpl.createRsIterator(Lorg/a
pache/ojb/broker/query/QueryBySQL;Lorg/apache/ojb/broker/metadata/ClassD
escriptor;Lorg/apache/ojb/broker/core/PersistenceBrokerImpl;)Lorg/apache
/ojb/broker/accesslayer/RsIterator;
003c
org/apache/ojb/broker/core/PersistenceBrokerImpl.getRsIteratorFromQuery(
Lorg/apache/ojb/broker/query/Query;Lorg/apache/ojb/broker/metadata/Class
Descriptor;Lorg/apache/ojb/broker/core/RsIteratorFactory;)Lorg/apache/oj
b/broker/accesslayer/OJBIterator;
0008
org/apache/ojb/broker/core/PersistenceBrokerImpl.getIteratorFromQuery(Lo
rg/apache/ojb/broker/query/Query;Lorg/apache/ojb/broker/metadata/ClassDe
scriptor;)Lorg/apache/ojb/broker/accesslayer/OJBIterator;
0089
org/apache/ojb/broker/core/QueryReferenceBroker.getCollectionByQuery(Lja
va/lang/Class;Ljava/lang/Class;Lorg/apache/ojb/broker/query/Query;)Lorg/
apache/ojb/broker/ManageableCollection;
002c
org/apache/ojb/broker/core/QueryReferenceBroker.getCollectionByQuery(Lja
va/lang/Class;Lorg/apache/ojb/broker/query/Query;Z)Lorg/apache/ojb/broke
r/ManageableCollection;
0018
org/apache/ojb/broker/core/QueryReferenceBroker.getCollectionByQuery(Lor
g/apache/ojb/broker/query/Query;Z)Ljava/util/Collection;
0006
org/apache/ojb/broker/core/PersistenceBrokerImpl.getCollectionByQuery(Lo
rg/apache/ojb/broker/query/Query;)Ljava/util/Collection;
0005
org/apache/ojb/broker/core/DelegatingPersistenceBroker.getCollectionByQu
ery(Lorg/apache/ojb/broker/query/Query;)Ljava/util/Collection;
0005
org/apache/ojb/broker/core/DelegatingPersistenceBroker.getCollectionByQu
ery(Lorg/apache/ojb/broker/query/Query;)Ljava/util/Collection;
001c
com/lmig/pm/affinity/persistence/PersistenceManager.retrieveAll(Lorg/apa
che/ojb/broker/query/Query;)Ljava/util/Collection;
00bb
com/lmig/pm/affinity/persistence/PersistenceManager.retrieveIndustryDisc
ountsByQuery(Ljava/util/Date;Lcom/lmig/pm/affinity/model/State;Ljava/lan
g/String;)Ljava/util/Collection;
005a
com/lmig/pm/affinity/persistence/PersistenceManager.retrieveIndustryDisc
ounts(Ljava/util/Date;Ljava/util/List;Ljava/util/List;)Ljava/util/List;
000a
com/lmig/pm/affinity/service/DefaultIndustryService.getDiscounts(Ljava/u
til/Date;Ljava/util/List;Ljava/util/List;)Ljava/util/List;
0033
com/lmig/pm/affinity/action/IndustryDiscountAction.retrieveIndustryDisco
unts(Ljavax/servlet/http/HttpServletRequest;)Ljava/util/List;
0031
com/lmig/pm/affinity/action/MaintainIndustryDiscountsAction.doPerform(Lo
rg/apache/struts/action/ActionMapping;Lorg/apache/struts/action/ActionFo
rm;Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServle
tResponse;)Lorg/apache/struts/action/ActionForward;
000e
com/lmig/pm/affinity/action/AffinityAction.execute(Lorg/apache/struts/ac
tion/ActionMapping;Lorg/apache/struts/action/ActionForm;Ljavax/servlet/h
ttp/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)Lorg/apa
che/struts/action/ActionForward;
0007
org/apache/struts/action/RequestProcessor.processActionPerform(Ljavax/se
rvlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;Lo
rg/apache/struts/action/Action;Lorg/apache/struts/action/ActionForm;Lorg
/apache/struts/action/ActionMapping;)Lorg/apache/struts/action/ActionFor
ward;
00df
org/apache/struts/action/RequestProcessor.process(Ljavax/servlet/http/Ht
tpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V
0013
org/apache/struts/action/ActionServlet.process(Ljavax/servlet/http/HttpS
ervletRequest;Ljavax/servlet/http/HttpServletResponse;)V
0003
org/apache/struts/action/ActionServlet.doPost(Ljavax/servlet/http/HttpSe
rvletRequest;Ljavax/servlet/http/HttpServletResponse;)V
0003
com/lmig/pm/affinity/servlet/ActionServlet.doGet(Ljavax/servlet/http/Htt
pServletRequest;Ljavax/servlet/http/HttpServletResponse;)V
0021
javax/servlet/http/HttpServlet.service(Ljavax/servlet/http/HttpServletRe
quest;Ljavax/servlet/http/HttpServletResponse;)V
001e
javax/servlet/http/HttpServlet.service(Ljavax/servlet/ServletRequest;Lja
vax/servlet/ServletResponse;)V
0017
com/ibm/ws/webcontainer/servlet/StrictServletInstance.doService(Ljavax/s
ervlet/ServletRequest;Ljavax/servlet/ServletResponse;)V
0048
com/ibm/ws/webcontainer/servlet/StrictLifecycleServlet._service(Ljavax/s
ervlet/ServletRequest;Ljavax/servlet/ServletResponse;)V
0003
com/ibm/ws/webcontainer/servlet/IdleServletState.service(Lcom/ibm/ws/web
container/servlet/StrictLifecycleServlet;Ljavax/servlet/ServletRequest;L
javax/servlet/ServletResponse;)V
0007
com/ibm/ws/webcontainer/servlet/StrictLifecycleServlet.service(Ljavax/se
rvlet/ServletRequest;Ljavax/servlet/ServletResponse;)V
00bc
com/ibm/ws/webcontainer/servlet/ServletInstance.service(Ljavax/servlet/S
ervletRequest;Ljavax/servlet/ServletResponse;Lcom/ibm/ws/webcontainer/we
bapp/WebAppServletInvocationEvent;)V
0008
com/ibm/ws/webcontainer/servlet/ValidServletReferenceState.dispatch(Lcom
/ibm/ws/webcontainer/servlet/ServletInstanceReference;Ljavax/servlet/Ser
vletRequest;Ljavax/servlet/ServletResponse;Lcom/ibm/ws/webcontainer/weba
pp/WebAppServletInvocationEvent;)V
0008
com/ibm/ws/webcontainer/servlet/ServletInstanceReference.dispatch(Ljavax
/servlet/ServletRequest;Ljavax/servlet/ServletResponse;Lcom/ibm/ws/webco
ntainer/webapp/WebAppServletInvocationEvent;)V
0314
com/ibm/ws/webcontainer/webapp/WebAppRequestDispatcher.handleWebAppDispa
tch(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServl
etResponse;)V
14a9
com/ibm/ws/webcontainer/webapp/WebAppRequestDispatcher.dispatch(Ljavax/s
ervlet/ServletRequest;Ljavax/servlet/ServletResponse;Z)V (@09276eb5)
0067
com/ibm/ws/webcontainer/webapp/WebAppRequestDispatcher.forward(Ljavax/se
rvlet/ServletRequest;Ljavax/servlet/ServletResponse;)V
000e
com/ibm/ws/webcontainer/srt/WebAppInvoker.doForward(Ljavax/servlet/http/
HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V
011c
com/ibm/ws/webcontainer/srt/WebAppInvoker.handleInvocationHook(Ljava/lan
g/Object;)V
001b
com/ibm/ws/webcontainer/cache/invocation/CachedInvocation.handleInvocati
on(Ljava/lang/Object;)V
027f
com/ibm/ws/webcontainer/srp/ServletRequestProcessor.dispatchByURI(Ljava/
lang/String;Lcom/ibm/ws/webcontainer/srp/ISRPConnection;)V
0076
com/ibm/ws/webcontainer/oselistener/OSEListenerDispatcher.service(Lcom/i
bm/ws/webcontainer/oselistener/api/IOSEConnection;)V
0005 com/ibm/ws/webcontainer/http/HttpConnection.handleRequest()V
00c6 com/ibm/ws/http/HttpConnection.readAndHandleRequest(Z)V
043e com/ibm/ws/http/HttpConnection.run()V (@09300a4a)
008f com/ibm/ws/util/ThreadPool$Worker.run()V
Thread: Thread-12 (priority 5) (daemon)
NATV java/lang/Thread.sleep(JI)V
0002 java/lang/Thread.sleep(J)V
0007 com/ibm/ejs/j2c/poolmanager/TaskTimer.run()V
Thread: Servlet.Engine.Transports : 1 (priority 5) (daemon)
NATV java/lang/Object.wait(JI)V
0003 java/lang/Object.wait()V
0018 com/ibm/ws/util/BoundedBuffer.take()Ljava/lang/Object;
0194 com/ibm/ws/util/ThreadPool.getTask()Ljava/lang/Runnable;
(@09270e60)
00e9 com/ibm/ws/util/ThreadPool$Worker.run()V
Thread: Alarm : 2 (priority 5) (daemon)
NATV java/io/Win32FileSystem.getLastModifiedTime(Ljava/io/File;)J
0014 java/io/File.lastModified()J
001e com/ibm/ws/cache/config/ConfigManager.checkConfig()V
0008 com/ibm/ws/cache/config/ConfigManager.alarm(Ljava/lang/Object;)V
0008 com/ibm/ejs/util/am/_Alarm.run()V
0117 com/ibm/ws/util/ThreadPool$Worker.run()V (@09288603)
Thread: Alarm : 3 (priority 5) (daemon)
NATV java/lang/Object.wait(JI)V
0003 java/lang/Object.wait(J)V
013b com/ibm/ws/util/BoundedBuffer.poll(J)Ljava/lang/Object;
(@09278ca7)
015c com/ibm/ws/util/ThreadPool.getTask()Ljava/lang/Runnable;
(@09270e28)
015e com/ibm/ws/util/ThreadPool$Worker.run()V (@0928864a)
Thread: main (priority 5)
Thread: Gc Thread (priority 5) (daemon)
Thread: Debug response server (priority 10) (daemon)
Thread: Finalizer thread (priority 5) (daemon)
Thread: Thread-1 (priority 7)
NATV
java/net/SocketInputStream.socketRead([BIILjava/net/SocketImpl;Ljava/io/
FileDescriptor;)I
0037 java/net/SocketInputStream.read([BII)I
0005 java/net/SocketInputStream.read([B)I
00a4 java/io/InputStreamReader.fill([CII)I (@0926e4b0)
0046 java/io/InputStreamReader.read([CII)I
008e java/io/BufferedReader.fill()V
0097 java/io/BufferedReader.readLine(Z)Ljava/lang/String; (@09285a23)
0028 java/io/BufferedReader.readLine()Ljava/lang/String; (@0929c934)
00f2
com/ibm/etools/websphere/tools/runner/CommonServerRunner$Communicator.ru
n()V
000b java/lang/Thread.run()V
Thread: com.ibm.logging.MultiFileHandler: (priority 5) (daemon)
NATV java/lang/Object.wait(JI)V
0003 java/lang/Object.wait()V
0029 com/ibm/logging/Handler.run()V
000b java/lang/Thread.run()V
Thread: Thread-5 (priority 5) (daemon)
NATV java/io/Win32FileSystem.getLastModifiedTime(Ljava/io/File;)J
0014 java/io/File.lastModified()J
0133 com/ibm/ws/classloader/ReloadableClassLoader.checkForUpdate()Z
(@092703df)
0001
com/ibm/ws/classloader/ClassLoaderManager.checkAndNotify(Lcom/ibm/ws/cla
ssloader/ReloadableClassLoader;Lcom/ibm/etools/commonarchive/ModuleRef;)
V
0003
com/ibm/ws/classloader/ClassLoaderManager.access$100(Lcom/ibm/ws/classlo
ader/ClassLoaderManager;Lcom/ibm/ws/classloader/ReloadableClassLoader;Lc
om/ibm/etools/commonarchive/ModuleRef;)V
002f com/ibm/ws/classloader/ClassLoaderManager$ReloadTimerTask.run()V
00e3 java/util/TimerThread.mainLoop()V
0001 java/util/TimerThread.run()V
Thread: LT=0:P=900512:O=0:port=3916 (priority 5) (daemon)
NATV java/net/PlainSocketImpl.socketAccept(Ljava/net/SocketImpl;)V
0002 java/net/PlainSocketImpl.accept(Ljava/net/SocketImpl;)V
0025 java/net/ServerSocket.implAccept(Ljava/net/Socket;)V
000a java/net/ServerSocket.accept()Ljava/net/Socket;
0069 com/ibm/rmi/transport/ListenerThread.run()V
Thread: LT=1:P=900512:O=0:port=2809 (priority 5) (daemon)
NATV java/net/PlainSocketImpl.socketAccept(Ljava/net/SocketImpl;)V
0002 java/net/PlainSocketImpl.accept(Ljava/net/SocketImpl;)V
0025 java/net/ServerSocket.implAccept(Ljava/net/Socket;)V
000a java/net/ServerSocket.accept()Ljava/net/Socket;
0069 com/ibm/rmi/transport/ListenerThread.run()V
Thread: Thread-7 (priority 5) (daemon)
NATV java/lang/Object.wait(JI)V
0003 java/lang/Object.wait(J)V
003c com/ibm/ejs/jts/tran/JavaClock.run()V
Thread: Alarm Manager (priority 5) (daemon)
NATV java/lang/Object.wait(JI)V
0003 java/lang/Object.wait(J)V
006c com/ibm/ejs/util/am/AlarmManagerThread.run()V
000b java/lang/Thread.run()V
Thread: Alarm : 0 (priority 5) (daemon)
NATV java/lang/Object.wait(JI)V
0003 java/lang/Object.wait(J)V
013b com/ibm/ws/util/BoundedBuffer.poll(J)Ljava/lang/Object;
(@09278ca7)
015c com/ibm/ws/util/ThreadPool.getTask()Ljava/lang/Runnable;
(@09270e28)
00e9 com/ibm/ws/util/ThreadPool$Worker.run()V
Thread: ServerSocket[addr=0.0.0.0/0.0.0.0,port=0,localport=8880]
(priority 5)
NATV java/net/PlainSocketImpl.socketAccept(Ljava/net/SocketImpl;)V
0002 java/net/PlainSocketImpl.accept(Ljava/net/SocketImpl;)V
0025 java/net/ServerSocket.implAccept(Ljava/net/Socket;)V
000a java/net/ServerSocket.accept()Ljava/net/Socket;
002c com/ibm/ws/http/HttpTransport.run()V
000b java/lang/Thread.run()V
Thread: PoolScavenger0 (priority 5) (daemon)
NATV java/lang/Object.wait(JI)V
0003 java/lang/Object.wait()V
00b1 com/ibm/mq/PoolScavenger.run()V
000b java/lang/Thread.run()V
Thread: Alarm : 1 (priority 5) (daemon)
NATV java/lang/Object.wait(JI)V
0003 java/lang/Object.wait(J)V
013b com/ibm/ws/util/BoundedBuffer.poll(J)Ljava/lang/Object;
(@09278ca7)
015c com/ibm/ws/util/ThreadPool.getTask()Ljava/lang/Runnable;
(@09270e28)
00e9 com/ibm/ws/util/ThreadPool$Worker.run()V
Thread: JSDI Server Thread (priority 5)
NATV java/lang/Object.wait(JI)V
0003 java/lang/Object.wait()V
0069 com/ibm/bsf/debug/serverImpl/ObjectServer.run()V
000b java/lang/Thread.run()V
Thread: JSDI Connection Thread (priority 5)
NATV java/net/PlainSocketImpl.socketAccept(Ljava/net/SocketImpl;)V
0002 java/net/PlainSocketImpl.accept(Ljava/net/SocketImpl;)V
0025 java/net/ServerSocket.implAccept(Ljava/net/Socket;)V
000a java/net/ServerSocket.accept()Ljava/net/Socket;
0007
com/ibm/bsf/debug/serverImpl/GatedListener$1.run()Ljava/lang/Object;
0001
java/security/AccessController.doPrivileged(Ljava/security/PrivilegedExc
eptionAction;)Ljava/lang/Object;
0066 com/ibm/bsf/debug/serverImpl/GatedListener.accept()V
0006 com/ibm/bsf/debug/serverImpl/GatedListener.run()V
000b java/lang/Thread.run()V
Thread: ServerSocket[addr=0.0.0.0/0.0.0.0,port=0,localport=9080]
(priority 5)
NATV java/net/PlainSocketImpl.socketAccept(Ljava/net/SocketImpl;)V
0002 java/net/PlainSocketImpl.accept(Ljava/net/SocketImpl;)V
0025 java/net/ServerSocket.implAccept(Ljava/net/Socket;)V
000a java/net/ServerSocket.accept()Ljava/net/Socket;
002c com/ibm/ws/http/HttpTransport.run()V
000b java/lang/Thread.run()V
Thread: ServerSocket[addr=0.0.0.0/0.0.0.0,port=0,localport=9443]
(priority 5)
NATV java/net/PlainSocketImpl.socketAccept(Ljava/net/SocketImpl;)V
0002 java/net/PlainSocketImpl.accept(Ljava/net/SocketImpl;)V
0025 java/net/ServerSocket.implAccept(Ljava/net/Socket;)V
000a java/net/ServerSocket.accept()Ljava/net/Socket;
0005 com/ibm/jsse/bc.accept()Ljava/net/Socket;
002c com/ibm/ws/http/HttpTransport.run()V
000b java/lang/Thread.run()V
Thread: Thread-11 (priority 5)
NATV java/lang/Object.wait(JI)V
0003 java/lang/Object.wait()V
0004 com/ibm/CORBA/iiop/KeepAlive.run()V
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
