jsp - Use column names with periods -

-

i've been writing jsp insert values excel sheet , code below.

<%@page import="java.sql.*"%> <% connection con = null; statement stmnt = null; try {     int updatequery=0;     string a=request.getparameter("comments");     string b=request.getparameter("updatedl");     string c=request.getparameter("sid");     string d=request.getparameter("desc");     string e=request.getparameter("pubcode");     string f=request.getparameter("type");     string g=request.getparameter("status");     string h=request.getparameter("daterec");     string i=request.getparameter("startd");     string j=request.getparameter("assignedd");     string k=request.getparameter("senttoae");     string l=request.getparameter("respfrmae");     string m=request.getparameter("vwrcmp");     string n=request.getparameter("ps");     string o=request.getparameter("test");     string p=request.getparameter("units");     string q=request.getparameter("vwr");     string r=request.getparameter("ie");     string s=request.getparameter("revdate");     string t=request.getparameter("reviews");   class.forname( "sun.jdbc.odbc.jdbcodbcdriver" ); con = drivermanager.getconnection( "jdbc:odbc:driver={microsoft excel driver (*.xls)};dbq=c:/jus/excel1.xls;");   stmnt = con.createstatement();  //string query="select column_name 'feb$'"; string query = "insert [feb$] (comments,'no. of lines updated in psis','shipment id',"+ "'sap txt description', 'phoenix pub code', 'product type', 'status of job', 'date request received',"+ "'start date', 'date assigned', 'date file sent ae', 'date response ae',"+ "'date completed --vwr', 'assigned ps', 'time estimate', units, 'date file needs sent vendor (vwr)',"+ "'internal errors', 'review date',  'review sent (yes/no)') values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; preparedstatement ps=con.preparestatement(query); ps.setstring(1, a); ps.setstring(2, b); ps.setstring(3, c); ps.setstring(4, d); ps.setstring(5, e); ps.setstring(6, f); ps.setstring(7, g); ps.setstring(8, h); ps.setstring(9, i); ps.setstring(10, j); ps.setstring(11, k); ps.setstring(12, l); ps.setstring(13, m); ps.setstring(14, n); ps.setstring(15, o); ps.setstring(16, p); ps.setstring(17, q); ps.setstring(18, r); ps.setstring(19, s); ps.setstring(20, t);  //out.print(query); resultset rs = ps.executequery();  if (updatequery != 0) { %> <br> <table style="background-color: #e3e4fa;"  width="30%" border="1">    <tr><th>data inserted   in database.</th></tr> </table> <% }  } catch( exception e ) { out.println( e ); } { try { stmnt.close(); con.close(); } catch( exception e ) { out.println( e ); } }          %>

when run i'm getting below exception.

java.sql.sqlexception: [microsoft][odbc excel driver] invalid bracketing of name ''no. of lines updated in psis''.

please let me know how can rid of exception without changing column name.

thanks


Comments

Post a Comment

Popular posts from this blog

c++11 - Intel compiler and "cannot have an in-class initializer" when using constexpr -

-
the following test program compiles , runs fine g++. intel icpc (14.0.2) compile , run if use explicit type double instead of template. template version icpc produces error: icpc -g -o2 -i. -std=c++0x -c main.cc -o main.o main.cc(10): error: member of type "const t [9]" cannot have in-class initializer static constexpr t dx_[9] = { test code template<typename t> class myclass { public: static constexpr t dx_[9] = { 1.5, 2.0, -0.5, -0.5, 0.0, 0.5, 0.5, -2.0, -1.5 }; }; template<typename t> constexpr t myclass<t>::dx_[9]; int main(int argc, char *argv[]) { return 0; } // main why receiving error "cannot have in-class initializer" when using constexpr ? this bug of intel compiler, submitted intel , fixed in future versions. also see multiple constexpr bugs , sfinae bug intel c++ compiler 15 , method constexpr bug c++ compiler 15 on intel forums.
Read more

rest - Spring boot: Request method 'PUT' not supported -

-
i getting request method 'put' not supported error on hitting put method on restful api upload file. following information uploaded ticket. client log restcontroller spring boot app config tomcat log pom.xml 1. client log $ curl -x put -t "/cygdrive/c/a/documents/test.pptx" http://localhost:8080/piranha-storage-service/buckets/gnaval.bucket1/test.pptx <html><head><title>apache tomcat/7.0.52 - error report</title><style><!--h1 {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;font-size:22px;} h2 {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;font-size:16px;} h3 {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;font-size:14px;} body {font-family:tahoma,arial,sans-serif;color:black;background-color:white;} b {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;} p {font-family:tahoma,arial,sans-serif;background:white;co...
Read more

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp...
Read more