R: R: R: R: R: App + ConnectorJ + MXJ deployment

Hi Eric, 

I added your foo table to my DB.  

I created the table by means of your SQL statement and inserted a few rows
by means of phpMyAdmin 2.8.2.4

As usual, my app connected properly when was unaware of connector-mxj and
failed with the redeployed customized connector-mxj including the new
data_dir.jar. 

The error message was the same as with my anlog00f table: 

061009 11:03:31 [ERROR] C:\roberto_test\mysql-mxj\bin\mysqld-nt.exe:
Incorrect information in file: '.\rua142\foo.frm'

The query which fails from my app can be executed successfully from the
interactive SQL query tool of phpMyAdmin 2.8.2.4 

To summarize, 

My data_dir.jar includes: 
1) the directories META-INF, mysql, test, rua142 (my DB with my table
anlog00f, your table foo and the file db.opt)
2) the files ib_logfile0, ib_logfile1, ib_data1 

My data_dir.jar was added to the directory 5-0-22 of the unpacked
connector-mxj where it replaced the existing data_dir.jar 


The following directories: 
5-0-22, 
com, 
META-INF 

And files: 
ConnectorMXJObjectTestExample.class, 
ConnectorMXJObjectTestExample.class,
kill.exe, 
TestDB.class, 
support-issue-8601-help-output.txt 

were packed together to form the new connector-mxj.jar. 

The new connector-mxj.jar was added to the directory where the previous
connector-mxj.jar was and replaced it. 

Two distinct paths to connector-mxj.jar and data_dir.jar are in the
CLASSPATH. 


Cheers
Roberto





-----Messaggio originale-----
Da: Eric Herman [mailto:[email protected]] 
Inviato: venerdì 6 ottobre 2006 18.16
A: tech
Cc: [email protected]
Oggetto: Re: R: R: R: R: App + ConnectorJ + MXJ deployment

Hi Roberto,

> from the console output you attached, looking at:
> 
> 060929 12:20:41 [ERROR] C:\roberto_test\mysql-mxj\bin\mysqld-nt.exe:
> Incorrect information in file: '.\rua142\anlog00f.frm'
> 
> That looks to me like mysqld-nt.exe 5.0.22 doesn't like the table.
> 
> What version of MySQL was used to create the custom data dir which was
> used to create the data_dir.jar file added to connector-mxj.jar?

Today I created a data directory using MySQL v5.0.24a (windows) and
populated the "test" database with a simple table:

create table foo( \
    id INTEGER NOT NULL AUTO_INCREMENT, \
    stuff TEXT NOT NULL, \
    PRIMARY KEY(id)) CHARACTER SET utf8 \
    ENGINE=InnoDB;

Next, I inserted half a dozen rows.

Then, I used this data directory with Connector/MXJ and it worked as
expected: I was able to do selects and inserts and deletes just fine.

At this point I'm not sure how to re-create the failure. 

Obviously there is something slightly different between what we are
seeing in your environment and what we are seeing in mine. 

If you can guide me through, step-by-step, a series of instructions that
will re-create the failure, I should be able to find the problem at fix
it. Without a failure I can experience, it is very hard to speculate.


Cheers,
 -Eric



-- 
Eric Herman, Software Developer
MySQL AB, www.mysql.com
VoIP Ext: 6594   US: +1 408 213 6540  Europe: +46 18 174 400
Mobile: +31 [0]6-20719662
Are you MySQL certified?  www.mysql.com/certification


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]