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"><error>The 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"> <title>Hello</title> <content> <para>This is my first Cocoon2 page filled with sql data!</para> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0"> <query>select 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"/> <dburl>jdbc:sqlbase://myip:2155/mydb</dburl> <user>SYSADM</user> <password>mypasswd</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]>