I've attached a stripped down resin.conf

you wrote "But the cluster store doesn't use jdbc." - BUT earlier in the thread you wrote "The jdbc store in Resin 4.0 acts as a backup to the normal cluster store."


which is it?

how can things like persistent sessions work in a load balanced scenario if all servers are not pointing to the same DB?

like I stated earlier in the thread - I haven't been using Resin's clustering setup... I have been relying on db persisted sessions to "tie" the server together... is this approach no longer valid with 4.0?

Does Caucho intend to support Oracle? or do I need to stay on a earlier version until I can figure out what I am going to do?





On 07/01/2011 11:41 AM, Scott Ferguson wrote:
On 07/01/2011 07:57 AM, Eric Kreiser wrote:
I changed my persistent-store type to be "cluster" instead of "jdbc"...
but it still doesn't start because it still needs the "new" resin
database tables... (which fail on create connecting to Oracle)
But the cluster store doesn't use jdbc. It wouldn't even know about the
Oracle database.

What does that section of the resin.xml look like?

-- Scott

thoughts?
Eric Kreiser


On 06/27/2011 02:24 PM, Eric Kreiser wrote:
the problem(I think) is that I don't use Resin's clustering... and rely
on the db persistent sessions to handle bouncing between servers.


On 06/27/2011 01:50 PM, Scott Ferguson wrote:
On 06/27/2011 10:39 AM, Eric Kreiser wrote:
I am trying to upgrade from 4.0.15 to 4.0.19.

The server fails to start.
For now, just set the persistent-store type="cluster" instead of "jdbc".

The jdbc store in Resin 4.0 acts as a backup to the normal cluster store.

-- Scott

The problem is that it is trying to create the "resin_data" and
"resin_mnode" database tables ... but the "create table" syntax is not
valid for Oracle.

--------------------------------------------------------------------------------------------------
06-27 12:38:29.146 JdbcMnodeStore[server]
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

06-27 12:38:29.146 CREATE TABLE resin_mnode (
                           id CHAR(64) PRIMARY KEY,
                           value CHAR(64),
                           cache_id CHAR(64),
                           expire_timeout BIGINT,
                           idle_timeout BIGINT,
                           lease_timeout BIGINT,
                           local_read_timeout BIGINT,
                           update_time BIGINT,
                           item_version BIGINT,
                           flags INTEGER,
                           server_version INTEGER)
06-27 12:38:29.149 [3ms]
jdbc/versioncloud.d0.0.0:exn-executeUpdate(CREATE TABLE resin_mnode (
                           id CHAR(64) PRIMARY KEY,
                           value CHAR(64),
                           cache_id CHAR(64),
                           expire_timeout BIGINT,
                           idle_timeout BIGINT,
                           lease_timeout BIGINT,
                           local_read_timeout BIGINT,
                           update_time BIGINT,
                           item_version BIGINT,
                           flags INTEGER,
                           server_version INTEGER)) ->
java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype

06-27 12:38:29.149 [0ms] jdbc/versioncloud.d0.0.0:close()
06-27 12:38:29.149 idle
ManagedPoolItem[jdbc/versioncloud,0,ManagedConnectionImpl]
06-27 12:38:29.149 jdbc/versioncloud.d0.0:clearWarnings()
06-27 12:38:29.149 java.lang.RuntimeException:
java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype

                             at
com.caucho.distcache.cluster.ClusterDataBacking.<init>(ClusterDataBacking.java:89)
                             at
com.caucho.distcache.cluster.ClusterCacheManagerImpl.createDataBacking(ClusterCacheManagerImpl.java:81)
                             at
com.caucho.server.distcache.AbstractCacheManager.start(AbstractCacheManager.java:1133)
                             at
com.caucho.distcache.cluster.ClusterCacheManagerImpl.start(ClusterCacheManagerImpl.java:90)
                             at
com.caucho.env.distcache.DistCacheSystem.start(DistCacheSystem.java:110)
                             at
com.caucho.env.service.ResinSystem.startServices(ResinSystem.java:513)
                             at
com.caucho.env.service.ResinSystem.start(ResinSystem.java:481)
                             at
com.caucho.server.resin.Resin.start(Resin.java:999)
                             at
com.caucho.server.resin.Resin.initMain(Resin.java:1127)
                             at
com.caucho.server.resin.Resin.main(Resin.java:1426)
                         Caused by: java.sql.SQLSyntaxErrorException:
ORA-00902: invalid datatype

                             at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
                             at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
                             at
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
                             at
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
                             at
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
                             at
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
                             at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)
                             at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
                             at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
                             at
oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1814)
                             at
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1779)
                             at
oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277)
                             at
com.caucho.sql.spy.SpyStatement.executeUpdate(SpyStatement.java:225)
                             at
com.caucho.sql.UserStatement.executeUpdate(UserStatement.java:230)
                             at
com.caucho.distcache.jdbc.JdbcMnodeStore.initDatabase(JdbcMnodeStore.java:256)
                             at
com.caucho.distcache.jdbc.JdbcMnodeStore.init(JdbcMnodeStore.java:196)
                             at
com.caucho.distcache.cluster.ClusterDataBacking.<init>(ClusterDataBacking.java:80)
                             ... 9 more
--------------------------------------------------------------------------------------------------


If I manually add the tables... the server starts... but I get errors.

--------------------------------------------------------------------------------------------------
06-27 12:07:31.860 jdbc/versioncloud.d0.0.5:prepareStatement(SELECT
d.id, d.expire_time, m.value FROM resin_mnode AS m LEFT JOIN resin_data
AS d ON(m.value = d.id))
06-27 12:07:31.866 [6ms]
jdbc/versioncloud.d0.0.5:exn-executeQuery(java.sql.SQLSyntaxErrorException:
ORA-00933: SQL command not properly ended
--------------------------------------------------------------------------------------------------



_______________________________________________
resin-interest mailing list
resin-interest@caucho.com
http://maillist.caucho.com/mailman/listinfo/resin-interest

_______________________________________________
resin-interest mailing list
resin-interest@caucho.com
http://maillist.caucho.com/mailman/listinfo/resin-interest



_______________________________________________
resin-interest mailing list
resin-interest@caucho.com
http://maillist.caucho.com/mailman/listinfo/resin-interest



_______________________________________________
resin-interest mailing list
resin-interest@caucho.com
http://maillist.caucho.com/mailman/listinfo/resin-interest

Attachment: resin.conf.2
Description: Unix manual page

_______________________________________________
resin-interest mailing list
resin-interest@caucho.com
http://maillist.caucho.com/mailman/listinfo/resin-interest

Reply via email to