[Seasar-user:7740] Re: [S2Pager]Postgres Forestの対応

2007年 5月 22日 (火) 08:54:17 JST

$B$*@$OC$K$J$j$^$9!#(B
$B;38}$G$9!#(B

$BD{@5$,$"$j$^$9!#(B
> $B"((BphpPgAdmin$B$b(Bport=9999$B$K$9$k$H;_$^$C$F$7$^$$$^$9!#(B 
$B$3$N7o$O4*0c$$$G!"<RFb$N%]!<%H$r9J$C$F$$$k;v$,860x$G$"$j!"(B
$B7R$,$k$+7R$,$i$J$$$+$b$o$+$j$^$;$s!#(B

$B%"%W%j%1!<%7%g%s<+BN$O(B9999$B%]!<%H$K@\B3$G$-$k>l=j$K$"$j$^$9!#(B

-----Original Message-----
From: [E-MAIL ADDRESS DELETED] [mailto:[E-MAIL ADDRESS DELETED]] On Behalf Of Kenji Yamaguchi
Sent: Tuesday, May 22, 2007 12:31 AM
To: [E-MAIL ADDRESS DELETED]
Subject: [Seasar-user:7738] Re:[S2Pager]Postgres Forest$B$NBP1~(B

$B$*@$OC$K$J$j$^$9!#(B
$B;38}$G$9!#(B

Postgres Forest$B$G$O$J$/(BPgpool$B-6$G$b;n$7$F$_$^$7$?!#(B

"jdbc:postgresql://localhost:9999/hogedb?protocolVersion=2" 
$B$@$[E-MAIL ADDRESS DELETED]>o$KF0$+$:!"(B
"jdbc:postgresql://localhost:9999/hogedb" 
$B$@$H!"(Blimit$B$r;H$o$J$$J}K!$[E-MAIL ADDRESS DELETED]>o$KF0:n$7$^$9!#(B

$B$?$@$7!":#2s$O(BTomcat$B$N5/F0$G%(%i!<$,=P$F$$$k$o$1$G$O$J$/(B
$B%G!<%?%Y!<%9$N@\B3$G;_$^$C$F$7$^$$$^$9!#(B
$B![E-MAIL ADDRESS DELETED]$K$O@\B3ItJ,$+$I$&$+$b%H%l!<%9$7$F$$$^$;$s$,40A4$K=hM}$,(B
$B!!JV$C$F$3$J$/$J$j$^$9!K(B
$B"((BphpPgAdmin$B$b(Bport=9999$B$K$9$k$H;_$^$C$F$7$^$$$^$9!#(B

cluster$B$O(BprotocolVersion=2$B$G$OBP1~$7$F$$$J$$$H$$$&;v$J$N$G$7$g$&$+!)(B
$B$@$s$@$s!"(BPager$B$+$iN%$l$F$$$C$F$$$k5$$,$7$^$9!#!#(B
$B$9$$$^$;$s!#(B

-----Original Message-----
From: Kenji Yamaguchi [mailto:[E-MAIL ADDRESS DELETED]]
Sent: Monday, May 21, 2007 12:10 PM
To: '[E-MAIL ADDRESS DELETED]'
Subject: RE: [Seasar-user:7722] Re:[S2Pager]Postgres Forest$B$NBP1~(B

$BK\4VMM(B

$B$*@$OC$K$J$j$^$9!#(B
> JDBC API$B$rD>@\8F$V%W%m%0%i%`$K$F!"@\B3$G$-$k$+!&(BCRUD$B$G$-$k$+(B
> $B$r$43NG'$$$?$@$1$^$9$G$7$g$&$+(B?
$B$3$A$i$O$9$0$K$O$G$-$J$$$N$G!"8=:_$N8=>]$[E-MAIL ADDRESS DELETED]@$5$;$F$$$?$@$-$^$9!#(B

<property name="URL">
 "jdbc:postgresforest:GSC=//localhost:5432/[E-MAIL ADDRESS DELETED]?protocolVersion=2" 
</property>
$B$H(B
hoge.dao.pager.PagerResultSetFactoryLimitOffsetWrapper
$B$NAH$_9g$o$;$@$H$[E-MAIL ADDRESS DELETED]@$5$;$F$$$?$@$$$?$h$&$K5/F0;~$K%(%i!<$,H/@8$7$^$9!#(B

<property name="URL">
 "jdbc:postgresforest:GSC=//localhost:5432/[E-MAIL ADDRESS DELETED]" 
</property>
$B$H(B
hoge.dao.pager.PagerResultSetFactoryLimitOffsetWrapper
$B$NAH$_9g$o$;$N$h$&$K(BprotocolVersion=2$B$rGS=|$9$k$H5/F0$[E-MAIL ADDRESS DELETED]>o$K9T$o$l$^$9!#(B
$B$?$@$7!"(BPager$B$r;H$C$?;~$ODL>o;~$K(BprotocolVersion=2$B$rIU$1$J$+$C$?>l9g$H(B
$BF1MM$N%(%i!<$K$J$j$^$9!#(B
$B!J$3$l$O(BPager$B$r;H$&>l9g$NCm0UE@$GGD0.$5$l$F$$$k%(%i!<$G$9!K(B

<property name="URL">
 "jdbc:postgresforest:GSC=//localhost:5432/[E-MAIL ADDRESS DELETED]" 
</property>
$B$H(B
org.seasar.dao.pager.PagerResultSetFactoryWrapper
$B$NAH$_9g$o$;$@$H(BPager$B!J(Blimit$B!K$r;H$o$J$$$d$jJ}$G(B
$B8+$?L\$NF0:n$[E-MAIL ADDRESS DELETED]>o$KF0$-$^$9!#(B

> $B@\B3(BURL$B$K860x$,$"$k$h$&$J5$$,$7$^$9!#(B
protocolVersion=2$B0J30$N(BURL$B$K4X$7$F$OJQ99$7$F$*$j$^$;$s$N$G(B
URL$B<+BN$,4V0c$($F$$$k$H$$$&;v$G$O$J$$$H;W$C$F$$$k$N$G$9$,!#(B

$B$9$$$^$;$s!#(B
$B$o$+$i$J$$;v$@$i$1$G!#!#(B

-----Original Message-----
From: [E-MAIL ADDRESS DELETED] [mailto:[E-MAIL ADDRESS DELETED]] On Behalf Of Hirotaka HONMA
Sent: Monday, May 21, 2007 11:10 AM
To: [E-MAIL ADDRESS DELETED]
Subject: [Seasar-user:7722] Re:[S2Pager]Postgres Forest$B$NBP1~(B

$BK\4V$G$9!#(B

$B%U%!%$%kE:IU$"$j$,$H$&$4$6$$$^$9!#(B
catalina.out$B$K$O(B
$B!V(BCaused by: org.postgresforest.util.PSQLException: Backend start-up failed: FATAL:  database "hogedb" does not exist$B!W(B
$B$H=PNO$5$l$F$$$^$9!#(B
$B$3$NItJ,$G$9!#(B

  Caused by: org.postgresforest.util.PSQLException: Backend start-up failed: FATAL:  database "hogedb" does not exist
  .
    at org.postgresforest.core.v2.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:340)
    at org.postgresforest.core.v2.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:80)
    at org.postgresforest.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
    at org.postgresforest.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
    at org.postgresforest.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
    at org.postgresforest.vm.jdbc.ForestConnection.<init>(ForestConnection.java:39)
    at org.postgresforest.Driver.makeConnection(Driver.java:420)
    at org.postgresforest.Driver.connect(Driver.java:291)
    at java.sql.DriverManager.getConnection(DriverManager.java:525)
    at java.sql.DriverManager.getConnection(DriverManager.java:171)
    at org.seasar.extension.dbcp.impl.XADataSourceImpl.getXAConnection(XADataSourceImpl.java:96)
    at org.seasar.extension.dbcp.impl.XADataSourceImpl.getXAConnection(XADataSourceImpl.java:86)
    at org.seasar.extension.dbcp.impl.ConnectionPoolImpl.createConnection(ConnectionPoolImpl.java:207)
    at org.seasar.extension.dbcp.impl.ConnectionPoolImpl.checkOut(ConnectionPoolImpl.java:169)
    at org.seasar.extension.dbcp.impl.DataSourceImpl.getConnection(DataSourceImpl.java:46)
    at org.seasar.extension.jdbc.util.DataSourceUtil.getConnection(DataSourceUtil.java:36)
    ... 49 more

S2$B$,(BDriverManager.getConnection$B$r8F$s$@%?%$%_%s%0$GNc30$,H/(B
$[E-MAIL ADDRESS DELETED]$7$F$$$k$N$G!"(BPager$B$O4X78$J$5$=$&$K;W$($^$9!#(B
$B$^$?%(%i!<%a%C%;!<%8$+$i;!$9$k$K!"@\B3(BURL$B$K860x$,$"$k$h$&$J(B
$B5$$,$7$^$9!#(B

JDBC API$B$rD>@\8F$V%W%m%0%i%`$K$F!"@\B3$G$-$k$+!&(BCRUD$B$G$-$k$+(B
$B$r$43NG'$$$?$@$1$^$9$G$7$g$&$+(B?

$B$h$m$7$/$*4j$$$$$?$7$^$9!#(B


on Fri, 18 May 2007 20:34:22 +0900
in [Seasar-user:7707] Re: [S2Pager]Postgres Forest$B$NBP1~(B
"Kenji Yamaguchi" <[E-MAIL ADDRESS DELETED]> wrote:

> $BK\4V$5$s(B
> 
> $B$*@$OC$K$J$j$^$9!#;38}$G$9!#(B
> catalina.out$B$H@\B3>pJs(B.dicon$B$rE:IU$7$^$9!#(B
> $B@\B3>pJs$N(Bfor PostgreSQL$BB&$G$[E-MAIL ADDRESS DELETED]>o$KF0$-!"(B
> for Postgres Forest$BB&$[E-MAIL ADDRESS DELETED]$jBX$($k$H%(%i!<$K$J$j$^$9!#(B
> 
> for Postgres Forest$BC1BN$G$[E-MAIL ADDRESS DELETED]>o$KF0$$$F$$$k;v$O(B
> $B3NG'$G$-$F$$$^$9$,!"%W%m%0%i%`$+$i07$C$?;v$,$"$j$^$;$s!#(B
> S2Pager$B$N860x$+$I$&$+$b$o$+$j$^$;$s$,!#!#(B
> 
> [$B$*$^$1(B]
> "jdbc:postgresforest:GSC=//localhost:5432/[E-MAIL ADDRESS DELETED]"$B$K$7$F(B
> PagerResultSetFactoryWrapper$B$K$9$k$H(BPager$B$r;H$o$J$$@_Dj$G(B
> $B;2>H$O$G$-$F$$$^$9!#(B
> $B"($?$@$7!"$3$A$i$G$b%7!<%1%s%7%c%k$,$9$9$^$:!"(Binsert$B$G(B
> $B!!0l0U@)Ls%(%i!<$,$G$k$H$$$&LdBj$,=P$F$$$^$9!#(B
> $B!!!J$3$l$O(BPager$B$NLdBj$G$O$J$$$G$9$,!K(B
> S2Dao$B$,=PNO$7$?%m%0(B
> 2007/05/18 19:18:52.501 select nextval ('hogetbl_id_seq')
> 2007/05/18 19:18:52.508 INSERT INTO HOGETBL (id, c1, c2) VALUES (1, 
> 'A1', 'B1')
> 2007/05/18 19:18:52.510 select nextval ('hogetbl_id_seq')
> 2007/05/18 19:18:52.511 INSERT INTO HOGETBL (id, c1, c2) VALUES (1, 
> 'A2', 'B2')
> 
> $B$h$m$7$/$*4j$$$7$^$9!#(B

_______________________________________________
Seasar-user mailing list
[E-MAIL ADDRESS DELETED]
https://ml.seasar.org/mailman/listinfo/seasar-user