[java] Problema assurdo Freechart [Archivio]

Dolcezeus

05-07-2010, 09:56

public static JDBCXYDataset GetAcuvisionResult(String CodFis) throws ClassNotFoundException, SQLException{

Connection conn = null;
JDBCXYDataset dataset = null;
String sql ="select Score, Date from Results where Codfis="+CodFis;
System.out.println(sql);
try
{
Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
//Get a connection
conn = DriverManager.getConnection("jdbc:derby:DBAcuvision;user=admin;password=admin");
dataset = new JDBCXYDataset(conn);
dataset.executeQuery(sql);
dataset.close();
conn.close();
}
catch (Exception except)
{
except.printStackTrace();
}

return dataset;
}

Cari amici ho dei problemi con questo codice l'errore che mi riporta eclipse è alla riga dataset.executeQuery(sql) precisamente ricevo :

java.sql.SQLSyntaxErrorException: La colonna 'T***********' non si trova in una tabella nell'elenco FROM, oppure compare in una specifica di collegamento ed è esterna all'ambito di tale specifica, oppure compare in una clausola HAVING e non nell'elenco GROUP BY. Se si tratta di un'istruzione CREATE o ALTER TABLE, 'T**************' non è una colonna della tabella di destinazione.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
at org.jfree.data.jdbc.JDBCXYDataset.executeQuery(JDBCXYDataset.java:242)
at org.jfree.data.jdbc.JDBCXYDataset.executeQuery(JDBCXYDataset.java:213)
at org.jfree.data.jdbc.JDBCXYDataset.<init>(JDBCXYDataset.java:177)
at acuvision.Utility.GetAcuvisionResult(Utility.java:522)
at acuvision.PatientPanel.initGUI(PatientPanel.java:449)
at acuvision.PatientPanel.<init>(PatientPanel.java:115)
at acuvision.MainPatientPanel.mouseclicked(MainPatientPanel.java:571)
at acuvision.MainPatientPanel$3.mouseClicked(MainPatientPanel.java:367)
at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253)
at java.awt.Component.processMouseEvent(Component.java:6351)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6113)
at java.awt.Container.processEvent(Container.java:2085)
at java.awt.Component.dispatchEventImpl(Component.java:4714)
at java.awt.Container.dispatchEventImpl(Container.java:2143)
at java.awt.Component.dispatchEvent(Component.java:4544)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4618)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4291)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4212)
at java.awt.Container.dispatchEventImpl(Container.java:2129)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4544)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:635)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

il problema è assurdo perchè se utilizzo un prepareStatement normale e stampo il resultset non ottengo errori ergo il database è pieno ed è logicamente corretto, vi prego aiutatemi non sò più come fare.