|
Re: JDBC connection properties [message #516343 is a reply to message #516259] |
Tue, 23 February 2010 16:04 |
|
Why not change the url on the fly with script or property binding?
Jason
john mcteague wrote:
> I am using BIRT 2.5.1 with Sybase 15 and jconnect6.
> I am faced with the problem that I need to set the sybase specific
> connection property JCONNECT_VERSION on the driver. This can be achieved
> by adding it to the url of the datasource (i.e.
> jdbc:sybase:Tds:host:port/db?JCONNECT_VERSION=5) however Id like to
> explore the possibility of getting this property into my connection
> without using a URL. This is because of the way we integrate the BIRT
> runtime into an existing application, changine the URL may not be possible.
>
> I cannot see how to set a jdbc connection property via BIRT and ODA. Is
> there a way?
>
> For background, the latest jconnect6 drivers for sybase handle column
> aliases differently than in jconnect5. If I had select foo as 'bar' from
> my_table, in jconnect5, the column name would be 'bar', with jconnect6
> its 'foo' (rs.getColumnLabel() would return 'bar'). I have existing birt
> reports that were originally developed against jconnect 5 that have
> expectations about column names. To get around this problem without
> adding a connection property (either through url or otherwise), I would
> have to go into my design file, change my sql to not use column aliases
> and instead set the column alias in the Output Columns section of the
> data set editor.
>
|
|
|
Powered by
FUDForum. Page generated in 0.02899 seconds