Débutant java sql [Résolu]

[mmanas]

je doit créer les méthodes d'une DAO et les tester.
la création de la méthode update est faite mais le teste me renvoi l'erreur suivante ORA-00907:parenthèse de droite absente

ligneTicket.updateLigneTicketOTC("Lt1",1,"A",50,"Tar2","Tp","null",15,30,10,"A","commentaireConfi",
"SF",Date.valueOf("07-07-07"),10,"envoye","trainId","numeroOrdre","courtage",
"messageAllouant",3,"o",0,"Pd2","D2","T2","SL1","tS","ok","ST1","A","lg_LT",3,
"TypeEcheance",15,"quotite","EA","NotionalValueN","NotionalValueM","delta",
"FuturesIndexCrossed",Date.valueOf("07-07-07"),"Settlement","Exercise","Terms","GlobalPremium",
Timestamp.valueOf("2022-12-05 16:29:50.1456484"),"statutVersion","executiveBroker","modificateur");

sachant que je travail sur oracle XE, merci de m'apporter de l'aide

[miloux32]

Envoyé par mmanas

je doit créer les méthodes d'une DAO et les tester.
la création de la méthode update est faite mais le teste me renvoi l'erreur suivante ORA-00907:parenthèse de droite absente

ligneTicket.updateLigneTicketOTC("Lt1",1,"A",50,"Tar2","Tp","null",15,30,10,"A","commentaireConfi",
"SF",Date.valueOf("07-07-07"),10,"envoye","trainId","numeroOrdre","courtage",
"messageAllouant",3,"o",0,"Pd2","D2","T2","SL1","tS","ok","ST1","A","lg_LT",3,
"TypeEcheance",15,"quotite","EA","NotionalValueN","NotionalValueM","delta",
"FuturesIndexCrossed",Date.valueOf("07-07-07"),"Settlement","Exercise","Terms","GlobalPremium",
Timestamp.valueOf("2022-12-05 16:29:50.1456484"),"statutVersion","executiveBroker","modificateur");

sachant que je travail sur oracle XE, merci de m'apporter de l'aide

Poste ca sur le forum java plutot ....

[mmanas]

je vais le faire mais si vous préférez, vous pouvez le voir sous une requette sql:

update LigneTicket set ("Lt1",'1',"A",'50',"Tar2","Tp","null",'15','30','10',"A","commentaireConfi",
"SF",Date.valueOf("07-07-07"),10,"envoye","trainId","numeroOrdre","courtage",
"messageAllouant",'3',"o",'0',"Pd2","D2","T2","SL1","tS","ok","ST1","A","lg_LT",'3',
"TypeEcheance",15,"quotite","EA","NotionalValueN","NotionalValueM","delta",
"FuturesIndexCrossed",Date.valueOf("07-07-07"),"Settlement","Exercise","Terms","GlobalPremium",
Timestamp.valueOf("2022-12-05 16:29:50.1456484"), "statutVersion","executiveBroker","modificateur")

et voici les types des données:
String ligneTicketId, int numSplit, String sens, int quantite, String tarification, String Type, String echeanceManuelle, double prix, double prixRef, double brokerage, String franco, String commentaireConfi, String statutFacturation, Date dateValeur, double commission, String envoye, String trainId, String numeroOrdre, String courtage, String messageAllouant, int niveau,
String statut, int couverture, String produitId, String deviseId, String ticketId, String statutLigneId, String typeSplitId, String statutFacturationId, String sousTicketId, String critereFacturationId, String lg_LigneTicketId, int lg_NumSplit, String TypeEcheance, double Strike, String quotite, String EA,
Timestamp timeStamp, String statutVersion, String executiveBroker, String modificateur .