Posts

SOLVED :- java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Exception :-  Please provide me a solution to following error when i try to run Java file which has connections to MYSQL database.  [javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver] with root cause java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1676) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1521) at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:126) at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:63) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at org.apache.jsp.login_jsp._jspService(login_jsp.java:62) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(J...
29 comments
Read more

Solved - HTTP Status 500 - No action instance for path /Login could be created

Solution :- Don't  use the pakage name as java or sun. use something else. Due to security issues, don't start your package name with java and/or sun word. PFB. Actual Problem :-  I am running the tomacat server its perfectly working and welcome file is displayed. But on submitting login form with user name & password ,  following error is given in browser. " HTTP Status 500 - No action instance for path /login could be created " Code of Struts-config.xml :-  <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE struts-config PUBLIC           "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN"           "http://jakarta.apache.org/struts/dtds/struts-config_1_2.dtd"> <struts-config>     <form-beans>         <form-bean name="LoginForm" type="org.apache.struts.validator.DynaValidatorForm">       ...
1 comment
Read more

To create a Materialized view with FAST REFRESH

Image
Materialized views  is used to replicate data from master(parent) to non-master sites in a replication environment. at non-master site it is replica of master site. so it is also known as ' snapshots' of master. Need of Materialized views :-                             Suppose I have two application, 1. for User Administration 2. actual user console. where based on user role user can perform different task. like Admin user can do administrative work, support user can monitor session, or see logs, and normal user can do all other things.                            For Both this application I have different schema, from User console while logging into application, i have to check user role given in User Administration console. So I need data from other application and which need to be synchronized. we can do this by DB jobs but t he...
Post a Comment
Read more

dda line drawing algorithm in java

Read about DDA (Digital differential analyzer) algorithm . You can find line drawing using bresenham's line algorithm here . Java Code for DDA line drawing algorithm. :- package applet; import java.applet.Applet; import java.awt.Button; import java.awt.Color; import java.awt.Dimension; import java.awt.Graphics; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.MouseEvent; import java.awt.event.MouseListener; import java.awt.event.MouseMotionListener; public class dda extends Applet implements MouseListener, MouseMotionListener, ActionListener {     int x1 = -1, y1 = -1, x2 = -1, y2 = -1,     //coordinates of start and end points             pixelsize = 12,                     //size of pixel in raster             xa = 0, xfin = 0, yfin = 0,         //increment and end po...
Post a Comment
Read more

Bresenham line drawing algorithm in java

   My friend Sandip is doing M.Tech from one of the reputed college. His lecturer asked him to do Java code for line drawing using Bresenham s , DDA algorithm. So I am posting this blog for  Bresenham line drawing algorithm in java and you can find line drawing using DDA algorithm  here . Read more about Bresenham's line algorithm  . Java code :-  package applet; import java.awt.Color; import java.awt.Dimension; import java.awt.Graphics; import java.awt.event.MouseEvent; import java.awt.event.MouseListener; import java.awt.event.MouseMotionListener; public class bresenhamLine extends java.applet.Applet implements MouseListener, MouseMotionListener { private static final long serialVersionUID = 1L; int width, height; int x1 = 0, y1 = 0, x2 = 0, y2 = 0, pixelsize = 2; public void init() {      width = getSize().width;      height = getSize().height;      this.addMous...
Post a Comment
Read more

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.

When I was trying to delete records from orderednotcompltedcarts tables when my customers order is succesfully placed. But when i tried to delete records form table by using below query delete from orderednotcompletecarts where custphone='1234567890'; it reports the above mentioned error :  Solution : -   It’s because I tried to update a table without a WHERE that uses a KEY column. The quick fix is to add SET SQL_SAFE_UPDATES=0; before delete query : SET SQL_SAFE_UPDATE=0 ; Or close the safe update mode  Go to  Edit -> Preferences -> SQL Queries and  disable Forbid UPDATE and DELETE statements with no key in where clause or no LIMIT clause.But you require to reconnect to make it available. Hope So You solve your problem with same solution. If not, then please update your problem in comments.
Post a Comment
Read more

Set current date as default for date Type in mysql

I have  to add new columns in table 'order' namely shippedDate and last_updated  which consist of datetime data type. i would like to do the following. a) Set shippedDate defaults value to MySQL NOW() or CURRENT_DATE    b) Set last_updated default value to  CURRENT_TIMESTAMP   Instead of null which it uses by default. as the table already exist and it already some existing records i would like to do Modify table, i tried using two different code but none is working. ALTER TABLE orders  ADD COLUMN  shippedDate   Date NULL default  CURRENT_DATE   AFTER 'previoueColumn' , ADD COLUMN ` last_updated  ` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP  AFTER ` shippedDate  ` ; It gives me Error :Error 1067 : Invalid default value for  shippedDate. is it possible for me to set the default datetime value to NOW() in MySQL? thank you...
2 comments
Read more

javax.mail.AuthenticationFailedException: 535 No SMTP server defined. Use real server address instead of 127.0.0.1 in your account.

I am trying to send mail using below program :-  public class mail { public static void main(String[] args) { final String username = "****@gmail.com"; final String password = "****"; Properties props = new Properties(); props.put("mail.smtp.auth", "true"); props.put("mail.smtp.starttls.enable", "true"); props.put("mail.smtp.host", "smtp.gmail.com"); props.put("mail.smtp.port", "587"); Session session = Session.getInstance(props,  new javax.mail.Authenticator() { protected PasswordAuthentication getPasswordAuthentication() { return new PasswordAuthentication(username, password); }  }); try { Message message = new MimeMessage(session); message.setFrom(new InternetAddress("piyush.mundada89@gmail.com")); message.setRecipients(Message.RecipientType.TO, InternetAddress.parse("piyush.mundada89@gmail.com...
6 comments
Read more