-- Bill K.
> -Original Message-
> From: Beth Kelly [mailto:[EMAIL 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
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
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
> >
> > > &g
>
> > > "".equals(passwd)
> > > rather than
> > > passwd.equals( "" )
>
> > No you shouldn't. That's totally evil. For a start, you're
> > creating another String object by doing ""
>
>
> As "" is a constant string, it is created just once. So there
> is not much overhead.
True, othe
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
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, y
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
O'
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 cr
ess properties are only set 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
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 t
10 matches
Mail list logo