RE: the url cannot be null
Maybe you're facing the same problem I've had with the SQL Transformer that is closing the connection too prematurely. * open connection * perform query * get resultset * close the connection-- I've had to move this step later * browse the resultset David -Mensaje original- De: I-Lin Kuo [mailto:[EMAIL PROTECTED] Enviado el: viernes, 30 de mayo de 2003 17:44 Para: [EMAIL PROTECTED] Asunto: RE: the url cannot be null I think you are missing sql:use-connectionconnection-name/sql:use-connection in testSQL.xml Thanks for the suggestion but that's not it. I don't need to specify that in testSQL.xml if I supply it as a parameter to the SQLTransformer in the pipeline as I've done. Besides, it's the same file in both cases, but one runs and the other doesn't. I did a little more searching and found the following on http://wiki.cocoondev.org/Wiki.jsp?page=UnderstandingCocoonMounts Components Inheritance of components have been a little problem between some versions of Cocoon, it's now solved. But after experience, it's not so bad to keep the components you need in each sitemap, especially to have your own names for generators or transformers, and be able to move your app under any other sitemap, or put it directly as root. So, maybe it's my SQLTransformer that's not being inherited in my subsitemap? I-Lin Kuo, Ann Arbor, MI Macromedia Certified ColdFusion 5.0 Advanced Developer Sun Certified Java 2 Programmer Ann Arbor Java Users Group (http://www.aajug.org) _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
the url cannot be null
cocoon 2.04: I have a problem that's bugging the hell out of me because it must be really simple. I'm hoping to get a fresh pair of eyes to look at this problem. I have a page to test the SQL connection that works from one directory but not the other. By works, I mean one returns: ... rowset nrofrows=1 row nowmay 30, 2003 10:55:37/now /row /rowset ... while the other returns: ... rowset errorThe url cannot be null/error /rowset ... My directory structure is: cocoon/ sitemap.xmap - myDev/ - test/ - prototype/ Minimalsitemap.xmap - xml/ where I have a main sitemap.xmap which mounts a subsitemap Minimalsitemap.xmap via: map:match pattern=NSFGProto/** map:mount check-reload=yes src=NSFGProto/Minimalsitemap.xmap uri-prefix=NSFGProto/ /map:match Here are the relevant snippets from the various sitemaps and the xml that tests the connection. !-- match from Minimalsitemap.xmap under prototype -- map:match pattern=testSQL map:generate src=xml/testSQL.xml/ map:transform type=sql map:parameter name=use-connection value=SSVDPool/ /map:transform map:serialize type=xml/ /map:match !-- match from sitemap.xmap under myDev -- map:match pattern=test/SSVDPool map:generate src=myDev/test/testSQL.xml/ map:transform type=sql map:parameter name=use-connection value=SSVDPool/ map:parameter name=show-nr-of-rows value=true/ /map:transform map:serialize type=xml/ /map:match !-- contents of testSQL.xml -- page xmlns:sql=http://apache.org/cocoon/SQL/2.0; titleSQLTransformer Test with sql:/title content para sql:execute-query sql:query select to_char(sysdate, 'month DD, HH24:MI:SS') Now from dual /sql:query /sql:execute-query /para /content /page Am I missing something obvious, or is there a problem with specifying the pool once I do a sitemap mount? And what does the error The url cannot be null mean? I-Lin Kuo, Ann Arbor, MI Macromedia Certified ColdFusion 5.0 Advanced Developer Sun Certified Java 2 Programmer Ann Arbor Java Users Group (http://www.aajug.org) _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: the url cannot be null
I think you are missing sql:use-connectionconnection-name/sql:use-connection in testSQL.xml -Original Message- From: I-Lin Kuo [mailto:[EMAIL PROTECTED] Sent: Friday, May 30, 2003 10:24 AM To: [EMAIL PROTECTED] Subject: the url cannot be null cocoon 2.04: I have a problem that's bugging the hell out of me because it must be really simple. I'm hoping to get a fresh pair of eyes to look at this problem. I have a page to test the SQL connection that works from one directory but not the other. By works, I mean one returns: ... rowset nrofrows=1 row nowmay 30, 2003 10:55:37/now /row /rowset ... while the other returns: ... rowset errorThe url cannot be null/error /rowset ... My directory structure is: cocoon/ sitemap.xmap - myDev/ - test/ - prototype/ Minimalsitemap.xmap - xml/ where I have a main sitemap.xmap which mounts a subsitemap Minimalsitemap.xmap via: map:match pattern=NSFGProto/** map:mount check-reload=yes src=NSFGProto/Minimalsitemap.xmap uri-prefix=NSFGProto/ /map:match Here are the relevant snippets from the various sitemaps and the xml that tests the connection. !-- match from Minimalsitemap.xmap under prototype -- map:match pattern=testSQL map:generate src=xml/testSQL.xml/ map:transform type=sql map:parameter name=use-connection value=SSVDPool/ /map:transform map:serialize type=xml/ /map:match !-- match from sitemap.xmap under myDev -- map:match pattern=test/SSVDPool map:generate src=myDev/test/testSQL.xml/ map:transform type=sql map:parameter name=use-connection value=SSVDPool/ map:parameter name=show-nr-of-rows value=true/ /map:transform map:serialize type=xml/ /map:match !-- contents of testSQL.xml -- page xmlns:sql=http://apache.org/cocoon/SQL/2.0; titleSQLTransformer Test with sql:/title content para sql:execute-query sql:query select to_char(sysdate, 'month DD, HH24:MI:SS') Now from dual /sql:query /sql:execute-query /para /content /page Am I missing something obvious, or is there a problem with specifying the pool once I do a sitemap mount? And what does the error The url cannot be null mean? I-Lin Kuo, Ann Arbor, MI Macromedia Certified ColdFusion 5.0 Advanced Developer Sun Certified Java 2 Programmer Ann Arbor Java Users Group (http://www.aajug.org) _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: the url cannot be null
I think you are missing sql:use-connectionconnection-name/sql:use-connection in testSQL.xml Thanks for the suggestion but that's not it. I don't need to specify that in testSQL.xml if I supply it as a parameter to the SQLTransformer in the pipeline as I've done. Besides, it's the same file in both cases, but one runs and the other doesn't. I did a little more searching and found the following on http://wiki.cocoondev.org/Wiki.jsp?page=UnderstandingCocoonMounts Components Inheritance of components have been a little problem between some versions of Cocoon, it's now solved. But after experience, it's not so bad to keep the components you need in each sitemap, especially to have your own names for generators or transformers, and be able to move your app under any other sitemap, or put it directly as root. So, maybe it's my SQLTransformer that's not being inherited in my subsitemap? I-Lin Kuo, Ann Arbor, MI Macromedia Certified ColdFusion 5.0 Advanced Developer Sun Certified Java 2 Programmer Ann Arbor Java Users Group (http://www.aajug.org) _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
JDBC Connection: The url cannot be null
Hello, i´ve got a problem connecting to SQLBase with JDBC and i hope someone here can give me a hint: When transforming an xml document with the sql-transformer i get an error: The url cannot be null. This is the result: rowset xmlns=http://apache.org/cocoon/SQL/2.0;errorThe url cannot be null/error/rowset I can see that jdbc driver connects to the database, so classes are found and loaded correctly. The dburl is correct to, the jdbc driver can connect with this url, username an password from within other applications without problems. This is my xml file called user.xml: ?xml version=1.0? page xmlns:sql=http://apache.org/cocoon/SQL/2.0; titleHello/title content paraThis is my first Cocoon2 page filled with sql data!/para execute-query xmlns=http://apache.org/cocoon/SQL/2.0; queryselect vorname,nachname from kickuser/query /execute-query /content /page This is my transformer: map:transformer logger=sitemap.transformer.sql name=sql src= org.apache.cocoon.transformation.SQLTransformer map:parameter name=use-connection value=mydb/ /map:transformer This is my sitemap match: map:match pattern=user map:generate src=user.xml/ map:transform type=sql/ map:serialize type=xml/ /map:match This is my datasource in cocoon.xconf: jdbc name=mydb pool-controller max=5 min=2/ dburljdbc:sqlbase://myip:2155/mydb/dburl userSYSADM/user passwordmypasswd/password /jdbc Joern - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]