Help (Basic Login)

[jukie]

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

[jukie]

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

[Tolls]

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

Have you got the code?