[#SQL-12] Resultset for odbc is empty (System-DSN) - Atlassian Developer Network JIRA

Confluence SQL Plugin

Resultset for odbc is empty (System-DSN)

Created: 06/Feb/07 03:03 AM Updated: 04/Jun/07 07:13 AM

Component/s:

SQL macro

Affects Version/s:

3.0, 3.1

Fix Version/s:

3.2.2

Time Tracking:

Not Specified

File Attachments:

sql-plugin-3.2-beta.jar (79 kb)

Issue Links:

Reference

This issue is related to:

~~SQL-16~~ Access DB Connectivity

Labels:

Description

« Hide

As I already posted in the Plugin-Homepage-Comments (see http://confluence.atlassian.com/display/CONFEXT/SQL+Plugin?focusedCommentId=11567653#comment-11567653)

Plugin Version, all i would say, from Scripting-Plugin till SQL-Plugin 3.1.
Confluence 2.2.8 (we updated from 2.1.4)

I have registered a MS Access Database via System-DSN.
Made a entry in server.xml
SQL-query in Confluence gives a empty resultset (no errors)

On Confluence 2.1.4 it was working, i think that was the Scripting library, which this plugin was part of.

I will look in the Log-Files, but i dont think i will find something, because there is no error produced.

cheers
Frank

All

Comments

Work Log

Change History

FishEye

Crucible

Related Builds

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Bob Swift - 07/Feb/07 10:51 PM

Frank, might be a while before I can get to this and then I doubt I have a license to try and reproduce.

[ Permlink | « Hide ]

Bob Swift - 19/Feb/07 06:00 PM

Frank, haven't had time to get into this. Sorry. However, if you have time, I would appreciate it if you tried a beta of the next release of the macro. There was a change made that might change the behavior you are seeing, at least for the normal case (rowOrientation = vertical). I have attached it here.

[ Permlink | « Hide ]

Frank Stiller - 04/May/07 04:30 AM

we also try to get access-db to work again

[ Permlink | « Hide ]

Frank Stiller - 04/May/07 05:09 AM

sry, it seems i dont get a email-notification on comments.

With Version 3.2.1 i get the following error:

sql: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Attribute cannot be set now

i will try to checkout the beta-release you attached

[ Permlink | « Hide ]

Frank Stiller - 04/May/07 05:17 AM

same message as with 3.2.1 on the 3.2-beta...

[ Permlink | « Hide ]

Frank Stiller - 04/Jun/07 06:43 AM

i just checked out the 3.2.2 release and it solved the MS-Access Connection.

thanks