Greg Monroe wrote:
> Hmm, at this point, I'd try doing a simple jsp page
> to manually open the DB and do a simple query with
> straight JDBC calls using the DB URL and other info
> in the Torque properties.
>
Thank you! The more direct call, gave the more useful error message:
java.sql.SQLException: Invalid authorization specification: Access denied
for user: '[EMAIL PROTECTED]' (Using password: YES)
Which led to the solution (a spurious MySQL SQL GRANT). The jsp used was:
<%@ page import="java.util.Properties" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Driver" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.PreparedStatement" %>
<%
Driver driver = (Driver)
Class.forName("com.mysql.jdbc.Driver").newInstance();
Properties props = new Properties();
props.setProperty("user", "xxx");
props.setProperty("password", "xxxxxxxx");
Connection conn = driver.connect("jdbc:mysql://localhost:3306/xxx",
props);
PreparedStatement stmt =
conn.prepareStatement("SELECT THING_ID, THING_NAME FROM XXX_THING");
ResultSet rs = stmt.executeQuery();
if( rs != null ) {
%>
<table>
<tr>
<th>THING ID</th>
<th>THING Name</th>
</tr>
<%
while( rs.next() ) {
%>
<tr><td><%= rs.getLong("THING_ID") %></td>
<td><%= rs.getString("THING_NAME") %></td></tr>
<%
}
%>
</table>
<%
} else {
%>
ResultSet was null!
<%
}
%>
And this resolved the more cryptic error message:
9839 [tcpConnection-6809-0] WARN oid.IDBroker - IDBroker is being used
with db 'default', which does not support transactions. IDBroker
attempts to use transactions to limit the possibility of duplicate key
generation. Without transactions, duplicate key generation is possible
if multiple JVMs are used or other means are used to write to the database.
Which had previously torqued us all off...
...and let us down the wrong paths.
...since the db is not named 'default',
....and since transactions were never the issue.
Thanks for the hints!
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
