On the off chance someone has tried to connect the InterSystems Cache database to Cocoon, I thought I'd ask for some assistance here...
I've taken the SQL Transformator (transformator?!) sample and replaced the hsqldb datasource with InterSystems'.
Here's the error I receive:
----------
Hello This is my first Cocoon2 page filled with sql data!
[SQLCODE: <-30>:<Table or View not found>] [Cache Error: <<SYNTAX>errdone+10^%qaqqt>] [Details: <FLoop - func = PP>] [%msg: < SQL ERROR #30: Table `SQLUSER.DEPARTMENT' not found>]
----------
Changes made to accomodate Cache:
1) Added to web.xml: <!-- Cache Driver: --> com.intersys.jdbc.CacheDriver
2) In cocoon.xconf: a) renamed "personnel" datasource to "personnel-old" b) added: <jdbc logger="core.datasources.personnel" name="personnel"> <pool-controller min="5" max="10"/> <dburl>jdbc:Cache://127.0.0.1:1972/TEST</dburl> <user>TestUser</user> <password>test</password> </jdbc>
The TEST database exists in Cache, and I added the user and checked permissions.
Should I expect this to work without further changes?
I can use Cache's SQL Manager tool and it doesn't look like the table is ever created or populated (makes sense, given the error message). I imagined table creation would occur upon the occasion of one of my page requests but I haven't quite figured out at what point this would be. Would appreciate a pointer...
Nope - it's not created automatically. It's already defined and prepopulated in hsql in the distribution just for ease of the demonstration, but if you want to use a different database you need to create and do any necessary pre-populating yourself. There is a .sql file somewhere in the source (either hsql block or database block) that could get you well on you way to doing that but you may need to modify it to work on your specific DB which I've no experience with.
Geoff
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
