From: thomas at tada.se (Thomas Hallgren)
Date: Tue, 28 Feb 2006 15:04:56 +0100
Subject: [Pljava-dev] ERROR: java.sql.SQLException: The url cannot benull
In-Reply-To: <000401c63c6f$2ab2dfc0$3a0108c0@JOAOVIEIRA>
References: <000401c63c6f$2ab2dfc0$3a0108c0@JOAOVIEIRA>
Message-ID: <44045888.4050306@tada.se>

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
>