I was trying to install a Confluence instance in my hosting account. I had gone through the install and setup successfully locally on my Mac. But the setup on the host was failing:

2008-12-21 13:07:28,087 ERROR [TP-Processor8] [atlassian.config.bootstrap.DefaultAtlassianBootstrapManager] getTestDatasourceConnection Couldn’t open a connection on Datasource (java:comp/env/jdbc/confluence): org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Server connection failure during transaction. Due to underlying exception: ‘java.sql.SQLException: Access denied for user ‘foo_user’@'dz64.dailyrazor.com’ (using password: YES)’.</p> <p>** BEGIN NESTED EXCEPTION ** </p> <p>java.sql.SQLException<br /> MESSAGE: Access denied for user ‘foo_user’@'dz64.dailyrazor.com’ (using password: YES)</p> <p>STACKTRACE:</p> <p>java.sql.SQLException: Access denied for user ‘foo_user’@'dz64.dailyrazor.com’ (using password: YES)<br /> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)<br /> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)<br /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)<br /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)<br /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:894)<br /> at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3808)<br /> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1256)<br /> at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2182)<br /> at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)<br /> at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)<br /> at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)<br /> at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)<br /> at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)<br /> at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)<br /> at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)<br /> at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)<br /> at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.getTestDatasourceConnection(DefaultAtlassianBootstrapManager.java:403)<br /> at com.atlassian.confluence.setup.actions.SetupDatasourceAction.execute(SetupDatasourceAction.java:50)<br />

I kept receiving some sort of access error:
Access denied for user 'foo_user'@'dz64.dailyrazor.com' (using password: YES)

I tried establishing the database connection manually through DbVisualizer, which worked fine:

jdbc:mysql://domain.com:3306/db_name?autoReconnect=true

I looked more closely at the error and realized that something was appending the username with the individual server my account was being hosted on (i.e., dz64.dailyrazor.com). I had a hard time figuring out who was at fault – Confluence, Tomcat, DBCP, or MySQL.

The source of the problem appeared to be my Tomcat resource definition:

<Context path="/wiki" docBase="/path/to/tomcat/confluence-2.10-std/confluence" debug="0" reloadable="true"><br /> <Resource name="jdbc/confluence" auth="Container" type="javax.sql.DataSource"<br /> username="foo_user"<br /> password="password"<br /> driverClassName="com.mysql.jdbc.Driver"<br /> url="jdbc:mysql://domain.com:3306/db_name?autoReconnect=true"<br /> maxActive="15"<br /> maxIdle="7"<br /> validationQuery="Select 1" /><br /> </Context><br />

Googling around didn’t provide me any answers. I tried replacing “domain.com” in the “url” attribute with “dz64.dailyrazor.com”, but this didn’t achieve anything. In the end, I figured out that specifying “localhost” was the answer:

url="jdbc:mysql://localhost:3306/db_name?autoReconnect=true"

This is what I was doing on my Mac, but it took me a while to figure out that the same had to be done on my host.

If you enjoyed this post, you might want to follow this blog!

I’ve been running a Confluence installation (using a personal license) for a couple years. Recently, I’ve been experiencing some issues with it, and figured that it might be time to upgrade (from version 2.2.5, which is from July 2006, I’m guessing). At the time of this writing, the current version (and the version to which I wanted to upgrade), is version 2.10.

My upgrade process consisted of performing a clean install of version 2.10 and importing a backup of the content from my version 2.2.5 installation. According to the documentation, this is an expected and supported operation for these version numbers. But, it did not work. The error I received (in the atlassian-confluence.log file):

