On Thursday 09 August 2001 06:08 am, you wrote:
For what's happening now, you need to print out the SQL, make sure it's
syntactically correct, and print out the exception message that's returned.
Don't know if it's just me, but I find that I tend to make really dumb SQL
errors For later, you
A couple of points:
for your SQL try using a PreparedStatement and using the setXXX methods on it.
Greg's point about Patrick O'Reilly was that with your hardcoded update statement you
don't have any method of escaping single
quotes in the input data.
Also it looks like you are sending a string
snip /
.equals(passwd)
rather than
passwd.equals( )
snip /
No you shouldn't. That's totally evil. For a start, you're
creating another String object by doing
snip/
remark
As is a constant string, it is created just once. So there
is not much overhead.
True, other
Kyle Wayne Kelly
(504)391-3985
http://www.cs.uno.edu/~kkelly
- Original Message -
From: William Kaufman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 09, 2001 7:14 AM
Subject: RE: Using Tomcat with MSAccess
snip /
.equals(passwd)
rather than
passwd.equals
I was talking about String.equals().
Kyle Wayne Kelly
(504)391-3985
http://www.cs.uno.edu/~kkelly
- Original Message -
From: Beth Kelly [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 09, 2001 9:50 AM
Subject: Re: Using Tomcat with MSAccess
Kyle Wayne Kelly
(504)391
PROTECTED]]
Sent: Thursday, August 09, 2001 9:50 AM
To: [EMAIL PROTECTED]
Subject: Re: Using Tomcat with MSAccess
Kyle Wayne Kelly
(504)391-3985
http://www.cs.uno.edu/~kkelly
- Original Message -
From: William Kaufman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday
For what's happening now, you need to print out the SQL, make sure it's
syntactically correct, and print out the exception message that's returned.
Don't know if it's just me, but I find that I tend to make really dumb SQL
errors For later, you should ask yourself what will happen when Patrick
You ought to fire up a debugger and debug this.
Also, you could add some code in your catch to your insert statement that would write
output to a log file.
As for MS Access and JDBC: I've had some problems with this where resource leakage
would eventually cause the JDBC calls to slow to a
What's the actual error message?
Maybe you can print out the SQL statement to see if the syntax is OK. It
could be invalid SQL. Are you running this under Windows NT/2000 or
9x/ME? Maybe the user Tomcat runs under doesn't have access rights on
this database?
I don't really use Access, I'm just
to
Archive.
Jeff
- Original Message -
From: Bojan Smojver [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 03, 2001 10:23 PM
Subject: Re: Using Tomcat with MSAccess
What's the actual error message?
Maybe you can print out the SQL statement to see if the syntax is OK. It
could
10 matches
Mail list logo