EAServer 6.0 connect to MS SQL SERVER using ODBC Connection

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.
0
Thomas
10/31/2006 5:24:14 PM
sybase.easerver.general 7903 articles. 0 followers. Follow

12 Replies
1231 Views

Similar Articles

[PageSpeed] 12

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. 


0
gpzhang
11/1/2006 2:26:26 AM
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
0
Thomas
11/1/2006 5:27:17 PM
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 


0
David
11/1/2006 6:22:00 PM
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
>
>
0
Thomas
11/1/2006 8:23:29 PM
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
>>
>> 


0
gpzhang
11/2/2006 1:11:53 AM
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
>>>
>>>
>
> 


0
Alexander
11/2/2006 1:20:49 AM
 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.


0
Chris
11/2/2006 11:27:38 AM
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
> >>>
> >>>
> >
> >
>
>


0
Alexander
11/2/2006 3:07:45 PM
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.
>
>


0
Alexander
11/2/2006 3:48:28 PM
 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.
> >
> >
>
>


0
Chris
11/2/2006 5:30:42 PM
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.
> > >
> > >
> >
> >
>
>


0
Alexander
11/2/2006 6:19:38 PM
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
> > >>>
> > >>>
> > >
> > >
> >
> >
>
>


0
Alexander
11/2/2006 6:29:52 PM
Reply:

Similar Artilces:

PB6.5 connect MS SQL 2005 using native driver (DBMS=MSS (Msoft) SQL Server 6.0)
Is it possible PB 6.5 using "DBMS=MSS (Msoft) SQL Server 6.0" to connect MS SQL 2005? The existing application is PB6.5 using "DBMS=MSS (Msoft) SQL Server 6.0" to connect MS SQL 2000. It is work fine. John Hi John; AFAIK .. it should work. The only restrictions would be 1) PB 6.5 will not understand SS2005 functionality. You will be restricted to the SS 6.0 (as you are today with SS2000) feature set. 2) The MSS setting connects using the NTDBLIB.dll from MS. I do not believe that this is supplied with SS2005. So you will need to install the SS20...

How to setup connection property in Connection Cache using EAServer 3.6.1 + JDBC 2.0
Hi, The following properties is my connection cache property. Server Name ---> NetworkProtocol=Tds:Server=localhost:Port=4100:DatabaseName=odwas Class Name ---> com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource I am using the JDBC 2.0 to connect with my ASE 12.0 Server. I check all of the books about JDBC API. I could not find more information about connection property with JDBC 2.0 + Sybase jConnect 5.2. I already try to use the connection cache property file but it could not work. Do anyone know how to put the "PACKETSIZE" property to "Server Na...

Connection to SQL Server 7.0 using a trusted connection
Can someone help me with connecting to SQL Server via PowerBuilder 7.01 using a trusted connection. I have never connected to a database in this manner. My application has a login window where the users enter a user_id and password. The script in this window gets the user_id and password and populates the SQLCA.UserID and SQLCA.DBPass. The script then connects to the database. The client that will be using my application wants to use SQL Server with NT Authentication which means a trusted connection. How do I accomplish this connection if no user_id and password has been entered? ...

Connection of PB 6.0 to SQL Server 7.0 & Version B/W PB 6.0 and PB 7.0
Can anyone tell me about connecting PB 6.0 to SQL Server 7.0. Please remember we are not planning to upgrade both software. When I was trying to connect PB 6.0 to SQL Server 7.0, error occurred " SQLSTAT 1003". OS=NT 4.0 Server PB=6.0 Enterprise Edition SQL SERVER=7.0 Corporate Edition I also want to know the versions between PB 6.0 to PB 7.0 If your are using the ODBC, which I assume you are, include Disablebind=1 in your DBParm. If your deployment environment is also NT, you will have to turn SQLSPY=1 using PFC services. Autocommit=FALSE and SetTransObject() ra...

Using ODBC to connect to MS SQL Server
Due to the problems with using the native MS SQL Server drivers that seem to be well documented in this news group, we have switched to ODBC to connect to MS SQL Server. However our DataWindow objects that we associate to our DataStores no longer return the identity column value after doing an insert. We have set the identity column in the DW and have even added/removed the column as an updateable column in the DW without solving the problem. Anyone get this to work or is this an ODBC driver bug/feature? Additionally SQL that is modified at runtime (that worked w. native drivers) i...

Using ODBC to connect to MS SQL Server
Due to the problems with using the native MS SQL Server drivers that seem to be well documented in this news group, we have switched to ODBC to connect to MS SQL Server. However our DataWindow objects that we associate to our DataStores no longer return the identity column value after doing an insert. We have set the identity column in the DW and have even added/removed the column as an updateable column in the DW without solving the problem. Anyone get this to work or is this an ODBC driver bug/feature? Additionally SQL that is modified at runtime (that worked w. native drivers) i...

Help me about connecting PB 6.0 to SQL Server 7.0 & Versions B/W PB 6.0 and PB 7.0
Can anyone tell me about connecting PB 6.0 to SQL Server 7.0. Please remember we are not planning to upgrade both software. When I was trying to connect PB 6.0 to SQL Server 7.0, error occurred " SQLSTAT 1003". OS=NT 4.0 Server PB=6.0 Enterprise Edition SQL SERVER=7.0 Corporate Edition I also want to know the versions between PB 6.0 to PB 7.0 I don't believe this is going to be possible without at least upgrading to the latest maintenance release of 6.x. On Mon, 23 Aug 1999 00:59:56 -0700, in powersoft.public.powerbuilder.database Abdul Lateef <abdul_lat...

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not all #6
hi there! I've uploaded my website at online server. which has its database on its local server. Now whenever Im trying to open the website. I get the following message instead of website. "An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) " Im using sql server 2000 for database. Asp.net 2.0 Please hel...

