home list archives users mailing list
 

Subject: JDBC driver & OGSA-DAI 3.0

Date view Thread view Subject view Author view Attachment view

From: Samatha Kottha (samatha.kottha@tu-dresden.de)
Date: Dec 14, 2007 09:45

Hi Mike,

Ally knew this problem but we did not yet found the source of this error
messages. Here is the background of the problem. I installed OGSA-DAI
3.0 on GT 4.0.5 container. Globus is working just fine and it using
mysql-connector-java-5.0.5-bin.jar driver to connect to the RFT database
in MySQL (5.0.45 version) without any problem. I deployed the
application databases from a remote database server (MYSQL 5.0.18) under
OGSA-DAI 3.0. But when I try to access this database using OGSA-DAI I am
getting the following error message. Please check the container log
messages at the end of mail. I am pretty sure there is no problem with
the driver because the remote databases could be accessed with the same
driver using OGSA-DAI. 2.2. So, the problem is something to do with code
of OGSA-DAI 3.0 but could not figure it out. Of course, the driver is in
CLASSPATH as well as $GLOBUS_LOCATION/lib . Any clues?

Cheers,
Samatha

kottha@romeo:/home/globus/ogsadai/ogsadai-3.0-gt-4.0.5-src/build/ogsadai-3.0-gt-4.0.5-bin>
java uk.org.ogsadai.client.toolkit.gt.example.GTSecureSQLClient -u
https://romeo.urz.tu-dresden.de:8443/wsrf/services/dai -d MyCATH260 -q
"show tables" -tls encrypt
DRER ID: DataRequestExecutionResource
Data Resource ID: MyCATH260
Base Services URL: https://romeo.urz.tu-dresden.de:8443/wsrf/services/dai
SQLQuery: show tables
Transport level security with encryption
A problem has occured...
[1197625412427:4]
uk.org.ogsadai.client.toolkit.REQUEST_COMPLETED_WITH_ERROR :
ogsadai-116c8e81899
kottha@romeo:/home/globus/ogsadai/ogsadai-3.0-gt-4.0.5-src/build/ogsadai-3.0-gt-4.0.5-bin>

container log

2007-12-14 10:43:31,766 WARN activity.MatchedIterativeActivity
[pool-1-thread-33,warnExceptionAndChildren:?] #1197625411766:108#
java.lang.NullPointerExce
ption: null
2007-12-14 10:43:31,767 WARN event.LoggingActivityListener
[pool-1-thread-33,warnExceptionAndChildren:?] #1197625411766:107# A
problem has occurred during
 processing of activity uk.org.ogsadai.SQLQuery with instance name
uk.org.ogsadai.SQLQuery-ogsadai-116d8098168.
2007-12-14 10:43:31,767 WARN event.LoggingActivityListener
[pool-1-thread-33,warnExceptionAndChildren:?] #1197625411766:107# The
activity encountered a pr
oblem while interacting with a relational database.
2007-12-14 10:43:31,767 WARN event.LoggingActivityListener
[pool-1-thread-33,warnExceptionAndChildren:?] #1197625411766:107# Error
using JDBC connection a
t jdbc:mysql://othello.zih.tu-dresden.de:3306/CATH_2_6_0 .
2007-12-14 10:43:31,767 WARN event.LoggingActivityListener
[pool-1-thread-33,warnExceptionAndChildren:?] #1197625411766:107# Cannot
find Java class org.gj
t.mm.mysql.Driver
2007-12-14 10:43:31,768 WARN event.LoggingActivityListener
[pool-1-thread-32,warnExceptionAndChildren:?] #1197625411768:111# A
problem has occurred during
 processing of activity uk.org.ogsadai.TupleToWebRowSetCharArrays with
instance name uk.org.ogsadai.TupleToWebRowSetCharArrays-ogsadai-116d809816a.
2007-12-14 10:43:31,768 WARN event.LoggingActivityListener
[pool-1-thread-32,warnExceptionAndChildren:?] #1197625411768:111# The
pipe has been closed due
to an error that occurred at the data producer.
2007-12-14 10:43:31,769 WARN event.LoggingActivityListener
[pool-1-thread-34,warnExceptionAndChildren:?] #1197625411769:114# A
problem has occurred during
 processing of activity uk.org.ogsadai.CharArraysResize with instance
name uk.org.ogsadai.CharArraysResize-ogsadai-116d809816c.
2007-12-14 10:43:31,769 WARN event.LoggingActivityListener
[pool-1-thread-34,warnExceptionAndChildren:?] #1197625411769:114# The
pipe has been closed due
to an error that occurred at the data producer.
2007-12-14 10:43:31,769 WARN event.LoggingActivityListener
[pool-1-thread-31,warnExceptionAndChildren:?] #1197625411769:117# A
problem has occurred during
 processing of activity uk.org.ogsadai.DeliverToRequestStatus with
instance name uk.org.ogsadai.DeliverToRequestStatus-ogsadai-116d809816e.
2007-12-14 10:43:31,769 WARN event.LoggingActivityListener
[pool-1-thread-31,warnExceptionAndChildren:?] #1197625411769:117# The
pipe has been closed due
to an error that occurred at the data producer. 

-- 
Samatha Kottha
Zentrum für Informationsdienste und Hochleistungsrechnen (ZIH)
Technische Universität Dresden			Tel: (+49) 351 463-38776
Room 1019					Fax: (+49) 351 463-38245
Noethnitzer Straße 46 
01187 Dresden
Germany
Date view Thread view Subject view Author view Attachment view