It's LONGVARCHAR (== java.sql.Types value of -1). Two lines of code to
be added to Simper to support this... Will be doing another checking (to
sf) in the short term.
FYI, the "null" type is 0. And just what the heck does that mean? I've
never heard of a column type of null (as opposed to a column which
allows nulls, which is totally different).
Bryan
On Tue, 2002-03-05 at 20:47, Ted Husted wrote:
It's probably null. I've noticed that different pools handle this
differently. I believe Resin returns zero instead.
Bryan Field-Elliot wrote:
>
> 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]>
>
>
>
-- Ted Husted, Husted dot Com, Fairport NY US
-- Developing Java Web Applications with Struts
-- Tel: +1 585 737-3463
-> Web: http://husted.com/about/services
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
