Re: OO base -> jdbc -> mysql timeout problem

2008-12-03 Thread Daevid Vincent
l > db that is running on the web in a shared hosting environment using > jdbc as the connector. > > The problem is if I let OO base sit for a few minutes it looses the > connection to the db and I have to restart OO base to get it to > reconnect. > > Not only is this a

OO base -> jdbc -> mysql timeout problem

2008-12-03 Thread Bazooka Joe
I am trying to develop an db app w/ OO base as the front end to mysql db that is running on the web in a shared hosting environment using jdbc as the connector. The problem is if I let OO base sit for a few minutes it looses the connection to the db and I have to restart OO base to get it to

JDBC Compatibility

2008-11-14 Thread Ronan Lucio
Hi, Suppose a simple query: SELECT client_name as name FROM clients WHERE client_id = $client_id Using JDBC 5.0.8 it returns column name as "name", that it's the expected for me. Using JDBC 5.1.7 it returns column name as "client_name", although I have as

JDBC error: sql: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'gname' at row 0

2008-04-15 Thread Andrey Dmitriev
Have identical versions installed, in one query works fine, in another, pukes with the error in the subject. When I query by hand (via mysql client) works fine. Not even that much data to complain about! mysql> select -> group_concat(concat('',hosts.name,'') order by hosts.name asc separa

jdbc connection pool problem, help, thanks!

2008-02-24 Thread raybristol
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

Re: a scheme for the future mysql-protocol, Re: [ANN] New PBXT/MyBS release enables JDBC-based BLOB streaming!

2007-10-22 Thread Paul McCullagh
Hi Chad, Yes, I agree. This is a really good idea. I think that it makes a lot of sense to make streaming part of the standard MySQL protocol. Your suggestion solves the problem that always comes with a transition to a new protocol. On Oct 19, 2007, at 6:20 PM, Chad MILLER wrote: On 19

a scheme for the future mysql-protocol, Re: [ANN] New PBXT/MyBS release enables JDBC-based BLOB streaming!

2007-10-19 Thread Chad MILLER
On 19 Oct 2007, at 04:35, Paul McCullagh wrote: For this release I have completed changes to the MySQL Connector/J 5.0.7, to allow BLOB data to be transparently stored and retrieved from the MyBS BLOB repository. The new version of the driver is called MySQL Connector/J SE (streaming enabl

[ANN] New PBXT/MyBS release enables JDBC-based BLOB streaming!

2007-10-19 Thread Paul McCullagh
you need to install the latest versions of PBXT and MyBS. Both are available from: http://www.blobstreaming.org/download. Binary versions of the storage engines are also available for MySQL 5.1.22 running on 32-bit Linux and x86 Mac OS X. The modified version of the JDBC source code is

Re: jdbc with a UDF

2007-06-05 Thread Dave G
Thanks for the reply. I tracked the problem down. Simple problem really, I was using an old mysql-connector-java jar. I updated that to the correct version for my database and it all worked. What version of of the JDBC driver are you using? Good question to ask. I asked myself that very

jdbc with a UDF

2007-06-05 Thread Dave G
I'm getting what appears to be a java reference back from values I return from a UDF. The values appear find using php, and in the mysql client. The result looks something like: [EMAIL PROTECTED] The result should be a string (some representing floats, others as integers). Any help will be app

jdbc question regarding enum

2006-11-01 Thread Jon Drukman
disclaimer: i know nothing about java or jdbc. a co-worker is trying to access a database i've set up using jdbc. he says that my enum column is always returning an integer value instead of the string. obviously this is less than desirable. does anybody have any advice i could give h

Re: Support for JDBC 4.0?

2006-08-30 Thread Colin Charles
Steven Buroff wrote: Does anyone know if there are plans to add support for JDBC 4.0 to the java connector? I'm particularly interested in support for the Connection.createQueryObject(Class cls) method. Its mostly already there in the trunk, and keep in mind that JDK-6 (w/JDBC-4) isn&#

Support for JDBC 4.0?

2006-08-09 Thread Steven Buroff
Does anyone know if there are plans to add support for JDBC 4.0 to the java connector? I'm particularly interested in support for the Connection.createQueryObject(Class cls) method. Thanks. Steve Buroff

Re: Announce: LBPool 1.0 beta1 (Load Balancing JDBC Connection Pool)

2006-07-19 Thread Kevin Burton
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

Re: Announce: LBPool 1.0 beta1 (Load Balancing JDBC Connection Pool)

2006-07-19 Thread Christopher G. Stach II
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

Announce: LBPool 1.0 beta1 (Load Balancing JDBC Connection Pool)

2006-07-18 Thread Kevin Burton
uages. == The lbpool project provides a load balancing JDBC driver for use with DB connection pools. It wraps a normal JDBC driver providing reconnect semantics in the event of additional hardware availability, partial system failure, or uneven load distribution. It also evenly distributes al

error in JDBC Connection(Sorry there was TYPO ERROR in my previous mail)

2006-06-03 Thread VenuGopal Papasani
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>

Problem with JDBC Connection

2006-06-03 Thread VenuGopal Papasani
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>

Re: MySQL JDBC Problem

2006-05-02 Thread Mark Matthews
nt" is not showed on .getIndexInfo() > > > MySQL 5.0.20a > Connector/J 3.1.12 > Linux box > Java 1.5.0_06 Dyego, Exactly how are you calling getPrimaryKeys(), i.e. the _exact_ arguments you're passing in. Do you actually get a NULL result set (shouldn't happen)

MySQL JDBC Problem

2006-05-02 Thread Dyego Souza Dantas Leal
I have a problem using the latest version of Connector/J the DESC of table shows: mysql> desc tiposelo; ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+-

Re: MySQL JDBC Exception: "No operations allowed after connection closed"

2006-03-16 Thread amiljusevic
Factory vs. org.apache.commons.dbcp.BasicDataSourceFactory. The data source factory required for JOTM is specified in the following document: "How to use JDBC and transactions in Tomcat with JOTM" (http://jotm.objectweb.org/current/jotm/doc/howto-tomcat-jotm.html) Different data source factories translate

MySQL JDBC Exception: "No operations allowed after connection closed"

2006-03-14 Thread amiljusevic
I use Tomcat 5.0.28 on both Fedora and FreeBSD, MySQL 4.1.14, J/Connector JDBC driver for MySQL 3.1.11 and JOTM 2.0.10. From time to time I get the MySQL JDBC driver exception "No operations allowed after connection closed", after which DB calls from my application keep failing.

Re: MySQL and OpenOffice - JDBC

2006-02-19 Thread George Law
"MySQL List" Sent: Sunday, February 19, 2006 3:52 PM Subject: MySQL and OpenOffice - JDBC -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I don't really think this is the right place to ask this question, so please forgive this post. I've tried asking the question over on the Open

MySQL and OpenOffice - JDBC

2006-02-19 Thread Michael Satterwhite
e is other external data source (Is this ~ to be expected?). I select that and at Next press Settings and select MySQL (JDBC). At next, I enter the database as mysql://localhost:3306/Magicians. I check password required, enter the user and test connection. After entering the password, I get t

Re: Mysql and JDBC connection time out.

2005-11-02 Thread Paul DuBois
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

Re: Mysql and JDBC connection time out.

2005-11-02 Thread Hassan Schroeder
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

Re: Mysql and JDBC connection time out.

2005-11-02 Thread Xiaobo Chen
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 '^

Re: Mysql and JDBC connection time out.

2005-11-02 Thread Hassan Schroeder
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

Re: Mysql and JDBC connection time out.

2005-11-02 Thread Xiaobo Chen
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

Re: Mysql and JDBC connection time out.

2005-11-02 Thread Hassan Schroeder
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

Mysql and JDBC connection time out.

2005-11-02 Thread Xiaobo Chen
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

Re: Question for JDBC and Mysql

2005-11-02 Thread Alec . Cawley
le_A; > > it returned something like this: > > +-+-+ > | min(date_time) | max(date_time) | > +-+-+ > | 2003-05-06 11:59:00 | 2003-05-23 11:59:00 | > +-----+-+ > > My que

Question for JDBC and Mysql

2005-11-01 Thread Xiaobo Chen
_time) | +-+-+ | 2003-05-06 11:59:00 | 2003-05-23 11:59:00 | +-+-+ My question is that if I used JDBC like this: String sqlcmd = "select min(date_time), max(date_time) from table_A; Statement Stmt = conn.createStatement(); Re

Re: EOFException with jdbc driver

2005-09-15 Thread Stefan Kuhn
Hi Mark, thanks for your answer. See comments. > > Stefan, > > Something is closing the network connection abrubtly between JDBC and > your MySQL server. Things to check are: > > 1) Connections don't sit longer than 'wait_timeout' on the server. I am actually

Re: EOFException with jdbc driver

2005-09-15 Thread Mark Matthews
ve this and also not a real explanation what the error means. > Any ideas? > Thanks, > Stefan > Stefan, Something is closing the network connection abrubtly between JDBC and your MySQL server. Things to check are: 1) Connections don't sit longer than 'wait_timeout' on

