I am currently migrating from EAServer 4.2 to 6.0.  I am
trying to connect a SQL Server database through an ODBC
connection in EAServer 6.0.  When I set up the data source
and tried to ping the database server, it gives me an error
saying it cannot connect to the database.  I have tried to
change the database type from SQL SERVER to JCM_ODBC and
other multiple things to try to connect, but it still fails.
 The odbc connection is properly set up but I can't seem to
connect through EAServer.  Any help would be appreciated.

Could you please give the log of EAServer6 which is under 
$EAServer6/logs/$machine_name.log
and also the properties of your JCM_ODBC datasource.
Also could you ping the SQL SERVER successfully from "ODBC Data Source 
Administrator" in windows control panel?


<Thomas> wrote in message news:454794ce.43f.1681692777@sybase.com...
>I am currently migrating from EAServer 4.2 to 6.0.  I am
> trying to connect a SQL Server database through an ODBC
> connection in EAServer 6.0.  When I set up the data source
> and tried to ping the database server, it gives me an error
> saying it cannot connect to the database.  I have tried to
> change the database type from SQL SERVER to JCM_ODBC and
> other multiple things to try to connect, but it still fails.
> The odbc connection is properly set up but I can't seem to
> connect through EAServer.  Any help would be appreciated. 

Under the JCM_ODBC connection settings, everything was left
to default except the server name which the database is
actually stored at and the user name and password.

Below is what the log file says after I tried to ping the
database server.

2006-11-01 12:17:03.835 INFO  HttpListener0-5
[SystemException] com.sybase.djc.DataStoreException was
thrown by transaction com.sybase.djc.sql.DataSource.ping()
2006-11-01 12:17:03.835 INFO  HttpListener0-5    
com.sybase.djc.DataStoreException: Connection Failed:
java.sql.SQLException: Unable to obtain connection from the
data source 'QATEST' due to missing DataSource
class or Driver class.
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.sql.ConnectionPool.createConnection(ConnectionPool.java:713)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.sql.ConnectionPool.getConnectionHandle(ConnectionPool.java:223)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.sql.ConnectionPool.getConnection(ConnectionPool.java:190)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.sql.ConnectionPool.getConnection(ConnectionPool.java:154)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.sql.ConnectionWrapper.checkOpen(ConnectionWrapper.java:204)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.sql.ConnectionWrapper.getConnection(ConnectionWrapper.java:177)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.sql.ConnectionWrapper_DJC.createStatement(ConnectionWrapper_DJC.java:25)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.sql.DataSource.ping(DataSource.java:1729)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.sql.DataSource_DJC.access$101(DataSource_DJC.java:4)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.sql.DataSource_DJC$2.invoke(DataSource_DJC.java:2199)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:844)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:739)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.sql.DataSource_DJC.ping(DataSource_DJC.java:2210)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.management.beans.EASDataSource.ping(EASDataSource.java:83)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
java.lang.reflect.Method.invoke(Method.java:324)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.management.beans.J2EEManagedObject.invoke(J2EEManagedObject.java:178)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
mx4j.server.interceptor.InvokerMBeanServerInterceptor.invoke(InvokerMBeanServerInterceptor.java:221)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:120)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
mx4j.server.interceptor.SecurityMBeanServerInterceptor.invoke(SecurityMBeanServerInterceptor.java:84)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:120)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:120)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
mx4j.server.interceptor.ContextClassLoaderMBeanServerInterceptor.invoke(ContextClassLoaderMBeanServerInterceptor.java:203)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:1043)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.management.beans.ManagementBean.invoke(ManagementBean.java:279)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.management.console.easmgm.ConnectionProfiles.invoke(ConnectionProfiles.java:179)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.management.console.easmgm.EASMBeanNode.performOperation(EASMBeanNode.java:385)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.management.console.TreeAction.performAction(TreeAction.java:306)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.management.console.TreeAction.execute(TreeAction.java:138)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
javax.servlet.http.HttpServlet.service(HttpServlet.java:596)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
web.components.console.console.action.service(action.java:28)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
web.components.console.console.action_DJC.access$201(action_DJC.java:4)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
web.components.console.console.action_DJC$3.invoke(action_DJC.java:310)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.transaction.TransactionManager.invokeNotSupported1(TransactionManager.java:654)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.transaction.TransactionManager.invokeBeanManaged(TransactionManager.java:589)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
web.components.console.console.action_DJC.service(action_DJC.java:339)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
web.components.console.console.action$WC.service(action$WC.java:24)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:170)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.server.jetty.WebApplicationHandler.dispatch(WebApplicationHandler.java:157)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.server.jetty.WebApplicationHandler.handle(WebApplicationHandler.java:115)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.http.HttpServer.service(HttpServer.java:909)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.server.jetty.HttpListener.handleConnection(HttpListener.java:107)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
2006-11-01 12:17:03.835 INFO  HttpListener0-5     Caused by:
java.sql.SQLException: Unable to obtain connection from the
data source 'QATEST' due to missing DataSource
class or Driver class.
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.sql.ConnectionPool.newConnection(ConnectionPool.java:752)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
com.sybase.djc.sql.ConnectionPool.createConnection(ConnectionPool.java:685)
2006-11-01 12:17:03.835 INFO  HttpListener0-5         ... 63
more
2006-11-01 12:17:03.835 ERROR HttpListener0-5
[ManagementBeans] Caught Exception:
com.sybase.djc.transaction.TransactionRolledbackSystemException:
com.sybase.djc.sql.DataSource.ping()
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:1024)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:739)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.sql.DataSource_DJC.ping(DataSource_DJC.java:2210)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.management.beans.EASDataSource.ping(EASDataSource.java:83)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
java.lang.reflect.Method.invoke(Method.java:324)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.management.beans.J2EEManagedObject.invoke(J2EEManagedObject.java:178)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
mx4j.server.interceptor.InvokerMBeanServerInterceptor.invoke(InvokerMBeanServerInterceptor.java:221)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:120)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
mx4j.server.interceptor.SecurityMBeanServerInterceptor.invoke(SecurityMBeanServerInterceptor.java:84)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:120)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:120)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
mx4j.server.interceptor.ContextClassLoaderMBeanServerInterceptor.invoke(ContextClassLoaderMBeanServerInterceptor.java:203)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:1043)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.management.beans.ManagementBean.invoke(ManagementBean.java:279)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.management.console.easmgm.ConnectionProfiles.invoke(ConnectionProfiles.java:179)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.management.console.easmgm.EASMBeanNode.performOperation(EASMBeanNode.java:385)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.management.console.TreeAction.performAction(TreeAction.java:306)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.management.console.TreeAction.execute(TreeAction.java:138)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
javax.servlet.http.HttpServlet.service(HttpServlet.java:596)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
web.components.console.console.action.service(action.java:28)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
web.components.console.console.action_DJC.access$201(action_DJC.java:4)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
web.components.console.console.action_DJC$3.invoke(action_DJC.java:310)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.transaction.TransactionManager.invokeNotSupported1(TransactionManager.java:654)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.transaction.TransactionManager.invokeBeanManaged(TransactionManager.java:589)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
web.components.console.console.action_DJC.service(action_DJC.java:339)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
web.components.console.console.action$WC.service(action$WC.java:24)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:170)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.server.jetty.WebApplicationHandler.dispatch(WebApplicationHandler.java:157)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.server.jetty.WebApplicationHandler.handle(WebApplicationHandler.java:115)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.http.HttpServer.service(HttpServer.java:909)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.server.jetty.HttpListener.handleConnection(HttpListener.java:107)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
2006-11-01 12:17:03.835 ERROR HttpListener0-5     Caused by:
com.sybase.djc.DataStoreException: Connection Failed:
java.sql.SQLException: Unable to obtain connection from the
data source 'QATEST' due to missing DataSource
class or Driver class.
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.sql.ConnectionPool.createConnection(ConnectionPool.java:713)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.sql.ConnectionPool.getConnectionHandle(ConnectionPool.java:223)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.sql.ConnectionPool.getConnection(ConnectionPool.java:190)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.sql.ConnectionPool.getConnection(ConnectionPool.java:154)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.sql.ConnectionWrapper.checkOpen(ConnectionWrapper.java:204)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.sql.ConnectionWrapper.getConnection(ConnectionWrapper.java:177)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.sql.ConnectionWrapper_DJC.createStatement(ConnectionWrapper_DJC.java:25)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.sql.DataSource.ping(DataSource.java:1729)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.sql.DataSource_DJC.access$101(DataSource_DJC.java:4)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.sql.DataSource_DJC$2.invoke(DataSource_DJC.java:2199)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:844)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         ... 53
more
2006-11-01 12:17:03.835 ERROR HttpListener0-5     Caused by:
java.sql.SQLException: Unable to obtain connection from the
data source 'QATEST' due to missing DataSource
class or Driver class.
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.sql.ConnectionPool.newConnection(ConnectionPool.java:752)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
com.sybase.djc.sql.ConnectionPool.createConnection(ConnectionPool.java:685)
2006-11-01 12:17:03.835 ERROR HttpListener0-5         ... 63
more

The key part seems to be 'due to missing DataSource class or Driver class'. 
Can you check those?

<Thomas C.> wrote in message news:4548e705.1828.1681692777@sybase.com...
> Under the JCM_ODBC connection settings, everything was left
> to default except the server name which the database is
> actually stored at and the user name and password.
>
> Below is what the log file says after I tried to ping the
> database server.
>
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> [SystemException] com.sybase.djc.DataStoreException was
> thrown by transaction com.sybase.djc.sql.DataSource.ping()
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> com.sybase.djc.DataStoreException: Connection Failed:
> java.sql.SQLException: Unable to obtain connection from the
> data source &apos;QATEST&apos; due to missing DataSource
> class or Driver class.
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.createConnection(ConnectionPool.java:713)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.getConnectionHandle(ConnectionPool.java:223)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.getConnection(ConnectionPool.java:190)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.getConnection(ConnectionPool.java:154)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.sql.ConnectionWrapper.checkOpen(ConnectionWrapper.java:204)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.sql.ConnectionWrapper.getConnection(ConnectionWrapper.java:177)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.sql.ConnectionWrapper_DJC.createStatement(ConnectionWrapper_DJC.java:25)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.sql.DataSource.ping(DataSource.java:1729)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.sql.DataSource_DJC.access$101(DataSource_DJC.java:4)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.sql.DataSource_DJC$2.invoke(DataSource_DJC.java:2199)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:844)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:739)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.sql.DataSource_DJC.ping(DataSource_DJC.java:2210)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.management.beans.EASDataSource.ping(EASDataSource.java:83)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> java.lang.reflect.Method.invoke(Method.java:324)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.management.beans.J2EEManagedObject.invoke(J2EEManagedObject.java:178)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> mx4j.server.interceptor.InvokerMBeanServerInterceptor.invoke(InvokerMBeanServerInterceptor.java:221)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:120)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> mx4j.server.interceptor.SecurityMBeanServerInterceptor.invoke(SecurityMBeanServerInterceptor.java:84)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:120)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:120)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> mx4j.server.interceptor.ContextClassLoaderMBeanServerInterceptor.invoke(ContextClassLoaderMBeanServerInterceptor.java:203)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:1043)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.management.beans.ManagementBean.invoke(ManagementBean.java:279)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.management.console.easmgm.ConnectionProfiles.invoke(ConnectionProfiles.java:179)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.management.console.easmgm.EASMBeanNode.performOperation(EASMBeanNode.java:385)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.management.console.TreeAction.performAction(TreeAction.java:306)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.management.console.TreeAction.execute(TreeAction.java:138)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:596)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> web.components.console.console.action.service(action.java:28)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> web.components.console.console.action_DJC.access$201(action_DJC.java:4)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> web.components.console.console.action_DJC$3.invoke(action_DJC.java:310)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.transaction.TransactionManager.invokeNotSupported1(TransactionManager.java:654)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.transaction.TransactionManager.invokeBeanManaged(TransactionManager.java:589)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> web.components.console.console.action_DJC.service(action_DJC.java:339)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> web.components.console.console.action$WC.service(action$WC.java:24)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:170)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.server.jetty.WebApplicationHandler.dispatch(WebApplicationHandler.java:157)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.server.jetty.WebApplicationHandler.handle(WebApplicationHandler.java:115)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.http.HttpServer.service(HttpServer.java:909)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.server.jetty.HttpListener.handleConnection(HttpListener.java:107)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5     Caused by:
> java.sql.SQLException: Unable to obtain connection from the
> data source &apos;QATEST&apos; due to missing DataSource
> class or Driver class.
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.newConnection(ConnectionPool.java:752)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.createConnection(ConnectionPool.java:685)
> 2006-11-01 12:17:03.835 INFO  HttpListener0-5         ... 63
> more
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> [ManagementBeans] Caught Exception:
> com.sybase.djc.transaction.TransactionRolledbackSystemException:
> com.sybase.djc.sql.DataSource.ping()
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:1024)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:739)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.sql.DataSource_DJC.ping(DataSource_DJC.java:2210)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.management.beans.EASDataSource.ping(EASDataSource.java:83)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> java.lang.reflect.Method.invoke(Method.java:324)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.management.beans.J2EEManagedObject.invoke(J2EEManagedObject.java:178)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> mx4j.server.interceptor.InvokerMBeanServerInterceptor.invoke(InvokerMBeanServerInterceptor.java:221)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:120)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> mx4j.server.interceptor.SecurityMBeanServerInterceptor.invoke(SecurityMBeanServerInterceptor.java:84)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:120)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:120)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> mx4j.server.interceptor.ContextClassLoaderMBeanServerInterceptor.invoke(ContextClassLoaderMBeanServerInterceptor.java:203)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:1043)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.management.beans.ManagementBean.invoke(ManagementBean.java:279)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.management.console.easmgm.ConnectionProfiles.invoke(ConnectionProfiles.java:179)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.management.console.easmgm.EASMBeanNode.performOperation(EASMBeanNode.java:385)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.management.console.TreeAction.performAction(TreeAction.java:306)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.management.console.TreeAction.execute(TreeAction.java:138)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:596)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> web.components.console.console.action.service(action.java:28)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> web.components.console.console.action_DJC.access$201(action_DJC.java:4)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> web.components.console.console.action_DJC$3.invoke(action_DJC.java:310)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.transaction.TransactionManager.invokeNotSupported1(TransactionManager.java:654)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.transaction.TransactionManager.invokeBeanManaged(TransactionManager.java:589)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> web.components.console.console.action_DJC.service(action_DJC.java:339)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> web.components.console.console.action$WC.service(action$WC.java:24)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:170)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.server.jetty.WebApplicationHandler.dispatch(WebApplicationHandler.java:157)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.server.jetty.WebApplicationHandler.handle(WebApplicationHandler.java:115)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.http.HttpServer.service(HttpServer.java:909)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.server.jetty.HttpListener.handleConnection(HttpListener.java:107)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5     Caused by:
> com.sybase.djc.DataStoreException: Connection Failed:
> java.sql.SQLException: Unable to obtain connection from the
> data source &apos;QATEST&apos; due to missing DataSource
> class or Driver class.
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.createConnection(ConnectionPool.java:713)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.getConnectionHandle(ConnectionPool.java:223)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.getConnection(ConnectionPool.java:190)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.getConnection(ConnectionPool.java:154)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.sql.ConnectionWrapper.checkOpen(ConnectionWrapper.java:204)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.sql.ConnectionWrapper.getConnection(ConnectionWrapper.java:177)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.sql.ConnectionWrapper_DJC.createStatement(ConnectionWrapper_DJC.java:25)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.sql.DataSource.ping(DataSource.java:1729)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.sql.DataSource_DJC.access$101(DataSource_DJC.java:4)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.sql.DataSource_DJC$2.invoke(DataSource_DJC.java:2199)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:844)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         ... 53
> more
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5     Caused by:
> java.sql.SQLException: Unable to obtain connection from the
> data source &apos;QATEST&apos; due to missing DataSource
> class or Driver class.
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.newConnection(ConnectionPool.java:752)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.createConnection(ConnectionPool.java:685)
> 2006-11-01 12:17:03.835 ERROR HttpListener0-5         ... 63
> more 

