[Pljava-dev] ERROR: java.sql.SQLException: The url cannot benull

Joao,
Looks like the class org.compiere.sqlj.Compiere class needs some kind of
configuration. Right now it makes an attempt to obtain a connection
using null as an argument. It should be made to look for
"jdbc:default:connection:". My guess is that a property file is missing
from your setup. You'll have to ask someone who knows Compiere.

Regards,
Thomas Hallgren

Joao Vieira wrote:
>
> The query it's started from a desktop application, not a stored
> procedure, not a container.
>
> i belive this is what you ar asking for:
>
> 2006-02-28 00:25:53 LOG: Exception
> 2006-02-28 00:25:53 CONTEXT: PL/pgSQL function "currencybase" line 2
> at return
> 2006-02-28 00:25:53 LOG: in thread "main"
> 2006-02-28 00:25:53 CONTEXT: PL/pgSQL function "currencybase" line 2
> at return
> java.sql.SQLException: The url cannot be null
>
> at java.sql.DriverManager.getConnection(DriverManager.java:502)
>
> at java.sql.DriverManager.getConnection(DriverManager.java:193)
>
> at org.compiere.sqlj.Compiere.getConnection(Compiere.java:156)
>
> at org.compiere.sqlj.Compiere.prepareStatement(Compiere.java:180)
>
> at org.compiere.sqlj.Compiere.prepareStatement(Compiere.java:167)
>
> at org.compiere.sqlj.Compiere.getSQLValue(Compiere.java:203)
>
> at org.compiere.sqlj.Currency.base(Currency.java:56)
>
> 2006-02-28 00:25:53 ERROR: java.sql.SQLException: The url cannot be null
> 2006-02-28 00:25:53 CONTEXT: PL/pgSQL function "currencybase" line 2
> at return
> 2006-02-28 00:25:53 LOG: Exception
> 2006-02-28 00:25:53 CONTEXT: PL/pgSQL function "currencybase" line 2
> at return
> 2006-02-28 00:25:53 LOG: in thread "main"
> 2006-02-28 00:25:53 CONTEXT: PL/pgSQL function "currencybase" line 2
> at return
> java.sql.SQLException: The url cannot be null
>
> at java.sql.DriverManager.getConnection(DriverManager.java:502)
>
> at java.sql.DriverManager.getConnection(DriverManager.java:193)
>
> at org.compiere.sqlj.Compiere.getConnection(Compiere.java:156)
>
> at org.compiere.sqlj.Compiere.prepareStatement(Compiere.java:180)
>
> at org.compiere.sqlj.Compiere.prepareStatement(Compiere.java:167)
>
> at org.compiere.sqlj.Compiere.getSQLValue(Compiere.java:203)
>
> at org.compiere.sqlj.Currency.base(Currency.java:56)
>
> 2006-02-28 00:25:53 ERROR: java.sql.SQLException: The url cannot be null
> 2006-02-28 00:25:53 CONTEXT: PL/pgSQL function "currencybase" line 2
> at return
>
>
>
>
> -----Original Message-----
> From: Thomas Hallgren [mailto:thomas at tada.se]
> Sent: ter?a-feira, 28 de fevereiro de 2006 09:33
> To: Joao Vieira
> Cc: pljava-dev at gborg.postgresql.org
> Subject: Re: [Pljava-dev] ERROR: java.sql.SQLException: The url cannot
> benull
>
> Joao Vieira wrote:
> > org.postgresql.util.PSQLException: ERROR: java.sql.SQLException: The
> > url cannot be null; State=08001; ErrorCode=0
> > at
> > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
> > ecutorImpl.java:1512)
> > at
> > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
> > Impl.java:1297)
> > at
> > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
> > va:188)
> > at
> > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
> > ement.java:437)
> > at
> > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
> > Jdbc2Statement.java:353)
> > at
> > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
> > 2Statement.java:257)
> > at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source)
> > at
> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> > sorImpl.java:25)
> > at java.lang.reflect.Method.invoke(Method.java:585)
> > at
> > org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke
> > (PooledConnectionImpl.java:467)
> > at $Proxy1.executeQuery(Unknown Source)
> > at
> > org.compiere.util.CPreparedStatement.executeQuery(CPreparedStatement.
> > java:99)
> > at org.compiere.model.MTab.getTrxInfo(MTab.java:1422)
> > at org.compiere.apps.APanel.dataStatusChanged(APanel.java:823)
> > at org.compiere.model.MTab.fireDataStatusChanged(MTab.java:1790)
> > at org.compiere.model.MTab.setCurrentRow(MTab.java:1976)
> > at org.compiere.model.MTab.query(MTab.java:517)
> > at
> org.compiere.grid.GridController.query(GridController.java:534)
> > at org.compiere.apps.APanel.stateChanged(APanel.java:1004)
> > at
> javax.swing.JTabbedPane.fireStateChanged(JTabbedPane.java:290)
> > at
> > javax.swing.JTabbedPane$ModelListener.stateChanged(JTabbedPane.java:2
> > 22)
> >
> >
> Joao,
> This stacktrace origins from a JTabbedPane. I doubt that's what you
> have running inside a stored procedure. Can you please send some
> information about what's going on in the backend? Like the backend log
> for instance?
>
> Regards,
> Thomas Hallgren
>