OFS-Temenos upload help

[ancaremthoi]

Hi All,
I use the quickstart for OFS-T24
When I uploaded T24Test.dbs to server by web admin. There is a error
as following.
Please help me to resolve it.
Error: DS Fault Message: Error occured connecting to database using
connection pooling manager Nested Exception:- DS Fault Message: Error
locating class org.t24.driver.T24Driver Nested Exception:-
java.lang.ClassNotFoundException: org.t24.driver.T24Driver at
org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:
489) at
org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:
405) at
org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:
393) at
org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:
105) at java.lang.ClassLoader.loadClass(ClassLoader.java:248) at
java.lang.Class.forName0(Native Method) at
java.lang.Class.forName(Class.java:169) at
org.wso2.carbon.dataservices.DBCPConnectionManager.connectToDB(DBCPConnectionManager.java:
87) at org.wso2.carbon.dataservices.DBCPConnectionManager.
(DBCPConnectionManager.java:46) at
org.wso2.carbon.dataservices.dispatch.config.RDBMSConfig.
(RDBMSConfig.java:33) at
org.wso2.carbon.dataservices.dispatch.config.ConfigFactory.getRDBMSConfig(ConfigFactory.java:
56) at
org.wso2.carbon.dataservices.dispatch.config.ConfigFactory.createConfig(ConfigFactory.java:
41) at
org.wso2.carbon.dataservices.DBDeployer.createDataServiceObject(DBDeployer.java:
361) at
org.wso2.carbon.dataservices.DBDeployer.createDBService(DBDeployer.java:
555) at
org.wso2.carbon.dataservices.DBDeployer.processService(DBDeployer.java:
811) at org.wso2.carbon.dataservices.DBDeployer.deploy(DBDeployer.java:
161) at
org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:
136) at
org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:
795) at
org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.java:
144) at
org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.java:
338) at
org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListener.java:
241) at
org.apache.axis2.deployment.DeploymentEngine.loadServices(DeploymentEngine.java:
136) at
org.wso2.carbon.core.CarbonAxisConfigurator.loadServices(CarbonAxisConfigurator.java:
288) at
org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.java:
95) at
org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(CarbonConfigurationContextFactory.java:
76) at
org.wso2.carbon.core.init.CarbonServerManager.initializeCarbon(CarbonServerManager.java:
308) at
org.wso2.carbon.core.init.CarbonServerManager.removePendingItem(CarbonServerManager.java:
221) at
org.wso2.carbon.core.init.OSGiAxis2ServicesListener.bundleChanged(OSGiAxis2ServicesListener.java:
82) at
org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:
916) at
org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:
220) at org.eclipse.osgi.framework.eventmgr.EventManager
$EventThread.run(EventManager.java:330) at
org.wso2.carbon.dataservices.DBCPConnectionManager.connectToDB(DBCPConnectionManager.java:
90) at org.wso2.carbon.dataservices.DBCPConnectionManager.
(DBCPConnectionManager.java:46) at
org.wso2.carbon.dataservices.dispatch.config.RDBMSConfig.
(RDBMSConfig.java:33) at
org.wso2.carbon.dataservices.dispatch.config.ConfigFactory.getRDBMSConfig(ConfigFactory.java:
56) at
org.wso2.carbon.dataservices.dispatch.config.ConfigFactory.createConfig(ConfigFactory.java:
41) at
org.wso2.carbon.dataservices.DBDeployer.createDataServiceObject(DBDeployer.java:
361) at
org.wso2.carbon.dataservices.DBDeployer.createDBService(DBDeployer.java:
555) at
org.wso2.carbon.dataservices.DBDeployer.processService(DBDeployer.java:
811) at org.wso2.carbon.dataservices.DBDeployer.deploy(DBDeployer.java:
161) at
org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:
136) at
org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:
795) at
org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.java:
144) at
org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.java:
338) at
org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListener.java:
241) at
org.apache.axis2.deployment.DeploymentEngine.loadServices(DeploymentEngine.java:
136) at
org.wso2.carbon.core.CarbonAxisConfigurator.loadServices(CarbonAxisConfigurator.java:
288) at
org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.java:
95) at
org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(CarbonConfigurationContextFactory.java:
76) at
org.wso2.carbon.core.init.CarbonServerManager.initializeCarbon(CarbonServerManager.java:
308) at
org.wso2.carbon.core.init.CarbonServerManager.removePendingItem(CarbonServerManager.java:
221) at
org.wso2.carbon.core.init.OSGiAxis2ServicesListener.bundleChanged(OSGiAxis2ServicesListener.java:
82) at
org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:
916) at
org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:
220) at org.eclipse.osgi.framework.eventmgr.EventManager
$EventThread.run(EventManager.java:330) Caused by:
java.lang.ClassNotFoundException: org.t24.driver.T24Driver at
org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:
489) at
org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:
405) at
org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:
393) at
org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:
105) at java.lang.ClassLoader.loadClass(ClassLoader.java:248) at
java.lang.Class.forName0(Native Method) at
java.lang.Class.forName(Class.java:169) at
org.wso2.carbon.dataservices.DBCPConnectionManager.connectToDB(DBCPConnectionManager.java:
87) ... 23 more at org.wso2.carbon.dataservices.DBCPConnectionManager.
(DBCPConnectionManager.java:48) at
org.wso2.carbon.dataservices.dispatch.config.RDBMSConfig.
(RDBMSConfig.java:33) at
org.wso2.carbon.dataservices.dispatch.config.ConfigFactory.getRDBMSConfig(ConfigFactory.java:
56) at
org.wso2.carbon.dataservices.dispatch.config.ConfigFactory.createConfig(ConfigFactory.java:
41) at
org.wso2.carbon.dataservices.DBDeployer.createDataServiceObject(DBDeployer.java:
361) at
org.wso2.carbon.dataservices.DBDeployer.createDBService(DBDeployer.java:
555) at
org.wso2.carbon.dataservices.DBDeployer.processService(DBDeployer.java:
811) at org.wso2.carbon.dataservices.DBDeployer.deploy(DBDeployer.java:
161) at
org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:
136) at
org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:
795) at
org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.java:
144) at
org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.java:
338) at
org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListener.java:
241) at
org.apache.axis2.deployment.DeploymentEngine.loadServices(DeploymentEngine.java:
136) at
org.wso2.carbon.core.CarbonAxisConfigurator.loadServices(CarbonAxisConfigurator.java:
288) at
org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.java:
95) at
org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(CarbonConfigurationContextFactory.java:
76) at
org.wso2.carbon.core.init.CarbonServerManager.initializeCarbon(CarbonServerManager.java:
308) at
org.wso2.carbon.core.init.CarbonServerManager.removePendingItem(CarbonServerManager.java:
221) at
org.wso2.carbon.core.init.OSGiAxis2ServicesListener.bundleChanged(OSGiAxis2ServicesListener.java:
82) at
org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:
916) at
org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:
220) at org.eclipse.osgi.framework.eventmgr.EventManager
$EventThread.run(EventManager.java:330) Caused by: DS Fault Message:
Error locating class org.t24.driver.T24Driver Nested Exception:-
java.lang.ClassNotFoundException: org.t24.driver.T24Driver at
org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:
489) at
org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:
405) at
org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:
393) at
org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:
105) at java.lang.ClassLoader.loadClass(ClassLoader.java:248) at
java.lang.Class.forName0(Native Method) at
java.lang.Class.forName(Class.java:169) at
org.wso2.carbon.dataservices.DBCPConnectionManager.connectToDB(DBCPConnectionManager.java:
87) at org.wso2.carbon.dataservices.DBCPConnectionManager.
(DBCPConnectionManager.java:46) at
org.wso2.carbon.dataservices.dispatch.config.RDBMSConfig.
(RDBMSConfig.java:33) at
org.wso2.carbon.dataservices.dispatch.config.ConfigFactory.getRDBMSConfig(ConfigFactory.java:
56) at
org.wso2.carbon.dataservices.dispatch.config.ConfigFactory.createConfig(ConfigFactory.java:
41) at
org.wso2.carbon.dataservices.DBDeployer.createDataServiceObject(DBDeployer.java:
361) at
org.wso2.carbon.dataservices.DBDeployer.createDBService(DBDeployer.java:
555) at
org.wso2.carbon.dataservices.DBDeployer.processService(DBDeployer.java:
811) at org.wso2.carbon.dataservices.DBDeployer.deploy(DBDeployer.java:
161) at
org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:
136) at
org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:
795) at
org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.java:
144) at
org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.java:
338) at
org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListener.java:
241) at
org.apache.axis2.deployment.DeploymentEngine.loadServices(DeploymentEngine.java:
136) at
org.wso2.carbon.core.CarbonAxisConfigurator.loadServices(CarbonAxisConfigurator.java:
288) at
org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.java:
95) at
org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(CarbonConfigurationContextFactory.java:
76) at
org.wso2.carbon.core.init.CarbonServerManager.initializeCarbon(CarbonServerManager.java:
308) at
org.wso2.carbon.core.init.CarbonServerManager.removePendingItem(CarbonServerManager.java:
221) at
org.wso2.carbon.core.init.OSGiAxis2ServicesListener.bundleChanged(OSGiAxis2ServicesListener.java:
82) at
org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:
916) at
org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:
220) at org.eclipse.osgi.framework.eventmgr.EventManager
$EventThread.run(EventManager.java:330) at
org.wso2.carbon.dataservices.DBCPConnectionManager.connectToDB(DBCPConnectionManager.java:
90) at org.wso2.carbon.dataservices.DBCPConnectionManager.
(DBCPConnectionManager.java:46) ... 22 more Caused by:
java.lang.ClassNotFoundException: org.t24.driver.T24Driver at
org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:
489) at
org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:
405) at
org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:
393) at
org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:
105) at java.lang.ClassLoader.loadClass(ClassLoader.java:248) at
java.lang.Class.forName0(Native Method) at
java.lang.Class.forName(Class.java:169) at
org.wso2.carbon.dataservices.DBCPConnectionManager.connectToDB(DBCPConnectionManager.java:
87) ... 23 more

