MYSQL :: Jdbc Over SSL, SAP Business Connector 4.6

Wich Connector Is Faster? (PHP JDBC)
Are there any benchmarks to compare operations on a MySQL Database with mysql(i)
for php and jdbc? We need to develop a big webservice (SOAP) project and we have to decide if we will use java or php. One point is our MySQL database, that will be on its own hardware in our local net. Its a big database with hundreds of Tables. We need features of MySQL 5.0 like transaction, row-based locking, innodb and so on..

Wich conntector will do these jobs faster?

View Replies !

JDBC Error - Javax.servlet.ServletException: Com.mysql.jdbc.driver
I get the following error when trying access my MySQL database from a jsp page.

I have copied the proper jar into the WEB-INF/lib and the /ext path of my CLASSPATH.

Am I misisng something?

+++++++++++++++++++++++++++++++++++++++++++++

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: com.mysql.jdbc.driver
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.ja va:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcesso r.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.ClassNotFoundException: com.mysql.jdbc.driver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java: 1352)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java: 1198)
java.lang.ClassLoader.loadClassInternal(Unknown Source)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
com.mullen.cac.struts.action.TestDB.execute(TestDB.java:30)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcesso r.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.

View Replies !

Calculating Business Days
I need to calculate the number of business days between a pair of arbitrary dates.Some scrounging around online delivered me this query,which basically does the trick:
Quote:SELECT
d1,
d2,
@dow1 := DAYOFWEEK(d1) AS dow1,
@dow2 := DAYOFWEEK(d2) AS dow2,
@days := DATEDIFF(d2,d1) AS Days,
@wknddays := 2 * FLOOR( @days / 7 ) +
if( @dow1 = 1 AND @dow2 > 1, 1,
if( @dow1 = 7 AND @dow2 = 1, 1,
if( @dow1 > 1 AND @dow1 > @dow2, 2,
if( @dow1 < 7 AND @dow2 = 7, 1, 0 )
)
)
) AS WkndDays,
@days - @wkndDays AS BizDays
FROM dates
ORDER BY d1,d2;

View Replies !

Selecting Results From This Business Week
I have a table which has the column 'date_added'. I need a query which returns all of the results which were added in the current week. By this I dont mean today minus 7 days, I mean monday 00.00am to sunday 11.59pm.

Is there a way of doing this? I've looked into WEEK() and YEARWEEK() but cant think of a way to do this using PHP.

Heres what I've got (probably awfully wrong..

PHP

mysql_query("SELECT * FROM table WHERE date_added BETWEEN WEEK(now(), 0) AND WEEK(??)");

View Replies !

How To Reset Yahoo Small Business MySQL Database
I am a new user of "Yahoo Small Business" web hosting service and I changed
a lot of settings in my "MySQL Database" using "phpMyAdmin" utility during my
learning period. Now, I want to reset my Yahoo Small Business MySQL Database
to default settings or to reinstall it (I want it to be the same as it was newly
activated).

Note: I tried to repair my database with Yahoo's "Database Setup" page and the
message "Database scheduled for repair" appeared for a few days but nothing
happened. And, I can not login to my database using "phpMyAdmin" utility.

If you can help me to reset my "Yahoo Small Business - MySQL Database" I will
be very pleased.

View Replies !

About JDBC
Well i work with intellutionÂ´s Proficy line of products and my clientes are using various database manager systems, now MySQL is very popular and i found a lot of clients using it, for progrmas like iFIX there is no problem we just use MyODBC and it is like a walk in the park, but trying to connect it with JDBC to other program (to be exact Proficy portal wich is made totally in Java) at least for me has been impossible.

would anyone please tell me how to connect, install and manage the .jar files under Windows XP? what step am i missing? where do i have to put install or copy this files? is there an application i am not using?

View Replies !

JDBC To MySQL
I wrote a Java program to connect to MySQL using
JDBC ...and it works fine...it connects and it does what is supposed
to do.....however when I use the same program to connect to another
MySQL server (in another machine) then I get an exception: "Server
Configuration Denies access to data source"

View Replies !

Setting The First Row In JDBC
Consider a table with 100 entries in it. Say, I execute the following query from a JAVA application using JDBC: -

SELECT * FROM foo_table LIMIT 10 ORDER BY start_date DESC;

Due to 'LIMIT 10 ORDER BY start_date DESC' it will return me top 10 results.

How can I retrieve the next 10 in some later query, totally independent of any current query? I wish to do something like the Hibernate function Query.setFirstResult(int index); but using JDBC.

View Replies !

JDBC And MySQL
I want to create a Java-Applet, which communicates with a MySQL-Server.

My question:
Is it possible to use a Java-Applet without installing a Driver on the client?
What do I need?

View Replies !

MySQL & JDBC
We currently have mySQL version 4.1.21 on our server. Does a version of JDBC come bundled with mySQL? If so what version is it?

View Replies !

JDBC Install
i have recently installed MySQL 5.0.67 on my Mac OS X 10.5.5. I want to connect my web application to a database. I was hoping that someone might point me in the correct direction to get this sorted.

View Replies !

Comment With JDBC
I'm just experiencing this new database, it's great. I have one question. Is it possible to get the column comment (set by the insert command) with JDBC somewhere in the metadefinitions? ... that would be great because I want to make a generator and could use this for several settings.

View Replies !

Map JDBC Types
I'm setting up a server-application on a tomcat that is developed for SQL Server or Oracle but I got the thankless task of trying to set up the application on a MySQL instead.
One part of setting up this is to port some properties-files and I cannot get the hang of it.
Is there some friendly soul out there that could give me a hand?
I've included the content of properties-files below for SQL Server and I believe you'll get how it should be ported to MySQL. Most part of the content is the same in all three files but I included them all anyway

View Replies !

Mysal / Jdbc
why this code leads to SQLException? with SELECT * from FUNDS all is well.

SELECT FUNDS.ISIN, NAME, COUNTRY_NAME, CURRENCY_ID, UL_1.LOGIN AS CLOGIN,
UL_2.LOGIN AS MLOGIN
FROM FUNDS, COUNTRIES, USER_LIST ALIAS UL_1, USER_LIST ALIAS UL_2
WHERE FUNDS.COUNTRY_ID = COUNTRIES.COUNTRY_ID
AND
CREATOR = UL_1.USER_ID
AND MODIFICATOR = UL_2.USER_ID
UNION
SELECT FUNDS.ISIN, NAME, COUNTRY_NAME, CURRENCY_ID, UL_1.LOGIN AS CLOGIN,
NULL
FROM FUNDS, COUNTRIES, USER_LIST ALIAS UL_1, USER_LIST ALIAS UL_2
WHERE FUNDS.COUNTRY_ID = COUNTRIES.COUNTRY_ID
AND
CREATOR = UL_1.USER_ID
AND MODIFICATOR IS NULL
ORDER BY ISIN;

View Replies !

Classpath For JDBC
Do I need to set a classpath to get a connection between a java program and a database?

If I have to set a classpath in the command prompt in Windows - what must this classpath direct to - the .exe file where mysql is installed on my system?

View Replies !

Com.mysql.jdbc.MysqlDataTruncation:
I just upgraded to MySQL to 4.1.9 and JDBC
mysql-connector-java-3.1.6-bin.jar and now getting the following Exception:

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for
column 'usaCard' at row 1

What causes this exception?

I've set jdbcCompliantTruncation=false for the time being but would like to
understand what causes the Exception.

View Replies !

Com.mysql.jdbc.CommunicationsException
I have the web Application in Spring and Hibernate which is connected to the MySql database through the Jboss Server. I am getting the following error.

com.mysql.jdbc.CommunicationsException: Communications link failure

Do any one has the solution?

View Replies !

Can't Establish JDBC Connection
I'm developing a small java web-app for a client using JSP, Servlets and a MySQL db. The app-server and database are leased from a third party vendor, so all my work is done remotely. I've uploaded my app and am trying to establish a connection but can't. The exception is this:

Access denied for user: 'username@localhost.localdomain' (Using password: YES)

and occurs at line:

Code:

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/database","username","pwd");

View Replies !

How To Use Jdbc To Connect To Database?
I have installed MySQL4.1.9 and installed JDBC driver connect J/3.1 I installed MySQL in C:MySQL and I have copied the "mysql-connector-java-3.1.6-bin.jar" file into <java home>jrelibext , <java runtime environment home>libext and <Tomcat Home> commonlib.

I started up MySQL from the commandline client and created a 'books ' database using "CREATE DATABASE books;". I have also added the statement: GRANT ALL PRIVILEGES ON *.* TO '<user>' IDENTIFIED BY '<password>' WITH GRANT OPTION;

The problem is when I try to use java to access the database via jdbc. I typed the code:
Connection con = null;
Class.forName("org.gjt.mm.mysql.Drive").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost/books ?user=<user>&password=<password>");

It compiles correctly but when i execute the code,it displays: "SQLException: java.sql.SQLException: Incorrect database name 'books ' "

I changed the statement to:
con = DriverManager.getConnection("jdbc:mysql:books ?user=<user>&password=<password>");
but when executing,the message now is: SQLException: java.sql.SQLException: No suitable driver

I have tried checked the jdbc manuel online but the con statement given is about the same. It seems that somehow jdbc cannot find the database and the driver is not recognised also.

View Replies !

JDBC Number Rows
After you have done a .executeQuery() and returned that to a ResultSet how do you get the number of rows returned?
I have tried using getFetchSize() but that does not help me.

View Replies !

Remote Access Using JDBC
I've set up a User account called 'test' for my MySQL database (for use from my Uni). The host value for 'test' is '%' but for some reason I can't connect when accessing the Database from a dynamic dns name.

Test can connect when the JDBC is run using 'localhost' but the connection attempt simply times out when I change the URL to 'bailz.dyndns.org'.

The PC is running behind a router but I can access the web server no problem from outside... it's just MySQL via JDBC that I'm having trouble with.

View Replies !

Jdbc / Odbc Connection
I am running Suse 10.1 and i have MySQL working fine but Im having problems with connecting my Java Application with my Database. I got the recent J Connector drivers but i keep getting the exception about it not being able to find my device driver. The only other thing I was un-able to figre is where is "%Java_home% /jre/lib" is that only for windows?

View Replies !

[java] Jdbc, More Than One Sql Command
I use Connector/J ver. 3.0 (downloaded from mysql.com).

Does anybody know why I cannot execute something like that in my Java
program:

stat.execute("CREATE TABELE a(b int);INSERT INTO a(b) VALUES(1);");
???

something like this works fine:
stat.execute("CREATE TABELE a(b int);");
stat.execute("INSERT INTO a(b) VALUES(1);");

i was trying to change the string:
"CREATE TABELE a(b int);
INSERT INTO a(b) VALUES(1);"
"CREATE TABELE a(b int); INSERT INTO a(b) VALUES(1);"
and nothing works.

Can anyone tell me why this jdbc driver cannot take this??? If I put the
string:
"CREATE TABELE a(b int);INSERT INTO a(b) VALUES(1);"
into mysql console everthing works fine....

I don't get it. I was trying to run it in pg, and evertyhing worked fine.

View Replies !

Configuring MySQL For JDBC ?
I'm having a MySQL DB running on one machine and a Java-Tool which accesses this DB via JDBC. With this tool, I can add a second DB data source in form of a mySQL DB and I've installed one more MySQL DB on a third machine, which runs perfect, but the access from the java-tool via JDBC-connection doesn't work.

Command line "mysql" tool work perfect from the machine where the java tool is running. The company which coded the java-tool told me that I have to install a package for the mysql db which enables jdbc. Is that right and what do I have to configure ?

View Replies !

JDBC Rowcount() Too Much Slow
Does MySql 5.0 go over all records of a InnoDB data base when I ask for RowCount() . It's excessively slow with very much records.

View Replies !

JDBC And Mysql Errors
I developed the java code to create data object's that is created from the class mpcData, the main database connectivity is mpcConnect now when i initially developed the code it compiled error free, soon as i added the classpath to the directory containing the Mysql drivers ( "c:jdbcDriver") in my windows system environment i'm getting error's in the compiling that i cannot find the data object mpcData anymore.

View Replies !

Mysql Jdbc Driver Problem
I am trying to connect to mysql database using connector/J jdbc driver
this is my code

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import java.util.*;

class JdbcTest1 {

public static void main(String[] args) {
// Connection conn = null;
// Statement st = null;
//R........................

View Replies !

Turkish Character With Mysql Jdbc
I have a problem with show to turkish character of the JDBC driver
for MYSQL. I have a mysql database.And It's default-character-set is
latin5.(This is supporting the turkish characters)
I can see Turkish character with database engine programs so as
MySQL Control Center. But I can not display with show to turkish
character of the JDBC driver for MYSQL.

View Replies !

JDBC Driver Licensing And Distribution
We are developing a Report Generator that works with a number of databases.
In order to add support for MySQL, I need to understand the implications of
using the JDBC driver, and the effect it will have on the closed-source
application using it.

The question is: does the application making call on the GPLed JDBC driver
come under GPL? The driver itself is not going to be extended/reworked in
any way, but used "as is".

A related question: can the driver be freely distributed (bundled) with a
commercial application?

I never worked with MySQL, and hope that someone could shed some light on
this issue.

View Replies !

Installation :: Unable To Connect Using JDBC
I am a MySQL newbee and have run into problems straight. I installed MySQL 4.1 on Win XP with the help of Installer. Everything worked fine and I made a database and some tables also.
When I was trying to connect with the database through JDBC program, It shows exception that it can't connect to server.

I tried to reconfigure the instance. There is MySQL Database configuration wizard. I used this thing.

I set up a root password and enabled TCP/IP networking. In the final stage it showed a error message, (I am not recalling the entire message properly.)

could not allow root@localhost(Using password:Yes). It seems there is a personal firewall running in your computer. Disable it and press retry.

There is no firewall on my comp. When i start command line client it asks the password and when I enter it and press enter it exits without any message.

View Replies !

View Creation And Jdbc Driver
Does someone know if it is possible to create a view on a table with the 4.0.18 mysql version ? And does someone know which Jdbc driver to use with the 4.0.18 mysql version ?

View Replies !

Timestamp Not Updating Thru Java/JDBC
I'm doing updates to records thru Java and JDBC but the timestamp field doesn't update.

An example:
Address has only two fields
Line1 - varchar(40)
UpdateTime - timestamp

ResultSet rs = this.doQuery("SELECT * FROM address WHERE address.key = 1", true);
rs.updateString("Line1", "street addr");
rs.updateRow();
The above does not UpdateTime

If however I do a query
"Update address set line1 = 'street addr' where address.key = 1"
Then the timestamp is updated.

View Replies !

J Connector Jdk / Jre
My application uses J Connector's 'mysql-connector-java-3.1.6-bin.jar'
file with jdk 1.5 on my Win 2000 system to connect to MySQL running on a
Linux machine on my LAN and it works fine from within JDK. However it does
not work (does not register the 'MySQL J Connector' driver) if I run my
application's jar file using JRE 1.5 which is also installed on my Win
2000 system.

Can J Connector's 'mysql-connector-java-3.1.6-bin.jar' somehow be built
into my application's jar file? Or should it just be placed somewhere in
the JRE directory tree and, if so, then where?

View Replies !

.net 2.0 Connector
About to develop an asp .net site on a windows 2003 server. I am using
Visual Basic .net 2005 to constuct the site. What type of connection to
mySQL should I use - e.g. ODBC or mySQL's .net connector?

View Replies !

Connector/J Using JSP
we've installed MySQL on a Windows XP machine, but cannot connect to it
using JSP/Servlet. An error message comes up saying:

java.sql.SQLException: General error, message from server: "Incorrect
database name 'water'"
The database water exists on the server.

Class.forName( "com.mysql.jdbc.Driver" ).newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost/water
?user=root&password=");

yes, we've tried different databases and the error persists;
yes, we've tried different users and passwords and the error persists;
yes, we looked at the Connector/J documentation and sintax and it is OK
yes, we used google and search for errors but no luc. Code:

View Replies !

ASP Connector
I have set up a DSN connection on my local server. The test connections works fine.
It is connecting to an external mysql database.

However when I try to connect using a script it gives me a connection error I am using asp 2.0 and the latest mysql driver for ODBC The code is as follows: Code:

View Replies !

PHP Connector
I have MySQL, Apache, and PHP5 installed. The last thing I need to do is to install the PHP connector, but when I go to the http://dev.mysql.com/downloads/connector/php/ link, the directory does not exist :(

Does anyone know of another way to obtain and install the PHP connector for MySQL? I am just setting things up on my local system to start learning PHP development, but without the connector I am sort of stuck.

View Replies !

Sql Connector 5.1.3
I'm trying to develop a small application in java with jre version 1.5.0_09
which uses sql connector 5.1.3 to connect to my 5.0.45 Mysql db.

when i run the application i get following exception.
java.lang.UnsupportedClassVersionError: Bad version number in .class file
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.access$100(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
Exception in thread "main"

View Replies !

Connector/PHP
I need to download a "MySQL Connector/PHP". Supposedly it should be located at http://dev.mysql.com/downloads/connector/php/, but the page does not exist. There's even an internal link in the navigation menu on the right side of the downloads page with it on it, but the link is broken and there is no place on that page with anything related to a Connector/PHP.

View Replies !

What Connector To Use
What is the best choice for establishing a connection between the asp.net web site and the mySQL database?

I will be using asp .net 2.0, and IIS 6.0. The server will be used for multiple web sites with product databases.

I am aware of the issues with a release of the new .net connector version, but I am also aware that compiling the old 1.0.7 connector under .net 2.0 seems to cure any issues (?).

Either way, whats the best choice - ODBC or .net Connector?

View Replies !

Can Seqouia/c-jdbc Segregate Read & Write DBs ?
I haven't started using Seqouia/C-jdbc but I am probing the ability to
do something like this:

Controller CW has 2 controllers under it - C1 & C2.
C1 is local and has a host HA with X.db's tables t1 & t2.
C2 is remote and has a host HB also with X.db's tables t1 & t2.

Controller CR has 2 controllers under it - C3 & C4.
C3 is local and has a host HC with X.db's tables t1 & t2.
C4 is remote and has a host HD also with X.db's tables t1 & t2.

X.db is MySql type, from experience I've found that MySQL is better off
doing either only writes or only reads. So I want to segregate my read
and write stores. Hence, HA & HB are meant for writing into, while HC &
HD are meant for reading.

Now writes coming to CW should be treated like transactions which land
up on local and remote X.db. These are my WRITE-ONLY-DBs.

Likewise I want reads to goto CR for load balancing with higher
priority to read from HC than HD.

Questions:
(a) Can c-jdbc help in replication of data between HA-HC and HB-HD ?
Which component would help to set this up ? Or do I need to go for
out-of-band MySQL replication ?

(b) Is this configuration optimal for high scalability or availability
? Should I have added contollers horizontally instead of vertically ?

(c) Also, looks like I'd have to write an app to direct writes to CW
and read to CR. Or is there a way to obviate that with the controller
settings itself ?

View Replies !

JDBC Result Closing Takes Time
i am reading 1000 Elements from a database (500.000 all together).
The problem is reading the data takes only a few miliseconds but
closing the ResultSet takes another 22 seconds. My Hard Disk tells me
that the ResultSet is probably running to the end of my table row by
row. Is there a way to tell mysql not to do this ?

Statement tempStmnt = aConnection.createStatement();
tempStmnt = aConnection.createStatement(
java.sql.ResultSet.TYPE_FORWARD_ONLY,
java.sql.ResultSet.CONCUR_READ_ONLY);

tempStmnt.setFetchSize(Integer.MIN_VALUE);

Date tempStart = new Date();
ResultSet tempRs = tempStmnt.executeQuery("SELECT * FROM
ARTIKELSTAMMDATEN");
int tempXx = 0;
while (tempRs.next() && tempXx++ < aCount) {
tempRs.getString("artikelBezeichnung");
}

View Replies !

Turkish Character Problem With Mysql Jdbc
I have a problem with show to turkish character of the JDBC driver
for MYSQL. I have a mysql database.And It's default-character-set is
latin5.(This is supporting the turkish characters)

I can see Turkish character with database engine programs so as
MySQL Control Center. But I can not display with show to turkish
character of the JDBC driver for MYSQL.

View Replies !

MySQL 5.0 And Jdbc - Unexpected End Of Input Stream
Is there something different going on with JDBC and the alpha version
of MySQL 5.0? When trying to connect I am getting:

** BEGIN NESTED EXCEPTION **

java.io.IOException
MESSAGE: Unexpected end of input stream

The client machine trying to connect to the server *CAN* connect via
the mysql command line client (ie. is has permission to the servers).
I have tried connecting to version 5.0 installs on both Linux and
Solaris with the same result. If I point the driver back to a 3.23.57
install, it works fine as always. Code:

View Replies !