Subject RES: [Firebird-Java] FBException (STILL HAVING PROBLEMS)
Author Francisco Vieira
OK, these are the execeptions to one table with 3 lines
org.firebirdsql.jdbc.FBSQLException: GDS Exception. No message for code
335544558 found.
null
null
at
org.firebirdsql.jdbc.FBPreparedStatement.internalExecute(FBPreparedStatement
.java:426)
at
org.firebirdsql.jdbc.FBPreparedStatement.execute(FBPreparedStatement.java:38
5)
at tarifas.bConfirmarActionPerformed(tarifas.java:1929)
at tarifas.access$4200(tarifas.java:24)
at tarifas$76.actionPerformed(tarifas.java:995)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1450)
at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButto
n.java:1504)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:3
78)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:250)
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener
.java:216)
at java.awt.Component.processMouseEvent(Component.java:3715)
at java.awt.Component.processEvent(Component.java:3544)
at java.awt.Container.processEvent(Container.java:1164)
at java.awt.Component.dispatchEventImpl(Component.java:2593)
at java.awt.Container.dispatchEventImpl(Container.java:1213)
at java.awt.Component.dispatchEvent(Component.java:2497)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2451)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125)
at java.awt.Container.dispatchEventImpl(Container.java:1200)
at java.awt.Window.dispatchEventImpl(Window.java:914)
at java.awt.Component.dispatchEvent(Component.java:2497)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:339)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
va:131)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java
:98)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:85)
at org.firebirdsql.gds.GDSException: No message for code 335544558 found.
null
null
at
org.firebirdsql.jgds.GDS_Impl.readStatusVector(GDS_Impl.java:1698)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse(GDS_Impl.java:1651)
at
org.firebirdsql.jgds.GDS_Impl.isc_dsql_execute2(GDS_Impl.java:856)
at
org.firebirdsql.jca.FBManagedConnection.executeStatement(FBManagedConnection
.java:787)
at
org.firebirdsql.jdbc.FBConnection.executeStatement(FBConnection.java:1100)
at
org.firebirdsql.jdbc.FBPreparedStatement.internalExecute(FBPreparedStatement
.java:421)
at
org.firebirdsql.jdbc.FBPreparedStatement.execute(FBPreparedStatement.java:38
5)
at tarifas.bConfirmarActionPerformed(tarifas.java:1929)
at tarifas.access$4200(tarifas.java:24)
at tarifas$76.actionPerformed(tarifas.java:995)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1450)
at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButto
n.java:1504)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:3
78)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:250)
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener
.java:216)
at java.awt.Component.processMouseEvent(Component.java:3715)
at java.awt.Component.processEvent(Component.java:3544)
at java.awt.Container.processEvent(Container.java:1164)
at java.awt.Component.dispatchEventImpl(Component.java:2593)
at java.awt.Container.dispatchEventImpl(Container.java:1213)
at java.awt.Component.dispatchEvent(Component.java:2497)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2451)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125)
at java.awt.Container.dispatchEventImpl(Container.java:1200)
at java.awt.Window.dispatchEventImpl(Window.java:914)
at java.awt.Component.dispatchEvent(Component.java:2497)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:339)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
va:131)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java
:98)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:85)

