WebPrintVideoAudioMusicClient LoginMember Login
  • Latest Posts
  • Monthly Posts


  • Contact Us:
    315-469-8414


    Contact Form


    4701 Wrightsville Ave #2203
    Wilmington, NC 28403

    Site Links:
    Clients Area
    Members Area
    H.O.W.D.Y. Help!
    H.O.W.D.Y. Tools
    H.O.W.D.Y. Games
    Spammer Info
    Site Map

    Our Network:
    H.O.W.D.Y. Media
    H.O.W.D.Y. Web
    H.O.W.D.Y. Print
    H.O.W.D.Y. Video
    H.O.W.D.Y. Audio
    H.O.W.D.Y. Music
    H.O.W.D.Y. Host
    H.O.W.D.Y. Mail
    H.O.W.D.Y. Photo
    H.O.W.D.Y. Space
    SEO No-No
    Veggie Kisses
    fadishist

    The content of this site is
    ©2000-2024 H.O.W.D.Y Media
    Wordpress Themes
    from $99
    Custom made to match you existing website, 24 Hours of FREE option


    OSCommerce Work
    from $99
    Custom Themes and Development, no task too large or small


    Business Cards
    from $75
    Shipped within 48 hours, Full Color Printing


    Slides or Photos
    4x5" at $5
    Possibly the Lowest Price Online for Scitex Quality!

    Connecting MySQL Databases with Java Applications
    Java — Written by Steve Baldwin on March 7, 2010

    If you are having a hard time finding a *simple* as to why you are not getting anywhere, this should cut through it all in a few minutes. I am assuming that you are a programmer and have moderate knowledge, but even following these steps should have your MySQL accessible from your Java application in no time.

    For this, I’m using NetBeans (6.1) , but the same principles can be used in Eclipse. Since some of you may have already set up your database properly, I’ll save that to last.

    Mysql.java

    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import java.sql.Statement;
    import java.sql.ResultSet;
    
    public class Mysql {                                   // Class Declaration
    private Connection conn = null;
    private Statement st = null;
    private ResultSet rs = null;
    
    public Mysql(){                                     // Constructor Class
    try{
    System.out.println(”Attempting to add driver…”);
    Class.forName(”com.mysql.jdbc.Driver”).newInstance();  // Load the driver
    System.out.println(”Driver added successfully.”);
    }catch(Exception ex){
    System.out.println(”Exception: ” + ex.getMessage());
    }
    try{
    System.out.println(”Attempting to connect…”);
    conn = DriverManager.getConnection(
    “jdbc:mysql://YOUR_IP_ADDRESS:3306/YOUR_DATABASE_NAME”,
    “YOUR_MYSQL_USER”,”YOUR_MYSQL_USER_PASSWORD”);
    System.out.println(”Connection was made successfully.”);
    }catch(SQLException ex){ // Note - SQLException!
    System.out.println(”SQLException: ” + ex.getMessage());
    System.out.println(”SQLState: ” + ex.getSQLState());
    System.out.println(”VendorError: ” + ex.getErrorCode());
    }
    }
    

    That should do the trick on the code side, but now you have one very important step! You must make the driver available to your application. Simply copy the driver to your project folder and under the ‘Projects’ tab in NetBeans, add it to your libraries.

    To do this, find the location of the MySQL Connector/J driver. By clicking on the ‘Services’ tab, open Databases, open Drivers, and right click on MySQL (Connector/J driver), and finally select ‘Customize’. This will tell you the path. Mine was located at:

    C:\Program Files\NetBeans 6.1\ide9\modules\ext\mysql-connector-java-5.1.5-bin.jar

    Now that you have the tough part taken care of, you should be able to run the application above and get positive feedback.

    If you are getting driver connection errors, then you will have go through the steps above to add the driver jar to your project library.

    If you are getting MySQL connection errors, then you most likely have an issue with your MySQL setup:

    1. Make sure that the database name, user, and password are all correct. One easy step is to create a small PHP script to test the connection:

    db.php

    mysql_connect('HOST','DB_USER','DB_USER_PASS') or die('Connection failed!');

    2. If that script failed, then you haven’t set up your database access correctly. Recreate or create a new user and try the new access credentials with both scripts.

    3. If you still can’t get this, are you trying to access a database that isn’t ‘localhost’? Remember, most hosts will force you to add an exception to allow database access from an outside location. Make sure that the IP address of the application (on your computer or the server you are deploying to) is added to the allowable hosts.

    If none of this helps, you can stop trying to find the solution with your MySQL server and your application code as it probably is all good. Your problem probably lies elsewhere.

    Comments (0)
    Changing/Renaming Domain for Mailman under cPanel
    Linux, Hosting — Written by Steve Baldwin on February 3, 2010

    One weak link in cPanel is the integration with Mailman, the email list manager. If you are a reseller, a ’semi-dedicated’ or virtual dedicated, or dedicated server administrator, chances are you have changed a cPanel account from one domain to another. Unfortunately, after doing so, any Mailman lists will not be ported to the new domain. If the old domain is still in use, it might not affect anything, but if it is going away you have a problem.

    A solution is possible if you have root access. The simple way is to edit a list configuration variablele and leave the list name the same, but to be thorough, you can change the relevant folder names.

    The simple step:

    1. Log in to your server and gain root access.
    
    2. Navigate to the mailman folder:
    
    # cd /usr/local/cpanel/3rdparty/mailman
    
    3. Run a command to edit the list:
    
    # bin/withlist -l LISTNAME
    
    4. A different interface will come up, enter the following to see the current URL:
    
    >>> m.web_page_url
    ‘http://olddomain.tld/mailman/’
    
    5. Edit the URL with the following command:
    
    >>> m.web_page_url = ‘http://newdomain.tld/mailman/’
    
    6. Save the change:
    
    >>> m.Save()
    
    7. Close the editor, a the >>> prompt, end by hitting Ctrl-D:
    
    >>> [Ctrl-D]

    That is the simple method.

    To go further, check out the information on this page:
    http://wiki.list.org/pages/viewpage.action?pageId=4030617

    Comments (0)
    Migrating from PHP 4 to PHP 5
    Linux, Hosting — Written by Steve Baldwin on October 1, 2008

    When thinking of technology and the speed at which it becomes obsolete, it is amazing to consider that such technologies as Apache and PHP that were developed over a decade ago are still as reliable and commonly used as they are. Looking at the major releases, Apache 1.3.2 was released April 1998, and PHP 4.0.0 appeared in May, 2000. These have each had a number of updates straight up until now.

     Time moves forward, and in the computer world usually something comes to replace the old entirely. This has not been the case with these technologies, and they certainly are not going away any time soon unless the world implodes. What does come are new major releases, such as Apache 2.0 or Apache 2.2 and the series within the two branches of PHP 4 and PHP 5.

     PHP 5 was release in 2004, and although PHP 4 works for many, we have decided to abandon it in favor of running our hosting using Apache 2.x and PHP 5. What that means to our hosted customers is that some things may break. We have made sure that each account moved works as expected and found there are a few things that can help anyone doing the same.

    #1. Running PHP in HTML files.

    If you want to include PHP coding, but hide the fact it is PHP, you can place one line in your .htaccess file to make Apache aware it should parse PHP in the file type you specify. In PHP 5, it works the same, but the trick is that the name of the program running it changed slightly:

    PHP 4 :
    AddHandler application/x-httpd-php .html

    PHP 5:
    AddHandler application/x-httpd-php5 .html

     #2 To come later…

    Comments (0)
    Microsoft Word or Excel ‘Save As…’ Deathly Slow on Windows XP
    Windows — Written by Steve Baldwin on June 14, 2007

    While trying to save a file out of Excel, clicking the parent directory button would cause a delayed reponse taking about 20 seconds to a few minutes before the file requestor would update. I immediately thought, could a virus have slipped through? Is spyware causing this?

    After running some virus scans and running spyware searches, I determined that the problem only occured while accessing files. No other program had this delay, but it certainly existed and persisted even after a reboot. Going on the notion that it was file access related, I tried cleaning up my messy desktop. No help.

    Finally, after disabling all network connected devices the problem went away. The network device which caused these problems for me was an HP printer’s Card Reader slot. I never wanted this installed on my system, but HP insists that I share and enjoy all their bulky device software. No doubt that I will post a solution for that in the future.

     For shame Microsoft! Every other program seems to understand how to handle a disconnected device better using your own OS than your own programs!

    Comments (2)
    Disabling Automatic Address Bar Search in Internet Explorer 6
    Windows — Written by Steve Baldwin on

    Are you a web developer and want to see real responses to your URLs that you enter? Did you know that often times typing a wrong URL may direct you to what it thinks you want or even to a search engine? This is thanks to AutoSearch.

    AutoSearch using Google

    I’ve had this problem once before, solved it, and subsequently forgot what I had done when I needed to remember it later. The quick way is to edit your systems registry which stores all sorts of important settings and information which Windows and all your programs rely upon. It goes without saying, use extreme caution when editing your system registry!

     Solution:

    Step 1 - Click your Start bar and click on ‘Run…’

    Step 2 - Enter ‘Regedit’ and hit enter

    Registry Editor - Disabling AutoSearch 

    Step 3 - Navigate to HKEY_CURRENT_USER/Software/Microsoft/Internet Explorer/Main/

    Step 4 - Within the Main folder, double click on the REG_DWORD ‘AutoSearch’ and write this value down for safe keeping

    Step 5 - Change the value to 0 (zero) and hit enter

    Step 6 - Close RegEdit and Internet Explorer

    Now when you type google.c9m in your browser, you should receive the familiar ‘The page cannot be displayed’ error.

    The page cannot be displayed

    Comments (0)