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 Pradyut Bhattacharya

Back

Reply: 1 2 3 4

May be using the jar file (JDBC connector) for sql server available at
Microsoft.com can help

Thanks

Pradyut
<http://pradyut.tk> http://pradyut.tk
<http://groups.yahoo.com/group/d_dom/> http://groups.yahoo.com/group/d_dom/
<http://groups-beta.google.com/group/oop_programming>
http://groups-beta.google.com/group/oop_programming
India

__ __

From: A mailing list for Java(tm) 2 Platform, Enterprise Edition
[mailto:J2EE-INTEREST@(protected)] On Behalf Of Darrin Smith
Sent: Thursday, March 17, 2005 10:14 PM
To: J2EE-INTEREST@(protected)
Subject: Re: Setting up a datasource in Sun's App Server PE 8.1

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
<http://investors.progress.com/phoenix.zhtml?c=86919&p=irol-newsArticle&ID=5
85688&highlight> &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@(protected)>: -- ---- ------

> 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@(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 "hel p".

===========================================================================
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".

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft
-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1=
"urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC
-html40">


<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="country-region
"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>

<style>

</style>

</head>

<body lang=EN-US link=blue vlink=blue>

<div class=Section1>

May be using the jar file (JDBC connector)
for sql server available at Microsoft.com can help<o:p></o:p>

<o:p> </o:p>

Thanks<o:p></o:p>

<o:p> </o:p>

<div>

Pradyut 
<a href="http://pradyut.tk">http://pradyut.tk</a> 
<a href="http://groups.yahoo.com/group/d_dom/">http://groups.yahoo.com/group/d_dom/</a> 
<a href="http://groups-beta.google.com/group/oop_programming">http://groups-beta.google.com/group
/oop_programming</a> 
<st1:country-region w:st="on"><st1:place w:st="on">India</st1:place></st1:country-region><o:p></o:p>

</div>

<div>

<div class=MsoNormal align=center style='text-align:center'>

<hr size=2 width="100%" align=center tabindex=-1>

</div>

From: A mailing list
for Java(tm) 2 Platform, Enterprise Edition [mailto:<st1:PersonName w:st="on"
>J2EE-INTEREST@(protected)</st1:PersonName>]
On Behalf Of Darrin Smith 
Sent: Thursday, March 17, 2005
10:14 PM 
To: <st1:PersonName w:st="on">J2EE
-INTEREST@(protected)</st1:PersonName> 
Subject: Re: Setting up a
datasource in Sun's App Server PE 8.1<o:p></o:p>

</div>

<o:p> </o:p>

I sure
thought that's what I read...if not in so many words:<o:p></o:p>

 <o
:p></o:p>

<a
href="http://www.gridtoday.com/04/0705/103476.html">http://www.gridtoday.com/04
/0705/103476.html</a><o:p></o:p>

 <o
:p></o:p>

<a
href="http://investors.progress.com/phoenix.zhtml?c=86919&p=irol
-newsArticle&ID=585688&highlight">http://investors.progress.com/phoenix
.zhtml?c=86919&p=irol-newsArticle&ID=585688&highlight</a>=<o:p></o:p
>

 <o
:p></o:p>

<a
href="http://www.devx.com/Java/Article/20876/0/page/1">http://www.devx.com/Java
/Article/20876/0/page/1</a><o:p></o:p>

 <o
:p></o:p>

Funny too
that the name I mentioned below
(com.ddtek.jdbcx.sqlserver.SQLServerDataSource) AUTO POPULATED in the
Datasource box!<o:p></o:p>

 <o
:p></o:p>

Maybe
this was planned at one time and taken out?<o:p></o:p>

 <o
:p></o:p>

Anyway,
thanks for clarifying.  I'll try to dig around to find the documentation
you mention.<o:p></o:p>

 <o
:p></o:p>

Thanks.<o
:p></o:p>

 <o
:p></o:p>

Darrin<o
:p></o:p>

 
 <o:p></o:p>

<blockquote style='border:none;border-left:solid #1010FF 1.5pt;padding:0in 0in
0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-bottom:5.0pt'>

-- ---- ------ Original message from "Lance J. Andersen" &lt
;Lance.Andersen@(protected)>:
-- ---- ------ 
 
 
> 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@(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 "hel
p". <o:p></o:p>

</blockquote>

</div>


</body>

</html>
===========================================================================
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".