Forum Discussion

mgandra's avatar
mgandra
Frequent Visitor
7 years ago

org.apache.xmlbeans.XmlException: error: Unexpected end of file in JDBC response

I have data in the database and I am trying to query it using JDBC Request step. It gives an error in response "org.apache.xmlbeans.XmlException: error: Unexpected end of file after USERGUID". The issue is with UserHash. Below I have the query to create table and also sample data. Please let me know how resolve this error.

 

Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

 

Here is script to create the table

 

CREATE TABLE [dbo].[UserInfo](
    [UserInfoId] [bigint] IDENTITY(1,1) NOT NULL,
    [UserGuid] [uniqueidentifier] NULL,
    [UserHash] [varchar](4000) NOT NULL,
    [ProductIdentifier] [int] NOT NULL,
    [AccountIdentifier] [varchar](50) NULL,
    [AccountNumber] [varchar](50) NULL,
    [FirstName] [varchar](50) NULL,
    [LastName] [varchar](50) NULL,
    [Email] [varchar](255) NULL,
    [Street] [varchar](50) NULL,
    [ApartmentNumber] [varchar](20) NULL,
    [City] [varchar](50) NULL,
    [State] [varchar](50) NULL,
    [ZipCode] [varchar](10) NULL,
    [CreateDate] [smalldatetime] NOT NULL,
 CONSTRAINT [PKCIL_UserInfo_UserInfoId] PRIMARY KEY CLUSTERED
(
    [UserInfoId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

 

Here is the test data

 

INSERT INTO [dbo].[UserInfo]
           ([UserGuid]
           ,[UserHash]
           ,[ProductIdentifier]
           ,[AccountIdentifier]
           ,[AccountNumber]
           ,[FirstName]
           ,[LastName]
           ,[Email]
           ,[Street]
           ,[ApartmentNumber]
           ,[City]
           ,[State]
           ,[ZipCode]
           ,[CreateDate])
     VALUES
           ('E1D6A3A9-3254-4BEE-9D7C-E4F3B371A50E'
           ,'N?o{?|[???.rS??6??X?y?e"?v?2 C?Z??A???}????Bl?????E??j!?'
           ,'1400'
           ,'181323'
           ,NULL
           ,'LORENZA'
           ,'LEFFLER'
           ,'LORENZA3057.LEFFLER@email.QA.COM'
           ,'51 CONTOUR ST.'
           ,NULL
           ,'Tucson'
           ,'AZ'
           ,'85704'
           ,GETDATE())
GO

No RepliesBe the first to reply