Where are we supposed to enter the datasource class or the
driver class.  I know currently in EAServer 4.2.2 you can
actually enter a driver class, ex. in our case odbc32.dll,
but there isn't a place to enter it in 6.0.  I have checked
the odbc connection and the connection is good through
windows odbc control manager.

> The key part seems to be 'due to missing DataSource class
> or Driver class'.  Can you check those?
>
> <Thomas C.> wrote in message
> > news:4548e705.1828.1681692777@sybase.com... Under the
> > JCM_ODBC connection settings, everything was left to
> > default except the server name which the database is
> actually stored at and the user name and password. >
> > Below is what the log file says after I tried to ping
> > the database server.
> >
> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > [SystemException] com.sybase.djc.DataStoreException was
> > thrown by transaction
> > com.sybase.djc.sql.DataSource.ping() 2006-11-01
> > 12:17:03.835 INFO  HttpListener0-5
> > com.sybase.djc.DataStoreException: Connection Failed:
> java.sql.SQLException: Unable to obtain connection from
> > the data source &apos;QATEST&apos; due to missing
> > DataSource class or Driver class.
> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> >
> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
> > ionPool.java:713) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.getConnectionHandle(Conn
> > ectionPool.java:223) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
> > Pool.java:190) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
> > Pool.java:154) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> com.sybase.djc.sql.ConnectionWrapper.checkOpen(ConnectionW
> > rapper.java:204) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> com.sybase.djc.sql.ConnectionWrapper.getConnection(Connect
> > ionWrapper.java:177) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> com.sybase.djc.sql.ConnectionWrapper_DJC.createStatement(C
> > onnectionWrapper_DJC.java:25) 2006-11-01 12:17:03.835
> > INFO  HttpListener0-5         at
> > com.sybase.djc.sql.DataSource.ping(DataSource.java:1729)
> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.sql.DataSource_DJC.access$101(DataSource_DJ
> > C.java:4) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >        at
> com.sybase.djc.sql.DataSource_DJC$2.invoke(DataSource_DJC.
> > java:2199) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >         at
> com.sybase.djc.transaction.TransactionManager.invokeRequir
> > esNew(TransactionManager.java:844) 2006-11-01
> > 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.transaction.TransactionManager.invokeRequir
> > esNew(TransactionManager.java:739) 2006-11-01
> > 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.sql.DataSource_DJC.ping(DataSource_DJC.java
> > :2210) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >     at
> com.sybase.djc.management.beans.EASDataSource.ping(EASData
> > Source.java:83) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > Method) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >      at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAc
> > cessorImpl.java:39) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegating
> > MethodAccessorImpl.java:25) 2006-11-01 12:17:03.835 INFO
> >  HttpListener0-5         at
> > java.lang.reflect.Method.invoke(Method.java:324)
> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.management.beans.J2EEManagedObject.invoke(J
> > 2EEManagedObject.java:178) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> mx4j.server.interceptor.InvokerMBeanServerInterceptor.invo
> > ke(InvokerMBeanServerInterceptor.java:221) 2006-11-01
> > 12:17:03.835 INFO  HttpListener0-5         at
> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> > 12:17:03.835 INFO  HttpListener0-5         at
> mx4j.server.interceptor.SecurityMBeanServerInterceptor.inv
> > oke(SecurityMBeanServerInterceptor.java:84) 2006-11-01
> > 12:17:03.835 INFO  HttpListener0-5         at
> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> > 12:17:03.835 INFO  HttpListener0-5         at
> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> > 12:17:03.835 INFO  HttpListener0-5         at
> mx4j.server.interceptor.ContextClassLoaderMBeanServerInter
> ceptor.invoke(ContextClassLoaderMBeanServerInterceptor.jav
> > a:203) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >     at
> mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:10
> > 43) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >  at
> com.sybase.djc.management.beans.ManagementBean.invoke(Mana
> > gementBean.java:279) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> com.sybase.djc.management.console.easmgm.ConnectionProfile
> > s.invoke(ConnectionProfiles.java:179) 2006-11-01
> > 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.management.console.easmgm.EASMBeanNode.perf
> > ormOperation(EASMBeanNode.java:385) 2006-11-01
> > 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.management.console.TreeAction.performAction
> > (TreeAction.java:306) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> com.sybase.djc.management.console.TreeAction.execute(TreeA
> > ction.java:138) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> org.apache.struts.action.RequestProcessor.processActionPer
> > form(RequestProcessor.java:431) 2006-11-01 12:17:03.835
> > INFO  HttpListener0-5         at
> org.apache.struts.action.RequestProcessor.process(RequestP
> > rocessor.java:236) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> org.apache.struts.action.ActionServlet.process(ActionServl
> > et.java:1196) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet
> > .java:414) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >         at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:59
> > 6) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
> > 9) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > at
> web.components.console.console.action.service(action.java:
> > 28) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >  at
> web.components.console.console.action_DJC.access$201(actio
> > n_DJC.java:4) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> web.components.console.console.action_DJC$3.invoke(action_
> > DJC.java:310) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> com.sybase.djc.transaction.TransactionManager.invokeNotSup
> > ported1(TransactionManager.java:654) 2006-11-01
> > 12:17:03.835 INFO  HttpListener0-5         at
> com.sybase.djc.transaction.TransactionManager.invokeBeanMa
> > naged(TransactionManager.java:589) 2006-11-01
> > 12:17:03.835 INFO  HttpListener0-5         at
> web.components.console.console.action_DJC.service(action_D
> > JC.java:339) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> web.components.console.console.action$WC.service(action$WC
> > .java:24) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >        at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
> > 9) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > at
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHold
> > er.java:428) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
> > n.doFilter(WebApplicationHandler.java:830) 2006-11-01
> > 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filt
> > er.java:170) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
> > n.doFilter(WebApplicationHandler.java:821) 2006-11-01
> > 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(W
> > ebApplicationHandler.java:471) 2006-11-01 12:17:03.835
> > INFO  HttpListener0-5         at
> com.sybase.djc.server.jetty.WebApplicationHandler.dispatch
> > (WebApplicationHandler.java:157) 2006-11-01 12:17:03.835
> > INFO  HttpListener0-5         at
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHan
> > dler.java:568) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> com.sybase.djc.server.jetty.WebApplicationHandler.handle(W
> > ebApplicationHandler.java:115) 2006-11-01 12:17:03.835
> > INFO  HttpListener0-5         at
> >
> org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationContext.handle(Web
> > ApplicationContext.java:633) 2006-11-01 12:17:03.835
> > INFO  HttpListener0-5         at
> >
> org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> > org.mortbay.http.HttpServer.service(HttpServer.java:909)
> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> org.mortbay.http.HttpConnection.service(HttpConnection.jav
> > a:816) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >     at
> org.mortbay.http.HttpConnection.handleNext(HttpConnection.
> > java:982) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >        at
> org.mortbay.http.HttpConnection.handle(HttpConnection.java
> > :833) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >    at
> org.mortbay.http.SocketListener.handleConnection(SocketLis
> > tener.java:244) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> com.sybase.djc.server.jetty.HttpListener.handleConnection(
> > HttpListener.java:107) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java
> > :357) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >    at
> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java
> > :534) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > Caused by: java.sql.SQLException: Unable to obtain
> > connection from the data source &apos;QATEST&apos; due
> > to missing DataSource class or Driver class.
> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> >
> com.sybase.djc.sql.ConnectionPool.newConnection(Connection
> > Pool.java:752) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
> > ionPool.java:685) 2006-11-01 12:17:03.835 INFO
> > HttpListener0-5         ... 63 more
> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > [ManagementBeans] Caught Exception:
> >
> com.sybase.djc.transaction.TransactionRolledbackSystemExce
> > ption: com.sybase.djc.sql.DataSource.ping()
> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> >
> com.sybase.djc.transaction.TransactionManager.invokeRequir
> > esNew(TransactionManager.java:1024) 2006-11-01
> > 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.transaction.TransactionManager.invokeRequir
> > esNew(TransactionManager.java:739) 2006-11-01
> > 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.sql.DataSource_DJC.ping(DataSource_DJC.java
> > :2210) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >     at
> com.sybase.djc.management.beans.EASDataSource.ping(EASData
> > Source.java:83) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > Method) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >      at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAc
> > cessorImpl.java:39) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegating
> > MethodAccessorImpl.java:25) 2006-11-01 12:17:03.835
> > ERROR HttpListener0-5         at
> > java.lang.reflect.Method.invoke(Method.java:324)
> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.management.beans.J2EEManagedObject.invoke(J
> > 2EEManagedObject.java:178) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> mx4j.server.interceptor.InvokerMBeanServerInterceptor.invo
> > ke(InvokerMBeanServerInterceptor.java:221) 2006-11-01
> > 12:17:03.835 ERROR HttpListener0-5         at
> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> > 12:17:03.835 ERROR HttpListener0-5         at
> mx4j.server.interceptor.SecurityMBeanServerInterceptor.inv
> > oke(SecurityMBeanServerInterceptor.java:84) 2006-11-01
> > 12:17:03.835 ERROR HttpListener0-5         at
> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> > 12:17:03.835 ERROR HttpListener0-5         at
> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> > 12:17:03.835 ERROR HttpListener0-5         at
> mx4j.server.interceptor.ContextClassLoaderMBeanServerInter
> ceptor.invoke(ContextClassLoaderMBeanServerInterceptor.jav
> > a:203) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >     at
> mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:10
> > 43) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >  at
> com.sybase.djc.management.beans.ManagementBean.invoke(Mana
> > gementBean.java:279) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> com.sybase.djc.management.console.easmgm.ConnectionProfile
> > s.invoke(ConnectionProfiles.java:179) 2006-11-01
> > 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.management.console.easmgm.EASMBeanNode.perf
> > ormOperation(EASMBeanNode.java:385) 2006-11-01
> > 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.management.console.TreeAction.performAction
> > (TreeAction.java:306) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> com.sybase.djc.management.console.TreeAction.execute(TreeA
> > ction.java:138) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> org.apache.struts.action.RequestProcessor.processActionPer
> > form(RequestProcessor.java:431) 2006-11-01 12:17:03.835
> > ERROR HttpListener0-5         at
> org.apache.struts.action.RequestProcessor.process(RequestP
> > rocessor.java:236) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> org.apache.struts.action.ActionServlet.process(ActionServl
> > et.java:1196) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet
> > .java:414) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >         at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:59
> > 6) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
> > 9) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > at
> web.components.console.console.action.service(action.java:
> > 28) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >  at
> web.components.console.console.action_DJC.access$201(actio
> > n_DJC.java:4) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> web.components.console.console.action_DJC$3.invoke(action_
> > DJC.java:310) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> com.sybase.djc.transaction.TransactionManager.invokeNotSup
> > ported1(TransactionManager.java:654) 2006-11-01
> > 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.transaction.TransactionManager.invokeBeanMa
> > naged(TransactionManager.java:589) 2006-11-01
> > 12:17:03.835 ERROR HttpListener0-5         at
> web.components.console.console.action_DJC.service(action_D
> > JC.java:339) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> web.components.console.console.action$WC.service(action$WC
> > .java:24) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >        at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
> > 9) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > at
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHold
> > er.java:428) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
> > n.doFilter(WebApplicationHandler.java:830) 2006-11-01
> > 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filt
> > er.java:170) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
> > n.doFilter(WebApplicationHandler.java:821) 2006-11-01
> > 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(W
> > ebApplicationHandler.java:471) 2006-11-01 12:17:03.835
> > ERROR HttpListener0-5         at
> com.sybase.djc.server.jetty.WebApplicationHandler.dispatch
> > (WebApplicationHandler.java:157) 2006-11-01 12:17:03.835
> > ERROR HttpListener0-5         at
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHan
> > dler.java:568) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> com.sybase.djc.server.jetty.WebApplicationHandler.handle(W
> > ebApplicationHandler.java:115) 2006-11-01 12:17:03.835
> > ERROR HttpListener0-5         at
> >
> org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.jetty.servlet.WebApplicationContext.handle(Web
> > ApplicationContext.java:633) 2006-11-01 12:17:03.835
> > ERROR HttpListener0-5         at
> >
> org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> > org.mortbay.http.HttpServer.service(HttpServer.java:909)
> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> org.mortbay.http.HttpConnection.service(HttpConnection.jav
> > a:816) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >     at
> org.mortbay.http.HttpConnection.handleNext(HttpConnection.
> > java:982) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >        at
> org.mortbay.http.HttpConnection.handle(HttpConnection.java
> > :833) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >    at
> org.mortbay.http.SocketListener.handleConnection(SocketLis
> > tener.java:244) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> com.sybase.djc.server.jetty.HttpListener.handleConnection(
> > HttpListener.java:107) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java
> > :357) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >    at
> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java
> > :534) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > Caused by: com.sybase.djc.DataStoreException: Connection
> > Failed: java.sql.SQLException: Unable to obtain
> > connection from the data source &apos;QATEST&apos; due
> > to missing DataSource class or Driver class.
> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> >
> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
> > ionPool.java:713) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.getConnectionHandle(Conn
> > ectionPool.java:223) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
> > Pool.java:190) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
> > Pool.java:154) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> com.sybase.djc.sql.ConnectionWrapper.checkOpen(ConnectionW
> > rapper.java:204) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> com.sybase.djc.sql.ConnectionWrapper.getConnection(Connect
> > ionWrapper.java:177) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> com.sybase.djc.sql.ConnectionWrapper_DJC.createStatement(C
> > onnectionWrapper_DJC.java:25) 2006-11-01 12:17:03.835
> > ERROR HttpListener0-5         at
> > com.sybase.djc.sql.DataSource.ping(DataSource.java:1729)
> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> com.sybase.djc.sql.DataSource_DJC.access$101(DataSource_DJ
> > C.java:4) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >        at
> com.sybase.djc.sql.DataSource_DJC$2.invoke(DataSource_DJC.
> > java:2199) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >         at
> com.sybase.djc.transaction.TransactionManager.invokeRequir
> > esNew(TransactionManager.java:844) 2006-11-01
> > 12:17:03.835 ERROR HttpListener0-5         ... 53 more
> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5     Caused
> > by: java.sql.SQLException: Unable to obtain connection
> > from the data source &apos;QATEST&apos; due to missing
> > DataSource class or Driver class.
> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> >
> com.sybase.djc.sql.ConnectionPool.newConnection(Connection
> > Pool.java:752) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         at
> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
> > ionPool.java:685) 2006-11-01 12:17:03.835 ERROR
> > HttpListener0-5         ... 63 more
>
>