[Dmitry.]

Hello,

java.lang.ClassNotFoundException: org.t24.driver.T24Driver
means that server could not locate temenos jdbc library.
Check that you put t24jdbc.jar into
%WSO2_HOME%/repository/components/lib

Where %WSO2_HOME% is dataservices or wsas home.
By the way what product/version do you use?

[Dmitry.]

This problem discussed here:
http://wso2.org/forum/thread/9124

[NGUYEN TRUONG]

Thanks all for your reply. It's work now when I move jdbc lib into right folder. But I use T24Test.dbs to upload server but there is error following

rror: java.lang.NullPointerException at org.wso2.carbon.dataservices.dispatch.query.SQLQuery.createNamedParamIndices(SQLQuery.java:167) at org.wso2.carbon.dataservices.dispatch.query.SQLQuery.(SQLQuery.java:95) at org.wso2.carbon.dataservices.dispatch.query.QueryFactory.createSQLQuery(QueryFactory.java:82) at org.wso2.carbon.dataservices.dispatch.query.QueryFactory.createQuery(QueryFactory.java:49) at org.wso2.carbon.dataservices.DBDeployer.createDataServiceObject(DBDeployer.java:367) at org.wso2.carbon.dataservices.DBDeployer.createDBService(DBDeployer.java:555) at org.wso2.carbon.dataservices.DBDeployer.processService(DBDeployer.java:811) at org.wso2.carbon.dataservices.DBDeployer.deploy(DBDeployer.java:161) at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:136) at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:795) at org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.java:144) at org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.java:338) at org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListener.java:241) at org.apache.axis2.deployment.RepositoryListener.startListener(RepositoryListener.java:332) at org.apache.axis2.deployment.scheduler.SchedulerTask.checkRepository(SchedulerTask.java:64) at org.apache.axis2.deployment.scheduler.SchedulerTask.run(SchedulerTask.java:71) at org.apache.axis2.deployment.scheduler.Scheduler$SchedulerTimerTask.run(Scheduler.java:90) at java.util.TimerThread.mainLoop(Timer.java:512) at java.util.TimerThread.run(Timer.java:462)

