Setting up a datasource in Sun 's App Server PE 8.1

Google

Mailing List

Home

Forum Home

JBoss - Java Application Server

Tomcat - JSP/Servlet container

Struts - A MVC web framework

iText - An open source PDF Java Library

JDOM - JDOM XML Parser

JSP - A mailing list about Java Server Pages specification and reference

J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition

J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog

Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology

Struts & Hibernate

Subjects

•	JSP editor plugin for eclipse ?
•	org apache jasper JasperException: Unable to compile class for JSP
•	Tomcat: Connection reset by peer: socket write error
•	Cannot retrieve definition for form bean null
•	Struts Tiles Tutorial (free Struts training)
•	Where do I download Tomcat 4 0 6?
•	Data Access Object (DAO) pattern, example DAO 's
•	Where to download Tomcat v 4 1 24 from?
•	Tomcat 5 0 16 Requested resource not available
•	Subject: Servlet : Session invalidate
•	Oracle Connection Pooling in 3 2 2
•	Servlet action is currently unavailable
•	Tomcat/Struts Unicode Encoding/Decoding problems
•	Subject: Running a Simple JMS Example
•	Tomcat and webapplication specific java library path
•	Mapping in workers2 properties
•	org apache jasper JasperException
•	problem with html:text bean throwing exception
•	Cannot find message resources under key org apache struts action MESSAGE
•	Cannot find message resources under key org apache struts action MESSAGE
•	invalid direct reference problem with solution
•	Tool for jsp debug Try Sysdeo Eclipse Plugin
•	Tomcat 5 Cannot load JDBC driver class 'null ' SQL state: null
•	weblogic ejbc
•	java properties file
•	Jboss 3 2 3 Coyote Can 't re
•	Tomcat 5, Apache2 and mod jk2 integration problem
•	JBoss example problem new to J2EE
•	Value attribute of <html:checkbox
•	url string for connecting jboss to oracle
•	javax servlet ServletException: BeanUtils populate
•	5 0 18: Windows XP Pro vs Windows 2000
•	HTTP Status 404 The requested resource is not available

Setting up a datasource in Sun 's App Server PE 8.1

Setting up a datasource in Sun 's App Server PE 8.1

2005-03-17 - By Darrin Smith

Back

Reply: 1 2 3 4

I need to set up a datasource to access a MS SQL Server database and I have
a couple of questions.

In the Sun Java System Application Server Admin Console I do this:

1) Click JDBC
2) Click Connection Pool

There I add a name for my pool: Call it ss_pool for example.

Then I am given a choice of "Resource Type:". This has three options:

a) javax.sql.Datasource
b) javax.sql.ConnectionPoolDatasource
c) javax.sql.Datasouce

QUESTION 1> Which one should I choose and what difference does it make?

Note that I would like to use the bundled DataDirect drivers if possible.
I have been able to get the JTDS driver to ping, but when I try to install
the bundled one (com.ddtek.jdbcx.sqlserver.SQLServerDataSource) I get this:

An error has occurred.
Operation 'pingConnectionPool' failed in 'resources' Config Mbean. Target
exception message: Class name is wrong or classpath is not set for :
com.ddtek.jdbcx.sqlserver.SQLServerDataSource.

I know that you need to place the driver's jar file in the lib directory
(or somewhere in the classpath), but I would THINK that would have already
been done for the bundled driver!

QUESTION 2> What am I doing wrong with the DataDirect driver (all of the
properties except the Datasource Classname are the same) given that the one
from JTDS does ping?

Thanks!

===========================================================================
To unsubscribe, send email to listserv@(protected) and include in the body
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected) and include in the body of the message "help".