induz sat

I came across ucanAccess open source driver to get connection to MS access database.


I added all 5 jar files on my project's Library on Netbeans and the .accdb is getting connected. i use the following for the connection :
Connection conn=DriverManager.getConnection( "jdbc:ucanaccess://C:/__tmp/test/zzz.accdb");
and it works


Thanks

Thanks for suggestions. Yes I am using java 1.8 and 32 bit MS2007.

I can get connected with mySQL database with jdbc though.

But still waned to know if something to be installed for JDBC-ODBC connections to work with .accdb.

Thanks again

I created a local database UserInfo,accdb using MS Access 2007 on my c drive and trying to connect in Netbeans 7.4.
I configured DataSource ODBC using adminTool from Control panel.
public class DbConnection { Connection con; Statement st; ResultSet rs; //making constructor public DbConnection() { connect(); } private void connect() { try { // Load MS accces driver class Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // C:\\databaseFileName.accdb" - location of your database String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + "C:\\Users\\jaxie\\Documents\\NetBeansProjects\\LibraryDb\\Database1.accdb"; // specify url, username, pasword - make sure these are valid Connection conn = DriverManager.getConnection(url, "username", "password"); System.out.println("Connection Succesfull"); } catch (Exception ex) { System.err.println("Got an exception! "); System.err.println(ex.getMessage()); }

I get this error:
Got an exception! sun.jdbc.odbc.JdbcOdbcDriver exception is java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver

I am following this tutorial:
https://www.youtube.com/watch?v=PUeJbLmhuh8

what I am doing wrong?

Do I have to run a server for .accdb ? The database is on my local c drive.

What should be the query for checking userName and Password from registredUser table to be valid and matching with the Parameters[ 'user' and 'pw' ] from Login.jsp.
I am getting error and query is not working...please help

String sql = "INSERT INTO SocialNetwork.RegisteredUser( UserName, Password) values(?,?)"; conn = ConnectionFactory.getConnection(); PreparedStatement ptmt = (PreparedStatement) conn.prepareStatement(sql); ptmt.setString(1,user); ptmt.setString(2,pw); ptmt.executeUpdate(); Statement stmt = (Statement) conn.createStatement(); String query = "select * from registeredUser"; //storing user data in ResultSet ResultSet rs = stmt.executeQuery(query); if (rs.next()){ int id = rs.getInt("userID"); String name = rs.getString("userName"); String pass = rs.getString("Password"); { System.out.println("name-" + name+ "pass-"+pass+"ID-"+id); }

Thanks for the clarifications about 2 tables and PKs.
userId in Table 1[registeredUser] is the PK, that would be the same in the userInfo table. I could have stored all the records in a table[ registredUser] but for my learning I want to have 2 tables.

Now the big Q is when the user is being registered through Registration and UserRegistration servlet, how could I keep the PK FK relationship among both tables.

Column name, userId, is the same in both the Tables. userId in registredUser is PK; but I am not sure about its FK realtionship in userInfo

Hope to get some heads-up.

I have 2 tables in a Socialnetwork schema.
[1] registredUser- userId, userName, Password, age, sex,city- userId is PK and Auto Increment
[2] userinfo- userId, userName Password- userId is Pkey and Auto Incremnt

When a user login on a login.jsp, he submits username and Pasword.

These two parameters of login.jsp are checked in registeredUser Table. If matched, he could log in.

If he is unable to log in he has to register in registration.jsp supplying username, password, Age, sex and city parametsrs. These records are added to the RegistredUser table.

How can I add username and password in the userInfo table when the user has successful log in so that next time the check has to be in userinfo table only, not in registred table?

I want to have multiple JDBC-connections (to mySQL databse) in my servlet.

For each servlet I use:
database connection settings final String JDBC_DRIVER = "com.mysql.jdbc.Driver"; final String dbURL = "jdbc:mysql://localhost:3306/SocialNetwork"; final String dbUser = "root"; final String dbPass = "root"; Connection conn = null; //************************************************************* try { // Register JDBC driver Class.forName(JDBC_DRIVER); //*************************************************************** // DriverManager methods for connection to mySQL server System.out.println("Connecting to a selected database..."); conn = DriverManager.getConnection(dbURL, dbUser, dbPass); System.out.println("Connected database successfully..."); //*************************************************************** System.out.println("Connecting to a selected database...");
After establishing JDBC connection to SocialNetwork DataBase, I use insert, and update queries to add/update the records on my userInfo db.

PreparedStatement updateUserInfo = (PreparedStatement) conn .prepareStatement("insert into userInfo WHERE ( UserName, userPW) values(?,?)"); updateUserInfo.executeUpdate();

i want the same JDBC connection to use in another servlet[userLogin] in the same application/package.

Is there a way I can create another connection servler/class and import it and use it in all other Httpservlets responsible for registering a new user , checking records, updating records etc..in the same SocialNetwork Db but different tables??

The 'UserLogin' servlet checks two records userName and Password in 'registredUser' table when the user logs-in through a login.jsp page with userName and password.

I am getting input parameters onto the UserLogin servlet from Login.jsp as below String user = req.getParameter("loginName"); String pw = req.getParameter("loginPW");


How should i go about checking name and password in terms of sql queries- right now I am trying to use

String sql = "SELECT userName " + "FROM userInfo " + "WHERE userPass=?"; connection = ConnectionFactory.getConnection(); ptmt = (PreparedStatement) connection.prepareStatement(sql); ptmt.setString(1, user); resultSet = ptmt.executeQuery();

to make it clear I have 2 tables[ registredUser and UserInfo.
RegistredUser has these colums- UserId, userName, Password, Age and city. user Id is PK and AI.

UserInfo has userId, userName and Password. User Id is PK and AI in this table too.

How can i establish a relation between userID in two different tables and check/authenticate the userName and password??

java]Aug 25, 2013 9:13:11 AM org.apache.catalina.core.AprLifecycleListener init INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk7\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32; C:\Windows;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common; C:\Program Files\Common Files\Microsoft Shared\Windows Live; C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live; C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\; C:\Program Files (x86)\Windows Live\Shared;C:\Program Files\Java\jdk7\bin;C:\JavaWorkspace;C:\JavaWorkspace\jdk7; C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files (x86)\Spiceworks\Nmap;. Aug 25, 2013 9:13:11 AM org.apache.tomcat.util.digester.SetPropertiesRule begin WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:SocialNetwork02' did not find a matching property. Aug 25, 2013 9:13:11 AM org.apache.coyote.AbstractProtocolHandler init INFO: Initializing ProtocolHandler ["http-bio-8080"] Aug 25, 2013 9:13:11 AM org.apache.coyote.AbstractProtocolHandler init INFO: Initializing ProtocolHandler ["ajp-bio-8009"]

The tomcat starts but I get this on my server console in Indigo.

I had Juno SR 2 running with Tomcat7 and mySQL5.6.
I was getting some startup errors and other errors related to TomCat whenever I started Tomcat. So I delete the Tomcat server runtime Environment and also the directory.
• I have downloaded http://tomcat.apache.org/download-70.cgi for 64 bit version for window7- 64-bit Windows zip (pgp, md5)


Also my directories for JDK/JRE have been moved from original locations.

Now Tomcat in a different folder and JDK plus JRE in different folder under C: root.

How can I start from scratch again and set JAVA_HOME and CLASSPATH and other environment variables.

What this error on server console indicates??

SEVERE: Error starting static Resources java.lang.IllegalArgumentException: Document base C:\WorkSpace-Social\.metadata\.plugins\org.eclipse.wst.server.core\tmp2\wtpwebapps\SocialNetwork02 does not exist or is not a readable directory



Thanks

curly closing brace in line 6

was a typo. Corrected.

Could you please suggest a working link/example example of PreparedStatement generic class and its methods.

Thanks a lot...I can check a record in the same db in the same project through a Login.jsp and LoginServlet. Do I have to close the jdbc connection for another doPost method to connect??

Thanks again

I have UserRegistration servlet that fetches parameters from register.jsp and add records to RegisteredUser db through JDBC on Tomcat.

what is wrong in the code as when i run the jsp it shows all the elements of HTML form. but when i type in something in TextBox and submit it, Tomcat says "you are not connected to the internet". I can visit yahoo though from the same webbrowser. Also it does not add any records in RegisteredUser table.



try{ Class.forName(jdbc_driver); Connection conn= DriverManager.getConnection(db_URL, db_user, db_pass); Statement stmt = conn.createStatement(); //Statement stmt = conn.createStatement(); String sql =("INSERT INTO SocialNetwork.REGISTEREDUSER (Name,Password,Age} value (?,?,?)"); ResultSet rs= stmt.executeQuery(sql); if (rs.next()){ out.println("Welcome" +regdN); } else { out.println("<h2>Log in again Or <br>Register<h2>"); }

Thanks for describing about fetching all record vs what is required from the Db.

I have added the suggestions to the servlet and its working now with ResultSet.


Please helpe me to figure out what framework to use for making a simple social networking project.

So far I can get connected using simple JDBC to add a user and authenticate the credential using user's password and ID in a mySQL table.

Should I use Hibernate or just JDBC.

I am trying to authenticate user log in try { // Register JDBC driver Class.forName(JDBC_DRIVER); // DriverManager.getConnection method for connection to mySQL server System.out.println("Connecting to a selected database..."); conn = DriverManager.getConnection(dbURL, dbUser, dbPass); System.out.println("Connected database successfully..."); // create a Statement and update records System.out.println("checking records into the table..."); PreparedStatement checkUserInfo = (PreparedStatement) conn .prepareStatement("SELECT * FROM userInfo ( UserName, userPW) values(?,?)"); /*String name = checkUserInfo.getString("userName"); Statement stmt = (Statement) conn.createStatement(); String sql = "select * from userInfo (userName, UserPW) values(?,?)"; //PreparedStatement updateUserInfo = (PreparedStatement) conn //.prepareStatement("select * from socialnetwork.userInfo WHERE (userName, UserPW) values(?,?)"); //updateUserInfo.executeUpdate(); */ Statement stmt = (Statement) conn.createStatement(); String sql = "select * from userInfo (userName, UserPW) values(?,?)"; ResultSet rs= stmt.executeUpdate(sql); //storing user data in ResultSet //ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { String name = rs.getString("userName"); String pass = rs.getString("userPW"); if ( name==user && pass==pw) { //session.setAttribute("username",user); //resp.sendRedirect("http://localhost:8084/Socialnetwork02/index.jsp"); out.print("Login Successful"); } else { out.print("Login Unsucessfull. Try again."); //resp.sendRedirect("http://localhost:8084/SocialNetwork02/UserRegistration.jsp"); } } } catch (Exception e) { e.printStackTrace(); } } }

My Db has a table named UserInfo with 3 columns :- serail [ PK and AutoI], userName and UserPW

when I run this I get "HTTP Status 404 "

what is wrong and how to fix it.
'

I'd have to use The ResultSet interface

//statement Statement stmt = (Statement) conn.createStatement(); String sql = "select * from userInfo WHERE (userName, UserPW) values(?,?)"; //storing user data in ResultSet ResultSet rs = stmt.executeQuery(sql); if (rs.equals(userName) && rs.equals(pw)) { out.print("Login Successful"); } else { out.print("Login Unsucessfull. Try again."); }

I am getting"" HTTP method GET is not supported by this URL"". Also, I get the same erorr with POST.
what is wrong here??



Also, please move this thread to the right place.

Thanks.

My index.jsp for Login is:
<title>Social Networking</title> <script type="text/javascript"> function checkform() { if (document.Login.userName.value === '') { // something is wrong alert('Please Enter Your Name'); document.Login.userName.focus(); return false; } else if (document.Login.userPW.value === '') { // something else is wrong alert('Please Enter Pasword'); document.Login.userPW.focus(); return false; } /* else if (document.Login.userRePW.value === ' ' || document.Login.userReW.value !== document.Login.userPW.value) { // something else is wrong alert('Your Password Matching not found'); document.userLogin.userRePW.focus(); return false; } */ return true; } </script> </head> <body> <h2><font color=blue><b>Social Network </b></font> Please enter user name and password</h2> <form name="Login" action="http://localhost:8080/SocialNetwork02\userLogin" method="POST" onSubmit="return checkform();"> <b> Name: </b> <input type="text" name="userName" value=""/><br> <b> Password:</b><input type="Password" name="userPW" value=""/> <p> <input type="submit" value="Check"/> </p> </form> <a href="./UserRegistration.jsp"> To Register</a> </body> </html>


I retrieve the login attributes in a Http servlet named as userLogIn.java

protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { // get attributes from the jsp form String user = req.getParameter("userName"); String pw = req.getParameter("userPW");

How can I authenticate the log in parameters- userName and userPW in the userInfo table.
The userInfo table has three columns- serial#, username, userPW.
Serial# is the unique PK and Auto-Incremental.
I am using JDBC for connection