By any chance, are those drive letters on your system? Larry
On 9/18/05, Ron Grabowski <[EMAIL PROTECTED]> wrote: > Whenever I try and run the StatementTest group in NUnit I get the > following error message: > > IBatisNet.DataMapper.Test.NUnit.SqlMapTests.StatementTest.TestCustomTypeHandler > : IBatisNet.Common.Exceptions.IBatisNetException : Unable to execute > the sql: other-init.sql > ----> ByteFX.Data.MySqlClient.MySqlException : Can't find file: > '.\ibatisnet\c.frm' (errno: 13) > > 'ibatisnet' is the name of the table in MySql, not a file path relating > to the IBatisNet source code. > > If I comment out this line from StatementTest: > > InitScript(sqlMap.DataSource, ScriptDirectory + "other-init.sql"); > > All the tests pass except for the one or two that rely on > other-init.sql. > > When I try to run other-init.sql from a mysql prompt the file starts > out ok: > > mysql> use IBatisNet; > Database changed > mysql> > mysql> drop table if exists Others; > Query OK, 0 rows affected (0.03 sec) > > mysql> drop table if exists A; > Query OK, 0 rows affected, 1 warning (0.00 sec) > > mysql> drop table if exists B; > Query OK, 0 rows affected, 1 warning (0.00 sec) > > mysql> drop table if exists C; > Query OK, 0 rows affected, 1 warning (0.00 sec) > > mysql> drop table if exists D; > Query OK, 0 rows affected (0.05 sec) > > mysql> drop table if exists E; > Query OK, 0 rows affected (0.04 sec) > > mysql> drop table if exists F; > Query OK, 0 rows affected (0.04 sec) > > But eventually I see the same error that I see in NUnit: > > mysql> > mysql> CREATE TABLE C ( > -> ID varchar(50) NOT MULL , > -> C_Libelle varchar(50) NULL , > -> primary key (ID) > -> ) TYPE=INNODB; > ERROR 1017 (HY000): Can't find file: '.\ibatisnet\c.frm' (errno: 13) > > The statement after that is executed fine: > > mysql> CREATE TABLE B ( > -> ID varchar(50) NOT NULL , > -> C_ID varchar(50) NULL , > -> D_ID varchar(50) NULL , > -> B_Libelle varchar(50) NULL , > -> primary key (ID) > -> ) TYPE=INNODB; > Query OK, 0 rows affected, 1 warning (0.09 sec) > > If I change the names of the tables from: > > A, B, C, D, etc. > > to: > > AA, BB, CC, DD, etc. > > everything works fine. Could it be that those table names are reserved? > > I'm using MySql 4.1.14-nt on a Windows Home machine. > > Could someone else running MySql 4.1 run these commands and report > their output: > > DROP TABLE IF EXISTS A; > DROP TABLE IF EXISTS B; > DROP TABLE IF EXISTS C; > DROP TABLE IF EXISTS D; > DROP TABLE IF EXISTS E; > DROP TABLE IF EXISTS F; > DROP TABLE IF EXISTS G; > DROP TABLE IF EXISTS H; > DROP TABLE IF EXISTS I; > DROP TABLE IF EXISTS J; > DROP TABLE IF EXISTS K; > DROP TABLE IF EXISTS L; > DROP TABLE IF EXISTS M; > DROP TABLE IF EXISTS N; > DROP TABLE IF EXISTS O; > DROP TABLE IF EXISTS P; > DROP TABLE IF EXISTS Q; > DROP TABLE IF EXISTS R; > DROP TABLE IF EXISTS S; > DROP TABLE IF EXISTS T; > DROP TABLE IF EXISTS U; > DROP TABLE IF EXISTS V; > DROP TABLE IF EXISTS W; > DROP TABLE IF EXISTS X; > DROP TABLE IF EXISTS Y; > DROP TABLE IF EXISTS Z; > > CREATE TABLE A (ID varchar(50) NOT NULL); > CREATE TABLE B (ID varchar(50) NOT NULL); > CREATE TABLE C (ID varchar(50) NOT NULL); > CREATE TABLE D (ID varchar(50) NOT NULL); > CREATE TABLE E (ID varchar(50) NOT NULL); > CREATE TABLE F (ID varchar(50) NOT NULL); > CREATE TABLE G (ID varchar(50) NOT NULL); > CREATE TABLE H (ID varchar(50) NOT NULL); > CREATE TABLE I (ID varchar(50) NOT NULL); > CREATE TABLE J (ID varchar(50) NOT NULL); > CREATE TABLE K (ID varchar(50) NOT NULL); > CREATE TABLE L (ID varchar(50) NOT NULL); > CREATE TABLE M (ID varchar(50) NOT NULL); > CREATE TABLE N (ID varchar(50) NOT NULL); > CREATE TABLE O (ID varchar(50) NOT NULL); > CREATE TABLE P (ID varchar(50) NOT NULL); > CREATE TABLE Q (ID varchar(50) NOT NULL); > CREATE TABLE S (ID varchar(50) NOT NULL); > CREATE TABLE R (ID varchar(50) NOT NULL); > CREATE TABLE T (ID varchar(50) NOT NULL); > CREATE TABLE U (ID varchar(50) NOT NULL); > CREATE TABLE V (ID varchar(50) NOT NULL); > CREATE TABLE W (ID varchar(50) NOT NULL); > CREATE TABLE X (ID varchar(50) NOT NULL); > CREATE TABLE Y (ID varchar(50) NOT NULL); > CREATE TABLE Z (ID varchar(50) NOT NULL); > > I was able to create most of the tables ok but I wasn't able to create > the tables mentioned in the subject: > > mysql> CREATE TABLE K (ID varchar(50) NOT NULL); > Query OK, 0 rows affected (0.18 sec) > > mysql> CREATE TABLE L (ID varchar(50) NOT NULL); > ERROR 1017 (HY000): Can't find file: '.\ibatisnet\l.frm' (errno: 13) > > mysql> CREATE TABLE M (ID varchar(50) NOT NULL); > Query OK, 0 rows affected (0.08 sec) > > Thanks, > Ron >
