Bug 1118470

Summary: Database Logging: Problems with Microsoft
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Thomas Hauser <thauser>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.1.0CC: dlesage, jstastny, vhalbert
Target Milestone: ER5Keywords: QA-Closed
Target Release: 6.1.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
When the Microsoft SQL Server driver was used for the database logging feature, table creation would fail with errors. This was because it used the column heading name ROWCOUNT which was reserved in SQL Server. The column name has now been changed to "row_count" and, as a result, database logging now works without error.
 Story Points: ---
Clone Of: Environment:
Last Closed: 2016-02-10 08:56:06 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Full server.log of failed startup none

Description Thomas Hauser 2014-07-10 19:37:42 UTC 
Created attachment 917169 [details]
Full server.log of failed startup

Description of problem:
When using the Microsoft SQL Server driver as the database backing the database logging feature, table creation fails with errors.

Version-Release number of selected component (if applicable):
6.1.0 DR1

How reproducible:
Always

Steps to Reproduce:
1. Install DV using the (upcoming) DR2 installer
2. Elect to install a JDBC driver and configure database logging
3. Install the microsoft JDBC driver
4. Enter the details of the database logging database in the following panel.
5. Installation will complete successfully. 
6. Attempt to start the newly installed server.

Actual results:
The following stacktrace is encountered upon server startup: 
http://pastebin.test.redhat.com/220860

Expected results:
Table creation succeeds and commands are logged.

Additional info:
JDBC driver used is here: http://www.qa.jboss.com/jdbc-drivers-products/jdbc/EAP/6.3.0/mssql2012/jdbc4/sqljdbc4.jar
Comment 3 JBoss JIRA Server 2014-12-05 23:20:06 UTC 
Ramesh Reddy <rareddy> updated the status of jira TEIID-3245 to Resolved
Comment 4 JBoss JIRA Server 2015-10-08 14:39:56 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-3245 to Closed