Temas

Bueno, no se si postear esto en bases de datos o aquí.

Tengo una aplicación en C# que utiliza SQL Server Management. Como hago para importar esa base de datos a otra PC?? O tengo que instalar SQL Server Management en la PC en la que lo quiero usar y crear la base de datos nuevamente?

Saludos

Volví, les dejo este nuevo Crack Me (espero haber perfeccionado un poco en lo que es proteger aplicaciones .NET).

Download:

http://www.mediafire.com/download/a2hfsxhef6ssy84/Go+Crack+-+II.rar

Suerte!

Hola, estaría necesitando saber como evitar que programas me lean el código de un programa en C#. Tengo entendido que se hace con themida, pero no encuentro una versión full (si alguien me la facilita estaría muy agradecido).

Si me recomiendan otro programa mejor, se los agradecería.

Bueno, estoy haciendo un ejercicio para la facultad con pilas y secuencias (archivos de texto). El problema es que al pasar la pila a las funcionas para manejarla, me tira el siguiente error:

warning: passing argument 1 of 'pVacia' from incompatible pointer type [enabled by default]|
note: expected 'struct TPila *' but argument is of type 'struct TPila **'|
warning: passing argument 1 of 'pSacar' from incompatible pointer type [enabled by default]|
note: expected 'struct TPila *' but argument is of type 'struct TPila **'|
warning: passing argument 2 of 'pSacar' from incompatible pointer type [enabled by default]|
note: expected 'char *' but argument is of type 'char **'|
warning: passing argument 1 of 'pVacia' from incompatible pointer type [enabled by default]|
note: expected 'struct TPila *' but argument is of type 'struct TPila **'|
warning: passing argument 1 of 'sacarPila' from incompatible pointer type [enabled by default]|
note: expected 'char *' but argument is of type 'char **'|
warning: passing argument 3 of 'sacarPila' from incompatible pointer type [enabled by default]|
note: expected 'struct TPila *' but argument is of type 'struct TPila **'|
warning: passing argument 1 of 'pPoner' from incompatible pointer type [enabled by default]|
note: expected 'struct TPila *' but argument is of type 'struct TPila **'|
warning: passing argument 2 of 'pPoner' makes integer from pointer without a cast [enabled by default]|

Acá dejo el code y el header:

Código (c) [Seleccionar] Expandir

#include <stdio.h>
#include <stdlib.h>
#include "Pila.h"

#define MAX 50

void sacarPila(char *c, int n, TPila *p)
{
    int i = 0;

    while(!pVacia(&p) && i <= n)
    {
        pSacar(&p, &c);
        i += 1;
    }

    if(pVacia(&p))
    {
        printf("La pila esta vacia\n");
    }
}

void esDigito(char *c, TPila *p)
{
    int i = 10;

    switch(*c)
    {
        case '0': i = 0;
        case '1': i = 1;
        case '2': i = 2;
        case '3': i = 3;
        case '4': i = 4;
        case '5': i = 5;
        case '6': i = 6;
        case '7': i = 7;
        case '8': i = 8;
        case '9': i = 9;
    }

    if( i != 10)
    {
        sacarPila(&c, i, &p);
    }
    else
    {
        pPoner(&p, c);
    }
}

void vaciarPila(TPila *p)
{
    int i = 0;

    for(i=0; i<MAX; i++)
    {
        (*p).elem[i] = 0;
    }
}

int main()
{
    char c;
    TPila p;
    FILE *arch;
    arch = fopen("secuencia.txt", "r");

    vaciarPila(&p);
    if ( arch == NULL )
  {
    printf("- No se puede abrir el Archivo\n");
return 0;
}

    while((feof(arch) == 0) && !pLlena(&p))
    {
        c = fgetc(arch);
        esDigito(&c, &p);
    }

    while(!pLlena(&p))
    {
        pSacar(&p, &c);
        printf("%c", c);
    }
    return 0;
}

Código (c) [Seleccionar] Expandir

#include <stdlib.h>
#include <stdbool.h>

#define MAX 50

typedef struct Pila
{
    int elem[MAX];
    int cima;
}TPila;

bool pVacia(TPila *p)
{
    return (*p).cima == 0;
}

bool pLlena(TPila *p)
{
    return (*p).cima == MAX;
}

void pCrear(TPila *p)
{
    (*p).cima = 0;
}

void pPoner(TPila *p, char x)
{
    (*p).cima = (*p).cima + 1;
    (*p).elem[(*p).cima] = x;
}

void pSacar(TPila *p, char *c)
{
    *c = (*p).elem[(*p).cima];
    (*p).cima = (*p).cima + 1;
}

Bueno, mi idea era que cuando un usuario haga click derecho en una celda de un datagridview, se le abra un contextmenu con la opción para eliminar esa fila.

Pero al hacer click derecho, no aparece el menu. Acá el código que uso:

Código (csharp) [Seleccionar] Expandir

private void dataGridView1_MouseDown(object sender, MouseEventArgs e)
        {
            if (e.Button == MouseButtons.Right)
            {
                contextMenuStrip1.Show(MousePosition);
            }
        }

Bueno, tengo un datagridview, y lo quiero recorrer para pasar todo a un archivo .dat.

El problema llega cuando aprieto el boton para pasarlo todo, y me sale este error:

"Object reference not set to an instance of an object."

Busque info en internet para resolverlo, pero no encontre mucho. Alguien sabe como resolverlo?

