11:54 a.m.
I am using the booking example as a reference for my testNG test suite. I am basically
trying to accomplish the same thing only I want to use oracle as my database instead of
the hypersonic db. Any help would be greatly appreciated.
Apparently the microcontainer that the tests are executed in needs some tables created in
the datasource in order to function properly, and I have set the property in the
persistence.xml to allow create/drop ability. However, only 2 of N tables gets created
(I'm guessing the sql to create the tables is not speaking oracle entirely correctly,
it is possibly talking in HSSQL). The 2 tables that were successfully created are simple
tables with varchar2 datatypes as columns, the others tables that are trying to be created
have datatypes that don't match oracles datatypes, so I'm guessing table creation
is not speaking in oracle somehow. So now when I try to launch a unit test, I get the
table or view does not exist error, because the table that the microcontainer needed did
not get auto-created properly (probably due to malformed oracle syntax)
Here is the exception I get....
[testng] C:\devSeam\InternalJavaWebAppTemplate\test-build\ijwatTest.xml
| [testng] ERROR [org.jboss.jms.util.ExceptionUtil] ServerPeer[0] startService
| [testng] java.sql.SQLException: ORA-00942: table or view does not exist
| [testng] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
| [testng] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
| [testng] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
| [testng] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
| [testng] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
| [testng] at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
| [testng] at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
| [testng] at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
| [testng] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
| [testng] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
| [testng] at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
|
To reproduce this error, I did the following bootstrap replacements/modifications and
other ds and config files:
1) replaced a bootstrap file for the microcontainer (generated by seam-gen), namely:
replaced the hsqldb-persisence-service.xml with mine-persistenence-service.xml to point my
datasource instead of DefaultDS.
| <?xml version="1.0" encoding="UTF-8"?>
|
| <!--
| Hypersonic persistence deployment descriptor.
|
| $Id: hsqldb-persistence-service.xml,v 1.1 2007/06/15 05:20:58 gavin Exp $
| -->
|
| <server>
|
| <mbean
code="org.jboss.messaging.core.plugin.JDBCPersistenceManagerService"
| name="jboss.messaging:service=PersistenceManager"
| xmbean-dd="xmdesc/JDBCPersistenceManager-xmbean.xml">
|
<depends>jboss.jca:service=DataSourceBinding,name=InternalJavaWebAppTemplateDatasource</depends>
| <depends
optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
| <attribute
name="DataSource">java:/InternalJavaWebAppTemplateDatasource</attribute>
| <attribute name="CreateTablesOnStartup">true</attribute>
| <attribute name="UsingBatchUpdates">false</attribute>
| <attribute name="MaxParams">500</attribute>
| </mbean>
|
|
| <mbean
code="org.jboss.messaging.core.plugin.DefaultPostOfficeService"
| name="jboss.messaging:service=PostOffice"
| xmbean-dd="xmdesc/DefaultPostOffice-xmbean.xml">
| <depends
optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer</depends>
|
<depends>jboss.jca:service=DataSourceBinding,name=InternalJavaWebAppTemplateDatasource</depends>
| <depends
optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
| <attribute name="PostOfficeName">JMS</attribute>
| <attribute
name="DataSource">java:/InternalJavaWebAppTemplateDatasource</attribute>
| <attribute name="CreateTablesOnStartup">true</attribute>
| </mbean>
|
| <mbean code="org.jboss.jms.server.plugin.JDBCJMSUserManagerService"
| name="jboss.messaging:service=JMSUserManager"
| xmbean-dd="xmdesc/JMSUserManager-xmbean.xml">
|
<depends>jboss.jca:service=DataSourceBinding,name=InternalJavaWebAppTemplateDatasource</depends>
| <depends
optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
| <attribute
name="DataSource">java:/InternalJavaWebAppTemplateDatasource</attribute>
| <attribute name="CreateTablesOnStartup">true</attribute>
| <attribute name="SqlProperties"><![CDATA[
| POPULATE.TABLES.1=INSERT INTO JBM_USER (USER_ID,PASSWD,CLIENTID) VALUES
('dilbert','dogbert','dilbert-id')
| ]]></attribute>
| </mbean>
|
| </server>
|
2) replace and added the hsqldb-ds.xml file with mine-ds.xml to
<?xml version="1.0" encoding="UTF-8"?>
|
| <!DOCTYPE datasources
| PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN"
| "http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd">
|
| <datasources>
|
| <local-tx-datasource>
| <jndi-name>InternalJavaWebAppTemplateDatasource</jndi-name>
|
<connection-url>jdbc:oracle:thin:@<myhost>:1521:DWEBAPPS</connection-url>
| <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
| <user-name>myusername</user-name>
| <password>mypassword</password>
| <!--
| <exception-sorter-class-name>
| org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
| </exception-sorter-class-name>
| <metadata>
| <type-mapping>mySQL</type-mapping>
| </metadata>
| -->
| </local-tx-datasource>
|
| </datasources>
|
|
3) Changed the login-config.xml
<application-policy name="OracleDbRealm">
| <authentication>
| <login-module
code="org.jboss.resource.security.ConfiguredIdentityLoginModule"
| flag="required">
| <module-option
name="userName">myusername</module-option>
| <module-option
name="password">mypassword</module-option>
| <module-option
name="managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=InternalJavaWebAppTemplateDatasource</module-option>
| </login-module>
| </authentication>
| </application-policy>
4) changed the persistence-test.xml to point to my datasource.
5) made sure of this in my mine-persistenence-service.xml : <attribute
name="CreateTablesOnStartup">true</attribute>
6) made sure of this in my persistence-test.xml
<property name="hibernate.hbm2ddl.auto" value="create-drop"/>
And oh, by the way.. my testNG class is as follows... really simple...
package com.cox.ijwat.test;
|
| import org.jboss.seam.contexts.Contexts;
| import org.jboss.seam.mock.SeamTest;
| import org.testng.annotations.Test;
|
| public class IjwatTest extends SeamTest
| {
|
| @Test
| public void testSomeCrud() throws Exception
| {
| new FacesRequest()
| {
|
| @Override
| protected void invokeApplication() throws Exception
| {
| //Contexts.getSessionContext().set("user", new User("Gavin
King", "foobar", "gavin"));
| Contexts.getSessionContext().set("user", null);
| setValue("#{identity.username}", "gavin");
| setValue("#{identity.password}", "foobar");
| invokeAction("#{identity.login}");
| }
|
| }.run();
|
| }
| }
|
Thanks in advance... Kent
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4108173#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...