Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
Subject: mysql openssl Question
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
Update one field with more fields from another table
Subject: Getting Identity after INSERT
ERROR 2002: Can 't connect to local MySQL server through socket
mysql test 4 1 fails with the gis test
Subject: MySQL Cluster Software
Downgrade Mysql from 4 to 3 23
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Can 't access mysql after kernel upgrade
Executing MySQL Commands From Within C Program
Comparing and writing out BLOBS
Subject: Re: Preventing Duplicate Entries
FULLTEXT query format question
Strange behavior, Table Level Permission
Does the binary log enabling affect the MySQL performances?
mysql:it 's a db not a dbms how it 's possible?!
mysql have same function mthod as Oracle decode()
 
Java Help
Page 7 of 26 1   2   3   4   5   6   7   8   9   10   Next 10  

What SQLException when MySQL box crashes or is shutdown?

Hey. I 'm writing a load balancing JDBC driver which is MySQL and replication aware... I 'll post more info when its complete. What SQLException and errorCode are thrown if an existing Connection obje

Subject: Re: Out of memory (Needed xxx ...

As far as i remember you must set that variable in order to send huge blobs and the error message can vary because it can means that the current memory space for that connection has been filled. Why

connector mxj can 't init db on linux

Hi all I 'm using connector mxj 1.1.6 with Java 1.5.0_06 on Debian Linux. I have an small program that fills the database and a second one uses this db. First I filled the db and the program exite

login problem

Hi Experts I face some access problem to work with the Mysql 5. I use jdbc for myeclipse and mySql5 on Win xp. But when I click 'open connection ' it gives an error as follows Error while trying

Subject: Load statement in mysql

Hi I have to execute a "Load table.. " statement to load a dat file to mysql database. My file contains some special characters like ? ?...Due to this my Load statement is giving some error. How d

queris are significantly slower on the failed over sqld

Hi I am experimenting JDBC failover/failback with MySQL cluster environemt. What I found is the JDBC failover / failback does take place howvever after JDBC failover to the 2nd sqld the queries

connector mxj problems on linux

Lo i 'm using Mysql connector/MXJ 1.1 with java 1.5 on windows xp and linux (suse 10) After some test i could use it to install mysql as demo database or portable database on windows. However when

compress/uncompress using java prepared statements

Hello My configuration mysql-connector-java-3.1.12-bin.jar mysql5018 I am trying to get uncompressed data from mysql using SELECT UNCOMPRESS(FILE_DATA) FROM <table > WHERE <id 11 > I am using Pr

help with preparedStatement.setTimestamp with Calendar

I 'm having problems getting the results I expect using setTimestamp with a PreparedStatement and Calendar. So far my Google searches trying to find an answer have resulted in finding a couple others

Purse installation

I am installing a credential management package for a computer grid. The package is called PURSe and it uses Java Mysql and portlet classes to work. when I compile it for testing I get this Java-mysq

ResultSet.getFloatFromString doesn 't handle Float.NaN or does it?

Hello If my database contains NaN and I do getObject on the field there is an exception. Caused by java.sql.SQLException Invalid value for getFloat() - 'nan ' in column 27 at com.mysql.jdbc.Result

x509 client certificate validation problems

Greetings I 'm attempting to setup a mysql database that works with a java application using X509 verification/encryption. Below are some configs Server - MySQL 4.1.12 (RHEL v4 install) J/Connect

Off-topic: How to specify a variable name in a GRANT statement inside a stored r

First of all sorry about the (kinda) offtopic How can I specify the use of a variable in a stored rutine for a GRANT statement which is inside a stored rutine? I 'm currently trying to do somthing

How to shutdown mysql from Java

Hi my application starts mysqld (via Runtime.getRuntime().exec) and I would like to stop it also from Java (because of technical reasons I cannot use mysqladmin). What is the best way stop shutdown

fixes to hang in setAutoCommit ?

Hi Mark We 've been getting problems which look a lot like the problem mentioned in http //forums.mysql.com/read.php?39 45273 45302#msg-45302 The solution you mentioned is to upgrade to

Problems with UTF-8

I have problem with UTF-8 character set. I use MySQL 5 and Tomcat 5.5.9.I use NetBeans for programinnig in Java. I made one database and is in UTF8 also all my JSP pages are set to UTF8 encoding and

Subject: sql warnings and JDBC

Hi I have changed my environment from an old 3.0.11 JDBC driver to the new 3.1.12. The old driver suppress the warnings from the mysql server which the new reports as SQLExceptions. How can I check

Prepared statemens do not work for sort-order in ORDER BY clause

Hi To prevent SQL injection attacks we use PreparedStatements. In an ORDER BY clause we also set the sort order ASC or DESC via a ? Unfortunately if done so this does not work. When doing a l

Employment Offer

I have a new email address!You can now email me at harris_cole_uk@(protected) I am looking for a representative in the states who will be working for me as a partime worker and i will be willing to

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

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

ResultSet Streaming

Ok unless anyone corrects me it seems like in the latest driver the fetch size has no impact besides this odd special value of Integer.MIN_VALUE. You basically have two choices when using the MySQL

Default ResultSet holdability inconsistency problem

I am in the process of debugging my connection pooling library and I seem to have uncovered an inconsistency in the ResultSet holdability of MySQL. Perhaps I am missing the point but my presumption i

5.x and setFetchSize

Does #setFetchSize work in the MySQL JDBC driver now or do I only have two choices (a) all in memory or (b) single row at a time? TIA R. -- MySQL Java Mailing List For list archives http //lists

how to specifiy a Primary SQL server for JDBC connection, JDBC connection fail-b

Hi I am axiously waiting for experts from this mailing list to help me out on following two questions. (I first sent the same question to the cluster mailing list since the target architecture is

Prepared Statements, not being prepared?

Hello Everyone I 'm encountering a strange problem where prepared statements aren 't being prepared at all. ******** PreparedStatement s new connection.prepareStatement( "SELECT item FROM table

Handheld Data Access

Hi again List! I wonder what should be the best way to access data on a remote MySQL Server while working on a handheld (PocketPC or whatever) Is there any jdbc connector for any handheld jvm

--skip-networking and JDBC connection

Hello ! Is it possible to connect to mysql through jdbc driver when mysqld started with --skip-networking option ?. For example as here "C \Program Files\MySQL\mysql-4.1.13-win32\bin\mysqld-max-nt.ex

DataTrunctation error when BLOB/CLOB greater than 64K

Is there a way to lift the restriction on how much data can be written to a LOB in MySQL from JDBC? R. -- MySQL Java Mailing List For list archives http //lists.mysql.com/java To unsubscribe h

Statement release

Hello I would like to solve this problem. I get a Connection instance from a connection pool create some statements and prepared statements do some database operations close all statements and ret

R: java.lang.OutOfMemoryError - LONG (with test case)

Try with for (int j 0 j < 100 j++) { sql "SELECT * FROM " + TABLE_NAME + " " stmt conn.createStatement() ResultSet rs stmt.exe
Page 7 of 26 1   2   3   4   5   6   7   8   9   10   Next 10