B2 Sql 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 db2 sql error sqlcode=-204 sqlstate=42704 Us Learn more about Stack Overflow the company Business Learn more about hiring developers ibm db2 sqlcode=-204 sqlstate=42704 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 sql return code 204 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
Sql Code 42704
of 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
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
Sqlcode 204 Sqlstate 42704 Ibm-db2
site About Us Learn more about Stack Overflow the company Business Learn more is an undefined name.. sqlcode=-204, sqlstate=42704 about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x sqlcode=-727, sqlstate=56098 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 a minute: Sign up DB2 SQL http://stackoverflow.com/questions/24144538/why-do-i-get-sqlcode-204-sqlstate-42704-with-db2-luw-and-websphere-app-server Error: SQLCODE=-204, SQLSTATE=42704 up vote 4 down vote favorite 1 I created local database in DB2 called "TestDB" then I created table called "TestTable". I found that the table is put under schema name is "yasmin". I am trying to connect to the DB2 database using JDBC but I got this exception R SQLException information [1/4/14 11:32:59:289 EST] 0000004d SystemErr R Error msg: DB2 http://stackoverflow.com/questions/20919298/db2-sql-error-sqlcode-204-sqlstate-42704 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.TESTTABLE, DRIVER=3.61.86 [1/4/14 11:32:59:290 EST] 0000004d SystemErr R SQLSTATE: 42704 [1/4/14 11:32:59:290 EST] 0000004d SystemErr R Error code: -204 [1/4/14 11:32:59:290 EST] 0000004d SystemErr R com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.TESTTABLE, DRIVER=3.61.86 I tried many solutions on the internet Like set schema but unfortunately doesn't work. This is the JDBC code I used String urlPrefix = "jdbc:db2:"; String url; String user; String password; String empNo; Connection con; Statement stmt; ResultSet rs; url = urlPrefix + "//127.0.0.1:50000/TestDB"; user = "db2admin"; password = "db2admin"; try { // Load the driver Class.forName("com.ibm.db2.jcc.DB2Driver"); System.out.println("**** Loaded the JDBC driver"); // Create the connection using the IBM Data Server Driver for JDBC and SQLJ con = DriverManager.getConnection (url, user, password); // Commit changes manually con.setAutoCommit(false); System.out.println("**** Created a JDBC connection to the data source"); stmt = con.createStatement(); con.createStatement(); System.out.println("**** Created JDBC Statement object"); // Execute a query and generate a ResultSet instance rs = stmt.executeQuery("select *from TestTable"); System.out.println("**** Created JDBC ResultSet object"); } catch (ClassNotFoundException e) { System.err.println("Could not load JDBC driver"); System.out.println("Exception: " + e); e.printStackTrace(); } catch(SQLException ex) { System.err.println("SQLException information"); while(ex!=null) { System.err.println ("Error msg: " + ex.getMessage()); System.err.
this is your first visit, be sure to check out the FAQ by clicking the link above. You may have http://www.dbforums.com/showthread.php?1622381-DB2-Error-DB2-SQL-error-SQLCODE-204-SQLSTATE-42704-SQLERRMC to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: DB2 Error - DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: Tweet Thread Tools Show Printable Version Subscribe to this Thread… 204 sqlstate Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-12-07,11:09 #1 gokul_ifs View Profile View Forum Posts Registered User Join Date Sep 2007 Posts 1 Unanswered: DB2 Error - DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: Hi all My application J2EEruns in jboss. I have migrated my database from b2 sql error a windows machine to a Linux machine. Jboss is starting without any error The application runs fine when running with the database in the windows machine. But when i try to run it with the database in the Linux machine (which is migrated from windows). It shows the following in the log file, ERROR [http-0.0.0.0-8080-1] com.infosys.saas.ecomm.catalog.dao.CatalogmasterDA OImpl - Error at the time of executing the query = CatalogmasterSearchQuery.Message B2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: cataloguser.TCATALOG_MASTER com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: cataloguser.TCATALOG_MASTER Help neded to fix this. Thankx in advance, Gokul Reply With Quote 09-12-07,12:57 #2 ARWinner View Profile View Forum Posts Registered User Join Date Jan 2003 Posts 4,286 Provided Answers: 5 This is the documentation on your error: LCAD-->? sql204 SQL0204N "