If you use JCM_ODBC as "Database Type", you should not need to set 
datasource class or the driver class as driver class will be taken from your 
"Database Type" setting which is com.sybase.jaguar.jcm.odbc.OdbcDriver.
Please check your 
$EAS6\Repository\Instance\com\sybase\djc\sql\DatabaseType\JCM_Odbc.properties:
It should looks like:

.........
driverClass=com.sybase.jaguar.jcm.odbc.OdbcDriver
........
databaseURL=jdbc\:sybase\:jcm\:odbc\:serverName\=${serverName};user\=${user};password\=${password}

"driverClass property is missing from JCM_Odbc.properties" is the only 
reason I could think of for your exception trace. Also please note that any 
change to Database Type requires restart EAServer.


<Thomas C.> wrote in message news:45491051.1a0b.1681692777@sybase.com...
> Where are we supposed to enter the datasource class or the
> driver class.  I know currently in EAServer 4.2.2 you can
> actually enter a driver class, ex. in our case odbc32.dll,
> but there isn't a place to enter it in 6.0.  I have checked
> the odbc connection and the connection is good through
> windows odbc control manager.
>
>> The key part seems to be 'due to missing DataSource class
>> or Driver class'.  Can you check those?
>>
>> <Thomas C.> wrote in message
>> > news:4548e705.1828.1681692777@sybase.com... Under the
>> > JCM_ODBC connection settings, everything was left to
>> > default except the server name which the database is
>> actually stored at and the user name and password. >
>> > Below is what the log file says after I tried to ping
>> > the database server.
>> >
>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> > [SystemException] com.sybase.djc.DataStoreException was
>> > thrown by transaction
>> > com.sybase.djc.sql.DataSource.ping() 2006-11-01
>> > 12:17:03.835 INFO  HttpListener0-5
>> > com.sybase.djc.DataStoreException: Connection Failed:
>> java.sql.SQLException: Unable to obtain connection from
>> > the data source &apos;QATEST&apos; due to missing
>> > DataSource class or Driver class.
>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
>> >
>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
>> > ionPool.java:713) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> com.sybase.djc.sql.ConnectionPool.getConnectionHandle(Conn
>> > ectionPool.java:223) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
>> > Pool.java:190) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
>> > Pool.java:154) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> com.sybase.djc.sql.ConnectionWrapper.checkOpen(ConnectionW
>> > rapper.java:204) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> com.sybase.djc.sql.ConnectionWrapper.getConnection(Connect
>> > ionWrapper.java:177) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> com.sybase.djc.sql.ConnectionWrapper_DJC.createStatement(C
>> > onnectionWrapper_DJC.java:25) 2006-11-01 12:17:03.835
>> > INFO  HttpListener0-5         at
>> > com.sybase.djc.sql.DataSource.ping(DataSource.java:1729)
>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
>> com.sybase.djc.sql.DataSource_DJC.access$101(DataSource_DJ
>> > C.java:4) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> >        at
>> com.sybase.djc.sql.DataSource_DJC$2.invoke(DataSource_DJC.
>> > java:2199) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> >         at
>> com.sybase.djc.transaction.TransactionManager.invokeRequir
>> > esNew(TransactionManager.java:844) 2006-11-01
>> > 12:17:03.835 INFO  HttpListener0-5         at
>> com.sybase.djc.transaction.TransactionManager.invokeRequir
>> > esNew(TransactionManager.java:739) 2006-11-01
>> > 12:17:03.835 INFO  HttpListener0-5         at
>> com.sybase.djc.sql.DataSource_DJC.ping(DataSource_DJC.java
>> > :2210) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> >     at
>> com.sybase.djc.management.beans.EASDataSource.ping(EASData
>> > Source.java:83) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>> > Method) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> >      at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAc
>> > cessorImpl.java:39) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegating
>> > MethodAccessorImpl.java:25) 2006-11-01 12:17:03.835 INFO
>> >  HttpListener0-5         at
>> > java.lang.reflect.Method.invoke(Method.java:324)
>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
>> com.sybase.djc.management.beans.J2EEManagedObject.invoke(J
>> > 2EEManagedObject.java:178) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> mx4j.server.interceptor.InvokerMBeanServerInterceptor.invo
>> > ke(InvokerMBeanServerInterceptor.java:221) 2006-11-01
>> > 12:17:03.835 INFO  HttpListener0-5         at
>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
>> > 12:17:03.835 INFO  HttpListener0-5         at
>> mx4j.server.interceptor.SecurityMBeanServerInterceptor.inv
>> > oke(SecurityMBeanServerInterceptor.java:84) 2006-11-01
>> > 12:17:03.835 INFO  HttpListener0-5         at
>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
>> > 12:17:03.835 INFO  HttpListener0-5         at
>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
>> > 12:17:03.835 INFO  HttpListener0-5         at
>> mx4j.server.interceptor.ContextClassLoaderMBeanServerInter
>> ceptor.invoke(ContextClassLoaderMBeanServerInterceptor.jav
>> > a:203) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> >     at
>> mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:10
>> > 43) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> >  at
>> com.sybase.djc.management.beans.ManagementBean.invoke(Mana
>> > gementBean.java:279) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> com.sybase.djc.management.console.easmgm.ConnectionProfile
>> > s.invoke(ConnectionProfiles.java:179) 2006-11-01
>> > 12:17:03.835 INFO  HttpListener0-5         at
>> com.sybase.djc.management.console.easmgm.EASMBeanNode.perf
>> > ormOperation(EASMBeanNode.java:385) 2006-11-01
>> > 12:17:03.835 INFO  HttpListener0-5         at
>> com.sybase.djc.management.console.TreeAction.performAction
>> > (TreeAction.java:306) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> com.sybase.djc.management.console.TreeAction.execute(TreeA
>> > ction.java:138) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> org.apache.struts.action.RequestProcessor.processActionPer
>> > form(RequestProcessor.java:431) 2006-11-01 12:17:03.835
>> > INFO  HttpListener0-5         at
>> org.apache.struts.action.RequestProcessor.process(RequestP
>> > rocessor.java:236) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> org.apache.struts.action.ActionServlet.process(ActionServl
>> > et.java:1196) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> org.apache.struts.action.ActionServlet.doGet(ActionServlet
>> > .java:414) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> >         at
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:59
>> > 6) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> > at
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
>> > 9) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> > at
>> web.components.console.console.action.service(action.java:
>> > 28) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> >  at
>> web.components.console.console.action_DJC.access$201(actio
>> > n_DJC.java:4) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> web.components.console.console.action_DJC$3.invoke(action_
>> > DJC.java:310) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> com.sybase.djc.transaction.TransactionManager.invokeNotSup
>> > ported1(TransactionManager.java:654) 2006-11-01
>> > 12:17:03.835 INFO  HttpListener0-5         at
>> com.sybase.djc.transaction.TransactionManager.invokeBeanMa
>> > naged(TransactionManager.java:589) 2006-11-01
>> > 12:17:03.835 INFO  HttpListener0-5         at
>> web.components.console.console.action_DJC.service(action_D
>> > JC.java:339) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> web.components.console.console.action$WC.service(action$WC
>> > .java:24) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> >        at
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
>> > 9) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> > at
>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHold
>> > er.java:428) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
>> > n.doFilter(WebApplicationHandler.java:830) 2006-11-01
>> > 12:17:03.835 INFO  HttpListener0-5         at
>> org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filt
>> > er.java:170) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
>> > n.doFilter(WebApplicationHandler.java:821) 2006-11-01
>> > 12:17:03.835 INFO  HttpListener0-5         at
>> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(W
>> > ebApplicationHandler.java:471) 2006-11-01 12:17:03.835
>> > INFO  HttpListener0-5         at
>> com.sybase.djc.server.jetty.WebApplicationHandler.dispatch
>> > (WebApplicationHandler.java:157) 2006-11-01 12:17:03.835
>> > INFO  HttpListener0-5         at
>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHan
>> > dler.java:568) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> com.sybase.djc.server.jetty.WebApplicationHandler.handle(W
>> > ebApplicationHandler.java:115) 2006-11-01 12:17:03.835
>> > INFO  HttpListener0-5         at
>> >
>> org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
>> org.mortbay.jetty.servlet.WebApplicationContext.handle(Web
>> > ApplicationContext.java:633) 2006-11-01 12:17:03.835
>> > INFO  HttpListener0-5         at
>> >
>> org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
>> > org.mortbay.http.HttpServer.service(HttpServer.java:909)
>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
>> org.mortbay.http.HttpConnection.service(HttpConnection.jav
>> > a:816) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> >     at
>> org.mortbay.http.HttpConnection.handleNext(HttpConnection.
>> > java:982) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> >        at
>> org.mortbay.http.HttpConnection.handle(HttpConnection.java
>> > :833) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> >    at
>> org.mortbay.http.SocketListener.handleConnection(SocketLis
>> > tener.java:244) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> com.sybase.djc.server.jetty.HttpListener.handleConnection(
>> > HttpListener.java:107) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java
>> > :357) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> >    at
>> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java
>> > :534) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>> > Caused by: java.sql.SQLException: Unable to obtain
>> > connection from the data source &apos;QATEST&apos; due
>> > to missing DataSource class or Driver class.
>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
>> >
>> com.sybase.djc.sql.ConnectionPool.newConnection(Connection
>> > Pool.java:752) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         at
>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
>> > ionPool.java:685) 2006-11-01 12:17:03.835 INFO
>> > HttpListener0-5         ... 63 more
>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> > [ManagementBeans] Caught Exception:
>> >
>> com.sybase.djc.transaction.TransactionRolledbackSystemExce
>> > ption: com.sybase.djc.sql.DataSource.ping()
>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>> >
>> com.sybase.djc.transaction.TransactionManager.invokeRequir
>> > esNew(TransactionManager.java:1024) 2006-11-01
>> > 12:17:03.835 ERROR HttpListener0-5         at
>> com.sybase.djc.transaction.TransactionManager.invokeRequir
>> > esNew(TransactionManager.java:739) 2006-11-01
>> > 12:17:03.835 ERROR HttpListener0-5         at
>> com.sybase.djc.sql.DataSource_DJC.ping(DataSource_DJC.java
>> > :2210) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> >     at
>> com.sybase.djc.management.beans.EASDataSource.ping(EASData
>> > Source.java:83) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>> > Method) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> >      at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAc
>> > cessorImpl.java:39) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegating
>> > MethodAccessorImpl.java:25) 2006-11-01 12:17:03.835
>> > ERROR HttpListener0-5         at
>> > java.lang.reflect.Method.invoke(Method.java:324)
>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>> com.sybase.djc.management.beans.J2EEManagedObject.invoke(J
>> > 2EEManagedObject.java:178) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> mx4j.server.interceptor.InvokerMBeanServerInterceptor.invo
>> > ke(InvokerMBeanServerInterceptor.java:221) 2006-11-01
>> > 12:17:03.835 ERROR HttpListener0-5         at
>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
>> > 12:17:03.835 ERROR HttpListener0-5         at
>> mx4j.server.interceptor.SecurityMBeanServerInterceptor.inv
>> > oke(SecurityMBeanServerInterceptor.java:84) 2006-11-01
>> > 12:17:03.835 ERROR HttpListener0-5         at
>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
>> > 12:17:03.835 ERROR HttpListener0-5         at
>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
>> > 12:17:03.835 ERROR HttpListener0-5         at
>> mx4j.server.interceptor.ContextClassLoaderMBeanServerInter
>> ceptor.invoke(ContextClassLoaderMBeanServerInterceptor.jav
>> > a:203) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> >     at
>> mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:10
>> > 43) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> >  at
>> com.sybase.djc.management.beans.ManagementBean.invoke(Mana
>> > gementBean.java:279) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> com.sybase.djc.management.console.easmgm.ConnectionProfile
>> > s.invoke(ConnectionProfiles.java:179) 2006-11-01
>> > 12:17:03.835 ERROR HttpListener0-5         at
>> com.sybase.djc.management.console.easmgm.EASMBeanNode.perf
>> > ormOperation(EASMBeanNode.java:385) 2006-11-01
>> > 12:17:03.835 ERROR HttpListener0-5         at
>> com.sybase.djc.management.console.TreeAction.performAction
>> > (TreeAction.java:306) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> com.sybase.djc.management.console.TreeAction.execute(TreeA
>> > ction.java:138) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> org.apache.struts.action.RequestProcessor.processActionPer
>> > form(RequestProcessor.java:431) 2006-11-01 12:17:03.835
>> > ERROR HttpListener0-5         at
>> org.apache.struts.action.RequestProcessor.process(RequestP
>> > rocessor.java:236) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> org.apache.struts.action.ActionServlet.process(ActionServl
>> > et.java:1196) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> org.apache.struts.action.ActionServlet.doGet(ActionServlet
>> > .java:414) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> >         at
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:59
>> > 6) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> > at
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
>> > 9) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> > at
>> web.components.console.console.action.service(action.java:
>> > 28) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> >  at
>> web.components.console.console.action_DJC.access$201(actio
>> > n_DJC.java:4) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> web.components.console.console.action_DJC$3.invoke(action_
>> > DJC.java:310) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> com.sybase.djc.transaction.TransactionManager.invokeNotSup
>> > ported1(TransactionManager.java:654) 2006-11-01
>> > 12:17:03.835 ERROR HttpListener0-5         at
>> com.sybase.djc.transaction.TransactionManager.invokeBeanMa
>> > naged(TransactionManager.java:589) 2006-11-01
>> > 12:17:03.835 ERROR HttpListener0-5         at
>> web.components.console.console.action_DJC.service(action_D
>> > JC.java:339) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> web.components.console.console.action$WC.service(action$WC
>> > .java:24) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> >        at
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
>> > 9) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> > at
>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHold
>> > er.java:428) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
>> > n.doFilter(WebApplicationHandler.java:830) 2006-11-01
>> > 12:17:03.835 ERROR HttpListener0-5         at
>> org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filt
>> > er.java:170) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
>> > n.doFilter(WebApplicationHandler.java:821) 2006-11-01
>> > 12:17:03.835 ERROR HttpListener0-5         at
>> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(W
>> > ebApplicationHandler.java:471) 2006-11-01 12:17:03.835
>> > ERROR HttpListener0-5         at
>> com.sybase.djc.server.jetty.WebApplicationHandler.dispatch
>> > (WebApplicationHandler.java:157) 2006-11-01 12:17:03.835
>> > ERROR HttpListener0-5         at
>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHan
>> > dler.java:568) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> com.sybase.djc.server.jetty.WebApplicationHandler.handle(W
>> > ebApplicationHandler.java:115) 2006-11-01 12:17:03.835
>> > ERROR HttpListener0-5         at
>> >
>> org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>> org.mortbay.jetty.servlet.WebApplicationContext.handle(Web
>> > ApplicationContext.java:633) 2006-11-01 12:17:03.835
>> > ERROR HttpListener0-5         at
>> >
>> org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>> > org.mortbay.http.HttpServer.service(HttpServer.java:909)
>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>> org.mortbay.http.HttpConnection.service(HttpConnection.jav
>> > a:816) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> >     at
>> org.mortbay.http.HttpConnection.handleNext(HttpConnection.
>> > java:982) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> >        at
>> org.mortbay.http.HttpConnection.handle(HttpConnection.java
>> > :833) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> >    at
>> org.mortbay.http.SocketListener.handleConnection(SocketLis
>> > tener.java:244) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> com.sybase.djc.server.jetty.HttpListener.handleConnection(
>> > HttpListener.java:107) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java
>> > :357) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> >    at
>> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java
>> > :534) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> > Caused by: com.sybase.djc.DataStoreException: Connection
>> > Failed: java.sql.SQLException: Unable to obtain
>> > connection from the data source &apos;QATEST&apos; due
>> > to missing DataSource class or Driver class.
>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>> >
>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
>> > ionPool.java:713) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> com.sybase.djc.sql.ConnectionPool.getConnectionHandle(Conn
>> > ectionPool.java:223) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
>> > Pool.java:190) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
>> > Pool.java:154) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> com.sybase.djc.sql.ConnectionWrapper.checkOpen(ConnectionW
>> > rapper.java:204) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> com.sybase.djc.sql.ConnectionWrapper.getConnection(Connect
>> > ionWrapper.java:177) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> com.sybase.djc.sql.ConnectionWrapper_DJC.createStatement(C
>> > onnectionWrapper_DJC.java:25) 2006-11-01 12:17:03.835
>> > ERROR HttpListener0-5         at
>> > com.sybase.djc.sql.DataSource.ping(DataSource.java:1729)
>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>> com.sybase.djc.sql.DataSource_DJC.access$101(DataSource_DJ
>> > C.java:4) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> >        at
>> com.sybase.djc.sql.DataSource_DJC$2.invoke(DataSource_DJC.
>> > java:2199) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>> >         at
>> com.sybase.djc.transaction.TransactionManager.invokeRequir
>> > esNew(TransactionManager.java:844) 2006-11-01
>> > 12:17:03.835 ERROR HttpListener0-5         ... 53 more
>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5     Caused
>> > by: java.sql.SQLException: Unable to obtain connection
>> > from the data source &apos;QATEST&apos; due to missing
>> > DataSource class or Driver class.
>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>> >
>> com.sybase.djc.sql.ConnectionPool.newConnection(Connection
>> > Pool.java:752) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         at
>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
>> > ionPool.java:685) 2006-11-01 12:17:03.835 ERROR
>> > HttpListener0-5         ... 63 more
>>
>> 