Código (csharp) [Seleccionar] Expandir

            String line = "";
            StreamWriter writer = File.AppendText(path + "\\update.dat");
            String value = "";

            for (int rows = 0; rows < dataGridView1.Rows.Count - 1; rows++)
            {
                line = Base64Decode("BQ==") + Base64Decode("Aw==") + "1" + Base64Decode("BA==") + Base64Decode("Aw==");
                for (int col = 0; col < dataGridView1.Rows[rows].Cells.Count - 1; col++)
                {
                    line += col+1.ToString() + Base64Decode("Bg==");
                    value = dataGridView1.Rows[rows].Cells[col].Value.ToString();

                    if (value == "-")
                    {
                        line += Base64Decode("Bg==");
                    }
                    else
                    {
                        line += value + Base64Decode("Bg==");
                    }
                }

                line += Base64Decode("BA==");

                writer.WriteLine(line);

El error me lo tira acá:

Código (csharp) [Seleccionar] Expandir

value = dataGridView1.Rows[rows].Cells[col].Value.ToString();

Bueno, mi problema es medio raro. Simplemente coloque un checkbox, que al clickearlo se active el textBox.

Lo mas raro de todo esto, es que cuando clickeo en el, no se habilita el checkbox... Es como si no me tomara el check.

Código que uso:

Código (csharp) [Seleccionar] Expandir

public Form1()
       {
           InitializeComponent();
           textBox2.Enabled = false;

       }

       private void checkBox1_CheckedChanged(object sender, EventArgs e)
       {
           if (checkBox1.Checked == true)
           {
               textBox2.Enabled = true;
           }
           else
           {
               textBox2.Enabled = false;
           }
       }

[Descarga:]

Segundo CrackMe, diviértanse.

Descarga: https://mega.co.nz/#!dsdkXAZS!ZBjlqvyJ5ihrje4z1Bd5pgo3I_qprbwtbmzHKmlwMLI

[Link:]

Bueno, programo en C# (Aplicaciones comerciales mas que nada). Les voy a hacer CrackMe's mas que nada para aprender a proteger mis aplicaciones (a la mayoría las protejo con HWID con MySQL, pero nose que tan seguro es...).

Les dejo este pequeño y muy simple CrackMe, es muy, pero muy básico y extremadamente fácil (Para los que recién empiezan).

Simplemente tienen que ingresar un código y este les va a dar el mensaje si lo resolvieron o si no lo hicieron.

Link: http://www.mediafire.com/download/8qxk7pk84c3hr6j/CrackMe1.exe

Saludos

Hola, tengo un problema que no puedo solucionar. Me arroja error al tratar de pasar un registro como parámetro a un método.

Error:

Error   1   Incoherencia de accesibilidad: el tipo de parámetro 'registro' es menos accesible que el método 'método'

Código donde me arroja el error:

Código (csharp) [Seleccionar] Expandir

public partial class Form1 : Form
   {
       struct registro
       {
           public String nombre;
           public String apellido;
           public String dias;
           public String horario;
       }

public void ObtenerAlumno(registro alumno, int d)
       {
           char hora = ObtenerHorario(alumno.horario, alumno.dias, d);
           String horario = HoraACadena(hora);
           richTextBox1.Text = alumno.nombre + "   " + alumno.apellido + "   ";

       }

public Form1()
       {
           InitializeComponent();

           registro alumno;
           int nd = 0;
           ObtenerAlumno(alumno, nd);
       }

Hola, tengo un problema que no puedo solucionar. Me arroja error al tratar de pasar un registro como parámetro a un método.

Error:

Error   1   Incoherencia de accesibilidad: el tipo de parámetro 'registro' es menos accesible que el método 'método'

Código donde me arroja el error:

Código (csharp) [Seleccionar] Expandir

public partial class Form1 : Form
    {
        struct registro
        {
            public String nombre;
            public String apellido;
            public String dias;
            public String horario;
        }

public void ObtenerAlumno(registro alumno, int d)
        {
            char hora = ObtenerHorario(alumno.horario, alumno.dias, d);
            String horario = HoraACadena(hora);
            richTextBox1.Text = alumno.nombre + "   " + alumno.apellido + "   ";

        }

public Form1()
        {
            InitializeComponent();

            registro alumno;
            int nd = 0;
            ObtenerAlumno(alumno, nd);
        }

Hola, necesito saber que día es hoy. Ejemplo: Hoy es 31/03, necesitaría saber si es Lunes, Martes, Miercoles, jueves, etc.

Saludos

Hola, quería saber como dibujar las lineas que les voy a mostrar en la imagen. Por si no se entiende, son las lineas que envuelven los checkbox:

Hola, tengo una duda. Tengo 2 forms creados (Form1.cs y form2.cs). Como puedo trabajar con una variable en los 2? Es decir, quiero modificar una variable en el Form1, y modificarla tambien en el Form2.

Saludos

Hola, hoy tenía una duda. Quiero crear un registro dependiendo de cuantos campos escriba el usuario.

Ejemplo:

El usuario ingresa que quiere un registro de 5 enteros. Como hago para crear un registro dependiendo de lo que escribe el usuario?

Saludos

Bueno, tengo un TP para la universidad de un programa de registros y archivos.  Tengo varios problemas lógicos, pero el que mas me interesa es el que al terminar un procedimiento, por ejemplo Altas, directamente va a otra opcion sin ingresar nada, y recorre todos los procedimientos sin que yo se lo indique.

Acá les dejo el código que tengo hasta ahora:

Código (cpp) [Seleccionar] Expandir

#include <stdio.h>
#include <stdlib.h>

typedef struct
{
    int legajo;
    char CUIL[13];
    char nombre[31];
    char apellido[31];
    char sexo[3];
    char categoria[3];
    char obrasocial[51];
    float sueldo;
    char activo[2];
} registro;

/*****************************************************************************/

void CargarRegistro()
{
    registro reg;
    FILE *archivo;

    if((archivo = fopen("empleados.dat", "a")) == NULL)
{
printf("No se pudo abrir el archivo\n");
return;
}

    printf("Ingrese CUIL (Formato xx-xxxxxxxxxx): \n");
    scanf("%s", reg.CUIL);
    printf("Ingrese Nombre: \n");
    scanf("%s", reg.nombre);
    printf("Ingrese Apellido: \n");
    scanf("%s", reg.apellido);
    printf("Ingrese sexo: \n");
    scanf("%s", reg.sexo);
    printf("Ingrese categoria: \n");
    scanf("%s", reg.categoria);
    printf("Ingrese Obra social: \n");
    scanf("%s", reg.obrasocial);
    printf("Ingrese sueldo: \n");
    scanf("%f", &reg.sueldo);
    reg.activo[0] = '1';

    fwrite(&reg, sizeof(registro), 1, archivo);

    fclose(archivo);

    return;
}

void Alta(registro datos)
{
    int legajo = 0, encontrado = 0;
    FILE *archivo;

    printf("Ingrese un numero de legajo (0 para salir): \n");
    scanf("%d", &legajo);

    while(legajo != 0)
    {
        if((archivo = fopen("empleados.dat", "r")) == NULL)
        {
            printf("No se pudo abrir el archivo\n");
            return;
        }

        fread(&datos, sizeof(registro), 1, archivo);
        while((!feof(archivo)) && (encontrado == 0))
        {
            if(datos.legajo == legajo)
            {
                encontrado = 1;
                fclose(archivo);
            }

            fread(&datos, sizeof(registro), 1, archivo);
        }

        if(encontrado == 1)
        {
            printf("El legajo ya existe\n");
            return;
        }
        else
        {
            CargarRegistro();
        }

        return;
    }
}

/*****************************************************************************/

void Baja(registro datos)
{
    int legajo = 0;
    int confirmar = 0;
    FILE *archivo;

    printf("Ingrese un numero de legajo (0 para salir): \n");
    scanf("%d", &legajo);

    while(legajo != 0)
    {
        if((archivo = fopen("empleados.dat", "rt")) == NULL)
        {
            printf("No se pudo abrir el archivo\n");
            return;
        }

        fread(&datos, sizeof(registro), 1, archivo);
        while(!feof(archivo))
        {
            if((datos.legajo == legajo) && (datos.activo[0] == '1'))
            {
                printf("Esta seguro que desea dar de baja el registro?\n[ 1 ] - Si\n[ 2 ] - No\n");
                scanf("%d", &confirmar);
                while((confirmar != 0) && (confirmar != 1))
                {
                    printf("Opcion incorrecta. Esta seguro que desea dar de baja el registro?\n[ 1 ] - Si\n[ 2 ] - No\n");
                    scanf("%d", &confirmar);
                }

                switch(confirmar)
                {
                    case 1:
                        datos.activo[0] = '0';
                        fwrite(&datos, sizeof(registro), 1, archivo);
                        fclose(archivo);
                        return;

                    case 2: return;
                }

            }

            fread(&datos, sizeof(registro), 1, archivo);
        }

        fclose(archivo);

    }
}

/*****************************************************************************/

int OpcionModif(registro reg, int x)
{
    printf("Datos del empleado a modificar:\n");
    printf("%d\n", reg.legajo);
    printf("%s\n", reg.CUIL);
    printf("%s\n", reg.nombre);
    printf("%s\n", reg.apellido);
    printf("%s\n", reg.sexo);
    printf("%s\n", reg.categoria);
    printf("%s\n", reg.obrasocial);
    printf("%f\n", reg.sueldo);
    printf("%s\n", reg.activo);

    printf("Elija que dato desea modificar\n");
    printf("[ 1 ] - Sexo\n[ 2 ] - Categoria\n[ 3 ] - Obra social\n[ 4 ] - Sueldo\nIngrese cualquier otro numero para salir\n");
    scanf("%d", &x);

    while( (x < 0) && (x > 5) )
    {
        printf("Elija que dato desea modificar\n");
        printf("[ 1 ] - Sexo\n[ 2 ] - Categoria\n[ 3 ] - Obra social\n[ 4 ] - Sueldo\nIngrese cualquier otro numero para salir\n");
        scanf("%d", &x);
    }

    return x;
}

void Modificar(registro datos)
{
    int legajo = 0, opc = 0;
    FILE *archivo;

    printf("Ingrese un numero de legajo (0 para salir): \n");
    scanf("%d", &legajo);

    while(legajo != 0)
    {
        if((archivo = fopen("empleados.dat", "r")) == NULL)
        {
            printf("No se pudo abrir el archivo\n");
            return;
        }

        fread(&datos, sizeof(registro), 1, archivo);

        while(!feof(archivo))
        {
            if((datos.legajo == legajo) && (datos.activo[0] = '1'))
            {
                opc = OpcionModif(datos, opc);

                switch(opc)
                {
                    case 1:
                        printf("Ingrese el sexo:\n");
                        scanf("%s", datos.sexo);
                    case 2:
                        printf("Ingrese categoria:\n");
                        scanf("%s", datos.categoria);
                    case 3:
                        printf("Ingrese Obra Social:\n");
                        scanf("%s", datos.obrasocial);
                    case 4:
                        printf("Ingrese sueldo:\n");
                        scanf("%f", &datos.sueldo);
                }

                fwrite(&datos, sizeof(registro), 1, archivo);
                fclose(archivo);
                return;

            }
            fread(&datos, sizeof(registro), 1, archivo);
        }


    }
    printf("El legajo no existe\n");
}

/*****************************************************************************/

int main()
{
    int opcmenu = 1;
    registro empleados;

    while((opcmenu > 0) && (opcmenu < 7))
    {
        printf("Seleccione entre una de las opciones disponibles\n");
        printf("[ 1 ] - Altas\n[ 2 ] - Bajas\n[ 3 ] - Modificacion\n[ 4 ] - Listado\n[ 5 ] - Aumentar salario\n[ 6 ] - Buscar por legajo\n[ 7 ] - Salir\n");
        scanf("%d", &opcmenu);

        switch(opcmenu)
        {
            case 1: Alta(empleados);
            case 2: Baja(empleados);
            case 3: Modificar(empleados);
            case 7: return -1;

        }
    }

    return 0;
}

Eso mismo, me surgió esta duda escuchando sobre un secuestro en el que los secuestradores dicen que "interfirieron" el numero del celular del hijo, osea las victimas llamaban al celular del secuestrado y lo atendían ellos (Cuando en realidad el hijo no estaba secuestrado). Es posible interferir una señal sin ayuda de alguien interno en una empresa de telefonía?

Hola, tengo un problema al leer un archivo en el que guardo un registro. El problema es que me muestra varios signos y numeros que yo no ingrese. Les paso a dejar las funciones en donde escribo y leo el fichero (Paso el fichero y el archivo por referencia):

Código (cpp) [Seleccionar] Expandir

void DarDeAlta(registro *clientes, int n, FILE **db)
{
   int a = 1;

   while (a == 1)
   {
       printf("Ingrese un nombre: ");
       scanf("%s", ((*clientes).nombre));
       fprintf(*db, "%s\n", (*clientes).nombre);

       printf("Ingrese su apellido: ");
       scanf("%s", ((*clientes).apellido));
       fprintf(*db, "%s\n", (*clientes).apellido);

       printf("Ingrese el telefono: ");
       scanf("%d", &(*clientes).telefono);
       fprintf(*db, "%d\n", (*clientes).telefono);

       printf("Ingrese la edad: ");
       scanf("%d", &(*clientes).edad);
       fprintf(*db, "%d\n", (*clientes).edad);

       Seguir(&a);
   }

   fclose(*db);
   return;
}

void MostrarClientes(registro *clientes, int n, FILE **db)
{
   *db = fopen("clientes.dat", "r");
   if(*db == NULL)
   {
       printf("El archivo no existe\n");
   }
   else{
       while(feof(*db) == 0)
       {
           fgets((*clientes).apellido, 30, *db);
           printf("%s\n", (*clientes).nombre);

           fgets((*clientes).apellido, 30, *db);
           printf("%s\n", (*clientes).apellido);

           fscanf(*db, "%d", &(*clientes).telefono);
           printf("%d\n", (*clientes).telefono);

           fscanf(*db, "%d", &(*clientes).edad);
           printf("%d\n", (*clientes).edad);
       }
   }

   fclose(*db);
   return;
}

Buenas, mi duda es como pasar un registro por referencia a una función.                                                                                                                                                                                                                                                                                          

Quería saber si pasa algo si uso el OllyDbg en windows 64 bits. Caso contrario, si me pueden dejar un programa que sea similar para empezar con ingeniería inversa, debido a que todos recomiendan el Olly pero tengo w64.

Saludos

Bueno, tengo este problema. Hice un programa de un sistema bancario, pero me crashea al llegar aquí (Eh probado sacando esta parte y no crashea, por eso llegue a esta conclusión):

Código (c) [Seleccionar] Expandir

suc1 = tran/sucursal[0];
    suc2 = tran/sucursal[1];
    suc3 = tran/sucursal[2];

Aquí las variables:

Código (c) [Seleccionar] Expandir

int sucursal[3];
int suc1, suc2, suc3;
int tran;

Recalco que la primera parte esta en una función, es decir, la parte de las divisiones. Saludos!

Bueno, mi problema es que en esta sentencia se queda echo un loop, no importa si pongo S o N, repite infinitas veces lo mismo y no sale de ahí:

Código (cpp) [Seleccionar] Expandir

while((conf != 'S') || (conf != 'N') || (conf != 's') || (conf != 'n'))
   {
       printf("Desea realizar una operacion? - S/N\n");
       scanf("%c", &conf);
   }

[País(es):]

País(es): Estados Unidos / Reino Unido
Año: 2013
Género: Ciencia ficción / Thriller
Duración: 91 minutos
Idioma(s): Inglés
Protagonistas: Sandra Bullock / George Clooney



Sinopsis

La doctora Ryan Stone es una brillante ingeniero médica en su primera misión en un transbordador, junto con el veterano astronauta Matt Kowalsky (Clooney), al mando de su último vuelo antes de retirarse. Sin embargo, en una caminata espacial rutinaria, surge el desastre: el transbordador queda destruido, dejando a Stone y Kowalsky completamente solos, atados el uno al otro en una espiral hacia la oscuridad.

El silencio ensordecedor les dice que han perdido cualquier vínculo con la Tierra ... y cualquier posibilidad de rescate. A medida que el miedo se convierte en pánico, cada bocanada de aire carcome el poco oxígeno que queda. Pero la única forma de volver a casa puede que esté en la aterradora inmensidad del espacio.



Trailer

[youtube=425,350]https://www.youtube.com/watch?v=QK8O8L2b7vs[/youtube]



Descarga:

https://mega.co.nz/#!J591GJ7D!-AKuuKsdwACsJ91kD2mCZyKGoojToc3h2SnUrQZiXZI

Tengo una pregunta, se pueden postear torrents en esta sección? http://foro.elhacker.net/series_peliculas_musica_juegos_programas-b80.0/

No encontre ninguna regla, pero por las dudas pregunto, ya que no quiero ser sancionado.

Hola, quisiera saber como almacenar todo esto:

Código (cpp) [Seleccionar] Expandir

printf("%c%d%c%d%c%d%c%d%c%d \n\n", letra[0], numero[0], letra[1], numero[1], letra[2], numero[2], letra[3], numero[3], letra[4], numero[4]);

En una sola cadena o palabra. Gracias!

Bueno, mi problema es que el programa me crashea al poner 1 para que genere el codigo. El code no está terminado pero no puedo terminar de resolver eso:

Código (cpp) [Seleccionar] Expandir

int main()
{
   int a, i, j, k, f;
   int b[10] = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9};
   char c[] = {'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', 'x', 'y', 'z', '\0'};
   printf("==========================\n== Generador de codigos ==\n==========================\n\n* Ingrese 1 si quiere generar un codigo\n");
   scanf("%i", &a);

   char letra[5];

   if (!(a = 1))
   {
       printf("Necesitas ingresar el numero 1 para generar un codigo\n");
   }

   if (a = 1)
   {
       printf("En breve se generara tu codigo\n");

       for(j=0; j=5; j++)
       {
           i++;
           k = 0;
           k = 1 + rand() % 23;
           c[k] = letra[i];
       }
   }

   return 0;
}

Hola! Quería saber como poder utilizar el sockets practical http://foro.elhacker.net/programacion_cc/practicalsockets_c_sockets_asi_de_facil-t205821.0.html, es decir, como instalo los archivos de cabecera y la librería para poder empezar a usarlas. Utilizo Code::Blocks

Bueno, estaba practicando con C antes de empezar la facultad, y quice hacer un programa en el cual se le pide al usuario que ingrese la cantidad de productos que quiere guardar en el programa y que luego se le pida escribir los nombres de los productos. Todo iba bien hasta la parte del for, en el cual solo puedo ingresar un producto y enseguida finaliza el programa. Nosé que es lo que hago mal:

Código (c) [Seleccionar] Expandir

#include <stdio.h>
#include <stdlib.h>

int main()
{
    int i, j, x;
    printf("Ingrese el numero de productos que quiere cargar:\n");
    scanf("%d", &i);
    x = 0;

    char productos[i];

    for(j; j==i; j++);
    {
        x++;
        printf("Ingrese el nombre de su producto:\n");
        scanf("%s", &productos[x]);
    }

    return 0;
}

Bueno, utilizo el Code::Blocks y descargue el conector de MySQL para C++ para poder trabajar. Pero no sé como puedo incluir esa librería en el compilador para poder utilizar sus funciones. Descomprimi el .zip que me vino, y supuestamente tengo que utilizar los archivos:

mysqlcppconn.dll
mysqlcppconn.lib
mysqlcppconn-static.lib

Alguien sabe como puedo incluir las librerías para empezar a usarlas?

Hola, una pregunta, no logro encontrar las librerías para programar con MySQL en Code::Blocks. ¿Alguien me puede facilitar las librerías y/o archivos que necesito para programar en MySQL y que me compile bien?

Hola, el problema que tengo es que quiero hacer como un Creador de Figuras que al escribir el nombre de la figura se imprima. Utilize la sentencia IF, al compilarlo no me tira errores, pero cuando escribo cuadrado no me imprime el cuadrado.

Código [Seleccionar] Expandir

#include <stdio.h>
#include <stdlib.h>

int main()
{
    char peticion, cuadrado, triangulo, rectangulo;
    printf("Ingrese la figura que quiera representar\n Elija entre: Cuadrado, Triangulo y un Rectangulo\n\n");
    scanf("%s", &peticion);

    if (peticion == cuadrado)
        printf("******\n*    *\n*    *\n*    *\n*    *\n*    *\n*    *\n******");


    return 0;
}

Bueno, había echo un programa con interfaz gráfica, pero al colocarle MySQL me lo dejo de ejecutar y me tira todo esto en consola...

Código (c) [Seleccionar] Expandir

<ConnectionProperties>
<PropertyCategory name="Connection/Authentication">
  <Property name="user" required="No" default="" sortOrder="-2147483647" since="all versions">
    The user to connect as
  </Property>
  <Property name="password" required="No" default="" sortOrder="-2147483646" since="all versions">
    The password to use when connecting
  </Property>
  <Property name="socketFactory" required="No" default="com.mysql.jdbc.StandardSocketFactory" sortOrder="4" since="3.0.3">
    The name of the class that the driver should use for creating socket connections to the server. This class must implement the interface 'com.mysql.jdbc.SocketFactory' and have public no-args constructor.
  </Property>
  <Property name="connectTimeout" required="No" default="0" sortOrder="9" since="3.0.1">
    Timeout for socket connect (in milliseconds), with 0 being no timeout. Only works on JDK-1.4 or newer. Defaults to '0'.
  </Property>
  <Property name="socketTimeout" required="No" default="0" sortOrder="10" since="3.0.1">
    Timeout on network socket operations (0, the default means no timeout).
  </Property>
  <Property name="connectionLifecycleInterceptors" required="No" default="" sortOrder="2147483647" since="5.1.4">
    A comma-delimited list of classes that implement "com.mysql.jdbc.ConnectionLifecycleInterceptor" that should notified of connection lifecycle events (creation, destruction, commit, rollback, setCatalog and setAutoCommit) and potentially alter the execution of these commands. ConnectionLifecycleInterceptors are "stackable", more than one interceptor may be specified via the configuration property as a comma-delimited list, with the interceptors executed in order from left to right.
  </Property>
  <Property name="useConfigs" required="No" default="" sortOrder="2147483647" since="3.1.5">
    Load the comma-delimited list of configuration properties before parsing the URL or applying user-specified properties. These configurations are explained in the 'Configurations' of the documentation.
  </Property>
  <Property name="authenticationPlugins" required="No" default="" sortOrder="alpha" since="5.1.19">
    Comma-delimited list of classes that implement com.mysql.jdbc.AuthenticationPlugin and which will be used for authentication unless disabled by "disabledAuthenticationPlugins" property.
  </Property>
  <Property name="defaultAuthenticationPlugin" required="No" default="com.mysql.jdbc.authentication.MysqlNativePasswordPlugin" sortOrder="alpha" since="5.1.19">
    Name of a class implementing com.mysql.jdbc.AuthenticationPlugin which will be used as the default authentication plugin (see below). It is an error to use a class which is not listed in "authenticationPlugins" nor it is one of the built-in plugins. It is an error to set as default a plugin which was disabled with "disabledAuthenticationPlugins" property. It is an error to set this value to null or the empty string (i.e. there must be at least a valid default authentication plugin specified for the connection, meeting all constraints listed above).
  </Property>
  <Property name="disabledAuthenticationPlugins" required="No" default="" sortOrder="alpha" since="5.1.19">
    Comma-delimited list of classes implementing com.mysql.jdbc.AuthenticationPlugin or mechanisms, i.e. "mysql_native_password". The authentication plugins or mechanisms listed will not be used for authentication which will fail if it requires one of them. It is an error to disable the default authentication plugin (either the one named by "defaultAuthenticationPlugin" property or the hard-coded one if "defaultAuthenticationPlugin" property is not set).
  </Property>
  <Property name="disconnectOnExpiredPasswords" required="No" default="true" sortOrder="alpha" since="5.1.23">
    If "disconnectOnExpiredPasswords" is set to "false" and password is expired then server enters "sandbox" mode and sends ERR(08001, ER_MUST_CHANGE_PASSWORD) for all commands that are not needed to set a new password until a new password is set.
  </Property>
  <Property name="interactiveClient" required="No" default="false" sortOrder="alpha" since="3.1.0">
    Set the CLIENT_INTERACTIVE flag, which tells MySQL to timeout connections based on INTERACTIVE_TIMEOUT instead of WAIT_TIMEOUT
  </Property>
  <Property name="localSocketAddress" required="No" default="" sortOrder="alpha" since="5.0.5">
    Hostname or IP address given to explicitly configure the interface that the driver will bind the client side of the TCP/IP connection to when connecting.
  </Property>
  <Property name="propertiesTransform" required="No" default="" sortOrder="alpha" since="3.1.4">
    An implementation of com.mysql.jdbc.ConnectionPropertiesTransform that the driver will use to modify URL properties passed to the driver before attempting a connection
  </Property>
  <Property name="useCompression" required="No" default="false" sortOrder="alpha" since="3.0.17">
    Use zlib compression when communicating with the server (true/false)? Defaults to 'false'.
  </Property>
</PropertyCategory>
<PropertyCategory name="Networking">
  <Property name="maxAllowedPacket" required="No" default="-1" sortOrder="alpha" since="5.1.8">
    Maximum allowed packet size to send to server. If not set, the value of system variable 'max_allowed_packet' will be used to initialize this upon connecting. This value will not take effect if set larger than the value of 'max_allowed_packet'.
  </Property>
  <Property name="tcpKeepAlive" required="No" default="true" sortOrder="alpha" since="5.0.7">
    If connecting using TCP/IP, should the driver set SO_KEEPALIVE?
  </Property>
  <Property name="tcpNoDelay" required="No" default="true" sortOrder="alpha" since="5.0.7">
    If connecting using TCP/IP, should the driver set SO_TCP_NODELAY (disabling the Nagle Algorithm)?
  </Property>
  <Property name="tcpRcvBuf" required="No" default="0" sortOrder="alpha" since="5.0.7">
    If connecting using TCP/IP, should the driver set SO_RCV_BUF to the given value? The default value of '0', means use the platform default value for this property)
  </Property>
  <Property name="tcpSndBuf" required="No" default="0" sortOrder="alpha" since="5.0.7">
    If connecting using TCP/IP, should the driver set SO_SND_BUF to the given value? The default value of '0', means use the platform default value for this property)
  </Property>
  <Property name="tcpTrafficClass" required="No" default="0" sortOrder="alpha" since="5.0.7">
    If connecting using TCP/IP, should the driver set traffic class or type-of-service fields ?See the documentation for java.net.Socket.setTrafficClass() for more information.
  </Property>
