| Stuck on JBoss datasource [message #240441] |
Wed, 30 May 2007 16:19  |
Eclipse User |
|
|
|
Originally posted by: behrens.offis.de
Hi everyone,
I am quite new to BIRT and am facing some probs getting up to speed. I
would like to integrate the BIRT engine to generate / view reports in a
EJB3 application. I followed the instructions (using the Runtime Release
Build 2.1.2) given at
http://www.eclipse.org/birt/phoenix/deploy/viewerSetup.php. I got the app
deployed allright, allthough I somehow do not get the testreport displayed
in the frameset (shows using run though).
I now would like to use a datasource within the testreport, just to slowly
get going. This is however where I am stuck... I would like to use a JNDI
datasource configured under JBoss (see below). The DS is allright because
our app uses it allright. I used the RCP designer to add a DS to it (see
below) and redeployed the report / complete app. Calling the report only
gives me the stacktrace below. I am obviously missing something but am
stuck because I can not find any further instructions. Any help / pointer
to a (working) tutorial would be great (I allready tried to eclipse
magazine 01-2007 article...)
TIA & cheers, Jan
java.lang.NullPointerException at
org.eclipse.birt.report.model.elements.OdaDataSource.setIntr insicProperty(OdaDataSource.java:201)
at
org.eclipse.birt.report.model.core.DesignElement.setProperty (DesignElement.java:1192)
at
org.eclipse.birt.report.model.core.DesignElement.setProperty (DesignElement.java:1162)
at
org.eclipse.birt.report.model.parser.DesignParseState.setPro perty(DesignParseState.java:99)
at
org.eclipse.birt.report.model.parser.OdaDataSourceState.pars eODADataSourceExtensionID(OdaDataSourceState.java:167)
at
org.eclipse.birt.report.model.parser.OdaDataSourceState.pars eAttrs(OdaDataSourceState.java:82)
at
org.eclipse.birt.report.model.parser.ModuleParserHandler.sta rtElement(ModuleParserHandler.java:145)
at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unk nown
Source) at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanSt artElement(Unknown
Source) at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$Fragme ntContentDispatcher.dispatch(Unknown
Source) at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDo cument(Unknown
Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at
org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at
org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unk nown Source)
at javax.xml.parsers.SAXParser.parse(SAXParser.java:375) at
org.eclipse.birt.report.model.parser.ModuleReader.readModule (ModuleReader.java:90)
at
org.eclipse.birt.report.model.parser.DesignReader.read(Desig nReader.java:90)
at
org.eclipse.birt.report.model.core.DesignSession.openDesign( DesignSession.java:278)
at
org.eclipse.birt.report.model.api.SessionHandle.openDesign(S essionHandle.java:291)
at
org.eclipse.birt.report.engine.parser.ReportParser.getDesign Handle(ReportParser.java:160)
at
org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.o penReportDesign(ReportEngineHelper.java:243)
at
org.eclipse.birt.report.engine.api.impl.ReportEngine.openRep ortDesign(ReportEngine.java:458)
at
org.eclipse.birt.report.service.ReportEngineService.openRepo rtDesign(Unknown
Source) at
org.eclipse.birt.report.context.ViewerAttributeBean.getDesig nHandle(Unknown
Source) at
org.eclipse.birt.report.context.ViewerAttributeBean.__initPa rameters(Unknown
Source) at
org.eclipse.birt.report.context.ViewerAttributeBean.__init(U nknown Source)
at org.eclipse.birt.report.context.BaseAttributeBean.init(Unkno wn Source)
at org.eclipse.birt.report.context.ViewerAttributeBean.(Unknown Source) at
org.eclipse.birt.report.context.BirtContext.__init(Unknown Source) at
org.eclipse.birt.report.context.BaseContext.(Unknown Source) at
org.eclipse.birt.report.context.BirtContext.(Unknown Source) at
org.eclipse.birt.report.servlet.ViewerServlet.__getContext(U nknown Source)
at
org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.doGet(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:96)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:175)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:74)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11Connection Handler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
JBoss DS
<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/jbossdb</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password></password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter </exception-sorter-class-name>
<valid-connection-checker-class-name> org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionC hecker </valid-connection-checker-class-name>
<new-connection-sql>select (1*1)</new-connection-sql>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml
(optional) -->
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
DS definition in report
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="28">
<property
name="odaDriverClass">com.mysql.jdbc.Driver</property>
<property
name="odaURL">jdbc:mysql://localhost:3306/jbossdb</property>
<property name="odaUser">root</property>
<property name="odaJndiName">java:MySqlDS</property>
</oda-data-source>
</data-sources>
|
|
|
| Re: Stuck on JBoss datasource [message #240525 is a reply to message #240441] |
Thu, 31 May 2007 01:31  |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Can you first try to make the connection without using the pool?
Also try the jndi name
java:comp/env/MySqlDS
Jason
Jan Behrens wrote:
> Hi everyone,
>
> I am quite new to BIRT and am facing some probs getting up to speed. I
> would like to integrate the BIRT engine to generate / view reports in a
> EJB3 application. I followed the instructions (using the Runtime Release
> Build 2.1.2) given at
> http://www.eclipse.org/birt/phoenix/deploy/viewerSetup.php. I got the
> app deployed allright, allthough I somehow do not get the testreport
> displayed in the frameset (shows using run though). I now would like to
> use a datasource within the testreport, just to slowly get going. This
> is however where I am stuck... I would like to use a JNDI datasource
> configured under JBoss (see below). The DS is allright because our app
> uses it allright. I used the RCP designer to add a DS to it (see below)
> and redeployed the report / complete app. Calling the report only gives
> me the stacktrace below. I am obviously missing something but am stuck
> because I can not find any further instructions. Any help / pointer to a
> (working) tutorial would be great (I allready tried to eclipse magazine
> 01-2007 article...)
>
> TIA & cheers, Jan
>
> java.lang.NullPointerException at
> org.eclipse.birt.report.model.elements.OdaDataSource.setIntr insicProperty(OdaDataSource.java:201)
> at
> org.eclipse.birt.report.model.core.DesignElement.setProperty (DesignElement.java:1192)
> at
> org.eclipse.birt.report.model.core.DesignElement.setProperty (DesignElement.java:1162)
> at
> org.eclipse.birt.report.model.parser.DesignParseState.setPro perty(DesignParseState.java:99)
> at
> org.eclipse.birt.report.model.parser.OdaDataSourceState.pars eODADataSourceExtensionID(OdaDataSourceState.java:167)
> at
> org.eclipse.birt.report.model.parser.OdaDataSourceState.pars eAttrs(OdaDataSourceState.java:82)
> at
> org.eclipse.birt.report.model.parser.ModuleParserHandler.sta rtElement(ModuleParserHandler.java:145)
> at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unk nown
> Source) at
> org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanSt artElement(Unknown
> Source) at
> org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$Fragme ntContentDispatcher.dispatch(Unknown
> Source) at
> org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDo cument(Unknown
> Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
> Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
> Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at
> org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at
> org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unk nown Source)
> at javax.xml.parsers.SAXParser.parse(SAXParser.java:375) at
> org.eclipse.birt.report.model.parser.ModuleReader.readModule (ModuleReader.java:90)
> at
> org.eclipse.birt.report.model.parser.DesignReader.read(Desig nReader.java:90)
> at
> org.eclipse.birt.report.model.core.DesignSession.openDesign( DesignSession.java:278)
> at
> org.eclipse.birt.report.model.api.SessionHandle.openDesign(S essionHandle.java:291)
> at
> org.eclipse.birt.report.engine.parser.ReportParser.getDesign Handle(ReportParser.java:160)
> at
> org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.o penReportDesign(ReportEngineHelper.java:243)
> at
> org.eclipse.birt.report.engine.api.impl.ReportEngine.openRep ortDesign(ReportEngine.java:458)
> at
> org.eclipse.birt.report.service.ReportEngineService.openRepo rtDesign(Unknown
> Source) at
> org.eclipse.birt.report.context.ViewerAttributeBean.getDesig nHandle(Unknown
> Source) at
> org.eclipse.birt.report.context.ViewerAttributeBean.__initPa rameters(Unknown
> Source) at
> org.eclipse.birt.report.context.ViewerAttributeBean.__init(U nknown
> Source) at
> org.eclipse.birt.report.context.BaseAttributeBean.init(Unkno wn Source)
> at org.eclipse.birt.report.context.ViewerAttributeBean.(Unknown Source)
> at org.eclipse.birt.report.context.BirtContext.__init(Unknown Source) at
> org.eclipse.birt.report.context.BaseContext.(Unknown Source) at
> org.eclipse.birt.report.context.BirtContext.(Unknown Source) at
> org.eclipse.birt.report.servlet.ViewerServlet.__getContext(U nknown
> Source) at
> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.doGet(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
> at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:96)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:175)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:74)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:869)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11Connection Handler.processConnection(Http11BaseProtocol.java:664)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:595)
>
>
>
>
> JBoss DS
> <datasources>
> <local-tx-datasource>
> <jndi-name>MySqlDS</jndi-name>
> <connection-url>jdbc:mysql://localhost:3306/jbossdb</connection-url>
> <driver-class>com.mysql.jdbc.Driver</driver-class>
> <user-name>root</user-name>
> <password></password>
>
> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter </exception-sorter-class-name>
>
>
> <valid-connection-checker-class-name> org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionC hecker </valid-connection-checker-class-name>
>
> <new-connection-sql>select (1*1)</new-connection-sql>
> <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml
> (optional) -->
> <metadata>
> <type-mapping>mySQL</type-mapping>
> </metadata>
> </local-tx-datasource>
> </datasources>
>
>
> DS definition in report
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> id="28">
> <property name="odaDriverClass">com.mysql.jdbc.Driver</property>
> <property
> name="odaURL">jdbc:mysql://localhost:3306/jbossdb</property>
> <property name="odaUser">root</property>
> <property name="odaJndiName">java:MySqlDS</property>
> </oda-data-source>
> </data-sources>
>
|
|
|
| Re: Stuck on JBoss datasource [message #240535 is a reply to message #240525] |
Thu, 31 May 2007 06:52 |
| Eclipse User |
|
|
|
Originally posted by: behrens.offis.de
Hi Jason
Thanks for the fast reply and your suggestions!
> Can you first try to make the connection without using the pool?
All I need to do for that would be to drop the driver under
{APP_DIR}\WEB-INF\platform\plugins\org.eclipse.birt.report.d ata.oda.jdbc_2.1.1.v20070205-1728\drivers
and ensure that the connection settings in my report are valid, correct?
That does not work for me either :(
What are the plugin.properties under
.../org.eclipse.birt.report.data.oda.jdbc_*/ used for? I have tried
setting them as well, no change.
> Also try the jndi name
> java:comp/env/MySqlDS
Thanks for the hint, have tried most possible (and some impossible)
combinations to no avail :(
I'be grateful for any other suggestions?
|
|
|
| Re: Stuck on JBoss datasource [message #240540 is a reply to message #240535] |
Thu, 31 May 2007 07:40 |
| Eclipse User |
|
|
|
Originally posted by: behrens.offis.de
Update, I undeployed all BIRT 2.1.2 apps from my JBoss (4.0.4) and
deployed a copy of the latest 2.1.1, then followed the instructions. Have
added a DS to the testreport using a direct connection and... have a
working report!
Will try to set up my JNDI DS now and see if it works now. Funny thing is
though that the sample apps welcome page still shows both version numbers
as 2.1.2. Is this correct???
Thanks, Jan
|
|
|
| Re: Stuck on JBoss datasource [message #240637 is a reply to message #240540] |
Thu, 31 May 2007 14:02 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Jan,
I am not certain why 2.1.2 is showing up, but you may get a problem if
the db jar file is located in more than one place. If you set up
connection pooling in JBoss you should not need the driver in the JDBC
plugin/drivers directory.
Jason
Jan Behrens wrote:
> Update, I undeployed all BIRT 2.1.2 apps from my JBoss (4.0.4) and
> deployed a copy of the latest 2.1.1, then followed the instructions.
> Have added a DS to the testreport using a direct connection and... have
> a working report! Will try to set up my JNDI DS now and see if it works
> now. Funny thing is though that the sample apps welcome page still shows
> both version numbers as 2.1.2. Is this correct???
>
> Thanks, Jan
>
|
|
|
| Re: Stuck on JBoss datasource [message #241159 is a reply to message #240637] |
Tue, 05 June 2007 11:36 |
| Eclipse User |
|
|
|
Originally posted by: behrens.offis.de
Hi Jason
Thanks for your answer. The 2.1.2 showing was aparently due to a caching
problem within JBoss. I got my first test report working from within my
app allright by using the engine servlet. I am not sure however which
connection type is used (any idea how I could find?). Will be looking into
this once I have some report design issues fixed.
Thanks again
Jan
|
|
|
| Re: Stuck on JBoss datasource [message #241198 is a reply to message #241159] |
Tue, 05 June 2007 14:42 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Jan,
If you set logging to FINEST you should see pool messages in the log.
Jason
Jan Behrens wrote:
> Hi Jason
>
> Thanks for your answer. The 2.1.2 showing was aparently due to a caching
> problem within JBoss. I got my first test report working from within my
> app allright by using the engine servlet. I am not sure however which
> connection type is used (any idea how I could find?). Will be looking
> into this once I have some report design issues fixed.
>
> Thanks again
>
> Jan
>
|
|
|
| Re: Stuck on JBoss datasource [message #243336 is a reply to message #241198] |
Tue, 19 June 2007 15:50 |
| Eclipse User |
|
|
|
Originally posted by: behrens.offis.de
Jason Weathersby wrote:
> If you set logging to FINEST you should see pool messages in the log.
Hi Jason
Thanks for the input. I think I got it working now but have a further
question regarding the behaviour I am seeing in the logs. I set the report
connection parameters URL and User to some garbage to ensure that a
connection could only be established via JNDI - and my reports show up
allright (see also log below). What troubles me is the fact that I see
MySQL (access denied) errors in the logs as well. They are logged at INFO
level in the BIRT logs but show up as full errors in the JBoss logs. From
what I see there, they seem to occur at the JNDI level - but _only_ on
BIRT accesses to the resource. Do you have an explanation for this
behaviour?
TIA, Jan
19.06.2007 17:13:55
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager getConnection
FEIN: Request JDBC Connection: driverClass=com.mysql.jdbc.Driver;
url=jdbc:mysql://none; jndi name url=java:MySqlDS
19.06.2007 17:13:55
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadDriverExtensions
INFO: Found JDBC driverinfo extension:
driverClass=org.apache.derby.jdbc.EmbeddedDriver, connectionFactory=null
19.06.2007 17:13:55
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadDriverExtensions
INFO: Found JDBC driverinfo extension:
driverClass=org.eclipse.birt.report.data.oda.sampledb.Driver ,
connectionFactory=org.eclipse.birt.report.data.oda.sampledb. SampleDBJDBCConnectionFactory
19.06.2007 17:13:55
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager getJndiDSConnection
FEINER: Calling getJndiDSConnection: JNDI name url=java:MySqlDS
19.06.2007 17:13:55 JndiDataSource getConnection
FEINER: ENTRY java:MySqlDS
19.06.2007 17:13:55 org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
getDriverJndiPropertyFile
KONFIG: getDriverJndiPropertyFile()
D:\programming\server\JBoss.4.0.4\server\default\tmp\deploy\ tmp11182App-exp.war\WEB-INF\platform\plugins\org.eclipse.bir t.report.data.oda.jdbc_2.1.1.v20070205-1728\drivers\jndi.pro perties
canReadFile = false
19.06.2007 17:13:55 org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
getDataSourceConnection
FEINER: getDataSourceConnection: using getConnection( username, password )
from data source pool.
19.06.2007 17:13:55 org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
getDataSourceConnection
INFO: org.jboss.util.NestedSQLException: Could not create connection; -
nested throwable: (com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:
Access denied for user ''@'%' to database 'jbossdb'); - nested throwable:
(org.jboss.resource.JBossResourceException: Could not create connection; -
nested throwable: (com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:
Access denied for user ''@'%' to database 'jbossdb'))
19.06.2007 17:13:55 org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
getDataSourceConnection
FEINER: getDataSourceConnection: using getConnection() from data source
pool.
19.06.2007 17:13:55 JndiDataSource getConnection
FEINER: RETURN org.jboss.resource.adapter.jdbc.WrappedConnection@1a49bfa
19.06.2007 17:13:55 org.eclipse.birt.data.engine.odaconsumer.Connection
Connection
FEINER: ENTRY
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection @14a0b92
org.eclipse.birt.report.data.oda.jdbc
19.06.2007 17:13:55 org.eclipse.birt.data.engine.odaconsumer.Connection
Connection
|
|
|
| Re: Stuck on JBoss datasource [message #243558 is a reply to message #243336] |
Wed, 20 June 2007 14:17 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Jan,
You may want to try 2.1.2 and see if the error exist.
Jason
Jan wrote:
> Jason Weathersby wrote:
>
>> If you set logging to FINEST you should see pool messages in the log.
>
>
> Hi Jason
>
> Thanks for the input. I think I got it working now but have a further
> question regarding the behaviour I am seeing in the logs. I set the
> report connection parameters URL and User to some garbage to ensure that
> a connection could only be established via JNDI - and my reports show up
> allright (see also log below). What troubles me is the fact that I see
> MySQL (access denied) errors in the logs as well. They are logged at
> INFO level in the BIRT logs but show up as full errors in the JBoss
> logs. From what I see there, they seem to occur at the JNDI level - but
> _only_ on BIRT accesses to the resource. Do you have an explanation for
> this behaviour?
> TIA, Jan
>
>
>
> 19.06.2007 17:13:55
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager getConnection
> FEIN: Request JDBC Connection: driverClass=com.mysql.jdbc.Driver;
> url=jdbc:mysql://none; jndi name url=java:MySqlDS
> 19.06.2007 17:13:55
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
> loadDriverExtensions
> INFO: Found JDBC driverinfo extension:
> driverClass=org.apache.derby.jdbc.EmbeddedDriver, connectionFactory=null
> 19.06.2007 17:13:55
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
> loadDriverExtensions
> INFO: Found JDBC driverinfo extension:
> driverClass=org.eclipse.birt.report.data.oda.sampledb.Driver ,
> connectionFactory=org.eclipse.birt.report.data.oda.sampledb. SampleDBJDBCConnectionFactory
>
> 19.06.2007 17:13:55
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager getJndiDSConnection
> FEINER: Calling getJndiDSConnection: JNDI name url=java:MySqlDS
> 19.06.2007 17:13:55 JndiDataSource getConnection
> FEINER: ENTRY java:MySqlDS
> 19.06.2007 17:13:55 org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
> getDriverJndiPropertyFile
> KONFIG: getDriverJndiPropertyFile()
> D:\programming\server\JBoss.4.0.4\server\default\tmp\deploy\ tmp11182App-exp.war\WEB-INF\platform\plugins\org.eclipse.bir t.report.data.oda.jdbc_2.1.1.v20070205-1728\drivers\jndi.pro perties
> canReadFile = false
> 19.06.2007 17:13:55 org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
> getDataSourceConnection
> FEINER: getDataSourceConnection: using getConnection( username, password
> ) from data source pool.
> 19.06.2007 17:13:55 org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
> getDataSourceConnection
> INFO: org.jboss.util.NestedSQLException: Could not create connection; -
> nested throwable: (com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:
> Access denied for user ''@'%' to database 'jbossdb'); - nested
> throwable: (org.jboss.resource.JBossResourceException: Could not create
> connection; - nested throwable:
> (com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Access denied for
> user ''@'%' to database 'jbossdb'))
> 19.06.2007 17:13:55 org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
> getDataSourceConnection
> FEINER: getDataSourceConnection: using getConnection() from data source
> pool.
> 19.06.2007 17:13:55 JndiDataSource getConnection
> FEINER: RETURN org.jboss.resource.adapter.jdbc.WrappedConnection@1a49bfa
> 19.06.2007 17:13:55 org.eclipse.birt.data.engine.odaconsumer.Connection
> Connection
> FEINER: ENTRY
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection @14a0b92
> org.eclipse.birt.report.data.oda.jdbc
> 19.06.2007 17:13:55 org.eclipse.birt.data.engine.odaconsumer.Connection
> Connection
>
|
|
|
| Re: Stuck on JBoss datasource [message #243803 is a reply to message #243558] |
Thu, 21 June 2007 07:41 |
| Eclipse User |
|
|
|
Originally posted by: behrens.offis.de
Jason
Thanks for the update. Will give it a try and report my observations. Hope
it will do the trick...
Jan
Jason Weathersby wrote:
> Jan,
> You may want to try 2.1.2 and see if the error exist.
> Jason
> Jan wrote:
>> Jason Weathersby wrote:
>>
>>> If you set logging to FINEST you should see pool messages in the log.
>>
>>
>> Hi Jason
>>
>> Thanks for the input. I think I got it working now but have a further
>> question regarding the behaviour I am seeing in the logs. I set the
>> report connection parameters URL and User to some garbage to ensure that
>> a connection could only be established via JNDI - and my reports show up
>> allright (see also log below). What troubles me is the fact that I see
>> MySQL (access denied) errors in the logs as well. They are logged at
>> INFO level in the BIRT logs but show up as full errors in the JBoss
>> logs. From what I see there, they seem to occur at the JNDI level - but
>> _only_ on BIRT accesses to the resource. Do you have an explanation for
>> this behaviour?
>> TIA, Jan
>>
>>
>>
>> 19.06.2007 17:13:55
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager getConnection
>> FEIN: Request JDBC Connection: driverClass=com.mysql.jdbc.Driver;
>> url=jdbc:mysql://none; jndi name url=java:MySqlDS
>> 19.06.2007 17:13:55
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
>> loadDriverExtensions
>> INFO: Found JDBC driverinfo extension:
>> driverClass=org.apache.derby.jdbc.EmbeddedDriver, connectionFactory=null
>> 19.06.2007 17:13:55
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
>> loadDriverExtensions
>> INFO: Found JDBC driverinfo extension:
>> driverClass=org.eclipse.birt.report.data.oda.sampledb.Driver ,
>>
connectionFactory=org.eclipse.birt.report.data.oda.sampledb. SampleDBJDBCConnectionFactory
>>
>> 19.06.2007 17:13:55
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager getJndiDSConnection
>> FEINER: Calling getJndiDSConnection: JNDI name url=java:MySqlDS
>> 19.06.2007 17:13:55 JndiDataSource getConnection
>> FEINER: ENTRY java:MySqlDS
>> 19.06.2007 17:13:55 org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
>> getDriverJndiPropertyFile
>> KONFIG: getDriverJndiPropertyFile()
>>
D:programmingserverJBoss.4.0.4serverdefaulttmpdeploytmp11182 App-exp.warWEB-INFplatformpluginsorg.eclipse.birt.report.dat a.oda.jdbc_2.1.1.v20070205-1728driversjndi.properties
>> canReadFile = false
>> 19.06.2007 17:13:55 org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
>> getDataSourceConnection
>> FEINER: getDataSourceConnection: using getConnection( username, password
>> ) from data source pool.
>> 19.06.2007 17:13:55 org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
>> getDataSourceConnection
>> INFO: org.jboss.util.NestedSQLException: Could not create connection; -
>> nested throwable: (com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:
>> Access denied for user ''@'%' to database 'jbossdb'); - nested
>> throwable: (org.jboss.resource.JBossResourceException: Could not create
>> connection; - nested throwable:
>> (com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Access denied for
>> user ''@'%' to database 'jbossdb'))
>> 19.06.2007 17:13:55 org.eclipse.birt.report.data.oda.jdbc.JndiDataSource
>> getDataSourceConnection
>> FEINER: getDataSourceConnection: using getConnection() from data source
>> pool.
>> 19.06.2007 17:13:55 JndiDataSource getConnection
>> FEINER: RETURN org.jboss.resource.adapter.jdbc.WrappedConnection@1a49bfa
>> 19.06.2007 17:13:55 org.eclipse.birt.data.engine.odaconsumer.Connection
>> Connection
>> FEINER: ENTRY
>>
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection @14a0b92
>> org.eclipse.birt.report.data.oda.jdbc
>> 19.06.2007 17:13:55 org.eclipse.birt.data.engine.odaconsumer.Connection
>> Connection
>>
|
|
|
Powered by
FUDForum. Page generated in 0.04754 seconds
] 
Search
Help
Register
Login
Home
