Advertisement
Guest User

Untitled

a guest
Aug 27th, 2014
196
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.16 KB | None | 0 0
  1. select * from myTable where objtype='EQUI' and scnrtype='C'
  2. java.sql.SQLException: Column 'dataType' not found.
  3. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
  4. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
  5. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
  6. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
  7. at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1162)
  8. at com.mysql.jdbc.ResultSetImpl.getCharacterStream(ResultSetImpl.java:2056)
  9. at com.hastha.marerp.googlemaps.DBUtils.getScreenFields(DBUtils.java:672)
  10. at com.hastha.marerp.googlemaps.DBUtils.getScreenFieldsJSON(DBUtils.java:754)
  11. at com.hastha.marerp.googlemaps.DynamicMenuItemBuilder.doGet(DynamicMenuItemBuilder.java:67)
  12. at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
  13. at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
  14. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  15. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  16. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  17. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  18. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  19. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
  20. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
  21. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
  22. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
  23. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  24. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
  25. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  26. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
  27. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
  28. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
  29. at org.apache.tomcat.util.net.JIoEondpoint$SocketProcessor.run(JIoEndpoint.java:316)
  30. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  31. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  32. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  33. at java.lang.Thread.run(Unknown Source)
  34.  
  35. public ArrayList<ScenarioFieldInfo> getScreenFields(String objType, String scenarioType)
  36. {
  37. System.out.println("Input args objType: "+objType+" and scenarioType: "+scenarioType);
  38. PreparedStatement pst = null;
  39. ResultSet rs = null;
  40. ArrayList<ScenarioFieldInfo> scenarioFieldList = new ArrayList<ScenarioFieldInfo>();
  41. try {
  42. String sql = "select * from myTable where objtype='"+objType+"' and scnrtype='"+scenarioType+"'";
  43. System.out.println(sql);
  44. pst = (PreparedStatement) conn.prepareStatement(sql.toString());
  45. rs = pst.executeQuery();
  46. while(rs.next()){
  47. ScenarioFieldInfo fieldInfo = new ScenarioFieldInfo();
  48. fieldInfo.fieldName = rs.getString("fieldName");
  49. fieldInfo.fieldLabel = rs.getString("FieldLabel");
  50. //fieldInfo.sapType=rs.getString("dataType");
  51. BufferedReader reader=new BufferedReader(rs.getCharacterStream("dataType"));
  52. try {
  53. String sapType=reader.readLine();
  54. fieldInfo.sapType=sapType;
  55. } catch (IOException e) {
  56. // TODO Auto-generated catch block
  57. e.printStackTrace();
  58. }
  59. fieldInfo.parameter=rs.getString("PARAMETER");
  60. scenarioFieldList.add(fieldInfo);
  61. }
  62. System.out.println("There are "+scenarioFieldList.size()+" screen fields");
  63. } catch (SQLException e) {
  64. e.printStackTrace();
  65. }
  66. finally
  67. {
  68. close(rs);
  69. close(pst);
  70. }
  71. return scenarioFieldList;
  72. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement