Getting EXCEPTION_ACCESS_VIOLATION

[Mathias Nilsson]

Hi ranchers!
I'm having difficulties. I get an errormessage and the tomcat shuts down
Error message

#
# An EXCEPTION_ACCESS_VIOLATION exception has been detected in native
code outside the VM.
# Program counter=0x77f4200b
#

I get this when I try to login 2 times. see this message
ServletContextListener Class fails

// Mathias
[ November 04, 2003: Message edited by: Mathias Nilsson ]

[Mike Curwen]

looks like something is very unhappy, and those types of messages are not *usually* caused by your code (unless of course, you're actually doing JNI)

What is the JVM you are using?

I'm also quite suspicious of "sun.jdbc.odbc.JdbcOdbcDriver"

I'm not a big fan of the jdbc-odbc bridge driver.

[Mathias Nilsson]

What should I use instead of JDBC DBC driver? I have tried with
the javax.naming. java:env/jdbc or something like that but i coulden't get
it to run. Any suggestion? I use tomcat 4.0.1 , Windows 2003 server , Access 2000 as a database.
// Mathias

[Mike Curwen]

If you're using Access, you have no real choice (amongst free drivers) but to use the odbc-jdbc bridge.

It might be that some unhappy combination of the Windows OS and Access and the driver is causing you trouble.

[Mathias Nilsson]

Shall I try mySQL instead?

[Mike Curwen]

If you are not tied to using Access, then I would highly recommend using *any* other database. MySql is free, and very stable, very popular and there is lots of people with lots of experience using this database.

[Mathias Nilsson]

I have now downloaded MySQL but it does not support Stored procedures??
That is not good at all. how do you do a search with multiple conditions?
ex

CREATE   PROCEDURE SearchOrders
@OrderId VARCHAR( 255 ) ,
@FirstName VARCHAR( 255 ) ,
@LastName VARCHAR( 255 ) ,
@CountryCode CHAR( 2 ) ,
@OrderDate VARCHAR( 255 ) ,
@Status VARCHAR( 2 ) ,
@Email VARCHAR( 255 ) ,
@ArticleName VARCHAR( 255 )
AS
SELECT DISTINCT O.* FROM Orders o , OrderItem oi WHERE
 o.OrderId = oi.OrderId AND o.IsDeleted = 0 AND CONVERT( VARCHAR , o.OrderId ) like 
CASE WHEN Len( @OrderId ) > 0 Then '%' + @OrderId + '%' ELSE CONVERT( VARCHAR , o.OrderId ) END
AND FirstName LIKE CASE WHEN Len( @FirstName ) > 0 Then '%' + @FirstName + '%' ELSE o.FirstName END
AND LastName LIKE CASE WHEN Len( @LastName ) > 0 Then '%' + @LastName + '%' ELSE o.LastName END
AND Email LIKE CASE WHEN Len( @Email ) > 0 Then '%' + @Email + '%' ELSE o.Email END
AND CountryCode = CASE WHEN Len( @CountryCode ) > 0 Then @CountryCode  ELSE o.CountryCode END
AND OrderedAt >= CASE WHEN Len( @OrderDate ) > 0 Then @OrderDate  ELSE o.OrderedAt END
AND Status = CASE WHEN Len( @Status ) > 0 Then @Status  ELSE o.Status END
AND oi.Name LIKE CASE WHEN Len( @ArticleName ) > 0 Then '%' + @ArticleName + '%' ELSE oi.Name END
GO

// Mathias
[ November 07, 2003: Message edited by: Mathias Nilsson ]