Hi
In BETA-PROD I'm trying to use XADataSourceLoader to configure a connection...
But table not created on deploy
>> from jboss.jcml
<mbean name="DefaultDomain:service=XADataSource,name=PostgreSQL">
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:postgresql://192.168.10.18:3312/upsa</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="Password">test</attribute>
<attribute name="ShrinkPercent">0.33</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">false</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="JDBCUser">postgress</attribute>
<attribute name="MinSize">0</attribute>
<attribute name="ShrinkMinIdleTime">600000</attribute>
<attribute name="ShrinkingEnabled">false</attribute>
</mbean>
>> from jboss.conf
<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar,postgresql.jar"
CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="PostgreSQL">
<ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
>>>ejb-jar.xml
<?xml version="1.0" encoding="Cp1251"?>
<ejb-jar>
<enterprise-beans>
<entity>
<ejb-name>AdProfessionBean</ejb-name>
<home>com.ulybin.JobBoerse.database.adprofession.AdProfessionHome</home>
<remote>com.ulybin.JobBoerse.database.adprofession.AdProfession</remote>
<ejb-class>com.ulybin.JobBoerse.database.adprofession.AdProfessionBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>com.ulybin.JobBoerse.database.adprofession.AdProfessionPK</prim-key-class>
<reentrant>False</reentrant>
<cmp-field>
<field-name>ad_id</field-name>
</cmp-field>
<cmp-field>
<field-name>category_id</field-name>
</cmp-field>
<cmp-field>
<field-name>spec_id</field-name>
</cmp-field>
</entity>
</enterprise-beans>
<assembly-descriptor>
<container-transaction>
<method>
<ejb-name>AdProfessionBean</ejb-name>
<method-name>*</method-name>
</method>
<trans-attribute>NotSupported</trans-attribute>
</container-transaction>
</assembly-descriptor>
</ejb-jar>
>>jaws.xml
<?xml version="1.0" encoding="Cp1251"?>
<jaws>
<datasource>PostgreSQL</datasource>
<type-mappings>
<type-mapping>
<name>PostgreSQL</name>
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
<sql-type>CHAR</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
<sql-type>INT8</sql-type>
</mapping>
<mapping>
<java-type>java.sql.Date</java-type>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>BOOL</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.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(256)</sql-type>
</mapping>
<mapping>
<java-type>java.sql.TimeStamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>INTERVAL</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.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INT4</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.Byte</java-type>
<jdbc-type>TINYINT</jdbc-type>
<sql-type>TINYINT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INT2</sql-type>
</mapping>
</type-mapping>
</type-mappings>
<type-mapping>PostgreSQL</type-mapping>
<enterprise-beans>
<entity>
<ejb-name>AdProfessionBean</ejb-name>
<table-name>AdProfession</table-name>
<create-table>true</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<cmp-field>
<field-name>ad_id</field-name>
<column-name>ad_id</column-name>
<sql-type>INT8</sql-type>
<jdbc-type>BIGINT</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>category_id</field-name>
<column-name>category_id</column-name>
<sql-type>INT8</sql-type>
<jdbc-type>BIGINT</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>spec_id</field-name>
<column-name>spec_id</column-name>
<sql-type>INT8</sql-type>
<jdbc-type>BIGINT</jdbc-type>
</cmp-field>
<finder>
<name>findByADId</name>
<query>ad_id = {0}</query>
<order></order>
</finder>
</entity>
</enterprise-beans>
</jaws>
>>jboss log
...
[XADataSource] Starting
[XADataSource] XA Connection pool PostgreSQL bound to PostgreSQL
[XADataSource] Started
...
[Auto deploy] Auto deploy of file:/D:/temp/CVS/jboss/dist/deploy/adprofession.jar
[Container factory] Deploying:file:/D:/temp/CVS/jboss/dist/deploy/adprofession.jar
[Container factory] Loading ejb-jar.xml :
jar:file:/D:/temp/CVS/jboss/dist/tmp/deploy/tmpejbjar4390.
jar!/META-INF/ejb-jar.xml
[Container factory] Loading standardjboss.xml :
jar:file:/D:/temp/CVS/jboss/dist/lib/ext/jboss.jar!/
org/jboss/metadata/standardjboss.xml
[Verifier] Verifying file:/D:/temp/CVS/jboss/dist/tmp/deploy/tmpejbjar4390.jar
[Verifier] AdProfessionBean: Verified.
[Container factory] Deploying AdProfessionBean
[Container factory] Container Invoker Optimize='false'
[JAWS] Initializing JAWS plugin for AdProfessionBean
[JAWS] Loading standardjaws.xml :
jar:file:/D:/temp/CVS/jboss/dist/lib/ext/jboss.jar!/org/jboss/ejb/
plugins/jaws/metadata/standardjaws.xml
[JAWS]
jar:file:/D:/temp/CVS/jboss/dist/tmp/deploy/tmpejbjar4390.jar!/META-INF/jaws.xml
found. Overr
iding defaults
[JAWS] Table AdProfession created
[Container factory] Bound AdProfessionBean to AdProfessionBean
[Container factory] Deployed application:
file:/D:/temp/CVS/jboss/dist/deploy/adprofession.jar
....
>>>>postgreSQL log
...
ERROR: adprofession: Table does not exist.
NOTICE: (transaction aborted): all queries ignored until end of transaction block
..
Any ideas? (All works fine on jboss pre4)
Thanx a lot,
Nahibin Serhiy
Software Developer
ULYBIN GmbH
http://www.ulybin.com
Phone: +38 0322 797 403
Phone/Fax: +38 0322 728 835
E-mail: [EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Aaron Mulder
Sent: Friday, September 29, 2000 10:32 PM
To: jBoss
Subject: Re: [jBoss-User] PostgreSQL & Minerva
In the BETA-PROD-1 build, you could use DataSourceImpl instead of
XADataSourceLoader to configure a connection. That is no longer available
(as of this morning). Both put an implementation of DataSource in JNDI,
so the client code and Deployment Descriptors are the same, it was just
the jboss.conf and jboss.jcml entries that were different.
There is no other approved way to get a connection in J2EE.
We'll be adding specific data source examples to the manual for
Oracle, Postgres, DB/2, and so on (speak up if you use another DB, though
it has to be one I can get a copy of for testing!).
Aaron
On Fri, 29 Sep 2000, Christian Bourque wrote:
> Does anyone knows how to setup Minerva with PostgreSQL ?
>
> In a cmp bean is there a way to request a database connection from a
> DataSource (jboss.conf) without using Minerva (XADataSource...) ???
>
> Thanks
>
> Christian
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