EOFException with jdbc driver

2005-09-15 Thread Stefan Kuhn
Hi all, I have a Java webapp using a mysql database. It all used to run well, but I now frequently get the following error: 2005-09-15 11:33:32,115 [Thread-23] ERROR rotation - com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCE

Re: Transactions in Java - JDBC

2005-08-09 Thread Mark Matthews
java.sun.com/docs/books/tutorial/jdbc/basics/transactions.html -Mark - -- Mark Matthews MySQL AB, Software Development Manager - Connectivity www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8D

Transactions in Java - JDBC

2005-08-05 Thread C.F. Scheidecker Antunes
Hello, Can anyone tell me what to do in order to use transactions on a java application? Is there any howto regarding this issu? Thanks, C.F. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: UNION in JDBC - WAS Re: use of indexes

2005-07-27 Thread Gleb Paharenko
worked. From a normal > mysql client, it was returning my results sub-second. I am actually > executing this over JDBC, using mysql-connector j. > > WHen I put the SQL into my Java program - it takes a minute or so. I > am logging the SQL and if I copy and paste it into my mysq

UNION in JDBC - WAS Re: use of indexes

2005-07-23 Thread Chris Faulkner
Hello again Following on from this index question, the UNION worked. From a normal mysql client, it was returning my results sub-second. I am actually executing this over JDBC, using mysql-connector j. WHen I put the SQL into my Java program - it takes a minute or so. I am logging the SQL and if