Just an small comment

com.sybase.jaguar.jcm.odbc.OdbcDriver is not in the djc-all.jar, the values 
shoud be without the odbc, like next:

driverClass=com.sybase.jaguar.jcm.OdbcDriver

Regards

-- 

Alexander Pire
PowerObjects
www.powerobjects.com
612.339.3355
**IT Solutions - Outside the Box**


"gpzhang" <gpzhang@sybase.com> wrote in message 
news:454953e9@forums-1-dub...
> If you use JCM_ODBC as "Database Type", you should not need to set 
> datasource class or the driver class as driver class will be taken from 
> your "Database Type" setting which is 
> com.sybase.jaguar.jcm.odbc.OdbcDriver.
> Please check your 
> $EAS6\Repository\Instance\com\sybase\djc\sql\DatabaseType\JCM_Odbc.properties:
> It should looks like:
>
> ........
> driverClass=com.sybase.jaguar.jcm.odbc.OdbcDriver
> .......
> databaseURL=jdbc\:sybase\:jcm\:odbc\:serverName\=${serverName};user\=${user};password\=${password}
>
> "driverClass property is missing from JCM_Odbc.properties" is the only 
> reason I could think of for your exception trace. Also please note that 
> any change to Database Type requires restart EAServer.
>
>
> <Thomas C.> wrote in message news:45491051.1a0b.1681692777@sybase.com...
>> Where are we supposed to enter the datasource class or the
>> driver class.  I know currently in EAServer 4.2.2 you can
>> actually enter a driver class, ex. in our case odbc32.dll,
>> but there isn't a place to enter it in 6.0.  I have checked
>> the odbc connection and the connection is good through
>> windows odbc control manager.
>>
>>> The key part seems to be 'due to missing DataSource class
>>> or Driver class'.  Can you check those?
>>>
>>> <Thomas C.> wrote in message
>>> > news:4548e705.1828.1681692777@sybase.com... Under the
>>> > JCM_ODBC connection settings, everything was left to
>>> > default except the server name which the database is
>>> actually stored at and the user name and password. >
>>> > Below is what the log file says after I tried to ping
>>> > the database server.
>>> >
>>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> > [SystemException] com.sybase.djc.DataStoreException was
>>> > thrown by transaction
>>> > com.sybase.djc.sql.DataSource.ping() 2006-11-01
>>> > 12:17:03.835 INFO  HttpListener0-5
>>> > com.sybase.djc.DataStoreException: Connection Failed:
>>> java.sql.SQLException: Unable to obtain connection from
>>> > the data source &apos;QATEST&apos; due to missing
>>> > DataSource class or Driver class.
>>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
>>> >
>>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
>>> > ionPool.java:713) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> com.sybase.djc.sql.ConnectionPool.getConnectionHandle(Conn
>>> > ectionPool.java:223) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
>>> > Pool.java:190) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
>>> > Pool.java:154) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> com.sybase.djc.sql.ConnectionWrapper.checkOpen(ConnectionW
>>> > rapper.java:204) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> com.sybase.djc.sql.ConnectionWrapper.getConnection(Connect
>>> > ionWrapper.java:177) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> com.sybase.djc.sql.ConnectionWrapper_DJC.createStatement(C
>>> > onnectionWrapper_DJC.java:25) 2006-11-01 12:17:03.835
>>> > INFO  HttpListener0-5         at
>>> > com.sybase.djc.sql.DataSource.ping(DataSource.java:1729)
>>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
>>> com.sybase.djc.sql.DataSource_DJC.access$101(DataSource_DJ
>>> > C.java:4) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> >        at
>>> com.sybase.djc.sql.DataSource_DJC$2.invoke(DataSource_DJC.
>>> > java:2199) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> >         at
>>> com.sybase.djc.transaction.TransactionManager.invokeRequir
>>> > esNew(TransactionManager.java:844) 2006-11-01
>>> > 12:17:03.835 INFO  HttpListener0-5         at
>>> com.sybase.djc.transaction.TransactionManager.invokeRequir
>>> > esNew(TransactionManager.java:739) 2006-11-01
>>> > 12:17:03.835 INFO  HttpListener0-5         at
>>> com.sybase.djc.sql.DataSource_DJC.ping(DataSource_DJC.java
>>> > :2210) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> >     at
>>> com.sybase.djc.management.beans.EASDataSource.ping(EASData
>>> > Source.java:83) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>> > Method) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> >      at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAc
>>> > cessorImpl.java:39) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegating
>>> > MethodAccessorImpl.java:25) 2006-11-01 12:17:03.835 INFO
>>> >  HttpListener0-5         at
>>> > java.lang.reflect.Method.invoke(Method.java:324)
>>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
>>> com.sybase.djc.management.beans.J2EEManagedObject.invoke(J
>>> > 2EEManagedObject.java:178) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> mx4j.server.interceptor.InvokerMBeanServerInterceptor.invo
>>> > ke(InvokerMBeanServerInterceptor.java:221) 2006-11-01
>>> > 12:17:03.835 INFO  HttpListener0-5         at
>>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
>>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
>>> > 12:17:03.835 INFO  HttpListener0-5         at
>>> mx4j.server.interceptor.SecurityMBeanServerInterceptor.inv
>>> > oke(SecurityMBeanServerInterceptor.java:84) 2006-11-01
>>> > 12:17:03.835 INFO  HttpListener0-5         at
>>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
>>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
>>> > 12:17:03.835 INFO  HttpListener0-5         at
>>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
>>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
>>> > 12:17:03.835 INFO  HttpListener0-5         at
>>> mx4j.server.interceptor.ContextClassLoaderMBeanServerInter
>>> ceptor.invoke(ContextClassLoaderMBeanServerInterceptor.jav
>>> > a:203) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> >     at
>>> mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:10
>>> > 43) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> >  at
>>> com.sybase.djc.management.beans.ManagementBean.invoke(Mana
>>> > gementBean.java:279) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> com.sybase.djc.management.console.easmgm.ConnectionProfile
>>> > s.invoke(ConnectionProfiles.java:179) 2006-11-01
>>> > 12:17:03.835 INFO  HttpListener0-5         at
>>> com.sybase.djc.management.console.easmgm.EASMBeanNode.perf
>>> > ormOperation(EASMBeanNode.java:385) 2006-11-01
>>> > 12:17:03.835 INFO  HttpListener0-5         at
>>> com.sybase.djc.management.console.TreeAction.performAction
>>> > (TreeAction.java:306) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> com.sybase.djc.management.console.TreeAction.execute(TreeA
>>> > ction.java:138) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> org.apache.struts.action.RequestProcessor.processActionPer
>>> > form(RequestProcessor.java:431) 2006-11-01 12:17:03.835
>>> > INFO  HttpListener0-5         at
>>> org.apache.struts.action.RequestProcessor.process(RequestP
>>> > rocessor.java:236) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> org.apache.struts.action.ActionServlet.process(ActionServl
>>> > et.java:1196) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> org.apache.struts.action.ActionServlet.doGet(ActionServlet
>>> > .java:414) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> >         at
>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:59
>>> > 6) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> > at
>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
>>> > 9) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> > at
>>> web.components.console.console.action.service(action.java:
>>> > 28) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> >  at
>>> web.components.console.console.action_DJC.access$201(actio
>>> > n_DJC.java:4) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> web.components.console.console.action_DJC$3.invoke(action_
>>> > DJC.java:310) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> com.sybase.djc.transaction.TransactionManager.invokeNotSup
>>> > ported1(TransactionManager.java:654) 2006-11-01
>>> > 12:17:03.835 INFO  HttpListener0-5         at
>>> com.sybase.djc.transaction.TransactionManager.invokeBeanMa
>>> > naged(TransactionManager.java:589) 2006-11-01
>>> > 12:17:03.835 INFO  HttpListener0-5         at
>>> web.components.console.console.action_DJC.service(action_D
>>> > JC.java:339) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> web.components.console.console.action$WC.service(action$WC
>>> > .java:24) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> >        at
>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
>>> > 9) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> > at
>>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHold
>>> > er.java:428) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
>>> > n.doFilter(WebApplicationHandler.java:830) 2006-11-01
>>> > 12:17:03.835 INFO  HttpListener0-5         at
>>> org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filt
>>> > er.java:170) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
>>> > n.doFilter(WebApplicationHandler.java:821) 2006-11-01
>>> > 12:17:03.835 INFO  HttpListener0-5         at
>>> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(W
>>> > ebApplicationHandler.java:471) 2006-11-01 12:17:03.835
>>> > INFO  HttpListener0-5         at
>>> com.sybase.djc.server.jetty.WebApplicationHandler.dispatch
>>> > (WebApplicationHandler.java:157) 2006-11-01 12:17:03.835
>>> > INFO  HttpListener0-5         at
>>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHan
>>> > dler.java:568) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> com.sybase.djc.server.jetty.WebApplicationHandler.handle(W
>>> > ebApplicationHandler.java:115) 2006-11-01 12:17:03.835
>>> > INFO  HttpListener0-5         at
>>> >
>>> org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
>>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
>>> org.mortbay.jetty.servlet.WebApplicationContext.handle(Web
>>> > ApplicationContext.java:633) 2006-11-01 12:17:03.835
>>> > INFO  HttpListener0-5         at
>>> >
>>> org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
>>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
>>> > org.mortbay.http.HttpServer.service(HttpServer.java:909)
>>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
>>> org.mortbay.http.HttpConnection.service(HttpConnection.jav
>>> > a:816) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> >     at
>>> org.mortbay.http.HttpConnection.handleNext(HttpConnection.
>>> > java:982) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> >        at
>>> org.mortbay.http.HttpConnection.handle(HttpConnection.java
>>> > :833) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> >    at
>>> org.mortbay.http.SocketListener.handleConnection(SocketLis
>>> > tener.java:244) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> com.sybase.djc.server.jetty.HttpListener.handleConnection(
>>> > HttpListener.java:107) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java
>>> > :357) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> >    at
>>> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java
>>> > :534) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
>>> > Caused by: java.sql.SQLException: Unable to obtain
>>> > connection from the data source &apos;QATEST&apos; due
>>> > to missing DataSource class or Driver class.
>>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
>>> >
>>> com.sybase.djc.sql.ConnectionPool.newConnection(Connection
>>> > Pool.java:752) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         at
>>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
>>> > ionPool.java:685) 2006-11-01 12:17:03.835 INFO
>>> > HttpListener0-5         ... 63 more
>>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> > [ManagementBeans] Caught Exception:
>>> >
>>> com.sybase.djc.transaction.TransactionRolledbackSystemExce
>>> > ption: com.sybase.djc.sql.DataSource.ping()
>>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>>> >
>>> com.sybase.djc.transaction.TransactionManager.invokeRequir
>>> > esNew(TransactionManager.java:1024) 2006-11-01
>>> > 12:17:03.835 ERROR HttpListener0-5         at
>>> com.sybase.djc.transaction.TransactionManager.invokeRequir
>>> > esNew(TransactionManager.java:739) 2006-11-01
>>> > 12:17:03.835 ERROR HttpListener0-5         at
>>> com.sybase.djc.sql.DataSource_DJC.ping(DataSource_DJC.java
>>> > :2210) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> >     at
>>> com.sybase.djc.management.beans.EASDataSource.ping(EASData
>>> > Source.java:83) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>> > Method) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> >      at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAc
>>> > cessorImpl.java:39) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegating
>>> > MethodAccessorImpl.java:25) 2006-11-01 12:17:03.835
>>> > ERROR HttpListener0-5         at
>>> > java.lang.reflect.Method.invoke(Method.java:324)
>>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>>> com.sybase.djc.management.beans.J2EEManagedObject.invoke(J
>>> > 2EEManagedObject.java:178) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> mx4j.server.interceptor.InvokerMBeanServerInterceptor.invo
>>> > ke(InvokerMBeanServerInterceptor.java:221) 2006-11-01
>>> > 12:17:03.835 ERROR HttpListener0-5         at
>>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
>>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
>>> > 12:17:03.835 ERROR HttpListener0-5         at
>>> mx4j.server.interceptor.SecurityMBeanServerInterceptor.inv
>>> > oke(SecurityMBeanServerInterceptor.java:84) 2006-11-01
>>> > 12:17:03.835 ERROR HttpListener0-5         at
>>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
>>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
>>> > 12:17:03.835 ERROR HttpListener0-5         at
>>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
>>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
>>> > 12:17:03.835 ERROR HttpListener0-5         at
>>> mx4j.server.interceptor.ContextClassLoaderMBeanServerInter
>>> ceptor.invoke(ContextClassLoaderMBeanServerInterceptor.jav
>>> > a:203) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> >     at
>>> mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:10
>>> > 43) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> >  at
>>> com.sybase.djc.management.beans.ManagementBean.invoke(Mana
>>> > gementBean.java:279) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> com.sybase.djc.management.console.easmgm.ConnectionProfile
>>> > s.invoke(ConnectionProfiles.java:179) 2006-11-01
>>> > 12:17:03.835 ERROR HttpListener0-5         at
>>> com.sybase.djc.management.console.easmgm.EASMBeanNode.perf
>>> > ormOperation(EASMBeanNode.java:385) 2006-11-01
>>> > 12:17:03.835 ERROR HttpListener0-5         at
>>> com.sybase.djc.management.console.TreeAction.performAction
>>> > (TreeAction.java:306) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> com.sybase.djc.management.console.TreeAction.execute(TreeA
>>> > ction.java:138) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> org.apache.struts.action.RequestProcessor.processActionPer
>>> > form(RequestProcessor.java:431) 2006-11-01 12:17:03.835
>>> > ERROR HttpListener0-5         at
>>> org.apache.struts.action.RequestProcessor.process(RequestP
>>> > rocessor.java:236) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> org.apache.struts.action.ActionServlet.process(ActionServl
>>> > et.java:1196) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> org.apache.struts.action.ActionServlet.doGet(ActionServlet
>>> > .java:414) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> >         at
>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:59
>>> > 6) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> > at
>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
>>> > 9) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> > at
>>> web.components.console.console.action.service(action.java:
>>> > 28) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> >  at
>>> web.components.console.console.action_DJC.access$201(actio
>>> > n_DJC.java:4) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> web.components.console.console.action_DJC$3.invoke(action_
>>> > DJC.java:310) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> com.sybase.djc.transaction.TransactionManager.invokeNotSup
>>> > ported1(TransactionManager.java:654) 2006-11-01
>>> > 12:17:03.835 ERROR HttpListener0-5         at
>>> com.sybase.djc.transaction.TransactionManager.invokeBeanMa
>>> > naged(TransactionManager.java:589) 2006-11-01
>>> > 12:17:03.835 ERROR HttpListener0-5         at
>>> web.components.console.console.action_DJC.service(action_D
>>> > JC.java:339) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> web.components.console.console.action$WC.service(action$WC
>>> > .java:24) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> >        at
>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
>>> > 9) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> > at
>>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHold
>>> > er.java:428) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
>>> > n.doFilter(WebApplicationHandler.java:830) 2006-11-01
>>> > 12:17:03.835 ERROR HttpListener0-5         at
>>> org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filt
>>> > er.java:170) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
>>> > n.doFilter(WebApplicationHandler.java:821) 2006-11-01
>>> > 12:17:03.835 ERROR HttpListener0-5         at
>>> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(W
>>> > ebApplicationHandler.java:471) 2006-11-01 12:17:03.835
>>> > ERROR HttpListener0-5         at
>>> com.sybase.djc.server.jetty.WebApplicationHandler.dispatch
>>> > (WebApplicationHandler.java:157) 2006-11-01 12:17:03.835
>>> > ERROR HttpListener0-5         at
>>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHan
>>> > dler.java:568) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> com.sybase.djc.server.jetty.WebApplicationHandler.handle(W
>>> > ebApplicationHandler.java:115) 2006-11-01 12:17:03.835
>>> > ERROR HttpListener0-5         at
>>> >
>>> org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
>>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>>> org.mortbay.jetty.servlet.WebApplicationContext.handle(Web
>>> > ApplicationContext.java:633) 2006-11-01 12:17:03.835
>>> > ERROR HttpListener0-5         at
>>> >
>>> org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
>>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>>> > org.mortbay.http.HttpServer.service(HttpServer.java:909)
>>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>>> org.mortbay.http.HttpConnection.service(HttpConnection.jav
>>> > a:816) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> >     at
>>> org.mortbay.http.HttpConnection.handleNext(HttpConnection.
>>> > java:982) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> >        at
>>> org.mortbay.http.HttpConnection.handle(HttpConnection.java
>>> > :833) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> >    at
>>> org.mortbay.http.SocketListener.handleConnection(SocketLis
>>> > tener.java:244) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> com.sybase.djc.server.jetty.HttpListener.handleConnection(
>>> > HttpListener.java:107) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java
>>> > :357) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> >    at
>>> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java
>>> > :534) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> > Caused by: com.sybase.djc.DataStoreException: Connection
>>> > Failed: java.sql.SQLException: Unable to obtain
>>> > connection from the data source &apos;QATEST&apos; due
>>> > to missing DataSource class or Driver class.
>>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>>> >
>>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
>>> > ionPool.java:713) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> com.sybase.djc.sql.ConnectionPool.getConnectionHandle(Conn
>>> > ectionPool.java:223) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
>>> > Pool.java:190) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
>>> > Pool.java:154) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> com.sybase.djc.sql.ConnectionWrapper.checkOpen(ConnectionW
>>> > rapper.java:204) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> com.sybase.djc.sql.ConnectionWrapper.getConnection(Connect
>>> > ionWrapper.java:177) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> com.sybase.djc.sql.ConnectionWrapper_DJC.createStatement(C
>>> > onnectionWrapper_DJC.java:25) 2006-11-01 12:17:03.835
>>> > ERROR HttpListener0-5         at
>>> > com.sybase.djc.sql.DataSource.ping(DataSource.java:1729)
>>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>>> com.sybase.djc.sql.DataSource_DJC.access$101(DataSource_DJ
>>> > C.java:4) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> >        at
>>> com.sybase.djc.sql.DataSource_DJC$2.invoke(DataSource_DJC.
>>> > java:2199) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
>>> >         at
>>> com.sybase.djc.transaction.TransactionManager.invokeRequir
>>> > esNew(TransactionManager.java:844) 2006-11-01
>>> > 12:17:03.835 ERROR HttpListener0-5         ... 53 more
>>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5     Caused
>>> > by: java.sql.SQLException: Unable to obtain connection
>>> > from the data source &apos;QATEST&apos; due to missing
>>> > DataSource class or Driver class.
>>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
>>> >
>>> com.sybase.djc.sql.ConnectionPool.newConnection(Connection
>>> > Pool.java:752) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         at
>>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
>>> > ionPool.java:685) 2006-11-01 12:17:03.835 ERROR
>>> > HttpListener0-5         ... 63 more
>>>
>>>
>
> 

 Does anyone know when/if EAS 6.x will support direct connection to SS2005
