[jboss-user] [JBoss Cache] - JDBC Loader doesn't create table?
Sehee Lee
do-not-reply at jboss.com
Thu Jul 1 14:34:06 EDT 2010
Sehee Lee [http://community.jboss.org/people/tosehee75] created the discussion
"JDBC Loader doesn't create table?"
To view the discussion, visit: http://community.jboss.org/message/550668#550668
--------------------------------------------------------------
Hello.
Trying to configure the jboss cache.xml with JDBC loader and table.create=true, but it doesn't seem to be doing it.
Here is the snippet of config xml.
<loader async="true" fetchPersistentState="true" ignoreModifications="true" purgeOnStartup="true">
<properties>
cache.jdbc.table.name=JBOSSCACHE
cache.jdbc.table.create=true
cache.jdbc.table.drop=true
cache.jdbc.datasource=datasource_name
</properties>
<singletonStore>
<properties> pushStateWhenCoordinator=true pushStateWhenCoordinatorTimeout=20000</properties>
</singletonStore>
</loader>
and I get this exception..
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'staging.JBOSSCACHE' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
My question is..
Does cache.jdbc.table.create=true get ignored if using datasource for jdbc loader?
If so, is there a custom sql that I can run to create these tables manually?
Thanks in advance.
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/550668#550668]
Start a new discussion in JBoss Cache at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2052]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100701/2979a49a/attachment.html
More information about the jboss-user
mailing list