</PropertyCategory>
<PropertyCategory name="High Availability and Clustering">
  <Property name="autoReconnect" required="No" default="false" sortOrder="0" since="1.1">
    Should the driver try to re-establish stale and/or dead connections? If enabled the driver will throw an exception for a queries issued on a stale or dead connection, which belong to the current transaction, but will attempt reconnect before the next query issued on the connection in a new transaction. The use of this feature is not recommended, because it has side effects related to session state and data consistency when applications don't handle SQLExceptions properly, and is only designed to be used when you are unable to configure your application to handle SQLExceptions resulting from dead and stale connections properly. Alternatively, as a last option, investigate setting the MySQL server variable "wait_timeout" to a high value, rather than the default of 8 hours.
  </Property>
  <Property name="autoReconnectForPools" required="No" default="false" sortOrder="1" since="3.1.3">
    Use a reconnection strategy appropriate for connection pools (defaults to 'false')
  </Property>
  <Property name="failOverReadOnly" required="No" default="true" sortOrder="2" since="3.0.12">
    When failing over in autoReconnect mode, should the connection be set to 'read-only'?
  </Property>
  <Property name="maxReconnects" required="No" default="3" sortOrder="4" since="1.1">
    Maximum number of reconnects to attempt if autoReconnect is true, default is '3'.
  </Property>
  <Property name="reconnectAtTxEnd" required="No" default="false" sortOrder="4" since="3.0.10">
    If autoReconnect is set to true, should the driver attempt reconnections at the end of every transaction?
  </Property>
  <Property name="retriesAllDown" required="No" default="120" sortOrder="4" since="5.1.6">
    When using loadbalancing, the number of times the driver should cycle through available hosts, attempting to connect.  Between cycles, the driver will pause for 250ms if no servers are available.
  </Property>
  <Property name="initialTimeout" required="No" default="2" sortOrder="5" since="1.1">
    If autoReconnect is enabled, the initial time to wait between re-connect attempts (in seconds, defaults to '2').
  </Property>
  <Property name="roundRobinLoadBalance" required="No" default="false" sortOrder="5" since="3.1.2">
    When autoReconnect is enabled, and failoverReadonly is false, should we pick hosts to connect to on a round-robin basis?
  </Property>
  <Property name="queriesBeforeRetryMaster" required="No" default="50" sortOrder="7" since="3.0.2">
    Number of queries to issue before falling back to master when failed over (when using multi-host failover). Whichever condition is met first, 'queriesBeforeRetryMaster' or 'secondsBeforeRetryMaster' will cause an attempt to be made to reconnect to the master. Defaults to 50.
  </Property>
  <Property name="secondsBeforeRetryMaster" required="No" default="30" sortOrder="8" since="3.0.2">
    How long should the driver wait, when failed over, before attempting
  </Property>
  <Property name="selfDestructOnPingMaxOperations" required="No" default="0" sortOrder="2147483647" since="5.1.6">
    =If set to a non-zero value, the driver will report close the connection and report failure when Connection.ping() or Connection.isValid(int) is called if the connection's count of commands sent to the server exceeds this value.
  </Property>
  <Property name="selfDestructOnPingSecondsLifetime" required="No" default="0" sortOrder="2147483647" since="5.1.6">
    If set to a non-zero value, the driver will report close the connection and report failure when Connection.ping() or Connection.isValid(int) is called if the connection's lifetime exceeds this value.
  </Property>
  <Property name="resourceId" required="No" default="" sortOrder="alpha" since="5.0.1">
    A globally unique name that identifies the resource that this datasource or connection is connected to, used for XAResource.isSameRM() when the driver can't determine this value based on hostnames used in the URL
  </Property>
