to me, any
recommendations are much appericated!
PS: I posted this question on Java section but no replys :(
Ray
--
View this message in context:
http://www.nabble.com/jdbc-connection-pool-problem%2C-help%2C-thanks%21-tp15673813p15673813.html
Sent from the MySQL - General mailing list archi
There was a thread before about this... this is much better than connector
J's load balancing.
You can take machines out of production, add thhem back in, it's MySQL slave
aware, etc
On 7/19/06, Christopher G. Stach II <[EMAIL PROTECTED]> wrote:
Kevin Burton wrote:
> Hey Gang.
>
> I wanted to
Kevin Burton wrote:
> Hey Gang.
>
> I wanted to get this out on the list and facilitate some feedback.
>
> http://www.feedblog.org/2006/07/announce_lbpool.html
>
What does this have over MySQL Connector/J's load balancing?
--
Christopher G. Stach II
--
MySQL General Mailing List
For list ar
Hey Gang.
I wanted to get this out on the list and facilitate some feedback.
http://www.feedblog.org/2006/07/announce_lbpool.html
I CC'd both lists because this might be of interest to the larger MySQL
community as the techniques I used here could be implemented in other
languages.
==
Hi all,
I have got a problem with the jdbc connection while connecting to
Mysql.I have written an XML file.The following is the code for giving the
database connection
com.mysql.jdbc.Driver<\driver>
jdbc:mysql:\\localhost\test<\location>
Hi all,
I have got a problem with the jdbc connection while connecting to
Mysql.I have written an XML file.The following is the code for giving the
database connection
com.mysql.jdbc.Driver<\driver>
jdbc:mysql:\\localhost\\test<\location>
At 14:57 -0400 11/2/05, Xiaobo Chen wrote:
I already turned off the firewall on the XP machine, but it doesn't work
either. I am doubting that in the database on the other Solaris machine,
it doesn't allow the connection from the XP machine. I am doubting this
way because other application on oth
Xiaobo Chen wrote:
> I can not use 'telnet aaa.bbb.ca 3306' on XP machine, it will give error
> like this:
>
> Could not open connection to the host, on port 3306. Connection failed.
>
> But if I try on other Solaris machines ,it will say something like this:
>
> Trying (IP address)
> Connected
I can not use 'telnet aaa.bbb.ca 3306' on XP machine, it will give error
like this:
Could not open connection to the host, on port 3306. Connection failed.
But if I try on other Solaris machines ,it will say something like this:
Trying (IP address)
Connected to aaa.bbb.ca.
Escape character is '^
Xiaobo Chen wrote:
> I already turned off the firewall on the XP machine, but it doesn't work
> either. I am doubting that in the database on the other Solaris machine,
> it doesn't allow the connection from the XP machine. I am doubting this
> way because other application on other Solaris machine
I already turned off the firewall on the XP machine, but it doesn't work
either. I am doubting that in the database on the other Solaris machine,
it doesn't allow the connection from the XP machine. I am doubting this
way because other application on other Solaris machine can conenction to
the mysq
Xiaobo Chen wrote:
> then I tried 'telnet':
>
> telnet aaa.bbb.ca or telnet aaa.bbb.ca:3306
>
> both case, it said: Could not connected to the host , on port 23: connect
> failed.
Your second example is invalid -- it should be `aaa.bbb.ca 3306` --
so it's not surprising that didn't work :-)
B
Hi, all.
First, I should give some information on the setting:
I have mysql database, say, mydatabase, existing in one machine A which is
Solaris; I am trying to connect this database from another XP machine.
The code snippet in the XP machine looks like this:
String driver = "com.mysql.jdbc.D
I noticed from the example given by William Mussatto that I needed to
include the Port Number on the URL. Yes, I am a Linux idiotbut
hopefully learning as I go.
Thank you, everyone.
This list is awesome!!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeff Weeks wrote:
> I can't access MySQL using Java on Linux! It's killing my project. I
> can access that very MySQL from PHP just fine. I have the same
> database running on Windows so I can develop what I need to. Just can't
> run anything fo
> I can't access MySQL using Java on Linux! It's killing my project. I
> can access that very MySQL from PHP just fine. I have the same
> database running on Windows so I can develop what I need to. Just
> can't run anything for our users!!!
>
> I don't think it's the firewall because I get t
At 05:59 PM 6/17/2003 -0700, Jeff Weeks wrote:
I can't access MySQL using Java on Linux! It's killing my project. I
can access that very MySQL from PHP just fine. I have the same database
running on Windows so I can develop what I need to. Just can't run
anything for our users!!!
I don't
I can't access MySQL using Java on Linux! It's killing my project. I
can access that very MySQL from PHP just fine. I have the same
database running on Windows so I can develop what I need to. Just
can't run anything for our users!!!
I don't think it's the firewall because I get the same
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom O'Neil wrote:
I have configured WAS Express 5.0 to connect to MySql
4.0, however I am unable to open any connections. I
know that the connection to the MySql server works,
because if I change any of the connection parameters
(port, database name,
I have configured WAS Express 5.0 to connect to MySql
4.0, however I am unable to open any connections. I
know that the connection to the MySql server works,
because if I change any of the connection parameters
(port, database name, login), the JDBC driver returns
the appropriate error message. I h
Rick Mann wrote:
sql, query ... just to make the filter happy.
on 11/8/02 2:30 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED]
wrote:
>You are missing something, I am afraid. To quite Sun's Javadoc for the
>PooledConnection class
Thank you so much for the quick reply.
Now I understand why the im
sql, query ... just to make the filter happy.
on 11/8/02 2:30 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED]
wrote:
> You are missing something, I am afraid. To quite Sun's Javadoc for the
> PooledConnection class
Thank you so much for the quick reply.
Now I understand why the implementation of poo
Hi, Rick,
> Hi. I hope this is the right place to discuss this, now that the drivers
are
> part of the official MySQL stuff. If not, please let me know where I
should
> post this. Thanks.
The Java list - [EMAIL PROTECTED] - would probaby be more appropriate
than the general list, but otherwise t
Hi. I hope this is the right place to discuss this, now that the drivers are
part of the official MySQL stuff. If not, please let me know where I should
post this. Thanks.
I've been using the 2.0.14 version of the drivers, and just recently
switched to using the pooled connections supplied by JDBC
On Tue, 7 May 2002, George Pitcher wrote:
> Date: Tue, 7 May 2002 06:15:28 +0100
> From: George Pitcher <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: Re: JDBC connection to MySQL
>
> Just a guess, but how about an ampe
Just a guess, but how about an ampersand?
Connection c =
DriverManager.getConnection("jdbc:mysql://localhost/dbName?user=username&pas
sword=password");
George
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 07,
Hello,
I've been struggling with this for two weeks, I can't seem to find the answer
wherever I look whether in the core mysql book or the documentation on what
variables, if any go between parameters(user and password) as in:
Connection c =
DriverManager.getConnection("jdbc:mysql://localhost/d
How do you set up the server.xml and web.xml files to use connection
pooling in Tomcat using the org.gjt.mm.mysql.Driver JDLC driver (version
mm.mysql-2.0.11)?
I have set up and used a simple data source, but I can't get the pooled
one working - do I need to set it up differently?
Originally, I
I am looking for different alternatives to getting data into a MySQL
database from an unattended command line output (a script) from a remote
machine. This is what I have so far:
email: Parse the output from the command line and simply email it to the
MySQL database server, where a sendmail scri
I am using mySQL 3.23.36 for RH Linux (came with the 7.1 install).
I am using mm.mysql-2.0.7-bin.jar JDBC driver.
When I attempt to connect, I am getting a Server Configuration denies
access... error.
When I have gotten this error in the past, it's been because the user wasn't
set up with the c
sage-
From: Silver Fox [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 11:07 AM
To: [EMAIL PROTECTED]
Subject: JDBC Connection help
Hi everyone,
I just installed MySQL on my linux box. But when I tried to connect to my
own box with jdbc (jdbc:mysql://localhost/red), it gave me
Hi everyone,
I just installed MySQL on my linux box. But when I tried to connect to my
own box with jdbc (jdbc:mysql://localhost/red), it gave me "SQLException:
server configuration denies access to data source". I have already added
root in the mysql.user and mysql.db, why is this happening
ux or OS X.
Here's the scoop ... let's try OS X first:
* .jar files belong in /Library/Java/Home/lib/ext/
* In EOModeler:
URL: jdbc:mysql://localhost/newsie
Driver: org.gjt.mm.mysql.Driver
* MySQL is up and running, and I created a database "newsie"
* EOModeler gives this err
Hi !
)-Original Message-
)From: [EMAIL PROTECTED]
)[mailto:[EMAIL PROTECTED]]On Behalf Of Charles Megnin
)Sent: Wednesday, August 08, 2001 8:55 AM
)To: [EMAIL PROTECTED]
)Subject: Re: database URL / JDBC connection trouble
)
)
)Mark -
)thanks for your input.
)I am using RH 6.2
)however
Hi !
)-Original Message-
)From: Mark Matthews [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, August 08, 2001 5:48 AM
)To: [EMAIL PROTECTED]
)Cc: [EMAIL PROTECTED]
)Subject: RE: database URL / JDBC connection trouble
)
)
)There is no problem with your URL. The message you are receiving
Mark -
thanks for your input.
I am using RH 6.2
however
charly@theblueplanet[24] cat /etc/hosts
127.0.0.1 localhost.localdomain localhost
Besides, I've added 127.0.0.1 explicitely in the db table
& tried to connect via that IP address
rather than localhost, to no avail.
Incidentally, I
There is no problem with your URL. The message you are receiving comes from
the database. Your network permissions are not setup to allow TCP/IP
connections from localhost (or my bet, you're on Redhat which brokenly maps
127.0.0.1 to "localhost.localdomain"). You will need to add grants to allow
c
My apologies if I am cross-posting as I am not clear
on which is the proper list for gal questions (& I have
also posted to [EMAIL PROTECTED]).
What is the proper database URL for JDBC connectivity ?
I have set
String url = "jdbc:mysql://localhost:3306/music";
String user = "charly";
String passw
this is my code:
import java.sql.*;
import java.util.*;
public class Connected {
public static void main (String[] args) throws Exception{
Connection con = null;
try{
String url = "jdbc:mysql://localhost:3306/mydatabase";
Hi,
I have used mm.mysql driver for jdbc connection. I've did all the neccessary
connection and the java application was able to load the driver, but there was this
problem. The java program was actually from the mm.mysql documentation.
Problem:
SQLException:S
this.password = newPassword;
}
public String getPassword() {
return password;
}
}
***
>From: "Cal Evans" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>CC: <[EMAIL
If that's an exact quote then you left off the opening quote marks.
Cal
http://www.calevans.com
-Original Message-
From: Li Bing [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 19, 2001 4:14 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: The Syntax to Get JDBC Connection
Dear All,
I use mm.mysql.jdbc to access mysql in Java. To get the connection, the
following sentence is writen in my program. But an error occurred.
I guess that the syntax is wrong. Could you please give me the correct
one.
Connection conn =
DriverManager.getConnection(jdbc:mysql://localhost/Re
Hello:
Could someone help me in giving me the JAVA syntax to connect to a datbase using
MySQL. I have mm.msql.jdbc-1.2.c.tar as the jdbc connection. All I need is the
detailed code in JAVA to connect to a database in regards to the try block statement.
Thanks alot for all your help
HI Friends ...
I wish u help me in this problem ... I have installed the mysql(recommended
version) For NT(my platform) and the odbc, and finally I unarchived the
mm.mysql.jdbc-1.2c.zip and made all the required configurations . Mysql
driver works properly and I build a database using the SQL
HI Friends ...
I wish u help me in this problem ... I have installed the mysql(recommended
version) For NT(my platform) and the odbc, and finally I installed the
mm.mysql.jdbc-1.2c.zip and made all the required configurations . Mysql
driver works properly and I build a database using the SQL C
Hi
I am using Resin1.2.3 engine to run my servlet and
mysql database with mysql-jdbc driver to connect my
servlet with database but it gives me null pointer
exception when I run my servlet
500 servlet exception
java.lang.NullPointerException
I hope many of you might have face t
47 matches
Mail list logo
