-
1. Re: Error in deploying a data source
mayerw01 Jan 5, 2016 4:57 AM (in response to alaa.alarfaj)You should find some more messages in the server.log which give some more details to the root cause.
What kind of data source are you deploying? Did you make sure that the JDBC driver is installed?
-
2. Re: Error in deploying a data source
alaa.alarfaj Jan 5, 2016 7:04 AM (in response to mayerw01)First, In the server.log:
INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "crc-ds.xml"
ERROR [org.jboss.msc.service.fail] (MSC service thread 1-7) MSC00001: Failed to start service jboss.deployment.unit."crc-ds.xml".PARSE: org.jboss.msc.service.StartException in service jboss.deployment.unit."crc-ds.xml".PARSE: Failed to process phase PARSE of deployment "crc-ds.xml"
at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:119) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [rt.jar:1.6.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [rt.jar:1.6.0_45]
at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_45]
Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: Received non-all-whitespace CHARACTERS or CDATA event in nextTag(). at [row,col {unknown source}]: [95,0]
at org.jboss.as.connector.deployers.processors.DsXmlDeploymentParsingProcessor.deploy(DsXmlDeploymentParsingProcessor.java:85)
at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:113) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]
... 5 more
Caused by: com.ctc.wstx.exc.WstxParsingException: Received non-all-whitespace CHARACTERS or CDATA event in nextTag(). at [row,col {unknown-source}]: [95,0]
at com.ctc.wstx.sr.StreamScanner.constructWfcException(StreamScanner.java:606)
at com.ctc.wstx.sr.StreamScanner.throwParseError(StreamScanner.java:479)
at com.ctc.wstx.sr.StreamScanner.throwParseError(StreamScanner.java:464)
at com.ctc.wstx.sr.BasicStreamReader.nextTag(BasicStreamReader.java:1137)
at org.jboss.jca.common.metadata.ds.DsParser.parseDataSources(DsParser.java:145)
at org.jboss.jca.common.metadata.ds.DsParser.parse(DsParser.java:119)
at org.jboss.jca.common.metadata.ds.DsParser.parse(DsParser.java:82)
at org.jboss.as.connector.deployers.processors.DsXmlDeploymentParsingProcessor.deploy(DsXmlDeploymentParsingProcessor.java:80)
... 6 more
INFO [org.jboss.as.server.deployment] (MSC service thread 1-8) JBAS015877: Stopped deployment crc-ds.xml in 54ms
INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS015870: Deploy of deployment "crc-ds.xml" was rolled back with failure message {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"crc-ds.xml\".PARSE" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"crc-ds.xml\".PARSE: Failed to process phase PARSE of deployment \"crc-ds.xml\""}}
INFO [org.jboss.as.controller] (DeploymentScanner-threads - 2) JBAS014774: Service status report
JBAS014777: Services which failed to start: service jboss.deployment.unit."crc-ds.xml".PARSE: org.jboss.msc.service.StartException in service jboss.deployment.unit."crc-ds.xml".PARSE: Failed to process phase PARSE of deployment "crc-ds.xml"
ERROR [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-2" => {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"crc-ds.xml\".PARSE" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"crc-ds.xml\".PARSE: Failed to process phase PARSE of deployment \"crc-ds.xml\""}}}}
Second, I am trying install i2b2 platform that contain many plug-in cells. Each cell has a data source file. The following is the data source file for the cell that I want to deploy:
<datasource jta="false" jndi-name="java:/CRCBootStrapDS"
pool-name="CRCBootStrapDS" enabled="true" use-ccm="false">
<connection-url>jdbc:sqlserver://localhost:1433;databaseName=i2b2hive</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<driver>sqljdbc4.jar</driver>
<security>
<user-name>i2b2hive</user-name>
<password>demouser</password>
</security>
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"></valid-connection-checker>
<validate-on-match>false</validate-on-match>
</validation>
<statement>
<share-prepared-statements>false</share-prepared-statements>
</statement>
</datasource>
<datasource jta="false" jndi-name="java:/QueryToolDemoDS"
pool-name="QueryToolDemoDS" enabled="true" use-ccm="false">
<connection-url>jdbc:sqlserver://localhost:1433;databaseName=i2b2demodata</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<driver>sqljdbc4.jar</driver>
<security>
<user-name>i2b2demodata</user-name>
<password>demouser</password>
</security>
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"></valid-connection-checker>
<validate-on-match>false</validate-on-match>
</validation>
<statement>
<share-prepared-statements>false</share-prepared-statements>
</statement>
</datasource>
Third, How can I test the JDBC installation?
Thank you
Alaa
-
3. Re: Error in deploying a data source
mayerw01 Jan 5, 2016 7:51 AM (in response to alaa.alarfaj)In your log you should find entries like:
FLYJCA0005: Deploying non-JDBC-compliant driver ...
INFO .... WFLYJCA0018: Started Driver service with driver-name = ...
The driver should either be installed as module or as deployment JDBC Driver / DataSource Setup | HAL Management Console
You may also check via jboss-cli if your driver is successfully installed:
For example enter /subsystem=datasources/jdbc-driver=
then press the tab-key.
-
4. Re: Error in deploying a data source
alaa.alarfaj Jan 5, 2016 8:25 AM (in response to mayerw01)Sorry but, I am new to JBOSS.
Where shall I enter /subsystem=datasources/jdbc-driver=?
Thank you
Alaa
-
5. Re: Error in deploying a data source
mayerw01 Jan 5, 2016 8:51 AM (in response to alaa.alarfaj)For configuring / analyzing the application server JBoss (Wildfly) provides as well an online tool (web console) as a command line tool (jboss-cli).
If you are new to JBoss (WildFly) you should first get a general understanding.
A good starting point might be to read the documentation (Documentation - WildFly 9 - Project Documentation Editor)
Which version are you using?
-
6. Re: Error in deploying a data source
alaa.alarfaj Jan 5, 2016 11:18 AM (in response to mayerw01)I am using JBOSS 7.
-
7. Re: Error in deploying a data source
jaysensharma Jan 5, 2016 12:57 PM (in response to alaa.alarfaj)[Received non-all-whitespace CHARACTERS or CDATA event in nextTag(). at [row,col {unknown-source}]: [95,0]]
The parsing error indicates that your XML is not correct. You need to really check if there is any hidden character in your crc-ds.xml file. Specially the line number "95" is the culprit. (even though the pasted XML snippet is having less than 95 lines, But i am suspecting that there is some special character in your XML file please check carefully)
Your datasource XML(crc-ds.xml) does not have the root element as <datasources></datasources> in the "crc-ds.xml" file.
It does not look right.
Can you try creating a fresh DataSource file as following and see if it works:
<datasources xmlns="http://www.jboss.org/ironjacamar/schema"> <datasource jta="false" jndi-name="java:/CRCBootStrapDS" pool-name="CRCBootStrapDS" enabled="true" use-ccm="false"> <connection-url>jdbc:sqlserver://localhost:1433;databaseName=i2b2hive</connection-url> <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> <driver>sqljdbc4.jar</driver> <security> <user-name>i2b2hive</user-name> <password>demouser</password> </security> <validation> <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"></valid-connection-checker> <validate-on-match>false</validate-on-match> </validation> <statement> <share-prepared-statements>false</share-prepared-statements> </statement> </datasource> <datasource jta="false" jndi-name="java:/QueryToolDemoDS" pool-name="QueryToolDemoDS" enabled="true" use-ccm="false"> <connection-url>jdbc:sqlserver://localhost:1433;databaseName=i2b2demodata</connection-url> <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> <driver>sqljdbc4.jar</driver> <security> <user-name>i2b2demodata</user-name> <password>demouser</password> </security> <validation> <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"></valid-connection-checker> <validate-on-match>false</validate-on-match> </validation> <statement> <share-prepared-statements>false</share-prepared-statements> </statement> </datasource> </datasources>
Also make sure that the "sqljdbc4.jar" is placed inside the "deployments" directory of your JBossAS7
Regards
Jay SenSharma
-
8. Re: Error in deploying a data source
alaa.alarfaj Jan 5, 2016 3:54 PM (in response to jaysensharma)Thank you for replying Jay.
My data source is correct but I did not copy the first line in the file in this post.
sqljdbc4.jar in inside the deployment folder.
Thank you
-
9. Re: Error in deploying a data source
jaysensharma Jan 5, 2016 10:25 PM (in response to alaa.alarfaj)This issue is because of your -ds.xml file has some bad characters that is causing the issue here. That's what JBossAS7 is also reporting
[Received non-all-whitespace CHARACTERS or CDATA event in nextTag(). at [row,col {unknown-source}]: [95,0]]
If you really want this issue to get solved soon, then either paste the complete datasource here Or better attach the file to this thread so that we can have a look at whats special in your XML which is causing the parsing failure.
-
10. Re: Error in deploying a data source
alaa.alarfaj Jan 6, 2016 8:07 AM (in response to jaysensharma)The problem is solved. There was a --> character in the end of the data source file and I did not see it.
The data source is deployed successfully.
Thanks all.
Alaa