7:24 a.m.
SQLGateway adds process column
------------------------------
Key: JBESB-1499
URL: http://jira.jboss.com/jira/browse/JBESB-1499
Project: JBoss ESB
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Adapters, Rosetta
Affects Versions: 4.2.1
Environment: FC7/PostgreSQL
Reporter: Jiri Pechanec
Assigned To: Tom Cunningham
Fix For: 4.2.1 CP1
Table was created
create table GATEWAY_TABLE (UNIQUE_ID integer, DATA_COLUMN varchar(255), STATUS_COL
varchar(255))
body: [ objects: {org.jboss.soa.esb.message.defaultEntry={DATA_COLUMN=Bye ESB World,
STATUS_COL=P, UNIQUE_ID=5, unique_id=5, status_col=P, data_column=Bye ESB World},
org.jboss.soa.esb.message.defaultEntry-set-stack=Deferred serialized value: 3fa3586c} ]
The issue is probably related to upper/lower case names of columns
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:24 a.m.
New subject: [JBoss JIRA] Updated: (JBESB-1499) SQLGateway adds process column
[ http://jira.jboss.com/jira/browse/JBESB-1499?page=all ]
Jiri Pechanec updated JBESB-1499:
---------------------------------
Description:
All databases but PostgreSQL omits status column from result set.
The issue is probably related to upper/lower case names of columns
was:
Table was created
create table GATEWAY_TABLE (UNIQUE_ID integer, DATA_COLUMN varchar(255), STATUS_COL
varchar(255))
body: [ objects: {org.jboss.soa.esb.message.defaultEntry={DATA_COLUMN=Bye ESB World,
STATUS_COL=P, UNIQUE_ID=5, unique_id=5, status_col=P, data_column=Bye ESB World},
org.jboss.soa.esb.message.defaultEntry-set-stack=Deferred serialized value: 3fa3586c} ]
The issue is probably related to upper/lower case names of columns
SQLGateway adds process column
------------------------------
Key: JBESB-1499
URL: http://jira.jboss.com/jira/browse/JBESB-1499
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Rosetta, Adapters
Affects Versions: 4.2.1
Environment: FC7/PostgreSQL
Reporter: Jiri Pechanec
Assigned To: Tom Cunningham
Fix For: 4.2.1 CP1
All databases but PostgreSQL omits status column from result set.
The issue is probably related to upper/lower case names of columns
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:55 a.m.
New subject: [JBoss JIRA] Commented: (JBESB-1499) SQLGateway adds process column
[ http://jira.jboss.com/jira/browse/JBESB-1499?page=comments#action_12395832 ]
Mark Little commented on JBESB-1499:
------------------------------------
Please attach an example to illustrate the differences you are seeing, as well as your
configuration.
SQLGateway adds process column
------------------------------
Key: JBESB-1499
URL: http://jira.jboss.com/jira/browse/JBESB-1499
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Rosetta, Adapters
Affects Versions: 4.2.1
Environment: FC7/PostgreSQL
Reporter: Jiri Pechanec
Assigned To: Tom Cunningham
Fix For: 4.2.1 CP1
All databases but PostgreSQL omits status column from result set.
The issue is probably related to upper/lower case names of columns
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:11 a.m.
New subject: [JBoss JIRA] Commented: (JBESB-1499) SQLGateway adds process column
[ http://jira.jboss.com/jira/browse/JBESB-1499?page=comments#action_12395918 ]
Jiri Pechanec commented on JBESB-1499:
--------------------------------------
Hi, I think the problem is in method pollForCandidates
if (!_inProcessField.equals(sCol))
row.put(sCol, RS.getObject(iCurr));
here should be equalsIgnoreCase as MySQL/Oracle returns column name in uppercase but
PostgreSQL in lowercase.
SQLGateway adds process column
------------------------------
Key: JBESB-1499
URL: http://jira.jboss.com/jira/browse/JBESB-1499
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Rosetta, Adapters
Affects Versions: 4.2.1
Environment: FC7/PostgreSQL
Reporter: Jiri Pechanec
Assigned To: Tom Cunningham
Fix For: 4.2.1 CP1
All databases but PostgreSQL omits status column from result set.
The issue is probably related to upper/lower case names of columns
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:25 a.m.
New subject: [JBoss JIRA] Assigned: (JBESB-1499) SQLGateway adds process column
[ http://jira.jboss.com/jira/browse/JBESB-1499?page=all ]
Kevin Conner reassigned JBESB-1499:
-----------------------------------
Assignee: Kevin Conner (was: Tom Cunningham)
Tom, I'm taking this off your hands to get it into today's merge.
SQLGateway adds process column
------------------------------
Key: JBESB-1499
URL: http://jira.jboss.com/jira/browse/JBESB-1499
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Rosetta, Adapters
Affects Versions: 4.2.1
Environment: FC7/PostgreSQL
Reporter: Jiri Pechanec
Assigned To: Kevin Conner
Fix For: 4.2.1 CP1
All databases but PostgreSQL omits status column from result set.
The issue is probably related to upper/lower case names of columns
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:28 a.m.
New subject: [JBoss JIRA] Commented: (JBESB-1499) SQLGateway adds process column
[ http://jira.jboss.com/jira/browse/JBESB-1499?page=comments#action_12395936 ]
Mark Little commented on JBESB-1499:
------------------------------------
Please attach a log indicating the problem.
SQLGateway adds process column
------------------------------
Key: JBESB-1499
URL: http://jira.jboss.com/jira/browse/JBESB-1499
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Rosetta, Adapters
Affects Versions: 4.2.1
Environment: FC7/PostgreSQL
Reporter: Jiri Pechanec
Assigned To: Kevin Conner
Fix For: 4.2.1 CP1
All databases but PostgreSQL omits status column from result set.
The issue is probably related to upper/lower case names of columns
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:56 a.m.
New subject: [JBoss JIRA] Closed: (JBESB-1499) SQLGateway adds process column
[ http://jira.jboss.com/jira/browse/JBESB-1499?page=all ]
Kevin Conner closed JBESB-1499.
-------------------------------
Resolution: Done
CP fixed in revision 17999.
trunk fixed in revision 18000.
SQLGateway adds process column
------------------------------
Key: JBESB-1499
URL: http://jira.jboss.com/jira/browse/JBESB-1499
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Rosetta, Adapters
Affects Versions: 4.2.1
Environment: FC7/PostgreSQL
Reporter: Jiri Pechanec
Assigned To: Kevin Conner
Fix For: 4.2.1 CP1
All databases but PostgreSQL omits status column from result set.
The issue is probably related to upper/lower case names of columns
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:04 a.m.
New subject: [JBoss JIRA] Commented: (JBESB-1499) SQLGateway adds process column
[ http://jira.jboss.com/jira/browse/JBESB-1499?page=comments#action_12396116 ]
Jiri Pechanec commented on JBESB-1499:
--------------------------------------
Dump of gateway result set
MySQL
{DATA_COLUMN=Hello ESB World!, UNIQUE_ID=1}
PostgreSQL
{unique_id=1, status_col=P, data_column=Hello ESB World!}
SQLGateway adds process column
------------------------------
Key: JBESB-1499
URL: http://jira.jboss.com/jira/browse/JBESB-1499
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Rosetta, Adapters
Affects Versions: 4.2.1
Environment: FC7/PostgreSQL
Reporter: Jiri Pechanec
Assigned To: Kevin Conner
Fix For: 4.2.1 CP1
All databases but PostgreSQL omits status column from result set.
The issue is probably related to upper/lower case names of columns
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:35 a.m.
New subject: [JBoss JIRA] Commented: (JBESB-1499) SQLGateway adds process column
[ http://jira.jboss.com/jira/browse/JBESB-1499?page=comments#action_12396125 ]
Kevin Conner commented on JBESB-1499:
-------------------------------------
Jirka, are you saying this issue is not fixed?
SQLGateway adds process column
------------------------------
Key: JBESB-1499
URL: http://jira.jboss.com/jira/browse/JBESB-1499
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Rosetta, Adapters
Affects Versions: 4.2.1
Environment: FC7/PostgreSQL
Reporter: Jiri Pechanec
Assigned To: Kevin Conner
Fix For: 4.2.1 CP1
All databases but PostgreSQL omits status column from result set.
The issue is probably related to upper/lower case names of columns
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:37 a.m.
New subject: [JBoss JIRA] Commented: (JBESB-1499) SQLGateway adds process column
[ http://jira.jboss.com/jira/browse/JBESB-1499?page=comments#action_12396127 ]
Jiri Pechanec commented on JBESB-1499:
--------------------------------------
No, it is reaction to Mark's request
SQLGateway adds process column
------------------------------
Key: JBESB-1499
URL: http://jira.jboss.com/jira/browse/JBESB-1499
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Rosetta, Adapters
Affects Versions: 4.2.1
Environment: FC7/PostgreSQL
Reporter: Jiri Pechanec
Assigned To: Kevin Conner
Fix For: 4.2.1 CP1
All databases but PostgreSQL omits status column from result set.
The issue is probably related to upper/lower case names of columns
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6667
days inactive
6671
days old
9 comments
3 participants
participants (3)
-
Jiri Pechanec (JIRA) -
Kevin Conner (JIRA)
-
Mark Little (JIRA)