I sure thought that's what I read...if not in so many words:

 

http://www.gridtoday.com/04/0705/103476.html

 

http://investors.progress.com/phoenix.zhtml?c=86919&p=irol-newsArticle&ID=585688&highlight=

 

http://www.devx.com/Java/Article/20876/0/page/1

 

Funny too that the name I mentioned below (com.ddtek.jdbcx.sqlserver.SQLServerDataSource) AUTO POPULATED in the Datasource box!

 

Maybe this was planned at one time and taken out?

 

Anyway, thanks for clarifying.  I'll try to dig around to find the documentation you mention.

 

Thanks.

 

Darrin

 

-------------- Original message from "Lance J. Andersen" <Lance.Andersen@SUN.COM>: --------------


> 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 d river!
> >
> >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@java.sun.com and include in the body
> >of the message "signoff J2EE-INTEREST". For general help, send email to
> >listserv@java.sun.com and include in the body of the message "help".
> >
> >
>
> ===========================================================================
> To unsubscribe, send email to listserv@java.sun.com and include in the body
> of the message "signoff J2EE-INTEREST". For general help, send email to
> listserv@java.sun.com and include in the body of the message "hel p".

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