_
Subject: RE: Using Tomcat with MSAccess
Author: [EMAIL PROTECTED] (Greg Trasuk [EMAIL PROTECTED])
at INTERNET
Date:9.8.2001 0:08
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
]
Subject: Using Tomcat with MSAccess
I'm writing an applet using Tomcat to register new members
for a library.
Everything works fine until I get to the part where the new
information is
being inserted into the MSAccess DB. I have commented below
where the error
occurs. Any help
See remarks below.
-Ursprüngliche Nachricht-
Von: John Baker [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 9. August 2001 09:55
An: [EMAIL PROTECTED]
Betreff: Re: Using Tomcat with MSAccess
snip /
.equals(passwd)
rather than
passwd.equals( )
snip /
No you
See more remarks below :-)
-Ursprüngliche Nachricht-
Von: John Baker [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 9. August 2001 09:55
An: [EMAIL PROTECTED]
Betreff: Re: Using Tomcat with MSAccess
snip /
.equals(passwd)
rather than
passwd.equals( )
snip
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
PROTECTED]]
Sent: Friday, August 03, 2001 10:09 PM
To: [EMAIL PROTECTED]
Subject: Using Tomcat with MSAccess
I'm writing an applet using Tomcat to register new members
for a library.
Everything works fine until I get to the part where the new
information is
being inserted
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
I'm writing an applet using Tomcat to register new members for a library.
Everything works fine until I get to the part where the new information is
being inserted into the MSAccess DB. I have commented below where the error
occurs. Any help would be appreciated.
Thanks,
Jeff
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
14 matches
Mail list logo