 | | | Java Help | | Does anyone know of a database independent way to get the unique column
or index that whose constraint was violated from a SQLException?
--
MySQL Java Mailing List
For list archives http //lists.myHello
In my MySQL database I have a column set as a YEAR type.
When I try to set the value from a prepared statement
I get a truncation exception.
What is the proper way to set a year colum fromHi
Is it possible to tell to connector/j to use a specific source address
for its database conection?
I googled and looked into the ml archive but was unable to find an answer...
Thanks for your Hi I have a java program that successfully keeps retrying to connect when
necessary to a mysql server until it is connected. When this cannot connect
I get Exceptions which is fine they are dealt wHi all
I 'm using Connector/MXJ in my application and it 's working great
except for one minor quirk. This happens when the user force-quits the
program (via something in the OS say). Normally when tHello co-listers
I 'm getting a syntax error through mysql-connector-java-5.0.4 although
the same sql command is executed with no problem by mysql-client.
The syntax error is near
"DELETE FROM tps
This is a note about the feature submission I sent on 26 Oct 2006.
When I try to compile it for java version 1.4 I find that it uses
a feature introduced in 1.5. The best way I see so far to make itMy MySQL version is 4.1.10
I use ?select * from t_table where t_col like ?%~%?
But all items that contain ?y? will be returned.
Is that means ?y? equals to ?~? ??
Thanks!
Winy Wan
wanyi@dear all
whether in MySql the data of auto_increase column could 't start
from 0 if i want to the data start from a number i seted how can i do.
another in the table with auto_incr
This is a solution to the problem I recently described on
java@(protected) resulting in the error message
PROCEDURE mydb.demoSp can 't return a result set in the given context
All I 've changed I 've seen lots of complaints about this error but no solutions.
Here 's what I would call at very least an interesting result.
I hope the developers read this. (How can I cause them to do so?)
I 'm us
Using mysql 5.0.18 I find that I cannot use the procedure
in the mysql-connector-java documention to call stored procedures.
The error I get is
Driver requires declaration of procedure to either coHi
I think i found a bug in the MySQL JDBC Connector
I wrote a programm to stresstest a mysql server. It works well on a
Linux-x86 system. But on a Sun V20z Solaris system the validation query
(Hi
if I select attachments (BLOB) larger than 80MB I get
java.sql.SQLException Already closed
I have tried to increase max_allowed_packet 60M to max_allowed_packet 250M
but that didn 't help eithHi
I 'd appreciate guidance on how to write a safe findOrCreate method. I 'd
like to write a method that given a natural key
-returns POJO representing a row (if one exists) or
-creates and insertI wish that I had more information than I currently do but here goes
We 're using Hibernate 3.2.0GA and we noticed that certain classes
"can 't be instantiated " from the database. Hibernate uses a I have searched hi and low..is there a place to
download the Falcon alpha special fork that is talked
about in the new 5.1 release docs.
http //dev.mysql.com/doc/refman/5.1/en/se-falcon.html
Thank YHello
I am wondering whether anyone has an MXJ jar that is more complete in
terms of the operating systems and processor types represented? I am
writing software that will likely be run in a pleHello
I am observing a strange behaviour of JDBC resultset type assignment.
The behaviour seems to be induced by using GROUP BY and CONCAT.
Here are the details about the setup
mysql-connector-javaSorry if the answer is already in the archives but
I have no idea on how to connect to MySQL 4.1.11 using java 1.5
I 'm trying this way
public static final String DRIVER "com.mysql.jdHi.
Is there a way to measure size (in bytes) of transferred ResultSets (in
a sense of network traffic)?
Thanks
Przemek
--
_/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/
Przemek Klein (p.klein@(protected)Hello
Is there a tutorial on using xA transactions with MySQL
from Connector/J?
I have been searching the web for one but nothing looks
basic enough.
Thanks
Neil
--
Neil Aggarwal (214)986-353Hi all
I have a table with three integer and one double values. I use
PreparedStatement.addBatch and PreparedStatement.executeBatch for adding data to
the table. If I run the program I get a
java
hello there. im encoutering problem in restoring my database using a text
file. everytime i run my codes nothing happens. this is my code
try
{
Runtime.getRuntime()Hi
Sorry if the answer is already in the archives
how do you convert from oracle 's
CREATE SYNONYM SACADM.SAC#REJECTS FOR SACOWN.REJECTS
TO MySQL having this table SACOWN.REJECTS
already creaHi dears
I 'm using the hibernate to orm and have this options
(dynamic-insert ?true? and dynamic-update ?true?) to do the sql updates.
Is faster use this option which mysql myisam?
Thanks
ViniciCouldn 't determine if this is a known issue or not but
useJDBCCompliantTimezoneShift seems to behave differently based on the
setting of useServerPrepStmts.
If useServerPrepStmts is set to true then 1) Sorry to be a whiner but the current process documented at http //
dev.mysql.com/doc/refman/5.0/en/connector-j-reference-using-ssl.html
seems to be a lot of steps. If my server is configured wihi..
i 'm using mysql server version 5.0.21-standard and am seeing this
wierd behavior that SUM of a numeric column returns a java.lang.String
!
was wondering if anyone else has seen this behaviodisclaimer 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 st |
|
|
