This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes XML and Related Technologies and the fly likes SAXParser and java.sql types Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "SAXParser and java.sql types" Watch "SAXParser and java.sql types" New topic

SAXParser and java.sql types

Ahmed Basheer
Ranch Hand

Joined: Apr 15, 2004
Posts: 77
Hi Guys,
I need to define the java.sql.types in the XML doxument file.How I can I retrieve the types back when I parser the document. Do I have to specify it like this?
I want to map VARCHAR to java.sql types and don't want to do the string comparison. Is there any solution? I heard that these types can be specified in the xml schema document. Does that mean that I have to parse XML schema document as well to retrieve the element.Any help will be appreciated.
Lasse Koskela

Joined: Jan 23, 2002
Posts: 11962
There is no way of telling the parser to "give you java.sql.* objects" -- you need to parse the string into a Java object yourself with java.sql.Date#valueOf(String) etc.

Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
I agree. Here's the link:
subject: SAXParser and java.sql types
It's not a secret anymore!