Results 1 to 3 of 3
  1. #1
    jukie is offline Member
    Join Date
    Mar 2012
    Posts
    4
    Rep Power
    0

    Default Help (Basic Login)

    hi

    trying to create a login in page, using eclispe and mysql

    the issue is i'm having trouble connecting the two to each other,this is the error below, its look like that they are not connecting to each other

    this is the tutorial i followed JSP - Servlets: Full Login Example

    i'm really stuck and have spend most of weekend on it, as you can see i'm a beginner, can anyone help me or guide me the right way.

    youur user name is julieg
    Your password is jpassword
    Query: select * from users where username='julieg' AND password='jpassword'
    java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
    at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc .java:6957)
    at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java :7114)
    at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.j ava:3073)
    at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOd bcConnection.java:323)
    at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDrive r.java:174)
    at java.sql.DriverManager.getConnection(DriverManager .java:582)
    at java.sql.DriverManager.getConnection(DriverManager .java:185)
    at ExamplePackage.ConnectionManager.getConnection(Con nectionManager.java:24)
    at ExamplePackage.UserDAO.login(UserDAO.java:37)
    at ExamplePackage.LoginServlet.doGet(LoginServlet.jav a:32)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
    at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:237)
    at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:157)
    at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:214)
    at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:178)
    at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:825)
    at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnection(Http11Protocol.jav a:731)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:526)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:80)
    at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:619)
    Log In failed: An Exception has occurred! java.lang.NullPointerException

  2. #2
    jukie is offline Member
    Join Date
    Mar 2012
    Posts
    4
    Rep Power
    0

    Default Re: Help (Basic Login)

    UPDATE

    Ive might have solved it has to use a 32 ODBC manager instead so i done that and now have a new error,

    Query: select * from users where username='julieg' AND password='jpassword'
    Log In failed: An Exception has occurred! java.sql.SQLException: Column not found

  3. #3
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,009
    Rep Power
    20

    Default Re: Help (Basic Login)

    Pretty self explanatory.
    One of those columns doesn't exist...that is, presuming that is the actual query.

    Have you got the code?
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Similar Threads

  1. JSP Login
    By mpraveenu in forum JavaServer Pages (JSP) and JSTL
    Replies: 4
    Last Post: 01-17-2012, 05:03 AM
  2. Login
    By geniusokorro in forum NetBeans
    Replies: 5
    Last Post: 08-07-2011, 01:48 PM
  3. help with login
    By dhazwa in forum New To Java
    Replies: 2
    Last Post: 07-23-2011, 08:05 PM
  4. login.jsp
    By roo7 in forum Enterprise JavaBeans (EJB)
    Replies: 5
    Last Post: 12-02-2008, 03:58 PM
  5. Replies: 0
    Last Post: 06-25-2008, 12:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •