[JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem
by niuxuetao_fiserv
Thanks Mircea,
Here is the table description:
| DESC cached_events
| Name Null Type
| ------------------------------ -------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| FQN NOT NULL VARCHAR2(255)
| NODE BLOB()
| PARENT VARCHAR2(255)
|
| 3 rows selected
|
And there is another table automatically created, called 'cached_events_d' which is not described in the jboss doc as far as I can find. And if I change the cache table's name to something else, say XXX, the automatically created table will be named as XXX_Y where Y looks a random character.
Do you know what this is for?
The description of this table is as below:
| DESC cached_events_d
| Name Null Type
| ------------------------------ -------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| I CHAR(1)
|
| 1 rows selected
|
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4241080#4241080
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4241080
16 years, 9 months
[Installation, Configuration & DEPLOYMENT] - jboss 4.2.2 question
by sunlinux
Hi,
we need to insert queries dynamically thru war application in mysql db 5.1
(around 54000 rows)
whenever we start upload the same from application we get
2009-07-01 09:07:34,440 ERROR [STDERR] com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1741081 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
2009-07-01 09:07:34,442 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2635)
2009-07-01 09:07:34,442 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)
2009-07-01 09:07:34,442 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552)
2009-07-01 09:07:34,442 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
2009-07-01 09:07:34,442 ERROR [STDERR] at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
2009-07-01 09:07:34,442 ERROR [STDERR] at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
2009-07-01 09:07:34,442 ERROR [STDERR] at com.mysql.jdbc.Statement.execute(Statement.java:529)
Pls. share any input on above
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4241065#4241065
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4241065
16 years, 9 months