Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Setting an SQL Server Data Source/Connection Cache in EAServer 6.1

31 views
Skip to first unread message

Von M@x

unread,
Nov 10, 2008, 9:31:43 PM11/10/08
to
Does anyone know how to set up a jdbc data source connection for SQL
Server in EAServer 6? The procedure in setting up connection caches
have changed a lot since EAServer 5.3 so we're pretty clueless here.

Here's what we've done so far:
1. Copied the jdbc driver files (msbase.jar, msutil.jar,
mssqlserver.jar) to the lib/ext folder in the EAServer directory.
2. Created a new data source in the Sybase Management Console. Entered
in the usual settings for server name, database name, etc.
3. In the Data Source Driver tab, we put in
"com.microsoft.jdbc.sqlserver.SQLServerDriver" for the JDBC Driver
Class. Left the other two settings (JDBC Data Source Class and JDBC/
XA Data Source Class) blank.
4. An attempt to ping the data source resulted in an error. Here's
the first line in the easerver logs:

ERROR btpool0-1 [DataSource:OCS] The data source '' is missing
configuration for a DataSource class or Driver class.

... and from the stack trace:

com.sybase.djc.DataStoreException: Connection Failed:
java.sql.SQLException: Unable to obtain connection from the data
source 'OCS' due to missing DataSource class or Driver class.

5. I think we need to put in a value for "JDBC Data Source Class" to
resolve this issue but we don't know what to put in. There's no
equivalent of this field in EAServer 5.3 so we're pretty clueless.

Hope someone can help. We've looked at tons of documentation so far
and yielded nothing.

0 new messages