</PropertyCategory>
<PropertyCategory name="Security">
  <Property name="allowMultiQueries" required="No" default="false" sortOrder="1" since="3.1.1">
    Allow the use of ';' to delimit multiple queries during one statement (true/false), defaults to 'false', and does not affect the addBatch() and executeBatch() methods, which instead rely on rewriteBatchStatements.
  </Property>
  <Property name="useSSL" required="No" default="false" sortOrder="2" since="3.0.2">
    Use SSL when communicating with the server (true/false), defaults to 'false'
  </Property>
  <Property name="requireSSL" required="No" default="false" sortOrder="3" since="3.1.0">
    Require SSL connection if useSSL=true? (defaults to 'false').
  </Property>
  <Property name="verifyServerCertificate" required="No" default="true" sortOrder="4" since="5.1.6">
    If "useSSL" is set to "true", should the driver verify the server's certificate? When using this feature, the keystore parameters should be specified by the "clientCertificateKeyStore*" properties, rather than system properties.
  </Property>
  <Property name="clientCertificateKeyStoreUrl" required="No" default="" sortOrder="5" since="5.1.0">
    URL to the client certificate KeyStore (if not specified, use defaults)
  </Property>
  <Property name="clientCertificateKeyStoreType" required="No" default="JKS" sortOrder="6" since="5.1.0">
    KeyStore type for client certificates (NULL or empty means use the default, which is "JKS". Standard keystore types supported by the JVM are "JKS" and "PKCS12", your environment may have more available depending on what security products are installed and available to the JVM.
  </Property>
  <Property name="clientCertificateKeyStorePassword" required="No" default="" sortOrder="7" since="5.1.0">
    Password for the client certificates KeyStore
  </Property>
  <Property name="trustCertificateKeyStoreUrl" required="No" default="" sortOrder="8" since="5.1.0">
    URL to the trusted root certificate KeyStore (if not specified, use defaults)
  </Property>
  <Property name="trustCertificateKeyStoreType" required="No" default="JKS" sortOrder="9" since="5.1.0">
    KeyStore type for trusted root certificates (NULL or empty means use the default, which is "JKS". Standard keystore types supported by the JVM are "JKS" and "PKCS12", your environment may have more available depending on what security products are installed and available to the JVM.
  </Property>
  <Property name="trustCertificateKeyStorePassword" required="No" default="" sortOrder="10" since="5.1.0">
    Password for the trusted root certificates KeyStore
  </Property>
  <Property name="allowLoadLocalInfile" required="No" default="true" sortOrder="2147483647" since="3.0.3">
    Should the driver allow use of 'LOAD DATA LOCAL INFILE...' (defaults to 'true').
  </Property>
  <Property name="allowUrlInLocalInfile" required="No" default="false" sortOrder="2147483647" since="3.1.4">
    Should the driver allow URLs in 'LOAD DATA LOCAL INFILE' statements?
  </Property>
  <Property name="paranoid" required="No" default="false" sortOrder="alpha" since="3.0.1">
    Take measures to prevent exposure sensitive information in error messages and clear data structures holding sensitive data when possible? (defaults to 'false')
  </Property>
  <Property name="passwordCharacterEncoding" required="No" default="" sortOrder="alpha" since="5.1.7">
    What character encoding is used for passwords? Leaving this set to the default value (null), uses the platform character set, which works for ISO8859_1 (i.e. "latin1") passwords. For passwords in other character encodings, the encoding will have to be specified with this property, as it's not possible for the driver to auto-detect this.
  </Property>
</PropertyCategory>
<PropertyCategory name="Performance Extensions">
  <Property name="callableStmtCacheSize" required="No" default="100" sortOrder="5" since="3.1.2">
    If 'cacheCallableStmts' is enabled, how many callable statements should be cached?
  </Property>
  <Property name="metadataCacheSize" required="No" default="50" sortOrder="5" since="3.1.1">
    The number of queries to cache ResultSetMetadata for if cacheResultSetMetaData is set to 'true' (default 50)
  </Property>
  <Property name="useLocalSessionState" required="No" default="false" sortOrder="5" since="3.1.7">
    Should the driver refer to the internal values of autocommit and transaction isolation that are set by Connection.setAutoCommit() and Connection.setTransactionIsolation() and transaction state as maintained by the protocol, rather than querying the database or blindly sending commands to the database for commit() or rollback() method calls?
  </Property>
  <Property name="useLocalTransactionState" required="No" default="false" sortOrder="6" since="5.1.7">
    Should the driver use the in-transaction state provided by the MySQL protocol to determine if a commit() or rollback() should actually be sent to the database?
  </Property>
  <Property name="prepStmtCacheSize" required="No" default="25" sortOrder="10" since="3.0.10">
    If prepared statement caching is enabled, how many prepared statements should be cached?
  </Property>
  <Property name="prepStmtCacheSqlLimit" required="No" default="256" sortOrder="11" since="3.0.10">
    If prepared statement caching is enabled, what's the largest SQL the driver will cache the parsing for?
  </Property>
  <Property name="parseInfoCacheFactory" required="No" default="com.mysql.jdbc.PerConnectionLRUFactory" sortOrder="12" since="5.1.1">
    Name of a class implementing com.mysql.jdbc.CacheAdapterFactory, which will be used to create caches for the parsed representation of client-side prepared statements.
  </Property>
  <Property name="serverConfigCacheFactory" required="No" default="com.mysql.jdbc.PerVmServerConfigCacheFactory" sortOrder="12" since="5.1.1">
    Name of a class implementing com.mysql.jdbc.CacheAdapterFactory&lt;String, Map&lt;String, String&gt;&gt;, which will be used to create caches for MySQL server configuration values
  </Property>
  <Property name="alwaysSendSetIsolation" required="No" default="true" sortOrder="2147483647" since="3.1.7">
    Should the driver always communicate with the database when Connection.setTransactionIsolation() is called? If set to false, the driver will only communicate with the database when the requested transaction isolation is different than the whichever is newer, the last value that was set via Connection.setTransactionIsolation(), or the value that was read from the server when the connection was established.  Note that useLocalSessionState=true will force the same behavior as alwaysSendSetIsolation=false, regardless of how alwaysSendSetIsolation is set.
  </Property>
  <Property name="maintainTimeStats" required="No" default="true" sortOrder="2147483647" since="3.1.9">
    Should the driver maintain various internal timers to enable idle time calculations as well as more verbose error messages when the connection to the server fails? Setting this property to false removes at least two calls to System.getCurrentTimeMillis() per query.
  </Property>
  <Property name="useCursorFetch" required="No" default="false" sortOrder="2147483647" since="5.0.0">
    If connected to MySQL &gt; 5.0.2, and setFetchSize() &gt; 0 on a statement, should that statement use cursor-based fetching to retrieve rows?
  </Property>
  <Property name="blobSendChunkSize" required="No" default="1048576" sortOrder="alpha" since="3.1.9">
    Chunk to use when sending BLOB/CLOBs via ServerPreparedStatements
  </Property>
  <Property name="cacheCallableStmts" required="No" default="false" sortOrder="alpha" since="3.1.2">
    Should the driver cache the parsing stage of CallableStatements
  </Property>
  <Property name="cachePrepStmts" required="No" default="false" sortOrder="alpha" since="3.0.10">
    Should the driver cache the parsing stage of PreparedStatements of client-side prepared statements, the "check" for suitability of server-side prepared and server-side prepared statements themselves?
  </Property>
  <Property name="cacheResultSetMetadata" required="No" default="false" sortOrder="alpha" since="3.1.1">
    Should the driver cache ResultSetMetaData for Statements and PreparedStatements? (Req. JDK-1.4+, true/false, default 'false')
  </Property>
  <Property name="cacheServerConfiguration" required="No" default="false" sortOrder="alpha" since="3.1.5">
    Should the driver cache the results of 'SHOW VARIABLES' and 'SHOW COLLATION' on a per-URL basis?
  </Property>
  <Property name="defaultFetchSize" required="No" default="0" sortOrder="alpha" since="3.1.9">
    The driver will call setFetchSize(n) with this value on all newly-created Statements
  </Property>
  <Property name="dontTrackOpenResources" required="No" default="false" sortOrder="alpha" since="3.1.7">
    The JDBC specification requires the driver to automatically track and close resources, however if your application doesn't do a good job of explicitly calling close() on statements or result sets, this can cause memory leakage. Setting this property to true relaxes this constraint, and can be more memory efficient for some applications.
  </Property>
  <Property name="dynamicCalendars" required="No" default="false" sortOrder="alpha" since="3.1.5">
    Should the driver retrieve the default calendar when required, or cache it per connection/session?
  </Property>
  <Property name="elideSetAutoCommits" required="No" default="false" sortOrder="alpha" since="3.1.3">
    If using MySQL-4.1 or newer, should the driver only issue 'set autocommit=n' queries when the server's state doesn't match the requested state by Connection.setAutoCommit(boolean)?
  </Property>
  <Property name="enableQueryTimeouts" required="No" default="true" sortOrder="alpha" since="5.0.6">
    When enabled, query timeouts set via Statement.setQueryTimeout() use a shared java.util.Timer instance for scheduling. Even if the timeout doesn't expire before the query is processed, there will be memory used by the TimerTask for the given timeout which won't be reclaimed until the time the timeout would have expired if it hadn't been cancelled by the driver. High-load environments might want to consider disabling this functionality.
  </Property>
  <Property name="holdResultsOpenOverStatementClose" required="No" default="false" sortOrder="alpha" since="3.1.7">
    Should the driver close result sets on Statement.close() as required by the JDBC specification?
  </Property>
  <Property name="largeRowSizeThreshold" required="No" default="2048" sortOrder="alpha" since="5.1.1">
    What size result set row should the JDBC driver consider "large", and thus use a more memory-efficient way of representing the row internally?
  </Property>
  <Property name="loadBalanceStrategy" required="No" default="random" sortOrder="alpha" since="5.0.6">
    If using a load-balanced connection to connect to SQL nodes in a MySQL Cluster/NDB configuration (by using the URL prefix "jdbc:mysql:loadbalance://"), which load balancing algorithm should the driver use: (1) "random" - the driver will pick a random host for each request. This tends to work better than round-robin, as the randomness will somewhat account for spreading loads where requests vary in response time, while round-robin can sometimes lead to overloaded nodes if there are variations in response times across the workload. (2) "bestResponseTime" - the driver will route the request to the host that had the best response time for the previous transaction.
  </Property>
  <Property name="locatorFetchBufferSize" required="No" default="1048576" sortOrder="alpha" since="3.2.1">
    If 'emulateLocators' is configured to 'true', what size buffer should be used when fetching BLOB data for getBinaryInputStream?
  </Property>
  <Property name="rewriteBatchedStatements" required="No" default="false" sortOrder="alpha" since="3.1.13">
    Should the driver use multiqueries (irregardless of the setting of "allowMultiQueries") as well as rewriting of prepared statements for INSERT into multi-value inserts when executeBatch() is called? Notice that this has the potential for SQL injection if using plain java.sql.Statements and your code doesn't sanitize input correctly. Notice that for prepared statements, server-side prepared statements can not currently take advantage of this rewrite option, and that if you don't specify stream lengths when using PreparedStatement.set*Stream(), the driver won't be able to determine the optimum number of parameters per batch and you might receive an error from the driver that the resultant packet is too large. Statement.getGeneratedKeys() for these rewritten statements only works when the entire batch includes INSERT statements.
  </Property>
  <Property name="useDirectRowUnpack" required="No" default="true" sortOrder="alpha" since="5.1.1">
    Use newer result set row unpacking code that skips a copy from network buffers  to a MySQL packet instance and instead reads directly into the result set row data buffers.
  </Property>
  <Property name="useDynamicCharsetInfo" required="No" default="true" sortOrder="alpha" since="5.0.6">
    Should the driver use a per-connection cache of character set information queried from the server when necessary, or use a built-in static mapping that is more efficient, but isn't aware of custom character sets or character sets implemented after the release of the JDBC driver?
  </Property>
  <Property name="useFastDateParsing" required="No" default="true" sortOrder="alpha" since="5.0.5">
    Use internal String->Date/Time/Timestamp conversion routines to avoid excessive object creation?
  </Property>
  <Property name="useFastIntParsing" required="No" default="true" sortOrder="alpha" since="3.1.4">
    Use internal String->Integer conversion routines to avoid excessive object creation?
  </Property>
  <Property name="useJvmCharsetConverters" required="No" default="false" sortOrder="alpha" since="5.0.1">
    Always use the character encoding routines built into the JVM, rather than using lookup tables for single-byte character sets?
  </Property>
  <Property name="useReadAheadInput" required="No" default="true" sortOrder="alpha" since="3.1.5">
    Use newer, optimized non-blocking, buffered input stream when reading from the server?
  </Property>
</PropertyCategory>
<PropertyCategory name="Debugging/Profiling">
  <Property name="logger" required="No" default="com.mysql.jdbc.log.StandardLogger" sortOrder="0" since="3.1.1">
    The name of a class that implements "com.mysql.jdbc.log.Log"  that will be used to log messages to. (default is "com.mysql.jdbc.log.StandardLogger", which logs to STDERR)
  </Property>
  <Property name="gatherPerfMetrics" required="No" default="false" sortOrder="1" since="3.1.2">
    Should the driver gather performance metrics, and report them via the configured logger every 'reportMetricsIntervalMillis' milliseconds?
  </Property>
  <Property name="profileSQL" required="No" default="false" sortOrder="1" since="3.1.0">
    Trace queries and their execution/fetch times to the configured logger (true/false) defaults to 'false'
  </Property>
  <Property name="profileSql" required="No" default="" sortOrder="3" since="2.0.14">
    Deprecated, use 'profileSQL' instead. Trace queries and their execution/fetch times on STDERR (true/false) defaults to 'false'
  </Property>
  <Property name="reportMetricsIntervalMillis" required="No" default="30000" sortOrder="3" since="3.1.2">
    If 'gatherPerfMetrics' is enabled, how often should they be logged (in ms)?
  </Property>
  <Property name="maxQuerySizeToLog" required="No" default="2048" sortOrder="4" since="3.1.3">
    Controls the maximum length/size of a query that will get logged when profiling or tracing
  </Property>
  <Property name="packetDebugBufferSize" required="No" default="20" sortOrder="7" since="3.1.3">
    The maximum number of packets to retain when 'enablePacketDebug' is true
  </Property>
  <Property name="slowQueryThresholdMillis" required="No" default="2000" sortOrder="9" since="3.1.2">
    If 'logSlowQueries' is enabled, how long should a query (in ms) before it is logged as 'slow'?
  </Property>
  <Property name="slowQueryThresholdNanos" required="No" default="0" sortOrder="10" since="5.0.7">
    If 'useNanosForElapsedTime' is set to true, and this property is set to a non-zero value, the driver will use this threshold (in nanosecond units) to determine if a query was slow.
  </Property>
  <Property name="useUsageAdvisor" required="No" default="false" sortOrder="10" since="3.1.1">
    Should the driver issue 'usage' warnings advising proper and efficient usage of JDBC and MySQL Connector/J to the log (true/false, defaults to 'false')?
  </Property>
  <Property name="autoGenerateTestcaseScript" required="No" default="false" sortOrder="alpha" since="3.1.9">
    Should the driver dump the SQL it is executing, including server-side prepared statements to STDERR?
  </Property>
  <Property name="autoSlowLog" required="No" default="true" sortOrder="alpha" since="5.1.4">
    Instead of using slowQueryThreshold* to determine if a query is slow enough to be logged, maintain statistics that allow the driver to determine queries that are outside the 99th percentile?
  </Property>
  <Property name="clientInfoProvider" required="No" default="com.mysql.jdbc.JDBC4CommentClientInfoProvider" sortOrder="alpha" since="5.1.0">
    The name of a class that implements the com.mysql.jdbc.JDBC4ClientInfoProvider interface in order to support JDBC-4.0's Connection.get/setClientInfo() methods
  </Property>
  <Property name="dumpMetadataOnColumnNotFound" required="No" default="false" sortOrder="alpha" since="3.1.13">
    Should the driver dump the field-level metadata of a result set into the exception message when ResultSet.findColumn() fails?
  </Property>
  <Property name="dumpQueriesOnException" required="No" default="false" sortOrder="alpha" since="3.1.3">
    Should the driver dump the contents of the query sent to the server in the message for SQLExceptions?
  </Property>
  <Property name="enablePacketDebug" required="No" default="false" sortOrder="alpha" since="3.1.3">
    When enabled, a ring-buffer of 'packetDebugBufferSize' packets will be kept, and dumped when exceptions are thrown in key areas in the driver's code
  </Property>
  <Property name="explainSlowQueries" required="No" default="false" sortOrder="alpha" since="3.1.2">
    If 'logSlowQueries' is enabled, should the driver automatically issue an 'EXPLAIN' on the server and send the results to the configured log at a WARN level?
  </Property>
  <Property name="includeInnodbStatusInDeadlockExceptions" required="No" default="false" sortOrder="alpha" since="5.0.7">
    Include the output of "SHOW ENGINE INNODB STATUS" in exception messages when deadlock exceptions are detected?
  </Property>
  <Property name="includeThreadDumpInDeadlockExceptions" required="No" default="false" sortOrder="alpha" since="5.1.15">
    Include a current Java thread dump in exception messages when deadlock exceptions are detected?
  </Property>
  <Property name="includeThreadNamesAsStatementComment" required="No" default="false" sortOrder="alpha" since="5.1.15">
    Include the name of the current thread as a comment visible in "SHOW PROCESSLIST", or in Innodb deadlock dumps, useful in correlation with "includeInnodbStatusInDeadlockExceptions=true" and "includeThreadDumpInDeadlockExceptions=true".
  </Property>
  <Property name="logSlowQueries" required="No" default="false" sortOrder="alpha" since="3.1.2">
    Should queries that take longer than 'slowQueryThresholdMillis' be logged?
  </Property>
  <Property name="logXaCommands" required="No" default="false" sortOrder="alpha" since="5.0.5">
    Should the driver log XA commands sent by MysqlXaConnection to the server, at the DEBUG level of logging?
  </Property>
  <Property name="profilerEventHandler" required="No" default="com.mysql.jdbc.profiler.LoggingProfilerEventHandler" sortOrder="alpha" since="5.1.6">
    Name of a class that implements the interface com.mysql.jdbc.profiler.ProfilerEventHandler that will be used to handle profiling/tracing events.
  </Property>
  <Property name="resultSetSizeThreshold" required="No" default="100" sortOrder="alpha" since="5.0.5">
    If the usage advisor is enabled, how many rows should a result set contain before the driver warns that it is suspiciously large?
  </Property>
  <Property name="traceProtocol" required="No" default="false" sortOrder="alpha" since="3.1.2">
    Should trace-level network protocol be logged?
  </Property>
  <Property name="useNanosForElapsedTime" required="No" default="false" sortOrder="alpha" since="5.0.7">
    For profiling/debugging functionality that measures elapsed time, should the driver try to use nanoseconds resolution if available (JDK >= 1.5)?
  </Property>
</PropertyCategory>
<PropertyCategory name="Miscellaneous">
  <Property name="useUnicode" required="No" default="true" sortOrder="0" since="1.1g">
    Should the driver use Unicode character encodings when handling strings? Should only be used when the driver can't determine the character set mapping, or you are trying to 'force' the driver to use a character set that MySQL either doesn't natively support (such as UTF-8), true/false, defaults to 'true'
  </Property>
  <Property name="characterEncoding" required="No" default="" sortOrder="5" since="1.1g">
    If 'useUnicode' is set to true, what character encoding should the driver use when dealing with strings? (defaults is to 'autodetect')
  </Property>
  <Property name="characterSetResults" required="No" default="" sortOrder="6" since="3.0.13">
    Character set to tell the server to return results as.
  </Property>
  <Property name="connectionAttributes" required="No" default="" sortOrder="7" since="5.1.25">
    A comma-delimited list of user-defined key:value pairs (in addition to standard MySQL-defined key:value pairs) to be passed to MySQL Server for display as connection attributes in the PERFORMANCE_SCHEMA.SESSION_CONNECT_ATTRS table.  Example usage:  connectionAttributes=key1:value1,key2:value2  This functionality is available for use with MySQL Server version 5.6 or later only.  Earlier versions of MySQL Server do not support connection attributes, causing this configuration option will be ignored.  Setting connectionAttributes=none will cause connection attribute processing to be bypassed, for situations where Connection creation/initialization speed is critical.
  </Property>
  <Property name="connectionCollation" required="No" default="" sortOrder="7" since="3.0.13">
    If set, tells the server to use this collation via 'set collation_connection'
  </Property>
  <Property name="useBlobToStoreUTF8OutsideBMP" required="No" default="false" sortOrder="128" since="5.1.3">
    Tells the driver to treat [MEDIUM/LONG]BLOB columns as [LONG]VARCHAR columns holding text encoded in UTF-8 that has characters outside the BMP (4-byte encodings), which MySQL server can't handle natively.
  </Property>
  <Property name="utf8OutsideBmpExcludedColumnNamePattern" required="No" default="" sortOrder="129" since="5.1.3">
    When "useBlobToStoreUTF8OutsideBMP" is set to "true", column names matching the given regex will still be treated as BLOBs unless they match the regex specified for "utf8OutsideBmpIncludedColumnNamePattern". The regex must follow the patterns used for the java.util.regex package.
  </Property>
  <Property name="utf8OutsideBmpIncludedColumnNamePattern" required="No" default="" sortOrder="129" since="5.1.3">
    Used to specify exclusion rules to "utf8OutsideBmpExcludedColumnNamePattern". The regex must follow the patterns used for the java.util.regex package.
  </Property>
  <Property name="loadBalanceEnableJMX" required="No" default="false" sortOrder="2147483647" since="5.1.13">
    Enables JMX-based management of load-balanced connection groups, including live addition/removal of hosts from load-balancing pool.
  </Property>
  <Property name="sessionVariables" required="No" default="" sortOrder="2147483647" since="3.1.8">
    A comma-separated list of name/value pairs to be sent as SET SESSION ... to the server when the driver connects.
  </Property>
  <Property name="useColumnNamesInFindColumn" required="No" default="false" sortOrder="2147483647" since="5.1.7">
    Prior to JDBC-4.0, the JDBC specification had a bug related to what could be given as a "column name" to ResultSet methods like findColumn(), or getters that took a String property. JDBC-4.0 clarified "column name" to mean the label, as given in an "AS" clause and returned by ResultSetMetaData.getColumnLabel(), and if no AS clause, the column name. Setting this property to "true" will give behavior that is congruent to JDBC-3.0 and earlier versions of the JDBC specification, but which because of the specification bug could give unexpected results. This property is preferred over "useOldAliasMetadataBehavior" unless you need the specific behavior that it provides with respect to ResultSetMetadata.
  </Property>
  <Property name="allowNanAndInf" required="No" default="false" sortOrder="alpha" since="3.1.5">
    Should the driver allow NaN or +/- INF values in PreparedStatement.setDouble()?
  </Property>
  <Property name="autoClosePStmtStreams" required="No" default="false" sortOrder="alpha" since="3.1.12">
    Should the driver automatically call .close() on streams/readers passed as arguments via set*() methods?
  </Property>
  <Property name="autoDeserialize" required="No" default="false" sortOrder="alpha" since="3.1.5">
    Should the driver automatically detect and de-serialize objects stored in BLOB fields?
  </Property>
  <Property name="blobsAreStrings" required="No" default="false" sortOrder="alpha" since="5.0.8">
    Should the driver always treat BLOBs as Strings - specifically to work around dubious metadata returned by the server for GROUP BY clauses?
  </Property>
  <Property name="capitalizeTypeNames" required="No" default="true" sortOrder="alpha" since="2.0.7">
    Capitalize type names in DatabaseMetaData? (usually only useful when using WebObjects, true/false, defaults to 'false')
  </Property>
  <Property name="clobCharacterEncoding" required="No" default="" sortOrder="alpha" since="5.0.0">
    The character encoding to use for sending and retrieving TEXT, MEDIUMTEXT and LONGTEXT values instead of the configured connection characterEncoding
  </Property>
  <Property name="clobberStreamingResults" required="No" default="false" sortOrder="alpha" since="3.0.9">
    This will cause a 'streaming' ResultSet to be automatically closed, and any outstanding data still streaming from the server to be discarded if another query is executed before all the data has been read from the server.
  </Property>
  <Property name="compensateOnDuplicateKeyUpdateCounts" required="No" default="false" sortOrder="alpha" since="5.1.7">
    Should the driver compensate for the update counts of "ON DUPLICATE KEY" INSERT statements (2 = 1, 0 = 1) when using prepared statements?
  </Property>
  <Property name="continueBatchOnError" required="No" default="true" sortOrder="alpha" since="3.0.3">
    Should the driver continue processing batch commands if one statement fails. The JDBC spec allows either way (defaults to 'true').
  </Property>
  <Property name="createDatabaseIfNotExist" required="No" default="false" sortOrder="alpha" since="3.1.9">
    Creates the database given in the URL if it doesn't yet exist. Assumes the configured user has permissions to create databases.
  </Property>
  <Property name="emptyStringsConvertToZero" required="No" default="true" sortOrder="alpha" since="3.1.8">
    Should the driver allow conversions from empty string fields to numeric values of '0'?
  </Property>
  <Property name="emulateLocators" required="No" default="false" sortOrder="alpha" since="3.1.0">
    Should the driver emulate java.sql.Blobs with locators? With this feature enabled, the driver will delay loading the actual Blob data until the one of the retrieval methods (getInputStream(), getBytes(), and so forth) on the blob data stream has been accessed. For this to work, you must use a column alias with the value of the column to the actual name of the Blob. The feature also has the following restrictions: The SELECT that created the result set must reference only one table, the table must have a primary key; the SELECT must alias the original blob column name, specified as a string, to an alternate name; the SELECT must cover all columns that make up the primary key.
  </Property>
  <Property name="emulateUnsupportedPstmts" required="No" default="true" sortOrder="alpha" since="3.1.7">
    Should the driver detect prepared statements that are not supported by the server, and replace them with client-side emulated versions?
  </Property>
  <Property name="exceptionInterceptors" required="No" default="" sortOrder="alpha" since="5.1.8">
    Comma-delimited list of classes that implement com.mysql.jdbc.ExceptionInterceptor. These classes will be instantiated one per Connection instance, and all SQLExceptions thrown by the driver will be allowed to be intercepted by these interceptors, in a chained fashion, with the first class listed as the head of the chain.
  </Property>
  <Property name="functionsNeverReturnBlobs" required="No" default="false" sortOrder="alpha" since="5.0.8">
    Should the driver always treat data from functions returning BLOBs as Strings - specifically to work around dubious metadata returned by the server for GROUP BY clauses?
  </Property>
  <Property name="generateSimpleParameterMetadata" required="No" default="false" sortOrder="alpha" since="5.0.5">
    Should the driver generate simplified parameter metadata for PreparedStatements when no metadata is available either because the server couldn't support preparing the statement, or server-side prepared statements are disabled?
  </Property>
  <Property name="getProceduresReturnsFunctions" required="No" default="true" sortOrder="alpha" since="5.1.26">
    Pre-JDBC4 DatabaseMetaData API has only the getProcedures() and getProcedureColumns() methods, so they return metadata info for both stored procedures and functions. JDBC4 was extended with the getFunctions() and getFunctionColumns() methods and the expected behaviours of previous methods are not well defined. For JDBC4 and higher, default 'true' value of the option means that calls of DatabaseMetaData.getProcedures() and DatabaseMetaData.getProcedureColumns() return metadata for both procedures and functions as before, keeping backward compatibility. Setting this property to 'false' decouples Connector/J from its pre-JDBC4 behaviours for DatabaseMetaData.getProcedures() and DatabaseMetaData.getProcedureColumns(), forcing them to return metadata for procedures only.
  </Property>
  <Property name="ignoreNonTxTables" required="No" default="false" sortOrder="alpha" since="3.0.9">
    Ignore non-transactional table warning for rollback? (defaults to 'false').
  </Property>
  <Property name="jdbcCompliantTruncation" required="No" default="true" sortOrder="alpha" since="3.1.2">
    Should the driver throw java.sql.DataTruncation exceptions when data is truncated as is required by the JDBC specification when connected to a server that supports warnings (MySQL 4.1.0 and newer)? This property has no effect if the server sql-mode includes STRICT_TRANS_TABLES.
  </Property>
  <Property name="loadBalanceAutoCommitStatementRegex" required="No" default="" sortOrder="alpha" since="5.1.15">
    When load-balancing is enabled for auto-commit statements (via loadBalanceAutoCommitStatementThreshold), the statement counter will only increment when the SQL matches the regular expression.  By default, every statement issued matches.
  </Property>
  <Property name="loadBalanceAutoCommitStatementThreshold" required="No" default="0" sortOrder="alpha" since="5.1.15">
    When auto-commit is enabled, the number of statements which should be executed before triggering load-balancing to rebalance.  Default value of 0 causes load-balanced connections to only rebalance when exceptions are encountered, or auto-commit is disabled and transactions are explicitly committed or rolled back.
  </Property>
  <Property name="loadBalanceBlacklistTimeout" required="No" default="0" sortOrder="alpha" since="5.1.0">
    Time in milliseconds between checks of servers which are unavailable, by controlling how long a server lives in the global blacklist.
  </Property>
  <Property name="loadBalanceConnectionGroup" required="No" default="" sortOrder="alpha" since="5.1.13">
    Logical group of load-balanced connections within a classloader, used to manage different groups independently.  If not specified, live management of load-balanced connections is disabled.
  </Property>
  <Property name="loadBalanceExceptionChecker" required="No" default="com.mysql.jdbc.StandardLoadBalanceExceptionChecker" sortOrder="alpha" since="5.1.13">
    Fully-qualified class name of custom exception checker.  The class must implement com.mysql.jdbc.LoadBalanceExceptionChecker interface, and is used to inspect SQLExceptions and determine whether they should trigger fail-over to another host in a load-balanced deployment.
  </Property>
  <Property name="loadBalancePingTimeout" required="No" default="0" sortOrder="alpha" since="5.1.13">
    Time in milliseconds to wait for ping response from each of load-balanced physical connections when using load-balanced Connection.
  </Property>
  <Property name="loadBalanceSQLExceptionSubclassFailover" required="No" default="" sortOrder="alpha" since="5.1.13">
    Comma-delimited list of classes/interfaces used by default load-balanced exception checker to determine whether a given SQLException should trigger failover.  The comparison is done using Class.isInstance(SQLException) using the thrown SQLException.
  </Property>
  <Property name="loadBalanceSQLStateFailover" required="No" default="" sortOrder="alpha" since="5.1.13">
    Comma-delimited list of SQLState codes used by default load-balanced exception checker to determine whether a given SQLException should trigger failover.  The SQLState of a given SQLException is evaluated to determine whether it begins with any value in the comma-delimited list.
  </Property>
  <Property name="loadBalanceValidateConnectionOnSwapServer" required="No" default="false" sortOrder="alpha" since="5.1.13">
    Should the load-balanced Connection explicitly check whether the connection is live when swapping to a new physical connection at commit/rollback?
  </Property>
  <Property name="maxRows" required="No" default="-1" sortOrder="alpha" since="all versions">
    The maximum number of rows to return (0, the default means return all rows).
  </Property>
  <Property name="netTimeoutForStreamingResults" required="No" default="600" sortOrder="alpha" since="5.1.0">
    What value should the driver automatically set the server setting 'net_write_timeout' to when the streaming result sets feature is in use? (value has unit of seconds, the value '0' means the driver will not try and adjust this value)
  </Property>
  <Property name="noAccessToProcedureBodies" required="No" default="false" sortOrder="alpha" since="5.0.3">
    When determining procedure parameter types for CallableStatements, and the connected user  can't access procedure bodies through "SHOW CREATE PROCEDURE" or select on mysql.proc  should the driver instead create basic metadata (all parameters reported as IN VARCHARs, but allowing registerOutParameter() to be called on them anyway) instead  of throwing an exception?
  </Property>
  <Property name="noDatetimeStringSync" required="No" default="false" sortOrder="alpha" since="3.1.7">
    Don't ensure that ResultSet.getDatetimeType().toString().equals(ResultSet.getString())
  </Property>
  <Property name="noTimezoneConversionForTimeType" required="No" default="false" sortOrder="alpha" since="5.0.0">
    Don't convert TIME values using the server timezone if 'useTimezone'='true'
  </Property>
  <Property name="nullCatalogMeansCurrent" required="No" default="true" sortOrder="alpha" since="3.1.8">
    When DatabaseMetadataMethods ask for a 'catalog' parameter, does the value null mean use the current catalog? (this is not JDBC-compliant, but follows legacy behavior from earlier versions of the driver)
  </Property>
  <Property name="nullNamePatternMatchesAll" required="No" default="true" sortOrder="alpha" since="3.1.8">
    Should DatabaseMetaData methods that accept *pattern parameters treat null the same as '%' (this is not JDBC-compliant, however older versions of the driver accepted this departure from the specification)
  </Property>
  <Property name="overrideSupportsIntegrityEnhancementFacility" required="No" default="false" sortOrder="alpha" since="3.1.12">
    Should the driver return "true" for DatabaseMetaData.supportsIntegrityEnhancementFacility() even if the database doesn't support it to workaround applications that require this method to return "true" to signal support of foreign keys, even though the SQL specification states that this facility contains much more than just foreign key support (one such application being OpenOffice)?
  </Property>
  <Property name="padCharsWithSpace" required="No" default="false" sortOrder="alpha" since="5.0.6">
    If a result set column has the CHAR type and the value does not fill the amount of characters specified in the DDL for the column, should the driver pad the remaining characters with space (for ANSI compliance)?
  </Property>
  <Property name="pedantic" required="No" default="false" sortOrder="alpha" since="3.0.0">
    Follow the JDBC spec to the letter.
  </Property>
  <Property name="pinGlobalTxToPhysicalConn

[Descarga:]

Bueno muchachos, acá les dejo este manual que encontré dando vueltas por ahí. Está en PDF, se los subí a mediafire.

Descarga:

¡CLICK!

Bueno, logre hacer la conexión y no me tiro ningún error de sintaxis  

Pero cuando pongo "run" para iniciar el programa, me tira todo esto en consola (Creo que es todo por la MySQL)

[code=cpp]<ConnectionProperties>
<PropertyCategory name="Connection/Authentication">
 <Property name="user" required="No" default="" sortOrder="-2147483647" since="all versions">
   The user to connect as
 </Property>
 <Property name="password" required="No" default="" sortOrder="-2147483646" since="all versions">
   The password to use when connecting
 </Property>
 <Property name="socketFactory" required="No" default="com.mysql.jdbc.StandardSocketFactory" sortOrder="4" since="3.0.3">
   The name of the class that the driver should use for creating socket connections to the server. This class must implement the interface 'com.mysql.jdbc.SocketFactory' and have public no-args constructor.
 </Property>
 <Property name="connectTimeout" required="No" default="0" sortOrder="9" since="3.0.1">
   Timeout for socket connect (in milliseconds), with 0 being no timeout. Only works on JDK-1.4 or newer. Defaults to '0'.
 </Property>
 <Property name="socketTimeout" required="No" default="0" sortOrder="10" since="3.0.1">
   Timeout on network socket operations (0, the default means no timeout).
 </Property>
 <Property name="connectionLifecycleInterceptors" required="No" default="" sortOrder="2147483647" since="5.1.4">
   A comma-delimited list of classes that implement "com.mysql.jdbc.ConnectionLifecycleInterceptor" that should notified of connection lifecycle events (creation, destruction, commit, rollback, setCatalog and setAutoCommit) and potentially alter the execution of these commands. ConnectionLifecycleInterceptors are "stackable", more than one interceptor may be specified via the configuration property as a comma-delimited list, with the interceptors executed in order from left to right.
 </Property>
 <Property name="useConfigs" required="No" default="" sortOrder="2147483647" since="3.1.5">
   Load the comma-delimited list of configuration properties before parsing the URL or applying user-specified properties. These configurations are explained in the 'Configurations' of the documentation.
 </Property>
 <Property name="authenticationPlugins" required="No" default="" sortOrder="alpha" since="5.1.19">
   Comma-delimited list of classes that implement com.mysql.jdbc.AuthenticationPlugin and which will be used for authentication unless disabled by "disabledAuthenticationPlugins" property.
 </Property>
 <Property name="defaultAuthenticationPlugin" required="No" default="com.mysql.jdbc.authentication.MysqlNativePasswordPlugin" sortOrder="alpha" since="5.1.19">
   Name of a class implementing com.mysql.jdbc.AuthenticationPlugin which will be used as the default authentication plugin (see below). It is an error to use a class which is not listed in "authenticationPlugins" nor it is one of the built-in plugins. It is an error to set as default a plugin which was disabled with "disabledAuthenticationPlugins" property. It is an error to set this value to null or the empty string (i.e. there must be at least a valid default authentication plugin specified for the connection, meeting all constraints listed above).
 </Property>
 <Property name="disabledAuthenticationPlugins" required="No" default="" sortOrder="alpha" since="5.1.19">
   Comma-delimited list of classes implementing com.mysql.jdbc.AuthenticationPlugin or mechanisms, i.e. "mysql_native_password". The authentication plugins or mechanisms listed will not be used for authentication which will fail if it requires one of them. It is an error to disable the default authentication plugin (either the one named by "defaultAuthenticationPlugin" property or the hard-coded one if "defaultAuthenticationPlugin" property is not set).
 </Property>
 <Property name="disconnectOnExpiredPasswords" required="No" default="true" sortOrder="alpha" since="5.1.23">
   If "disconnectOnExpiredPasswords" is set to "false" and password is expired then server enters "sandbox" mode and sends ERR(08001, ER_MUST_CHANGE_PASSWORD) for all commands that are not needed to set a new password until a new password is set.
 </Property>
 <Property name="interactiveClient" required="No" default="false" sortOrder="alpha" since="3.1.0">
   Set the CLIENT_INTERACTIVE flag, which tells MySQL to timeout connections based on INTERACTIVE_TIMEOUT instead of WAIT_TIMEOUT
 </Property>
 <Property name="localSocketAddress" required="No" default="" sortOrder="alpha" since="5.0.5">
   Hostname or IP address given to explicitly configure the interface that the driver will bind the client side of the TCP/IP connection to when connecting.
 </Property>
 <Property name="propertiesTransform" required="No" default="" sortOrder="alpha" since="3.1.4">
   An implementation of com.mysql.jdbc.ConnectionPropertiesTransform that the driver will use to modify URL properties passed to the driver before attempting a connection
 </Property>
 <Property name="useCompression" required="No" default="false" sortOrder="alpha" since="3.0.17">
   Use zlib compression when communicating with the server (true/false)? Defaults to 'false'.
 </Property>
</PropertyCategory>
<PropertyCategory name="Networking">
 <Property name="maxAllowedPacket" required="No" default="-1" sortOrder="alpha" since="5.1.8">
   Maximum allowed packet size to send to server. If not set, the value of system variable 'max_allowed_packet' will be used to initialize this upon connecting. This value will not take effect if set larger than the value of 'max_allowed_packet'.
 </Property>
 <Property name="tcpKeepAlive" required="No" default="true" sortOrder="alpha" since="5.0.7">
   If connecting using TCP/IP, should the driver set SO_KEEPALIVE?
 </Property>
 <Property name="tcpNoDelay" required="No" default="true" sortOrder="alpha" since="5.0.7">
   If connecting using TCP/IP, should the driver set SO_TCP_NODELAY (disabling the Nagle Algorithm)?
 </Property>
 <Property name="tcpRcvBuf" required="No" default="0" sortOrder="alpha" since="5.0.7">
   If connecting using TCP/IP, should the driver set SO_RCV_BUF to the given value? The default value of '0', means use the platform default value for this property)
 </Property>
 <Property name="tcpSndBuf" required="No" default="0" sortOrder="alpha" since="5.0.7">
   If connecting using TCP/IP, should the driver set SO_SND_BUF to the given value? The default value of '0', means use the platform default value for this property)
 </Property>
 <Property name="tcpTrafficClass" required="No" default="0" sortOrder="alpha" since="5.0.7">
   If connecting using TCP/IP, should the driver set traffic class or type-of-service fields ?See the documentation for java.net.Socket.setTrafficClass() for more information.
 </Property>