Re: JDBC driver problem with sql LIMIT

2005-03-30 Thread Mark Matthews
eption in thread "AWT-EventQueue-0" java.lang.OutOfMemoryError: Java heap > space > Exception on Toolkit thread: java.lang.OutOfMemoryError: Java heap space > java.lang.OutOfMemoryError: Java heap space > > Is LIMIT supported with the JDBC driver? > thank you everygody

JDBC driver problem with sql LIMIT

2005-03-30 Thread l'eau
emoryError: Java heap space java.lang.OutOfMemoryError: Java heap space Is LIMIT supported with the JDBC driver? thank you everygody Laurie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Using a Load balancer with MySQL 4.1.7 and JDBC 3.1.7 (performance)...

2005-01-21 Thread Kevin A. Burton
I'm playing around with using a load balancer to balance our slaves. What I want to do is put a load balancer in front of our slaves and then reconnect each time via the JDBC driver. This way a slave can fail and I can just take it out of service. It also means that I can keep performan

Re: JDBC driver support

2005-01-11 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Manish wrote: > We're having some problems in getting MySQL 4.1.8 to work with JDBC drivers > in - > mysql-connector-java-2.0.14-bin.jar > > Do these drivers work with MySQL 4.1.8? hey seem to be working fine with > 4.0.14

Re: JDBC driver support

2005-01-11 Thread Stephen Moretti
Manish wrote: We're having some problems in getting MySQL 4.1.8 to work with JDBC drivers in - mysql-connector-java-2.0.14-bin.jar Do these drivers work with MySQL 4.1.8? hey seem to be working fine with 4.0.14 version of MySQL. Is there any compatibility data available for all these JDBC dr

JDBC driver support

2005-01-10 Thread Manish
We're having some problems in getting MySQL 4.1.8 to work with JDBC drivers in - mysql-connector-java-2.0.14-bin.jar Do these drivers work with MySQL 4.1.8? hey seem to be working fine with 4.0.14 version of MySQL. Is there any compatibility data available for all these JDBC drivers and

Problem with JDBC and Unicode

2004-10-25 Thread Barley
Hi all, I have been struggling to get MySql to accept Unicode characters for a while now with no success. I am attaching a small example program as well as a mySql dump in hopes that someone can help. The expected behavior is that the program should insert a curly quote and a 'one quarter' symbol

Re: JDBC - how to insert Strings with mixed characterEncodings