Dial-up MS SQL Server 6.0 Connection
Hello Friends! I am trying to make a connection to SQL Server 6.0 through Dial-up Networking connection. Since my users are going to be remote (on laptops), I thought that dial-up database connections would be the best way to go. What information do I need for this kind of connection? What should be the servername in the db profile box? Does anybody have any ideas about any products out there I can use to connect remotely? Any help would be appreciated. Thanks. We connect to the network via RAS and access the database just as if we were local. -- Andy Tauber - Team Powerso...

Possible to connect to EAServer and MS SQL server at same time?
I'm proposing the use of Powerbuilder 7.0 and EA server in an application development project to my client. The project will deliver additional functionality to an existing application. The existing application is written in PowerBuilder 5.0 and is a client-server application which connects directly to a MS SQL Server data base server. For the new development we wish to make full use of EA Server to encode business rules and to provide more control over access to the database. All access to the database in the new portions of the application will be implemented via EA Server....

help. when using Profile GetPropertyValue, I get the following connection error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure
 Hi,I need some help. I am getting this error after I complete the asp.net register control and click on the continue button. It crashed when it tries to get it calls this Profile property((string)(this.GetPropertyValue("Address1")));When I look at the stack, it is coming from my ProfileWrapper class which adds user address, city, etc.. from a class which inherits fromSystem.Web.Profile.ProfileBase. From the stack, it is calling the System.Web.Profile and crashed when it tries to open a connection atSystem.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObj...

A Problem to Connect SQL Server 2000 Through MSS MS SQL Server 6.x Interaface
Hi, We have two SQL Server 2000 database servers. I have no problem to connect serverA through MSS MS SQL Server 6.X. But I cannot connect to serverB through MSS MS SQL Server 6.X. I tried to connect to serverB through ODBC. It is connected well, but there was error message said "Catalog tables could not be created and are not available for use." My PowerBuilder version is 7.0.2 and build 8046. Mindy ...

PB 6.5 to MS SQL server 7.0 connectivity
Greetings Seem to much discussion on this topic...I desperately need the answer at the end of the book. We are upgrading to SQL 7 and MUST be live with our PB 6.5 app in 3 weeks. PowerSoft/Sybase preferred or recommended configuration?? Please respond with any recommendations on: PB versions / builds PB drivers SQL Server client software Native drivers VS OLEDB VS ODBC etc... PB support of 7.0 new features: specifically the 8K varchar DataType thanks <pc> ...

How connect PB 6.5 to MS SQL Server 2000 with ODBC
Hi: I need to connect PB 6.5 with MS SQL Server 2000 with a ODBC connection, but they return this message: SQLSTATE = S1003 [Microsoft][ODBC Driver Manager] Program type out of range How i can do it? Thanks -- Francisco L�pez Keyhelp, S.L. Departamento de desarrollo PB 6.5 is too old as it's ODBC driver handshake is out-of-date compared to the one provided by Microsoft. "Keyhelp" <keyhelpNOSPAM@keyhelp(dot)net> wrote in message news:4369f838@forums-2-dub... > Hi: > > I need to connect PB 6.5 with MS SQL Server 2000 with...

Web resources about - EAServer 6.0 connect to MS SQL SERVER using ODBC Connection - sybase.easerver.general

Connection - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

iMedia Connection: Interactive Marketing News, Features, Podcasts and Video - iMediaConnection.com
High-quality data, if not used properly, can still lead marketers to make bad decisions. Consider these common ways that numbers are used to ...

HTTP persistent connection - Wikipedia, the free encyclopedia
... tacked on to an existing protocol. If the browser supports keep-alive, it adds an additional header to the request: Following this, the connection ...

CareerSonar Turns Facebook Friends Into Job Connections
Looking for a job ? Among your Facebook friends lies the potential for employment. CareerSonar , a new service, brings together a person’s connections ...

Ben Garcia gives Penrith Panthers a new French connection
Should he jag a game in the NRL, Ben Garcia will become just the third genuine French import to do so.

Man Charged With Aggravated Arson In Connection To Columbus Warehouse Fire
Police have charged 30-year-old Robin Toms with aggravated arson.

Facebook becomes more adept at dealing with crappy connections
... to get a decent phone signal to allow you to post a photo of your meal. Joking aside, in countries where people are struggling with 2G connections ...

Adam Savage from 'MythBusters' has an incredible connection to the 'Star Wars' franchise
Adam Savage, co-host of the popular " MythBusters " television show, soured on the plot of "Interstellar." But when it comes to the newest films ...

French authorities detain suspects in connection to attacks 10 months apart
CNN French authorities detain suspects in connection to attacks 10 months apart CNN A forensic scientist works near a Paris cafe on Saturday, ...

UK Police Make Arrest in Connection With VTech Hacking
British law enforcement officials arrest a 21-year-old man in connection with attack on toy maker VTech that exposed 6 million parents and children ...

Resources last updated: 12/22/2015 6:02:10 AM