</PropertyCategory>
<PropertyCategory name="High Availability and Clustering">
 <Property name="autoReconnect" required="No" default="false" sortOrder="0" since="1.1">
   Should the driver try to re-establish stale and/or dead connections? If enabled the driver will throw an exception for a queries issued on a stale or dead connection, which belong to the current transaction, but will attempt reconnect before the next query issued on the connection in a new transaction. The use of this feature is not recommended, because it has side effects related to session state and data consistency when applications don't handle SQLExceptions properly, and is only designed to be used when you are unable to configure your application to handle SQLExceptions resulting from dead and stale connections properly. Alternatively, as a last option, investigate setting the MySQL server variable "wait_timeout" to a high value, rather than the default of 8 hours.
 </Property>
 <Property name="autoReconnectForPools" required="No" default="false" sortOrder="1" since="3.1.3">
   Use a reconnection strategy appropriate for connection pools (defaults to 'false')
 </Property>
 <Property name="failOverReadOnly" required="No" default="true" sortOrder="2" since="3.0.12">
   When failing over in autoReconnect mode, should the connection be set to 'read-only'?
 </Property>
 <Property name="maxReconnects" required="No" default="3" sortOrder="4" since="1.1">
   Maximum number of reconnects to attempt if autoReconnect is true, default is '3'.
 </Property>
 <Property name="reconnectAtTxEnd" required="No" default="false" sortOrder="4" since="3.0.10">
   If autoReconnect is set to true, should the driver attempt reconnections at the end of every transaction?
 </Property>
 <Property name="retriesAllDown" required="No" default="120" sortOrder="4" since="5.1.6">
   When using loadbalancing, the number of times the driver should cycle through available hosts, attempting to connect.  Between cycles, the driver will pause for 250ms if no servers are available.
 </Property>
 <Property name="initialTimeout" required="No" default="2" sortOrder="5" since="1.1">
   If autoReconnect is enabled, the initial time to wait between re-connect attempts (in seconds, defaults to '2').
 </Property>
 <Property name="roundRobinLoadBalance" required="No" default="false" sortOrder="5" since="3.1.2">
   When autoReconnect is enabled, and failoverReadonly is false, should we pick hosts to connect to on a round-robin basis?
 </Property>
 <Property name="queriesBeforeRetryMaster" required="No" default="50" sortOrder="7" since="3.0.2">
   Number of queries to issue before falling back to master when failed over (when using multi-host failover). Whichever condition is met first, 'queriesBeforeRetryMaster' or 'secondsBeforeRetryMaster' will cause an attempt to be made to reconnect to the master. Defaults to 50.
 </Property>
 <Property name="secondsBeforeRetryMaster" required="No" default="30" sortOrder="8" since="3.0.2">
   How long should the driver wait, when failed over, before attempting
 </Property>
 <Property name="selfDestructOnPingMaxOperations" required="No" default="0" sortOrder="2147483647" since="5.1.6">
   =If set to a non-zero value, the driver will report close the connection and report failure when Connection.ping() or Connection.isValid(int) is called if the connection's count of commands sent to the server exceeds this value.
 </Property>
 <Property name="selfDestructOnPingSecondsLifetime" required="No" default="0" sortOrder="2147483647" since="5.1.6">
   If set to a non-zero value, the driver will report close the connection and report failure when Connection.ping() or Connection.isValid(int) is called if the connection's lifetime exceeds this value.
 </Property>
 <Property name="resourceId" required="No" default="" sortOrder="alpha" since="5.0.1">
   A globally unique name that identifies the resource that this datasource or connection is connected to, used for XAResource.isSameRM() when the driver can't determine this value based on hostnames used in the URL
 </Property>
