show for both tables?
If it doesn't say 'Type=InnoDB' at the end, transactions won't work :(
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Client Connectivity
Office: +1 708 332 0507
www.mysql.com
-BEGIN PGP SIGNATURE-
Versi
is a 'feature' (many call a bug)
in BufferedInputStreams that causes them in some cases to want to read a
full buffer's worth of data when you're only asking for some portion of
it...That's what's happening here.
I'd try downloading something more recent for a J
even has some pointers
in the docs). There are plenty of documentation artifacts for JDBC
(books, tutorials, apidocs, etc), there's no reason for us to re-invent
the wheel there.
We implement the _standard_, there are very few 'extensions' to the JDBC
standard in the Connector/J
you think they are.
I can state from experience that _usually_ it's not at the database
level, however, it's usually a mismatch somewhere else that these
problems occur (but they are hard to debug sometimes :( )
Regards,
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Developmen
stmt).getLastInsertID()
> ;
> stmt.close();
> return (int)newKey;
> }catch (SQLException e){
Use MySQL's Connector/J 3.x or 3.1.x (they're what MM.MySQL 'grew up'
to), and use the JDBC-standard Statement.getGeneratedKeys() method to do
the same thin
s caused by a lost connection, or some other
error (section 4.4 under the following link):
http://www.mysql.com/documentation/connector-j/index.html#id2803835
-Mark (the guy who wrote the 'autoReconnect' functionality, and now
wishes he could remove it from the JDBC driver)
- --
Mr. Mark M
t documented anywhere).
If you follow the example given in the Tomcat documentation
_to_the_letter_ things work out fine. Once you have _that_ working, then
start tweaking from there. I've found that trying to plug the right
magic values from scratch into server.xml never works as
en change one thing at a time.
Unfortunately, Tomcat itself doesn't complain much up front when you
have something wrong with configuration, and it usually manifests itself
as an exception that's not related to what you've misconfigured :(
Regards,
-Mark
- --
Mr. Mark Ma
ipes will
give you a 50-60% performance improvement. It depends on the particular
version of Windows (first, it has to be NT-based, secondly the newer the
better).
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 332 0507
www.
t it will be delivered. You'll need to watch for 'bounce'
messages to see whether it was delivered or not, and even then, you
might not get those.
Perhaps a better way to do it might be to have different states, i.e.
confirmation email sent, user confirmed, etc?
Regards,
-Mark
27;XML way' to produce an ampersand
(&) is to use the entity &
So...Your connection URL would look like:
connectionURL="jdbc:mysql://localhost/authority?user=leeson&password="
Regards,
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE
11 matches
Mail list logo
