Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT ACCESS
HXTT Access v3.2
denis
2009-07-07 00:39:15.0
good day from russia ))

Try get data from file msaccess (locale "cp1251")

2009-07-06 15:24:15,328 ERROR worklist.server.WLFindRsp - Cannot execute query
java.lang.ClassCastException: com.hxtt.d.i cannot be cast to java.lang.Boolean
at com.hxtt.d.i.if(Unknown Source)
at com.hxtt.d.i.a(Unknown Source)

CP1251 not supported ?
or something else ?
names of tables and fields cp1251
Re:HXTT Access v3.2
HXTT Support
2009-07-07 04:10:37.0
>java.lang.ClassCastException: com.hxtt.d.i cannot be cast to java.lang.Boolean
That issue should have not relation with Cp1251. It seems that one function failed to return a bool value. Please check whether you're using the latest package. If yeah, please email us such a mdb file sample.
Re:Re:HXTT Access v3.2
HXTT Support
2009-07-08 07:52:33.0
Passed test with "select * from "����������������������������;". What's your failed sql?
Re:Re:Re:HXTT Access v3.2
Denis
2009-07-09 00:02:20.0
Good day, my query


query

SELECT
�������������������������������� as accession_number,
������������������������ as patient_id,
�������������� as patient_name,
������������������������ as patient_bth_date,
'S' as patient_sex,
'1.50' as patient_size,
'50' as patient_weight,
'1.2.801.1231233121' as study_uid,
'1' as req_physician,
'1' as req_proc_description,
'WLS' as scheduled_ae_title,
'11:00' as start_time
FROM
����������������������������
WHERE
'WLS' LIKE ? AND
�������������������������������� BETWEEN ? AND ? AND
���������������������� LIKE ?

Re:Re:Re:Re:HXTT Access v3.2
Denis
2009-07-09 00:32:19.0
LOG appserv after query

2009-07-09 11:15:06,943 INFO worklist.server.WLServer - Start Server listening on port 5001
2009-07-09 11:15:06,968 INFO ui.listener.WorklistManager - Worklist server is started successfully
2009-07-09 11:25:58,660 INFO worklist.server.WLFindRsp - Called AETitle: WLS
2009-07-09 11:25:58,661 INFO worklist.server.WLFindRsp - keys: (0008,0050) SH #0 [] Accession Number
(0010,0010) PN #0 [] Patient's Name
(0010,0020) LO #0 [] Patient ID
(0010,0030) DA #0 [] Patient's Birth Date
(0010,0040) CS #0 [] Patient's Sex
(0010,2110) LO #0 [] Contrast Allergies
(0020,000D) UI #0 [] Study Instance UID
(0032,1032) PN #0 [] Requesting Physician
(0032,1060) LO #0 [] Requested Procedure Description
(0040,0100) SQ #-1 [1 item] Scheduled Procedure Step Sequence
>ITEM #1 @80:
>(0008,0060) CS #0 [] Modality
>(0032,1070) LO #0 [] Requested Contrast Agent
>(0040,0001) AE #0 [] Scheduled Station AE Title
>(0040,0002) DA #18 [20000709-20090709] Scheduled Procedure Step Start Date
>(0040,0003) TM #0 [] Scheduled Procedure Step Start Time
>(0040,0006) PN #0 [] Scheduled Performing Physician's Name
>(0040,0007) LO #0 [] Scheduled Procedure Step Description
>(0040,0009) SH #0 [] Scheduled Procedure Step ID
>(0040,0010) SH #0 [] Scheduled Station Name
>(0040,0011) SH #0 [] Scheduled Procedure Step Location
>(0040,0012) LO #0 [] Pre-Medication
(0040,1001) SH #0 [] Requested Procedure ID
(0040,1003) SH #0 [] Requested Procedure Priority

