RE: SQL Error with CTP JDBC Driver 1.1
- From: JPorter <JPorter@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 2 May 2006 11:57:02 -0700
Wes - We had the exact same problem with that CTP JDBC Driver version 1.1. I
need to file a case number with Microsoft on this - but one of the developers
that I work with came up with an idea & it seems to be a workaround. For us,
we found that this problem was occuring if a NULL value was passed as one of
the parameters in the CallableStatement - if the cooresponding database field
was not a PRIMARY KEY in the table - strange!
We initialized all of our parameters with the the following types:
For SMALLINT/TINYINT/INTEGER columns
insertStmt.setNull(1, Types.INTEGER)
For VARCHAR columns:
insertStmt.setNull(1, Types.CHAR)
For DECIMAL columns:
insertStmt.setNull(1, Types.REAL)
Once we changed to this configuration, everything worked fine. Seems like a
problem with the null equivalents of the different types. Would be
interested to hear Microsoft's opinion on this problem & any other
information you find.
Thanks!
Jon
"Wes Clark" wrote:
Starting up our application server encounters an error with the 1.1 CTP JDBC.
driver against a SQL Server 2005 SP1 server. The identical process succeeds
with the 1.0 driver. The error received is: "The conversion from VARCHAR to
CHAR is unsupported."
More detail is below. Sorry about the volume, but that might be the cause.
Prior to this point, the database schema is created from sratch, and then
initial data is being loaded when the error occurs.
Is there a particular trace or something I could provide to help diagnose.
[SQLException.getErrorCode() = 0
SQLException.getSQLState() = null
Connection:
com.guidewire.pl.system.database.connection.dhcp.DBCPPoolableConnection@1f11ffc
Isolation level: Read Committed
Autocommit: false
Last Executed SQL:
INSERT INTO cc_activitypattern (Type, AutomatedOnly, UpdateTime,
ClaimLossType, Recurring, CreateTime, ShortSubject, TargetHours, Priority,
BeanVersion, ActivityClass, Retired, EscalationDays, CreateUserID,
Description, TargetIncludeDays, Subject, Code, TargetStartPoint, PublicID,
Importance, EscalationHours, EscalationStartPt, EscalationInclDays,
LoadHistoryID, TargetDays, ExternallyOwned, ClosedClaimAvlble, Command,
Category, Mandatory, UpdateUserID, ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [General, false, Tue Apr 25 21:32:21 PDT 2006, null, false, Tue
Apr 25 21:32:21 PDT 2006, null, null, Normal, 0, Task, 0, null, null, null,
null, General reminder (diary), general_reminder, null, default_data:10001,
null, null, null, null, null, null, false, false, null, Reminder, false,
null, 1, General, false, Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr
25 21:32:21 PDT 2006, null, null, High, 0, Task, 0, 10, null, null, Business
days, Verify coverage, coverage, Claim notice date, default_data:10002, null,
null, Claim notice date, Business days, null, 2, false, false, null,
Reminder, true, null, 2, General, false, Tue Apr 25 21:32:21 PDT 2006, null,
false, Tue Apr 25 21:32:21 PDT 2006, null, null, Urgent, 0, Task, 0, 5, null,
null, Business days, Make initial contact with insured, contact_insured,
Claim notice date, default_data:10003, null, null, Claim notice date,
Business days, null, 1, false, false, null, Interview, false, null, 3,
General, false, Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr 25
21:32:21 PDT 2006, null, null, Urgent, 0, Task, 0, 5, null, null, Business
days, Make initial contact with claimant, contact_claimant, Claim notice
date, default_data:10004, null, null, Claim notice date, Business days, null,
2, false, false, null, Interview, false, null, 4, General, false, Tue Apr 25
21:32:21 PDT 2006, null, false, Tue Apr 25 21:32:21 PDT 2006, null, null,
Normal, 0, Task, 0, null, null, null, Business days, Get police report,
police_report, Claim notice date, default_data:10005, null, null, null, null,
null, 10, true, false, null, Request, false, null, 5, General, false, Tue Apr
25 21:32:21 PDT 2006, null, false, Tue Apr 25 21:32:21 PDT 2006, null, null,
Normal, 0, Task, 0, 15, null, null, Business days, Get vehicle inspected,
vehicle_inspection, Activity creation date, default_data:10006, null, null,
Activity creation date, Business days, null, 5, true, false, null, Request,
false, null, 6, General, false, Tue Apr 25 21:32:21 PDT 2006, null, false,
Tue Apr 25 21:32:21 PDT 2006, null, null, Normal, 0, Task, 0, 15, null, null,
Business days, Get property inspected, property_inspection, Activity creation
date, default_data:10007, null, null, Activity creation date, Business days,
null, 5, true, false, null, Request, false, null, 7, General, false, Tue Apr
25 21:32:21 PDT 2006, null, false, Tue Apr 25 21:32:21 PDT 2006, null, null,
Normal, 0, Task, 0, null, null, null, Business days, Get accident scene
inspected, scene_inspection, Claim notice date, default_data:10008, null,
null, null, null, null, 5, true, false, null, Request, false, null, 8,
General, false, Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr 25
21:32:21 PDT 2006, null, null, Normal, 0, Task, 0, null, null, null, Business
days, Get a statement from witness, witness_statement, Claim notice date,
default_data:10009, null, null, null, null, null, 3, true, false, null,
Interview, false, null, 9, General, false, Tue Apr 25 21:32:21 PDT 2006,
null, false, Tue Apr 25 21:32:21 PDT 2006, null, null, Normal, 0, Task, 0,
null, null, null, Business days, Get claimant medical reports,
medical_report_claimant, Activity creation date, default_data:10010, null,
null, null, null, null, 10, true, false, null, Request, false, null, 10,
General, false, Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr 25
21:32:21 PDT 2006, null, null, Normal, 0, Task, 0, null, null, null, Business
days, Get independent medical examination, IME, Activity creation date,
default_data:10011, null, null, null, null, null, 10, true, false, null,
Request, false, null, 11, General, false, Tue Apr 25 21:32:21 PDT 2006, null,
false, Tue Apr 25 21:32:21 PDT 2006, null, null, Normal, 0, Task, 0, null,
null, null, Elapsed days, Initial 30 day file review, initial_30day_review,
Activity creation date, default_data:10012, null, null, null, null, null, 30,
false, false, null, Reminder, false, null, 12, General, false, Tue Apr 25
21:32:21 PDT 2006, null, true, Tue Apr 25 21:32:21 PDT 2006, null, null,
Normal, 0, Task, 0, null, null, null, Elapsed days, 30 day diary,
30_day_diary, Activity creation date, default_data:10013, null, null, null,
null, null, 30, false, false, null, Reminder, false, null, 13, General,
false, Tue Apr 25 21:32:21 PDT 2006, null, true, Tue Apr 25 21:32:21 PDT
2006, null, null, Normal, 0, Task, 0, null, null, null, Elapsed days, 60 day
diary, 60_day_diary, Activity creation date, default_data:10014, null, null,
null, null, null, 60, false, false, null, Reminder, false, null, 14, General,
false, Tue Apr 25 21:32:21 PDT 2006, null, true, Tue Apr 25 21:32:21 PDT
2006, null, null, Normal, 0, Task, 0, null, null, null, Elapsed days, 90 day
diary, 90_day_diary, Activity creation date, default_data:10015, null, null,
null, null, null, 90, false, false, null, Reminder, false, null, 15, General,
false, Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr 25 21:32:21 PDT
2006, null, null, Low, 0, Task, 0, null, null, null, Elapsed days, Closed
File Review, closed_file_review, Activity creation date, default_data:10016,
null, null, null, null, null, 30, false, true, null, Reminder, true, null,
16, General, false, Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr 25
21:32:21 PDT 2006, null, null, Low, 0, Task, 0, null, null, null, Elapsed
days, Performance Review, employee_review, Activity creation date,
default_data:10017, null, null, null, null, null, 30, false, true, null,
Reminder, true, null, 17, General, true, Tue Apr 25 21:32:21 PDT 2006, null,
false, Tue Apr 25 21:32:21 PDT 2006, null, null, Urgent, 0, Task, 0, 2, null,
null, Elapsed days, Review new claim setup, fnol_review, Activity creation
date, default_data:10018, null, null, Activity creation date, Elapsed days,
null, 0, false, false, null, Reminder, true, null, 18, General, false, Tue
Apr 25 21:32:21 PDT 2006, Workers' Comp, false, Tue Apr 25 21:32:21 PDT 2006,
null, null, High, 0, Task, 0, 5, null, Determine whether claim should be
accepted or denied or delayed, Business days, Initial claim acceptance
decision, claim_acceptance, Claim notice date, default_data:10019, null,
null, Claim notice date, Business days, null, 1, false, false, null,
Reminder, true, null, 19, General, false, Tue Apr 25 21:32:21 PDT 2006, null,
false, Tue Apr 25 21:32:21 PDT 2006, null, null, Normal, 0, Task, 0, 5, null,
null, Business days, Notify reinsurer, notify_reinsurer, Claim notice date,
default_data:10020, null, null, Claim notice date, Business days, null, 5,
false, true, null, Reminder, false, null, 20, General, false, Tue Apr 25
21:32:21 PDT 2006, null, false, Tue Apr 25 21:32:21 PDT 2006, null, null,
High, 0, Task, 0, 5, null, Review for possible fraud, Elapsed days, SIU
referral, fraud_review, Activity creation date, default_data:10021, null,
null, Activity creation date, Business days, null, 3, true, false, null,
Request, false, null, 21, General, false, Tue Apr 25 21:32:21 PDT 2006, null,
false, Tue Apr 25 21:32:21 PDT 2006, null, null, High, 0, Task, 0, 5, null,
Referral to Legal Counsel, Elapsed days, Legal review, legal_review, Activity
creation date, default_data:10022, null, null, Activity creation date,
Business days, null, 3, true, true, null, Request, false, null, 22, General,
false, Tue Apr 25 21:32:21 PDT 2006, Workers' Comp, false, Tue Apr 25
21:32:21 PDT 2006, null, null, Urgent, 0, Task, 0, 5, null, null, Business
days, Get a statement from Health and Safety Dept, health_statement, Claim
notice date, default_data:10023, null, null, Claim notice date, Business
days, null, 2, false, false, null, Reminder, false, null, 23, General, false,
Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr 25 21:32:21 PDT 2006,
null, null, Normal, 0, Task, 0, 15, null, null, Business days, Get quote for
repairs/replacement, quote, Activity creation date, default_data:10024, null,
null, Activity creation date, Business days, null, 5, true, false, null,
Request, false, null, 24, General, false, Tue Apr 25 21:32:21 PDT 2006,
Workers' Comp, false, Tue Apr 25 21:32:21 PDT 2006, null, null, Normal, 0,
Task, 0, 15, null, Offer in lieu of repairs/replacement, Business days, Make
settlement offer, settlement_offer, Activity creation date,
default_data:10025, null, null, Activity creation date, Business days, null,
5, false, false, null, Reminder, false, null, 25, General, false, Tue Apr 25
21:32:21 PDT 2006, null, false, Tue Apr 25 21:32:21 PDT 2006, null, null,
Normal, 0, Task, 0, 15, null, null, Business days, Review and approve quote
for repairs/replacement, review_quote, Activity creation date,
default_data:10026, null, null, Activity creation date, Business days, null,
5, true, false, null, Reminder, false, null, 26, General, false, Tue Apr 25
21:32:21 PDT 2006, Workers' Comp, false, Tue Apr 25 21:32:21 PDT 2006, null,
null, Normal, 0, Task, 0, 25, null, Determine final decision on claim
acceptance, Elapsed days, Decision Date Review, decision_date, Claim loss
date, default_data:10027, null, null, Claim loss date, Elapsed days, null,
20, false, false, null, Reminder, true, null, 27, General, true, Tue Apr 25
21:32:21 PDT 2006, null, false, Tue Apr 25 21:32:21 PDT 2006, null, null,
Normal, 0, Task, 0, null, null, Recurring payment stream is about to end. If
necessary, add additional payments. See Financials Transaction screen for
details., Elapsed days, Recurring payment stream ending,
last_payment_reminder, Activity creation date, default_data:10028, null,
null, null, null, null, 7, false, false, null, Reminder, false, null, 28,
General, false, Tue Apr 25 21:32:21 PDT 2006, Workers' Comp, false, Tue Apr
25 21:32:21 PDT 2006, null, null, High, 0, Task, 0, 10, null, null, Business
days, File Employer's First Notice, first_report, Claim notice date,
default_data:11001, null, null, Claim notice date, Business days, null, 2,
false, false, null, Correspondence, true, null, 29, General, false, Tue Apr
25 21:32:21 PDT 2006, Workers' Comp, false, Tue Apr 25 21:32:21 PDT 2006,
null, null, High, 0, Task, 0, 10, null, null, Business days, Get Employee's
Notice of Injury, employee_notice, Claim notice date, default_data:11002,
null, null, Claim notice date, Business days, null, 2, true, false, null,
Request, true, null, 30, General, false, Tue Apr 25 21:32:21 PDT 2006,
Workers' Comp, false, Tue Apr 25 21:32:21 PDT 2006, null, null, High, 0,
Task, 0, 10, null, null, Business days, Get wage statement and tax status,
wage_stmt, Claim notice date, default_data:11003, null, null, Claim notice
date, Business days, null, 5, true, false, null, Request, true, null, 31,
General, false, Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr 25
21:32:21 PDT 2006, null, null, Normal, 0, Task, 0, null, null, null, Business
days, Determine if opportunity for recovery, subro_check, Claim notice date,
default_data:11004, null, null, null, null, null, 15, false, true, null,
Reminder, false, null, 32, General, false, Tue Apr 25 21:32:21 PDT 2006,
null, false, Tue Apr 25 21:32:21 PDT 2006, null, null, Normal, 0, Task, 0,
null, null, null, Business days, Assign nurse to case, rehab_nurse, Activity
creation date, default_data:11005, null, null, null, null, null, 5, true,
false, null, Reminder, false, null, 33, General, false, Tue Apr 25 21:32:21
PDT 2006, Workers' Comp, false, Tue Apr 25 21:32:21 PDT 2006, null, null,
Normal, 0, Task, 0, null, null, null, Business days, Notify account -
expected cost above threshold, notice_cost_above_threshold, Activity creation
date, default_data:11006, null, null, null, null, null, 3, false, false,
null, Reminder, true, null, 34, General, false, Tue Apr 25 21:32:21 PDT 2006,
Workers' Comp, false, Tue Apr 25 21:32:21 PDT 2006, null, null, Normal, 0,
Task, 0, null, null, null, Business days, Check on medical clearance for
light duty work, med_clear_for_light_duty, Activity creation date,
default_data:11007, null, null, null, null, null, 3, false, false, null,
Reminder, false, null, 35, General, false, Tue Apr 25 21:32:21 PDT 2006,
Workers' Comp, false, Tue Apr 25 21:32:21 PDT 2006, null, null, Normal, 0,
Task, 0, 20, null, null, Business days, Get signed Voluntary Agreement,
vol_agreement, Activity creation date, default_data:11008, null, null,
Activity creation date, Business days, null, 10, true, false, null, Request,
true, null, 36, General, false, Tue Apr 25 21:32:21 PDT 2006, null, false,
Tue Apr 25 21:32:21 PDT 2006, null, null, Normal, 0, Task, 0, null, null,
null, Business days, Get initial medical report, initial_med_report, Claim
notice date, default_data:11009, null, null, null, null, null, 5, true,
false, null, Request, true, null, 37, General, false, Tue Apr 25 21:32:21 PDT
2006, Workers' Comp, false, Tue Apr 25 21:32:21 PDT 2006, null, null, Normal,
0, Task, 0, null, null, null, Business days, Check with employer about temp
light duty work, employer_light_duty, Activity creation date,
default_data:11010, null, null, null, null, null, 3, false, false, null,
Reminder, false, null, 38, General, false, Tue Apr 25 21:32:21 PDT 2006,
Workers' Comp, false, Tue Apr 25 21:32:21 PDT 2006, null, null, Normal, 0,
Task, 0, 20, null, null, Business days, Visit claimant and assess
back-to-work status, nurse_visit, Activity creation date, default_data:11011,
null, null, Activity creation date, Business days, null, 10, true, false,
null, Interview, true, null, 39, Approval Denied, true, Tue Apr 25 21:32:21
PDT 2006, null, false, Tue Apr 25 21:32:21 PDT 2006, null, null, Normal, 0,
Task, 0, null, null, null, Business days, Review rejected request,
approval_denied, Activity creation date, default_data:12001, null, null,
null, null, null, 3, false, false, null, Approval Denied, false, null, 40,
General, true, Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr 25 21:32:21
PDT 2006, null, null, Normal, 0, Task, 0, null, null, The system was unable
to void the check because the check cleared, null, Unable to void the check,
unable_to_void_check, null, default_data:12002, null, null, null, null, null,
null, false, false, null, Warning, false, null, 41, General, true, Tue Apr 25
21:32:21 PDT 2006, null, false, Tue Apr 25 21:32:21 PDT 2006, null, null,
Normal, 0, Task, 0, null, null, The system was unable to issue a stop payment
because the check cleared, null, Unable to issue a stop payment,
unable_to_stop_check, null, default_data:12003, null, null, null, null, null,
null, false, false, null, Warning, false, null, 42, Assignment Review, true,
Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr 25 21:32:21 PDT 2006,
null, null, Normal, 0, Task, 0, null, null, null, Business days, Review
Assignment, assignment_review, Activity creation date, default_data:13001,
null, null, null, null, null, 3, false, false, null, Assignment Review, true,
null, 43, Approval, true, Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr
25 21:32:21 PDT 2006, null, null, Normal, 0, Task, 0, 10, null, null,
Business days, Review and approve settlement plan, plan_review, Activity
creation date, default_data:40001, null, null, Activity creation date,
Business days, null, 3, false, false, null, Approval, true, null, 44,
Approval, true, Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr 25
21:32:21 PDT 2006, null, null, High, 0, Task, 0, 2, null, null, Business
days, Review and approve reserve change, approve_reserve_change, Activity
creation date, default_data:40002, null, null, Activity creation date,
Business days, null, 0, false, false, null, Approval, true, null, 45,
Approval, true, Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr 25
21:32:21 PDT 2006, null, null, Urgent, 0, Task, 0, 2, null, null, Business
days, Review and approve new payment, approve_payment, Activity creation
date, default_data:40003, null, null, Activity creation date, Business days,
null, 0, false, false, null, Approval, true, null, 46, Approval, true, Tue
Apr 25 21:32:21 PDT 2006, null, false, Tue Apr 25 21:32:21 PDT 2006, null,
null, High, 0, Task, 0, 2, null, null, Business days, Review and approve new
recovery, approve_recovery, Activity creation date, default_data:40004, null,
null, Activity creation date, Business days, null, 0, false, false, null,
Approval, true, null, 47, Approval, true, Tue Apr 25 21:32:21 PDT 2006, null,
false, Tue Apr 25 21:32:21 PDT 2006, null, null, High, 0, Task, 0, 2, null,
null, Business days, Review and approve new recovery reserve change,
approve_recoveryreserve_change, Activity creation date, default_data:40005,
null, null, Activity creation date, Business days, null, 0, false, false,
null, Approval, true, null, 48, General, false, Tue Apr 25 21:32:21 PDT 2006,
null, false, Tue Apr 25 21:32:21 PDT 2006, null, null, High, 0, Task, 0, 27,
null, null, Business days, Send reservation of rights letter,
res_of_rights_letter, Activity creation date, default_data:50001, null, null,
Claim notice date, Elapsed days, null, 2, false, false, documentMerge.create(
"ReservationRights.doc" ), Correspondence, true, null, 49, General, false,
Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr 25 21:32:21 PDT 2006,
null, null, High, 0, Task, 0, 27, null, null, Business days, Send claim
acknowledgement letter, claim_ack_letter, Activity creation date,
default_data:50002, null, null, Claim notice date, Elapsed days, null, 2,
false, false, null, Correspondence, true, null, 50, General, false, Tue Apr
25 21:32:21 PDT 2006, null, false, Tue Apr 25 21:32:21 PDT 2006, null, null,
High, 0, Task, 0, 5, null, null, Business days, Send letter confirming
closure of exposure, expo_close_letter, Activity creation date,
default_data:50003, null, null, Activity creation date, Business days, null,
1, false, true, null, Correspondence, true, null, 51, FNOL, true, Tue Apr 25
21:32:21 PDT 2006, null, false, Tue Apr 25 21:32:21 PDT 2006, null, null,
Urgent, 0, Task, 0, 2, null, null, Elapsed days, Process new claim, fnol,
Activity creation date, default_data:60001, null, null, Activity creation
date, Elapsed days, null, 0, false, false, null, FNOL, true, null, 52,
General, false, Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr 25
21:32:21 PDT 2006, null, null, Normal, 0, Task, 0, null, null, null, Business
days, Review new mail, new_mail, Activity creation date, default_data:80001,
null, null, null, null, null, 3, false, true, null, New Mail, true, null, 53,
General, false, Tue Apr 25 21:32:21 PDT 2006, null, false, Tue Apr 25
21:32:21 PDT 2006, null, null, Normal, 0, Task, 0, null, null, null, Business
days, Review new bill received, new_bill, Activity creation date,
default_data:80002, null, null, null, null, null, 3, false, true, null, New
Mail, true, null, 54, Litigation, true, Tue Apr 25 21:32:21 PDT 2006, null,
false, Tue Apr 25 21:32:21 PDT 2006, null, null, Urgent, 0, Event, 0, null,
null, Trial Date, null, Trial Date, trial_date, null, default_data:90001,
null, null, null, null, null, null, false, false, null, Litigation, true,
null, 55, Litigation, true, Tue Apr 25 21:32:21 PDT 2006, null, false, Tue
Apr 25 21:32:21 PDT 2006, null, null, Urgent, 0, Event, 0, null, null,
Mediation Date, null, Mediation Date, mediation_date, null,
default_data:90002, null, null, null, null, null, null, false, false, null,
Litigation, true, null, 56, General, true, Tue Apr 25 21:32:21 PDT 2006,
null, false, Tue Apr 25 21:32:21 PDT 2006, null, null, High, 0, Task, 0,
null, null, ISO returned matches, possible duplicate claims, Business days,
ISO matches found, iso_matches, Activity creation date, default_data:70001,
null, null, null, null, null, 3, false, true, null, ISO, false, null, 57]
- Follow-Ups:
- RE: SQL Error with CTP JDBC Driver 1.1
- From: Wes Clark
- RE: SQL Error with CTP JDBC Driver 1.1
- Prev by Date: RE: NullPointerException in CallableStatement of Sql server 2005 d
- Next by Date: RE: SQL Error with CTP JDBC Driver 1.1
- Previous by thread: RE: NullPointerException in CallableStatement of Sql server 2005 d
- Next by thread: RE: SQL Error with CTP JDBC Driver 1.1
- Index(es):
Relevant Pages
|
Loading
