jdbc driver for mysql
Sponsored Links
Sponsored Links
Secleted [ 0 ] software to compare
Results 1 - 15 of about 2440
JDBC Driver for SQLite 006
JDBC Driver for SQLite is a thin layer on top of the SQLite 3.3.x C API. more>>
JDBC Driver for SQLite is a thin layer on top of the SQLite 3.3.x C API. The native JNI library has SQLite compiled into it so all you need to do is include the two files packaged above in your project.
Usage:
Download the binary for the platform you are developing on. Open the tarball and copy the two files into your application directory:
sqlitejdbc.jar
[lib]sqlitejdbc.[dll, so, jnilib]
Reference the driver in your code:
Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:filename");
// ... use the database ...
conn.close();
And call your program with the drivers JAR file in the classpath and the C library in the librarypath. E.g.
java -cp lib/yourprog.jar:lib/sqlitejdbc.jar
-Djava.library.path=lib
yourprog.Main
Enhancements:
- The driver is now thread-safe and fully supports UTF-16.
- There are binaries for Mac OS, Linux, and Windows, and instructions for compiling with MSVC.
<<lessUsage:
Download the binary for the platform you are developing on. Open the tarball and copy the two files into your application directory:
sqlitejdbc.jar
[lib]sqlitejdbc.[dll, so, jnilib]
Reference the driver in your code:
Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:filename");
// ... use the database ...
conn.close();
And call your program with the drivers JAR file in the classpath and the C library in the librarypath. E.g.
java -cp lib/yourprog.jar:lib/sqlitejdbc.jar
-Djava.library.path=lib
yourprog.Main
Enhancements:
- The driver is now thread-safe and fully supports UTF-16.
- There are binaries for Mac OS, Linux, and Windows, and instructions for compiling with MSVC.
Download (0.016MB)
Added: 2006-08-05 License: BSD License Price:
705 downloads
Zmanda Recovery Manager for MySQL 1.2.1
Zmanda Recovery Manager for MySQL simplifies life of a database administrator who needs an easy to use backup solution. more>>
Zmanda Recovery Manager for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server. With ZRM for MySQL you can:
- Schedule full and incremental logical or raw backups of your MySQL database
- Perform backup that is the best match for your storage engine and your MySQL configuration
- Get e-mail notification about status of your backups
- Monitor and browse your backups
- Recover database easily to any point in time or to any particular transaction
<<less- Schedule full and incremental logical or raw backups of your MySQL database
- Perform backup that is the best match for your storage engine and your MySQL configuration
- Get e-mail notification about status of your backups
- Monitor and browse your backups
- Recover database easily to any point in time or to any particular transaction
Download (0.10MB)
Added: 2007-08-02 License: GPL (GNU General Public License) Price:
813 downloads
Web Service Engine for MySQL 0.4
Web Service Engine for MySQL is a storage engine for the MySQL database. more>>
Web Service Engine for MySQL is a storage engine for the MySQL database. The project takes basic SQL and translates this through the engine interface into HTTP request methods.
This gives you the ability to create, read, and delete pages on Web servers. Wikipedia becomes a table you can select on from your database.
Enhancements:
- Multiple attributes per table are now supported.
- The engine now handles tables with more than two columns by generating XML that is stored on the remote server.
- Tables with only two columns are stored as before, with the non-keyed attribute being directly provided to the remote provider.
<<lessThis gives you the ability to create, read, and delete pages on Web servers. Wikipedia becomes a table you can select on from your database.
Enhancements:
- Multiple attributes per table are now supported.
- The engine now handles tables with more than two columns by generating XML that is stored on the remote server.
- Tables with only two columns are stored as before, with the non-keyed attribute being directly provided to the remote provider.
Download (0.29MB)
Added: 2007-06-29 License: GPL (GNU General Public License) Price:
849 downloads
HDBC ODBC Driver 1.0.1.1
HDBC ODBC Driver is the Haskell ODBC backend driver for HDBC. more>>
HDBC ODBC Driver is the Haskell ODBC backend driver for HDBC. This driver has been tested on Windows and on Linux with unixODBC. It should also be compatible with iODBC, though this has not been tested. It should be portable to any platform supported by both Haskell and unixODBC.
This driver is the preferred method of communicating with MySQL from Haskell.
MYSQL NOTE
Important note for MySQL users:
Unless you are going to use InnoDB tables, you are strongly encouraged to set
Option = 262144
in your odbc.ini (for Unix users), or to disable transaction support in your DSN setup for Windows users.
If you fail to do this, the MySQL ODBC driver will incorrectly state that it
supports transactions. dbTransactionSupport will incorrectly return True. commit and rollback will then silently fail. This is certainly /NOT/ what you want. It is a bug (or misfeature) in the MySQL driver, not in HDBC.
You should ignore this advice if you are using InnoDB tables.
<<lessThis driver is the preferred method of communicating with MySQL from Haskell.
MYSQL NOTE
Important note for MySQL users:
Unless you are going to use InnoDB tables, you are strongly encouraged to set
Option = 262144
in your odbc.ini (for Unix users), or to disable transaction support in your DSN setup for Windows users.
If you fail to do this, the MySQL ODBC driver will incorrectly state that it
supports transactions. dbTransactionSupport will incorrectly return True. commit and rollback will then silently fail. This is certainly /NOT/ what you want. It is a bug (or misfeature) in the MySQL driver, not in HDBC.
You should ignore this advice if you are using InnoDB tables.
Download (0.036MB)
Added: 2007-03-09 License: LGPL (GNU Lesser General Public License) Price:
959 downloads
Memcache Engine for MySQL 0.6
Memcache Engine for MySQL project allows memcache to work as a storage engine to MySQL. more>>
Memcache Engine for MySQL project allows memcache to work as a storage engine to MySQL.
This means that you can SELECT/UPDATE/ INSERTE/DELETE from it as though it is a table in MySQL. This is very experimental.
This is still very experimental.
Memcached is a high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load.
Enhancements:
- Support for discovery of tables was added.
- Row level locks were implemented.
- A major bug in duplicate keys was fixed, along with phantom rows for updates.
- The server status has been updated.
<<lessThis means that you can SELECT/UPDATE/ INSERTE/DELETE from it as though it is a table in MySQL. This is very experimental.
This is still very experimental.
Memcached is a high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load.
Enhancements:
- Support for discovery of tables was added.
- Row level locks were implemented.
- A major bug in duplicate keys was fixed, along with phantom rows for updates.
- The server status has been updated.
Download (0.29MB)
Added: 2007-04-10 License: GPL (GNU General Public License) Price:
932 downloads
Skeleton Engine for MySQL 0.4
Skeleton Engine for MySQL is a full framework to plug in a new storage engine. more>>
Skeleton Engine for MySQL is a full framework to plug in a new storage engine. Comes with prebuild autoconf files, and a full framework to plug in your own design.
The AWS, HTTP, Memcache, Nitro, PBXT, and many other engines were put together from the skeleton engine.
To install, grab a copy of the mysql source code and run this:
./configure --with-mysql=/home/brian/mysql-5.1/ --libdir=/usr/local/lib/mysql/
make install
And then inside of MySQL:
mysql> INSTALL PLUGIN skeleton SONAME libskeleton_engine.so;
mysql> CREATE TABLE `d` (`a` varchar(125), b text, primary key(a)) ENGINE=skeleton DEFAULT
CHARSET=latin1;
Query OK, 0 rows affected (0.01 sec)
You will probably need to edit the Makefile.am in the src/ tree if you want to build on anything other then Linux (and the Makefile assumes that the server was not compiled for debug).
<<lessThe AWS, HTTP, Memcache, Nitro, PBXT, and many other engines were put together from the skeleton engine.
To install, grab a copy of the mysql source code and run this:
./configure --with-mysql=/home/brian/mysql-5.1/ --libdir=/usr/local/lib/mysql/
make install
And then inside of MySQL:
mysql> INSTALL PLUGIN skeleton SONAME libskeleton_engine.so;
mysql> CREATE TABLE `d` (`a` varchar(125), b text, primary key(a)) ENGINE=skeleton DEFAULT
CHARSET=latin1;
Query OK, 0 rows affected (0.01 sec)
You will probably need to edit the Makefile.am in the src/ tree if you want to build on anything other then Linux (and the Makefile assumes that the server was not compiled for debug).
Download (0.29MB)
Added: 2007-07-17 License: BSD License Price:
831 downloads
DBD::mysql 4.004
DBD::mysql is a Perl module with MySQL driver for the Perl5 Database Interface (DBI). more>>
DBD::mysql is a Perl module with MySQL driver for the Perl5 Database Interface (DBI).
SYNOPSIS
use DBI;
$dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";
$dbh = DBI->connect($dsn, $user, $password);
$drh = DBI->install_driver("mysql");
@databases = DBI->data_sources("mysql");
or
@databases = DBI->data_sources("mysql",
{"host" => $host, "port" => $port});
$sth = $dbh->prepare("SELECT * FROM foo WHERE bla");
or
$sth = $dbh->prepare("LISTFIELDS $table");
or
$sth = $dbh->prepare("LISTINDEX $table $index");
$sth->execute;
$numRows = $sth->rows;
$numFields = $sth->{NUM_OF_FIELDS};
$sth->finish;
$rc = $drh->func(createdb, $database, $host, $user, $password, admin);
$rc = $drh->func(dropdb, $database, $host, $user, $password, admin);
$rc = $drh->func(shutdown, $host, $user, $password, admin);
$rc = $drh->func(reload, $host, $user, $password, admin);
$rc = $dbh->func(createdb, $database, admin);
$rc = $dbh->func(dropdb, $database, admin);
$rc = $dbh->func(shutdown, admin);
$rc = $dbh->func(reload, admin);
EXAMPLE
#!/usr/bin/perl
use strict;
use DBI();
# Connect to the database.
my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost",
"joe", "joes password",
{RaiseError => 1});
# Drop table foo. This may fail, if foo doesnt exist.
# Thus we put an eval around it.
eval { $dbh->do("DROP TABLE foo") };
print "Dropping foo failed: $@n" if $@;
# Create a new table foo. This must not fail, thus we dont
# catch errors.
$dbh->do("CREATE TABLE foo (id INTEGER, name VARCHAR(20))");
# INSERT some data into foo. We are using $dbh->quote() for
# quoting the name.
$dbh->do("INSERT INTO foo VALUES (1, " . $dbh->quote("Tim") . ")");
# Same thing, but using placeholders
$dbh->do("INSERT INTO foo VALUES (?, ?)", undef, 2, "Jochen");
# Now retrieve data from the table.
my $sth = $dbh->prepare("SELECT * FROM foo");
$sth->execute();
while (my $ref = $sth->fetchrow_hashref()) {
print "Found a row: id = $ref->{id}, name = $ref->{name}n";
}
$sth->finish();
# Disconnect from the database.
$dbh->disconnect();
DBD::mysql is the Perl5 Database Interface driver for the MySQL database. In other words: DBD::mysql is an interface between the Perl programming language and the MySQL programming API that comes with the MySQL relational database management system. Most functions provided by this programming API are supported. Some rarely used functions are missing, mainly because noone ever requested them.
<<lessSYNOPSIS
use DBI;
$dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";
$dbh = DBI->connect($dsn, $user, $password);
$drh = DBI->install_driver("mysql");
@databases = DBI->data_sources("mysql");
or
@databases = DBI->data_sources("mysql",
{"host" => $host, "port" => $port});
$sth = $dbh->prepare("SELECT * FROM foo WHERE bla");
or
$sth = $dbh->prepare("LISTFIELDS $table");
or
$sth = $dbh->prepare("LISTINDEX $table $index");
$sth->execute;
$numRows = $sth->rows;
$numFields = $sth->{NUM_OF_FIELDS};
$sth->finish;
$rc = $drh->func(createdb, $database, $host, $user, $password, admin);
$rc = $drh->func(dropdb, $database, $host, $user, $password, admin);
$rc = $drh->func(shutdown, $host, $user, $password, admin);
$rc = $drh->func(reload, $host, $user, $password, admin);
$rc = $dbh->func(createdb, $database, admin);
$rc = $dbh->func(dropdb, $database, admin);
$rc = $dbh->func(shutdown, admin);
$rc = $dbh->func(reload, admin);
EXAMPLE
#!/usr/bin/perl
use strict;
use DBI();
# Connect to the database.
my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost",
"joe", "joes password",
{RaiseError => 1});
# Drop table foo. This may fail, if foo doesnt exist.
# Thus we put an eval around it.
eval { $dbh->do("DROP TABLE foo") };
print "Dropping foo failed: $@n" if $@;
# Create a new table foo. This must not fail, thus we dont
# catch errors.
$dbh->do("CREATE TABLE foo (id INTEGER, name VARCHAR(20))");
# INSERT some data into foo. We are using $dbh->quote() for
# quoting the name.
$dbh->do("INSERT INTO foo VALUES (1, " . $dbh->quote("Tim") . ")");
# Same thing, but using placeholders
$dbh->do("INSERT INTO foo VALUES (?, ?)", undef, 2, "Jochen");
# Now retrieve data from the table.
my $sth = $dbh->prepare("SELECT * FROM foo");
$sth->execute();
while (my $ref = $sth->fetchrow_hashref()) {
print "Found a row: id = $ref->{id}, name = $ref->{name}n";
}
$sth->finish();
# Disconnect from the database.
$dbh->disconnect();
DBD::mysql is the Perl5 Database Interface driver for the MySQL database. In other words: DBD::mysql is an interface between the Perl programming language and the MySQL programming API that comes with the MySQL relational database management system. Most functions provided by this programming API are supported. Some rarely used functions are missing, mainly because noone ever requested them.
Download (0.11MB)
Added: 2007-03-23 License: Perl Artistic License Price:
562 downloads
mod_dbd_mysql 0.1
mod_dbd_mysql is a DBD Driver module for MySQL. more>>
mod_dbd_mysql is a DBD Driver module for MySQL. To replace mod_mysql_pool
Main features:
- Dynamic connection pooling for scalable applications.
- Persistent Connection for non-threaded MPMs and legacy applications.
- Single-use connections for debugging or low-usage applications.
- Database-independent framework with driver (DBD) modules for different databases.
- SQL namespace module for direct database access in HTML or XML pages with mod_publisher or mod_xmlns.
apr_dbd
The apr_dbd framework presents a common API for different SQL database engines. The API is documented in apr_dbd.h.
DBD Drivers
APR DBD Drivers are currently available for MySQL and PostgreSQL. The apr_dbd architecture supports dynamic loading of database driver modules, so that new drivers can be installed at any time, without any requirement to recompile APR (provided the platform supports dynamic loading).
mod_dbd
mod_dbd presents the API for Apache modules, and deals with managing database connections efficiently for both threaded and non-threaded MPMs.
mod_sql
mod_sql is an XML Namespace Module that builds on mod_dbd to implement SQL handling in XML applications with mod_publisher or mod_xmlns.
<<lessMain features:
- Dynamic connection pooling for scalable applications.
- Persistent Connection for non-threaded MPMs and legacy applications.
- Single-use connections for debugging or low-usage applications.
- Database-independent framework with driver (DBD) modules for different databases.
- SQL namespace module for direct database access in HTML or XML pages with mod_publisher or mod_xmlns.
apr_dbd
The apr_dbd framework presents a common API for different SQL database engines. The API is documented in apr_dbd.h.
DBD Drivers
APR DBD Drivers are currently available for MySQL and PostgreSQL. The apr_dbd architecture supports dynamic loading of database driver modules, so that new drivers can be installed at any time, without any requirement to recompile APR (provided the platform supports dynamic loading).
mod_dbd
mod_dbd presents the API for Apache modules, and deals with managing database connections efficiently for both threaded and non-threaded MPMs.
mod_sql
mod_sql is an XML Namespace Module that builds on mod_dbd to implement SQL handling in XML applications with mod_publisher or mod_xmlns.
Download (0.020MB)
Added: 2006-05-19 License: GPL (GNU General Public License) Price:
1255 downloads
MaxDB by MySQL 7.5.00.44
MaxDB by MySQL is the database backend for MySAP. more>>
MaxDB is a heavy-duty, SAP-certified open source database for OLTP and OLAP usage which offers high reliability, availability, scalability and a very comprehensive feature set. MaxDB by MySQL is targetted for large mySAP Business Suite environments and other applications that require maximum enterprise-level database functionality and complements the MySQL database server.
Today, about 6,000 customer installations are using MaxDB technology globally, including Toyota, Intel, DaimlerChrysler, Braun-Gillette, Bayer, Colgate, Yamaha, and Deutsche Post (the German Post Office).
Enhancements:
- Bugs were fixed.
<<lessToday, about 6,000 customer installations are using MaxDB technology globally, including Toyota, Intel, DaimlerChrysler, Braun-Gillette, Bayer, Colgate, Yamaha, and Deutsche Post (the German Post Office).
Enhancements:
- Bugs were fixed.
Download (78MB)
Added: 2007-07-14 License: GPL (GNU General Public License) Price:
839 downloads
guile-dbd-mysql 2.0.0
guile-dbd-mysql project is a MySQL database driver for the Guile DBI system. more>>
guile-dbd-mysql project is a MySQL database driver for the Guile DBI system.
guile-dbi is a database generic interface. Provide a way to use dbds (data base drivers) which are linked at run-time (like perl dbi or php or...) for query different database engines always in the same way.
Enhancements:
- The API has been upgraded to Guile 1.8.
<<lessguile-dbi is a database generic interface. Provide a way to use dbds (data base drivers) which are linked at run-time (like perl dbi or php or...) for query different database engines always in the same way.
Enhancements:
- The API has been upgraded to Guile 1.8.
Download (0.30MB)
Added: 2006-09-28 License: GPL (GNU General Public License) Price:
1121 downloads
JDBC SQL Profiler 0.3
JDBC SQL Profiler is a Swing-based GUI tool to recommend database index creation. more>>
JDBC SQL Profiler is a quickly hacked tool to do statistics on SELECT queries in order to know where it is most efficient to create indexes.
This small tool, released under an Apache-based license connects to the P6Spy JDBC logger and displays in real time the queries going to the database. It uses an integrated SQL parser to build statistics on the most accessed tables and columns and can generate SQL index creation files.
Other information is also gathered and displayed, such as the request time for a single request, for a class of request, and for all the requests. Sorting may be done on these views to detect database problems efficiently.
This tool can be very useful when you have a big volume of queries that you need to analyze not one by one (meaning that the specific time isnt that much of interest), but rather when you want to know what "group" of queries is taking a lot of time, such as queries on the same tables and columns but with different query values. The integrated SQL parser (built with ANTLR) is used to analyze the incoming SELECT queries.
The Swing GUI was based on Apaches Log4J Chainsaw, but all the bugs are mine. Also contributors are welcome to test, make new suggestions, give their opinion and submit patches.
<<lessThis small tool, released under an Apache-based license connects to the P6Spy JDBC logger and displays in real time the queries going to the database. It uses an integrated SQL parser to build statistics on the most accessed tables and columns and can generate SQL index creation files.
Other information is also gathered and displayed, such as the request time for a single request, for a class of request, and for all the requests. Sorting may be done on these views to detect database problems efficiently.
This tool can be very useful when you have a big volume of queries that you need to analyze not one by one (meaning that the specific time isnt that much of interest), but rather when you want to know what "group" of queries is taking a lot of time, such as queries on the same tables and columns but with different query values. The integrated SQL parser (built with ANTLR) is used to analyze the incoming SELECT queries.
The Swing GUI was based on Apaches Log4J Chainsaw, but all the bugs are mine. Also contributors are welcome to test, make new suggestions, give their opinion and submit patches.
Download (1.0MB)
Added: 2005-04-28 License: The Apache License Price:
1644 downloads
DBD::mSQL 1.2219
DBD::mSQL / DBD::mysql is a Perl module with mSQL and mysql drivers for the Perl5 Database Interface (DBI). more>>
DBD::mSQL / DBD::mysql is a Perl module with mSQL and mysql drivers for the Perl5 Database Interface (DBI).
SYNOPSIS
use DBI;
$driver = "mSQL"; # or "mSQL1";
$dsn = "DBI:$driver:database=$database;host=$hostname";
$dbh = DBI->connect($dsn, undef, undef);
or
$driver = "mysql";
$dsn = "DBI:$driver:database=$database;host=$hostname;port=$port";
$dbh = DBI->connect($dsn, $user, $password);
$drh = DBI->install_driver("mysql");
@databases = $drh->func($host, $port, _ListDBs);
@tables = $dbh->func( _ListTables );
$sth = $dbh->prepare("SELECT * FROM foo WHERE bla");
or
$sth = $dbh->prepare("LISTFIELDS $table");
or
$sth = $dbh->prepare("LISTINDEX $table $index");
$sth->execute;
$numRows = $sth->rows;
$numFields = $sth->{NUM_OF_FIELDS};
$sth->finish;
$rc = $drh->func(createdb, $database, $host, $user, $password, admin);
$rc = $drh->func(dropdb, $database, $host, $user, $password, admin);
$rc = $drh->func(shutdown, $host, $user, $password, admin);
$rc = $drh->func(reload, $host, $user, $password, admin);
$rc = $dbh->func(createdb, $database, admin);
$rc = $dbh->func(dropdb, $database, admin);
$rc = $dbh->func(shutdown, admin);
$rc = $dbh->func(reload, admin);
EXAMPLE
#!/usr/bin/perl
use strict;
use DBI();
# Connect to the database.
my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost",
"joe", "joes password",
{RaiseError => 1});
# Drop table foo. This may fail, if foo doesnt exist.
# Thus we put an eval around it.
eval { $dbh->do("DROP TABLE foo") };
print "Dropping foo failed: $@n" if $@;
# Create a new table foo. This must not fail, thus we dont
# catch errors.
$dbh->do("CREATE TABLE foo (id INTEGER, name VARCHAR(20))");
# INSERT some data into foo. We are using $dbh->quote() for
# quoting the name.
$dbh->do("INSERT INTO foo VALUES (1, " . $dbh->quote("Tim") . ")");
# Same thing, but using placeholders
$dbh->do("INSERT INTO foo VALUES (?, ?)", undef, 2, "Jochen");
# Now retrieve data from the table.
my $sth = $dbh->prepare("SELECT * FROM foo");
$sth->execute();
while (my $ref = $sth->fetchrow_hashref()) {
print "Found a row: id = $ref->{id}, name = $ref->{name}n";
}
$sth->finish();
# Disconnect from the database.
$dbh->disconnect();
DBD::mysql and DBD::mSQL are the Perl5 Database Interface drivers for the mysql, mSQL 1.x and mSQL 2.x databases. The drivers are part of the Msql-Mysql-modules package.
In other words: DBD::mSQL and DBD::mysql are an interface between the Perl programming language and the mSQL or mysql programming API that come with the mSQL any mysql relational database management systems. Most functions provided by the respective programming APIs are supported. Some rarely used functions are missing, mainly because noone ever requested them.
<<lessSYNOPSIS
use DBI;
$driver = "mSQL"; # or "mSQL1";
$dsn = "DBI:$driver:database=$database;host=$hostname";
$dbh = DBI->connect($dsn, undef, undef);
or
$driver = "mysql";
$dsn = "DBI:$driver:database=$database;host=$hostname;port=$port";
$dbh = DBI->connect($dsn, $user, $password);
$drh = DBI->install_driver("mysql");
@databases = $drh->func($host, $port, _ListDBs);
@tables = $dbh->func( _ListTables );
$sth = $dbh->prepare("SELECT * FROM foo WHERE bla");
or
$sth = $dbh->prepare("LISTFIELDS $table");
or
$sth = $dbh->prepare("LISTINDEX $table $index");
$sth->execute;
$numRows = $sth->rows;
$numFields = $sth->{NUM_OF_FIELDS};
$sth->finish;
$rc = $drh->func(createdb, $database, $host, $user, $password, admin);
$rc = $drh->func(dropdb, $database, $host, $user, $password, admin);
$rc = $drh->func(shutdown, $host, $user, $password, admin);
$rc = $drh->func(reload, $host, $user, $password, admin);
$rc = $dbh->func(createdb, $database, admin);
$rc = $dbh->func(dropdb, $database, admin);
$rc = $dbh->func(shutdown, admin);
$rc = $dbh->func(reload, admin);
EXAMPLE
#!/usr/bin/perl
use strict;
use DBI();
# Connect to the database.
my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost",
"joe", "joes password",
{RaiseError => 1});
# Drop table foo. This may fail, if foo doesnt exist.
# Thus we put an eval around it.
eval { $dbh->do("DROP TABLE foo") };
print "Dropping foo failed: $@n" if $@;
# Create a new table foo. This must not fail, thus we dont
# catch errors.
$dbh->do("CREATE TABLE foo (id INTEGER, name VARCHAR(20))");
# INSERT some data into foo. We are using $dbh->quote() for
# quoting the name.
$dbh->do("INSERT INTO foo VALUES (1, " . $dbh->quote("Tim") . ")");
# Same thing, but using placeholders
$dbh->do("INSERT INTO foo VALUES (?, ?)", undef, 2, "Jochen");
# Now retrieve data from the table.
my $sth = $dbh->prepare("SELECT * FROM foo");
$sth->execute();
while (my $ref = $sth->fetchrow_hashref()) {
print "Found a row: id = $ref->{id}, name = $ref->{name}n";
}
$sth->finish();
# Disconnect from the database.
$dbh->disconnect();
DBD::mysql and DBD::mSQL are the Perl5 Database Interface drivers for the mysql, mSQL 1.x and mSQL 2.x databases. The drivers are part of the Msql-Mysql-modules package.
In other words: DBD::mSQL and DBD::mysql are an interface between the Perl programming language and the mSQL or mysql programming API that come with the mSQL any mysql relational database management systems. Most functions provided by the respective programming APIs are supported. Some rarely used functions are missing, mainly because noone ever requested them.
Download (0.19MB)
Added: 2006-10-05 License: Perl Artistic License Price:
648 downloads
JDatabaseImport 0.1
JDatabaseImport is a simple tool created to import data between different databases. more>>
JDatabaseImport is a simple tool created to import data between different databases.
How does it work?
You can work with it in two ways, either using a configuration file or accessing its api using Java.
Example:
The following code show an example of a file called *export.xml*:
< export >
< from >
< driver >org.hsqldb.jdbcDriver< / driver >
< url >jdbc:hsqldb:hsql://localhost/source< / url >
< username >sa< / username >
< password >mysapass< / password >
< / from >
< to >
< driver >com.mysql.jdbc.Driver< / driver >
< url >jdbc:mysql://localhost/target< / url >
< username >root< / username >
< password >myrootpass< / password >
< / to >
< table name="firstTable"/ >
< table name="secondTable" >
< ignore >fieldToBeIgnored< / ignore >
< / table >
< table name="thirdTable"/ >
< / export >
Note that JDatabaseImport *will not* generate the target tables, but only import data from one source into the other.
In order to run JDatabaseImport, you need to put all drivers in the classpath and run it. The following code is an example on how to use it to import from mysql to hsqldb
java -cp mysql-connector-3.1.1.jar:hsqldb.jar:jdatabaseimport.jar br.com.caelum.jdatabaseimport.Main export.xml
Enhancements:
- This initial release has been tested with hsqldb, MySQL, Derby, and Oracle using some field types and different configurations.
<<lessHow does it work?
You can work with it in two ways, either using a configuration file or accessing its api using Java.
Example:
The following code show an example of a file called *export.xml*:
< export >
< from >
< driver >org.hsqldb.jdbcDriver< / driver >
< url >jdbc:hsqldb:hsql://localhost/source< / url >
< username >sa< / username >
< password >mysapass< / password >
< / from >
< to >
< driver >com.mysql.jdbc.Driver< / driver >
< url >jdbc:mysql://localhost/target< / url >
< username >root< / username >
< password >myrootpass< / password >
< / to >
< table name="firstTable"/ >
< table name="secondTable" >
< ignore >fieldToBeIgnored< / ignore >
< / table >
< table name="thirdTable"/ >
< / export >
Note that JDatabaseImport *will not* generate the target tables, but only import data from one source into the other.
In order to run JDatabaseImport, you need to put all drivers in the classpath and run it. The following code is an example on how to use it to import from mysql to hsqldb
java -cp mysql-connector-3.1.1.jar:hsqldb.jar:jdatabaseimport.jar br.com.caelum.jdatabaseimport.Main export.xml
Enhancements:
- This initial release has been tested with hsqldb, MySQL, Derby, and Oracle using some field types and different configurations.
Download (0.43MB)
Added: 2006-10-12 License: The Apache License 2.0 Price:
1109 downloads
Clevo Mail LED Linux Driver 0.6
Clevo Mail LED Linux Driver operates the mail LED on the Clevo notebook model D4J. more>>
Clevo Mail LED Linux Driver operates the mail LED on the Clevo notebook model D4J.
Enhancements:
- The DMI_BOARD_VENDOR string has been corrected for D410V autodetection.
<<lessEnhancements:
- The DMI_BOARD_VENDOR string has been corrected for D410V autodetection.
Download (0.002MB)
Added: 2007-06-11 License: GPL (GNU General Public License) Price:
867 downloads
JDBC 0.01
JDBC is a Perl 5 interface to Java JDBC (via Inline::Java). more>>
JDBC is a Perl 5 interface to Java JDBC (via Inline::Java).
SYNOPSIS
use JDBC;
JDBC->load_driver("org.apache.derby.jdbc.EmbeddedDriver");
my $con = JDBC->getConnection($url, "test", "test");
my $s = $con->createStatement();
$s->executeUpdate("create table foo (foo int, bar varchar(200), primary key (foo))");
$s->executeUpdate("insert into foo (foo, bar) values (42,notthis)");
$s->executeUpdate("insert into foo (foo, bar) values (43,notthat)");
my $rs = $s->executeQuery("select foo, bar from foo");
while ($rs->next) {
my $foo = $rs->getInt(1);
my $bar = $rs->getString(2);
print "row: foo=$foo, bar=$barn";
}
This JDBC module provides an interface to the Java java.sql.* and javax.sql.* JDBC APIs.
<<lessSYNOPSIS
use JDBC;
JDBC->load_driver("org.apache.derby.jdbc.EmbeddedDriver");
my $con = JDBC->getConnection($url, "test", "test");
my $s = $con->createStatement();
$s->executeUpdate("create table foo (foo int, bar varchar(200), primary key (foo))");
$s->executeUpdate("insert into foo (foo, bar) values (42,notthis)");
$s->executeUpdate("insert into foo (foo, bar) values (43,notthat)");
my $rs = $s->executeQuery("select foo, bar from foo");
while ($rs->next) {
my $foo = $rs->getInt(1);
my $bar = $rs->getString(2);
print "row: foo=$foo, bar=$barn";
}
This JDBC module provides an interface to the Java java.sql.* and javax.sql.* JDBC APIs.
Download (1.9MB)
Added: 2007-06-04 License: Perl Artistic License Price:
874 downloads
Secleted [ 0 ] software to compare
Copyright Notice:
Software piracy is theft, Using crack, password, serial numbers, registration codes, key generators is illegal and prevent future software development. The above jdbc driver for mysql search only lists software in full, demo and trial versions for free download. Download links are directly from our mirror sites or publisher sites, torrent files or links from rapidshare.com, yousendit.com or megaupload.com are not allowed