Conn. Pool/SQL Taglib: Very strange error, plz help!

[da...@frost.as]

Greetings!

I am running Linux Redhat 7.0 and I am trying to access a MySQL table 
("mytable") in a database ("example") using the SQL Taglib (slightly 
modified "taglib.xml" from demos) and the Connection 
Pool, but I am getting a very strange error:


java.sql.SQLException: General error: Table 'test.column_type_table' doesn't 
exist


I have no idea where this 'test.column_type_table' comes from!! 
Please have a look at the error message and files below! This is driving me 
insane!!!

TIA

/Dave



***************
ERROR MESSAGE:
***************

java.sql.SQLException: General error: Table 'test.column_type_table' doesn't 
exist
at java.lang.Throwable.(Throwable.java:96)
at java.lang.Exception.(Exception.java:44)
at java.sql.SQLException.(SQLException.java:45)
at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Statement.execute(Statement.java)
at org.gjt.mm.mysql.jdbc2.Statement.execute(Statement.java:114)
at 
org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.processQuery
(XSPSQLLibrary.java:260)
at 
org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.executeQuery
(XSPSQLLibrary.java:165)
at _opt._tomcat._webapps._ROOT._samples._sql._taglib.populateDocument
(_taglib.java:134)
at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:96)
at org.apache.cocoon.processor.xsp.XSPProcessor.process
(XSPProcessor.java:494)
at org.apache.cocoon.Engine.handle(Engine.java:359)
at org.apache.cocoon.Cocoon.service(Cocoon.java:167)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at org.apache.tomcat.core.ServletWrapper.handleRequest
(ServletWrapper.java:503)
at org.apache.tomcat.core.ContextManager.service
(ContextManager.java:559)
at 
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection
(HttpConnectionHandler.java:160)
at org.apache.tomcat.service.TcpConnectionThread.run
(SimpleTcpEndpoint.java:338)
at java.lang.Thread.run(Thread.java:498)

**************
TAGLIB.XML:
**************
<?xml version="1.0"?>

<?cocoon-process type="xsp"?>

<xsp:page
language="java"
xmlns:sql="http://www.apache.org/1999/SQL"
xmlns:xsp="http://www.apache.org/1999/XSP/Core"
xmlns:request="http://www.apache.org/1999/XSP/Request"
>

<page title="SQL Search Results">

<sql:execute-query>
<sql:use-connection>default</sql:use-connection>
<sql:doc-element>things</sql:doc-element>

<sql:row-element>thing</sql:row-element>
<sql:column-format>
<sql:name>my_date</sql:name>
<sql:class>java.text.SimpleDateFormat</sql:class>
<sql:parameter>MM/dd/yyyy</sql:parameter>
</sql:column-format>
<sql:column-format>
<sql:name>my_time</sql:name>
<sql:class>java.text.SimpleDateFormat</sql:class>
<sql:parameter>hh:mm (ss)</sql:parameter>
</sql:column-format>
<sql:query>select * from mytable</sql:query>
</sql:execute-query>

</page>

</xsp:page>


********************
In COCOON.PROPERTIES:
********************

# Turbine DB Connection Pool
############################

# These are your database settings, look in the
# org.apache.turbine.util.db.pool.* package for more information.
processor.xsp.pool.database.default.driver=org.gjt.mm.mysql.Driver
processor.xsp.pool.database.default.url=jdbc:mysql://localhost:/example
processor.xsp.pool.database.default.username=root	
processor.xsp.pool.database.default.password=foo
processor.xsp.pool.database.default.maxConnections=3
processor.xsp.pool.database.default.expiryTime=3600000

# These are the supported jdbc-drivers and their adaptors.
# These properties are used by the DBFactory.
processor.xsp.pool.database.adaptor=DBWeblogic,DBOracle,DBInstantDB,DBPostgres,D
BSybase,DBInformix,DBMM
processor.xsp.pool.database.adaptor.DBWeblogic=weblogic.jdbc.pool.Driver
processor.xsp.pool.database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
processor.xsp.pool.database.adaptor.DBInstantDB=org.enhydra.instantdb.jdbc.idbDr
iver
processor.xsp.pool.database.adaptor.DBPostgres=postgresql.Driver
processor.xsp.pool.database.adaptor.DBInformix=com.informix.jdbc.IfxDriver
processor.xsp.pool.database.adaptor.DBSybase=com.sybase.jdbc.SybDriver
processor.xsp.pool.database.adaptor.DBMM=org.gjt.mm.mysql.Driver



-- 
Get your firstname@lastname email for FREE at http://Nameplanet.com/?su



-- 
Get your firstname@lastname email for FREE at http://Nameplanet.com/?su