</PropertyCategory>
<PropertyCategory name="Security">
 <Property name="allowMultiQueries" required="No" default="false" sortOrder="1" since="3.1.1">
   Allow the use of ';' to delimit multiple queries during one statement (true/false), defaults to 'false', and does not affect the addBatch() and executeBatch() methods, which instead rely on rewriteBatchStatements.
 </Property>
 <Property name="useSSL" required="No" default="false" sortOrder="2" since="3.0.2">
   Use SSL when communicating with the server (true/false), defaults to 'false'
 </Property>
 <Property name="requireSSL" required="No" default="false" sortOrder="3" since="3.1.0">
   Require SSL connection if useSSL=true? (defaults to 'false').
 </Property>
 <Property name="verifyServerCertificate" required="No" default="true" sortOrder="4" since="5.1.6">
   If "useSSL" is set to "true", should the driver verify the server's certificate? When using this feature, the keystore parameters should be specified by the "clientCertificateKeyStore*" properties, rather than system properties.
 </Property>
 <Property name="clientCertificateKeyStoreUrl" required="No" default="" sortOrder="5" since="5.1.0">
   URL to the client certificate KeyStore (if not specified, use defaults)
 </Property>
 <Property name="clientCertificateKeyStoreType" required="No" default="JKS" sortOrder="6" since="5.1.0">
   KeyStore type for client certificates (NULL or empty means use the default, which is "JKS". Standard keystore types supported by the JVM are "JKS" and "PKCS12", your environment may have more available depending on what security products are installed and available to the JVM.
 </Property>
 <Property name="clientCertificateKeyStorePassword" required="No" default="" sortOrder="7" since="5.1.0">
   Password for the client certificates KeyStore
 </Property>
 <Property name="trustCertificateKeyStoreUrl" required="No" default="" sortOrder="8" since="5.1.0">
   URL to the trusted root certificate KeyStore (if not specified, use defaults)
 </Property>
 <Property name="trustCertificateKeyStoreType" required="No" default="JKS" sortOrder="9" since="5.1.0">
   KeyStore type for trusted root certificates (NULL or empty means use the default, which is "JKS". Standard keystore types supported by the JVM are "JKS" and "PKCS12", your environment may have more available depending on what security products are installed and available to the JVM.
 </Property>
 <Property name="trustCertificateKeyStorePassword" required="No" default="" sortOrder="10" since="5.1.0">
   Password for the trusted root certificates KeyStore
 </Property>
 <Property name="allowLoadLocalInfile" required="No" default="true" sortOrder="2147483647" since="3.0.3">
   Should the driver allow use of 'LOAD DATA LOCAL INFILE...' (defaults to 'true').
 </Property>
 <Property name="allowUrlInLocalInfile" required="No" default="false" sortOrder="2147483647" since="3.1.4">
   Should the driver allow URLs in 'LOAD DATA LOCAL INFILE' statements?
 </Property>
 <Property name="paranoid" required="No" default="false" sortOrder="alpha" since="3.0.1">
   Take measures to prevent exposure sensitive information in error messages and clear data structures holding sensitive data when possible? (defaults to 'false')
 </Property>
 <Property name="passwordCharacterEncoding" required="No" default="" sortOrder="alpha" since="5.1.7">
   What character encoding is used for passwords? Leaving this set to the default value (null), uses the platform character set, which works for ISO8859_1 (i.e. "latin1") passwords. For passwords in other character encodings, the encoding will have to be specified with this property, as it's not possible for the driver to auto-detect this.
 </Property>
</PropertyCategory>
<PropertyCategory name="Performance Extensions">
 <Property name="callableStmtCacheSize" required="No" default="100" sortOrder="5" since="3.1.2">
   If 'cacheCallableStmts' is enabled, how many callable statements should be cached?
 </Property>
 <Property name="metadataCacheSize" required="No" default="50" sortOrder="5" since="3.1.1">
   The number of queries to cache ResultSetMetadata for if cacheResultSetMetaData is set to 'true' (default 50)
 </Property>
 <Property name="useLocalSessionState" required="No" default="false" sortOrder="5" since="3.1.7">
   Should the driver refer to the internal values of autocommit and transaction isolation that are set by Connection.setAutoCommit() and Connection.setTransactionIsolation() and transaction state as maintained by the protocol, rather than querying the database or blindly sending commands to the database for commit() or rollback() method calls?
 </Property>
 <Property name="useLocalTransactionState" required="No" default="false" sortOrder="6" since="5.1.7">
   Should the driver use the in-transaction state provided by the MySQL protocol to determine if a commit() or rollback() should actually be sent to the database?
 </Property>
 <Property name="prepStmtCacheSize" required="No" default="25" sortOrder="10" since="3.0.10">
   If prepared statement caching is enabled, how many prepared statements should be cached?
 </Property>
 <Property name="prepStmtCacheSqlLimit" required="No" default="256" sortOrder="11" since="3.0.10">
   If prepared statement caching is enabled, what's the largest SQL the driver will cache the parsing for?
 </Property>
 <Property name="parseInfoCacheFactory" required="No" default="com.mysql.jdbc.PerConnectionLRUFactory" sortOrder="12" since="5.1.1">
   Name of a class implementing com.mysql.jdbc.CacheAdapterFactory, which will be used to create caches for the parsed representation of client-side prepared statements.
 </Property>
 <Property name="serverConfigCacheFactory" required="No" default="com.mysql.jdbc.PerVmServerConfigCacheFactory" sortOrder="12" since="5.1.1">
   Name of a class implementing com.mysql.jdbc.CacheAdapterFactory&lt;String, Map&lt;String, String&gt;&gt;, which will be used to create caches for MySQL server configuration values
 </Property>
 <Property name="alwaysSendSetIsolation" required="No" default="true" sortOrder="2147483647" since="3.1.7">
   Should the driver always communicate with the database when Connection.setTransactionIsolation() is called? If set to false, the driver will only communicate with the database when the requested transaction isolation is different than the whichever is newer, the last value that was set via Connection.setTransactionIsolation(), or the value that was read from the server when the connection was established.  Note that useLocalSessionState=true will force the same behavior as alwaysSendSetIsolation=false, regardless of how alwaysSendSetIsolation is set.
 </Property>
 <Property name="maintainTimeStats" required="No" default="true" sortOrder="2147483647" since="3.1.9">
   Should the driver maintain various internal timers to enable idle time calculations as well as more verbose error messages when the connection to the server fails? Setting this property to false removes at least two calls to System.getCurrentTimeMillis() per query.
 </Property>
 <Property name="useCursorFetch" required="No" default="false" sortOrder="2147483647" since="5.0.0">
   If connected to MySQL &gt; 5.0.2, and setFetchSize() &gt; 0 on a statement, should that statement use cursor-based fetching to retrieve rows?
 </Property>
 <Property name="blobSendChunkSize" required="No" default="1048576" sortOrder="alpha" since="3.1.9">
   Chunk to use when sending BLOB/CLOBs via ServerPreparedStatements
 </Property>
 <Property name="cacheCallableStmts" required="No" default="false" sortOrder="alpha" since="3.1.2">
   Should the driver cache the parsing stage of CallableStatements
 </Property>
 <Property name="cachePrepStmts" required="No" default="false" sortOrder="alpha" since="3.0.10">
   Should the driver cache the parsing stage of PreparedStatements of client-side prepared statements, the "check" for suitability of server-side prepared and server-side prepared statements themselves?
 </Property>
 <Property name="cacheResultSetMetadata" required="No" default="false" sortOrder="alpha" since="3.1.1">
   Should the driver cache ResultSetMetaData for Statements and PreparedStatements? (Req. JDK-1.4+, true/false, default 'false')
 </Property>
 <Property name="cacheServerConfiguration" required="No" default="false" sortOrder="alpha" since="3.1.5">
   Should the driver cache the results of 'SHOW VARIABLES' and 'SHOW COLLATION' on a per-URL basis?
 </Property>
 <Property name="defaultFetchSize" required="No" default="0" sortOrder="alpha" since="3.1.9">
   The driver will call setFetchSize(n) with this value on all newly-created Statements
 </Property>
 <Property name="dontTrackOpenResources" required="No" default="false" sortOrder="alpha" since="3.1.7">
   The JDBC specification requires the driver to automatically track and close resources, however if your application doesn't do a good job of explicitly calling close() on statements or result sets, this can cause memory leakage. Setting this property to true relaxes this constraint, and can be more memory efficient for some applications.
 </Property>
 <Property name="dynamicCalendars" required="No" default="false" sortOrder="alpha" since="3.1.5">
   Should the driver retrieve the default calendar when required, or cache it per connection/session?
 </Property>
 <Property name="elideSetAutoCommits" required="No" default="false" sortOrder="alpha" since="3.1.3">
   If using MySQL-4.1 or newer, should the driver only issue 'set autocommit=n' queries when the server's state doesn't match the requested state by Connection.setAutoCommit(boolean)?
 </Property>
 <Property name="enableQueryTimeouts" required="No" default="true" sortOrder="alpha" since="5.0.6">
   When enabled, query timeouts set via Statement.setQueryTimeout() use a shared java.util.Timer instance for scheduling. Even if the timeout doesn't expire before the query is processed, there will be memory used by the TimerTask for the given timeout which won't be reclaimed until the time the timeout would have expired if it hadn't been cancelled by the driver. High-load environments might want to consider disabling this functionality.
 </Property>
 <Property name="holdResultsOpenOverStatementClose" required="No" default="false" sortOrder="alpha" since="3.1.7">
   Should the driver close result sets on Statement.close() as required by the JDBC specification?
 </Property>
 <Property name="largeRowSizeThreshold" required="No" default="2048" sortOrder="alpha" since="5.1.1">
   What size result set row should the JDBC driver consider "large", and thus use a more memory-efficient way of representing the row internally?
 </Property>
 <Property name="loadBalanceStrategy" required="No" default="random" sortOrder="alpha" since="5.0.6">
   If using a load-balanced connection to connect to SQL nodes in a MySQL Cluster/NDB configuration (by using the URL prefix "jdbc:mysql:loadbalance://"), which load balancing algorithm should the driver use: (1) "random" - the driver will pick a random host for each request. This tends to work better than round-robin, as the randomness will somewhat account for spreading loads where requests vary in response time, while round-robin can sometimes lead to overloaded nodes if there are variations in response times across the workload. (2) "bestResponseTime" - the driver will route the request to the host that had the best response time for the previous transaction.
 </Property>
 <Property name="locatorFetchBufferSize" required="No" default="1048576" sortOrder="alpha" since="3.2.1">
   If 'emulateLocators' is configured to 'true', what size buffer should be used when fetching BLOB data for getBinaryInputStream?
 </Property>
 <Property name="rewriteBatchedStatements" required="No" default="false" sortOrder="alpha" since="3.1.13">
   Should the driver use multiqueries (irregardless of the setting of "allowMultiQueries") as well as rewriting of prepared statements for INSERT into multi-value inserts when executeBatch() is called? Notice that this has the potential for SQL injection if using plain java.sql.Statements and your code doesn't sanitize input correctly. Notice that for prepared statements, server-side prepared statements can not currently take advantage of this rewrite option, and that if you don't specify stream lengths when using PreparedStatement.set*Stream(), the driver won't be able to determine the optimum number of parameters per batch and you might receive an error from the driver that the resultant packet is too large. Statement.getGeneratedKeys() for these rewritten statements only works when the entire batch includes INSERT statements.
 </Property>
 <Property name="useDirectRowUnpack" required="No" default="true" sortOrder="alpha" since="5.1.1">
   Use newer result set row unpacking code that skips a copy from network buffers  to a MySQL packet instance and instead reads directly into the result set row data buffers.
 </Property>
 <Property name="useDynamicCharsetInfo" required="No" default="true" sortOrder="alpha" since="5.0.6">
   Should the driver use a per-connection cache of character set information queried from the server when necessary, or use a built-in static mapping that is more efficient, but isn't aware of custom character sets or character sets implemented after the release of the JDBC driver?
 </Property>
 <Property name="useFastDateParsing" required="No" default="true" sortOrder="alpha" since="5.0.5">
   Use internal String->Date/Time/Timestamp conversion routines to avoid excessive object creation?
 </Property>
 <Property name="useFastIntParsing" required="No" default="true" sortOrder="alpha" since="3.1.4">
   Use internal String->Integer conversion routines to avoid excessive object creation?
 </Property>
 <Property name="useJvmCharsetConverters" required="No" default="false" sortOrder="alpha" since="5.0.1">
   Always use the character encoding routines built into the JVM, rather than using lookup tables for single-byte character sets?
 </Property>
 <Property name="useReadAheadInput" required="No" default="true" sortOrder="alpha" since="3.1.5">
   Use newer, optimized non-blocking, buffered input stream when reading from the server?
 </Property>
</PropertyCategory>
<PropertyCategory name="Debugging/Profiling">
 <Property name="logger" required="No" default="com.mysql.jdbc.log.StandardLogger" sortOrder="0" since="3.1.1">
   The name of a class that implements "com.mysql.jdbc.log.Log"  that will be used to log messages to. (default is "com.mysql.jdbc.log.StandardLogger", which logs to STDERR)
 </Property>
 <Property name="gatherPerfMetrics" required="No" default="false" sortOrder="1" since="3.1.2">
   Should the driver gather performance metrics, and report them via the configured logger every 'reportMetricsIntervalMillis' milliseconds?
 </Property>
 <Property name="profileSQL" required="No" default="false" sortOrder="1" since="3.1.0">
   Trace queries and their execution/fetch times to the configured logger (true/false) defaults to 'false'
 </Property>
 <Property name="profileSql" required="No" default="" sortOrder="3" since="2.0.14">
   Deprecated, use 'profileSQL' instead. Trace queries and their execution/fetch times on STDERR (true/false) defaults to 'false'
 </Property>
 <Property name="reportMetricsIntervalMillis" required="No" default="30000" sortOrder="3" since="3.1.2">
   If 'gatherPerfMetrics' is enabled, how often should they be logged (in ms)?
 </Property>
 <Property name="maxQuerySizeToLog" required="No" default="2048" sortOrder="4" since="3.1.3">
   Controls the maximum length/size of a query that will get logged when profiling or tracing
 </Property>
 <Property name="packetDebugBufferSize" required="No" default="20" sortOrder="7" since="3.1.3">
   The maximum number of packets to retain when 'enablePacketDebug' is true
 </Property>
 <Property name="slowQueryThresholdMillis" required="No" default="2000" sortOrder="9" since="3.1.2">
   If 'logSlowQueries' is enabled, how long should a query (in ms) before it is logged as 'slow'?
 </Property>
 <Property name="slowQueryThresholdNanos" required="No" default="0" sortOrder="10" since="5.0.7">
   If 'useNanosForElapsedTime' is set to true, and this property is set to a non-zero value, the driver will use this threshold (in nanosecond units) to determine if a query was slow.
 </Property>
 <Property name="useUsageAdvisor" required="No" default="false" sortOrder="10" since="3.1.1">
   Should the driver issue 'usage' warnings advising proper and efficient usage of JDBC and MySQL Connector/J to the log (true/false, defaults to 'false')?
 </Property>
 <Property name="autoGenerateTestcaseScript" required="No" default="false" sortOrder="alpha" since="3.1.9">
   Should the driver dump the SQL it is executing, including server-side prepared statements to STDERR?
 </Property>
 <Property name="autoSlowLog" required="No" default="true" sortOrder="alpha" since="5.1.4">
   Instead of using slowQueryThreshold* to determine if a query is slow enough to be logged, maintain statistics that allow the driver to determine queries that are outside the 99th percentile?
 </Property>
 <Property name="clientInfoProvider" required="No" default="com.mysql.jdbc.JDBC4CommentClientInfoProvider" sortOrder="alpha" since="5.1.0">
   The name of a class that implements the com.mysql.jdbc.JDBC4ClientInfoProvider interface in order to support JDBC-4.0's Connection.get/setClientInfo() methods
 </Property>
 <Property name="dumpMetadataOnColumnNotFound" required="No" default="false" sortOrder="alpha" since="3.1.13">
   Should the driver dump the field-level metadata of a result set into the exception message when ResultSet.findColumn() fails?
 </Property>
 <Property name="dumpQueriesOnException" required="No" default="false" sortOrder="alpha" since="3.1.3">
   Should the driver dump the contents of the query sent to the server in the message for SQLExceptions?
 </Property>
 <Property name="enablePacketDebug" required="No" default="false" sortOrder="alpha" since="3.1.3">
   When enabled, a ring-buffer of 'packetDebugBufferSize' packets will be kept, and dumped when exceptions are thrown in key areas in the driver's code
 </Property>
 <Property name="explainSlowQueries" required="No" default="false" sortOrder="alpha" since="3.1.2">
   If 'logSlowQueries' is enabled, should the driver automatically issue an 'EXPLAIN' on the server and send the results to the configured log at a WARN level?
 </Property>
 <Property name="includeInnodbStatusInDeadlockExceptions" required="No" default="false" sortOrder="alpha" since="5.0.7">
   Include the output of "SHOW ENGINE INNODB STATUS" in exception messages when deadlock exceptions are detected?
 </Property>
 <Property name="includeThreadDumpInDeadlockExceptions" required="No" default="false" sortOrder="alpha" since="5.1.15">
   Include a current Java thread dump in exception messages when deadlock exceptions are detected?
 </Property>
 <Property name="includeThreadNamesAsStatementComment" required="No" default="false" sortOrder="alpha" since="5.1.15">
   Include the name of the current thread as a comment visible in "SHOW PROCESSLIST", or in Innodb deadlock dumps, useful in correlation with "includeInnodbStatusInDeadlockExceptions=true" and "includeThreadDumpInDeadlockExceptions=true".
 </Property>
 <Property name="logSlowQueries" required="No" default="false" sortOrder="alpha" since="3.1.2">
   Should queries that take longer than 'slowQueryThresholdMillis' be logged?
 </Property>
 <Property name="logXaCommands" required="No" default="false" sortOrder="alpha" since="5.0.5">
   Should the driver log XA commands sent by MysqlXaConnection to the server, at the DEBUG level of logging?
 </Property>
 <Property name="profilerEventHandler" required="No" default="com.mysql.jdbc.profiler.LoggingProfilerEventHandler" sortOrder="alpha" since="5.1.6">
   Name of a class that implements the interface com.mysql.jdbc.profiler.ProfilerEventHandler that will be used to handle profiling/tracing events.
 </Property>
 <Property name="resultSetSizeThreshold" required="No" default="100" sortOrder="alpha" since="5.0.5">
   If the usage advisor is enabled, how many rows should a result set contain before the driver warns that it is suspiciously large?
 </Property>
 <Property name="traceProtocol" required="No" default="false" sortOrder="alpha" since="3.1.2">
   Should trace-level network protocol be logged?
 </Property>
 <Property name="useNanosForElapsedTime" required="No" default="false" sortOrder="alpha" since="5.0.7">
   For profiling/debugging functionality that measures elapsed time, should the driver try to use nanoseconds resolution if available (JDK >= 1.5)?
 </Property>
</PropertyCategory>
<PropertyCategory name="Miscellaneous">
 <Property name="useUnicode" required="No" default="true" sortOrder="0" since="1.1g">
   Should the driver use Unicode character encodings when handling strings? Should only be used when the driver can't determine the character set mapping, or you are trying to 'force' the driver to use a character set that MySQL either doesn't natively support (such as UTF-8), true/false, defaults to 'true'
 </Property>
 <Property name="characterEncoding" required="No" default="" sortOrder="5" since="1.1g">
   If 'useUnicode' is set to true, what character encoding should the driver use when dealing with strings? (defaults is to 'autodetect')
 </Property>
 <Property name="characterSetResults" required="No" default="" sortOrder="6" since="3.0.13">
   Character set to tell the server to return results as.
 </Property>
 <Property name="connectionAttributes" required="No" default="" sortOrder="7" since="5.1.25">
   A comma-delimited list of user-defined key:value pairs (in addition to standard MySQL-defined key:value pairs) to be passed to MySQL Server for display as connection attributes in the PERFORMANCE_SCHEMA.SESSION_CONNECT_ATTRS table.  Example usage:  connectionAttributes=key1:value1,key2:value2  This functionality is available for use with MySQL Server version 5.6 or later only.  Earlier versions of MySQL Server do not support connection attributes, causing this configuration option will be ignored.  Setting connectionAttributes=none will cause connection attribute processing to be bypassed, for situations where Connection creation/initialization speed is critical.
 </Property>
 <Property name="connectionCollation" required="No" default="" sortOrder="7" since="3.0.13">
   If set, tells the server to use this collation via 'set collation_connection'
 </Property>
 <Property name="useBlobToStoreUTF8OutsideBMP" required="No" default="false" sortOrder="128" since="5.1.3">
   Tells the driver to treat [MEDIUM/LONG]BLOB columns as [LONG]VARCHAR columns holding text encoded in UTF-8 that has characters outside the BMP (4-byte encodings), which MySQL server can't handle natively.
 </Property>
 <Property name="utf8OutsideBmpExcludedColumnNamePattern" required="No" default="" sortOrder="129" since="5.1.3">
   When "useBlobToStoreUTF8OutsideBMP" is set to "true", column names matching the given regex will still be treated as BLOBs unless they match the regex specified for "utf8OutsideBmpIncludedColumnNamePattern". The regex must follow the patterns used for the java.util.regex package.
 </Property>
 <Property name="utf8OutsideBmpIncludedColumnNamePattern" required="No" default="" sortOrder="129" since="5.1.3">
   Used to specify exclusion rules to "utf8OutsideBmpExcludedColumnNamePattern". The regex must follow the patterns used for the java.util.regex package.
 </Property>
 <Property name="loadBalanceEnableJMX" required="No" default="false" sortOrder="2147483647" since="5.1.13">
   Enables JMX-based management of load-balanced connection groups, including live addition/removal of hosts from load-balancing pool.
 </Property>
 <Property name="sessionVariables" required="No" default="" sortOrder="2147483647" since="3.1.8">
   A comma-separated list of name/value pairs to be sent as SET SESSION ... to the server when the driver connects.
 </Property>
 <Property name="useColumnNamesInFindColumn" required="No" default="false" sortOrder="2147483647" since="5.1.7">
   Prior to JDBC-4.0, the JDBC specification had a bug related to what could be given as a "column name" to ResultSet methods like findColumn(), or getters that took a String property. JDBC-4.0 clarified "column name" to mean the label, as given in an "AS" clause and returned by ResultSetMetaData.getColumnLabel(), and if no AS clause, the column name. Setting this property to "true" will give behavior that is congruent to JDBC-3.0 and earlier versions of the JDBC specification, but which because of the specification bug could give unexpected results. This property is preferred over "useOldAliasMetadataBehavior" unless you need the specific behavior that it provides with respect to ResultSetMetadata.
 </Property>
 <Property name="allowNanAndInf" required="No" default="false" sortOrder="alpha" since="3.1.5">
   Should the driver allow NaN or +/- INF values in PreparedStatement.setDouble()?
 </Property>
 <Property name="autoClosePStmtStreams" required="No" default="false" sortOrder="alpha" since="3.1.12">
   Should the driver automatically call .close() on streams/readers passed as arguments via set*() methods?
 </Property>
 <Property name="autoDeserialize" required="No" default="false" sortOrder="alpha" since="3.1.5">
   Should the driver automatically detect and de-serialize objects stored in BLOB fields?
 </Property>
 <Property name="blobsAreStrings" required="No" default="false" sortOrder="alpha" since="5.0.8">
   Should the driver always treat BLOBs as Strings - specifically to work around dubious metadata returned by the server for GROUP BY clauses?
 </Property>
 <Property name="capitalizeTypeNames" required="No" default="true" sortOrder="alpha" since="2.0.7">
   Capitalize type names in DatabaseMetaData? (usually only useful when using WebObjects, true/false, defaults to 'false')
 </Property>
 <Property name="clobCharacterEncoding" required="No" default="" sortOrder="alpha" since="5.0.0">
   The character encoding to use for sending and retrieving TEXT, MEDIUMTEXT and LONGTEXT values instead of the configured connection characterEncoding
 </Property>
 <Property name="clobberStreamingResults" required="No" default="false" sortOrder="alpha" since="3.0.9">
   This will cause a 'streaming' ResultSet to be automatically closed, and any outstanding data still streaming from the server to be discarded if another query is executed before all the data has been read from the server.
 </Property>
 <Property name="compensateOnDuplicateKeyUpdateCounts" required="No" default="false" sortOrder="alpha" since="5.1.7">
   Should the driver compensate for the update counts of "ON DUPLICATE KEY" INSERT statements (2 = 1, 0 = 1) when using prepared statements?
 </Property>
 <Property name="continueBatchOnError" required="No" default="true" sortOrder="alpha" since="3.0.3">
   Should the driver continue processing batch commands if one statement fails. The JDBC spec allows either way (defaults to 'true').
 </Property>
 <Property name="createDatabaseIfNotExist" required="No" default="false" sortOrder="alpha" since="3.1.9">
   Creates the database given in the URL if it doesn't yet exist. Assumes the configured user has permissions to create databases.
 </Property>
 <Property name="emptyStringsConvertToZero" required="No" default="true" sortOrder="alpha" since="3.1.8">
   Should the driver allow conversions from empty string fields to numeric values of '0'?
 </Property>
 <Property name="emulateLocators" required="No" default="false" sortOrder="alpha" since="3.1.0">
   Should the driver emulate java.sql.Blobs with locators? With this feature enabled, the driver will delay loading the actual Blob data until the one of the retrieval methods (getInputStream(), getBytes(), and so forth) on the blob data stream has been accessed. For this to work, you must use a column alias with the value of the column to the actual name of the Blob. The feature also has the following restrictions: The SELECT that created the result set must reference only one table, the table must have a primary key; the SELECT must alias the original blob column name, specified as a string, to an alternate name; the SELECT must cover all columns that make up the primary key.
 </Property>
 <Property name="emulateUnsupportedPstmts" required="No" default="true" sortOrder="alpha" since="3.1.7">
   Should the driver detect prepared statements that are not supported by the server, and replace them with client-side emulated versions?
 </Property>
 <Property name="exceptionInterceptors" required="No" default="" sortOrder="alpha" since="5.1.8">
   Comma-delimited list of classes that implement com.mysql.jdbc.ExceptionInterceptor. These classes will be instantiated one per Connection instance, and all SQLExceptions thrown by the driver will be allowed to be intercepted by these interceptors, in a chained fashion, with the first class listed as the head of the chain.
 </Property>
 <Property name="functionsNeverReturnBlobs" required="No" default="false" sortOrder="alpha" since="5.0.8">
   Should the driver always treat data from functions returning BLOBs as Strings - specifically to work around dubious metadata returned by the server for GROUP BY clauses?
 </Property>
 <Property name="generateSimpleParameterMetadata" required="No" default="false" sortOrder="alpha" since="5.0.5">
   Should the driver generate simplified parameter metadata for PreparedStatements when no metadata is available either because the server couldn't support preparing the statement, or server-side prepared statements are disabled?
 </Property>
 <Property name="getProceduresReturnsFunctions" required="No" default="true" sortOrder="alpha" since="5.1.26">
   Pre-JDBC4 DatabaseMetaData API has only the getProcedures() and getProcedureColumns() methods, so they return metadata info for both stored procedures and functions. JDBC4 was extended with the getFunctions() and getFunctionColumns() methods and the expected behaviours of previous methods are not well defined. For JDBC4 and higher, default 'true' value of the option means that calls of DatabaseMetaData.getProcedures() and DatabaseMetaData.getProcedureColumns() return metadata for both procedures and functions as before, keeping backward compatibility. Setting this property to 'false' decouples Connector/J from its pre-JDBC4 behaviours for DatabaseMetaData.getProcedures() and DatabaseMetaData.getProcedureColumns(), forcing them to return metadata for procedures only.
 </Property>
 <Property name="ignoreNonTxTables" required="No" default="false" sortOrder="alpha" since="3.0.9">
   Ignore non-transactional table warning for rollback? (defaults to 'false').
 </Property>
 <Property name="jdbcCompliantTruncation" required="No" default="true" sortOrder="alpha" since="3.1.2">
   Should the driver throw java.sql.DataTruncation exceptions when data is truncated as is required by the JDBC specification when connected to a server that supports warnings (MySQL 4.1.0 and newer)? This property has no effect if the server sql-mode includes STRICT_TRANS_TABLES.
 </Property>
 <Property name="loadBalanceAutoCommitStatementRegex" required="No" default="" sortOrder="alpha" since="5.1.15">
   When load-balancing is enabled for auto-commit statements (via loadBalanceAutoCommitStatementThreshold), the statement counter will only increment when the SQL matches the regular expression.  By default, every statement issued matches.
 </Property>
 <Property name="loadBalanceAutoCommitStatementThreshold" required="No" default="0" sortOrder="alpha" since="5.1.15">
   When auto-commit is enabled, the number of statements which should be executed before triggering load-balancing to rebalance.  Default value of 0 causes load-balanced connections to only rebalance when exceptions are encountered, or auto-commit is disabled and transactions are explicitly committed or rolled back.
 </Property>
 <Property name="loadBalanceBlacklistTimeout" required="No" default="0" sortOrder="alpha" since="5.1.0">
   Time in milliseconds between checks of servers which are unavailable, by controlling how long a server lives in the global blacklist.
 </Property>
 <Property name="loadBalanceConnectionGroup" required="No" default="" sortOrder="alpha" since="5.1.13">
   Logical group of load-balanced connections within a classloader, used to manage different groups independently.  If not specified, live management of load-balanced connections is disabled.
 </Property>
 <Property name="loadBalanceExceptionChecker" required="No" default="com.mysql.jdbc.StandardLoadBalanceExceptionChecker" sortOrder="alpha" since="5.1.13">
   Fully-qualified class name of custom exception checker.  The class must implement com.mysql.jdbc.LoadBalanceExceptionChecker interface, and is used to inspect SQLExceptions and determine whether they should trigger fail-over to another host in a load-balanced deployment.
 </Property>
 <Property name="loadBalancePingTimeout" required="No" default="0" sortOrder="alpha" since="5.1.13">
   Time in milliseconds to wait for ping response from each of load-balanced physical connections when using load-balanced Connection.
 </Property>
 <Property name="loadBalanceSQLExceptionSubclassFailover" required="No" default="" sortOrder="alpha" since="5.1.13">
   Comma-delimited list of classes/interfaces used by default load-balanced exception checker to determine whether a given SQLException should trigger failover.  The comparison is done using Class.isInstance(SQLException) using the thrown SQLException.
 </Property>
 <Property name="loadBalanceSQLStateFailover" required="No" default="" sortOrder="alpha" since="5.1.13">
   Comma-delimited list of SQLState codes used by default load-balanced exception checker to determine whether a given SQLException should trigger failover.  The SQLState of a given SQLException is evaluated to determine whether it begins with any value in the comma-delimited list.
 </Property>
 <Property name="loadBalanceValidateConnectionOnSwapServer" required="No" default="false" sortOrder="alpha" since="5.1.13">
   Should the load-balanced Connection explicitly check whether the connection is live when swapping to a new physical connection at commit/rollback?
 </Property>
 <Property name="maxRows" required="No" default="-1" sortOrder="alpha" since="all versions">
   The maximum number of rows to return (0, the default means return all rows).
 </Property>
 <Property name="netTimeoutForStreamingResults" required="No" default="600" sortOrder="alpha" since="5.1.0">
   What value should the driver automatically set the server setting 'net_write_timeout' to when the streaming result sets feature is in use? (value has unit of seconds, the value '0' means the driver will not try and adjust this value)
 </Property>
 <Property name="noAccessToProcedureBodies" required="No" default="false" sortOrder="alpha" since="5.0.3">
   When determining procedure parameter types for CallableStatements, and the connected user  can't access procedure bodies through "SHOW CREATE PROCEDURE" or select on mysql.proc  should the driver instead create basic metadata (all parameters reported as IN VARCHARs, but allowing registerOutParameter() to be called on them anyway) instead  of throwing an exception?
 </Property>
 <Property name="noDatetimeStringSync" required="No" default="false" sortOrder="alpha" since="3.1.7">
   Don't ensure that ResultSet.getDatetimeType().toString().equals(ResultSet.getString())
 </Property>
 <Property name="noTimezoneConversionForTimeType" required="No" default="false" sortOrder="alpha" since="5.0.0">
   Don't convert TIME values using the server timezone if 'useTimezone'='true'
 </Property>
 <Property name="nullCatalogMeansCurrent" required="No" default="true" sortOrder="alpha" since="3.1.8">
   When DatabaseMetadataMethods ask for a 'catalog' parameter, does the value null mean use the current catalog? (this is not JDBC-compliant, but follows legacy behavior from earlier versions of the driver)
 </Property>
 <Property name="nullNamePatternMatchesAll" required="No" default="true" sortOrder="alpha" since="3.1.8">
   Should DatabaseMetaData methods that accept *pattern parameters treat null the same as '%' (this is not JDBC-compliant, however older versions of the driver accepted this departure from the specification)
 </Property>
 <Property name="overrideSupportsIntegrityEnhancementFacility" required="No" default="false" sortOrder="alpha" since="3.1.12">
   Should the driver return "true" for DatabaseMetaData.supportsIntegrityEnhancementFacility() even if the database doesn't support it to workaround applications that require this method to return "true" to signal support of foreign keys, even though the SQL specification states that this facility contains much more than just foreign key support (one such application being OpenOffice)?
 </Property>
 <Property name="padCharsWithSpace" required="No" default="false" sortOrder="alpha" since="5.0.6">
   If a result set column has the CHAR type and the value does not fill the amount of characters specified in the DDL for the column, should the driver pad the remaining characters with space (for ANSI compliance)?
 </Property>
 <Property name="pedantic" required="No" default="false" sortOrder="alpha" since="3.0.0">
   Follow the JDBC spec to the letter.
 </Property>
 <Property name="pinGlobalTxToPhysicalConn

Bueno, tengo una base de datos llamada bd1, y una tabla que se llama codigo. Necesito saber como hacer para que cuando apriete un boton, se compruebe si ese codigo existe en la db.

Ya me lo había puesto m1t$u, lo intente de cuarenta formas, y no pude. Me quedé ahí:

Código (php) [Seleccionar] Expandir

if (e.getSource()==boton2)
        {
           Class.forName("com.mysql.jdbc.Driver");
           Connection conexion = DriverManager.getConnection("jdbc:mysql://localhost/bd1", "root", "");
           Statement st = conexion.createStatement();
               ResultSet rs = st.executeQuery("SELECT * FROM codigo  where "+textfield1+"= '"+codigo+"'");
       
       
       
        }

El JTextField se llama: textfield1

Hola, tengo un problema.

Supongamos que tengo este code:

Código [Seleccionar] Expandir

import javax.swing.*;
import java.awt.event.*;
public class Formulario extends JFrame implements ActionListener{
    private JTextField textfield1;
    private JLabel label1;
    private JButton boton1;
    public Formulario() {
        setLayout(null);
        label1=new JLabel("Usuario:");
        label1.setBounds(10,10,100,30);
        add(label1);
        textfield1=new JTextField();
        textfield1.setBounds(120,10,150,20);
        add(textfield1);
        boton1=new JButton("Aceptar");
        boton1.setBounds(10,80,100,30);
        add(boton1);
        boton1.addActionListener(this);
    }
   
    public static void main(String[] ar) {
        Formulario formulario1=new Formulario();
        formulario1.setBounds(0,0,300,150);
        formulario1.setVisible(true);
    }
}

Como hago para que cuando apriete aceptar, se conecte a una mysql y compruebe si ese nombre de usuario existe?

Gracias!