well, i have tried what you said, but i'm not using ejb3 so i guess it's abit different.
Here is what i did: 1. copied the jdbc drivers of postgresql to server/all/lib and to server/default/lib. 2. copied the postgres-ds.xml file from docs/examples in to server/default/deploy. 3. modified that file so it now reads | <datasources> | <local-tx-datasource> | <jndi-name>PostgresDS</jndi-name> | <use-java-context>true</use-java-context> | <connection-url>jdbc:postgresql://localhost:5432/boostbox</connection-url> | <driver-class>org.postgresql.Driver</driver-class> | <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> | <user-name>myUsername</user-name> | <password>mypassword</password> | <min-pool-size>1</min-pool-size> | <max-pool-size>10</max-pool-size> | <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> | <metadata> | <type-mapping>PostgreSQL 8.0</type-mapping> | </metadata> | </local-tx-datasource> | | </datasources> | 4. changed server/default/conf/standardjboss-jdbc.xml so it reads: | <defaults> | <datasource>java:/PostgresDS</datasource> | <datasource-mapping>PostgreSQL 8.0</datasource-mapping> | | <create-table>true</create-table> | <remove-table>false</remove-table> | <read-only>false</read-only> | <read-time-out>300000</read-time-out> | <row-locking>false</row-locking> | <pk-constraint>true</pk-constraint> | <fk-constraint>false</fk-constraint> | <preferred-relation-mapping>foreign-key</preferred-relation-mapping> | <read-ahead> | <strategy>on-load</strategy> | <page-size>1000</page-size> | <eager-load-group>*</eager-load-group> | </read-ahead> | <list-cache-max>1000</list-cache-max> | <clean-read-ahead-on-load>false</clean-read-ahead-on-load> | | <unknown-pk> | <key-generator-factory>UUIDKeyGeneratorFactory</key-generator-factory> | <unknown-pk-class>java.lang.String</unknown-pk-class> | <jdbc-type>VARCHAR</jdbc-type> | <sql-type>VARCHAR(32)</sql-type> | </unknown-pk> | | <entity-command name="default"/> | <ql-compiler>org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler</ql-compiler> | <throw-runtime-exceptions>false</throw-runtime-exceptions> | </defaults> | 5. also changed the server/default/conf/standardjaws.xml | <jaws> | <datasource>java:/PostgresDS</datasource> | <type-mapping>PostgreSQL 8.0</type-mapping> | <debug>false</debug> | It still doesn't work, so i'm wondering if anyone can give me some pointers as to where it all goes to H*** Thanks.. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3907846#3907846 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3907846 ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today Register for a JBoss Training Course. Free Certification Exam for All Training Attendees Through End of 2005. For more info visit: http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
