Connection Error

[Saravanan Velu]

  Hi ,

 I am new to T24JDBC.  I have followed the steps as in your doc.

 And while trying to upload the test .dbs file (T24Test.dbs) , I am not able to connect. I am getting the following sql exception.

DS Fault Message: org.t24.driver.T24Driver DS Code: CONNECTION_UNAVAILABLE_ERROR Source Data Service:- Name: T24Test25 Location: \T24Test25.dbs Description: Temenos Test for DataServices 2.5.1 Default Namespace: http://my.namespace Nested Exception:- java.sql.SQLException: org.t24.driver.T24Driver at org.wso2.carbon.dataservices.core.description.config.RDBMSConfig.

I doubt whether something is wrong in my query ?

 <sql>SELECT SENDOFS ENQUIRY.SELECT,,R10USR/123456,%CUSTOMER
                        @ID:EQ  =   set ?1
                 END
        </sql>

Any help on this is mostly appreciated.

Thanks,
Saravanan.

[Dmitry.]

Hi,

I don't see any clear error message.

Try to read logs.

There should be full stack trace.

I can guess the problem in loading driver.

Dmitry

[George Ggyau]

Hello ,

Please share more logs or perhaps ur test dbs file and I might be able to help.

Thanks

Sent from my iPhone

--
You received this message because you are subscribed to the Google Groups "temenos-ofs-jdbc" group.
To unsubscribe from this group and stop receiving emails from it, send an email to temenos-ofs-jd...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Saravanan Velu]

Dears ,

Here is my log ,  and also I have attached the .dbs file.

Many thanks in advance.

DS Fault Message: org.t24.driver.T24Driver
DS Code: CONNECTION_UNAVAILABLE_ERROR
Source Data Service:-
Name: T24Test25
Location: \T24Test25.dbs
Description: Temenos Test for DataServices 2.5.1
Default Namespace: http://my.namespace
Nested Exception:-
java.sql.SQLException: org.t24.driver.T24Driver

    at org.wso2.carbon.dataservices.core.description.config.RDBMSConfig.<init>(RDBMSConfig.java:42)
    at org.wso2.carbon.dataservices.core.description.config.ConfigFactory.getRDBMSConfig(ConfigFactory.java:79)
    at org.wso2.carbon.dataservices.core.description.config.ConfigFactory.createConfig(ConfigFactory.java:51)
    at org.wso2.carbon.dataservices.core.DataServiceFactory.createDataService(DataServiceFactory.java:141)
    at org.wso2.carbon.dataservices.core.DBDeployer.createDBService(DBDeployer.java:755)
    at org.wso2.carbon.dataservices.core.DBDeployer.processService(DBDeployer.java:1106)
    at org.wso2.carbon.dataservices.core.DBDeployer.deploy(DBDeployer.java:174)
    at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:136)
    at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:807)
    at org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.java:144)
    at org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.java:377)
    at org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListener.java:254)
    at org.apache.axis2.deployment.DeploymentEngine.loadServices(DeploymentEngine.java:135)
    at org.wso2.carbon.core.CarbonAxisConfigurator.loadServices(CarbonAxisConfigurator.java:464)
    at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.java:95)
    at org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(CarbonConfigurationContextFactory.java:65)
    at org.wso2.carbon.core.init.CarbonServerManager.initializeCarbon(CarbonServerManager.java:398)
    at org.wso2.carbon.core.init.CarbonServerManager.start(CarbonServerManager.java:219)
    at org.wso2.carbon.core.internal.CarbonCoreServiceComponent.activate(CarbonCoreServiceComponent.java:77)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260)
    at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146)
    at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347)
    at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620)
    at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197)
    at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343)
    at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222)
    at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107)
    at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861)
    at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
    at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148)
    at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:819)
    at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:771)
    at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130)
    at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:214)
    at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:433)
    at org.eclipse.equinox.http.servlet.internal.Activator.registerHttpService(Activator.java:81)
    at org.eclipse.equinox.http.servlet.internal.Activator.addProxyServlet(Activator.java:60)
    at org.eclipse.equinox.http.servlet.internal.ProxyServlet.init(ProxyServlet.java:40)
    at org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.init(DelegationServlet.java:38)
    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1267)
    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1186)
    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1081)
    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5027)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)
Caused by: java.sql.SQLException: org.t24.driver.T24Driver
    at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:254)
    at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
    at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:701)
    at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:635)
    at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
    at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
    at org.wso2.carbon.dataservices.core.description.config.SQLConfig.createConnection(SQLConfig.java:185)
    at org.wso2.carbon.dataservices.core.description.config.SQLConfig.createConnection(SQLConfig.java:171)
    at org.wso2.carbon.dataservices.core.description.config.SQLConfig.initSQLDataSource(SQLConfig.java:152)
    at org.wso2.carbon.dataservices.core.description.config.RDBMSConfig.<init>(RDBMSConfig.java:40)
    ... 54 more
Caused by: java.lang.ClassNotFoundException: org.t24.driver.T24Driver
    at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:501)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:421)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:412)
    at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:270)
    at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:246)
    ... 63 more

[Dmitry Lukyanov]

The main error:

java.lang.ClassNotFoundException: org.t24.driver.T24Driver

So, class not found.

https://code.google.com/p/temenos-ofs-jdbc/wiki/QuickStartWebService

check that you did the following steps:

Put TCClient libraries into

/wso2/wso2dataservices-2.2/repository/components/lib

Put temenos-ofs-jdbc library: t24jdbc.jar into

/wso2/wso2dataservices-2.2/repository/components/lib

Дмитрий

--
Regards,
Dmitry

[Saravanan Velu]

Hi ,

Many thanks for your help .Its very basic mistake I have done, I copied the jar files in the some other wrong folder.

Now its working fine and able to connect to T24.

Kind Regards,
Saravanan.