Runtime connection string problem [message #643149] |
Sun, 05 December 2010 12:05 |
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 |
|
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.
|
|
|
Powered by
FUDForum. Page generated in 0.03362 seconds