[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-java
Subject:    RE: MySQL and WSAD Version 5 Server and Datasource
From:       "Collins, Danny" <Danny.Collins () LibertyMutual ! com>
Date:       2003-04-17 16:03:53
[Download RAW message or body]

Well I figured out how to get the lookup to work:

<resource-ref>

<description>Primary database pool</description>

<res-ref-name>jdbc/dmc</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Application</res-auth>

<res-sharing-scope>Unshareable</res-sharing-scope>

</resource-ref>

The above had to be defined in the web.xml in order for me to be able to
find the datasource

Now to make it work...

-----Original Message-----
From: Keith Hatton [mailto:khatton@axiomsystems.com] 
Sent: Thursday, April 17, 2003 11:58 AM
To: Collins, Danny; java@lists.mysql.com
Subject: RE: MySQL and WSAD Version 5 Server and Datasource


Hmm, having re-read your mail perhaps I was a bit too quick ... I
haven't used WSAD, but I have had WAS 5 working against a MySQL
datasource, thanks to a little help from Mark Matthews. It was a couple
of months ago, I did have some problems but don't remember all the
details, you might like to check the list archive ...


-----Original Message-----
From: Collins, Danny [mailto:Danny.Collins@LibertyMutual.com]
Sent: 17 April 2003 16:54
To: Keith Hatton; java@lists.mysql.com
Subject: RE: MySQL and WSAD Version 5 Server and Datasource


Thanks for the quick response. A quick test shows that:

[4/17/03 11:52:33:252 EDT] 4f8f4e83 SystemOut     O Name comp/env/jdbc
not found in context "java:".


Any ideas? Also have you set up MySQL in WSAD as a datasource yet?

TIA
Danny


-----Original Message-----
From: Keith Hatton [mailto:khatton@axiomsystems.com] 
Sent: Thursday, April 17, 2003 11:41 AM
To: Collins, Danny; java@lists.mysql.com
Subject: RE: MySQL and WSAD Version 5 Server and Datasource


Hi Danny,

If you create an InitialContext with the default constructor, your JNDI
lookup should be "java:comp/env/jdbc/dmc".

Hope this helps
Keith


-----Original Message-----
From: Collins, Danny [mailto:Danny.Collins@LibertyMutual.com]
Sent: 17 April 2003 16:21
To: java@lists.mysql.com
Subject: MySQL and WSAD Version 5 Server and Datasource


Hello All,
	I am attempting to use WSAD V5 to set up a datasource - this is
for a WAS V5 App Server. Has anyone else attempted this? I think I have
the majority of the datasource setup correct but when I do a look up I
keep getting:

This trace is kinda long, but I am loosing a lot of time on this and I
can't find anything from IBM to help me resolve it.

TIA
Danny


[4/17/03 10:57:47:202 EDT] 1e054826 ConnectionFac I J2CA0122I: Resource
reference jdbc/dmc could not be located, so default values of the
following are used: [Resource-ref settings]

	res-auth:                 1 (APPLICATION)
	res-isolation-level:      0 (TRANSACTION_NONE)
	res-sharing-scope:        true (SHAREABLE)
	res-resolution-control:   999 (undefined)



<Code Snippet>

	Context ctx = new InitialContext();
				
	DataSource ds = (DataSource) ctx.lookup("jdbc/dmc");

</Code Snippet>



-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/java?unsub=mysql-java@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]