2004-09-17 Thread Alec . Cawley
> FWIW, u201C is an opening curly quote and u00BC is a fraction representing > one quarter. > > If I create my JDBC url like this: > > jdbc:mysql://localhost/test?user=test&password=test&useUnicode=true&characte > rEncoding=cp1250 > > then the curly q

JDBC - how to insert Strings with mixed characterEncodings

2004-09-17 Thread Barley
Say, for example, I want to run an insert like the following: java.sql.Statement select = conn.createStatement(); select.executeUpdate("update test set observerNote='\u201C ... \u00BC'"); FWIW, u201C is an opening curly quote and u00BC is a fraction representing one quarter.

replication vs. c-jdbc

2004-09-07 Thread Crouch, Luke H.
we currently have a series of machines set up with replication (1 master, 4 slaves) and we were looking for a way to load-balance the read queries across the slaves, and came upon c-jdbc. I was wondering if anyone else has experience running c-jdbc in front of MySQL, and if so, if they can

Re: Error in JDBC retrieval of mediumint column (mysql4.1.2b-alpha-win and java-3.1.2-alpha driver)

2004-06-28 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Oliver Chua wrote: > To be able to use subqueries, I'm now using mysql-4.1.2b-alpha-win.zip > I'm using mysql-connector-java-3.1.2-alpha.zip as my jdbc driver to connect > to the db... > > I'm selecting some columns fr

Error in JDBC retrieval of mediumint column (mysql4.1.2b-alpha-win and java-3.1.2-alpha driver)

2004-06-28 Thread Oliver Chua
To be able to use subqueries, I'm now using mysql-4.1.2b-alpha-win.zip I'm using mysql-connector-java-3.1.2-alpha.zip as my jdbc driver to connect to the db... I'm selecting some columns from a table where the column is created using mediumint. Somehow, after creation, it beco

Re: Idea to speed up multiple jdbc connections?

2004-06-08 Thread Marc Slemko
On Tue, 8 Jun 2004, Haitao Jiang wrote: > > Each of 4 individual query only took <0.6 seconds, > there is no other clients, it hardly to believe taht > mysql query performance will degrade 300% (from <0.6s > to ~1.9s) if we have 4 concurrent connections... > > As far as I know, MySQL should be abl

Re: Idea to speed up multiple jdbc connections?

2004-06-08 Thread Haitao Jiang
Each of 4 individual query only took <0.6 seconds, there is no other clients, it hardly to believe taht mysql query performance will degrade 300% (from <0.6s to ~1.9s) if we have 4 concurrent connections... As far as I know, MySQL should be able to handle hundreds of connections on a single CPU b

Re: Idea to speed up multiple jdbc connections?

2004-06-07 Thread Marc Slemko
On Mon, 7 Jun 2004, Haitao Jiang wrote: > Marc > > mysqld runs on a very powerful Operton machine with > 16GB memory and barely any other application process > running, it is hard to believe that a simple select > that runs under 2 second will utilize all the > resources...that is why I tend to th

Re: Idea to speed up multiple jdbc connections?

2004-06-07 Thread Haitao Jiang
Marc mysqld runs on a very powerful Operton machine with 16GB memory and barely any other application process running, it is hard to believe that a simple select that runs under 2 second will utilize all the resources...that is why I tend to think there is something in the mysql set up that caused

Re: Idea to speed up multiple jdbc connections?

2004-06-07 Thread Marc Slemko
On Mon, 7 Jun 2004, Haitao Jiang wrote: > > Yes. The time I measure like I said is purely around > statement.execQuery() call. Connection creation is not > a factor here at all. > > My database has 1.64 million rows and 4 queries are > all selects, which are identical in both serial and > parallel

RE: Idea to speed up multiple jdbc connections?

2004-06-07 Thread jonathan.chiu
M To: Mark Matthews; JONATHAN CHIU (ISD-OLAPL/HKG) Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Idea to speed up multiple jdbc connections? Yes. The time I measure like I said is purely around statement.execQuery() call. Connection creation is not a factor here at all. My database has 1.

Re: Idea to speed up multiple jdbc connections?

2004-06-07 Thread Haitao Jiang
Yes. The time I measure like I said is purely around statement.execQuery() call. Connection creation is not a factor here at all. My database has 1.64 million rows and 4 queries are all selects, which are identical in both serial and parallel cases. In serial cases: Query 0 took 590 Query 1 took

Re: Idea to speed up multiple jdbc connections?