2008-12-20 12:00:56,428 WARN [Importing data task] [confluence.importexport.impl.ImportedProperty] saveLiteralProperty Unable to set property ‘owner’ on instance of ‘class com.atlassian.confluence.pages.Draft’ with id 13. This is probably due to internal data structure changes and doesn’t cause any data loss.<br /> — referer: http://localhost:8080/wiki/setup/setup-restore-start.action | url: /wiki/setup/setup-restore.action | userName: anonymous | action: setup-restore<br /> 2008-12-20 12:00:56,430 WARN [Importing data task] [confluence.importexport.impl.ImportedProperty] saveLiteralProperty Unable to set property ‘type’ on instance…<br /> 2008-12-20 12:00:56,431 WARN [Importing data task] [confluence.importexport.impl.ImportedProperty] saveLiteralProperty Unable to set property ‘spaceKey’ on instance…<br /> 2008-12-20 12:00:56,436 WARN [Importing data task] [confluence.importexport.impl.ImportedProperty] saveLiteralProperty Unable to set property ‘savedDate’ on instance…<br /> 2008-12-20 12:00:56,945 WARN [Importing data task] [confluence.importexport.impl.ImportedProperty] saveLiteralProperty Unable to set property ‘owner’ on instance of ‘class com.atlassian.confluence.pages.Draft’ with id 14. This is probably due to internal data structure changes and doesn’t cause any data loss.<br /> — referer: http://localhost:8080/wiki/setup/setup-restore-start.action | url: /wiki/setup/setup-restore.action | userName: anonymous | action: setup-restore<br /> 2008-12-20 12:00:56,946 WARN [Importing data task] [confluence.importexport.impl.ImportedProperty] saveLiteralProperty Unable to set property ‘type’ on instance…<br /> 2008-12-20 12:00:56,946 WARN [Importing data task] [confluence.importexport.impl.ImportedProperty] saveLiteralProperty Unable to set property ‘spaceKey’ on instance…<br /> 2008-12-20 12:00:56,946 WARN [Importing data task] [confluence.importexport.impl.ImportedProperty] saveLiteralProperty Unable to set property ‘savedDate’ on instance…<br /> 2008-12-20 12:00:58,660 WARN [Importing data task] [confluence.importexport.impl.ReverseDatabinder] writeObject Found duplicate key: class = com.atlassian.confluence.core.BodyContent, id = 2, skipping second object in import<br /> — referer: http://localhost:8080/wiki/setup/setup-restore-start.action | url: /wiki/setup/setup-restore.action | userName: anonymous | action: setup-restore<br /> 2008-12-20 12:00:58,788 ERROR [Importing data task] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Duplicate entry ’14′ for key 1<br /> — referer: http://localhost:8080/wiki/setup/setup-restore-start.action | url: /wiki/setup/setup-restore.action | userName: anonymous | action: setup-restore<br /> …<br /> net.sf.hibernate.exception.ConstraintViolationException: could not insert: [com.atlassian.confluence.pages.Page#14]<br /> — referer: http://localhost:8080/wiki/setup/setup-restore-start.action | url: /wiki/setup/setup-restore.action | userName: anonymous | action: setup-restore<br /> net.sf.hibernate.exception.ConstraintViolationException: could not insert: [com.atlassian.confluence.pages.Page#14]<br /> at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:73)<br /> at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)<br /> at net.sf.hibernate.persister.AbstractEntityPersister.convert(AbstractEntityPersister.java:1331)<br /> at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:472)<br /> at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)<br /> at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)<br /> at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449)<br /> at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435)<br /> at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392)<br /> at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261)<br /> at com.atlassian.confluence.importexport.impl.ReverseDatabinder.flushIfNeeded(ReverseDatabinder.java:532)<br /> at com.atlassian.confluence.importexport.impl.ReverseDatabinder.writeObject(ReverseDatabinder.java:505)<br /> …<br /> Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry ’14′ for key 1<br /> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)<br /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)

I did some Googling, but wasn’t able to find a solution. I looked closer at the information contained in the log and guessed that there were really only two records at issue, and that they both were drafts:

instance of 'class com.atlassian.confluence.pages.Draft' with id 13.

instance of 'class com.atlassian.confluence.pages.Draft' with id 14.

I opened the Confluence entities.xml file (located in the back-up zip) and searched for “draft”. As hoped, I found two elements:

<object class="Draft" package="com.atlassian.confluence.pages"><br /> <id name="id">13</id></p> <property name="pageId"><![CDATA[441]]></property> <property name="owner"><![CDATA[admin]]></property> <property name="type"><![CDATA[page]]></property> <property name="spaceKey"><![CDATA[dev]]></property> <property name="title"><![CDATA[FreeMarker Notes]]></property> <property name="content"><![CDATA[content... content... content]]></property> <property name="savedDate">2007-07-18 13:02:04.000</property> <property name="originalVersion">3</property> </object>

<object class="Draft" package="com.atlassian.confluence.pages"><br /> <id name="id">14</id></p> <property name="pageId"><![CDATA[700]]></property> <property name="owner"><![CDATA[admin]]></property> <property name="type"><![CDATA[page]]></property> <property name="spaceKey"><![CDATA[dev]]></property> <property name="title"><![CDATA[Blah Project - Reviews]]></property> <property name="content"><![CDATA[content... content... content]]></property> <property name="savedDate">2008-06-16 18:17:37.000</property> <property name="originalVersion">19</property> </object>

I deleted these two elements from the XML file, re-zipped the back-up, re-executed the import, and it worked perfectly.

If you enjoyed this post, you might want to follow this blog!

Fans of the Hibernate object-relational mapping (ORM) framework will realize that the Java Persistence API (JPA) is basically a standardization of that framework. And, if you’re like me, you really haven’t given much thought to JPA, because, gee, isn’t it just a watered-down Hibernate? Maybe, maybe not. (I’m not going to get into that here and now.)

It can be useful, though (even if only politically or procedurally), to code to JPA instead of the Hibernate API. If you find yourself in that situation, you may find this compare/contrast between the two API’s to be useful:

Additionally, there are a couple Hibernate-specific JPA-isms to keep in mind:

• If the underlying JPA implementation is Hibernate, either/both annotations or/and mapping files may be used – at the same time. In such a situation, I believe the mapping files act as an override for the annotations.
• The best of both worlds (in my mind) is to base the code (at an interface- or API-level) on JPA and its EntityManager, but to have the implementation interact with the Hibernate Session, which can be obtained by calling getDelegate() on the EntityManager.

If you enjoyed this post, you might want to follow this blog!