|
Re: Grails and Birt - Connection Not Active [message #735547 is a reply to message #735516] |
Wed, 12 October 2011 07:25 |
Chad Messages: 9 Registered: October 2011 |
Junior Member |
|
|
I modified the BirtReportService with the following snippet -
def connection = dataSource.getConnection()
def sql = new Sql(connection);
def rSet = sql.firstRow("select * from Contact")
println rSet.toString()
if(useGrailsDatasource) task.getAppContext().put("OdaJDBCDriverPassInConnection", connection);
task.run()
And this is what I get back:
BirtReportService taskParams: [
{id=1, version=0, address1=Not Listed, address2=null, city=Lesley, date_created=2011-10-12 02:12:39.0, email=null, first_name=Bob, last_name=Bole, phone_area_code=931, phone_prefix=425, phone_suffix=8162, state_id=43, zip=90210}
engine.odaconsumer Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.dbprofile.sqbDataSet).
[SELECT *
FROM `database`.`client` AS C, `database`.`organization` AS O
]
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: The established connection to the data source is not active.
So, as you can see from the contact result set printed, the connection is active. What is causing the underlying code in birt to think this connection is not valid?
|
|
|
|
|
|
Re: Grails and Birt - Connection Not Active [message #735686 is a reply to message #735685] |
Wed, 12 October 2011 14:23 |
|
Also what version of BIRT are you using?
Jason
On 10/12/2011 10:23 AM, Jason Weathersby wrote:
> Chad,
>
> Can you try it using a standard JDBC connection (Without using a profile)?
>
> Jason
>
> On 10/12/2011 10:15 AM, Chad wrote:
>> Any help on this?
>
|
|
|
|
|
|
Re: Grails and Birt - Connection Not Active [message #735715 is a reply to message #735685] |
Wed, 12 October 2011 14:23 |
|
Also what version of BIRT are you using?
Jason
On 10/12/2011 10:23 AM, Jason Weathersby wrote:
> Chad,
>
> Can you try it using a standard JDBC connection (Without using a profile)?
>
> Jason
>
> On 10/12/2011 10:15 AM, Chad wrote:
>> Any help on this?
>
|
|
|
|
Re: Grails and Birt - Connection Not Active [message #735737 is a reply to message #735694] |
Wed, 12 October 2011 15:22 |
|
Are you still passing in your own connection?
task.getAppContext().put("OdaJDBCDriverPassInConnection", connection);
I am not certain what integration you are using. Is the code available?
Jason
On 10/12/2011 10:52 AM, Chad wrote:
> I tried using Grail's dataSourceUnproxied which gives me access to a
> basic JDBC connection, but this met with the same error. Also, I'm using
> version 2.6.2. The update center for using the eclipse update-site links
> still listed the 3.7 version as not available.
>
> Thanks for the response,
>
> Chad
|
|
|
|
Re: Grails and Birt - Connection Not Active [message #735774 is a reply to message #735746] |
Wed, 12 October 2011 16:52 |
|
It must be. Any chance you can open a bugzilla for this?
Jason
On 10/12/2011 11:58 AM, Chad wrote:
> No, I have reverted back to using the original code which passes in a
> connection-pooled mysql connection. Is this something that is perhaps
> connection pool configuration related? I know that when the preview runs
> in eclipse it creates a new connection to the exact same database and I
> am able to see the data I am expecting. The only difference in
> datasources is that one is a direct connection and the other is a pooled
> source. Ideas?
>
> Chad
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.07395 seconds