AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Problem with table name          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message none Guest Posted: Fri Aug 11, 2006 4:30 pm    Post subject: Problem with table name Hi! I have a problem to access tables in an Informix Database. Table names are something like that : informix.pv_tvvte When I try a "SELECT informix.pv_tvvte.numero_vente FROM informix.pv_tvvte WHERE informix.pv_tvvte.numero_vente=#value#", (I use ibatis and spring) I get a syntax error exception (SQLException "Bad SQL Grammar"). If I replace dot with "_" in the name, I get a "Table Not Found" Exception. How could I escape the dot in the tables names ? TIA Arnaud Back to top Lee Fesperman Guest Posted: Sun Aug 13, 2006 6:32 am    Post subject: Re: Problem with table name none wrote: Quote: Hi! I have a problem to access tables in an Informix Database. Table names are something like that : informix.pv_tvvte When I try a "SELECT informix.pv_tvvte.numero_vente FROM informix.pv_tvvte WHERE informix.pv_tvvte.numero_vente=#value#", (I use ibatis and spring) I get a syntax error exception (SQLException "Bad SQL Grammar"). How could I escape the dot in the tables names ? The normal solution is to use name delimiters. They surround the name and allow you to use names that contain embedded special characters and are reserved words. For SQL92, you use double quotes ("); can't tell you what Informix takes. -- Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com) ============================================================== * The Ultimate DBMS is here! * FirstSQL/J Object/Relational DBMS (http://www.firstsql.com) Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.