Hello,
I am using Ver 8.41 Distrib 5.0.27, for apple-darwin8.5.1 on i686
==
My table definition:
==
mysql> show create table t1;
+---
+---
--
Hi,
Am using MySQL Connector/J 3.0 JDBC driver with 4.1.3-beta-standard on
OS X.
I have the following code snipet:
// ..
while (rs1 != null && rs1.next())
{
// ..
Calendar cal = Calendar.getInstance();
cal.clear();
cal.setTime(rs1.getTimestamp(i)); < ---
Everything was working fine. No changes were made and suddenly this
error shows up:
java.sql.SQLException: Server configuration denies access to data source
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:386)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1486)
at com.mysql.jdbc
What does the error mean ? - message from server: "Not unique
table/alias: 'USER_ROLE'"
This happens when I try to use the java code:
PreparedStatement pstmt = con.prepareStatement("Select * From
USER_ROLE, ROLE" +
"WHERE USER_ROLE.USERID = ? And USER_ROLE.ROLEID = ROLE.ID");
pstmt.setIn
I am using JDBC and trying to run this query.
Select DISTINCT COURSE.ID, COURSE.NAME, COURSE.CATEGORYID,
COURSE.DESCRIPTION " +
"COURSE.GRADELEVELS, COURSE.OWNERID from MEETING, COURSE,
INSTRUCTOR " +
"Where INSTURCTOR.ID = 1 And COURSE.INSTRUCTORID =
INSTRUCTOR.ID A
mary key i
have
already deleted from the mysql prompt.
When i try to enter a record with the same key using the mysql
prompt
the record successfully gets inserted into the table;
I suspect a bug in your jdbc driver .. .whats the solution or fix
to
this ?
regards,
Mu
