 | | | Java Help | | i 'm trying to figure out if i 'm doing something wrong or if i 've run
into a bug.
I created a PreparedStatement p with 2 parameters both ints. I set
these values and call executeQuery(). The s > is the format something I can control? The InnoDB engine stores
> timestamps incorrectly from versions 4.1 - 4.1.3 I 'm wondering if this
> is the problem.
>
> Nevertheless the fact that Statem > Hello
> I just upgraded both parts and am running my unit tests and I am
> getting a data truncation error.
>
> The column is of char[2] and I am trying to put into it a value of '00 '.
>
Hello
I just upgraded both parts and am running my unit tests and I am
getting a data truncation error.
The column is of char[2] and I am trying to put into it a value of '00 '.
Any idHello
I am using connector/j 3.1.3b but will be upgrading to 3.1.4b today
or tomorrow.
I am testing to see if I can get
jdbc mysql //host1.edu host2.edu/dbname
to work and if host1 is sis the format something I can control? The InnoDB engine stores
timestamps incorrectly from versions 4.1 - 4.1.3 I 'm wondering if this
is the problem.
Nevertheless the fact that Statements anHello All
I was doing some performance comparisons and was trying to use the
ServerPreparedStatements. However I immediately got this exception
.
.
.
Caused by java.sql.SQLException CanHi there
I 'm using the mysql-connector version 3.0.15-ga and server
4.1.4-gamma-standard-log. I 'm finding that I can 't retrieve TIMESTAMP
columns and get the following exception
ExceptionHi
I 'm doing updates to records using JDBC but the timestamp field doesn 't update.
An example
Address has only two fields
Line1 - varchar(40)
UpdateTime - timestamp
ResultSet rs Hello
I have a case where the new serverside prepared statements fail to execute
whereas the old-style java driver prepared statements correctly executes. I
suspect it might be due to a 'Feature suggestion...
In our OM layer I 've added a stack trace profile capability to our
prepared statements.
What I do is use the new JDK 1.4 getStackTrace method to determine the
caller.
Hi All
I am using MySQL server 4.0.16 with MySQL Connector 3.0.9. On our system we have the strange problem that the MySQL Connector hangs after 3-4 days. Here is a part of thread dump from our JavHi people
Due to MySQL does not support "inner-selects " I generate a string (I
programm java-client) with the values I used in an IN-operator for an
update onto a mySQL database.
The statemenHi
I have the following problem with connector 3.1.4-beta
There is a table that contains an integer column e.g.
numfld integer charfld char(50)
Contents
1 'row 1 '
2 'row 2 '
Hi folks Im dying here slowly..... Can anyone tell me what an
SqlState 08000 (connection exception) REALLY MEANS.... Is it as obvious
as I think it is Im NOT CONNECTED to MySQL and if sHello
is there a possibility starting or stopping MySQL database and
creating database instance by JAVA? Is there some API available for
this? If yes can you please write some example how tFollow up. Closing the ResultSet was not the issue. Upgrading to
mysql-connector-java-3.1.4-beta DID solve the problem.
At 03 16 PM 9/2/2004 +0530 Plaban Kumar Bhowmick wrote
>I think you arHi
Does anyone know how to get that all the tables and columns names came
at uppercase when you get them from the database??
Thanks in advance
Javi
--
MySQL Java Mailing List
For listDoes anyone have any benchmarks of the performance diff between MySQL
4.1 and 4.0 running prep stmts via JDBC?
I 'm curious about the per-query latency of using server side prep stmts
... IE w-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Hi
MySQL Connector/J 3.1.4 a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.1.4 is the second (and la-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Hi
MySQL Connector/J 3.0.15 a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.0.15 is a bugfix releaseI have come across this issue in mysql Ver 8.40 Distrib 4.1.3-beta as
well as mysql Ver 8.40 Distrib 4.0.16. I am using
mysql-connector-java-3.0.14-production-bin.jar on Mac OS X 10.3.5
I havI have an unexpected error "java.sql.SQLException Column Index out of
range 4 > 3. " in a Java servlet when rapid repeated queries are made to
the database (5 per second). When I restart the servMark
Awhile ago I was having some problems with the 3.1.3 release which the
nightly build on 2004.08.09 fixed. However since then I 've been
getting the following intermittant error
javaHi
We are currently porting our database from oracle to MySQL.
We have many functions and stored procedures implemented in oracle.
I am not sure if we can write our functions in SQL in mysql. I reis there a way to auto-direct select queries to our mysql replication slaves and direct all other queries to our master? does connector/J have some kind of function for doing this?
oh and we 're
My configuratiion
- MySql 4.0.20 Tomcat 5.0.27 jsdk1.4.2_04 y
mysql-connector-java-3.0.14-production-bin.
I put el jdbc driver in C \tomcat_5.0\common\lib and I configure the
DataSource iHi folks Im having a real weird problem here.... Im using Java SDK version 1.4.2_05 MySQL v 4.1.3b-beta-nt Tomcat Version 5.0.27 mysql-connector-java-3.0.11-stable-bin.jar all running unde(if there has been some discussion about this already please let me
know. searches on this list in the last 365 for either "ON DUPLICATE
KEY " or "PREPARED STATEMENT DUPLICATE KEY " yielded no releI am using the mysql driver with mysql version 3.23.42
I have a table with the following definition
CREATE TABLE data (
id int(11) NOT NULL auto_increment
keywords text NOT NULL
thema t |
|
|