>>-----Mensagem original-----
>>De: Ryan Baldwin [mailto:ryan.baldwin@...]
>>Enviada em: sexta-feira, 3 de outubro de 2003 18:59
>>Para: Firebird-Java@yahoogroups.com
>>Assunto: RE: [Firebird-Java] FBException (STILL HAVING PROBLEMS)
>>
>>
>>Hi,
>>
>>If you add the line
>>
>>e3.printStackTrace();
>>
>>in here ->
>>
>> }
>> catch (Exception e3)
>> {
>> e3.printStackTrace();
>>
>> T.getNew().Aviso("Erro nos VALORES", e3.toString());
>> }
>>
>>then a stack trace will be written to the console. If you post that entire
>>stack trace it may help to find the source of your problem.
>>
>>Also is your error message still looks like -
>>
>>org.firebirdsql.jdbc.FBSQLException: GDS Exception
>>No message for code 335544347 found.
>>null
>>null
>>
>>then there is a problem occuring with the error reporting which
>>is probarbly
>>caused by bad server setup. What version of firebird / interbase are you
>>using and how did you install it on your system ?
>>
>>Ryan
>>
>>
>>
>>-----Original Message-----
>>From: Francisco Vieira [mailto:franciscosouza2002@...]
>>Sent: 03 October 2003 21:16
>>To: Firebird-Java@yahoogroups.com
>>Subject: [Firebird-Java] FBException (STILL HAVING PROBLEMS)
>>
>>
>>
>>Look people, I am facing a problem that I have no idea how to
>>solve it, once
>>I tried all the ways I could, I JUST WANT TO INSERT some values in a table
>>and commit in the end if everything is alright, I suspected something was
>>wrong with the reading in the JTable I have, so I decided to put
>>the values
>>in some arrays just to be sure what was happening, HAVE A LOOK
>>PLEASE, this
>>time I used PreparedStatement and I´ve got the same Exception
>>message: null
>>null - FBSQLException GDS(something).
>>
>>WHAT COULD BE WRONG WITH THIS? WHY THE LOOP IS EXECUTED JUST
>>ONCE? HAVE YOU
>>EVER HAD SOMETHING LIKE THAT?
>>
>>int numRows = modTabValores.getRowCount();
>>int array_codigos[] = new int[numRows];
>>int array_linhas[] = new int[numRows];
>>String array_tipos[] = new String[numRows];
>>double array_inicios[] = new double[numRows];
>>double array_finais[] = new double[numRows];
>>double array_valores[] = new double[numRows];
>>for(int i=0; i < numRows; i++)
>>{
>> array_codigos[i] =
>>Integer.parseInt((String)tbValores.getValueAt(i,0));
>> array_linhas[i] =
>>Integer.parseInt((String)tbValores.getValueAt(i,1)); // (2)
>> array_tipos[i] =
>>((String)tbValores.getValueAt(i,2)).substring(0,1); // (3)
>> array_inicios[i] =
>>Double.parseDouble((String)tbValores.getValueAt(i,3)); // (4)
>> array_finais[i] =
>>Double.parseDouble((String)tbValores.getValueAt(i,4)); // (5)
>> array_valores[i] =
>>T.getNew().deMoedaParaDouble((String)tbValores.getValueAt(i,5)); // (6)
>>}
>> // ====== UNTIL HERE EVERYTHING IS OK
>>
>> try
>> {
>> int tamanho = array_codigos.length;
>> PreparedStatement st = c.prepareStatement("INSERT INTO
>>VALORTARIFAS VALUES(?, ?, ?, ?, ?, ?) ");
>> for(int i=0; i<tamanho; i++)
>> {
>> st.setInt(1, array_codigos[i]);
>> st.setInt(2, array_linhas[i]);
>> st.setString(3, array_tipos[i]);
>> st.setDouble(4, array_inicios[i]);
>> st.setDouble(5, array_finais[i]);
>> st.setDouble(6, array_valores[i]);
>> st.execute();
>> st.clearParameters();
>> }
>> }
>> catch (Exception e3)
>> {
>> T.getNew().Aviso("Erro nos VALORES", e3.toString());
>> }
>>
>>The metadata for the table used is:
>>/* Domain definitions */
>>CREATE DOMAIN DCOD AS INTEGER;
>>CREATE DOMAIN DVALOR AS NUMERIC(12, 2)
>> DEFAULT 0;
>>
>>/* Table: VALORTARIFAS, Owner: SYSDBA */
>>
>>CREATE TABLE "VALORTARIFAS"
>>(
>> "CODTABELA" "DCOD" DEFAULT 0,
>> "NUMLINHA" SMALLINT DEFAULT 0,
>> "TIPOTARIFA" CHAR(1) DEFAULT ' ',
>> "QUANTINICIO" NUMERIC(8, 3),
>> "QUANTFINAL" NUMERIC(8, 3),
>> "VALORFAIXA" "DVALOR" DEFAULT 0
>>);
>>
>>====================================================== END OF MY MESSAGE
>>
>>-----Mensagem original-----
>>De: Helen Borrie [mailto:helebor@...]
>>Enviada em: sexta-feira, 3 de outubro de 2003 10:20
>>Para: Firebird-Java@yahoogroups.com
>>Assunto: Re: [Firebird-Java] HELP HELP HELP - FBException
>>
>>
>>PLEASE DON'T SEND MESSAGES IN HTML!!
>>
>>At 08:52 AM 3/10/2003 -0300, you wrote:
>>
>>>This EXECPTION is driving me crazy, I have a Stored Procedure (in fact I
>>>have 3 for the same operation, but I am using try and catch to check each
>>>one) with 30 arguments to INSERT in a table wich has 3 NOT NULL fields,
>>
>>>one (the code) is INSERTED by a generator value incremented in
>>the TRIGGER
>>>(AFTER INSERT TRIGGER),
>>
>>2 problems:
>>1. if you have a column to be inserted by a trigger, you must
>>OMIT it from
>>your INSERT statement.
>>2. An AFTER INSERT trigger won't work. Any new.value for an insert or
>>update but be in a BEFORE INSERT trigger. Use AI triggers for inserting
>>values into OTHER tables.
>>
>>>the name is ALWAYS typed and the last, the date, is taken from the system
>>>date,
>>
>>The same problem: if you are trying to do this in a trigger - it must be
>>omitted from the INSERT statement and the trigger must be BEFORE
>>INSERT. But if you are sending CURRENT_DATE in your SQL, then
>>that's fine,
>>no problem.
>>
>>>but I've got this exception message everytime (even when I fill
>>in all the
>>>fields in the form):
>>>
>>>org.firebirdsql.jdbc.FBSQLException: GDS Exception
>>>No message for code 335544347 found.
>>>null
>>>null
>>
>>As Ryan said, you have the wrong message file on the server, the client or
>>both.
>>
>>Helen
>>
>>
>>
>>Yahoo! Groups Sponsor
>>ADVERTISEMENT
>>
>>
>>
>>
>>To unsubscribe from this group, send an email to:
>>Firebird-Java-unsubscribe@yahoogroups.com
>>
>>
>>
>>Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>>---
>>Outgoing mail is certified Virus Free.
>>
>>Checked by AVG anti-virus system (http://www.grisoft.com).
>>Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003
>>
>>
>>
>>To unsubscribe from this group, send an email to:
>>Firebird-Java-unsubscribe@yahoogroups.com
>>
>>
>>
>>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>>
>>
>>
>>
>>To unsubscribe from this group, send an email to:
>>Firebird-Java-unsubscribe@yahoogroups.com
>>
>>
>>
>>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>>
>>---
>>Incoming mail is certified Virus Free.
>>Checked by AVG anti-virus system (http://www.grisoft.com).
>>Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003
>>
---
Outgoing mail is certified Virus Free.

Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003