 | 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
|
|
|
| | | 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 Lance J. Andersen
Back
We do not bundle the Driver you listed below.
We bundle the Sun JDBC driver and its configuration info is available in
the SJSAS 8.1 documentation
Regards
Lance
Darrin Smith wrote:
>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".
>
>
===========================================================================
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".
|
|
|