using SNC (like PB 10.5.1 and 11.0 do)?
I would think that this would be the best connectivity from the performance
/ ease-of-use point of view?


<Thomas> wrote in message news:454794ce.43f.1681692777@sybase.com...
> I am currently migrating from EAServer 4.2 to 6.0.  I am
> trying to connect a SQL Server database through an ODBC
> connection in EAServer 6.0.  When I set up the data source
> and tried to ping the database server, it gives me an error
> saying it cannot connect to the database.  I have tried to
> change the database type from SQL SERVER to JCM_ODBC and
> other multiple things to try to connect, but it still fails.
>  The odbc connection is properly set up but I can't seem to
> connect through EAServer.  Any help would be appreciated.

Actually it looks like Sybase has changed the location of this class.

In a newer version (6.0.0.93) the driver is in the odbc folder (check if you
have a eas-server-xx.jar and look inside where is the driver, or if you have
in the lib folder djc-all.jar check where is the class).

So after this interesting confution I have to ask you something. Have you
done an upgrade of your EAServer?

--

Alexander Pire
PowerObjects
www.powerobjects.com
612.339.3355
**IT Solutions - Outside the Box**

"Alexander Pire" <Alexander_no_spam_@powerobjects_dot_com> wrote in message
news:45495601@forums-1-dub...
> Just an small comment
>
> com.sybase.jaguar.jcm.odbc.OdbcDriver is not in the djc-all.jar, the
values
> shoud be without the odbc, like next:
>
> driverClass=com.sybase.jaguar.jcm.OdbcDriver
>
> Regards
>
> --
>
> Alexander Pire
> PowerObjects
> www.powerobjects.com
> 612.339.3355
> **IT Solutions - Outside the Box**
>
>
> "gpzhang" <gpzhang@sybase.com> wrote in message
> news:454953e9@forums-1-dub...
> > If you use JCM_ODBC as "Database Type", you should not need to set
> > datasource class or the driver class as driver class will be taken from
> > your "Database Type" setting which is
> > com.sybase.jaguar.jcm.odbc.OdbcDriver.
> > Please check your
> >
$EAS6\Repository\Instance\com\sybase\djc\sql\DatabaseType\JCM_Odbc.propertie
s:
> > It should looks like:
> >
> > ........
> > driverClass=com.sybase.jaguar.jcm.odbc.OdbcDriver
> > .......
> >
databaseURL=jdbc\:sybase\:jcm\:odbc\:serverName\=${serverName};user\=${user}
;password\=${password}
> >
> > "driverClass property is missing from JCM_Odbc.properties" is the only
> > reason I could think of for your exception trace. Also please note that
> > any change to Database Type requires restart EAServer.
> >
> >
> > <Thomas C.> wrote in message news:45491051.1a0b.1681692777@sybase.com...
> >> Where are we supposed to enter the datasource class or the
> >> driver class.  I know currently in EAServer 4.2.2 you can
> >> actually enter a driver class, ex. in our case odbc32.dll,
> >> but there isn't a place to enter it in 6.0.  I have checked
> >> the odbc connection and the connection is good through
> >> windows odbc control manager.
> >>
> >>> The key part seems to be 'due to missing DataSource class
> >>> or Driver class'.  Can you check those?
> >>>
> >>> <Thomas C.> wrote in message
> >>> > news:4548e705.1828.1681692777@sybase.com... Under the
> >>> > JCM_ODBC connection settings, everything was left to
> >>> > default except the server name which the database is
> >>> actually stored at and the user name and password. >
> >>> > Below is what the log file says after I tried to ping
> >>> > the database server.
> >>> >
> >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> > [SystemException] com.sybase.djc.DataStoreException was
> >>> > thrown by transaction
> >>> > com.sybase.djc.sql.DataSource.ping() 2006-11-01
> >>> > 12:17:03.835 INFO  HttpListener0-5
> >>> > com.sybase.djc.DataStoreException: Connection Failed:
> >>> java.sql.SQLException: Unable to obtain connection from
> >>> > the data source &apos;QATEST&apos; due to missing
> >>> > DataSource class or Driver class.
> >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> >>> >
> >>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
> >>> > ionPool.java:713) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.sql.ConnectionPool.getConnectionHandle(Conn
> >>> > ectionPool.java:223) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
> >>> > Pool.java:190) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
> >>> > Pool.java:154) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.sql.ConnectionWrapper.checkOpen(ConnectionW
> >>> > rapper.java:204) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.sql.ConnectionWrapper.getConnection(Connect
> >>> > ionWrapper.java:177) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.sql.ConnectionWrapper_DJC.createStatement(C
> >>> > onnectionWrapper_DJC.java:25) 2006-11-01 12:17:03.835
> >>> > INFO  HttpListener0-5         at
> >>> > com.sybase.djc.sql.DataSource.ping(DataSource.java:1729)
> >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> >>> com.sybase.djc.sql.DataSource_DJC.access$101(DataSource_DJ
> >>> > C.java:4) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> >        at
> >>> com.sybase.djc.sql.DataSource_DJC$2.invoke(DataSource_DJC.
> >>> > java:2199) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> >         at
> >>> com.sybase.djc.transaction.TransactionManager.invokeRequir
> >>> > esNew(TransactionManager.java:844) 2006-11-01
> >>> > 12:17:03.835 INFO  HttpListener0-5         at
> >>> com.sybase.djc.transaction.TransactionManager.invokeRequir
> >>> > esNew(TransactionManager.java:739) 2006-11-01
> >>> > 12:17:03.835 INFO  HttpListener0-5         at
> >>> com.sybase.djc.sql.DataSource_DJC.ping(DataSource_DJC.java
> >>> > :2210) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> >     at
> >>> com.sybase.djc.management.beans.EASDataSource.ping(EASData
> >>> > Source.java:83) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> >>> > Method) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> >      at
> >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAc
> >>> > cessorImpl.java:39) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegating
> >>> > MethodAccessorImpl.java:25) 2006-11-01 12:17:03.835 INFO
> >>> >  HttpListener0-5         at
> >>> > java.lang.reflect.Method.invoke(Method.java:324)
> >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> >>> com.sybase.djc.management.beans.J2EEManagedObject.invoke(J
> >>> > 2EEManagedObject.java:178) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> mx4j.server.interceptor.InvokerMBeanServerInterceptor.invo
> >>> > ke(InvokerMBeanServerInterceptor.java:221) 2006-11-01
> >>> > 12:17:03.835 INFO  HttpListener0-5         at
> >>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> >>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> >>> > 12:17:03.835 INFO  HttpListener0-5         at
> >>> mx4j.server.interceptor.SecurityMBeanServerInterceptor.inv
> >>> > oke(SecurityMBeanServerInterceptor.java:84) 2006-11-01
> >>> > 12:17:03.835 INFO  HttpListener0-5         at
> >>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> >>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> >>> > 12:17:03.835 INFO  HttpListener0-5         at
> >>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> >>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> >>> > 12:17:03.835 INFO  HttpListener0-5         at
> >>> mx4j.server.interceptor.ContextClassLoaderMBeanServerInter
> >>> ceptor.invoke(ContextClassLoaderMBeanServerInterceptor.jav
> >>> > a:203) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> >     at
> >>> mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:10
> >>> > 43) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> >  at
> >>> com.sybase.djc.management.beans.ManagementBean.invoke(Mana
> >>> > gementBean.java:279) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.management.console.easmgm.ConnectionProfile
> >>> > s.invoke(ConnectionProfiles.java:179) 2006-11-01
> >>> > 12:17:03.835 INFO  HttpListener0-5         at
> >>> com.sybase.djc.management.console.easmgm.EASMBeanNode.perf
> >>> > ormOperation(EASMBeanNode.java:385) 2006-11-01
> >>> > 12:17:03.835 INFO  HttpListener0-5         at
> >>> com.sybase.djc.management.console.TreeAction.performAction
> >>> > (TreeAction.java:306) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.management.console.TreeAction.execute(TreeA
> >>> > ction.java:138) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> org.apache.struts.action.RequestProcessor.processActionPer
> >>> > form(RequestProcessor.java:431) 2006-11-01 12:17:03.835
> >>> > INFO  HttpListener0-5         at
> >>> org.apache.struts.action.RequestProcessor.process(RequestP
> >>> > rocessor.java:236) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> org.apache.struts.action.ActionServlet.process(ActionServl
> >>> > et.java:1196) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> org.apache.struts.action.ActionServlet.doGet(ActionServlet
> >>> > .java:414) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> >         at
> >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:59
> >>> > 6) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> > at
> >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
> >>> > 9) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> > at
> >>> web.components.console.console.action.service(action.java:
> >>> > 28) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> >  at
> >>> web.components.console.console.action_DJC.access$201(actio
> >>> > n_DJC.java:4) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> web.components.console.console.action_DJC$3.invoke(action_
> >>> > DJC.java:310) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.transaction.TransactionManager.invokeNotSup
> >>> > ported1(TransactionManager.java:654) 2006-11-01
> >>> > 12:17:03.835 INFO  HttpListener0-5         at
> >>> com.sybase.djc.transaction.TransactionManager.invokeBeanMa
> >>> > naged(TransactionManager.java:589) 2006-11-01
> >>> > 12:17:03.835 INFO  HttpListener0-5         at
> >>> web.components.console.console.action_DJC.service(action_D
> >>> > JC.java:339) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> web.components.console.console.action$WC.service(action$WC
> >>> > .java:24) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> >        at
> >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
> >>> > 9) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> > at
> >>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHold
> >>> > er.java:428) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
> >>> > n.doFilter(WebApplicationHandler.java:830) 2006-11-01
> >>> > 12:17:03.835 INFO  HttpListener0-5         at
> >>> org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filt
> >>> > er.java:170) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
> >>> > n.doFilter(WebApplicationHandler.java:821) 2006-11-01
> >>> > 12:17:03.835 INFO  HttpListener0-5         at
> >>> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(W
> >>> > ebApplicationHandler.java:471) 2006-11-01 12:17:03.835
> >>> > INFO  HttpListener0-5         at
> >>> com.sybase.djc.server.jetty.WebApplicationHandler.dispatch
> >>> > (WebApplicationHandler.java:157) 2006-11-01 12:17:03.835
> >>> > INFO  HttpListener0-5         at
> >>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHan
> >>> > dler.java:568) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.server.jetty.WebApplicationHandler.handle(W
> >>> > ebApplicationHandler.java:115) 2006-11-01 12:17:03.835
> >>> > INFO  HttpListener0-5         at
> >>> >
> >>> org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
> >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> >>> org.mortbay.jetty.servlet.WebApplicationContext.handle(Web
> >>> > ApplicationContext.java:633) 2006-11-01 12:17:03.835
> >>> > INFO  HttpListener0-5         at
> >>> >
> >>> org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
> >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> >>> > org.mortbay.http.HttpServer.service(HttpServer.java:909)
> >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> >>> org.mortbay.http.HttpConnection.service(HttpConnection.jav
> >>> > a:816) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> >     at
> >>> org.mortbay.http.HttpConnection.handleNext(HttpConnection.
> >>> > java:982) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> >        at
> >>> org.mortbay.http.HttpConnection.handle(HttpConnection.java
> >>> > :833) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> >    at
> >>> org.mortbay.http.SocketListener.handleConnection(SocketLis
> >>> > tener.java:244) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.server.jetty.HttpListener.handleConnection(
> >>> > HttpListener.java:107) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java
> >>> > :357) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> >    at
> >>> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java
> >>> > :534) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> >>> > Caused by: java.sql.SQLException: Unable to obtain
> >>> > connection from the data source &apos;QATEST&apos; due
> >>> > to missing DataSource class or Driver class.
> >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> >>> >
> >>> com.sybase.djc.sql.ConnectionPool.newConnection(Connection
> >>> > Pool.java:752) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
> >>> > ionPool.java:685) 2006-11-01 12:17:03.835 INFO
> >>> > HttpListener0-5         ... 63 more
> >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> > [ManagementBeans] Caught Exception:
> >>> >
> >>> com.sybase.djc.transaction.TransactionRolledbackSystemExce
> >>> > ption: com.sybase.djc.sql.DataSource.ping()
> >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> >>> >
> >>> com.sybase.djc.transaction.TransactionManager.invokeRequir
> >>> > esNew(TransactionManager.java:1024) 2006-11-01
> >>> > 12:17:03.835 ERROR HttpListener0-5         at
> >>> com.sybase.djc.transaction.TransactionManager.invokeRequir
> >>> > esNew(TransactionManager.java:739) 2006-11-01
> >>> > 12:17:03.835 ERROR HttpListener0-5         at
> >>> com.sybase.djc.sql.DataSource_DJC.ping(DataSource_DJC.java
> >>> > :2210) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> >     at
> >>> com.sybase.djc.management.beans.EASDataSource.ping(EASData
> >>> > Source.java:83) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> >>> > Method) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> >      at
> >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAc
> >>> > cessorImpl.java:39) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegating
> >>> > MethodAccessorImpl.java:25) 2006-11-01 12:17:03.835
> >>> > ERROR HttpListener0-5         at
> >>> > java.lang.reflect.Method.invoke(Method.java:324)
> >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> >>> com.sybase.djc.management.beans.J2EEManagedObject.invoke(J
> >>> > 2EEManagedObject.java:178) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> mx4j.server.interceptor.InvokerMBeanServerInterceptor.invo
> >>> > ke(InvokerMBeanServerInterceptor.java:221) 2006-11-01
> >>> > 12:17:03.835 ERROR HttpListener0-5         at
> >>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> >>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> >>> > 12:17:03.835 ERROR HttpListener0-5         at
> >>> mx4j.server.interceptor.SecurityMBeanServerInterceptor.inv
> >>> > oke(SecurityMBeanServerInterceptor.java:84) 2006-11-01
> >>> > 12:17:03.835 ERROR HttpListener0-5         at
> >>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> >>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> >>> > 12:17:03.835 ERROR HttpListener0-5         at
> >>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> >>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> >>> > 12:17:03.835 ERROR HttpListener0-5         at
> >>> mx4j.server.interceptor.ContextClassLoaderMBeanServerInter
> >>> ceptor.invoke(ContextClassLoaderMBeanServerInterceptor.jav
> >>> > a:203) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> >     at
> >>> mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:10
> >>> > 43) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> >  at
> >>> com.sybase.djc.management.beans.ManagementBean.invoke(Mana
> >>> > gementBean.java:279) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.management.console.easmgm.ConnectionProfile
> >>> > s.invoke(ConnectionProfiles.java:179) 2006-11-01
> >>> > 12:17:03.835 ERROR HttpListener0-5         at
> >>> com.sybase.djc.management.console.easmgm.EASMBeanNode.perf
> >>> > ormOperation(EASMBeanNode.java:385) 2006-11-01
> >>> > 12:17:03.835 ERROR HttpListener0-5         at
> >>> com.sybase.djc.management.console.TreeAction.performAction
> >>> > (TreeAction.java:306) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.management.console.TreeAction.execute(TreeA
> >>> > ction.java:138) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> org.apache.struts.action.RequestProcessor.processActionPer
> >>> > form(RequestProcessor.java:431) 2006-11-01 12:17:03.835
> >>> > ERROR HttpListener0-5         at
> >>> org.apache.struts.action.RequestProcessor.process(RequestP
> >>> > rocessor.java:236) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> org.apache.struts.action.ActionServlet.process(ActionServl
> >>> > et.java:1196) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> org.apache.struts.action.ActionServlet.doGet(ActionServlet
> >>> > .java:414) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> >         at
> >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:59
> >>> > 6) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> > at
> >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
> >>> > 9) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> > at
> >>> web.components.console.console.action.service(action.java:
> >>> > 28) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> >  at
> >>> web.components.console.console.action_DJC.access$201(actio
> >>> > n_DJC.java:4) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> web.components.console.console.action_DJC$3.invoke(action_
> >>> > DJC.java:310) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.transaction.TransactionManager.invokeNotSup
> >>> > ported1(TransactionManager.java:654) 2006-11-01
> >>> > 12:17:03.835 ERROR HttpListener0-5         at
> >>> com.sybase.djc.transaction.TransactionManager.invokeBeanMa
> >>> > naged(TransactionManager.java:589) 2006-11-01
> >>> > 12:17:03.835 ERROR HttpListener0-5         at
> >>> web.components.console.console.action_DJC.service(action_D
> >>> > JC.java:339) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> web.components.console.console.action$WC.service(action$WC
> >>> > .java:24) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> >        at
> >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
> >>> > 9) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> > at
> >>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHold
> >>> > er.java:428) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
> >>> > n.doFilter(WebApplicationHandler.java:830) 2006-11-01
> >>> > 12:17:03.835 ERROR HttpListener0-5         at
> >>> org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filt
> >>> > er.java:170) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
> >>> > n.doFilter(WebApplicationHandler.java:821) 2006-11-01
> >>> > 12:17:03.835 ERROR HttpListener0-5         at
> >>> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(W
> >>> > ebApplicationHandler.java:471) 2006-11-01 12:17:03.835
> >>> > ERROR HttpListener0-5         at
> >>> com.sybase.djc.server.jetty.WebApplicationHandler.dispatch
> >>> > (WebApplicationHandler.java:157) 2006-11-01 12:17:03.835
> >>> > ERROR HttpListener0-5         at
> >>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHan
> >>> > dler.java:568) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.server.jetty.WebApplicationHandler.handle(W
> >>> > ebApplicationHandler.java:115) 2006-11-01 12:17:03.835
> >>> > ERROR HttpListener0-5         at
> >>> >
> >>> org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
> >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> >>> org.mortbay.jetty.servlet.WebApplicationContext.handle(Web
> >>> > ApplicationContext.java:633) 2006-11-01 12:17:03.835
> >>> > ERROR HttpListener0-5         at
> >>> >
> >>> org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
> >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> >>> > org.mortbay.http.HttpServer.service(HttpServer.java:909)
> >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> >>> org.mortbay.http.HttpConnection.service(HttpConnection.jav
> >>> > a:816) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> >     at
> >>> org.mortbay.http.HttpConnection.handleNext(HttpConnection.
> >>> > java:982) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> >        at
> >>> org.mortbay.http.HttpConnection.handle(HttpConnection.java
> >>> > :833) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> >    at
> >>> org.mortbay.http.SocketListener.handleConnection(SocketLis
> >>> > tener.java:244) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.server.jetty.HttpListener.handleConnection(
> >>> > HttpListener.java:107) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java
> >>> > :357) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> >    at
> >>> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java
> >>> > :534) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> > Caused by: com.sybase.djc.DataStoreException: Connection
> >>> > Failed: java.sql.SQLException: Unable to obtain
> >>> > connection from the data source &apos;QATEST&apos; due
> >>> > to missing DataSource class or Driver class.
> >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> >>> >
> >>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
> >>> > ionPool.java:713) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.sql.ConnectionPool.getConnectionHandle(Conn
> >>> > ectionPool.java:223) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
> >>> > Pool.java:190) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
> >>> > Pool.java:154) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.sql.ConnectionWrapper.checkOpen(ConnectionW
> >>> > rapper.java:204) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.sql.ConnectionWrapper.getConnection(Connect
> >>> > ionWrapper.java:177) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.sql.ConnectionWrapper_DJC.createStatement(C
> >>> > onnectionWrapper_DJC.java:25) 2006-11-01 12:17:03.835
> >>> > ERROR HttpListener0-5         at
> >>> > com.sybase.djc.sql.DataSource.ping(DataSource.java:1729)
> >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> >>> com.sybase.djc.sql.DataSource_DJC.access$101(DataSource_DJ
> >>> > C.java:4) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> >        at
> >>> com.sybase.djc.sql.DataSource_DJC$2.invoke(DataSource_DJC.
> >>> > java:2199) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> >>> >         at
> >>> com.sybase.djc.transaction.TransactionManager.invokeRequir
> >>> > esNew(TransactionManager.java:844) 2006-11-01
> >>> > 12:17:03.835 ERROR HttpListener0-5         ... 53 more
> >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5     Caused
> >>> > by: java.sql.SQLException: Unable to obtain connection
> >>> > from the data source &apos;QATEST&apos; due to missing
> >>> > DataSource class or Driver class.
> >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> >>> >
> >>> com.sybase.djc.sql.ConnectionPool.newConnection(Connection
> >>> > Pool.java:752) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         at
> >>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
> >>> > ionPool.java:685) 2006-11-01 12:17:03.835 ERROR
> >>> > HttpListener0-5         ... 63 more
> >>>
> >>>
> >
> >
>
>

