Home » Archived » BIRT » BIRT 2.3.2 - JNDI error: NameNotFoundException
|
| Re: BIRT 2.3.2 - JNDI error: NameNotFoundException [message #368374 is a reply to message #368365] |
Tue, 26 May 2009 15:28   |
Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
John,
Can you try
java:/db1
Jason
John wrote:
> I've a BIRT 2.2.1 report, which uses "JNDI URL=java:/comp/env/jdbc/db1".
> This works fine in my appserver.
> Now I changed th BIRT runtime to BIRT 2.3.2 and I get following error:
> [exec] 26.05.2009 14:24:10
> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
> [exec] INFO: javax.naming.NameNotFoundException: Name comp is not
> bound in this Context
>
> What is wrong??
> I also opened the report in 2.3.2 and saved it in 2.3.2 format - no
> changes!
> I also tried "java:/jdbc/db1" - no changes!
> I also tried "/jdbc/db1" - no changes!
>
> I use "java:/comp/env/jdbc/db1" everywhere in my app (in servlets and so
> on) and it works - so the JNDI entry exists and DB-Connection is correct.
>
> Any ideas??
>
> THX!
|
|
| |
| Re: BIRT 2.3.2 - JNDI error: NameNotFoundException [message #368394 is a reply to message #368382] |
Wed, 27 May 2009 16:51 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
John,
What exception did you get with it?
Jason
John wrote:
> java:/db1 also doen't work
>
> John
>
> Jason Weathersby schrieb:
>> John,
>>
>> Can you try
>>
>> java:/db1
>>
>> Jason
>>
>> John wrote:
>>> I've a BIRT 2.2.1 report, which uses "JNDI
>>> URL=java:/comp/env/jdbc/db1". This works fine in my appserver.
>>> Now I changed th BIRT runtime to BIRT 2.3.2 and I get following error:
>>> [exec] 26.05.2009 14:24:10
>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp is not
>>> bound in this Context
>>>
>>> What is wrong??
>>> I also opened the report in 2.3.2 and saved it in 2.3.2 format - no
>>> changes!
>>> I also tried "java:/jdbc/db1" - no changes!
>>> I also tried "/jdbc/db1" - no changes!
>>>
>>> I use "java:/comp/env/jdbc/db1" everywhere in my app (in servlets and
>>> so on) and it works - so the JNDI entry exists and DB-Connection is
>>> correct.
>>>
>>> Any ideas??
>>>
>>> THX!
|
|
|
| Re: BIRT 2.3.2 - JNDI error: NameNotFoundException [message #368395 is a reply to message #368394] |
Wed, 27 May 2009 16:52 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
Also what app server are you using?
Jason Weathersby wrote:
> John,
>
> What exception did you get with it?
>
> Jason
>
> John wrote:
>> java:/db1 also doen't work
>>
>> John
>>
>> Jason Weathersby schrieb:
>>> John,
>>>
>>> Can you try
>>>
>>> java:/db1
>>>
>>> Jason
>>>
>>> John wrote:
>>>> I've a BIRT 2.2.1 report, which uses "JNDI
>>>> URL=java:/comp/env/jdbc/db1". This works fine in my appserver.
>>>> Now I changed th BIRT runtime to BIRT 2.3.2 and I get following error:
>>>> [exec] 26.05.2009 14:24:10
>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp is
>>>> not bound in this Context
>>>>
>>>> What is wrong??
>>>> I also opened the report in 2.3.2 and saved it in 2.3.2 format - no
>>>> changes!
>>>> I also tried "java:/jdbc/db1" - no changes!
>>>> I also tried "/jdbc/db1" - no changes!
>>>>
>>>> I use "java:/comp/env/jdbc/db1" everywhere in my app (in servlets
>>>> and so on) and it works - so the JNDI entry exists and DB-Connection
>>>> is correct.
>>>>
>>>> Any ideas??
>>>>
>>>> THX!
|
|
| |
| Re: BIRT 2.3.2 - JNDI error: NameNotFoundException [message #368423 is a reply to message #368414] |
Thu, 28 May 2009 15:22 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
John,
What I do not understand is that the error
Name comp is not bound in this Context
is complaining about comp, which the name I asked you to try did not
have in it.
Jason
John wrote:
> Error:
> [exec] 26.05.2009 14:24:10
> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
> [exec] INFO: javax.naming.NameNotFoundException: Name comp is not bound
> in this Context
>
> Server is tomcat 5.5.27
>
> As stated before: Report works fine with BIRT runtime 2.2.1?!
>
> Now I made a tiny new report (simple Datasource/set and 1 table) with
> BIRT 2.3.2, and I've the same problem :-(
>
> Jason Weathersby schrieb:
>> Also what app server are you using?
>>
>> Jason Weathersby wrote:
>>> John,
>>>
>>> What exception did you get with it?
>>>
>>> Jason
>>>
>>> John wrote:
>>>> java:/db1 also doen't work
>>>>
>>>> John
>>>>
>>>> Jason Weathersby schrieb:
>>>>> John,
>>>>>
>>>>> Can you try
>>>>>
>>>>> java:/db1
>>>>>
>>>>> Jason
>>>>>
>>>>> John wrote:
>>>>>> I've a BIRT 2.2.1 report, which uses "JNDI
>>>>>> URL=java:/comp/env/jdbc/db1". This works fine in my appserver.
>>>>>> Now I changed th BIRT runtime to BIRT 2.3.2 and I get following
>>>>>> error:
>>>>>> [exec] 26.05.2009 14:24:10
>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp is
>>>>>> not bound in this Context
>>>>>>
>>>>>> What is wrong??
>>>>>> I also opened the report in 2.3.2 and saved it in 2.3.2 format -
>>>>>> no changes!
>>>>>> I also tried "java:/jdbc/db1" - no changes!
>>>>>> I also tried "/jdbc/db1" - no changes!
>>>>>>
>>>>>> I use "java:/comp/env/jdbc/db1" everywhere in my app (in servlets
>>>>>> and so on) and it works - so the JNDI entry exists and
>>>>>> DB-Connection is correct.
>>>>>>
>>>>>> Any ideas??
>>>>>>
>>>>>> THX!
|
|
| |
| Re: BIRT 2.3.2 - JNDI error: NameNotFoundException [message #368445 is a reply to message #368431] |
Fri, 29 May 2009 15:50 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
John,
I just setup my webviewer application as described here
http://wiki.eclipse.org/BIRT/FAQ/Deployment#Q:_How_do_I_setu p_BIRT_to_use_Tomcat_Connection_Pooling
The only difference I made was that I put the context.xml in the
tomcat-5.5.20\conf directory. I used the url in the wiki and everything
worked fine. I changed the username just to verify that the connection
pool was working.
Jason
John wrote:
> If I use JNDI Url=java:/comp/env/jdbc/db1
> I get
> [exec] 28.05.2009 20:59:20
> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
> [exec] INFO: javax.naming.NameNotFoundException: Name comp is not
> bound in this Context
>
> If I use JNDI Url=java:/jdbc/db1
> I get
> [exec] 28.05.2009 21:04:20
> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
> [exec] INFO: javax.naming.NameNotFoundException: Name db1 is not
> bound in this Context
>
> If I use JNDI Url=/jdbc/db1
> I get
> [exec] 28.05.2009 21:05:37
> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
> [exec] INFO: javax.naming.NameNotFoundException: Name jdbc is not
> bound in this Context
>
> If I use JNDI Url=java:/db1
> I get
> [exec] 28.05.2009 21:01:38
> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
> [exec] INFO: javax.naming.NameNotFoundException: Name db1 is not
> bound in this Context
>
> Does 'java:/db1' make any sense? Because the resource is defined as
> "jdbc/db1"? Does BIRT guess "jdbc"?
>
> Whats the difference between BIRT 2.2.1 and 2.3.2 and JNDI handling? (As
> I stated before in 2.2.1 it works. I'm impatient of BIRT upgrades there
> are always so a lot of new bugs (besides the old ones). We are using
> BIRT for about three years. Always hoping having a stable less buggy
> product after an upgrade. But there are so much bugs and a lot of tiny
> inconviences at design time that makes reporting a hell. We are really
> considering putting three years work to garbage.
>
> Jason Weathersby schrieb:
>> John,
>>
>> What I do not understand is that the error
>>
>> Name comp is not bound in this Context
>>
>> is complaining about comp, which the name I asked you to try did not
>> have in it.
>>
>> Jason
>>
>> John wrote:
>>> Error:
>>> [exec] 26.05.2009 14:24:10
>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp is not
>>> bound in this Context
>>>
>>> Server is tomcat 5.5.27
>>>
>>> As stated before: Report works fine with BIRT runtime 2.2.1?!
>>>
>>> Now I made a tiny new report (simple Datasource/set and 1 table) with
>>> BIRT 2.3.2, and I've the same problem :-(
>>>
>>> Jason Weathersby schrieb:
>>>> Also what app server are you using?
>>>>
>>>> Jason Weathersby wrote:
>>>>> John,
>>>>>
>>>>> What exception did you get with it?
>>>>>
>>>>> Jason
>>>>>
>>>>> John wrote:
>>>>>> java:/db1 also doen't work
>>>>>>
>>>>>> John
>>>>>>
>>>>>> Jason Weathersby schrieb:
>>>>>>> John,
>>>>>>>
>>>>>>> Can you try
>>>>>>>
>>>>>>> java:/db1
>>>>>>>
>>>>>>> Jason
>>>>>>>
>>>>>>> John wrote:
>>>>>>>> I've a BIRT 2.2.1 report, which uses "JNDI
>>>>>>>> URL=java:/comp/env/jdbc/db1". This works fine in my appserver.
>>>>>>>> Now I changed th BIRT runtime to BIRT 2.3.2 and I get following
>>>>>>>> error:
>>>>>>>> [exec] 26.05.2009 14:24:10
>>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp
>>>>>>>> is not bound in this Context
>>>>>>>>
>>>>>>>> What is wrong??
>>>>>>>> I also opened the report in 2.3.2 and saved it in 2.3.2 format -
>>>>>>>> no changes!
>>>>>>>> I also tried "java:/jdbc/db1" - no changes!
>>>>>>>> I also tried "/jdbc/db1" - no changes!
>>>>>>>>
>>>>>>>> I use "java:/comp/env/jdbc/db1" everywhere in my app (in
>>>>>>>> servlets and so on) and it works - so the JNDI entry exists and
>>>>>>>> DB-Connection is correct.
>>>>>>>>
>>>>>>>> Any ideas??
>>>>>>>>
>>>>>>>> THX!
|
|
| |
| Re: BIRT 2.3.2 - JNDI error: NameNotFoundException [message #368613 is a reply to message #368607] |
Mon, 15 June 2009 15:06 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
John,
If you post your code I will try it with a servlet, but it should not
matter. Could you deploy the webviewer as a test?
Jason
John wrote:
> I do not use the birt webviewer - I directly call runAndRender() from
> the BIRT API.
> As I mentioned before: It works perfectly with runtime 2.2.1 and if I
> change to runtime 2.3.2 I get the error...
>
>
> Jason Weathersby schrieb:
>> John,
>>
>> I just setup my webviewer application as described here
>> http://wiki.eclipse.org/BIRT/FAQ/Deployment#Q:_How_do_I_setu p_BIRT_to_use_Tomcat_Connection_Pooling
>>
>>
>> The only difference I made was that I put the context.xml in the
>> tomcat-5.5.20\conf directory. I used the url in the wiki and
>> everything worked fine. I changed the username just to verify that
>> the connection pool was working.
>>
>> Jason
>>
>> John wrote:
>>> If I use JNDI Url=java:/comp/env/jdbc/db1
>>> I get
>>> [exec] 28.05.2009 20:59:20
>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp is
>>> not bound in this Context
>>>
>>> If I use JNDI Url=java:/jdbc/db1
>>> I get
>>> [exec] 28.05.2009 21:04:20
>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>> [exec] INFO: javax.naming.NameNotFoundException: Name db1 is not
>>> bound in this Context
>>>
>>> If I use JNDI Url=/jdbc/db1
>>> I get
>>> [exec] 28.05.2009 21:05:37
>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>> [exec] INFO: javax.naming.NameNotFoundException: Name jdbc is
>>> not bound in this Context
>>>
>>> If I use JNDI Url=java:/db1
>>> I get
>>> [exec] 28.05.2009 21:01:38
>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>> [exec] INFO: javax.naming.NameNotFoundException: Name db1 is not
>>> bound in this Context
>>>
>>> Does 'java:/db1' make any sense? Because the resource is defined as
>>> "jdbc/db1"? Does BIRT guess "jdbc"?
>>>
>>> Whats the difference between BIRT 2.2.1 and 2.3.2 and JNDI handling?
>>> (As I stated before in 2.2.1 it works. I'm impatient of BIRT upgrades
>>> there are always so a lot of new bugs (besides the old ones). We are
>>> using BIRT for about three years. Always hoping having a stable less
>>> buggy product after an upgrade. But there are so much bugs and a lot
>>> of tiny inconviences at design time that makes reporting a hell. We
>>> are really considering putting three years work to garbage.
>>>
>>> Jason Weathersby schrieb:
>>>> John,
>>>>
>>>> What I do not understand is that the error
>>>>
>>>> Name comp is not bound in this Context
>>>>
>>>> is complaining about comp, which the name I asked you to try did not
>>>> have in it.
>>>>
>>>> Jason
>>>>
>>>> John wrote:
>>>>> Error:
>>>>> [exec] 26.05.2009 14:24:10
>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp is not
>>>>> bound in this Context
>>>>>
>>>>> Server is tomcat 5.5.27
>>>>>
>>>>> As stated before: Report works fine with BIRT runtime 2.2.1?!
>>>>>
>>>>> Now I made a tiny new report (simple Datasource/set and 1 table)
>>>>> with BIRT 2.3.2, and I've the same problem :-(
>>>>>
>>>>> Jason Weathersby schrieb:
>>>>>> Also what app server are you using?
>>>>>>
>>>>>> Jason Weathersby wrote:
>>>>>>> John,
>>>>>>>
>>>>>>> What exception did you get with it?
>>>>>>>
>>>>>>> Jason
>>>>>>>
>>>>>>> John wrote:
>>>>>>>> java:/db1 also doen't work
>>>>>>>>
>>>>>>>> John
>>>>>>>>
>>>>>>>> Jason Weathersby schrieb:
>>>>>>>>> John,
>>>>>>>>>
>>>>>>>>> Can you try
>>>>>>>>>
>>>>>>>>> java:/db1
>>>>>>>>>
>>>>>>>>> Jason
>>>>>>>>>
>>>>>>>>> John wrote:
>>>>>>>>>> I've a BIRT 2.2.1 report, which uses "JNDI
>>>>>>>>>> URL=java:/comp/env/jdbc/db1". This works fine in my appserver.
>>>>>>>>>> Now I changed th BIRT runtime to BIRT 2.3.2 and I get
>>>>>>>>>> following error:
>>>>>>>>>> [exec] 26.05.2009 14:24:10
>>>>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
>>>>>>>>>> getConnection
>>>>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp
>>>>>>>>>> is not bound in this Context
>>>>>>>>>>
>>>>>>>>>> What is wrong??
>>>>>>>>>> I also opened the report in 2.3.2 and saved it in 2.3.2 format
>>>>>>>>>> - no changes!
>>>>>>>>>> I also tried "java:/jdbc/db1" - no changes!
>>>>>>>>>> I also tried "/jdbc/db1" - no changes!
>>>>>>>>>>
>>>>>>>>>> I use "java:/comp/env/jdbc/db1" everywhere in my app (in
>>>>>>>>>> servlets and so on) and it works - so the JNDI entry exists
>>>>>>>>>> and DB-Connection is correct.
>>>>>>>>>>
>>>>>>>>>> Any ideas??
>>>>>>>>>>
>>>>>>>>>> THX!
|
|
|
| Re: BIRT 2.3.2 - JNDI error: NameNotFoundException [message #369052 is a reply to message #368613] |
Thu, 23 July 2009 09:20 |
 John Missing name
Messages: 513
Registered: July 2009 |
Senior Member |
|
|
Maybe it's a classloader problem??
By debugging in the birts depth i saw "IConnectionFactory.PASS_IN_CONNECTION"!
So I do a jndi lookup in my code (instead of letting thios done by birt) and call
task.getAppContext().put(IConnectionFactory.PASS_IN_CONNECTI ON,sqlConnection);
before "runAndRender" - and now it works.
Is there somewhere an overview which appContext parameters exists???
There seems to be a lot of useful things by I never found any documentation!!
John
Jason Weathersby schrieb:
> John,
>
> If you post your code I will try it with a servlet, but it should not
> matter. Could you deploy the webviewer as a test?
>
> Jason
>
> John wrote:
>> I do not use the birt webviewer - I directly call runAndRender() from
>> the BIRT API.
>> As I mentioned before: It works perfectly with runtime 2.2.1 and if I
>> change to runtime 2.3.2 I get the error...
>>
>>
>> Jason Weathersby schrieb:
>>> John,
>>>
>>> I just setup my webviewer application as described here
>>> http://wiki.eclipse.org/BIRT/FAQ/Deployment#Q:_How_do_I_setu p_BIRT_to_use_Tomcat_Connection_Pooling
>>>
>>>
>>> The only difference I made was that I put the context.xml in the
>>> tomcat-5.5.20\conf directory. I used the url in the wiki and
>>> everything worked fine. I changed the username just to verify that
>>> the connection pool was working.
>>>
>>> Jason
>>>
>>> John wrote:
>>>> If I use JNDI Url=java:/comp/env/jdbc/db1
>>>> I get
>>>> [exec] 28.05.2009 20:59:20
>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp is
>>>> not bound in this Context
>>>>
>>>> If I use JNDI Url=java:/jdbc/db1
>>>> I get
>>>> [exec] 28.05.2009 21:04:20
>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>> [exec] INFO: javax.naming.NameNotFoundException: Name db1 is
>>>> not bound in this Context
>>>>
>>>> If I use JNDI Url=/jdbc/db1
>>>> I get
>>>> [exec] 28.05.2009 21:05:37
>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>> [exec] INFO: javax.naming.NameNotFoundException: Name jdbc is
>>>> not bound in this Context
>>>>
>>>> If I use JNDI Url=java:/db1
>>>> I get
>>>> [exec] 28.05.2009 21:01:38
>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>> [exec] INFO: javax.naming.NameNotFoundException: Name db1 is
>>>> not bound in this Context
>>>>
>>>> Does 'java:/db1' make any sense? Because the resource is defined as
>>>> "jdbc/db1"? Does BIRT guess "jdbc"?
>>>>
>>>> Whats the difference between BIRT 2.2.1 and 2.3.2 and JNDI handling?
>>>> (As I stated before in 2.2.1 it works. I'm impatient of BIRT
>>>> upgrades there are always so a lot of new bugs (besides the old
>>>> ones). We are using BIRT for about three years. Always hoping having
>>>> a stable less buggy product after an upgrade. But there are so much
>>>> bugs and a lot of tiny inconviences at design time that makes
>>>> reporting a hell. We are really considering putting three years work
>>>> to garbage.
>>>>
>>>> Jason Weathersby schrieb:
>>>>> John,
>>>>>
>>>>> What I do not understand is that the error
>>>>>
>>>>> Name comp is not bound in this Context
>>>>>
>>>>> is complaining about comp, which the name I asked you to try did
>>>>> not have in it.
>>>>>
>>>>> Jason
>>>>>
>>>>> John wrote:
>>>>>> Error:
>>>>>> [exec] 26.05.2009 14:24:10
>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp is not
>>>>>> bound in this Context
>>>>>>
>>>>>> Server is tomcat 5.5.27
>>>>>>
>>>>>> As stated before: Report works fine with BIRT runtime 2.2.1?!
>>>>>>
>>>>>> Now I made a tiny new report (simple Datasource/set and 1 table)
>>>>>> with BIRT 2.3.2, and I've the same problem :-(
>>>>>>
>>>>>> Jason Weathersby schrieb:
>>>>>>> Also what app server are you using?
>>>>>>>
>>>>>>> Jason Weathersby wrote:
>>>>>>>> John,
>>>>>>>>
>>>>>>>> What exception did you get with it?
>>>>>>>>
>>>>>>>> Jason
>>>>>>>>
>>>>>>>> John wrote:
>>>>>>>>> java:/db1 also doen't work
>>>>>>>>>
>>>>>>>>> John
>>>>>>>>>
>>>>>>>>> Jason Weathersby schrieb:
>>>>>>>>>> John,
>>>>>>>>>>
>>>>>>>>>> Can you try
>>>>>>>>>>
>>>>>>>>>> java:/db1
>>>>>>>>>>
>>>>>>>>>> Jason
>>>>>>>>>>
>>>>>>>>>> John wrote:
>>>>>>>>>>> I've a BIRT 2.2.1 report, which uses "JNDI
>>>>>>>>>>> URL=java:/comp/env/jdbc/db1". This works fine in my appserver.
>>>>>>>>>>> Now I changed th BIRT runtime to BIRT 2.3.2 and I get
>>>>>>>>>>> following error:
>>>>>>>>>>> [exec] 26.05.2009 14:24:10
>>>>>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
>>>>>>>>>>> getConnection
>>>>>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name
>>>>>>>>>>> comp is not bound in this Context
>>>>>>>>>>>
>>>>>>>>>>> What is wrong??
>>>>>>>>>>> I also opened the report in 2.3.2 and saved it in 2.3.2
>>>>>>>>>>> format - no changes!
>>>>>>>>>>> I also tried "java:/jdbc/db1" - no changes!
>>>>>>>>>>> I also tried "/jdbc/db1" - no changes!
>>>>>>>>>>>
>>>>>>>>>>> I use "java:/comp/env/jdbc/db1" everywhere in my app (in
>>>>>>>>>>> servlets and so on) and it works - so the JNDI entry exists
>>>>>>>>>>> and DB-Connection is correct.
>>>>>>>>>>>
>>>>>>>>>>> Any ideas??
>>>>>>>>>>>
>>>>>>>>>>> THX!
|
|
|
| Re: BIRT 2.3.2 - JNDI error: NameNotFoundException [message #369061 is a reply to message #369052] |
Thu, 23 July 2009 16:32 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
John,
Run this report in the designer /preview
Jason
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.3.2.r232_20090202 Build <2.3.2.v20090218-0730></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2006 Innovent Solutions,
Inc.</property>
<method name="beforeFactory"><![CDATA[// Create a hash table which
will contain lists of other lists
var topMap = new Packages.java.util.Hashtable();
// Request Attributes
var request = reportContext.getHttpServletRequest();
var requestAttrMap = new Packages.java.util.Hashtable();
var attrNames = request.getAttributeNames();
do {
var aName = attrNames.nextElement();
requestAttrMap.put(aName, request.getAttribute(aName).toString());
} while (attrNames.hasMoreElements())
topMap.put("requestAttributes", requestAttrMap);
// Request Parameters
var requestParamMap = new Packages.java.util.Hashtable();
var paramIter = request.getParameterMap().entrySet().iterator();
do{
var entry = paramIter.next();
requestParamMap.put(entry.getKey(), (entry.getValue()[0]));
} while (paramIter.hasNext())
topMap.put("requestParameters",requestParamMap);
// Session Attributes
var sessionAttrMap = new Packages.java.util.Hashtable();
var session = request.getSession();
// Insert a variable on the session
session.setAttribute("ReportAttribute", "arbitrary value to pass to
container");
var sessionAttrNames = session.getAttributeNames();
var i = 0;
do {
i ++;
var aaa = sessionAttrNames.nextElement();
sessionAttrMap.put(aaa, session.getAttribute(aaa));
} while (sessionAttrNames.hasMoreElements())
topMap.put("sessionAttributes", sessionAttrMap);
// Session Attributes
var ac = reportContext.getAppContext();
topMap.put("AppContextAttributes", ac);
// Get the system properties
topMap.put("systemProps", Packages.java.lang.System.getProperties());
// Store top map as a global
reportContext.setPersistentGlobalVariable("topMap", topMap);]]></method>
<data-sources>
<script-data-source name="setScript" id="4"/>
</data-sources>
<data-sets>
<script-data-set name="setEnvironmentVars" id="5">
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">propName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">propValue</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">propType</property>
<property name="dataType">string</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">propName</property>
</structure>
<structure>
<property name="columnName">propValue</property>
</structure>
<structure>
<property name="columnName">propType</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">propName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">propValue</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">propType</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">setScript</property>
<method name="open"><![CDATA[aMap =
reportContext.getPersistentGlobalVariable("topMap");
topIter = aMap.entrySet().iterator();
if (topIter == null)
{
topIterator = new Packages.java.util.Iterator();
//Packages.java.util.logging.Logger.getLogger("").info("OPEN NULL " );
}
innerIter = null;]]></method>
<method name="fetch"><![CDATA[do
{ // find an innerIter that has a new value
if (innerIter == null || innerIter.hasNext() == false)
{ // no value in the inner iterator, get the next Hashtable out of the
toHashtable
if (topIter.hasNext())
{
outerObject = topIter.next();
innerIter = outerObject.getValue().entrySet().iterator();
}
else
{ // no more top hash tables. close things up
return false;
}
}
}
while (innerIter.hasNext() == false)
// we must have another innerIter
innerObject = innerIter.next();
if( innerObject != null ){
row["propName"] = innerObject.getKey();
if( innerObject.getValue() != null ){
row["propValue"] = innerObject.getValue().toString();
}else{
row["propValue"] = "";
}
row["propType"] = outerObject.getKey();
}else{
row["propName"] = "";
row["propValue"] = "";
row["propType"] = "";
}
return true;
/*
Iterator i = topMap.entrySet().iterator();
while (i.hasNext()) {
Entry entry = (Entry) i.next();
logger.info(entry.getKey() + " " + entry.getValue() );
}
*/]]></method>
</script-data-set>
</data-sets>
<styles>
<style name="detail" id="36">
<property name="backgroundColor">#FFFF80</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
</style>
<style name="headerfooter" id="37">
<property name="backgroundColor">#004080</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<property name="color">#FFFFFF</property>
</style>
<style name="groupheader" id="38">
<property name="backgroundColor">#0080FF</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<property name="color">#FFFFFF</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="orientation">landscape</property>
<property name="topMargin">0.5in</property>
<property name="leftMargin">0.5in</property>
<property name="bottomMargin">0.5in</property>
<property name="rightMargin">0.5in</property>
</simple-master-page>
</page-setup>
<body>
<table id="6">
<property name="width">100%</property>
<property name="dataSet">setEnvironmentVars</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">propName</property>
<expression
name="expression">dataSetRow["propName"]</expression>
</structure>
<structure>
<property name="name">propValue</property>
<expression
name="expression">dataSetRow["propValue"]</expression>
</structure>
<structure>
<property name="name">propType</property>
<expression
name="expression">dataSetRow["propType"]</expression>
<simple-property-list name="aggregateOn">
<value>propType</value>
</simple-property-list>
</structure>
</list-property>
<property name="pageBreakInterval">50</property>
<column id="16"/>
<column id="17"/>
<header>
<row id="7">
<property name="style">headerfooter</property>
<cell id="8">
<label id="18">
<text-property
name="text">propName</text-property>
</label>
</cell>
<cell id="9">
<label id="20">
<text-property
name="text">propValue</text-property>
</label>
</cell>
</row>
</header>
<group id="22">
<property name="groupName">propType</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["propType"]</expression>
<structure name="toc">
<expression
name="expressionValue">row["propType"]</expression>
</structure>
<header>
<row id="23">
<property name="backgroundColor">#FFFF80</property>
<cell id="24">
<data id="29">
<property name="fontWeight">bold</property>
<property
name="resultSetColumn">propType</property>
</data>
</cell>
<cell id="25"/>
</row>
<row id="33">
<property name="height">2pt</property>
<property name="backgroundColor">#000000</property>
<cell id="34"/>
<cell id="35"/>
</row>
</header>
<footer>
<row id="26">
<cell id="27"/>
<cell id="28"/>
</row>
</footer>
</group>
<detail>
<row id="10">
<property name="style">groupheader</property>
<cell id="11">
<data id="19">
<property name="fontSize">small</property>
<property
name="resultSetColumn">propName</property>
</data>
</cell>
<cell id="12">
<data id="21">
<property name="fontSize">small</property>
<property
name="resultSetColumn">propValue</property>
</data>
</cell>
</row>
<row id="30">
<property name="height">2pt</property>
<property name="backgroundColor">#C0C0C0</property>
<cell id="31"/>
<cell id="32"/>
</row>
</detail>
<footer>
<row id="13">
<cell id="14"/>
<cell id="15"/>
</row>
</footer>
</table>
</body>
</report>
John wrote:
> Maybe it's a classloader problem??
>
> By debugging in the birts depth i saw
> "IConnectionFactory.PASS_IN_CONNECTION"!
>
> So I do a jndi lookup in my code (instead of letting thios done by birt)
> and call
> task.getAppContext().put(IConnectionFactory.PASS_IN_CONNECTI ON,sqlConnection);
>
> before "runAndRender" - and now it works.
>
> Is there somewhere an overview which appContext parameters exists???
> There seems to be a lot of useful things by I never found any
> documentation!!
>
> John
>
> Jason Weathersby schrieb:
>> John,
>>
>> If you post your code I will try it with a servlet, but it should not
>> matter. Could you deploy the webviewer as a test?
>>
>> Jason
>>
>> John wrote:
>>> I do not use the birt webviewer - I directly call runAndRender() from
>>> the BIRT API.
>>> As I mentioned before: It works perfectly with runtime 2.2.1 and if I
>>> change to runtime 2.3.2 I get the error...
>>>
>>>
>>> Jason Weathersby schrieb:
>>>> John,
>>>>
>>>> I just setup my webviewer application as described here
>>>> http://wiki.eclipse.org/BIRT/FAQ/Deployment#Q:_How_do_I_setu p_BIRT_to_use_Tomcat_Connection_Pooling
>>>>
>>>>
>>>> The only difference I made was that I put the context.xml in the
>>>> tomcat-5.5.20\conf directory. I used the url in the wiki and
>>>> everything worked fine. I changed the username just to verify that
>>>> the connection pool was working.
>>>>
>>>> Jason
>>>>
>>>> John wrote:
>>>>> If I use JNDI Url=java:/comp/env/jdbc/db1
>>>>> I get
>>>>> [exec] 28.05.2009 20:59:20
>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp is
>>>>> not bound in this Context
>>>>>
>>>>> If I use JNDI Url=java:/jdbc/db1
>>>>> I get
>>>>> [exec] 28.05.2009 21:04:20
>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name db1 is
>>>>> not bound in this Context
>>>>>
>>>>> If I use JNDI Url=/jdbc/db1
>>>>> I get
>>>>> [exec] 28.05.2009 21:05:37
>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name jdbc is
>>>>> not bound in this Context
>>>>>
>>>>> If I use JNDI Url=java:/db1
>>>>> I get
>>>>> [exec] 28.05.2009 21:01:38
>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name db1 is
>>>>> not bound in this Context
>>>>>
>>>>> Does 'java:/db1' make any sense? Because the resource is defined as
>>>>> "jdbc/db1"? Does BIRT guess "jdbc"?
>>>>>
>>>>> Whats the difference between BIRT 2.2.1 and 2.3.2 and JNDI
>>>>> handling? (As I stated before in 2.2.1 it works. I'm impatient of
>>>>> BIRT upgrades there are always so a lot of new bugs (besides the
>>>>> old ones). We are using BIRT for about three years. Always hoping
>>>>> having a stable less buggy product after an upgrade. But there are
>>>>> so much bugs and a lot of tiny inconviences at design time that
>>>>> makes reporting a hell. We are really considering putting three
>>>>> years work to garbage.
>>>>>
>>>>> Jason Weathersby schrieb:
>>>>>> John,
>>>>>>
>>>>>> What I do not understand is that the error
>>>>>>
>>>>>> Name comp is not bound in this Context
>>>>>>
>>>>>> is complaining about comp, which the name I asked you to try did
>>>>>> not have in it.
>>>>>>
>>>>>> Jason
>>>>>>
>>>>>> John wrote:
>>>>>>> Error:
>>>>>>> [exec] 26.05.2009 14:24:10
>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp is not
>>>>>>> bound in this Context
>>>>>>>
>>>>>>> Server is tomcat 5.5.27
>>>>>>>
>>>>>>> As stated before: Report works fine with BIRT runtime 2.2.1?!
>>>>>>>
>>>>>>> Now I made a tiny new report (simple Datasource/set and 1 table)
>>>>>>> with BIRT 2.3.2, and I've the same problem :-(
>>>>>>>
>>>>>>> Jason Weathersby schrieb:
>>>>>>>> Also what app server are you using?
>>>>>>>>
>>>>>>>> Jason Weathersby wrote:
>>>>>>>>> John,
>>>>>>>>>
>>>>>>>>> What exception did you get with it?
>>>>>>>>>
>>>>>>>>> Jason
>>>>>>>>>
>>>>>>>>> John wrote:
>>>>>>>>>> java:/db1 also doen't work
>>>>>>>>>>
>>>>>>>>>> John
>>>>>>>>>>
>>>>>>>>>> Jason Weathersby schrieb:
>>>>>>>>>>> John,
>>>>>>>>>>>
>>>>>>>>>>> Can you try
>>>>>>>>>>>
>>>>>>>>>>> java:/db1
>>>>>>>>>>>
>>>>>>>>>>> Jason
>>>>>>>>>>>
>>>>>>>>>>> John wrote:
>>>>>>>>>>>> I've a BIRT 2.2.1 report, which uses "JNDI
>>>>>>>>>>>> URL=java:/comp/env/jdbc/db1". This works fine in my appserver.
>>>>>>>>>>>> Now I changed th BIRT runtime to BIRT 2.3.2 and I get
>>>>>>>>>>>> following error:
>>>>>>>>>>>> [exec] 26.05.2009 14:24:10
>>>>>>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
>>>>>>>>>>>> getConnection
>>>>>>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name
>>>>>>>>>>>> comp is not bound in this Context
>>>>>>>>>>>>
>>>>>>>>>>>> What is wrong??
>>>>>>>>>>>> I also opened the report in 2.3.2 and saved it in 2.3.2
>>>>>>>>>>>> format - no changes!
>>>>>>>>>>>> I also tried "java:/jdbc/db1" - no changes!
>>>>>>>>>>>> I also tried "/jdbc/db1" - no changes!
>>>>>>>>>>>>
>>>>>>>>>>>> I use "java:/comp/env/jdbc/db1" everywhere in my app (in
>>>>>>>>>>>> servlets and so on) and it works - so the JNDI entry exists
>>>>>>>>>>>> and DB-Connection is correct.
>>>>>>>>>>>>
>>>>>>>>>>>> Any ideas??
>>>>>>>>>>>>
>>>>>>>>>>>> THX!
|
|
|
| Re: BIRT 2.3.2 - JNDI error: NameNotFoundException [message #369066 is a reply to message #369061] |
Fri, 24 July 2009 08:04 |
John Missing name
Messages: 513
Registered: July 2009 |
Senior Member |
|
|
Thanks Jason for the report it works great - but optional prameters like PASS_IN_CONNECTION and so on aren't shown. And
while debugging in ODA I saw there's a parameter for switching classloader... - So what I meant is, that there's a lack
of documentation for all/most or even 'important' parameters. Ok, everybody can debug BIRTs source and can obtain which
parameters are queried - but are these parameters a public?
TJX,
John
Jason Weathersby schrieb:
> John,
>
> Run this report in the designer /preview
>
> Jason
>....
>
> John wrote:
>> Maybe it's a classloader problem??
>>
>> By debugging in the birts depth i saw
>> "IConnectionFactory.PASS_IN_CONNECTION"!
>>
>> So I do a jndi lookup in my code (instead of letting thios done by
>> birt) and call
>>
>> task.getAppContext().put(IConnectionFactory.PASS_IN_CONNECTI ON,sqlConnection);
>>
>> before "runAndRender" - and now it works.
>>
>> Is there somewhere an overview which appContext parameters exists???
>> There seems to be a lot of useful things by I never found any
>> documentation!!
>>
>> John
>>
>> Jason Weathersby schrieb:
>>> John,
>>>
>>> If you post your code I will try it with a servlet, but it should not
>>> matter. Could you deploy the webviewer as a test?
>>>
>>> Jason
>>>
>>> John wrote:
>>>> I do not use the birt webviewer - I directly call runAndRender()
>>>> from the BIRT API.
>>>> As I mentioned before: It works perfectly with runtime 2.2.1 and if
>>>> I change to runtime 2.3.2 I get the error...
>>>>
>>>>
>>>> Jason Weathersby schrieb:
>>>>> John,
>>>>>
>>>>> I just setup my webviewer application as described here
>>>>> http://wiki.eclipse.org/BIRT/FAQ/Deployment#Q:_How_do_I_setu p_BIRT_to_use_Tomcat_Connection_Pooling
>>>>>
>>>>>
>>>>> The only difference I made was that I put the context.xml in the
>>>>> tomcat-5.5.20\conf directory. I used the url in the wiki and
>>>>> everything worked fine. I changed the username just to verify that
>>>>> the connection pool was working.
>>>>>
>>>>> Jason
>>>>>
>>>>> John wrote:
>>>>>> If I use JNDI Url=java:/comp/env/jdbc/db1
>>>>>> I get
>>>>>> [exec] 28.05.2009 20:59:20
>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp is
>>>>>> not bound in this Context
>>>>>>
>>>>>> If I use JNDI Url=java:/jdbc/db1
>>>>>> I get
>>>>>> [exec] 28.05.2009 21:04:20
>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name db1 is
>>>>>> not bound in this Context
>>>>>>
>>>>>> If I use JNDI Url=/jdbc/db1
>>>>>> I get
>>>>>> [exec] 28.05.2009 21:05:37
>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name jdbc is
>>>>>> not bound in this Context
>>>>>>
>>>>>> If I use JNDI Url=java:/db1
>>>>>> I get
>>>>>> [exec] 28.05.2009 21:01:38
>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name db1 is
>>>>>> not bound in this Context
>>>>>>
>>>>>> Does 'java:/db1' make any sense? Because the resource is defined
>>>>>> as "jdbc/db1"? Does BIRT guess "jdbc"?
>>>>>>
>>>>>> Whats the difference between BIRT 2.2.1 and 2.3.2 and JNDI
>>>>>> handling? (As I stated before in 2.2.1 it works. I'm impatient of
>>>>>> BIRT upgrades there are always so a lot of new bugs (besides the
>>>>>> old ones). We are using BIRT for about three years. Always hoping
>>>>>> having a stable less buggy product after an upgrade. But there are
>>>>>> so much bugs and a lot of tiny inconviences at design time that
>>>>>> makes reporting a hell. We are really considering putting three
>>>>>> years work to garbage.
>>>>>>
>>>>>> Jason Weathersby schrieb:
>>>>>>> John,
>>>>>>>
>>>>>>> What I do not understand is that the error
>>>>>>>
>>>>>>> Name comp is not bound in this Context
>>>>>>>
>>>>>>> is complaining about comp, which the name I asked you to try did
>>>>>>> not have in it.
>>>>>>>
>>>>>>> Jason
>>>>>>>
>>>>>>> John wrote:
>>>>>>>> Error:
>>>>>>>> [exec] 26.05.2009 14:24:10
>>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp is
>>>>>>>> not bound in this Context
>>>>>>>>
>>>>>>>> Server is tomcat 5.5.27
>>>>>>>>
>>>>>>>> As stated before: Report works fine with BIRT runtime 2.2.1?!
>>>>>>>>
>>>>>>>> Now I made a tiny new report (simple Datasource/set and 1 table)
>>>>>>>> with BIRT 2.3.2, and I've the same problem :-(
>>>>>>>>
>>>>>>>> Jason Weathersby schrieb:
>>>>>>>>> Also what app server are you using?
>>>>>>>>>
>>>>>>>>> Jason Weathersby wrote:
>>>>>>>>>> John,
>>>>>>>>>>
>>>>>>>>>> What exception did you get with it?
>>>>>>>>>>
>>>>>>>>>> Jason
>>>>>>>>>>
>>>>>>>>>> John wrote:
>>>>>>>>>>> java:/db1 also doen't work
>>>>>>>>>>>
>>>>>>>>>>> John
>>>>>>>>>>>
>>>>>>>>>>> Jason Weathersby schrieb:
>>>>>>>>>>>> John,
>>>>>>>>>>>>
>>>>>>>>>>>> Can you try
>>>>>>>>>>>>
>>>>>>>>>>>> java:/db1
>>>>>>>>>>>>
>>>>>>>>>>>> Jason
>>>>>>>>>>>>
>>>>>>>>>>>> John wrote:
>>>>>>>>>>>>> I've a BIRT 2.2.1 report, which uses "JNDI
>>>>>>>>>>>>> URL=java:/comp/env/jdbc/db1". This works fine in my appserver.
>>>>>>>>>>>>> Now I changed th BIRT runtime to BIRT 2.3.2 and I get
>>>>>>>>>>>>> following error:
>>>>>>>>>>>>> [exec] 26.05.2009 14:24:10
>>>>>>>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
>>>>>>>>>>>>> getConnection
>>>>>>>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name
>>>>>>>>>>>>> comp is not bound in this Context
>>>>>>>>>>>>>
>>>>>>>>>>>>> What is wrong??
>>>>>>>>>>>>> I also opened the report in 2.3.2 and saved it in 2.3.2
>>>>>>>>>>>>> format - no changes!
>>>>>>>>>>>>> I also tried "java:/jdbc/db1" - no changes!
>>>>>>>>>>>>> I also tried "/jdbc/db1" - no changes!
>>>>>>>>>>>>>
>>>>>>>>>>>>> I use "java:/comp/env/jdbc/db1" everywhere in my app (in
>>>>>>>>>>>>> servlets and so on) and it works - so the JNDI entry exists
>>>>>>>>>>>>> and DB-Connection is correct.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Any ideas??
>>>>>>>>>>>>>
>>>>>>>>>>>>> THX!
|
|
|
| Re: BIRT 2.3.2 - JNDI error: NameNotFoundException [message #369081 is a reply to message #369066] |
Mon, 27 July 2009 17:43 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
John,
You are correct. We need to document this on the wiki or the website.
Can you open a bugzilla entry for this?
Jason
John wrote:
> Thanks Jason for the report it works great - but optional prameters like
> PASS_IN_CONNECTION and so on aren't shown. And while debugging in ODA I
> saw there's a parameter for switching classloader... - So what I meant
> is, that there's a lack of documentation for all/most or even
> 'important' parameters. Ok, everybody can debug BIRTs source and can
> obtain which parameters are queried - but are these parameters a public?
>
> TJX,
> John
>
> Jason Weathersby schrieb:
>> John,
>>
>> Run this report in the designer /preview
>>
>> Jason
>> ....
>>
>> John wrote:
>>> Maybe it's a classloader problem??
>>>
>>> By debugging in the birts depth i saw
>>> "IConnectionFactory.PASS_IN_CONNECTION"!
>>>
>>> So I do a jndi lookup in my code (instead of letting thios done by
>>> birt) and call
>>>
>>> task.getAppContext().put(IConnectionFactory.PASS_IN_CONNECTI ON,sqlConnection);
>>>
>>> before "runAndRender" - and now it works.
>>>
>>> Is there somewhere an overview which appContext parameters exists???
>>> There seems to be a lot of useful things by I never found any
>>> documentation!!
>>>
>>> John
>>>
>>> Jason Weathersby schrieb:
>>>> John,
>>>>
>>>> If you post your code I will try it with a servlet, but it should
>>>> not matter. Could you deploy the webviewer as a test?
>>>>
>>>> Jason
>>>>
>>>> John wrote:
>>>>> I do not use the birt webviewer - I directly call runAndRender()
>>>>> from the BIRT API.
>>>>> As I mentioned before: It works perfectly with runtime 2.2.1 and if
>>>>> I change to runtime 2.3.2 I get the error...
>>>>>
>>>>>
>>>>> Jason Weathersby schrieb:
>>>>>> John,
>>>>>>
>>>>>> I just setup my webviewer application as described here
>>>>>> http://wiki.eclipse.org/BIRT/FAQ/Deployment#Q:_How_do_I_setu p_BIRT_to_use_Tomcat_Connection_Pooling
>>>>>>
>>>>>>
>>>>>> The only difference I made was that I put the context.xml in the
>>>>>> tomcat-5.5.20\conf directory. I used the url in the wiki and
>>>>>> everything worked fine. I changed the username just to verify
>>>>>> that the connection pool was working.
>>>>>>
>>>>>> Jason
>>>>>>
>>>>>> John wrote:
>>>>>>> If I use JNDI Url=java:/comp/env/jdbc/db1
>>>>>>> I get
>>>>>>> [exec] 28.05.2009 20:59:20
>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp
>>>>>>> is not bound in this Context
>>>>>>>
>>>>>>> If I use JNDI Url=java:/jdbc/db1
>>>>>>> I get
>>>>>>> [exec] 28.05.2009 21:04:20
>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name db1 is
>>>>>>> not bound in this Context
>>>>>>>
>>>>>>> If I use JNDI Url=/jdbc/db1
>>>>>>> I get
>>>>>>> [exec] 28.05.2009 21:05:37
>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name jdbc
>>>>>>> is not bound in this Context
>>>>>>>
>>>>>>> If I use JNDI Url=java:/db1
>>>>>>> I get
>>>>>>> [exec] 28.05.2009 21:01:38
>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name db1 is
>>>>>>> not bound in this Context
>>>>>>>
>>>>>>> Does 'java:/db1' make any sense? Because the resource is defined
>>>>>>> as "jdbc/db1"? Does BIRT guess "jdbc"?
>>>>>>>
>>>>>>> Whats the difference between BIRT 2.2.1 and 2.3.2 and JNDI
>>>>>>> handling? (As I stated before in 2.2.1 it works. I'm impatient of
>>>>>>> BIRT upgrades there are always so a lot of new bugs (besides the
>>>>>>> old ones). We are using BIRT for about three years. Always hoping
>>>>>>> having a stable less buggy product after an upgrade. But there
>>>>>>> are so much bugs and a lot of tiny inconviences at design time
>>>>>>> that makes reporting a hell. We are really considering putting
>>>>>>> three years work to garbage.
>>>>>>>
>>>>>>> Jason Weathersby schrieb:
>>>>>>>> John,
>>>>>>>>
>>>>>>>> What I do not understand is that the error
>>>>>>>>
>>>>>>>> Name comp is not bound in this Context
>>>>>>>>
>>>>>>>> is complaining about comp, which the name I asked you to try did
>>>>>>>> not have in it.
>>>>>>>>
>>>>>>>> Jason
>>>>>>>>
>>>>>>>> John wrote:
>>>>>>>>> Error:
>>>>>>>>> [exec] 26.05.2009 14:24:10
>>>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp is
>>>>>>>>> not bound in this Context
>>>>>>>>>
>>>>>>>>> Server is tomcat 5.5.27
>>>>>>>>>
>>>>>>>>> As stated before: Report works fine with BIRT runtime 2.2.1?!
>>>>>>>>>
>>>>>>>>> Now I made a tiny new report (simple Datasource/set and 1
>>>>>>>>> table) with BIRT 2.3.2, and I've the same problem :-(
>>>>>>>>>
>>>>>>>>> Jason Weathersby schrieb:
>>>>>>>>>> Also what app server are you using?
>>>>>>>>>>
>>>>>>>>>> Jason Weathersby wrote:
>>>>>>>>>>> John,
>>>>>>>>>>>
>>>>>>>>>>> What exception did you get with it?
>>>>>>>>>>>
>>>>>>>>>>> Jason
>>>>>>>>>>>
>>>>>>>>>>> John wrote:
>>>>>>>>>>>> java:/db1 also doen't work
>>>>>>>>>>>>
>>>>>>>>>>>> John
>>>>>>>>>>>>
>>>>>>>>>>>> Jason Weathersby schrieb:
>>>>>>>>>>>>> John,
>>>>>>>>>>>>>
>>>>>>>>>>>>> Can you try
>>>>>>>>>>>>>
>>>>>>>>>>>>> java:/db1
>>>>>>>>>>>>>
>>>>>>>>>>>>> Jason
>>>>>>>>>>>>>
>>>>>>>>>>>>> John wrote:
>>>>>>>>>>>>>> I've a BIRT 2.2.1 report, which uses "JNDI
>>>>>>>>>>>>>> URL=java:/comp/env/jdbc/db1". This works fine in my
>>>>>>>>>>>>>> appserver.
>>>>>>>>>>>>>> Now I changed th BIRT runtime to BIRT 2.3.2 and I get
>>>>>>>>>>>>>> following error:
>>>>>>>>>>>>>> [exec] 26.05.2009 14:24:10
>>>>>>>>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
>>>>>>>>>>>>>> getConnection
>>>>>>>>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name
>>>>>>>>>>>>>> comp is not bound in this Context
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> What is wrong??
>>>>>>>>>>>>>> I also opened the report in 2.3.2 and saved it in 2.3.2
>>>>>>>>>>>>>> format - no changes!
>>>>>>>>>>>>>> I also tried "java:/jdbc/db1" - no changes!
>>>>>>>>>>>>>> I also tried "/jdbc/db1" - no changes!
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> I use "java:/comp/env/jdbc/db1" everywhere in my app (in
>>>>>>>>>>>>>> servlets and so on) and it works - so the JNDI entry
>>>>>>>>>>>>>> exists and DB-Connection is correct.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Any ideas??
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> THX!
|
|
|
| Re: BIRT 2.3.2 - JNDI error: NameNotFoundException [message #404640 is a reply to message #369081] |
Thu, 30 July 2009 05:58 |
John Missing name
Messages: 513
Registered: July 2009 |
Senior Member |
|
|
bugzilla entry opened
John
Jason Weathersby schrieb:
> John,
>
> You are correct. We need to document this on the wiki or the website.
> Can you open a bugzilla entry for this?
>
> Jason
>
> John wrote:
>> Thanks Jason for the report it works great - but optional prameters
>> like PASS_IN_CONNECTION and so on aren't shown. And while debugging in
>> ODA I saw there's a parameter for switching classloader... - So what I
>> meant is, that there's a lack of documentation for all/most or even
>> 'important' parameters. Ok, everybody can debug BIRTs source and can
>> obtain which parameters are queried - but are these parameters a public?
>>
>> TJX,
>> John
>>
>> Jason Weathersby schrieb:
>>> John,
>>>
>>> Run this report in the designer /preview
>>>
>>> Jason
>>> ....
>>>
>>> John wrote:
>>>> Maybe it's a classloader problem??
>>>>
>>>> By debugging in the birts depth i saw
>>>> "IConnectionFactory.PASS_IN_CONNECTION"!
>>>>
>>>> So I do a jndi lookup in my code (instead of letting thios done by
>>>> birt) and call
>>>>
>>>> task.getAppContext().put(IConnectionFactory.PASS_IN_CONNECTI ON,sqlConnection);
>>>>
>>>> before "runAndRender" - and now it works.
>>>>
>>>> Is there somewhere an overview which appContext parameters exists???
>>>> There seems to be a lot of useful things by I never found any
>>>> documentation!!
>>>>
>>>> John
>>>>
>>>> Jason Weathersby schrieb:
>>>>> John,
>>>>>
>>>>> If you post your code I will try it with a servlet, but it should
>>>>> not matter. Could you deploy the webviewer as a test?
>>>>>
>>>>> Jason
>>>>>
>>>>> John wrote:
>>>>>> I do not use the birt webviewer - I directly call runAndRender()
>>>>>> from the BIRT API.
>>>>>> As I mentioned before: It works perfectly with runtime 2.2.1 and
>>>>>> if I change to runtime 2.3.2 I get the error...
>>>>>>
>>>>>>
>>>>>> Jason Weathersby schrieb:
>>>>>>> John,
>>>>>>>
>>>>>>> I just setup my webviewer application as described here
>>>>>>> http://wiki.eclipse.org/BIRT/FAQ/Deployment#Q:_How_do_I_setu p_BIRT_to_use_Tomcat_Connection_Pooling
>>>>>>>
>>>>>>>
>>>>>>> The only difference I made was that I put the context.xml in the
>>>>>>> tomcat-5.5.20\conf directory. I used the url in the wiki and
>>>>>>> everything worked fine. I changed the username just to verify
>>>>>>> that the connection pool was working.
>>>>>>>
>>>>>>> Jason
>>>>>>>
>>>>>>> John wrote:
>>>>>>>> If I use JNDI Url=java:/comp/env/jdbc/db1
>>>>>>>> I get
>>>>>>>> [exec] 28.05.2009 20:59:20
>>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp
>>>>>>>> is not bound in this Context
>>>>>>>>
>>>>>>>> If I use JNDI Url=java:/jdbc/db1
>>>>>>>> I get
>>>>>>>> [exec] 28.05.2009 21:04:20
>>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name db1
>>>>>>>> is not bound in this Context
>>>>>>>>
>>>>>>>> If I use JNDI Url=/jdbc/db1
>>>>>>>> I get
>>>>>>>> [exec] 28.05.2009 21:05:37
>>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name jdbc
>>>>>>>> is not bound in this Context
>>>>>>>>
>>>>>>>> If I use JNDI Url=java:/db1
>>>>>>>> I get
>>>>>>>> [exec] 28.05.2009 21:01:38
>>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource getConnection
>>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name db1
>>>>>>>> is not bound in this Context
>>>>>>>>
>>>>>>>> Does 'java:/db1' make any sense? Because the resource is defined
>>>>>>>> as "jdbc/db1"? Does BIRT guess "jdbc"?
>>>>>>>>
>>>>>>>> Whats the difference between BIRT 2.2.1 and 2.3.2 and JNDI
>>>>>>>> handling? (As I stated before in 2.2.1 it works. I'm impatient
>>>>>>>> of BIRT upgrades there are always so a lot of new bugs (besides
>>>>>>>> the old ones). We are using BIRT for about three years. Always
>>>>>>>> hoping having a stable less buggy product after an upgrade. But
>>>>>>>> there are so much bugs and a lot of tiny inconviences at design
>>>>>>>> time that makes reporting a hell. We are really considering
>>>>>>>> putting three years work to garbage.
>>>>>>>>
>>>>>>>> Jason Weathersby schrieb:
>>>>>>>>> John,
>>>>>>>>>
>>>>>>>>> What I do not understand is that the error
>>>>>>>>>
>>>>>>>>> Name comp is not bound in this Context
>>>>>>>>>
>>>>>>>>> is complaining about comp, which the name I asked you to try
>>>>>>>>> did not have in it.
>>>>>>>>>
>>>>>>>>> Jason
>>>>>>>>>
>>>>>>>>> John wrote:
>>>>>>>>>> Error:
>>>>>>>>>> [exec] 26.05.2009 14:24:10
>>>>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
>>>>>>>>>> getConnection
>>>>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name comp is
>>>>>>>>>> not bound in this Context
>>>>>>>>>>
>>>>>>>>>> Server is tomcat 5.5.27
>>>>>>>>>>
>>>>>>>>>> As stated before: Report works fine with BIRT runtime 2.2.1?!
>>>>>>>>>>
>>>>>>>>>> Now I made a tiny new report (simple Datasource/set and 1
>>>>>>>>>> table) with BIRT 2.3.2, and I've the same problem :-(
>>>>>>>>>>
>>>>>>>>>> Jason Weathersby schrieb:
>>>>>>>>>>> Also what app server are you using?
>>>>>>>>>>>
>>>>>>>>>>> Jason Weathersby wrote:
>>>>>>>>>>>> John,
>>>>>>>>>>>>
>>>>>>>>>>>> What exception did you get with it?
>>>>>>>>>>>>
>>>>>>>>>>>> Jason
>>>>>>>>>>>>
>>>>>>>>>>>> John wrote:
>>>>>>>>>>>>> java:/db1 also doen't work
>>>>>>>>>>>>>
>>>>>>>>>>>>> John
>>>>>>>>>>>>>
>>>>>>>>>>>>> Jason Weathersby schrieb:
>>>>>>>>>>>>>> John,
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Can you try
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> java:/db1
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Jason
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> John wrote:
>>>>>>>>>>>>>>> I've a BIRT 2.2.1 report, which uses "JNDI
>>>>>>>>>>>>>>> URL=java:/comp/env/jdbc/db1". This works fine in my
>>>>>>>>>>>>>>> appserver.
>>>>>>>>>>>>>>> Now I changed th BIRT runtime to BIRT 2.3.2 and I get
>>>>>>>>>>>>>>> following error:
>>>>>>>>>>>>>>> [exec] 26.05.2009 14:24:10
>>>>>>>>>>>>>>> org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
>>>>>>>>>>>>>>> getConnection
>>>>>>>>>>>>>>> [exec] INFO: javax.naming.NameNotFoundException: Name
>>>>>>>>>>>>>>> comp is not bound in this Context
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> What is wrong??
>>>>>>>>>>>>>>> I also opened the report in 2.3.2 and saved it in 2.3.2
>>>>>>>>>>>>>>> format - no changes!
>>>>>>>>>>>>>>> I also tried "java:/jdbc/db1" - no changes!
>>>>>>>>>>>>>>> I also tried "/jdbc/db1" - no changes!
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> I use "java:/comp/env/jdbc/db1" everywhere in my app (in
>>>>>>>>>>>>>>> servlets and so on) and it works - so the JNDI entry
>>>>>>>>>>>>>>> exists and DB-Connection is correct.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Any ideas??
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> THX!
|
|
|
Goto Forum:
Current Time: Fri Apr 26 22:28:57 GMT 2024
Powered by FUDForum. Page generated in 0.05008 seconds |
] 
Search
Help
Register
Login
Home
