I'm trying to get Simper working with MySQL and I'm getting the following error
when I try to access http://localhost/simper (Tomcat 4.x running on port 80).
<exception>
javax.servlet.ServletException: Exception while Simper.initEverything tried to
invoke user-supplied initializer: java.lang.IllegalStateException: Invalid
sqlType: -1
at org.netmeme.simper.Simper.initEverything(Simper.java:260)
at org.netmeme.simper.Simper.doFilter(Simper.java:158)
</exception>
<root_cause>
java.lang.IllegalStateException: Invalid sqlType: -1
at org.netmeme.simper.Simper.getClassFromSQLType(Simper.java:401)
at org.netmeme.simper.Simper.registerTable(Simper.java:294)
at org.netmeme.simper.demo.DemoInit.init(DemoInit.java:41)
at org.netmeme.simper.Simper.initEverything(Simper.java:258)
at org.netmeme.simper.Simper.doFilter(Simper.java:158)
</root_cause>
SQL Script I used to load MySQL:
<sql_script>
--
-- SQL commands to generate the simperdemo database
--
CREATE TABLE IF NOT EXISTS authors (
id int NOT NULL,
name text,
email text,
Constraint authors_pkey Primary Key (id)
);
CREATE TABLE IF NOT EXISTS books (
id int NOT NULL,
id_author integer,
title text,
publishdate timestamp,
Constraint books_pkey Primary Key (id)
);
CREATE TABLE IF NOT EXISTS next_id_table (
table_name text,
next_id int
);
--INSERT INTO next_id_table (table_name, next_id) values ('authors', 0);
--INSERT INTO next_id_table (table_name, next_id) values ('books', 0);
--
-- Create a foreign key relationship (books.id_author to authors.id)
-- To my knowledge, MySQL does not support referential integrety...
alter table books add constraint fk_books_authors foreign key (id_author)
references authors (id)
</sql_script>
<log_messages>
[HttpProcessor[80][1]] DEBUG org.netmeme.simper.Simper - doFilter
[HttpProcessor[80][1]] DEBUG org.netmeme.simper.Simper - initEverything
[HttpProcessor[80][1]] DEBUG org.netmeme.simper.Simper -
initClassName=org.netmeme.simper.demo.Demo
Init
[HttpProcessor[80][1]] DEBUG org.netmeme.simper.demo.DemoInit - init
[HttpProcessor[80][1]] DEBUG org.netmeme.simper.Simper - registerDataSource
[HttpProcessor[80][1]] DEBUG org.netmeme.simper.Simper - registerTable(books)
[HttpProcessor[80][1]] DEBUG org.netmeme.simper.Simper - column name: id,
type: class java.lang.Int
eger
[HttpProcessor[80][1]] DEBUG org.netmeme.simper.Simper - column name:
id_author, type: class java.l
ang.Integer
</log_messages>
Any ideas?
Matt
__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