Hi Chris

The drivers no pure Java supported are:
Oracle (libjcm_oracle.dll)
ODBC (libjcm_odbc.dll and libjcm_odbcu.dll)
Sybase (libjcm_sybase.dll)

Do you not like the performance of the MS JDBC pure Java driver?

--

Alexander Pire
PowerObjects
www.powerobjects.com
612.339.3355
**IT Solutions - Outside the Box**

"Chris Pollach" <cpollach@travel-net.dot.com> wrote in message
news:4549e43a$2@forums-1-dub...
> Does anyone know when/if EAS 6.x will support direct connection to SS2005
> using SNC (like PB 10.5.1 and 11.0 do)?
> I would think that this would be the best connectivity from the
performance
> / ease-of-use point of view?
>
>
> <Thomas> wrote in message news:454794ce.43f.1681692777@sybase.com...
> > I am currently migrating from EAServer 4.2 to 6.0.  I am
> > trying to connect a SQL Server database through an ODBC
> > connection in EAServer 6.0.  When I set up the data source
> > and tried to ping the database server, it gives me an error
> > saying it cannot connect to the database.  I have tried to
> > change the database type from SQL SERVER to JCM_ODBC and
> > other multiple things to try to connect, but it still fails.
> >  The odbc connection is properly set up but I can't seem to
> > connect through EAServer.  Any help would be appreciated.
>
>

 Hard to tell until we do some bench marking. However, the SNC driver
