Error Sqlcode=-204 Sqlstate=42704
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us db2 sql error sqlcode=-204 sqlstate=42704 Learn more about Stack Overflow the company Business Learn more about hiring developers
Sqlcode=-204 Sqlstate=42704 Sqlerrmc=
or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack sqlcode -204 sqlstate 42704 Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Why do I get SQLCODE=-204, SQLSTATE=42704 with sqlcode=-104 DB2 LUW and WebSphere App Server? up vote 3 down vote favorite There are numerous web pages where people show this message as a symptom (with the value after SQLERRMC and the driver level varying): DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=M51Dev.CUSTOMER, DRIVER=3.61.65 including several here on StackOverflow. The error codes mean that an object -- nearly always a table -- is not found, and the value of
Sqlcode=-104 Sqlstate=42601
the SQLERRMC parameter contains the name of the object in question. In every other occurrence of this I can find, the solution was just that they needed to qualify the table name with the schema name. However, as you can see from the line above, that isn't the case here. The schema is M51Dev, and the table is CUSTOMER, and both of them exist. The environment is WebSphere Application Server (7.0.0.31 in this particular case, but I somehow doubt that's relevant) running on Windows Server 2003 R2, with DB2 9.7.300.3885 on an old XP machine. The datasource is defined in WAS and retrieved via JNDI. the application is written in Java, and our SQL is executed using JDBC via Spring's JdbcTemplates. The datasource definition in WAS includes a custom property called currentSchema, which is set to M51Dev. This is the relevant line of SQL (or one of them, as we get the same symptom for every table): SELECT rundateOverride FROM customer WHERE customerId=1 And here's an extract from the stack trace. I can provide more if it helps. bad SQL grammar [SELECT rundateOverride FROM customer WHERE customerId=1]; nested exception is com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=M51Dev.CUSTOMER, DRIVER=3.61.6
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and sqlcode 204 sqlstate 42704 ibm-db2 policies of this site About Us Learn more about Stack Overflow the is an undefined name.. sqlcode=-204, sqlstate=42704 company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users
Sql0204n Is An Undefined Name. Sqlstate=42704
Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes http://stackoverflow.com/questions/24144538/why-do-i-get-sqlcode-204-sqlstate-42704-with-db2-luw-and-websphere-app-server a minute: Sign up SQLCODE=-204, SQLSTATE=42704 only on local development server up vote 0 down vote favorite since today I am getting this weird SQL error on my local development Server. The Integration Test machine is fine even if I deploy the same artifacts on both. I know this question has been asked before, but none of the answers seemed to solve http://stackoverflow.com/questions/31031246/sqlcode-204-sqlstate-42704-only-on-local-development-server my problem so far. I already tried to switch from the myBatis ${variable} to #{variable} and back. And I also tried putting all the table names in doublequotes. Here is the error I get for every query I send to my local applicationserver (JBoss 6.1): ### Error querying database. Cause: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SCHEME.TABLENAME DRIVER=3.63.75 ### The error may exist in path/to/dao/mapper/DAOMapper.xml ### The error may involve path.to.dao.mapper.DAOMapper.daoMethod - inline ### The error occurred while setting parameters ### SQL: SELECT VAL1 as VAL1, VAL2 as VAL2, FROM SCHEME.TABLENAME WHERE VAR1= ( select MAX (VAR1) FROM SCHEME.TABLENAME WHERE VAR2 <= VAR2 ) WITH UR; ### Cause: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SCHEME.TABLENAME, DRIVER=3.63.75; bad SQL grammar []; nested exception is com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SCHEME.TABLENAME, DRIVER=3.63.75: org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SCHEME.TABLENAME, DRIVER=3.63.75 Any Ideas? sql db2 share|improve this question asked Jun 24 '15 at 15:51 Chry007 48111 SQLCODE=-204 simply means that SCHEME.TABLENAME does not exist. Since this is obviously not the real error message, and the
English » 1. Installation / Deployment / Setup Recent Posts Statistics RSS (Opens New Window) Answer (Unmark) Mark as https://web.liferay.com/community/forums/-/message_boards/message/896814 an Answer Threads [ Previous | Next ] HELP:DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704 petar banicevic May 27, 2008 5:05 PM RE: HELP:DB2 http://dbaspot.com/db2-udb/249265-db2-error-db2-sql-error-sqlcode-204-sqlstate-42704-a.html SQL error: SQLCODE: -204, SQLSTATE: 42704 petar banicevic July 12, 2008 12:38 PM RE: HELP:DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704 Namrata Hangal 204 sqlstate August 7, 2012 1:43 AM RE: HELP:DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704 Boris Yurkevich October 31, 2012 3:22 AM RE: HELP:DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704 Hitoshi Ozawa November 1, 2012 5:01 PM RE: HELP:DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704 Henri Charles July 14, 2016 error sqlcode=-204 sqlstate=42704 11:39 PM HELP:DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704 May 27, 2008 5:05 PM Answer petar banicevic Rank: Junior Member Posts: 72 Join Date: May 27, 2008 Recent Posts QUESTION:What mean these warnings and can I ignore them?Can I fix them ???Thank youPS:I created database on db2 with UTF-8 codeset ==================================(e.g. CREATE DATABASE LPORTAL ON 'C:' USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM; )And when launching portal I get following messages:==================================Starting Liferay Enterprise Portal 5.0.1 (Luther / Build 5001 / April 14, 2008)22:12:56,484 INFO [DynamicDialect:80] Determining dialect for DB2/NT 822:12:56,500 INFO [DynamicDialect:106] Using dialect org.hibernate.dialect.DB2Dialect22:12:58,125 INFO [PortalImpl:184] Portal lib url /C:/Program Files/liferay-portal-tomcat-6.0-5.0.1/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/com/liferay/portal/util/PortalImpl.class22:12:58,125 INFO [PortalImpl:209] Portal lib directory /C:/Program Files/liferay-portal-tomcat-6.0-5.0.1/webapps/ROOT/WEB-INF/lib/22:13:02,609 WARN [ReleaseLocalServiceImpl:83] DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB2ADMIN.RELEASE_22:13:02,609 INFO [ReleaseLocalServiceImpl:96] Create tables and populate with default data22:13:07,281 WARN [DBUtil:365] DB2 SQL error: SQLCODE: -614, SQLSTATE: 54008, SQLERRMC