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

[Joao Vieira]

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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pljava-dev/attachments/20060228/e7b83401/attachment.html