Cedric,
Thanks, I will try that, but from what I understand, the jdbc/ bit is actuall just a label which is used to, ultimately, look up the jndi datasource name defined in the weblogic.xml. What appears to be happening is that we get a "java:comp/env/jdbc/" prepended to the jndi name by excalibur when it does the lookup - WL, obviously does not need this.
Cheers,
John
-----Original Message-----
From: Cedric Picard [mailto:[EMAIL PROTECTED]]
Sent: 08 August 2003 11:47
To: [EMAIL PROTECTED]
Subject: RE: jndi datasource lookup from cocoon 2.0.4 on weblogic 7
John,
as far as I know, you do not need to provide "jdbc/" in the dbname tag of the j2ee entry in cocoon.xconf (this is added automatically to the JNDI name).
I am currently trying to do exactly the same with JBuilder/BES and cocoon 2.0.3 and talking to Borland about how to set things up (our problem is that we are currently using JDBC1.x datasources which are not shared between JARs/WARs as far as I could see).
I guess the first thing is to find out if you are using JDBC1 or JDBC2 datasources.
If you already are using JDBC2 datasources, then removing "jdbc/" in the dbname tag *should* do the trick.
Otherwise, please bear with me, I'll post a message as soon as I get this working with JDBC1 datasources (solution would appear to require a Definitions ARchive, more to come).
Hope that helps,
Cedric
-----Original Message-----
From: Grange, John [mailto:[EMAIL PROTECTED]]
Sent: 08 August 2003 11:29
To: '[EMAIL PROTECTED]'
Subject: FW: jndi datasource lookup from cocoon 2.0.4 on weblogic 7
Has anybody any thoughts on this one?
-----Original Message-----
From: Grange, John [mailto:[EMAIL PROTECTED]]
Sent: 06 August 2003 09:01
To: '[EMAIL PROTECTED]'
Subject: jndi datasource lookup from cocoon 2.0.4 on weblogic 7
I am trying to get the j2ee jndi datasource lookup working under weblogic 7, without success. My xsp page fails with a null pointer exception in EsqlQuery.java:99 and produces a malformed xml document (no closing tags)
Has anybody else had this problem - if so, how have they resolved it? If this is not the correct list to report this to, can you please let me know where to report it.
It appears (looking in the excalibur code) that java:comp/env is prepended to the jndi name when performing a lookup, this is not required under weblogic, and as such fails if it is included.
The following code DOES NOT work under WebLogic
InitialContext ctx = new InitialContext();
Object obj = ctx.lookup("java:comp/env/jdbc/"+"myDataSourceName");
The following code DOES work under WebLogic
InitialContext ctx = new InitialContext();
Object obj = ctx.lookup("myDataSourceName");
My setup configuration is as follows:
cocoon.xconf:
<datasources>
<j2ee name="reportDataSource">
<dbname>jdbc/reportsDS</dbname>
</j2ee>
</datasources>
web.xml:
<resource-ref>
<res-ref-name>jdbc/reportsDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
weblogic.xml:
<weblogic-web-app>
<description>
Cocoon App
</description>
<reference-descriptor>
<resource-description>
<res-ref-name>jdbc/reportsDS</res-ref-name>
<jndi-name>com.lv.jdbc.oracle.ReportsTxDataSource</jndi-name>
</resource-description>
</reference-descriptor>
</weblogic-web-app>
John Grange
Software Team Leader
Tel: +44 (0) 1749 834922
Email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park, Wookey Hole Road, Wells, Somerset, BA5 1AF, UK
Tel: +44 (0) 1749 834900
Fax: +44 (0) 1749 834902
Mobile: +44 (0) 7876 038058
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.***
--
This e-mail is confidential and is intended for the named recipient only. If
you receive it in error please destroy the message and all copies. Kainos
Software Ltd. does not accept liability for damage sustained as a result of
malicious software (e.g. viruses). Kainos does not accept liability for, or
permit, the creation of contracts on its behalf by e-mail, the publication of
any defamatory statement by its employees by e-mail, or changes subsequently
made to the original message. The Company's registered office is located at
4-6 Upper Crescent, Belfast, BT7 1NT, Northern Ireland, Tel +44 28 9057 1100.
