C:\j2sdk1.4.2_08\source>java com.doc.samples.Test2
- Profiler Event: [QUERY] at    at java.sql.DriverManager.getConnection(DriverMa
nager.java:512) duration: 0 ms, connection-id: 0, statement-id: 999, resultset-i
d: 0, message: SET NAMES latin1
- Profiler Event: [FETCH] at    at java.sql.DriverManager.getConnection(DriverMa
nager.java:512) duration: 10 ms, connection-id: 0, statement-id: 999, resultset-
id: 0
- Profiler Event: [QUERY] at    at java.sql.DriverManager.getConnection(DriverMa
nager.java:512) duration: 0 ms, connection-id: 0, statement-id: 999, resultset-i
d: 0, message: SET character_set_results = NULL
- Profiler Event: [FETCH] at    at java.sql.DriverManager.getConnection(DriverMa
nager.java:512) duration: 0 ms, connection-id: 0, statement-id: 999, resultset-i
d: 0
- Profiler Event: [QUERY] at    at java.sql.DriverManager.getConnection(DriverMa
nager.java:512) duration: 0 ms, connection-id: 0, statement-id: 1, resultset-id:
 1, message: SHOW VARIABLES
- Profiler Event: [FETCH] at    at java.sql.DriverManager.getConnection(DriverMa
nager.java:512) duration: 10 ms, connection-id: 0, statement-id: 1, resultset-id
: 1
- Profiler Event: [WARN] at     at java.sql.DriverManager.getConnection(DriverMa
nager.java:512) duration: 0 ms, connection-id: 0, statement-id: 1, resultset-id:
 1, message: The following query was executed with a bad index, use 'EXPLAIN' fo
r more details: SHOW VARIABLES

Full stack trace of location where event occurred:



** BEGIN NESTED EXCEPTION **

java.lang.Throwable

STACKTRACE:

java.lang.Throwable
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1774)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2972)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
        at com.mysql.jdbc.Statement.executeQuery(Statement.java:822)
        at com.mysql.jdbc.Connection.loadServerVariables(Connection.java:3927)
        at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3
715)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2557)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:264)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at com.doc.samples.Test2.main(Test2.java:16)


** END NESTED EXCEPTION **



- Profiler Event: [QUERY] at    at java.sql.DriverManager.getConnection(DriverMa
nager.java:512) duration: 0 ms, connection-id: 0, statement-id: 2, resultset-id:
 2, message: SHOW COLLATION
- Profiler Event: [FETCH] at    at java.sql.DriverManager.getConnection(DriverMa
nager.java:512) duration: 10 ms, connection-id: 0, statement-id: 2, resultset-id
: 2
- Profiler Event: [WARN] at     at java.sql.DriverManager.getConnection(DriverMa
nager.java:512) duration: 0 ms, connection-id: 0, statement-id: 2, resultset-id:
 2, message: The following query was executed with a bad index, use 'EXPLAIN' fo
r more details: SHOW COLLATION

Full stack trace of location where event occurred:



** BEGIN NESTED EXCEPTION **

java.lang.Throwable

STACKTRACE:

java.lang.Throwable
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1774)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2972)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
        at com.mysql.jdbc.Statement.executeQuery(Statement.java:822)
        at com.mysql.jdbc.Connection.buildCollationMapping(Connection.java:1587)

        at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3
717)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2557)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:264)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at com.doc.samples.Test2.main(Test2.java:16)


** END NESTED EXCEPTION **



- Profiler Event: [QUERY] at    at java.sql.DriverManager.getConnection(DriverMa
nager.java:512) duration: 0 ms, connection-id: 0, statement-id: 999, resultset-i
d: 0, message: SET autocommit=1
- Profiler Event: [FETCH] at    at java.sql.DriverManager.getConnection(DriverMa
nager.java:512) duration: 0 ms, connection-id: 0, statement-id: 999, resultset-i
d: 0
- Profiler Event: [QUERY] at    at com.doc.samples.Test2.main(Test2.java:20) dur
ation: 10 ms, connection-id: 0, statement-id: 3, resultset-id: 3, message: selec
t * from persons where docwho like 'M%' or docwho = '1234567890
                                                                        x' or do
cwho = '2_34567890
                           x' or docwho = '3_34567890
                                                              x' or docwho = '4_
34567890
                 x' or docwho = '5_34567890
                                                    x' or docwho = '6_34567890

       x' or docwho = '7_34567890
                                          x' or docwho = '8_34567890
                                                                             x'
or docwho = '9_34567890                                ... (truncated)
- Profiler Event: [FETCH] at    at com.doc.samples.Test2.main(Test2.java:20) dur
ation: 0 ms, connection-id: 0, statement-id: 3, resultset-id: 3
- Profiler Event: [WARN] at     at com.doc.samples.Test2.main(Test2.java:20) dur
ation: 10 ms, connection-id: 0, statement-id: 3, resultset-id: 3, message: The f
ollowing query was executed with a bad index, use 'EXPLAIN' for more details: se
lect * from persons where docwho like 'M%' or docwho = '1234567890
                                                                           x' or
 docwho = '2_34567890
                              x' or docwho = '3_34567890
                                                                 x' or docwho =
'4_34567890
                    x' or docwho = '5_34567890
                                                       x' or docwho = '6_3456789
0
          x' or docwho = '7_34567890
                                             x' or docwho = '8_34567890

x' or docwho = '9_34567890                                ... (truncated)

Full stack trace of location where event occurred:



** BEGIN NESTED EXCEPTION **

java.lang.Throwable

STACKTRACE:

java.lang.Throwable
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1774)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2972)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
        at com.mysql.jdbc.Statement.executeQuery(Statement.java:822)
        at com.doc.samples.Test2.main(Test2.java:20)


** END NESTED EXCEPTION **



9
19
29
119
129
219
229
1219
1229
END OF DATA

C:\j2sdk1.4.2_08\source>