I successfully got a couple entity beans up and running w/ references, and now I'd like to move the datasource over to Postgres. It appears that I've got the Minerva pool configured correctly, as the connection seems to come up ok. I created a jaws.xml, and added that to my ejb-jar. I had to define some special field mappings in the jaws.xml, since I think a couple of my fields are illegal names in postgres (like 'user' for a table name or 'password' for a field name)
When I try to deploy, I get some errors on the server console. I'll post the errors and the jaws.xml below. I removed the jaws.xml file, and it deployed once again to Hypersonic with no problems.
Thanks for your input....
-Jason
--------------------------------------------------------------------------------
Console Output:
--------------------------------------------------------------------------------
[Auto deploy] Auto deploy of file:/opt/jboss/deploy/assetmgr.jar
[Container factory] Deploying:file:/opt/jboss/deploy/assetmgr.jar
[Container factory] Loading ejb-jar.xml : jar:file:/opt/jboss/tmp/deploy/tmpejbjar17501.jar!/META-INF/ejb-jar.xml
[Container factory] Loading standardjboss.xml : jar:file:/opt/jboss/lib/ext/jboss.jar!/org/jboss/metadata/standardjboss.xml
[Verifier] Verifying file:/opt/jboss/tmp/deploy/tmpejbjar17502.jar
[Verifier] Site: Verified.
[Verifier] User: Verified.
[Container factory] Deploying Site
[Container factory] Container Invoker Optimize='false'
[Container factory] Deploying User
[Container factory] Container Invoker Optimize='false'
[JAWS] Initializing JAWS plugin for Site
[JAWS] Loading standardjaws.xml : jar:file:/opt/jboss/lib/ext/jboss.jar!/org/jboss/ejb/plugins/jaws/metadata/standardjaws.xml
[JAWS] jar:file:/opt/jboss/tmp/deploy/tmpejbjar17501.jar!/META-INF/jaws.xml found. Overriding defaults
[Container factory] java.lang.NullPointerException
[Container factory] at org.jboss.ejb.plugins.jaws.metadata.JawsEntityMetaData.importXml(JawsEntityMetaData.java:220)
[Container factory] at org.jboss.ejb.plugins.jaws.metadata.JawsApplicationMetaData.importXml(JawsApplicationMetaData.java:191)
[Container factory] at org.jboss.ejb.plugins.jaws.metadata.JawsXmlFileLoader.load(JawsXmlFileLoader.java:69)
[Container factory] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommandFactory.<init>(JDBCCommandFactory.java:78)
[Container factory] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.init(JAWSPersistenceManager.java:78)
[Container factory] at org.jboss.ejb.plugins.CMPPersistenceManager.init(CMPPersistenceManager.java:101)
[Container factory] at org.jboss.ejb.EntityContainer.init(EntityContainer.java:191)
[Container factory] at org.jboss.ejb.Application.init(Application.java:158)
[Container factory] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:635)
[Container factory] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:227)
[Container factory] at java.lang.reflect.Method.invoke(Native Method)
[Container factory] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Container factory] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Container factory] at org.jboss.ejb.AutoDeployer.deploy(AutoDeployer.java:286)
[Container factory] at org.jboss.ejb.AutoDeployer.run(AutoDeployer.java:222)
[Container factory] at java.lang.Thread.run(Thread.java:484)
[Container factory] java.lang.NullPointerException
[Container factory] at org.jboss.ejb.plugins.jaws.metadata.JawsEntityMetaData.importXml(JawsEntityMetaData.java:220)
[Container factory] at org.jboss.ejb.plugins.jaws.metadata.JawsApplicationMetaData.importXml(JawsApplicationMetaData.java:191)
[Container factory] at org.jboss.ejb.plugins.jaws.metadata.JawsXmlFileLoader.load(JawsXmlFileLoader.java:69)
[Container factory] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommandFactory.<init>(JDBCCommandFactory.java:78)
[Container factory] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.init(JAWSPersistenceManager.java:78)
[Container factory] at org.jboss.ejb.plugins.CMPPersistenceManager.init(CMPPersistenceManager.java:101)
[Container factory] at org.jboss.ejb.EntityContainer.init(EntityContainer.java:191)
[Container factory] at org.jboss.ejb.Application.init(Application.java:158)
[Container factory] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:635)
[Container factory] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:227)
[Container factory] at java.lang.reflect.Method.invoke(Native Method)
[Container factory] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Container factory] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Container factory] at org.jboss.ejb.AutoDeployer.deploy(AutoDeployer.java:286)
[Container factory] at org.jboss.ejb.AutoDeployer.run(AutoDeployer.java:222)
[Container factory] at java.lang.Thread.run(Thread.java:484)
[Auto deploy] Deployment failed:file:/opt/jboss/deploy/assetmgr.jar
[Auto deploy] org.jboss.ejb.DeploymentException: Could not deploy file:/opt/jboss/tmp/deploy/tmpejbjar17502.jar, Cause:java.lang.NullPointerE
xception
[Auto deploy] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:665)
[Auto deploy] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:227)
[Auto deploy] at java.lang.reflect.Method.invoke(Native Method)
[Auto deploy] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Auto deploy] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Auto deploy] at org.jboss.ejb.AutoDeployer.deploy(AutoDeployer.java:286)
[Auto deploy] at org.jboss.ejb.AutoDeployer.run(AutoDeployer.java:222)
[Auto deploy] at java.lang.Thread.run(Thread.java:484)
--------------------------------------------------------------------------------
jaws.xml:
(yes, I did check to make sure the datasource name was correct)
--------------------------------------------------------------------------------
<jaws>
<datasource>PostgresPool</datasource>
<type-mapping>PostgreSQL</type-mapping>
<type-mappings>
<type-mapping>
<name>PostgreSQL</name>
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
<sql-type>BIT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>FLOAT8</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
<sql-type>CHAR</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
<jdbc-type>BLOB</jdbc-type>
<sql-type>BLOB</sql-type>
</mapping>
<mapping>
<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
<jdbc-type>TINYINT</jdbc-type>
<sql-type>TINYINT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Float</java-type>
<jdbc-type>FLOAT</jdbc-type>
<sql-type>FLOAT4</sql-type>
</mapping>
<mapping>
<java-type>java.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>TEXT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
<sql-type>BIGINT</sql-type>
</mapping>
</type-mapping>
</type-mappings>
<enterprise-beans>
<entity>
<ejb-name>Site</ejb-name>
<table-name>site</table-name>
<cmp-field>
<field-name>uniqueId</field-name>
<column-name>uniqueid</column-name>
</cmp-field>
<cmp-field>
<field-name>dateAdded</field-name>
<column-name>dateadded</column-name>
</cmp-field>
<cmp-field>
<field-name>name</field-name>
<column-name>name</column-name>
</cmp-field>
</entity>
<entity>
<ejb-name>User</ejb-name>
<table-name>userentity</table-name>
<cmp-field>
<field-name>uniqueId</field-name>
<column-name>uniqueid</column-name>
</cmp-field>
<cmp-field>
<field-name>dateAdded</field-name>
<column-name>dateadded</column-name>
</cmp-field>
<cmp-field>
<field-name>logonId</field-name>
<column-name>logonid</column-name>
</cmp-field>
<cmp-field>
<field-name>firstName</field-name>
<column-name>firstname</column-name>
</cmp-field>
<cmp-field>
<field-name>midInitial</field-name>
<column-name>midinitial</column-name>
</cmp-field>
<cmp-field>
<field-name>lastName</field-name>
<column-name>lastname</column-name>
</cmp-field>
<cmp-field>
<field-name>dept</field-name>
<column-name>dept</column-name>
</cmp-field>
<cmp-field>
<field-name>phone</field-name>
<column-name>phone</column-name>
</cmp-field>
<cmp-field>
<field-name>dropCode</field-name>
<column-name>dropcode</column-name>
</cmp-field>
<cmp-field>
<field-name>siteId</field-name>
<column-name>siteid</column-name>
</cmp-field>
<cmp-field>
<field-name>password</field-name>
<column-name>passwd</column-name>
</cmp-field>
</entity>
</enterprise-beans>
</jaws>
- Re: [jBoss-User] Jaws question VASQUEZ_JASON
- Re: [jBoss-User] Jaws question Sebastien Alborini
