Hi,
I'd like to suggest that you avoid the pattern of dynamic
construction of SQL, as in:
insertQuery = "INSERT INTO basePlusCommissionWorkers " +
"VALUES ( '" + socialSecurityNumber + "', '" +
grossSales +
"', '" + commissionRate + "', '" + baseSa
If I'm reading this correctly, you're putting single-quote delimiters
around the REAL value:
insertQuery = "INSERT INTO salariedWorkers VALUES ( '" +
socialSecurityNumber + "', '" + weeklySalary + "', '0' )";
MySQL would accept that, but Derby is a lot stricter. Drop the
single-quo
William B. wrote:
I keep receiving the error message above when I try to add a salary.
Please help
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.*;
public class Workers extends JFrame {
private Connection connection;
private Stat
I keep receiving the error message above when I try to add a salary. Please help
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.*;
public class Workers extends JFrame {
private Connection connection;
private Statement statemen
Daniel Piché wrote:
I am running Eclipse WTP.
I extracted the two Derby plugin files so that I now have the
org.apache.derby.core_10.2.1, org.apache.derby.plugin.doc_1.1.0 and
org.apache.derby.ui_1.1.0 folders in the Eclipse plugins folder.
However, when I use the context menu on a java pro
Daniel Piché wrote:
> I am running Eclipse WTP.
>
> I extracted the two Derby plugin files so that I now have the
> org.apache.derby.core_10.2.1, org.apache.derby.plugin.doc_1.1.0 and
> org.apache.derby.ui_1.1.0 folders in the Eclipse plugins folder.
>
> However, when I use the context menu on a
What would break if we "simply" change this such that NULL always
compares not equal with all other values including NULL?
Aside from a number of test cases for this particular case...
Craig
"not equal" would not work for the btree. It needs a reproducible
ordering for all key columns
I am running Eclipse WTP.
I extracted the two Derby plugin files so that I now have the
org.apache.derby.core_10.2.1, org.apache.derby.plugin.doc_1.1.0 and
org.apache.derby.ui_1.1.0 folders in the Eclipse plugins folder.
However, when I use the context menu on a java project, I dont get th
Hi,
I'm still not able to figure out what's wrong.
Are you able to write a reproduction of the bug which I may run?
Xanana Gusmao wrote (2006-12-13 04:18:45):
> Bernt,
>
> > 3) I would really hae liked to take peek at the connection pool your
> >are using to figure out what hap