File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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!