handshaking in PB 11 is the best of the JDBC, ODBC, OLE-DB or ADO.Net
options I have tested. So I just assumed that if EAServer was using this it
would be an excellent plus on the SS2005 supported feature list *g*


"Alexander Pire" <alexander_nospawn@powerobjects_dot_com> wrote in message
news:454a215c$1@forums-1-dub...
> Hi Chris
>
> The drivers no pure Java supported are:
> Oracle (libjcm_oracle.dll)
> ODBC (libjcm_odbc.dll and libjcm_odbcu.dll)
> Sybase (libjcm_sybase.dll)
>
> Do you not like the performance of the MS JDBC pure Java driver?
>
> --
>
> Alexander Pire
> PowerObjects
> www.powerobjects.com
> 612.339.3355
> **IT Solutions - Outside the Box**
>
> "Chris Pollach" <cpollach@travel-net.dot.com> wrote in message
> news:4549e43a$2@forums-1-dub...
> > Does anyone know when/if EAS 6.x will support direct connection to
SS2005
> > using SNC (like PB 10.5.1 and 11.0 do)?
> > I would think that this would be the best connectivity from the
> performance
> > / ease-of-use point of view?
> >
> >
> > <Thomas> wrote in message news:454794ce.43f.1681692777@sybase.com...
> > > I am currently migrating from EAServer 4.2 to 6.0.  I am
> > > trying to connect a SQL Server database through an ODBC
> > > connection in EAServer 6.0.  When I set up the data source
> > > and tried to ping the database server, it gives me an error
> > > saying it cannot connect to the database.  I have tried to
> > > change the database type from SQL SERVER to JCM_ODBC and
> > > other multiple things to try to connect, but it still fails.
> > >  The odbc connection is properly set up but I can't seem to
> > > connect through EAServer.  Any help would be appreciated.
> >
> >
>
>

I'm agree...

--

Alexander Pire
PowerObjects
www.powerobjects.com
612.339.3355
**IT Solutions - Outside the Box**

"Chris Pollach" <cpollach@travel-net.dot.com> wrote in message
news:454a3952$1@forums-1-dub...
>
>  Hard to tell until we do some bench marking. However, the SNC driver
> handshaking in PB 11 is the best of the JDBC, ODBC, OLE-DB or ADO.Net
> options I have tested. So I just assumed that if EAServer was using this
it
> would be an excellent plus on the SS2005 supported feature list *g*
>
>
> "Alexander Pire" <alexander_nospawn@powerobjects_dot_com> wrote in message
> news:454a215c$1@forums-1-dub...
> > Hi Chris
> >
> > The drivers no pure Java supported are:
> > Oracle (libjcm_oracle.dll)
> > ODBC (libjcm_odbc.dll and libjcm_odbcu.dll)
> > Sybase (libjcm_sybase.dll)
> >
> > Do you not like the performance of the MS JDBC pure Java driver?
> >
> > --
> >
> > Alexander Pire
> > PowerObjects
> > www.powerobjects.com
> > 612.339.3355
> > **IT Solutions - Outside the Box**
> >
> > "Chris Pollach" <cpollach@travel-net.dot.com> wrote in message
> > news:4549e43a$2@forums-1-dub...
> > > Does anyone know when/if EAS 6.x will support direct connection to
> SS2005
> > > using SNC (like PB 10.5.1 and 11.0 do)?
> > > I would think that this would be the best connectivity from the
> > performance
> > > / ease-of-use point of view?
> > >
> > >
> > > <Thomas> wrote in message news:454794ce.43f.1681692777@sybase.com...
> > > > I am currently migrating from EAServer 4.2 to 6.0.  I am
> > > > trying to connect a SQL Server database through an ODBC
> > > > connection in EAServer 6.0.  When I set up the data source
> > > > and tried to ping the database server, it gives me an error
> > > > saying it cannot connect to the database.  I have tried to
> > > > change the database type from SQL SERVER to JCM_ODBC and
> > > > other multiple things to try to connect, but it still fails.
> > > >  The odbc connection is properly set up but I can't seem to
> > > > connect through EAServer.  Any help would be appreciated.
> > >
> > >
> >
> >
>
>

Sybase Enterprise Application Server 6.0.0.43 ->
com.sybase.jaguar.jcm.OdbcDriver

Sybase Enterprise Application Server 6.0.0.93 ->
com.sybase.jaguar.jcm.odbc.OdbcDriver

Check your jars and the JCM_Odbc.properties and let us know the results.

Best Regards
--

Alexander Pire
PowerObjects
www.powerobjects.com
612.339.3355
**IT Solutions - Outside the Box**

"Alexander Pire" <alexander_nospawn@powerobjects_dot_com> wrote in message
news:454a17d1$1@forums-1-dub...
> Actually it looks like Sybase has changed the location of this class.
>
> In a newer version (6.0.0.93) the driver is in the odbc folder (check if
you
> have a eas-server-xx.jar and look inside where is the driver, or if you
have
> in the lib folder djc-all.jar check where is the class).
>
> So after this interesting confution I have to ask you something. Have you
> done an upgrade of your EAServer?
>
> --
>
> Alexander Pire
> PowerObjects
> www.powerobjects.com
> 612.339.3355
> **IT Solutions - Outside the Box**
>
> "Alexander Pire" <Alexander_no_spam_@powerobjects_dot_com> wrote in
message
> news:45495601@forums-1-dub...
> > Just an small comment
> >
> > com.sybase.jaguar.jcm.odbc.OdbcDriver is not in the djc-all.jar, the
> values
> > shoud be without the odbc, like next:
> >
> > driverClass=com.sybase.jaguar.jcm.OdbcDriver
> >
> > Regards
> >
> > --
> >
> > Alexander Pire
> > PowerObjects
> > www.powerobjects.com
> > 612.339.3355
> > **IT Solutions - Outside the Box**
> >
> >
> > "gpzhang" <gpzhang@sybase.com> wrote in message
> > news:454953e9@forums-1-dub...
> > > If you use JCM_ODBC as "Database Type", you should not need to set
> > > datasource class or the driver class as driver class will be taken
from
> > > your "Database Type" setting which is
> > > com.sybase.jaguar.jcm.odbc.OdbcDriver.
> > > Please check your
> > >
>
$EAS6\Repository\Instance\com\sybase\djc\sql\DatabaseType\JCM_Odbc.propertie
> s:
> > > It should looks like:
> > >
> > > ........
> > > driverClass=com.sybase.jaguar.jcm.odbc.OdbcDriver
> > > .......
> > >
>
databaseURL=jdbc\:sybase\:jcm\:odbc\:serverName\=${serverName};user\=${user}
> ;password\=${password}
> > >
> > > "driverClass property is missing from JCM_Odbc.properties" is the only
> > > reason I could think of for your exception trace. Also please note
that
> > > any change to Database Type requires restart EAServer.
> > >
> > >
> > > <Thomas C.> wrote in message
news:45491051.1a0b.1681692777@sybase.com...
> > >> Where are we supposed to enter the datasource class or the
> > >> driver class.  I know currently in EAServer 4.2.2 you can
> > >> actually enter a driver class, ex. in our case odbc32.dll,
> > >> but there isn't a place to enter it in 6.0.  I have checked
> > >> the odbc connection and the connection is good through
> > >> windows odbc control manager.
> > >>
> > >>> The key part seems to be 'due to missing DataSource class
> > >>> or Driver class'.  Can you check those?
> > >>>
> > >>> <Thomas C.> wrote in message
> > >>> > news:4548e705.1828.1681692777@sybase.com... Under the
> > >>> > JCM_ODBC connection settings, everything was left to
> > >>> > default except the server name which the database is
> > >>> actually stored at and the user name and password. >
> > >>> > Below is what the log file says after I tried to ping
> > >>> > the database server.
> > >>> >
> > >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> > [SystemException] com.sybase.djc.DataStoreException was
> > >>> > thrown by transaction
> > >>> > com.sybase.djc.sql.DataSource.ping() 2006-11-01
> > >>> > 12:17:03.835 INFO  HttpListener0-5
> > >>> > com.sybase.djc.DataStoreException: Connection Failed:
> > >>> java.sql.SQLException: Unable to obtain connection from
> > >>> > the data source &apos;QATEST&apos; due to missing
> > >>> > DataSource class or Driver class.
> > >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> > >>> >
> > >>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
> > >>> > ionPool.java:713) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.sql.ConnectionPool.getConnectionHandle(Conn
> > >>> > ectionPool.java:223) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
> > >>> > Pool.java:190) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
> > >>> > Pool.java:154) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.sql.ConnectionWrapper.checkOpen(ConnectionW
> > >>> > rapper.java:204) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.sql.ConnectionWrapper.getConnection(Connect
> > >>> > ionWrapper.java:177) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.sql.ConnectionWrapper_DJC.createStatement(C
> > >>> > onnectionWrapper_DJC.java:25) 2006-11-01 12:17:03.835
> > >>> > INFO  HttpListener0-5         at
> > >>> > com.sybase.djc.sql.DataSource.ping(DataSource.java:1729)
> > >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> > >>> com.sybase.djc.sql.DataSource_DJC.access$101(DataSource_DJ
> > >>> > C.java:4) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> >        at
> > >>> com.sybase.djc.sql.DataSource_DJC$2.invoke(DataSource_DJC.
> > >>> > java:2199) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> >         at
> > >>> com.sybase.djc.transaction.TransactionManager.invokeRequir
> > >>> > esNew(TransactionManager.java:844) 2006-11-01
> > >>> > 12:17:03.835 INFO  HttpListener0-5         at
> > >>> com.sybase.djc.transaction.TransactionManager.invokeRequir
> > >>> > esNew(TransactionManager.java:739) 2006-11-01
> > >>> > 12:17:03.835 INFO  HttpListener0-5         at
> > >>> com.sybase.djc.sql.DataSource_DJC.ping(DataSource_DJC.java
> > >>> > :2210) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> >     at
> > >>> com.sybase.djc.management.beans.EASDataSource.ping(EASData
> > >>> > Source.java:83) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > >>> > Method) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> >      at
> > >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAc
> > >>> > cessorImpl.java:39) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegating
> > >>> > MethodAccessorImpl.java:25) 2006-11-01 12:17:03.835 INFO
> > >>> >  HttpListener0-5         at
> > >>> > java.lang.reflect.Method.invoke(Method.java:324)
> > >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> > >>> com.sybase.djc.management.beans.J2EEManagedObject.invoke(J
> > >>> > 2EEManagedObject.java:178) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> mx4j.server.interceptor.InvokerMBeanServerInterceptor.invo
> > >>> > ke(InvokerMBeanServerInterceptor.java:221) 2006-11-01
> > >>> > 12:17:03.835 INFO  HttpListener0-5         at
> > >>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> > >>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> > >>> > 12:17:03.835 INFO  HttpListener0-5         at
> > >>> mx4j.server.interceptor.SecurityMBeanServerInterceptor.inv
> > >>> > oke(SecurityMBeanServerInterceptor.java:84) 2006-11-01
> > >>> > 12:17:03.835 INFO  HttpListener0-5         at
> > >>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> > >>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> > >>> > 12:17:03.835 INFO  HttpListener0-5         at
> > >>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> > >>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> > >>> > 12:17:03.835 INFO  HttpListener0-5         at
> > >>> mx4j.server.interceptor.ContextClassLoaderMBeanServerInter
> > >>> ceptor.invoke(ContextClassLoaderMBeanServerInterceptor.jav
> > >>> > a:203) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> >     at
> > >>> mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:10
> > >>> > 43) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> >  at
> > >>> com.sybase.djc.management.beans.ManagementBean.invoke(Mana
> > >>> > gementBean.java:279) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.management.console.easmgm.ConnectionProfile
> > >>> > s.invoke(ConnectionProfiles.java:179) 2006-11-01
> > >>> > 12:17:03.835 INFO  HttpListener0-5         at
> > >>> com.sybase.djc.management.console.easmgm.EASMBeanNode.perf
> > >>> > ormOperation(EASMBeanNode.java:385) 2006-11-01
> > >>> > 12:17:03.835 INFO  HttpListener0-5         at
> > >>> com.sybase.djc.management.console.TreeAction.performAction
> > >>> > (TreeAction.java:306) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.management.console.TreeAction.execute(TreeA
> > >>> > ction.java:138) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> org.apache.struts.action.RequestProcessor.processActionPer
> > >>> > form(RequestProcessor.java:431) 2006-11-01 12:17:03.835
> > >>> > INFO  HttpListener0-5         at
> > >>> org.apache.struts.action.RequestProcessor.process(RequestP
> > >>> > rocessor.java:236) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> org.apache.struts.action.ActionServlet.process(ActionServl
> > >>> > et.java:1196) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> org.apache.struts.action.ActionServlet.doGet(ActionServlet
> > >>> > .java:414) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> >         at
> > >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:59
> > >>> > 6) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> > at
> > >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
> > >>> > 9) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> > at
> > >>> web.components.console.console.action.service(action.java:
> > >>> > 28) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> >  at
> > >>> web.components.console.console.action_DJC.access$201(actio
> > >>> > n_DJC.java:4) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> web.components.console.console.action_DJC$3.invoke(action_
> > >>> > DJC.java:310) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.transaction.TransactionManager.invokeNotSup
> > >>> > ported1(TransactionManager.java:654) 2006-11-01
> > >>> > 12:17:03.835 INFO  HttpListener0-5         at
> > >>> com.sybase.djc.transaction.TransactionManager.invokeBeanMa
> > >>> > naged(TransactionManager.java:589) 2006-11-01
> > >>> > 12:17:03.835 INFO  HttpListener0-5         at
> > >>> web.components.console.console.action_DJC.service(action_D
> > >>> > JC.java:339) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> web.components.console.console.action$WC.service(action$WC
> > >>> > .java:24) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> >        at
> > >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
> > >>> > 9) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> > at
> > >>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHold
> > >>> > er.java:428) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
> > >>> > n.doFilter(WebApplicationHandler.java:830) 2006-11-01
> > >>> > 12:17:03.835 INFO  HttpListener0-5         at
> > >>> org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filt
> > >>> > er.java:170) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
> > >>> > n.doFilter(WebApplicationHandler.java:821) 2006-11-01
> > >>> > 12:17:03.835 INFO  HttpListener0-5         at
> > >>> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(W
> > >>> > ebApplicationHandler.java:471) 2006-11-01 12:17:03.835
> > >>> > INFO  HttpListener0-5         at
> > >>> com.sybase.djc.server.jetty.WebApplicationHandler.dispatch
> > >>> > (WebApplicationHandler.java:157) 2006-11-01 12:17:03.835
> > >>> > INFO  HttpListener0-5         at
> > >>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHan
> > >>> > dler.java:568) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.server.jetty.WebApplicationHandler.handle(W
> > >>> > ebApplicationHandler.java:115) 2006-11-01 12:17:03.835
> > >>> > INFO  HttpListener0-5         at
> > >>> >
> > >>> org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
> > >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> > >>> org.mortbay.jetty.servlet.WebApplicationContext.handle(Web
> > >>> > ApplicationContext.java:633) 2006-11-01 12:17:03.835
> > >>> > INFO  HttpListener0-5         at
> > >>> >
> > >>> org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
> > >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> > >>> > org.mortbay.http.HttpServer.service(HttpServer.java:909)
> > >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> > >>> org.mortbay.http.HttpConnection.service(HttpConnection.jav
> > >>> > a:816) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> >     at
> > >>> org.mortbay.http.HttpConnection.handleNext(HttpConnection.
> > >>> > java:982) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> >        at
> > >>> org.mortbay.http.HttpConnection.handle(HttpConnection.java
> > >>> > :833) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> >    at
> > >>> org.mortbay.http.SocketListener.handleConnection(SocketLis
> > >>> > tener.java:244) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.server.jetty.HttpListener.handleConnection(
> > >>> > HttpListener.java:107) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java
> > >>> > :357) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> >    at
> > >>> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java
> > >>> > :534) 2006-11-01 12:17:03.835 INFO  HttpListener0-5
> > >>> > Caused by: java.sql.SQLException: Unable to obtain
> > >>> > connection from the data source &apos;QATEST&apos; due
> > >>> > to missing DataSource class or Driver class.
> > >>> > 2006-11-01 12:17:03.835 INFO  HttpListener0-5         at
> > >>> >
> > >>> com.sybase.djc.sql.ConnectionPool.newConnection(Connection
> > >>> > Pool.java:752) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
> > >>> > ionPool.java:685) 2006-11-01 12:17:03.835 INFO
> > >>> > HttpListener0-5         ... 63 more
> > >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> > [ManagementBeans] Caught Exception:
> > >>> >
> > >>> com.sybase.djc.transaction.TransactionRolledbackSystemExce
> > >>> > ption: com.sybase.djc.sql.DataSource.ping()
> > >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> > >>> >
> > >>> com.sybase.djc.transaction.TransactionManager.invokeRequir
> > >>> > esNew(TransactionManager.java:1024) 2006-11-01
> > >>> > 12:17:03.835 ERROR HttpListener0-5         at
> > >>> com.sybase.djc.transaction.TransactionManager.invokeRequir
> > >>> > esNew(TransactionManager.java:739) 2006-11-01
> > >>> > 12:17:03.835 ERROR HttpListener0-5         at
> > >>> com.sybase.djc.sql.DataSource_DJC.ping(DataSource_DJC.java
> > >>> > :2210) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> >     at
> > >>> com.sybase.djc.management.beans.EASDataSource.ping(EASData
> > >>> > Source.java:83) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > >>> > Method) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> >      at
> > >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAc
> > >>> > cessorImpl.java:39) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegating
> > >>> > MethodAccessorImpl.java:25) 2006-11-01 12:17:03.835
> > >>> > ERROR HttpListener0-5         at
> > >>> > java.lang.reflect.Method.invoke(Method.java:324)
> > >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> > >>> com.sybase.djc.management.beans.J2EEManagedObject.invoke(J
> > >>> > 2EEManagedObject.java:178) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> mx4j.server.interceptor.InvokerMBeanServerInterceptor.invo
> > >>> > ke(InvokerMBeanServerInterceptor.java:221) 2006-11-01
> > >>> > 12:17:03.835 ERROR HttpListener0-5         at
> > >>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> > >>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> > >>> > 12:17:03.835 ERROR HttpListener0-5         at
> > >>> mx4j.server.interceptor.SecurityMBeanServerInterceptor.inv
> > >>> > oke(SecurityMBeanServerInterceptor.java:84) 2006-11-01
> > >>> > 12:17:03.835 ERROR HttpListener0-5         at
> > >>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> > >>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> > >>> > 12:17:03.835 ERROR HttpListener0-5         at
> > >>> mx4j.server.interceptor.DefaultMBeanServerInterceptor.invo
> > >>> > ke(DefaultMBeanServerInterceptor.java:120) 2006-11-01
> > >>> > 12:17:03.835 ERROR HttpListener0-5         at
> > >>> mx4j.server.interceptor.ContextClassLoaderMBeanServerInter
> > >>> ceptor.invoke(ContextClassLoaderMBeanServerInterceptor.jav
> > >>> > a:203) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> >     at
> > >>> mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:10
> > >>> > 43) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> >  at
> > >>> com.sybase.djc.management.beans.ManagementBean.invoke(Mana
> > >>> > gementBean.java:279) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.management.console.easmgm.ConnectionProfile
> > >>> > s.invoke(ConnectionProfiles.java:179) 2006-11-01
> > >>> > 12:17:03.835 ERROR HttpListener0-5         at
> > >>> com.sybase.djc.management.console.easmgm.EASMBeanNode.perf
> > >>> > ormOperation(EASMBeanNode.java:385) 2006-11-01
> > >>> > 12:17:03.835 ERROR HttpListener0-5         at
> > >>> com.sybase.djc.management.console.TreeAction.performAction
> > >>> > (TreeAction.java:306) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.management.console.TreeAction.execute(TreeA
> > >>> > ction.java:138) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> org.apache.struts.action.RequestProcessor.processActionPer
> > >>> > form(RequestProcessor.java:431) 2006-11-01 12:17:03.835
> > >>> > ERROR HttpListener0-5         at
> > >>> org.apache.struts.action.RequestProcessor.process(RequestP
> > >>> > rocessor.java:236) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> org.apache.struts.action.ActionServlet.process(ActionServl
> > >>> > et.java:1196) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> org.apache.struts.action.ActionServlet.doGet(ActionServlet
> > >>> > .java:414) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> >         at
> > >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:59
> > >>> > 6) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> > at
> > >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
> > >>> > 9) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> > at
> > >>> web.components.console.console.action.service(action.java:
> > >>> > 28) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> >  at
> > >>> web.components.console.console.action_DJC.access$201(actio
> > >>> > n_DJC.java:4) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> web.components.console.console.action_DJC$3.invoke(action_
> > >>> > DJC.java:310) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.transaction.TransactionManager.invokeNotSup
> > >>> > ported1(TransactionManager.java:654) 2006-11-01
> > >>> > 12:17:03.835 ERROR HttpListener0-5         at
> > >>> com.sybase.djc.transaction.TransactionManager.invokeBeanMa
> > >>> > naged(TransactionManager.java:589) 2006-11-01
> > >>> > 12:17:03.835 ERROR HttpListener0-5         at
> > >>> web.components.console.console.action_DJC.service(action_D
> > >>> > JC.java:339) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> web.components.console.console.action$WC.service(action$WC
> > >>> > .java:24) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> >        at
> > >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:68
> > >>> > 9) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> > at
> > >>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHold
> > >>> > er.java:428) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
> > >>> > n.doFilter(WebApplicationHandler.java:830) 2006-11-01
> > >>> > 12:17:03.835 ERROR HttpListener0-5         at
> > >>> org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filt
> > >>> > er.java:170) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChai
> > >>> > n.doFilter(WebApplicationHandler.java:821) 2006-11-01
> > >>> > 12:17:03.835 ERROR HttpListener0-5         at
> > >>> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(W
> > >>> > ebApplicationHandler.java:471) 2006-11-01 12:17:03.835
> > >>> > ERROR HttpListener0-5         at
> > >>> com.sybase.djc.server.jetty.WebApplicationHandler.dispatch
> > >>> > (WebApplicationHandler.java:157) 2006-11-01 12:17:03.835
> > >>> > ERROR HttpListener0-5         at
> > >>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHan
> > >>> > dler.java:568) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.server.jetty.WebApplicationHandler.handle(W
> > >>> > ebApplicationHandler.java:115) 2006-11-01 12:17:03.835
> > >>> > ERROR HttpListener0-5         at
> > >>> >
> > >>> org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
> > >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> > >>> org.mortbay.jetty.servlet.WebApplicationContext.handle(Web
> > >>> > ApplicationContext.java:633) 2006-11-01 12:17:03.835
> > >>> > ERROR HttpListener0-5         at
> > >>> >
> > >>> org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
> > >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> > >>> > org.mortbay.http.HttpServer.service(HttpServer.java:909)
> > >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> > >>> org.mortbay.http.HttpConnection.service(HttpConnection.jav
> > >>> > a:816) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> >     at
> > >>> org.mortbay.http.HttpConnection.handleNext(HttpConnection.
> > >>> > java:982) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> >        at
> > >>> org.mortbay.http.HttpConnection.handle(HttpConnection.java
> > >>> > :833) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> >    at
> > >>> org.mortbay.http.SocketListener.handleConnection(SocketLis
> > >>> > tener.java:244) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.server.jetty.HttpListener.handleConnection(
> > >>> > HttpListener.java:107) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java
> > >>> > :357) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> >    at
> > >>> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java
> > >>> > :534) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> > Caused by: com.sybase.djc.DataStoreException: Connection
> > >>> > Failed: java.sql.SQLException: Unable to obtain
> > >>> > connection from the data source &apos;QATEST&apos; due
> > >>> > to missing DataSource class or Driver class.
> > >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> > >>> >
> > >>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
> > >>> > ionPool.java:713) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.sql.ConnectionPool.getConnectionHandle(Conn
> > >>> > ectionPool.java:223) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
> > >>> > Pool.java:190) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.sql.ConnectionPool.getConnection(Connection
> > >>> > Pool.java:154) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.sql.ConnectionWrapper.checkOpen(ConnectionW
> > >>> > rapper.java:204) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.sql.ConnectionWrapper.getConnection(Connect
> > >>> > ionWrapper.java:177) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.sql.ConnectionWrapper_DJC.createStatement(C
> > >>> > onnectionWrapper_DJC.java:25) 2006-11-01 12:17:03.835
> > >>> > ERROR HttpListener0-5         at
> > >>> > com.sybase.djc.sql.DataSource.ping(DataSource.java:1729)
> > >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> > >>> com.sybase.djc.sql.DataSource_DJC.access$101(DataSource_DJ
> > >>> > C.java:4) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> >        at
> > >>> com.sybase.djc.sql.DataSource_DJC$2.invoke(DataSource_DJC.
> > >>> > java:2199) 2006-11-01 12:17:03.835 ERROR HttpListener0-5
> > >>> >         at
> > >>> com.sybase.djc.transaction.TransactionManager.invokeRequir
> > >>> > esNew(TransactionManager.java:844) 2006-11-01
> > >>> > 12:17:03.835 ERROR HttpListener0-5         ... 53 more
> > >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5     Caused
> > >>> > by: java.sql.SQLException: Unable to obtain connection
> > >>> > from the data source &apos;QATEST&apos; due to missing
> > >>> > DataSource class or Driver class.
> > >>> > 2006-11-01 12:17:03.835 ERROR HttpListener0-5         at
> > >>> >
> > >>> com.sybase.djc.sql.ConnectionPool.newConnection(Connection
> > >>> > Pool.java:752) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         at
> > >>> com.sybase.djc.sql.ConnectionPool.createConnection(Connect
> > >>> > ionPool.java:685) 2006-11-01 12:17:03.835 ERROR
> > >>> > HttpListener0-5         ... 63 more
> > >>>
> > >>>
> > >
> > >
> >
> >
>
>