Yes,
There are two functions with Simper where we do mapping of
java.sql.Types to Java classes, and vice versa.
The error you're getting is that the functions mentioned above don't yet
understand java.sql.Type of -1. Do you know offhand what type that is?
It can be added easily to Simper, I can make the change and commit to
sourceforge CVS in a flash.
Bryan
On Tue, 2002-03-05 at 05:11, Matt Raible wrote:
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]>