When I modify T24Test.dbs I can deploy server T24Test to server but when I use "try this service" has error following. Please help me to resolve it. (Attached file is my T24Test.dbs file after modified) Thansk

Fault: DS Fault Message: Error in 'createProcessedPreparedStatement' Source Data Service:- Name: T24Test Location: C:\wso2\wso2dataservices-2.2.1\repository\dataservices\T24Test.dbs Description: N/A Default Namespace: http://my.namespace Current Request Name: getUserList Current Params: {} Nested Exception:- org.t24.driver.T24FeatureNotSupportedException: The rquested feature is not supported by current driver. at org.t24.driver.T24PreparedStatement.setFetchSize(T24PreparedStatement.java:265) at org.apache.commons.dbcp.DelegatingStatement.setFetchSize(DelegatingStatement.java:279) at org.wso2.carbon.dataservices.dispatch.query.SQLQuery.createProcessedPreparedStatement(SQLQuery.java:390) at org.wso2.carbon.dataservices.dispatch.query.SQLQuery.processNormalQuery(SQLQuery.java:274) at org.wso2.carbon.dataservices.dispatch.query.SQLQuery.runQuery(SQLQuery.java:1043) at org.wso2.carbon.dataservices.dispatch.query.Query.execute(Query.java:105) at org.wso2.carbon.dataservices.dispatch.CallQuery.execute(CallQuery.java:82) at org.wso2.carbon.dataservices.dispatch.CallQueryGroup.execute(CallQueryGroup.java:88) at org.wso2.carbon.dataservices.dispatch.operation.Operation.execute(Operation.java:50) at org.wso2.carbon.dataservices.dispatch.DataService.invoke(DataService.java:204) at org.wso2.carbon.dataservices.dispatch.DSOMDataSource.serialize(DSOMDataSource.java:87) at org.apache.axiom.om.impl.llom.OMSourcedElementImpl.internalSerializeAndConsume(OMSourcedElementImpl.java:738) at org.apache.axiom.om.impl.llom.OMElementImpl.internalSerialize(OMElementImpl.java:966) at org.apache.axiom.om.impl.llom.OMElementImpl.internalSerializeAndConsume(OMElementImpl.java:995) at org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.serializeInternally(SOAPEnvelopeImpl.java:254) at org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.internalSerialize(SOAPEnvelopeImpl.java:242) at org.apache.axiom.om.impl.llom.OMElementImpl.internalSerializeAndConsume(OMElementImpl.java:995) at org.apache.axiom.om.impl.llom.OMNodeImpl.serializeAndConsume(OMNodeImpl.java:486) at org.apache.axis2.transport.http.SOAPMessageFormatter.writeTo(SOAPMessageFormatter.java:79) at org.apache.axis2.transport.http.CommonsHTTPTransportSender.sendUsingOutputStream(CommonsHTTPTransportSender.java:355) at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:232) at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:440) at org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLogic(AbstractInOutSyncMessageReceiver.java:45) at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:114) at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:178) at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:167) at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:142) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:67) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.wso2.carbon.bridge.BridgeServlet.service(BridgeServlet.java:135) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:619)

