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

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://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20060228/e7b83401/attachment.html>