Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Runtime connection string problem
icon5.gif  Runtime connection string problem [message #643149] Sun, 05 December 2010 12:05 Go to next message
Shahab  is currently offline Shahab
Messages: 4
Registered: December 2010
Junior Member
I need to set JDBC connection info at runtime.
I read this topic
http://www.eclipse.org/forums/index.php?t=tree&th=197797 &S=10362157421a2a3c81ba12fc9c9376cd#page_top
and added this code to my WebReport.java
task.getAppContext().put("OdaJDBCDriverPassInConnection",conn);
the following error occured :


+ An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: Users
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.dbprofile.sqbDataSet) .
[SELECT FULLNAME, LOGINNAME, WORKSITE, ISLOCKED, FAILEDLOGINCOUNT
FROM TUMUSER
WHERE VALIDTO IS NULL
]
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHe lperException: The established connection to the data source is not active.


Can anyone help me plzzzzzzzzzzzzzz,it's so important

[Updated on: Sun, 05 December 2010 12:06]

Report message to a moderator

Re: Runtime connection string problem [message #643409 is a reply to message #643149] Mon, 06 December 2010 18:55 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Is the conn object is valid?
Also instead of using the graphic sql builder can you try this with a
standard (non-profile) jdbc datasource?

Jason

On 12/5/2010 7:05 AM, Shahab wrote:
> I need to set JDBC connection info at runtime.
> I read this topic
> http://www.eclipse.org/forums/index.php?t=tree&th=197797 &S=10362157421a2a3c81ba12fc9c9376cd#page_top
>
> and added this code to my WebReport.java
> task.getAppContext().put("OdaJDBCDriverPassInConnection",conn);
> the following error occured :
>
>
> + An exception occurred during processing. Please see the following
> message for details:
> Failed to prepare the query execution for the data set: Users
> Failed to prepare the following query for the data set type
> (org.eclipse.birt.report.data.oda.jdbc.dbprofile.sqbDataSet) . [SELECT
> FULLNAME, LOGINNAME, WORKSITE, ISLOCKED, FAILEDLOGINCOUNT
> FROM TUMUSER
> WHERE VALIDTO IS NULL
> ]
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHe
> lperException: The established connection to the data source is not active.
Previous Topic:how to set data source connection string at runtime
Next Topic:Problems with 2 webapps in one BEA Weblogic
Goto Forum:
  


Current Time: Fri Oct 24 16:19:45 GMT 2014

Powered by FUDForum. Page generated in 0.02532 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software