i have this query on my application ...is via hibernate... select top ? tblvannes0_.GID as GID5_0_, tlkppropri1_.GID as GID21_1_, tblvannes0_.NO_CIVIQUE_DE as NO2_5_0_, tblvannes0_.DIAMETRE as DIAMETRE5_0_, tblvannes0_.PROFONDEUR_ECROU as PROFONDEUR4_5_0_, tblvannes0_.DIMENSION_ECROU as DIMENSION5_5_0_, tblvannes0_.DIAMETRE_COUVERCLE as DIAMETRE6_5_0_, tblvannes0_.DIAMETRE_BOITIER as DIAMETRE7_5_0_, tblvannes0_.HAUTEUR_CHAMBRE as HAUTEUR8_5_0_, tblvannes0_.LARGEUR_CHAMBRE as LARGEUR9_5_0_, tblvannes0_.LONGUEUR_CHAMBRE as LONGUEUR10_5_0_, tblvannes0_.PROFONDEUR_TOTALE_CHAMBRE as PROFONDEUR11_5_0_, tblvannes0_.PROFONDEUR_RESEAU_CHAMBRE as PROFONDEUR12_5_0_, tblvannes0_.DIAMETRE_CHEMINEE as DIAMETRE13_5_0_, tblvannes0_.LONGITUDE as LONGITUDE5_0_, tblvannes0_.LATITUDE as LATITUDE5_0_, tblvannes0_.DATE_CREATION as DATE16_5_0_, tblvannes0_.GID_VANNE_PROPRIETAIRE as GID17_5_0_, tblvannes0_.NBR_TOURS_MANIPULATION as NBR18_5_0_, tblvannes0_.POSITION_NORMALE as POSITION19_5_0_, tblvannes0_.NO_ARRONDISSEMENT as NO20_5_0_, tblvannes0_.NO_CIVIQUE_A as NO21_5_0_, tblvannes0_.ELEVATION as ELEVATION5_0_, tblvannes0_.ACTIVE as ACTIVE5_0_, tblvannes0_.REMARQUES as REMARQUES5_0_, tblvannes0_.DIAMETRE_CHAMBRE as DIAMETRE25_5_0_, tblvannes0_.THE_GEOM as THE26_5_0_, tblvannes0_.ZONE_GEO as ZONE27_5_0_, tblvannes0_.GID1_VANNE_PROPRIETAIRE as GID28_5_0_, tblvannes0_.TERRITOIRE as TERRITOIRE5_0_, tblvannes0_.FORME_ECROU as FORME30_5_0_, tblvannes0_.VIDANGE as VIDANGE5_0_, tblvannes0_.TYPE_JOINT as TYPE32_5_0_, tblvannes0_.INDICATEUR as INDICATEUR5_0_, tblvannes0_.DIVISION_INTERRESEAU as DIVISION34_5_0_, tblvannes0_.GID_PROPRIETAIRE as GID35_5_0_, tblvannes0_.MATERIAU_CHEMINEE as MATERIAU36_5_0_, tblvannes0_.OBSTRUCTION as OBSTRUC37_5_0_, tblvannes0_.SENS_MANIPULATION as SENS38_5_0_, tblvannes0_.ARRET_CORPORATION as ARRET39_5_0_, tblvannes0_.METHODE_MANIPULATION as METHODE40_5_0_, tblvannes0_.ACCES as ACCES5_0_, tblvannes0_.DEBITMETRE as DEBITMETRE5_0_, tblvannes0_.GID_INTERSECTION as GID43_5_0_, tblvannes0_.MECANISME as MECANISME5_0_, tblvannes0_.DECENTRE as DECENTRE5_0_, tblvannes0_.CADRE_CHEMINEE_AJUSTABLE as CADRE46_5_0_, tblvannes0_.LOCALISATION as LOCALIS47_5_0_, tblvannes0_.MODELE as MODELE5_0_, tblvannes0_.MATERIAU_CONDUITE as MATERIAU49_5_0_, tblvannes0_.MARQUE as MARQUE5_0_, tblvannes0_.ROBINET as ROBINET5_0_, tblvannes0_.GID_RUE as GID52_5_0_, tblvannes0_.CADRE_COUVERCLE_AJUSTABLE as CADRE53_5_0_, tblvannes0_.ECHELONS_CHEMINEE as ECHELONS54_5_0_, tblvannes0_.DERIVATION as DERIVATION5_0_, tblvannes0_.FORME_CHAMBRE as FORME56_5_0_, tblvannes0_.PURGEUR_AIR as PURGEUR57_5_0_, tblvannes0_.FORME_COUVERCLE as FORME58_5_0_, tblvannes0_.FORME_BOITIER as FORME59_5_0_, tblvannes0_.FORME_CHEMINEE as FORME60_5_0_, tblvannes0_.CARRE_ACCES_COUVERCLE as CARRE61_5_0_, tblvannes0_.MATERIAU_CHAMBRE as MATERIAU62_5_0_, tblvannes0_.PERSONNE as PERSONNE5_0_, tblvannes0_.ECHAPPEMENT_AIR as ECHAPPE64_5_0_, tblvannes0_.CADRE_BOITIER_AJUSTABLE as CADRE65_5_0_, tlkppropri1_.PROPRIETAIRE as PROPRIET2_21_1_ from VANNES.PUBLIC.TBLVANNES tblvannes0_ left outer join VANNES.PUBLIC.TLKPPROPRIETAIRES tlkppropri1_ on tblvannes0_.GID_PROPRIETAIRE=tlkppropri1_.GID where tlkppropri1_.GID=? order by tblvannes0_.GID asc [50200-154] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) at org.h2.message.DbException.get(DbException.java:167) at org.h2.message.DbException.get(DbException.java:144) at org.h2.table.RegularTable.doLock(RegularTable.java:501) at org.h2.table.RegularTable.lock(RegularTable.java:435) at org.h2.table.TableFilter.lock(TableFilter.java:142) at org.h2.command.dml.Select.queryWithoutCache(Select.java:590) at org.h2.command.dml.Query.query(Query.java:290) at org.h2.command.dml.Query.query(Query.java:260) at org.h2.command.dml.Query.query(Query.java:37) at org.h2.command.CommandContainer.query(CommandContainer.java:78) at org.h2.command.Command.executeQuery(Command.java:181) at org.h2.server.TcpServerThread.process(TcpServerThread.java:278) at org.h2.server.TcpServerThread.run(TcpServerThread.java:137) at java.lang.Thread.run(Unknown Source)
i hope can fix configuration something this is my jdbc parameter.. jdbc:h2:tcp://localhost/~/sampledb;LOCK_TIMEOUT=20000; -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
