Select deptno, dname, dtype, dphone, dfax, ddescription, dupper, dcreatedate from Dept where deptno = 1
The SQL statement is executed in PLSQL,ProgramThe following error is reported.
If (Rs. Next ()){
Dept. setdeptno (Rs. getint ("deptno "));
Dept. setdeptname (Rs. getstring ("dname "));
Dept. setdepttype (Rs. getstring ("dtype "));
Dept. setdeptphone (Rs. getstring ("dphone "));
Dept. setdeptfax (Rs. getstring ("dfax "));
Dept. setdeptdescription (Rs. getstring ("ddescription "));
Dept. setdupper (Rs. getint ("dupper "));
Dept. setdeptcreatedate (Rs. getstring ("dcreatedate "));
}
Java. SQL. sqlexception: the column name is invalid.
At oracle. JDBC. Driver. databaseerror. throwsqlexception (databaseerror. Java: 112)
At oracle. JDBC. Driver. databaseerror. throwsqlexception (databaseerror. Java: 146)
At oracle. JDBC. Driver. databaseerror. throwsqlexception (databaseerror. Java: 208)
At oracle. JDBC. Driver. oraclestatement. getcolumnindex (oraclestatement. Java: 3296)
At oracle. JDBC. Driver. oracleresultsetimpl. findcolumn (oracleresultsetimpl. Java: 1914)
At oracle. JDBC. Driver. oracleresultset. getstring (oracleresultset. Java: 1515)
At org. Apache. tomcat. DBCP. DBCP. delegatingresultset. getstring (delegatingresultset. Java: 263)
At org. Apache. tomcat. DBCP. DBCP. delegatingresultset. getstring (delegatingresultset. Java: 263)
At com. Neusoft. hr. model. Dao. impl. deptinfodaoimpl. finddeptbyid (deptinfodaoimpl. Java: 182)
At com. Neusoft. hr. model. Service. deptservice. finddeptbyid (deptservice. Java: 104)
At org. Apache. jsp. View. dept_005fpost.deptmod_jsp. _ jspservice (deptmod_jsp.java: 112)
At org. Apache. Jasper. runtime. httpjspbase. Service (httpjspbase. Java: 70)
At javax. servlet. http. httpservlet. Service (httpservlet. Java: 717)
At org. Apache. Jasper. servlet. jspservletwrapper. Service (jspservletwrapper. Java: 377)
At org. Apache. Jasper. servlet. jspservlet. servicejspfile (jspservlet. Java: 313)
At org. Apache. Jasper. servlet. jspservlet. Service (jspservlet. Java: 260)
At javax. servlet. http. httpservlet. Service (httpservlet. Java: 717)
At org. Apache. Catalina. Core. applicationfilterchain. internaldofilter (applicationfilterchain. Java: 290)
At org. Apache. Catalina. Core. applicationfilterchain. dofilter (applicationfilterchain. Java: 206)
At com. Neusoft. hr. utils. encodingfilter. dofilter (encodingfilter. Java: 29)
At org. Apache. Catalina. Core. applicationfilterchain. internaldofilter (applicationfilterchain. Java: 235)
At org. Apache. Catalina. Core. applicationfilterchain. dofilter (applicationfilterchain. Java: 206)
At org. Apache. Catalina. Core. standardwrappervalve. Invoke (standardwrappervalve. Java: 233)
At org. Apache. Catalina. Core. standardcontextvalve. Invoke (standardcontextvalve. Java: 191)
At org. Apache. Catalina. Core. standardhostvalve. Invoke (standardhostvalve. Java: 127)
At org. Apache. Catalina. Valves. errorreportvalve. Invoke (errorreportvalve. Java: 102)
At org. Apache. Catalina. Core. standardenginevalve. Invoke (standardenginevalve. Java: 109)
At org. Apache. Catalina. connector. coyoteadapter. Service (coyoteadapter. Java: 298)
At org. Apache. Coyote. http11.http11aprprocessor. Process (http11aprprocessor. Java: 861)
At org. Apache. Coyote. http11.http11aprprotocol $ http11connectionhandler. Process (http11aprprotocol. Java: 579)
At org.apache.tomcat.util.net. aprendpoint $ worker. Run (aprendpoint. Java: 1584)
At java. Lang. thread. Run (thread. Java: 619)
After the statement is commented out, there is no problem. After troubleshooting, it turns out that the date field in the database is not properly handled.
Change Dept. setdeptcreatedate (Rs. getstring ("dcreatedate") to Dept. setdeptcreatedate (Rs. getdate ("dcreatedate"). tostring (). The problem will be solved later. (PS: For ease of processing, I use string type processing in the program to insert a database, and use to_date () for conversion during the update operation)