java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch i

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jazz1
    New Member
    • Jun 2007
    • 1

    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch i

    my coding is

    <%
    //Connection conn=null;
    //Statement st=null;
    //ResultSet rs=null;
    int msgCount;
    try
    {
    String userid=request. getParameter("a pplication_no") ;

    String Query="SELECT * FROM master WHERE To='"+userid+"' ";
    Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;
    Connection conn=DriverMana ger.getConnecti on("jdbc:odbc:c deDB","admin"," ");
    Statement st = conn.createStat ement(ResultSet .TYPE_SCROLL_SE NSITIVE,ResultS et.CONCUR_READ_ ONLY);
    //ResultSet rs=st.executeQu ery(Query);
    //rs.last();
    //msgCount=rs.get Row();
    //out.println("Yo u Have "+msgCount +" Messages");


    //Class.forName(" oracle.jdbc.dri ver.OracleDrive r");
    //Connection con = DriverManager.g etConnection("j dbc:oracle:thin :@rccadv7:1521: ORACL","coll"," coll");
    //Statement st=con.createSt atement();


    ResultSet che=st.executeQ uery("select count(*) from master where application_no= '"+userid+"' ");
    while(che.next( ))
    {
    int cnt=che.getInt( 1);
    if(cnt>0)
    {
    ResultSet rs=st.executeQu ery("select * from master where application_no= '"+userid+"' ");
    while(rs.next() )
    {
    String cpdf=rs.getStri ng("image");
    cpdf=cpdf.trim( );
    %>
Working...