2009-07-09 11:25:58,687 INFO worklist.server.WLFindRsp - facades length: 1
2009-07-09 11:25:58,688 INFO server.core.WLServerFacadeImpl - Application Entity Title: WLS
2009-07-09 11:25:58,688 INFO server.core.WLServerFacadeImpl - From date: Sun Jul 09 00:00:00 MSD 2000
2009-07-09 11:25:58,688 INFO server.core.WLServerFacadeImpl - To date: Thu Jul 09 23:59:59 MSD 2009
2009-07-09 11:25:58,688 INFO server.core.WLServerFacadeImpl - Modality: null
2009-07-09 11:25:58,689 INFO server.core.WLServerFacadeImpl - Date before convert: Sun Jul 09 00:00:00 MSD 2000
2009-07-09 11:25:58,689 INFO server.core.WLServerFacadeImpl - Date after convert: 2000-07-09 00:00:00.0
2009-07-09 11:25:58,689 INFO server.core.WLServerFacadeImpl - Date before convert: Thu Jul 09 23:59:59 MSD 2009
2009-07-09 11:25:58,690 INFO server.core.WLServerFacadeImpl - Date after convert: 2009-07-09 23:59:59.999
2009-07-09 11:25:58,690 INFO server.core.WLServerFacadeImpl - Passed ASTitle: WLS
2009-07-09 11:25:58,690 INFO server.core.WLServerFacadeImpl - Passed From Date: 2000-07-09 00:00:00.0
2009-07-09 11:25:58,690 INFO server.core.WLServerFacadeImpl - Passed To Date: 2009-07-09 23:59:59.999
2009-07-09 11:25:58,690 INFO server.core.WLServerFacadeImpl - Passed Modality: %
2009-07-09 11:25:58,691 INFO server.core.WLServerFacadeImpl - Param[query]:
SELECT
???????????????? as accession_number,
???????????? as patient_id,
??????? as patient_name,
???????????? as patient_bth_date,
'S' as patient_sex,
'1.50' as patient_size,
'50' as patient_weight,
'1.2.801.1231233121' as study_uid,
'1' as req_physician,
'1' as req_proc_description,
'WLS' as scheduled_ae_title,
'11:00' as start_time
FROM
??????????????
WHERE
'WLS' LIKE ? AND
???????????????? BETWEEN ? AND ? AND
??????????? LIKE ?

2009-07-09 11:25:59,437 DEBUG server.core.WLServerFacadeImpl - Result: []
2009-07-09 11:25:59,437 INFO worklist.server.WLFindRsp - dicoms: []
2009-07-09 11:25:59,437 INFO worklist.server.WLFindRsp - dicoms size: 0 dicomObjects size: 0
Re:Re:Re:Re:Re:HXTT Access v3.2
HXTT Support
2009-07-09 08:20:10.0
>WHERE
>'WLS' LIKE ? AND
>�������������������������������� BETWEEN ? AND ? AND
>���������������������� LIKE ?
Try
WHERE
'WLS' LIKE ? AND
(�������������������������������� BETWEEN ? AND ? )
AND ���������������������� LIKE ?


Re:Re:Re:Re:Re:Re:HXTT Access v3.2
Denis
2009-07-09 22:54:09.0
no changes, why in query "??????????????", m\b config.xml must be "cp1251" ?

2009-07-10 09:49:37,247 INFO server.core.WLServerFacadeImpl - Passed ASTitle: WLS
2009-07-10 09:49:37,247 INFO server.core.WLServerFacadeImpl - Passed From Date: 2000-07-10 00:00:00.0
2009-07-10 09:49:37,247 INFO server.core.WLServerFacadeImpl - Passed To Date: 2009-07-10 23:59:59.999
2009-07-10 09:49:37,247 INFO server.core.WLServerFacadeImpl - Passed Modality: %
2009-07-10 09:49:37,247 INFO server.core.WLServerFacadeImpl - Param[query]:
SELECT
???????????????? as accession_number,
???????????? as patient_id,
??????? as patient_name,
???????????? as patient_bth_date,
'S' as patient_sex,
'1.50' as patient_size,
'50' as patient_weight,
'1.2.801.1231233121' as study_uid,
'1' as req_physician,
'1' as req_proc_description,
'WLS' as scheduled_ae_title,
'11:00' as start_time
FROM
??????????????
WHERE
'WLS' LIKE ? AND
(???????????????? BETWEEN ? AND ? )
AND ??????????? LIKE ?

2009-07-10 09:49:38,786 DEBUG server.core.WLServerFacadeImpl - Result: []
2009-07-10 09:49:38,787 INFO worklist.server.WLFindRsp - dicoms: []
2009-07-10 09:49:38,787 INFO worklist.server.WLFindRsp - dicoms size: 0 dicomObjects size: 0
Re:Re:Re:Re:Re:Re:HXTT Access v3.2
Denis
2009-07-09 22:55:13.0

xsi:schemaLocation="http://www.kirkazan.ru/schemas/pacs/worklist/server/config config.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
5001


JDBC
com.hxtt.sql.access.AccessDriver
jdbc:access:////mnt/prime/test_2.mdb




query

SELECT
�������������������������������� as accession_number,
������������������������ as patient_id,
�������������� as patient_name,
������������������������ as patient_bth_date,
'S' as patient_sex,
'1.50' as patient_size,
'50' as patient_weight,
'1.2.801.1231233121' as study_uid,
'1' as req_physician,
'1' as req_proc_description,
'WLS' as scheduled_ae_title,
'11:00' as start_time
FROM
����������������������������
WHERE
'WLS' LIKE ? AND
(�������������������������������� BETWEEN ? AND ? )
AND ���������������������� LIKE ?



Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access v3.2
Denis
2009-07-09 23:01:22.0
config.xml sent by email
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access v3.2
Denis
2009-07-13 04:25:07.0
It works!
Thx

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap