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
