 |
|
|
|
Next: SBS Backup Failures after Installing SQL 2005
|
| Author |
Message |
External
Since: Jan 12, 2006
Posts: 60
|
(Msg. 1) Posted: Tue Apr 25, 2006 10:14 pm
Post subject: SQL Error with CTP JDBC Driver 1.1
Archived from groups: microsoft>public>sqlserver>jdbcdriver (more info?)
|
|
|
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] |
|
| Back to top |
|
 | |
External
Since: Feb 28, 2006
Posts: 10
|
(Msg. 2) Posted: Wed Apr 26, 2006 7:55 pm
Post subject: RE: SQL Error with CTP JDBC Driver 1.1 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi Wes,
Thanks a lot for the feedback. In order to investigate this issue I would
need the following information,
1) Backend column types
2) How the parameters are set in the prepared statement (assuming that you
are using a PreparedStatement)
Also, if it is convenient for you a repro would be more than sufficient.
Thanks again,
Yesim |
|
| Back to top |
|
| |
External
Since: Jan 12, 2006
Posts: 60
|
(Msg. 3) Posted: Wed Apr 26, 2006 7:55 pm
Post subject: RE: SQL Error with CTP JDBC Driver 1.1 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I can stop in the debugger on the SQLException in
SQLServerPreparedStatement.executeBatch().
At that point, batchParameters is an ArrayList wiht 57 entries. Each entry
is an array of 33 DTV objects. Each DTVImpl has a jdbcType and value.
"Yesim Koman" wrote:
> Hi Wes,
>
> Thanks a lot for the feedback. In order to investigate this issue I would
> need the following information,
>
> 1) Backend column types
> 2) How the parameters are set in the prepared statement (assuming that you
> are using a PreparedStatement)
>
> Also, if it is convenient for you a repro would be more than sufficient.
> Thanks again,
>
> Yesim
>
> >> Stay informed about: SQL Error with CTP JDBC Driver 1.1 |
|
| Back to top |
|
| |
External
Since: Jan 12, 2006
Posts: 60
|
(Msg. 4) Posted: Wed Apr 26, 2006 10:18 pm
Post subject: RE: SQL Error with CTP JDBC Driver 1.1 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In my debugger (IntelliJ), the first method that reports the SQLException is
java.lang.Object getValue(com.microsoft.sqlserver.jdbc.DTV dtv, int i,
boolean b, int i1, java.lang.Object object) throws
com.microsoft.sqlserver.jdbc.SQLServerException in AppDTVImpl.
I don't have much debugging info since it is compiled code, but the object
at that point is holding int 12 in jdbcType, null is java.lang.Object and
null in setterArgs.
It was called from Parameter.getTypeDefinition. That object held false in
isOutput, 1 in jdbcType, 4 in outScale, null in name, null in outDTV, the
object described above in inDTV, true in inBatch, and in typeInfo, an
instance of TypeInfo with userType =0, isNullable=false, tdsType=0, and all
the rest of the fields 0 or null.
"Yesim Koman" wrote:
> Hi Wes,
>
> Thanks a lot for the feedback. In order to investigate this issue I would
> need the following information,
>
> 1) Backend column types
> 2) How the parameters are set in the prepared statement (assuming that you
> are using a PreparedStatement)
>
> Also, if it is convenient for you a repro would be more than sufficient.
> Thanks again,
>
> Yesim
>
> >> Stay informed about: SQL Error with CTP JDBC Driver 1.1 |
|
| Back to top |
|
| |
External
Since: Feb 28, 2006
Posts: 10
|
(Msg. 5) Posted: Thu Apr 27, 2006 2:55 pm
Post subject: RE: SQL Error with CTP JDBC Driver 1.1 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: May 02, 2006
Posts: 4
|
(Msg. 6) Posted: Tue May 02, 2006 11:57 am
Post subject: RE: SQL Error with CTP JDBC Driver 1.1 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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]
> >> Stay informed about: SQL Error with CTP JDBC Driver 1.1 |
|
| Back to top |
|
| |
External
Since: Jan 12, 2006
Posts: 60
|
(Msg. 7) Posted: Tue May 02, 2006 2:29 pm
Post subject: RE: SQL Error with CTP JDBC Driver 1.1 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I'm not sure if I understand what you were doing before to pass a null if you
weren't using the the setNull method.
"JPorter" wrote:
> 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 >> Stay informed about: SQL Error with CTP JDBC Driver 1.1 |
|
| Back to top |
|
| |
External
Since: May 02, 2006
Posts: 4
|
(Msg. 8) Posted: Tue May 02, 2006 2:55 pm
Post subject: RE: SQL Error with CTP JDBC Driver 1.1 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Wes- I'm sorry if I wasn't clear before. Yes, we were absolutely using the
setNull method - however, initially we had the following Java code for a
field defined as a VARCHAR:
insertStmt.setNull(1, Types.VARCHAR)
when we changed it to Types.CHAR - the problem you are seeing was no longer
occuring.
Types.VARCHAR seemed to work fine with the 1.0 release of the driver for SQL
Server 2005 as well as the BETA driver for 2005 - but just not in this CTP
release. The same was found with Types.DECIMAL - they had to be changed to
Types.REAL in the .setNull() method - otherwise exceptions were thrown.
Hope this is more clear...
Jon
"Wes Clark" wrote:
> I'm not sure if I understand what you were doing before to pass a null if you
> weren't using the the setNull method.
>
> "JPorter" wrote:
>
> > 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, >> Stay informed about: SQL Error with CTP JDBC Driver 1.1 |
|
| Back to top |
|
| |
External
Since: Jan 12, 2006
Posts: 60
|
(Msg. 9) Posted: Tue May 02, 2006 2:59 pm
Post subject: RE: SQL Error with CTP JDBC Driver 1.1 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Yes, it is clear now. This is definitely a workaround, and not really the
way you'd like to code it, so I will definitely wait for the fixed version.
"JPorter" wrote:
> Wes- I'm sorry if I wasn't clear before. Yes, we were absolutely using the
> setNull method - however, initially we had the following Java code for a
> field defined as a VARCHAR:
>
> insertStmt.setNull(1, Types.VARCHAR)
>
> when we changed it to Types.CHAR - the problem you are seeing was no longer
> occuring.
> Types.VARCHAR seemed to work fine with the 1.0 release of the driver for SQL
> Server 2005 as well as the BETA driver for 2005 - but just not in this CTP
> release. The same was found with Types.DECIMAL - they had to be changed to
> Types.REAL in the .setNull() method - otherwise exceptions were thrown.
>
> Hope this is more clear...
>
> Jon
> "Wes Clark" wrote:
>
> > I'm not sure if I understand what you were doing before to pass a null if you
> > weren't using the the setNull method.
> >
> > "JPorter" wrote:
> >
> > > 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, >> Stay informed about: SQL Error with CTP JDBC Driver 1.1 |
|
| Back to top |
|
| |
External
Since: May 02, 2006
Posts: 4
|
(Msg. 10) Posted: Tue May 02, 2006 3:18 pm
Post subject: RE: SQL Error with CTP JDBC Driver 1.1 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Wes - Thanks for your response. Yes, totally agree - it's only a workaround
if you are in a jam- like we were. Due to some other bugs in the initial
release, we needed to use this CTP release.
Have you heard anything more from Microsoft on this?
Thanks,
Jon
"Wes Clark" wrote:
> Yes, it is clear now. This is definitely a workaround, and not really the
> way you'd like to code it, so I will definitely wait for the fixed version.
>
> "JPorter" wrote:
>
> > Wes- I'm sorry if I wasn't clear before. Yes, we were absolutely using the
> > setNull method - however, initially we had the following Java code for a
> > field defined as a VARCHAR:
> >
> > insertStmt.setNull(1, Types.VARCHAR)
> >
> > when we changed it to Types.CHAR - the problem you are seeing was no longer
> > occuring.
> > Types.VARCHAR seemed to work fine with the 1.0 release of the driver for SQL
> > Server 2005 as well as the BETA driver for 2005 - but just not in this CTP
> > release. The same was found with Types.DECIMAL - they had to be changed to
> > Types.REAL in the .setNull() method - otherwise exceptions were thrown.
> >
> > Hope this is more clear...
> >
> > Jon
> > "Wes Clark" wrote:
> >
> > > I'm not sure if I understand what you were doing before to pass a null if you
> > > weren't using the the setNull method.
> > >
> > > "JPorter" wrote:
> > >
> > > > 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, >> Stay informed about: SQL Error with CTP JDBC Driver 1.1 |
|
| Back to top |
|
| |
External
Since: Jan 12, 2006
Posts: 60
|
(Msg. 11) Posted: Tue May 02, 2006 3:21 pm
Post subject: RE: SQL Error with CTP JDBC Driver 1.1 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
No. I'm just watching this thread.
"JPorter" wrote:
> Wes - Thanks for your response. Yes, totally agree - it's only a workaround
> if you are in a jam- like we were. Due to some other bugs in the initial
> release, we needed to use this CTP release.
>
> Have you heard anything more from Microsoft on this?
>
> Thanks,
> Jon
>
> "Wes Clark" wrote:
>
> > Yes, it is clear now. This is definitely a workaround, and not really the
> > way you'd like to code it, so I will definitely wait for the fixed version.
> >
> > "JPorter" wrote:
> >
> > > Wes- I'm sorry if I wasn't clear before. Yes, we were absolutely using the
> > > setNull method - however, initially we had the following Java code for a
> > > field defined as a VARCHAR:
> > >
> > > insertStmt.setNull(1, Types.VARCHAR)
> > >
> > > when we changed it to Types.CHAR - the problem you are seeing was no longer
> > > occuring.
> > > Types.VARCHAR seemed to work fine with the 1.0 release of the driver for SQL
> > > Server 2005 as well as the BETA driver for 2005 - but just not in this CTP
> > > release. The same was found with Types.DECIMAL - they had to be changed to
> > > Types.REAL in the .setNull() method - otherwise exceptions were thrown.
> > >
> > > Hope this is more clear...
> > >
> > > Jon
> > > "Wes Clark" wrote:
> > >
> > > > I'm not sure if I understand what you were doing before to pass a null if you
> > > > weren't using the the setNull method.
> > > >
> > > > "JPorter" wrote:
> > > >
> > > > > 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 >> Stay informed about: SQL Error with CTP JDBC Driver 1.1 |
|
| Back to top |
|
| |
External
Since: Feb 28, 2006
Posts: 10
|
(Msg. 12) Posted: Thu May 04, 2006 9:27 pm
Post subject: RE: SQL Error with CTP JDBC Driver 1.1 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi Wes,
Thanks for your patience. Without a repro I can't completely pinpoint the
cause of your problem. However, you are most likely observing the same CTP1
regression that some of our other customers reported.
Namely, if batch updates are executed through a PreparedStatement with the
same parameter set to different types within the batch, such a conversion
exception can be thrown. For example, using JPorter's example the following
code fails with CTP1.
insertStmt.setNull(1, Types.VARCHAR)
insertStmt.addBatch();
insertStmt.setNull(1, Types.CHAR)
insertStmt.addBatch();
insertStmt.executeBatch();
Exception thrown : java.sql.BatchUpdateException:
com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from CHAR
to VARCHAR is unsupported.
We have a bug filed for this issue and we already have a proposed fix. We
put the bootleg in your share location where you picked up CTP1. We would
really appreciate it if you could pick up the jar and let us know whether
you are still observing the same failure. Thanks a lot and hope this helps,
Yesim [MSFT] >> Stay informed about: SQL Error with CTP JDBC Driver 1.1 |
|
| Back to top |
|
| |
External
Since: Jan 12, 2006
Posts: 60
|
(Msg. 13) Posted: Tue May 23, 2006 1:44 pm
Post subject: RE: SQL Error with CTP JDBC Driver 1.1 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I'm sorry for the tardy reply. I didn't get notified of your post. I tried
getting a new version from the same location using the same password as
before, but nothing was found.
"Yesim Koman" wrote:
> Hi Wes,
>
> Thanks for your patience. Without a repro I can't completely pinpoint the
> cause of your problem. However, you are most likely observing the same CTP1
> regression that some of our other customers reported.
>
> Namely, if batch updates are executed through a PreparedStatement with the
> same parameter set to different types within the batch, such a conversion
> exception can be thrown. For example, using JPorter's example the following
> code fails with CTP1.
>
> insertStmt.setNull(1, Types.VARCHAR)
> insertStmt.addBatch();
> insertStmt.setNull(1, Types.CHAR)
> insertStmt.addBatch();
> insertStmt.executeBatch();
>
> Exception thrown : java.sql.BatchUpdateException:
> com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from CHAR
> to VARCHAR is unsupported.
>
> We have a bug filed for this issue and we already have a proposed fix. We
> put the bootleg in your share location where you picked up CTP1. We would
> really appreciate it if you could pick up the jar and let us know whether
> you are still observing the same failure. Thanks a lot and hope this helps,
>
> Yesim [MSFT]
>
> >> Stay informed about: SQL Error with CTP JDBC Driver 1.1 |
|
| Back to top |
|
| |
External
Since: Jan 12, 2006
Posts: 60
|
(Msg. 14) Posted: Wed May 24, 2006 2:52 pm
Post subject: RE: SQL Error with CTP JDBC Driver 1.1 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I can confirm the “bootleg” version I was provided does not encounter the
same error under the same circumstances. The error scenario ran without an
error. I will keep the bootleg version loaded on my machine and report if I
see anything else.
"Wes Clark" wrote:
> I'm sorry for the tardy reply. I didn't get notified of your post. I tried
> getting a new version from the same location using the same password as
> before, but nothing was found.
>
> "Yesim Koman" wrote:
>
> > Hi Wes,
> >
> > Thanks for your patience. Without a repro I can't completely pinpoint the
> > cause of your problem. However, you are most likely observing the same CTP1
> > regression that some of our other customers reported.
> >
> > Namely, if batch updates are executed through a PreparedStatement with the
> > same parameter set to different types within the batch, such a conversion
> > exception can be thrown. For example, using JPorter's example the following
> > code fails with CTP1.
> >
> > insertStmt.setNull(1, Types.VARCHAR)
> > insertStmt.addBatch();
> > insertStmt.setNull(1, Types.CHAR)
> > insertStmt.addBatch();
> > insertStmt.executeBatch();
> >
> > Exception thrown : java.sql.BatchUpdateException:
> > com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from CHAR
> > to VARCHAR is unsupported.
> >
> > We have a bug filed for this issue and we already have a proposed fix. We
> > put the bootleg in your share location where you picked up CTP1. We would
> > really appreciate it if you could pick up the jar and let us know whether
> > you are still observing the same failure. Thanks a lot and hope this helps,
> >
> > Yesim [MSFT]
> >
> > >> Stay informed about: SQL Error with CTP JDBC Driver 1.1 |
|
| Back to top |
|
| |
| Related Topics: | SQLServer 2000 Driver for JDBC]Error establishing socket - Error: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. After trying all from Microsoft KB 313178, I'm asking here. Application information: Software runs under JBOSS, and JSDK 1.4.1_02 from cmd prompt. It works at other..
JDBC Driver for SQL 7.0 ? - Hi; I'm installing an application that requires a JDBC driver for SQL Server. The thing is I am running SQL Server 7.0 and a look at Microsoft seems to show there are lots of these drivers for SQL 2000 but not for 7.0 I know little about these things -...
New JDBC Driver 1/19/06 & SSL ? - Does the today release new JDBC Driver support SSL encryption ?
JDBC 2005 Driver - Hi guys, I'm finding that if I run a query that returns a large amount of data I get java heap crashes. I have already set the jvm heap size but it's made no difference. Below is an exception trace - any comments appreciated! Thanks Shane << Ca...
SQL 2K JDBC driver with WebSphere - Hi, I am trying to use SQL 2K JDBC driver SP3 in WebSphere app server. I created an new JDBC provider, point the class path to where msbase.jar, mssqlserver.jar, and msutil.jar files are. I did not put anything in the "Native Library Path".... |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