2004-06-07 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: > AFAIK, creation of connection from DB is expensive. This is one of the > reasons why we need connection pooling. > Jonathan, While that might be true for other databases, it's not true for MySQL (connections are a few ms.

RE: Idea to speed up multiple jdbc connections?

2004-06-07 Thread jonathan.chiu
Jiang [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 8:14 AM To: mysql Subject: Idea to speed up multiple jdbc connections? Hi, I would appreciate any help on this: I got approximate same timing on following two: case 1: create 1 jdbc connection and issue 4 queries sequentially case 2

Idea to speed up multiple jdbc connections?

2004-06-07 Thread Haitao Jiang
Hi, I would appreciate any help on this: I got approximate same timing on following two: case 1: create 1 jdbc connection and issue 4 queries sequentially case 2: create 4 jdbc connections and issue 4 queries via 4 different threads at the same time The timing is done around

Re: JDBC ResultSet exception

2004-04-29 Thread Josh Trutwin
On Thu, 29 Apr 2004 23:59:05 +0200 "Bjoern Wuest" <[EMAIL PROTECTED]> wrote: > Dear All > > > I work on a small application with database support. For development I use > the MySQL database which is just doing fine. During testing I experienced a, > in my opinion, strange bug. > > > I have the

JDBC ResultSet exception

2004-04-29 Thread Bjoern Wuest
Dear All I work on a small application with database support. For development I use the MySQL database which is just doing fine. During testing I experienced a, in my opinion, strange bug. I have the following source code: >> Connection conn = p_GetConnectionFromPool(); try {

Re: Does JDBC realm really require cleartext password.

2004-04-22 Thread Paul DuBois
At 7:48 -0500 4/22/04, Faine, Mark wrote: I'm trying to configure a JDBC realm using a third party database and it seems they are using the mysql password command to store their passwords. I read in the docs: "When a standard realm authenticates by retrieving the stored password and co

Does JDBC realm really require cleartext password.

2004-04-22 Thread Faine, Mark
I'm trying to configure a JDBC realm using a third party database and it seems they are using the mysql password command to store their passwords. I read in the docs: "When a standard realm authenticates by retrieving the stored password and comparing it with the value presented b

Re: JDBC timeout after 4.0.8 -> 4.0.18 upgrade?

2004-03-11 Thread Alan Williamson
With respect to this problem, I am not running on Windows, but Redhat, and seeing this problem often. Which part of: http://www.mysql.com/documentation/connector-j/index.html#id2803835 should i be looking at? thanks alan -- MySQL General Mailing List For list archives: http://lists.mysql.c

Re: JDBC timeout after 4.0.8 -> 4.0.18 upgrade?

2004-03-10 Thread Eric B.
t; > Hi, > > > > I've recently upgraded from 4.0.8a to 4.0.18, and am running into a > strange > > error in the JDBC connector. If the DB connection is unused for a > period of > > time (don't konw the minimum amount of time, but 8-12 hours defintiely >

Re: JDBC timeout after 4.0.8 -> 4.0.18 upgrade?

2004-03-09 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Eric B. wrote: > Hi, > > I've recently upgraded from 4.0.8a to 4.0.18, and am running into a strange > error in the JDBC connector. If the DB connection is unused for a period of > time (don't konw the minimum amoun

JDBC timeout after 4.0.8 -> 4.0.18 upgrade?

2004-03-09 Thread Eric B.
Hi, I've recently upgraded from 4.0.8a to 4.0.18, and am running into a strange error in the JDBC connector. If the DB connection is unused for a period of time (don't konw the minimum amount of time, but 8-12 hours defintiely triggers the problem), I get the following error msg i

Re: Needing help for JDBC issue

2003-11-18 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Prasad Budim Ram wrote: > Hi, > > I'm getting the following error while connecting to a MySQL databases > using JDBC. Any clues?? > > "java.net.SocketException: errno: 48, error: Address already in use" > > T

Re: table crash (error127) using v4.0.15 & JDBC

2003-11-18 Thread fabien marsaud
#x27;" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, November 18, 2003 2:51 PM Subject: RE: table crash (error127) using v4.0.15 & JDBC > Are the crashes occurring on the same machines? Or random machines? Can you > track the disk activity at the time the ta

RE: Needing help for JDBC issue

2003-11-18 Thread Victor Pendleton
Can you post what you are trying to do? -Original Message- From: Prasad Budim Ram [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 2:17 AM To: [EMAIL PROTECTED] Subject: Needing help for JDBC issue Hi, I'm getting the following error while connecting to a MySQL data

RE: table crash (error127) using v4.0.15 & JDBC

2003-11-18 Thread Victor Pendleton
5:52 AM To: [EMAIL PROTECTED] Subject: table crash (error127) using v4.0.15 & JDBC Hi I'm working with mysql 4.0.15 for some software of ours and we are experiencing a random table crash. we have 30 MyISAM tables in our database and we're using JDBC to connect to them. Sometime

table crash (error127) using v4.0.15 & JDBC

2003-11-18 Thread fabien marsaud
Hi I'm working with mysql 4.0.15 for some software of ours and we are experiencing a random table crash. we have 30 MyISAM tables in our database and we're using JDBC to connect to them. Sometimes, very rarely, one of the tables crashes. It has nothing special compared to the ot

Needing help for JDBC issue

2003-11-18 Thread Prasad Budim Ram
Hi, I'm getting the following error while connecting to a MySQL databases using JDBC. Any clues?? "java.net.SocketException: errno: 48, error: Address already in use" Thanks, Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: JDBC : determining the schema name for MySQL

2003-09-29 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Andy Jefferson wrote: > Mark Matthews wrote: > >>MySQL doesn't have schemas (currently). They are being developed in a >>future version. The DatabaseMetaData interface in JDBC has a method, >>'getSchemaTerm' whi

Re: JDBC : determining the schema name for MySQL

2003-09-28 Thread Andy Jefferson
Mark Matthews wrote: > MySQL doesn't have schemas (currently). They are being developed in a > future version. The DatabaseMetaData interface in JDBC has a method, > 'getSchemaTerm' which tells you whether a certain database supports > schemas or not (returning "

Re: JDBC : determining the schema name for MySQL

2003-09-28 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Andy Jefferson wrote: > Hi, > > has anyone found a good way of determining the schema name using a JDBC > connection to MySQL ? > > I've tried accessing DatabaseMetaData and calling getSchemas() to get the > schemas and it r

JDBC : determining the schema name for MySQL

2003-09-28 Thread Andy Jefferson
Hi, has anyone found a good way of determining the schema name using a JDBC connection to MySQL ? I've tried accessing DatabaseMetaData and calling getSchemas() to get the schemas and it returns nothing using 3.0.8 of the connector. I've also tried tried DatabaseMetaData.getTables(

Re: jdbc-Driver - foreignkeys - OOo

2003-09-21 Thread Dieter Kroemer
(and has for quite some time). What version of MySQL are you > using? I installed yesterday mysql 4.0.15 (and if I start phpMyAdmin I see this number in the Browser) > The most recent two releases (4.0.14 and 4.0.15) have changed the > output format for the metadata that the JDBC dri

Re: jdbc-Driver - foreignkeys - OOo

2003-09-21 Thread Mark Matthews
t with MySQL I could do > all my jobs in schools with only _one_ database). > Till now, I thought mysql can't work with foreign keys, but I read, that > tables in the innodb-format can do this. But if I work with the jdbc-driver > and OOo, OOo doesn't support the foreignkey

jdbc-Driver - foreignkeys - OOo

2003-09-21 Thread Dieter Kroemer
ought mysql can't work with foreign keys, but I read, that tables in the innodb-format can do this. But if I work with the jdbc-driver and OOo, OOo doesn't support the foreignkeys-gui :-(( (the cause is the jdbc-Driver) Does anybody know, if a future version of the jdbc-Driver wi

C-JDBC (Was RE: Has anyone heard of SafeKit?)

2003-09-12 Thread Neil Aggarwal
Heikki: I agree that there a many issues to addres when trying to use multiple databases as a single database. The C-JDBC project (at least on the surface) seems to think it is possible. Their web page is at: http://c-jdbc.objectweb.org/ They even have a way to use multiple controllers to

Re: JDBC 3.08 nightly snapshot from 7/23/2003

2003-07-23 Thread Nils Valentin
Hi Mark, I use the the MySQL versions as provided from www.mysql.com. The drivers are taken from the daily snapshot and/or from www.mysql.com. Let me know if you need more information. Best regards Nils Valentin Tokyo/Japan 2003年 7月 23日 水曜日 23:44、Mark Matthews さんは書きました: > -BEGIN PGP SIGNE

Re: JDBC 3.08 nightly snapshot from 7/23/2003

2003-07-23 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Nils Valentin wrote: > Hi MySQL Fans ;-), > > Is it possible that the 3.08 series allows to connect to 4.0.14 versions but > not to the 4.1 alpha-versions ? > > I get belows error when tryig to connect from DbVisualizer which was working > fine until

JDBC 3.08 nightly snapshot from 7/23/2003

2003-07-23 Thread Nils Valentin
Hi MySQL Fans ;-), Is it possible that the 3.08 series allows to connect to 4.0.14 versions but not to the 4.1 alpha-versions ? I get belows error when tryig to connect from DbVisualizer which was working fine until a while ago. I haven't watched it recently, and haven't changed anything I am

Re: MySQL 4.0.13 and JDBC

2003-06-18 Thread Mark Matthews
sing mysql-connector-java-3.0.8-stable-bin.jar to access MySQL. > There's somthing that I must set on MySQL server? Or there's a new JDBC > for version 4.x? > > > Thanks > Luca Hi! The foreign key info returned from InnoDB changed in 4.0.13. The 3.0.x JDBC driver has bee

MySQL 4.0.13 and JDBC

2003-06-18 Thread Luca
st set on MySQL server? Or there's a new JDBC for version 4.x? Thanks Luca -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ _ Naviga www.numeroverdeweb.it -- MySQL General Mailing List For list archives: http://lists.mysql

Re: Java/JDBC - Connection refused on Linux - solved

2003-06-17 Thread Jeff Weeks
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

Re: Java/JDBC - Connection refused on Linux

2003-06-17 Thread Mark Matthews
-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

Re: Java/JDBC - Connection refused on Linux

2003-06-17 Thread William R. Mussatto
think it's the firewall because I get the same error when I run > locally on the box. > > Anyone face this before? I need HELP. > > > How are you trying to connect? You need a JDBC connector. You must "register" the connection.. The current connector is Connector

Re: Java/JDBC - Connection refused on Linux

2003-06-17 Thread Madscientist
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

Java/JDBC - Connection refused on Linux

2003-06-17 Thread Jeff Weeks
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

Query cache not working with JDBC driver?

2003-06-09 Thread Greg
I have the query cache on MySQL 4.0.13-standard running and working fine, with a large amount of memory allocated to it. But it doesn't appear to be working with the MySQL JDBC driver access. I have used versions 2.0 and 3.0 of the JDBC driver. Although it will cache a query from the

Re: JDBC is not surviving a mysql reboot

2003-06-06 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Lopez David E-r9374c wrote: > Dudes & Dudetts > > filter: mysql, select, sql > mysql version: 3.23.49 > jdbc version: 2.0.14 > development os: win2k > production os: solaris > > Problem: > > During a r

JDBC is not surviving a mysql reboot

2003-06-06 Thread Lopez David E-r9374c
Dudes & Dudetts filter: mysql, select, sql mysql version: 3.23.49 jdbc version: 2.0.14 development os: win2k production os: solaris Problem: During a reboot of mysqld, the perl connections survived and the jdbc connections did not. My definition of survived is that the connect

Fwd: Encoding problem (JDBC, mysql)

2003-06-02 Thread Venkata Srinivasa Rao, Yerra
2003 14:21:54 +0800 To: [EMAIL PROTECTED] From: "Venkata Srinivasa Rao, Yerra" <[EMAIL PROTECTED]> Subject: Encoding problem (JDBC, mysql) X-Spam-Check-By: lists.mysql.com X-Spam: False ; 3.3 / 5.0 Dear All, I am facing encoding problem with JDBC, mysql.  I can't insert/sel

Encoding problem (JDBC, mysql)

2003-06-02 Thread Venkata Srinivasa Rao, Yerra
Dear All, I am facing encoding problem with JDBC, mysql.  I can't insert/select Big5 text with JDBC connection. After I insert Big5 text, it becomes question marks () in the database. Before I insert Big5 text to mysql db, I am converting web browser post data from "8859_

RE: About JDBC

2003-04-06 Thread Kyle Lange
2003 19:44 To: ™âR­ Cc: [EMAIL PROTECTED] Subject: Re: About JDBC It should be enough to place the .jar file in the jre/lib/ext folder inside your Java installation folder. If you don't want to do that, you could modify your CLASSPATH environment variable to include wherever you decide to

  1   2   3   4   5   >