Thank you,Anil Gangoli.Thank you,Allen Gilliland.I am very apprecited and
excited.I finally successfully make it working after more than one week's
failure!
I made two indispensable changes:
I download ojdbc14.jar and copy it to %cantina_home%\common\lib,and comment
thesese lines in hibernate.cfg.xml:
<property name="hibernate.connection.driver_class">
oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.url">
jdbc:oracle:thin:@localhost:1521:TEST</property>
<property name="hibernate.connection.username">test</property>
<property name="hibernate.connection.password">test</property>
<property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect
</property>
Thank you all,and Merry Christmas!
-Jiang Ling
2005/12/19, Anil Gangolli <[EMAIL PROTECTED]>:
> Hi:
>
> Are you using the latest Oracle 10g (10.1.0.2) jdbc ojdbc14.jar in
> common/lib? If not, please try that. (Remove the 9i driver jars if you
> have them.) I would try the 10g jars even for the case of 9i server.
> Also make sure you are using ojdbc14.jar (NOT classes12.jar).
>
> If it continues to fail, it might be helpful to include the
> UnsupportedOperationException stack trace that was chopped off in your
> message. But I'm not sure.
>
> --a.
>
> 江岭 wrote:
>
> >I have expended one week to install roller2.0 but now i still have this
> >problem:I cannot see the register link in http://localhost:8181/roller/,
> >and in http://localhost:8181/roller/dstest.jsp, it displays success.I use
> >oracle9i for database and tomcat 5.0 for container.
> > My hibernate.cfg.xml is like this:
> >
> ><?xml version='1.0' encoding='utf-8'?>
> ><!DOCTYPE hibernate-configuration PUBLIC
> > "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
> > "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd
> ">
> ><hibernate-configuration>
> > <session-factory>
> >
> > <property name="show_sql">false</property>
> > <property name="connection.datasource
> >">java:comp/env/jdbc/rollerdb</property>
> > <property name="dialect">org.hibernate.dialect.Oracle9Dialect
> ></property>
> > <property name="hibernate.connection.driver_class">
> >oracle.jdbc.driver.OracleDriver</property>
> > <property name="hibernate.connection.url">
> >jdbc:oracle:thin:@localhost:1521:test1</property>
> > <property name="hibernate.connection.username">test1</property>
> > <property name="hibernate.connection.password">test1</property>
> > <property name="hibernate.dialect">
> >org.hibernate.dialect.Oracle9Dialect</property>
> >
> > <mapping resource="org/roller/business/HitCountData.hbm.xml" />
> > <mapping resource="org/roller/pojos/BookmarkData.hbm.xml" />
> > <mapping resource="org/roller/pojos/CommentData.hbm.xml" />
> > <mapping resource="org/roller/pojos/EntryAttributeData.hbm.xml"
> />
> > <mapping resource="org/roller/pojos/FolderAssoc.hbm.xml" />
> > <mapping resource="org/roller/pojos/FolderData.hbm.xml" />
> > <mapping resource="org/roller/pojos/WeblogTemplate.hbm.xml" />
> > <mapping
> >resource="org/roller/pojos/PingCategoryRestrictionData.hbm.xml" />
> > <mapping resource="org/roller/pojos/AutoPingData.hbm.xml" />
> > <mapping resource="org/roller/pojos/PingQueueEntryData.hbm.xml"
> />
> > <mapping resource="org/roller/pojos/PingTargetData.hbm.xml" />
> > <mapping resource="org/roller/pojos/RefererData.hbm.xml" />
> > <mapping resource="org/roller/pojos/RoleData.hbm.xml" />
> > <mapping resource="org/roller/pojos/RollerConfigData.hbm.xml" />
> > <mapping resource="org/roller/pojos/UserData.hbm.xml" />
> > <mapping resource="org/roller/pojos/UserCookieData.hbm.xml" />
> > <mapping resource="org/roller/pojos/WeblogCategoryData.hbm.xml"
> />
> > <mapping resource="org/roller/pojos/WeblogCategoryAssoc.hbm.xml"
> />
> > <mapping resource="org/roller/pojos/WeblogEntryData.hbm.xml" />
> > <mapping resource="org/roller/pojos/WebsiteData.hbm.xml" />
> > <mapping resource="org/roller/pojos/RollerPropertyData.hbm.xml"
> />
> > <mapping resource="org/roller/pojos/PermissionsData.hbm.xml" />
> > <mapping resource="org/roller/pojos/PlanetConfigData.hbm.xml" />
> > <mapping resource="org/roller/pojos/PlanetGroupData.hbm.xml" />
> > <mapping resource="org/roller/pojos/PlanetEntryData.hbm.xml" />
> > <mapping
> resource="org/roller/pojos/PlanetSubscriptionData.hbm.xml"
> >/>
> > <mapping
> >resource="org/roller/pojos/PlanetGroupSubscriptionAssoc.hbm.xml" />
> >
> > </session-factory>
> ></hibernate-configuration>
> >
> > and the server.xml is like this:
> >
> >
> >
> >...........
> >
> > <Context path="/roller" docBase="roller" debug="0">
> >
> > <Realm className="org.apache.catalina.realm.JDBCRealm"
> > driverName="oracle.jdbc.OracleDriver"
> > connectionURL=
> > "jdbc:oracle:thin:@localhost:1521:TEST1"
> > connectionName="test1"
> > connectionPassword="test1"
> > userTable="rolleruser"
> > userNameCol="username"
> > userCredCol="passphrase"
> > userRoleTable="userrole"
> > roleNameCol="rolename" debug="0" />
> >
> > <Resource name="jdbc/rollerdb" auth="Container" type="
> >javax.sql.DataSource" />
> >
> > <ResourceParams name="jdbc/rollerdb">
> > <parameter>
> > <name>factory</name>
> > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> > </parameter>
> > <parameter>
> > <name>driverClassName</name>
> > <value>oracle.jdbc.OracleDriver</value>
> > </parameter>
> > <parameter>
> > <name>url</name>
> > <value>jdbc:oracle:thin:@localhost:1521:TEST1</value>
> > </parameter>
> > <parameter><name>username</name><value>test1</value></parameter>
> > <parameter><name>password</name><value>test1</value></parameter>
> > <parameter><name>maxActive</name><value>20</value></parameter>
> > <parameter><name>maxIdle</name><value>3</value></parameter>
> >
> ><parameter><name>removeAbandoned</name><value>true</value></parameter>
> > <parameter><name>maxWait</name><value>3000</value></parameter>
> > </ResourceParams>
> > </Context>
> >
> >...........
> >
> > And the roller.log is like this:
> >
> > INFO 2005-12-19 09:35:44,453 BreadCrumbFilter:init - set breadcrumb
> >stack size to 3
> >INFO 2005-12-19 09:35:44,531 IfModifiedFilter:init - cache size is: 100
> >INFO 2005-12-19 09:35:44,531 IfModifiedFilter:init - cache timeout is:
> 1800
> >INFO 2005-12-19 09:35:44,546 LRUCacheHandler2:<init> - Initializing for:
> >PageCacheFilter
> >INFO 2005-12-19 09:35:44,546 LRUCacheHandler2:<init> - PageCacheFilter
> >size=100
> >INFO 2005-12-19 09:35:44,546 LRUCacheHandler2:<init> - PageCacheFilter
> >timeout=3600seconds
> >INFO 2005-12-19 09:35:44,562 LRUCacheHandler2:<init> - Initializing for:
> >RssCacheFilter
> >INFO 2005-12-19 09:35:44,562 LRUCacheHandler2:<init> - RssCacheFilter
> >size=100
> >INFO 2005-12-19 09:35:44,562 LRUCacheHandler2:<init> - RssCacheFilter
> >timeout=3600seconds
> >INFO 2005-12-19 09:35:44,562 LoginFilter:init - Remember Me enabled:
> true
> >INFO 2005-12-19 09:35:49,671 LoginServlet:init - secure login enabled:
> >false
> >INFO 2005-12-19 09:35:49,671 LoginServlet:init - secure login port: 443
> >FATAL 2005-12-19 09:35:55,750 PropertiesManagerImpl:init - Failed to
> >initialize runtime configuration properties.Please check that the
> database
> >has been upgraded!
> >java.lang.UnsupportedOperationException
> > at org.apache.commons.dbcp.PoolingDataSource.getConnection
> >
> >.......
> >
> > What's the problem?who can help me?THANKS!
> >
> >JiangLing
> >
> >
> >
>
>
