Please raise a JIRA and attach your patch, thx ! On 6/7/07, servicemix servicemix <[EMAIL PROTECTED]> wrote:
Hi, I think that, there is a bug in JDBStoreFactory: when I open a store with: Store store=factory.open("store"); I receive an SQLException : Exception while creating database I move the connection.commit(); from JDBStoreFactory line 62 and it work... There is the source code of the function: public synchronized Store open(String name) throws IOException { if (adapter == null) { Connection connection = null; try { connection = getDataSource().getConnection(); adapter = JDBCAdapterFactory.getAdapter(connection); if (statements == null) { statements = new Statements(); statements.setStoreTableName(tableName); } adapter.setStatements(statements); if (createDataBase) { adapter.doCreateTables(connection); if(!connection.getAutoCommit()) connection.commit(); } connection.commit(); } catch (SQLException e) { throw (IOException) new IOException("Exception while creating database").initCause(e); } finally { if (connection != null) { try { connection.close(); } catch (Exception e) { } } } } JdbcStore store = stores.get(name); if (store == null) { store = new JdbcStore(this, name); stores.put(name, store); } return store; } Thanks.
-- Cheers, Guillaume Nodet ------------------------ Principal Engineer, IONA Blog: http://gnodet.blogspot.com/