Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  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 Text(CSV)
SQL Exception Invalid Column Name
Martin Ross
2006-01-17 00:00:00.0
I get a SQLException when attempting to run a query. The column appears when I use AquaData studio to access the CSV file... I am running latest version of the JAR.

sqle= SQLException (id=198)
cause= SQLException (id=198)
detailMessage= "Invalid column: Physician First"
next= null
SQLState= "S0022"
stackTrace= null
vendorCode= 213249

Stack Trace
Thread [main] (Suspended (exception SQLException))
cl.a(af, aj, int, Object, Object, ab, boolean) line: not available
cl.a(Object, int, ab, int) line: not available
cl.a(bc, ac, d, int, boolean, int, String) line: not available
i(a7).a(y, m, b5, int, String) line: not available
i(a7).a(y, int, b5, m, Object) line: not available
cm(y).a(int, b5, m, Object) line: not available
cm.executeQuery() line: not available
NonBatchingBatcher(AbstractBatcher).getResultSet(PreparedStatement) line: 139
CustomLoader(Loader).getResultSet(PreparedStatement, boolean, boolean, RowSelection, SessionImplementor) line: 1669
CustomLoader(Loader).doQuery(SessionImplementor, QueryParameters, boolean) line: 662
CustomLoader(Loader).doQueryAndInitializeNonLazyCollections(SessionImplementor, QueryParameters, boolean) line: 224
CustomLoader(Loader).doList(SessionImplementor, QueryParameters) line: 2150
CustomLoader(Loader).listIgnoreQueryCache(SessionImplementor, QueryParameters) line: 2029
CustomLoader(Loader).list(SessionImplementor, QueryParameters, Set, Type[]) line: 2024
CustomLoader.list(SessionImplementor, QueryParameters) line: 117
SessionImpl.listCustomQuery(CustomQuery, QueryParameters) line: 1607
SessionImpl(AbstractSessionImpl).list(NativeSQLQuerySpecification, QueryParameters) line: 121
SQLQueryImpl.list() line: 169
NightingaleDocDB.createDoctorList(String) line: 112
NightingaleDocDB.connect() line: 49
BridgeDoctorDBCommandTest.testBridgeDoctorDBCommand() line: 56
NativeMethodAccessorImpl.invoke0(Method, Object, Object[]) line: not available [native method]
NativeMethodAccessorImpl.invoke(Object, Object[]) line: 39
DelegatingMethodAccessorImpl.invoke(Object, Object[]) line: 25
Method.invoke(Object, Object...) line: 585
BridgeDoctorDBCommandTest(TestCase).runTest() line: 154
BridgeDoctorDBCommandTest(TestCase).runBare() line: 127
TestResult$1.protect() line: 106
TestResult.runProtected(Test, Protectable) line: 124
TestResult.run(TestCase) line: 109
BridgeDoctorDBCommandTest(TestCase).run(TestResult) line: 118
TestSuite.runTest(Test, TestResult) line: 208
TestSuite.run(TestResult) line: 203
RemoteTestRunner.runTests(String[], String) line: 478
RemoteTestRunner.run() line: 344
RemoteTestRunner.main(String[]) line: 196





JDBC URL: jdbc:csv://///David/direct mail/Doctors/Patient Info/Hasson/Extract

The SQL Attempting to execute: select distinct "Physician First" as firstName, "Physician Last" as lastName, '' as uniqueDoctorID, '' as addressLine1, '' as addressLine2, '' as city, '' as postalCode from NightingalePatients

CSV Header for NightinGalePatients.csv
Physician Last,Physician First,Last,First,DOB,Chart #,Sex,Address,Address2,City,Prov,Post Code,Phone,Ext,Email,# of Visits,Last Service Date Billed,Last Blled,Last Billed Date,HealthNum,HealthVersion


Re:SQL Exception Invalid Column Name
HXTT Support
2006-01-18 00:00:00.0
>JDBC URL: jdbc:csv://///David/direct mail/Doctors/Patient Info/Hasson/Extract
You should use jdbc:csv://///David/direct mail/Doctors/Patient Info/Hasson/Extract?_CSV_Header=true

> select distinct "Physician First" as firstName, "Physician Last" as
> lastName, '' as uniqueDoctorID, '' as addressLine1, '' as addressLine2,
> '' as city, '' as postalCode from NightingalePatients
Your sal is correct, but maybe you wish to use:
select distinct "Physician First" as firstName, "Physician Last" as lastName, "DOB" as uniqueDoctorID, "Address" as addressLine1, "Address2" as addressLine2, city, "Post Code" as postalCode from NightingalePatients

Re:Re:SQL Exception Invalid Column Name
ross@medicaltelecom.com
2006-01-18 00:00:00.0
You can close this issue. It was a problem with _CSV_Header=true not being set via Hibernate.

Thanks,

Martin

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