[Dmitry Lukyanov]

Hello,

We did not test driver with DS 2.2.1 yet.
It seems there are some new jdbc functions required.
Could you please use DS 2.2.0 for now:
http://wso2.org/downloads/data-services-server/2.2.0

And we will check a new version of DataServices.

Regards,
DMitry

> *When I modify T24Test.dbs I can deploy server T24Test to server but when I

> use "try this service" has error following. Please help me to resolve it.
> (Attached file is my T24Test.dbs file after modified) Thansk
>

> *Fault: DS Fault Message: Error in 'createProcessedPreparedStatement' Source

> *
> *
>
>



--
Regards,
Dmitry

[NGUYEN TRUONG]

Dear  DMitry,
I have tried with DS2.2.0. but the problem is the same. Thanks for your support.
Look for your reply.
Thanks again.

Truong

2010/5/5 Dmitry Lukyanov <dluk...@ukr.net>

[Dmitry.]

Hello,

We just made tests on WSO2DS 2.2.1 and we have the same problem.

I sure you hit a bug on the level of wso2 dataservices.
I have createed an issue for this case
https://wso2.org/jira/browse/DS-507

What I can suggest:

Currently, we are using in production WSO2 WSAS 3.1.0 (it includes
also dataservices)
http://wso2.org/downloads/wsas/3.1.0

You can download sources and binaries.
We modified one library (because there were also some bugs).

I've attached an archive with corrected sources and compiled version
of the
dataservice-core module for exact version of WSAS: 3.1.0.
Just extract it over downloaded wsas.

[Dmitry.]

The link to the modified dataservice-core module:
http://groups.google.com/group/temenos-ofs-jdbc/web/wso2wsas-3.1.0-mod.zip

On May 5, 3:58 pm, "Dmitry." <dlukya...@ukr.net> wrote:
> Hello,
>
> We just made tests on WSO2DS 2.2.1 and we have the same problem.
>
> I sure you hit a bug on the level of wso2 dataservices.

> I have createed an issue for this casehttps://wso2.org/jira/browse/DS-507

>
> What I can suggest:
>
> Currently, we are using in production WSO2 WSAS 3.1.0 (it includes

> also dataservices)http://wso2.org/downloads/wsas/3.1.0

[NGUYEN TRUONG]

Hi,
I use WSAS 3.1.0 and your modified lib. But when I upload T24TestDB succesffuly but there is a error as following. I use getUserList => wait for a long time = > the result is NULL

[2010-05-06 09:35:02,248]  INFO -  'admin' logged in at [2010-05-06 09:35:02,024
8] from IP address 127.0.0.1
[2010-05-06 09:35:32,717]  INFO -  carbon.query.timeout=30
log4j:ERROR A "org.wso2.carbon.utils.MemoryAppender" object is not assignable to
 a "org.apache.log4j.Appender" variable.
log4j:ERROR The class "org.apache.log4j.Appender" was loaded by
log4j:ERROR [org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader@accd65] wh
ereas object of type
log4j:ERROR "org.wso2.carbon.utils.MemoryAppender" was loaded by [sun.misc.Launc
her$AppClassLoader@601bb1].
log4j:ERROR Could not instantiate appender named "CARBON_MEMORY".
log4j:ERROR A "org.wso2.carbon.utils.MemoryAppender" object is not assignable to
 a "org.apache.log4j.Appender" variable.
log4j:ERROR The class "org.apache.log4j.Appender" was loaded by
log4j:ERROR [org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader@accd65] wh
ereas object of type
log4j:ERROR "org.wso2.carbon.utils.MemoryAppender" was loaded by [sun.misc.Launc
her$AppClassLoader@601bb1].
log4j:ERROR Could not instantiate appender named "CARBON_MEMORY".
log4j:ERROR A "org.wso2.carbon.utils.MemoryAppender" object is not assignable to
 a "org.apache.log4j.Appender" variable.
log4j:ERROR The class "org.apache.log4j.Appender" was loaded by
log4j:ERROR [org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader@accd65] wh
ereas object of type
log4j:ERROR "org.wso2.carbon.utils.MemoryAppender" was loaded by [sun.misc.Launc
her$AppClassLoader@601bb1].
log4j:ERROR Could not instantiate appender named "CARBON_MEMORY".
log4j:ERROR A "org.wso2.carbon.utils.MemoryAppender" object is not assignable to
 a "org.apache.log4j.Appender" variable.
log4j:ERROR The class "org.apache.log4j.Appender" was loaded by
log4j:ERROR [org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader@accd65] wh
ereas object of type
log4j:ERROR "org.wso2.carbon.utils.MemoryAppender" was loaded by [sun.misc.Launc
her$AppClassLoader@601bb1].
log4j:ERROR Could not instantiate appender named "CARBON_MEMORY".
log4j:ERROR A "org.wso2.carbon.utils.MemoryAppender" object is not assignable to
 a "org.apache.log4j.Appender" variable.
log4j:ERROR The class "org.apache.log4j.Appender" was loaded by
log4j:ERROR [org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader@accd65] wh
ereas object of type
log4j:ERROR "org.wso2.carbon.utils.MemoryAppender" was loaded by [sun.misc.Launc
her$AppClassLoader@601bb1].
log4j:ERROR Could not instantiate appender named "CARBON_MEMORY".
log4j:ERROR A "org.wso2.carbon.utils.MemoryAppender" object is not assignable to
 a "org.apache.log4j.Appender" variable.
log4j:ERROR The class "org.apache.log4j.Appender" was loaded by
log4j:ERROR [org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader@accd65] wh
ereas object of type
log4j:ERROR "org.wso2.carbon.utils.MemoryAppender" was loaded by [sun.misc.Launc
her$AppClassLoader@601bb1].
log4j:ERROR Could not instantiate appender named "CARBON_MEMORY".
log4j:ERROR A "org.wso2.carbon.utils.MemoryAppender" object is not assignable to
 a "org.apache.log4j.Appender" variable.
log4j:ERROR The class "org.apache.log4j.Appender" was loaded by
log4j:ERROR [org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader@accd65] wh
ereas object of type
log4j:ERROR "org.wso2.carbon.utils.MemoryAppender" was loaded by [sun.misc.Launc
her$AppClassLoader@601bb1].
log4j:ERROR Could not instantiate appender named "CARBON_MEMORY".
[2010-05-06 09:35:32,936]  INFO -  Deploying Axis2 service T24Test

[Dmitry.]

Now, you did not put tcclientlog.properties into wsas conf directory,
or you put unmodified version of it. And it crash native wsas logger.

Stop the server, delete all logs, modify tcclientlog.properties
file according to
http://code.google.com/p/temenos-ofs-jdbc/wiki/QuickStartWebService
start wsas server.

PS: getUserList operation sends a standard enquiry "%USER"
to T24 server. Could you check that this enquiry is working from T24
desktop.
Another problems:
- t24 could take long time to answer, so timeout occured
- if you have a lot of lines in this enquiry, t24 could take long
time to format the answer.

But in any case we should see all problems in the logs.

Regards,
Dmitry

> On Wed, May 5, 2010 at 8:08 PM, Dmitry. <dlukya...@ukr.net> wrote:
> > The link to the modified dataservice-core module:

> >http://groups.google.com/group/temenos-ofs-jdbc/web/wso2wsas-3.1.0-mo...

[NGUYEN TRUONG]

I attachted tcclient.log file. Please have a look for more detail

Thanks alot
Truong Nguyen.

[NGUYEN TRUONG]

More log file

On Thu, May 6, 2010 at 10:05 AM, Dmitry. <dluk...@ukr.net> wrote:

[Dmitry.]

The problem that we meet in dataservice 2.2.1 is solved and will be
corrected in version 2.5.0.
https://wso2.org/jira/browse/DS-507

Regards,
Dmitry

[NGUYEN TRUONG]

Hi , 

I also downloaded version 2.5.0 and  try. But the error is the same.

Name: T24Test

Location: C:\wso2\WSO2DA~1.0\bin\..\repository\deployment\server\dataservices\T24Test.dbs

Description: Test service

Default Namespace: http://my.namespace

Current Request Name: getUserList

Current Params: {}

Nested Exception:-

org.t24.driver.T24FeatureNotSupportedException: The rquested feature is not supported by current driver.

at org.t24.driver.T24PreparedStatement.setFetchSize(T24PreparedStatement.java:265)

at org.apache.commons.dbcp.DelegatingStatement.setFetchSize(DelegatingStatement.java:279)

at org.wso2.carbon.dataservices.core.description.query.SQLQuery.createProcessedPreparedStatement(SQLQuery.java:775)

at org.wso2.carbon.dataservices.core.description.query.SQLQuery.processNormalQuery(SQLQuery.java:472)

at org.wso2.carbon.dataservices.core.description.query.SQLQuery.runQuery(SQLQuery.java:1412)

at org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:214)

at org.wso2.carbon.dataservices.core.engine.CallQuery.execute(CallQuery.java:150)

at org.wso2.carbon.dataservices.core.engine.CallQueryGroup.execute(CallQueryGroup.java:108)

at org.wso2.carbon.dataservices.core.description.operation.Operation.execute(Operation.java:64)

at org.wso2.carbon.dataservices.core.engine.DataService.invoke(DataService.java:318)

at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:90)

at org.apache.axiom.om.impl.llom.OMSourcedElementImpl.internalSerialize(OMSourcedElementImpl.java:691)

at org.apache.axiom.om.impl.llom.OMElementImpl.internalSerialize(OMElementImpl.java:965)

at org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.serializeInternally(SOAPEnvelopeImpl.java:283)

at org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.internalSerialize(SOAPEnvelopeImpl.java:245)

at org.apache.axiom.om.impl.llom.OMSerializableImpl.serializeAndConsume(OMSerializableImpl.java:193)

at org.apache.axis2.transport.http.SOAPMessageFormatter.writeTo(SOAPMessageFormatter.java:79)

at org.apache.axis2.transport.http.CommonsHTTPTransportSender.sendUsingOutputStream(CommonsHTTPTransportSender.java:361)

at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:238)

at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443)

at org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLogic(AbstractInOutSyncMessageReceiver.java:45)

at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:114)

at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:178)

at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:173)

at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:144)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)

at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)

at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:67)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.wso2.carbon.bridge.BridgeServlet.service(BridgeServlet.java:154)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)

at java.lang.Thread.run(Thread.java:619)

at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:97)

at org.apache.axiom.om.impl.llom.OMSourcedElementImpl.internalSerialize(OMSourcedElementImpl.java:691)

at org.apache.axiom.om.impl.llom.OMElementImpl.internalSerialize(OMElementImpl.java:965)

at org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.serializeInternally(SOAPEnvelopeImpl.java:283)

at org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.internalSerialize(SOAPEnvelopeImpl.java:245)

at org.apache.axiom.om.impl.llom.OMSerializableImpl.serializeAndConsume(OMSerializableImpl.java:193)

at org.apache.axis2.transport.http.SOAPMessageFormatter.writeTo(SOAPMessageFormatter.java:79)

... 30 more

[Dmitry.]

Just published fresh version t24jdbc-trunk.r130.zip with setFetchSize
support.
This method not applicable for OFS messages, but it does not return
exception anymore.
Regards/