java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Como soluciono esse problema???
Obrigado!
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Como soluciono esse problema???
Obrigado!
Boa pergunta. Sem seu código fica um pouco difícil de tentar ajudar. Poste-o aqui (e coloque-o entre as tags code).
Pela exception vc esqueceu de declarar 1 paramtero ? 
manda o código… deve ter menos parametros do que espera-se.
espero ter ajudado.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.Como soluciono esse problema???
Obrigado!
A frase em negrito acima já diz tudo 
Ae gente, foi mal o vacilo, sem o código fica difícil:
public Layout() {
//ResultSet rs = new ResultSet();
// TClientes.resultSet = rs;
initComponents();
try {
url = "jdbc:odbc:Paschoetoserieshistoricas";
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
connection = DriverManager.getConnection( url );
output.append( "Connection successful\n" );
} catch ( ClassNotFoundException cnfex ) {
// process ClassNotFoundExceptions here
cnfex.printStackTrace();
output.append( “Connection unsuccessful\n” +
cnfex.toString() );
} catch ( SQLException sqlex ) {
// process SQLExceptions here
sqlex.printStackTrace();
output.append( “Connection unsuccessful\n” +
sqlex.toString() );
} catch ( Exception ex ) {
// process remaining Exceptions here
ex.printStackTrace();
output.append( ex.toString() );
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
//
private void initComponents() {
jFrame1 = new javax.swing.JFrame();
PanelCliente = new javax.swing.JPanel();
Find = new javax.swing.JButton();
SClientes = new javax.swing.JButton();
NomeCliente = new javax.swing.JTextField();
try {
NomeSerie =(javax.swing.JTextField)java.beans.Beans.instantiate(getClass().getClassLoader(), “Layout_jTextField2”);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (java.io.IOException e) {
e.printStackTrace();
}
nCliente = new javax.swing.JLabel();
nSerie = new javax.swing.JLabel();
jScrollPane1 = new javax.swing.JScrollPane();
id = new javax.swing.JTextArea();
jScrollPane2 = new javax.swing.JScrollPane();
email = new javax.swing.JTextArea();
nID = new javax.swing.JLabel();
nEmail = new javax.swing.JLabel();
jScrollPane3 = new javax.swing.JScrollPane();
output = new javax.swing.JTextArea();
add = new javax.swing.JButton();
TituloCliente = new javax.swing.JLabel();
show = new javax.swing.JButton();
PanelSerie = new javax.swing.JPanel();
showSerie = new javax.swing.JButton();
findSerie = new javax.swing.JButton();
addSerie = new javax.swing.JButton();
addValue = new javax.swing.JButton();
NomeDaSerie = new javax.swing.JTextField();
jScrollPane4 = new javax.swing.JScrollPane();
idSerie = new javax.swing.JTextArea();
jScrollPane5 = new javax.swing.JScrollPane();
TpAgreg = new javax.swing.JTextArea();
jScrollPane6 = new javax.swing.JScrollPane();
Unidade = new javax.swing.JTextArea();
jScrollPane7 = new javax.swing.JScrollPane();
fonte = new javax.swing.JTextArea();
jScrollPane8 = new javax.swing.JScrollPane();
Tag = new javax.swing.JTextArea();
nSerieSerie = new javax.swing.JLabel();
nIDSerie = new javax.swing.JLabel();
nTp = new javax.swing.JLabel();
nUnidade = new javax.swing.JLabel();
nFonte = new javax.swing.JLabel();
jLabel10 = new javax.swing.JLabel();
tituloSerie = new javax.swing.JLabel();
cancel = new javax.swing.JButton();
help = new javax.swing.JButton();
org.jdesktop.layout.GroupLayout jFrame1Layout = new org.jdesktop.layout.GroupLayout(jFrame1.getContentPane());
jFrame1.getContentPane().setLayout(jFrame1Layout);
jFrame1Layout.setHorizontalGroup(
jFrame1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(0, 400, Short.MAX_VALUE)
);
jFrame1Layout.setVerticalGroup(
jFrame1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(0, 300, Short.MAX_VALUE)
);
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("Consulta Banco Dados");
setFont(new java.awt.Font("Arial", 1, 10));
PanelCliente.setBorder(new javax.swing.border.LineBorder(new java.awt.Color(102, 102, 102), 1, true));
PanelCliente.setFont(new java.awt.Font("Dialog", 1, 12));
Find.setText("Find");
Find.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
FindActionPerformed(evt);
}
});
SClientes.setText("Serie Clients");
NomeCliente.setText("Entre com o nome do cliente");
NomeCliente.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(153, 153, 153)));
nCliente.setText("Cliente:");
nSerie.setText("Serie:");
jScrollPane1.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
jScrollPane1.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER);
id.setColumns(20);
id.setEditable(false);
id.setRows(5);
jScrollPane1.setViewportView(id);
jScrollPane2.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
jScrollPane2.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER);
email.setColumns(20);
email.setEditable(false);
email.setRows(5);
jScrollPane2.setViewportView(email);
nID.setText("ID:");
nEmail.setText("Email:");
output.setColumns(20);
output.setEditable(false);
output.setLineWrap(true);
output.setRows(5);
output.setWrapStyleWord(true);
output.setInheritsPopupMenu(true);
jScrollPane3.setViewportView(output);
add.setText("ADD");
TituloCliente.setFont(new java.awt.Font("Dialog", 3, 18));
TituloCliente.setText("tbClientes");
show.setText("Show");
show.addContainerListener(new java.awt.event.ContainerAdapter() {
public void componentAdded(java.awt.event.ContainerEvent evt) {
showComponentAdded(evt);
}
});
org.jdesktop.layout.GroupLayout PanelClienteLayout = new org.jdesktop.layout.GroupLayout(PanelCliente);
PanelCliente.setLayout(PanelClienteLayout);
PanelClienteLayout.setHorizontalGroup(
PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(PanelClienteLayout.createSequentialGroup()
.addContainerGap()
.add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(org.jdesktop.layout.GroupLayout.TRAILING, PanelClienteLayout.createSequentialGroup()
.add(show)
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(Find))
.add(org.jdesktop.layout.GroupLayout.TRAILING, nEmail)
.add(org.jdesktop.layout.GroupLayout.TRAILING, nID)
.add(org.jdesktop.layout.GroupLayout.TRAILING, nSerie)
.add(org.jdesktop.layout.GroupLayout.TRAILING, nCliente))
.add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(PanelClienteLayout.createSequentialGroup()
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 141, Short.MAX_VALUE)
.add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING, false)
.add(org.jdesktop.layout.GroupLayout.LEADING, NomeSerie)
.add(org.jdesktop.layout.GroupLayout.LEADING, jScrollPane1)
.add(org.jdesktop.layout.GroupLayout.LEADING, jScrollPane2)
.add(org.jdesktop.layout.GroupLayout.LEADING, jScrollPane3)
.add(NomeCliente, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 626, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
.add(PanelClienteLayout.createSequentialGroup()
.add(12, 12, 12)
.add(SClientes)
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(add)
.add(217, 217, 217)
.add(TituloCliente, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 139, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
.addContainerGap())
);
PanelClienteLayout.setVerticalGroup(
PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(PanelClienteLayout.createSequentialGroup()
.addContainerGap()
.add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(PanelClienteLayout.createSequentialGroup()
.add(TituloCliente, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 32, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(37, 37, 37)
.add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
.add(NomeCliente, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(nCliente))
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
.add(NomeSerie, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(nSerie))
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
.add(jScrollPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 20, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(nID))
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
.add(jScrollPane2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 21, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(nEmail))
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.add(jScrollPane3, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
.add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
.add(Find)
.add(SClientes)
.add(add)
.add(show)))
.addContainerGap())
);
PanelSerie.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(102, 102, 102)));
showSerie.setText("Show");
findSerie.setText("Find");
addSerie.setText("ADD Serie");
addValue.setText("ADD Value");
NomeDaSerie.setText("Entre com o nome da s\u00e9rie");
jScrollPane4.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
jScrollPane4.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER);
idSerie.setColumns(20);
idSerie.setEditable(false);
idSerie.setRows(5);
jScrollPane4.setViewportView(idSerie);
jScrollPane5.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
jScrollPane5.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER);
TpAgreg.setColumns(20);
TpAgreg.setEditable(false);
TpAgreg.setRows(5);
jScrollPane5.setViewportView(TpAgreg);
jScrollPane6.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
jScrollPane6.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER);
Unidade.setColumns(20);
Unidade.setEditable(false);
Unidade.setRows(5);
jScrollPane6.setViewportView(Unidade);
jScrollPane7.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
jScrollPane7.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER);
fonte.setColumns(20);
fonte.setEditable(false);
fonte.setRows(5);
jScrollPane7.setViewportView(fonte);
jScrollPane8.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
jScrollPane8.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER);
Tag.setColumns(20);
Tag.setEditable(false);
Tag.setRows(5);
jScrollPane8.setViewportView(Tag);
nSerieSerie.setText("S\u00e9rie:");
nIDSerie.setText("ID:");
nTp.setText("TipoAgrega\u00e7\u00e3o:");
nUnidade.setText("Unidade:");
nFonte.setText("Fonte:");
jLabel10.setText("Tag:");
tituloSerie.setFont(new java.awt.Font("Dialog", 3, 18));
tituloSerie.setText("tbSeries");
org.jdesktop.layout.GroupLayout PanelSerieLayout = new org.jdesktop.layout.GroupLayout(PanelSerie);
PanelSerie.setLayout(PanelSerieLayout);
PanelSerieLayout.setHorizontalGroup(
PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(org.jdesktop.layout.GroupLayout.TRAILING, PanelSerieLayout.createSequentialGroup()
.addContainerGap()
.add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
.add(nTp)
.add(jLabel10)
.add(nFonte)
.add(nUnidade)
.add(nIDSerie)
.add(nSerieSerie)
.add(PanelSerieLayout.createSequentialGroup()
.add(showSerie)
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(findSerie)
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)))
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(addSerie)
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(jScrollPane8, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE)
.add(jScrollPane6, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE)
.add(jScrollPane5, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE)
.add(jScrollPane4, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE)
.add(NomeDaSerie, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE)
.add(org.jdesktop.layout.GroupLayout.TRAILING, jScrollPane7, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE)
.add(PanelSerieLayout.createSequentialGroup()
.add(addValue)
.add(194, 194, 194)
.add(tituloSerie, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 132, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
.addContainerGap())
);
PanelSerieLayout.setVerticalGroup(
PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(PanelSerieLayout.createSequentialGroup()
.addContainerGap()
.add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(PanelSerieLayout.createSequentialGroup()
.add(tituloSerie, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 44, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(35, 35, 35)
.add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
.add(NomeDaSerie, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(nSerieSerie))
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
.add(jScrollPane4, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 22, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(nIDSerie)))
.add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
.add(showSerie)
.add(findSerie)
.add(addSerie)
.add(addValue)))
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
.add(jScrollPane5, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 22, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(nTp))
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
.add(jScrollPane6, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 23, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(nUnidade))
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
.add(jScrollPane7, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 22, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(nFonte))
.add(12, 12, 12)
.add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
.add(jScrollPane8, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 23, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(jLabel10))
.addContainerGap(20, Short.MAX_VALUE))
);
cancel.setText("Cancel");
cancel.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
cancelActionPerformed(evt);
}
});
help.setText("Help");
org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(layout.createSequentialGroup()
.addContainerGap()
.add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(PanelSerie, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.add(org.jdesktop.layout.GroupLayout.TRAILING, layout.createSequentialGroup()
.add(help)
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(cancel))
.add(PanelCliente, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(org.jdesktop.layout.GroupLayout.TRAILING, layout.createSequentialGroup()
.addContainerGap()
.add(PanelCliente, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(PanelSerie, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(15, 15, 15)
.add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
.add(cancel)
.add(help))
.addContainerGap())
);
pack();
}// </editor-fold>
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
private void showComponentAdded(java.awt.event.ContainerEvent evt) {
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
private void cancelActionPerformed(java.awt.event.ActionEvent evt) {
System.exit(0);
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
private void FindActionPerformed(java.awt.event.ActionEvent evt) {
try {
if ( !NomeCliente.getText().equals( “” ) ) {
Statement statement =connection.createStatement();
String query = "SELECT * FROM tbClientes " +
“WHERE NomeCliente = '” +
NomeCliente.getText() + “’”;
output.append( "\nSending query: " +
connection.nativeSQL( query )
+ “\n” );
ResultSet rs = statement.executeQuery( query );
display( rs );
output.append( “\nQuery successful\n” );
statement.close();
} else
NomeCliente.setText(
“Enter last name here then press Find” );
} catch ( SQLException sqlex ) {
sqlex.printStackTrace();
output.append( sqlex.toString() );
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void display( ResultSet rs ) {
try {
rs.next();
int recordNumber = rs.getInt( 1 );
if ( recordNumber != 0 ) {
id.setText( String.valueOf( recordNumber));
NomeCliente.setText( rs.getString( 2 ) );
email.setText( rs.getString( 3 ) );
} else
output.append( "\nNo record found\n" );
} catch ( SQLException sqlex ) {
sqlex.printStackTrace();
output.append( sqlex.toString() );
}
}
ta ae!O código abaixo do comentário(gigante e confuso) foi gerado pelo netbeans. Antes esse cara funcionava!!!
Abs!
Ao que parece, é um problema na query.
Revise-a. Poste também todo o stack trace. Não se esqueça da tag code.
[]'s